Monthly reporting across a portfolio of clients

• The mapping lives in one person's workbook

  Whoever built the client's template knows which ledger feeds which head. When they are on another assignment, the month is late — and the reviewer cannot tell a mapping decision from a typing error.

• Every month repeats work that has not changed

  Ledger structure is stable between months. Re-keying the trial balance, re-checking the lookups and re-formatting the workbook is effort spent re-deriving something already known.

• A figure nobody can trace cannot be defended

  Pasted values survive until someone asks where a number came from in a client meeting. Then the answer has to be reconstructed from the raw file, if it still exists.

• Client data lives in email and shared drives

  Trial balances move by attachment and sit in inboxes. Under data-protection law that is the firm's exposure, not the client's.

• The mapping is a record, not a spreadsheet

  It belongs to the company, is versioned, and is reused every month. A new ledger is flagged for a decision; everything else carries forward untouched.

• A refresh on unchanged structure makes no AI calls

  That is a design guarantee with a test behind it, not a tuning target — which is why a monthly refresh costs a fraction of the first setup.

• Every figure carries its lineage

  Click a number in the dashboard and it shows the ledgers and vouchers behind it. Commentary never contains a written number: figures are computed and inserted through placeholders.

• Client files are encrypted, kept for you and opened by nobody

  Each client's files are encrypted under that company's own key, and nobody on our side has a way to open one. The AI receives redacted samples and ledger names, never a whole file.

For a CPA firm with a client accounting services practice, the monthly deliverable is the reporting package: income statement and balance sheet with comparatives, KPIs, A/R and A/P aging, and a short commentary. CAS reporting is where the margin of the service is won or lost, because the bookkeeping is already done and the package is rebuilt by hand for each client after the close.

Here each client is a company in one account, with its own mapping, history and encryption key. Upload the client's raw trial balance from QuickBooks, Xero or whatever they use, with the aging reports if you want them; the package comes back as an Excel workbook with live formulas — income statement with year to date, balance sheet summary, KPIs and aging — a dashboard and commentary, checked to tie to the trial balance. From the second month it is a refresh.

Indian CA firms that offer a monthly MIS usually receive a Tally export from each client and rebuild the same workbook from it: P&L and balance sheet in lakhs, against last month and the same month last year, ratios, debtors and creditors ageing, and commentary for the promoter. The firm's time goes on mapping ledgers that were mapped last month too.

Magic MIS keeps that mapping for each client company, reads the financial year from April by default (configurable per company), parses dates day-first and formats figures in lakhs and crores, or in absolute figures or millions if the client prefers. Each client's files are encrypted under that company's own key, nobody on our side can open one, and deleting a client's company destroys its key.

A bookkeeper's clients see the books as a set of reports exported from the ledger, which most owners do not open. Client reporting is the step after: a month's figures set out as a profit and loss, a balance sheet, cash and the handful of KPIs that matter, with sentences explaining what moved.

It is a service a bookkeeper can add without a new system. Upload the trial balance you closed, and the client gets a workbook and a dashboard you can present to them live, full screen, where every figure opens onto the ledgers it came from — so the question “where does that number come from?” is answered in the meeting. You pay per action from prepaid credits; there is no per-client subscription.

It is worth being direct about this, because the gaps matter more to a practice than the features.

There are no team logins or client portals, and none are planned — one account is one login. What a client can be sent is a read-only link to a copy of their board, frozen when the link is made, which expires and which you can withdraw; it opens no chat, file or workbook. There is no live connector to any accounting system: you take the raw reports and load the files. There is no scheduled refresh without someone uploading the month. There is no free tier or trial, so evaluating it means buying credits for a real month.

The professional judgement stays yours. The workbook is a prepared report to be reviewed and signed off, not an opinion — the commentary says what moved, and a reviewer decides what it means.