It’s a cry heard from finance teams everywhere: Why does this take so long?
If your team is managing to close the books on the past month within around five days, you’re likely to be running a pretty lean operation already – although you’d probably like the process to be shorter.
For many organisations, particularly smaller non-profits, a month-end close can run into weeks. In fact, plenty of teams have members who are occupied with month-end related tasks, and a lot of spreadsheets, pretty much all the time.
Smaller organisations might not bother with a month-end close at all, but for those of any size, it is a necessary procedure.
It is your opportunity to tie up loose ends, make sure you’re paying your bills and being paid and that things are not falling through the cracks.
But the bigger purpose of the exercise is providing clear financial information to inform business decisions.
It’s not always easy to remember that when you’re bogged down in the detail of a messy month-end. What’s more, the process can take so long that the information that comes out at the end is already out of date.
Finance teams will be familiar with the normal elements of a month-end process:
It is the time to review everything and ensure all transactions are recorded accurately and completely. It also involves getting to the bottom of any anomalies that might distort the picture – for example, transactions for a different month slipping into the accounts of the month in question.
But there are a host of factors that can hold matters up.
You might not have received all the expected invoices. It’s quite likely that you won’t have received all the invoices for goods or services ordered near the end of the month.
Sales might not have been finished. It’s possible your customers may not yet have been invoiced for goods that have been sent or services which have been done.
Purchase orders: The process of making sure all orders have been received and entered in the system, and that the corresponding sales invoices have come through, can be time-consuming.
Accruals and deferrals: It can be a complicated business to adjust the accounts to reflect payments already received for future goods and services – or for income earned but not yet received.
Expenses: Hardly anyone enjoys the admin of expenses claims, which is why staff tend to be slow to sign them off and line managers often don’t authorise them promptly. This all presents another barrier to closing the books in a timely manner.
Bank reconciliation: Checking the credits and debits in the bank statement against the cashbook in the finance system is a slow task if done in the traditional fashion.
VAT returns and other headaches: The complexity of quarterly VAT returns become part of many month-end closes, while in many sectors there is also the need to prepare figures for reporting to government or industry bodies.
Rekeying of information: If the finance system does not automatically pull in information from other business systems, such as the CRM (customer relations management) software, there can be a long and error-prone process of rekeying data.
Budgets and forecasts: Provide variance reports and analysis, collate up to date budget revisions. Get to the bottom of under/overs across the organisation and supply management with the figures for their area of the business.
Intercompany eliminations: If you’re doing the accounts for a group of companies, the process of stripping out transactions that have taken place between those companies – so as not to artificially inflate turnover – will be extremely laborious if done manually.
Fixed asset management: Most fixed assets depreciate in value month-on-month. Recalculating their value each month can be a frustratingly complex task and typically involves spreadsheets.
The key to achieving a quicker month-end close is to have software do more of the work and to manage these tasks on a continual basis i.e. not leaving everything until month end.
It’s here that you soon see the difference between basic accounting software and the kind that delivers the full range of features that are possible with cloud technology.
The best software will be able to do these things:
It’s easy to forget that there’s a reason month-end close is done – and it’s not to torment the finance team.
Apart from uncovering any problems, the object of the exercise is to produce reliable figures which the management team can use to make business decisions.
In fact, a lot of business decisions in any organisation might well be on hold until the numbers are available.
Yet in some organisations, the month-end process is so time-consuming that those figures are not in the hands of the management until two or three weeks after month-end, by which time they are already out of date.
Automating as many processes as possible can therefore make a big difference to the quality of decision making.
But as month end becomes less of an ordeal, it can become less significant.
With software to automate routine tasks and provide live up to date reporting and analysis throughout the period, there is no longer only one point each month when the books are accurate, reliable and current.
When leaders have access to complete financial data in real time, month-end can be just another day.