Monthly management accounts for every client, without rebuilding the pack

• Profit and loss for the month and the year to date. Set against last month, the same month last year and the budget where there is one.
• A balance sheet summary. Current assets and liabilities, working capital and cash at the month end.
• KPIs and ratios. Gross margin, debtor days, creditor days, the current ratio, and the few figures that matter most in that client's kind of business.
• Debtors and creditors ageing. Who owes the client what, for how long, and whom the client owes.
• Commentary. What moved this month, why, and what deserves the owner's attention.

The pack keeps the same shape from month to month, which is exactly what makes it worth taking off the spreadsheet. Each part, with a worked example and a template, is in the full breakdown.

Most of the hours in a monthly pack are not analysis. They go on three jobs that repeat for every client, every month:

• Re-mapping nominal codes. A client’s chart of accounts drifts: a new code for a new supplier, a renamed overhead, a bank account opened mid-year. Each has to land on the right report line again.
• Checking the trial balance ties. Debits against credits, the balance sheet against the profit carried into reserves, this month’s opening balances against last month’s closing ones.
• Rewriting the commentary. The same paragraphs updated by hand, with every figure retyped from the spreadsheet.

A new nominal code is the classic way a figure goes missing. Nobody adds it to the mapping, its balance falls outside every report line, and the pack still looks complete. The only sign is a trial balance that no longer agrees with the report, and that is the check most often skipped when the deadline is close.

1. Upload what the client already exports. The trial balance, and the ledgers if you have them, in Excel, CSV or a text PDF, from any accounting system. There is no connector to set up and nothing to install on the client’s side.
2. Confirm the ledger mapping once. Each account is placed on a report line by rules first, and by AI only where the rules cannot place it. You check the placing on the ledger map, change any you disagree with, and it is remembered for that client.
3. Refresh next month from the new trial balance. Accounts already placed are placed again from memory, so only new or changed codes need a look, and the year to date and the comparisons carry on from the months before.

The figures come from a calculation, not from the AI. When the commentary is drafted, the AI writes the words with blanks where the figures go, and the engine fills every blank from the calculated report. A draft that contains a number of its own is rejected rather than delivered. On the board, every figure opens to the ledgers behind it, so a reviewer can trace any line before the pack goes to the client.

Before anything is delivered, the trial balance is checked to tie and the statements to agree, and a problem a check finds in the client’s data is set out with the pack in plain words. No member of staff can open a file you upload, and every time one is opened is on a record you can see.

May 2026 for Larkfield Studio, an invented design studio: its board, and the first lines of the month’s commentary as Magic MIS wrote them, with every figure filled in by the engine.

Enlarge:

The board and the month's commentaryClose

Revenue from operations for May 2026 was £669,194.00, up £10,505.00 (1.6%) on last month but down £(230,235.00) (-25.6%) on the same month last year.

Direct costs were £122,173.00, a change of £(9,020.00) (-6.9%) on last month and £27,766.00 (29.4%) on last year.

Other operating expenses were £72,374.00, a change of £627.00 on last month and £11,231.00 (18.4%) on last year.

Give each client one workbook with the same six sheets, so a reviewer always knows where to look. If you need a reminder of what management accounts include, it is set out section by section.

• Summary: the headline figures and the two or three things the owner needs to know.
• Profit and loss: the month, the year to date, last year and the budget, in grouped lines.
• Balance sheet: current assets, current liabilities, working capital and cash.
• KPIs: the client’s handful of ratios, each with last month beside it.
• Ageing: debtors and creditors by 30, 60 and 90 days and over.
• Commentary: a short paragraph for each section above.

1. Paste each month’s trial balance into a raw-data tab, never over last month’s formulas.
2. Keep a mapping tab that tags every nominal code with its report line, and total the lines with SUMIF, so a new code shows up as untagged rather than vanishing.
3. Check that the trial balance nets to zero and that the balance sheet balances before anything else.
4. Write the commentary last, from the finished figures.

There is no subscription and no fee per client seat. You buy credits in prepaid packs and spend them per report: each action has a standard price in credits, shown before you press it. Purchased credits are valid for 12 months. Each company you keep has a monthly memory fee, which keeps its mapping and its months between one pack and the next. See the credit packs.