Financial Solution Experts logoFinancial Solution ExpertsFinancial Statement Suite

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

LayerTechnology
FrontendNext.js 15, React 19, Tailwind CSS
BackendNext.js API Routes
DatabasePostgreSQL + Prisma
AuthNextAuth (credentials)
Excel ProcessingXLSX library
Word Generationdocx library