XLNT Monthly Report

One import, 24 finished report sheets and an audit export. Load the trial balance or itemised general ledger from your accounting software, press a button, and the workbook produces the balance sheet, income statement, cash flow, filterable trial balance, customer and supplier aging, payment behaviour analysis, bank and petty cash reports, VAT summary, member loan statement, financial analysis, cost anomalies, liquidity balance sheets, dashboard and notes-to-the-accounts detail sheets. Everything runs in Excel on your own machine, with no data connection or monthly fee.

The dashboard brings together eight key indicators, monthly domestic and export revenue, and the TOP 5 customers and suppliers. From ledger entries and the company details on the Settings sheet, the workbook also generates the Chamber of Hungarian Auditors' MKVK AuditXML2 (v1.0.23.0) export, validates its fields and writes a UTF-8 file without a BOM.

Fő funkciók

• Dashboard — eight key indicators, domestic and export revenue by month, and TOP 5 customers and suppliers from a single import.
• Balance sheet and income statement — Hungarian format A in simplified, annual and monthly versions, with reconciliation checks and unmapped-account warnings.
• Cash flow — Annex 7 structure with calculated, manual correction and total columns, plus a monthly breakdown reconciled to the actual change in cash.
• Trial balance — filterable account-class and group subtotals with expandable sections and AutoFilter.
• Customer and supplier aging — age-bucket summaries, partner matrices, TOP 10 largest and longest-overdue items, and full open-item lists.
• Payment behaviour — average delay, on-time payment rate, payment categories and problem-partner ratings for customers and suppliers.
• Bank, petty cash and VAT — account balances and monthly movements; negative cash alerts and a monthly VAT position broken down by rate.
• Member loans, financial analysis and cost anomalies — itemised loan movements, profit and liquidity ratios, monthly trends, outliers and missing recurring costs.
• Liquidity balance sheets — 4-, 5- and 7-level versions together with an automatic assessment and cash, quick and current ratios.
• Notes-to-the-accounts schedules — fixed asset roll-forward, equity movement, accruals and deferrals, and other receivables and payables.
• Import and customise — xlsx or csv from accounting software, editable row plans and account prefixes on the Settings sheet; a single macro refreshes the reports.
• MKVK AuditXML2 export — validated ledger data in UTF-8 format, ready for the Chamber of Hungarian Auditors' checker.