EXCELlent Business Intelligence logo
HUEN

XLNT Monthly Report (English)

Complete monthly financial reporting pack for accountants – in a single Excel file

One import, 24 finished report sheets and an MKVK AuditXML2 export. Turn a trial balance or itemised general ledger into statements, cash flow, aging, payment behaviour, VAT, liquidity analysis and a dashboard in Excel on your own machine, with no data connection or monthly fee.

Main features

  • 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.

Why it helps

One-time or annual licence – no monthly fee or per-report charge. Work in Excel on your own machine without a cloud connection, keep your data with you, and set up the row plan once for repeat monthly reporting. Office / multiple PCs: ask for a custom quote based on the number of users.

Detailed documentation is available in Hungarian: Hungarian product page.