A reporting pack should answer three questions fast: how did we do, why, and what happens next.
A month-end reporting pack usually contains a one-page summary, the profit and loss against budget and prior year, the balance sheet, cash flow and cash forecast, a short set of KPIs and written commentary on the main variances and risks. Build it from a signed-off trial balance, link every number to one data source, and check that totals agree before it is issued.
Every number in the pack should trace to a signed-off trial balance. A workable Excel structure:
Add the reporting line to the TB sheet with XLOOKUP in column D:
=XLOOKUP(A2,Mapping!A:A,Mapping!B:B,"UNMAPPED")
Then each line on the P&L is:
=SUMIFS(TB!C:C,TB!D:D,$A5)
with the reporting line name in column A of the report. Check for unmapped accounts every month:
=COUNTIF(TB!D:D,"UNMAPPED")
It must be zero, or new accounts are missing from the pack.
Build these as formula checks on a Checks sheet, each returning OK or an error, so nothing relies on memory.
Put the pack on your close checklist with a working-day deadline, and prepare as much as possible before period end: refresh the template, roll forward formulas and update budget figures. Draft commentary as soon as the trial balance is final. See how to shorten the month-end close.
UK teams usually say "management accounts" or "month-end pack"; US teams say "monthly financial package" or "flash report" for a short early version. Label the accounting framework and any non-standard measures so readers in both countries understand them.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
A summary, the profit and loss against budget and prior year, the balance sheet, cash flow and forecast, a few KPIs and written commentary on the main variances.
As short as it can be while answering how the month went, why and what comes next. Put detail in appendices.
Build it from one trial balance with a mapping table, use SUMIFS rather than typed numbers, and run formula checks before it's issued.
Last updated 28 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.