Before choosing a new dashboard, ask two people to explain the same number. If they give different sources, periods or definitions, the first job is to agree the handover.
The short answer: month-end reporting rarely takes two days because the maths is hard. It takes two days because the same figure is collected from several places, argued about, and fixed by hand. Settle the definition, cut-off, codes and links before the report, not in it.
- 01 · DefinitionWhat the number means
Report Sales Defined
- IncludesWritten down
- ExcludesWritten down
- UnitWritten down
- DecisionWritten down
- 02 · Cut-offPeriod and cut-off
When do adjustments stop?Dates, time zone and cut-off
- 03 · SourceSource and owner
Report Source One record
- AuthoritativeOne record
- OwnerExplains a correction
- 04 · FreshnessHow fresh each source is
- Source refreshed
- Missing shows as a gap
- 05 · ReconcileTotals must agree
- References and totals agree
- Difference kept apart
- 06 · ExceptionWho owns a difference
Unresolved differenceOwner, review date, what to decide
At the end of the day Most of this is a decision and a line of writing, not new software.
The six questions in full, for one report figure
Choose a figure people question in a regular meeting. It might be open enquiries, completed work, available capacity or invoiced revenue. This is a working checklist, not a claim about your reporting time or data quality.
- Definition: What does the number include and exclude? Write the unit and the decision it supports.
- Period and cut-off: Which dates are included, in which time zone, and when do adjustments stop?
- Source and owner: Which record is authoritative? Who can explain a correction?
- Freshness: When was each source refreshed? Show missing or stale extracts instead of treating them as zero.
- Reconciliation: Which references and totals must agree? Keep a difference separate until it has been resolved.
- Exception: Who owns an unresolved difference, when is it reviewed and what can the team decide while it remains open?
Where the month-end reporting days go
A number with two meanings
Sales means invoiced to one person and completed to another. The meeting argues about which is on the page.
A cut-off nobody wrote down
Late invoices, bills and adjustments keep arriving after the month has ended.
Codes kept in two places
A business group or cost centre also lives in a spreadsheet, so every month starts with re-coding.
Job data through a link
If a mapping is wrong at the job end, the month-end report inherits it, and someone finds it late.
Four delays come up again and again. None of them is a software problem on its own. Each is fixed before the report, not in it. A dashboard on top of an undefined number, a moving cut-off or codes kept twice only shows the disagreement faster, and to more people.
What Xero and Simpro say about the cut-off, the codes and the link
- A cut-off nobody wrote down. Late invoices, late bills and adjustments keep arriving after the month has ended. In Xero, a lock date stops changes to transactions in a past period.2 Without one, last month’s figure can change after it has been reported.
- Codes kept in two places. Xero uses tracking categories and options instead of department codes or cost centres.1 If a business group or cost centre also lives in a spreadsheet, every month starts with re-coding.
- Job data that arrives through a link. Simpro’s accounting link shares accounts and tracking categories from Xero to Simpro, and invoices both ways.3 If a mapping is wrong at the job end, the month-end report inherits it, and someone finds it late.
Keep codes in one place
Tracking categories
Codes belong in one place: a second list in a spreadsheet means re-coding each month.
Source: Xero Central, Set up tracking categories and options (read 17 October 2026)
If Xero tracking categories hold your business groups, stop keeping a second list in a spreadsheet.1 A second list means every month starts with re-coding.
A sample handover
| Team | What it counts | Called | Agreed label |
|---|---|---|---|
| One team | Completed jobs | “Finished work” | Jobs completed |
| Another team | Invoices issued | “Finished work” | Invoices issued |
Sample data, not a client’s. Those are different measures, even if both are called “finished work”. Agree the labels before connecting the sources. A daily refresh cannot repair an undefined number.
A month-end checklist you can start this month
- List the five figures your management meeting actually uses. Leave the rest for later.
- Write one line for each: what it includes, which system it comes from, and who answers questions about it.
- Agree the cut-off day, and whether you set a lock date in your accounting software once the month is reported.
- Keep codes in one place. No second list in a spreadsheet.
- Pick one reconciliation that must agree before the report goes out, such as job software invoice totals against the accounts.
- Show gaps as gaps. A missing figure says “not available”, never zero.
- Name the reviewer. One person signs off the report before it is shared.
Most steps are a decision and a line of writing, not new software.
Where a person stays in charge
Gaps show as gaps
A figure that is not available shows as not available, never as zero.
A person signs off
One named reviewer signs off the report before it is shared.
Nothing goes out alone
Anything that goes to a customer, posts or pays waits for a person.
To start, write down the report, the disputed measure, its sources and the person who owns the next decision. Do not include private records when experimenting with an AI tool.
If your report is about what each job made, the job profitability report for Simpro and ServiceM8 follows the same steps for job margins. If you would like help working out which part of your month-end to fix first, start with a Workflow Audit. I review how your reporting works today, read-only, and give you a fixed quote for anything worth building.
Questions
Why does month-end reporting take two days?
Rarely because the maths is hard. The same figure is collected from several places, argued about and fixed by hand before anyone can use it.
Does a lock date in Xero help?
In Xero, a lock date stops changes to transactions in a past period.2 Without one, last month’s figure can change after it has been reported.
Should we buy a dashboard first?
Not first. A dashboard on top of an undefined number only shows the disagreement faster, and to more people. Agree the handover, then connect the sources.
Where do I start?
Pick one figure people question in a regular meeting and answer the six questions for it. Then work through the month-end checklist.
Sources
- 1. Xero Central, “Set up tracking categories and options”, read 17 October 2026: central.xero.com/s/article/Set-up-tracking-categories
- 2. Xero Central, “Set up or remove lock dates”, read 17 October 2026: central.xero.com/s/article/Set-up-and-work-with-lock-dates
- 3. Simpro listing, Xero App Store (Australia), read 17 October 2026: apps.xero.com/au/app/simpro
Not sure which to fix first?
Get a free fit check by email and I will say whether it is worth automating. No call needed. The next step is a A$990 workflow audit: the top 3 things worth automating, with a fixed quote for each.
Get a free fit check by email