In short

The monthly management pack is usually rebuilt by hand from the accounts, the CRM and a couple of spreadsheets. The improved process pulls the figures from each source, reconciles them, builds the pack and drafts commentary on what moved and why.

The finance lead or managing director reviews the numbers and the words and approves the pack before it goes to the directors. AI drafts commentary; it never sets a figure.

  • Sector Small and medium-sized businesses
  • Role Finance lead or managing director
  • Job Monthly management pack

The job today

In the first week of each month, the finance lead exports figures from the accounting software, the CRM and an operations spreadsheet, pastes them into a workbook, refreshes the charts and writes a page of commentary. The figures rarely agree first time, and the commentary is written late at night before the board meeting.

Where it breaks

  • Figures are copied between systems, so totals don't always reconcile.
  • Charts break when a new row or category appears.
  • Commentary is written in a rush, so it describes numbers rather than explaining them.
  • Only one person really knows how the workbook fits together.

The improved process, step by step

  1. Pull figures from each systemThe agreed figures are pulled from the accounts, CRM and operations data, read-only.
  2. Reconcile and compareTotals are reconciled across sources and compared with last month and budget. Differences are listed.
  3. Build the packThe pack is built in your usual format, with charts generated from the same figures.
  4. Draft the commentary AI preparesAn assistant drafts commentary on what moved and possible reasons, using only the figures and notes you provide. Each statement points to its figure.
  5. The finance lead approves A person approvesThe finance lead checks the figures, rewrites the commentary where needed and approves the pack.
  6. Circulate and archiveThe approved pack goes to the directors, and the figures, sources and approvals are archived.
Monthly management reporting for a small business: process diagramSteps: 1. Pull figures from each system; 2. Reconcile and compare; 3. Build the pack; 4. Draft the commentary (AI prepares); 5. The finance lead approves (a person approves); 6. Circulate and archive 01 RULES CHECK Pull figures from each system 02 RULES CHECK Reconcile and compare 03 Build the pack 04 AI PREPARES Draft the commentary 05 A PERSON APPROVES The finance lead approves 06 Circulate and archive
The process at a glance. Teal steps are prepared with AI help; the amber step is where a person approves.

Where a person must approve

A person approves

The finance lead or managing director approves the pack before it is circulated.

Any figure that failed reconciliation is resolved by a person, never smoothed over by the system.

The data boundary

  • The system has read-only access to the specific reports it needs in each system.
  • Commentary is drafted only from the figures and notes supplied, not from the internet.
  • Personal data about staff or customers is not needed and is left out.
  • Every run keeps a record of the figures used and who approved them.

Checklist before you start

  • We have a list of the figures in the pack and where each comes from.
  • We know how each source can be read (report, export or connection).
  • We have agreed what counts as a reconciliation failure.
  • We know who approves the pack and by when.
  • Last month's pack is available as a template.
  • We know who else should be able to run it if the finance lead is away.

This is an illustrative walkthrough of a common pattern. It is not a client case study, and the details will differ in your organisation.