Monthly financial reporting, without the spreadsheet rebuild

1. 1. Pull the raw trial balance

   From your accounting system, as Excel, CSV or PDF. Add the open invoices and open bills reports if you want A/R and A/P aging.

2. 2. Accounts are mapped for you

   Each account is matched to a line in the report automatically, and anything that cannot be placed is shown as Unmapped. Next month the mapping carries forward.

3. 3. Run it

   One button, paid from prepaid credits at the action's standard price.

4. 4. Send the package

   An Excel workbook with live formulas, a dashboard and written commentary on the month.

A monthly financial reporting package is what goes to the owner, the lender or the client once the books are closed: the financial statements for the month, the ratios and aging that explain them, and a page of commentary. The word “package” matters — it is one document, sent on the same day every month, rather than a set of reports exported separately and stapled together.

With Magic MIS the package is an Excel workbook with live formulas — income statement with year to date, balance sheet summary, KPIs and, where the open invoices and bills are loaded, A/R and A/P aging, checked to tie back to the trial balance — together with a dashboard and written commentary. Every figure on the dashboard opens onto the accounts it came from.

1. Summary. Five or six headline figures and the two or three sentences that matter most.
2. Income statement. The month, the same month last year and the year to date, from revenue down to net income.
3. Balance sheet. At the month end, beside the prior month end.
4. Cash flow. Opening cash, operating, investing and financing movements, closing cash.
5. KPIs. Gross and operating margin, days sales outstanding, days payable outstanding, the current ratio — each against the prior period.
6. A/R and A/P aging. Open balances by age, with the largest named.
7. Commentary. What moved, by how much and why — written against the figures, not restating them.

A board reads the same package from the top down and rarely past the second page, so the order changes rather than the content. The summary and the commentary come first, the KPIs next with their trend, and the full statements behind them for the director who wants to check a figure. Anything that needs a decision — a customer drifting past ninety days, cash running below a covenant — belongs in the first paragraph, not in a footnote to the aging.

In Magic MIS the board version is the dashboard, presented live from its own Present button, full screen. A director who asks where a number came from gets the answer in one click, because every figure opens the ledgers behind it.

Traceable figures. Every number in the package leads back to the accounts behind it.

Checked before delivery. The report must tie back to the trial balance you loaded.

No AI arithmetic. AI recognises files, proposes mappings and drafts commentary; a deterministic engine computes every figure.

Encrypted, and opened by nobody on our side. Files are encrypted under a key unique to each company, every opening is recorded where you can see it, and deleting the company destroys its key; customer and vendor names are redacted before anything is sent to the AI.