Financial Tax Report Generator
DB Realm Inc. (Internal)
Challenge
Needed Canadian tax reports generated automatically: 9 worksheets covering income categorization, HST/GST calculations, expense breakdowns, and annual summaries.
Solution
Built a Python tool using openpyxl that generates formatted 9-sheet Excel workbooks from Oracle financial data, with automatic tax calculations, cross-sheet formulas, and print-ready formatting.
Results
- ✓ 9-sheet Excel tax report generation
- ✓ Automated GST/HST/PST calculations
- ✓ Print-ready formatting with charts
- ✓ Replaces hours of manual spreadsheet work
The Financial Tax Report Generator handles the slowest part of Canadian tax preparation: pulling the financial data into the required report formats and calculating tax for each jurisdiction.