From trial balance to management accounts in five steps

You need the closing trial balance for the month, the year-to-date trial balance (or the opening balances, so the year to date can be worked out), and the same for the comparative periods: last month and the same month last year.

Check it balances to zero, that it is for the right dates, and that it includes zero-balance ledgers if your system can show them; otherwise a ledger that moves next month looks new.

This is the core of the job. Each ledger goes on one line of the report:

Do it once, keep it, and next month place only the ledgers that weren't there before. Most monthly errors come from a new ledger nobody placed. Place by meaning, not by account number, because ranges differ between systems and clients; use one standard set of lines for every client, so reports compare; note any odd choice ("director's car lease to admin overheads, agreed with the client"); and look again after the year end, when year-end journals open one-off ledgers.

Present grouped lines, not ledgers. Pembroke Joinery's April:

• The balance sheet balances.
• Profit for the period ties to the movement in retained earnings, after dividends.
• Cash agrees to the bank reconciliation.
• No ledger is left off the report.
• The comparatives use the same placing.

If a check fails, stop and fix it. Commentary on wrong numbers is worse than none.

Pick five or six KPIs that stay the same each month (gross margin, overheads as a share of revenue, EBITDA, cash, debtor days, and runway if it applies), then write commentary with the number, the comparison and the reason:

Revenue was £148,200, up £8,600 (6.2%) on April last year, from two kitchen fit-out contracts. Gross margin fell from 42.0% to 39.7% because timber prices rose after those jobs were quoted. EBITDA was £13,200, £2,600 lower than last year.

The first month takes longest, because the placing is new: an hour or two per company, depending on the chart of accounts. From the second month the job should shrink to exporting the new trial balance, placing any new ledgers, running the checks and writing the commentary. If month two takes as long as month one, the placing isn't being reused.

Magic MIS does steps two to four. Upload the trial balance export from any system; each ledger is placed once, by rules first and the AI only where the rules can't, and you check it on the ledger map. You get a checked Excel workbook with live formulas, a dashboard and drafted commentary, in which the AI writes only the words: every figure in a sentence is filled in by the calculation engine from the ledgers, and a person reviews it before it goes anywhere; next month the new trial balance refreshes it. The whole method is in the trial balance to management report guide, and it works in Excel too.