The finance manager at a community services organisation opens the month end file on Tuesday morning, expecting to send the board pack by Wednesday lunchtime. By Thursday it still is not out, because the accrued wages calculation had to be rebuilt, the grant schedule did not carry across cleanly, and one of the payroll exports changed shape again. The numbers come out right in the end, but nearly all of that time went into assembling the report rather than reading it.
That gap is the real cost of month end spreadsheets built by hand, and it repeats every month.
What month end spreadsheets cost an organisation
The cost of month end spreadsheets is the senior finance time they absorb before anybody reads a result. A hand-built accrued wages file or grant schedule can take hours to reconstruct, and each rebuild carries the chance of a dragged formula or a reference pointing at last month’s data. So the organisation pays twice: once for the hours, and again for the review that never happens.
For a not-for-profit, that missing review is the cost that reaches the board. A report nobody has had time to question still gets presented, and the questions surface later, in a funder’s acquittal, at audit, or in a budget conversation where the figures do not match what managers believed. By then the fix costs considerably more than the review would have.
There is also a cost you cannot put a number against. Finance staff who spend their month rebuilding files rarely get to do the work they were hired for, which is explaining what the numbers mean to the people making decisions with them.
Why month end spreadsheets get rebuilt every month
Nobody sets out to rebuild the same file twelve times a year. It happens because the inputs keep moving. Pay periods do not line up with calendar months, so the split between what has been paid and what has been earned changes each time.
Grant agreements start and finish mid-year, each with its own reporting requirements, and staff join, leave and change hours, so leave provisions shift. Meanwhile the exports from payroll and banking systems do not always arrive in the same shape, which is enough to make last month’s formulas point at the wrong columns.
Then there is ownership. Most of these files were built by one person for one purpose, and they have been patched ever since. That person knows which tabs matter and which ones are left over from two years ago, and nobody else does, so when they are on leave in January the close takes twice as long.
None of this is an argument against spreadsheets. They are flexible, everyone can use them, and for a one-off analysis they are the right tool. The trouble starts when a one-off becomes the monthly process and nobody revisits it.
The risk hiding inside a finished spreadsheet
A spreadsheet looks finished whether it is right or wrong, and that is what makes it risky as a monthly reporting tool. An error in a hand-built file is silent. A formula dragged one row short, a typed number sitting where a link used to be, a tab that was not updated after the last pay run: none of these announce themselves, and the report still totals, still balances to something, and still goes in the board pack.
There is usually no record of how the figure was reached, either. If the board asks in March how December’s accrued wages were calculated, the answer sits in somebody’s memory and a workbook with eleven tabs. Charities that report annually to the Australian Charities and Not-for-profits Commission (ACNC) need their working to stand up, and medium and large charities are generally required to use accrual accounting for those financial reports.
The risk also compounds. Once a figure has gone into a report, next month’s file starts from it, so a small error carried forward is far harder to find than the same error on the day it was made.
Accrued wages: a small calculation that eats an afternoon
Accrued wages make a good example because almost every organisation has them and almost nobody enjoys calculating them. Employees earn wages across a pay period, and if that period does not end on the last day of the month, part of what they have earned has not been paid at the reporting date. The organisation still owes it, so under accrual accounting the expense belongs in the month the work was done, not the month the payment leaves the bank.
Doing that properly means splitting the pay run by days, applying the right rates, dealing with overtime, allowances and leave taken in the period, then checking the result against the general ledger. For a small team it is mechanical work. For a larger one with several rosters and pay conditions, it is an afternoon, every month, before anyone has looked at a single result.
The accrual then has to be reversed and reconciled in the following month, which is where last month’s mistakes resurface. Two errors in a row in the same file are much harder to untangle than one.
Where AI fits into month end spreadsheets
Hopscotch has used AI to process financial reports and rapidly prepare calculations such as accrued wages, reducing manual spreadsheet work. That is how we have approached particular engagements, and it is a tool our accountants use and verify rather than something we hand over.
What the tool does
It reads the exported reports, pulls out the figures a calculation needs, and produces the working without someone rebuilding a template first. The time it gives back is assembly time, which is the part of the close that produces nothing on its own. The same thinking sits behind our wider systems work, including Xero-first setups and Power Query reporting, because every hour removed from assembly is an hour available for the result.
What the accountant still decides
Everything that matters. Whether the underlying data is right, whether pay items have been categorised correctly, whether the treatment suits the organisation’s circumstances, and whether the number makes sense against last month: those are judgement calls, and an experienced accountant makes them and verifies the output. AI shortens the build, but it does not shorten the review, and it should not.
Questions to ask about your own month end spreadsheets
If you are not the person running the close, you can still get a clear picture of how much rebuilding goes on. Ask your finance team:
- how many hours of the close go into building files, and how many into reviewing results.
- which calculations get rebuilt from scratch each month, and why.
- what happens to the close if the person who owns the files is away.
- where the working for last year’s accrued wages figure is kept.
- how many times a number has had to be corrected after the board pack went out.
- which steps could run the same way every month without someone assembling them.
You are not auditing anyone by asking. The answers show where the month is going, and they point at one step that would give back more time than all the others combined.
Moving from building to reviewing
A system replacement is rarely the first move. Start with the calculation that takes longest and ask whether it has to be built from zero each time. The template may have drifted and never been repaired, or the data leaves the payroll system in a form nobody designed a report around. Both are setup problems, and setup problems only have to be solved once.
Then give the close a shape it keeps. A steady month end rhythm with the same steps in the same order makes drift visible, because anything taking longer than it did last month stands out immediately. That visibility is what turns a close from an endurance exercise into a process you can improve.
Frequently asked questions about month end spreadsheets
Yes. Spreadsheets suit analysis and one-off work well. The difficulty is relying on hand-built files for a calculation you repeat every month, because the rebuilding absorbs time and errors travel forward.
Accrued wages are wages employees have earned at the reporting date but have not been paid, because the pay period does not end on the last day of the month. Under accrual accounting the expense belongs in the month the work was done.
Medium and large charities are generally required to use accrual accounting for their ACNC financial reports. Small charities can use cash or accrual accounting unless their governing document, a government requirement or a funding agreement says otherwise.
No. AI can prepare working from exported reports and cut assembly time, but an experienced accountant still checks the underlying data, decides the treatment and verifies the result.
A month end that ends with a proper review
If you change one thing this quarter, change the calculation that takes longest and is built from scratch every time. Write down the steps someone follows to produce it, and half of them will exist because of the way the data arrives. Fix that first, because it is the step that hands back enough time for the review the board papers deserve.
Hopscotch Accounting supports not-for-profits across Australia from Sutherland, NSW, either as an outsourced finance team or alongside the one you already have. We work on the systems and process behind the close so that reporting lands on time and the numbers can be questioned before they are presented.
If your close is taking days you do not have, we are glad to look at what is being rebuilt each month and why. You can Start a conversation.
