Use the top navigation bar to seamlessly explore different aspects of the financial dataset:
1. Trial Balance: Displays all general ledger accounts with debit, credit, and net closing balances.
Drill-down: Click any balance to open a modal window displaying all underlying journal lines for that account.
2. Period Table: A matrix displaying the balance of each general ledger account broken down across all periods (periods 0 through 12/13).
Click on any period amount to view the specific transactions booked in that period.
3. Process Matrix (PPM): Links all transactions to their respective business cycle (Sales, Purchases, Bank, Cash, Payroll, Depreciation, and Memorial).
Journal Mapping: The tool identifies journals automatically. Click ‘Map Journals’ to customize assignments. Mappings are cached in your local browser storage or can be exported/imported as .json files.
4. General Ledger: Complete journal ledger containing all transaction rows with journal ID, date, voucher number, invoice reference, amount, VAT code, party, and cost center. Every column features instant filter inputs and automatic pagination.
5. Business Partners: An overview of all customers and suppliers, including names, registration numbers, VAT IDs, and IBAN bank accounts. Click on any contact to filter all their associated transactions.
6. General Info: Header metadata from the audit file (company details, software version, fiscal year, reporting currency) and automated validation checks verifying that Debits equal Credits and match header control totals.
7. Financial Statements & Lead Schedules: Automatically groups the trial balance into Balance Sheet and Profit & Loss structures. Customize mappings and download full lead schedules to Excel (.xlsx).
8. Visual Dashboards: Dynamic charts visualizing accounts receivable, accounts payable, revenue, and expense trends across periods, updating in real time as you adjust category mappings.
9. Special Transactions & Audit Checks: Automated audit checks highlighting potential anomalies:
- Vouchers with debit/credit imbalances
- Potential duplicate purchase invoices (by invoice number or vendor/date/amount match)
- Direct cost postings originating from bank statements
- Conspicuous journal entries (memorial bookings on liquid assets, missing descriptions, round sums)