Delivered by Financial Solution Experts.
Financial Statement ETL System
A web-based application that transforms raw accounting data into complete, auditable financial statements. Upload Excel files containing journal entries or trial balance data, and generate professional Balance Sheet, Profit & Loss, Cash Flow, and Equity statements in Word and Excel formats.
What It Does
Input: Excel files containing either:
- Raw journal entries (transaction-level: date, account number, debit, credit)
- Pre-aggregated trial balance data
Output: Professional financial documents:
- Trial Balance (Excel) - Aggregated debit/credit totals per account
- Balance Sheet (Word) - Assets, Liabilities, and Equity
- Profit & Loss Statement (Word) - Revenue, Expenses, and Net Profit
- Cash Flow Statement (Word) - Operating, Investing, Financing activities
- Statement of Changes in Equity (Word) - Capital, retained earnings, reserves movements
How It Works
Excel Upload → Validation & Parsing → Account Categorization → Aggregation & Calculations → Financial Statement Generation → Word Document (DOCX) + Excel Workbook (XLSX)
Key Features
Dual Input Modes
- Journal Mode: Raw transaction-level data (date, account, debit, credit)
- Trial Balance Mode: Pre-aggregated account balances
Intelligent Account Categorization
- 1010-1019 → Share Capital (Equity)
- 2100-2499 → Fixed Assets (Non-Current Assets)
- 2500-2999 → Current Assets
- 3000-3999 → Liabilities
- 4000-4999 → Revenue & Cost of Sales
- 5000+ → Expenses
Comparative Period Analysis
Current vs. previous period side-by-side comparison with automatic variance calculations.
Dynamic Financial Notes
Auto-generates footnotes with account-level detail, filtered by materiality thresholds.
Multi-Format Output
- DOCX: Professional financial statements using templates
- XLSX: Trial balance with multiple sheets
Tech Stack
| Layer | Technology |
|---|---|
| Frontend | Next.js 15, React 19, Tailwind CSS |
| Backend | Next.js API Routes |
| Database | PostgreSQL + Prisma |
| Auth | NextAuth (credentials) |
| Excel Processing | XLSX library |
| Word Generation | docx library |