Multi-Client Financial Activity Platform
DB Realm Inc. (Internal)
Challenge
Needed a unified platform to track credit card transactions, bank activity, invoices, expenses, and rental property finances across multiple clients with automated tax calculations.
Solution
Built a 42-page Oracle APEX application with 17 FIN_* tables, 8 views, automated invoice extraction via n8n pipelines (135+ PDFs processed), multi-client billing with per-client rate history, and Canadian GST/HST/PST tax calculations.
Results
- ✓ 42 production APEX pages
- ✓ 135+ invoices auto-extracted from Google Drive
- ✓ 17 database tables with full audit trails
- ✓ Plaid API integration for automated bank sync
The Financial Activity Platform keeps the financial records for DB Realm Inc. and its clients in one Oracle APEX application: credit card reconciliation, bank transaction categorization, invoices, expenses and rental property accounting.
Invoices come in through an n8n pipeline. It has processed 135+ PDFs from Google Drive, parses each one with AI-assisted extraction, and loads the results into Oracle through staging tables, using bind variables throughout.
Bank accounts sync through the Plaid API. Canadian federal and provincial taxes (GST/HST/PST) are calculated from rate tables that can be changed without a code release.