Xeneural
BlogManagement

Closing the month without spreadsheets

The close does not run late for lack of effort. It runs late because the information lives in different places and somebody has to bring it together by hand.

Office tower at sunset

In almost any company under two hundred people, the monthly close looks the same: a week of gathering, two days of reconciling and an afternoon of explaining why the final number does not match the one somebody saw last week.

The cause is rarely the accounting. It is the geography of the information.

A slow close is a symptom, not a disease

When sales live in one system, purchases in another, payroll in a shared sheet and adjustments in somebody's email, the close is not an accounting process: it is a transport process. More time goes to moving data between files than to interpreting it.

That transport has a cost almost nobody measures: every copy is an opportunity for error, and every error found late forces you to redo everything that came after. That is why the close does not improve by hiring someone faster. It improves by removing transfer steps.

An entry born from the operation

The alternative is that the accounting entry is not written at the end but produced at the moment the operation happens. An issued sale generates its entry. A received purchase generates its own. The calculated payroll generates its own. Nobody transcribes anything, because there is nothing to transcribe.

The practical effect is not that the close is faster. It is that it stops existing as an event. The financial statements can be looked at on the twelfth of the month with the same confidence as on the thirtieth, because what you see is the current state and not the result of a pending consolidation.

What remains is the work of judgment: reviewing provisions, deciding adjustments, explaining deviations. That work is the valuable one, and it is the one that usually gets crushed under transport work.

The case of several companies

The problem multiplies when the group has more than one organization. Each closes on its own, somebody receives three files with similar but not identical structures, and consolidation is done with formulas only their author understands.

Consolidating well requires three unspectacular things: that all organizations use the same chart of accounts or a mappable one, that they share the same date cutoff, and that currency conversion follows a written rule and not the judgment of the day. With that, consolidation is a query. Without it, it is a negotiation.

What it takes to get there

The leap is not technological, it is a matter of order: a cutoff date instead of migrating the full history, catalogs unified before anything else, no figure corrected at the destination, and a period that is truly closed, with a lock. That last step is the one that meets the most resistance and helps the most: a closed month stops being argued about.

The exact order, with what to review at each step, is in the first monthly close guide. Read the first monthly close guide

Where a spreadsheet is still the right tool

In one off analysis, in simulating a scenario, in exploring an idea that is still taking shape. There the spreadsheet is unbeatable and should not be taken away.

The problem starts when it stops being an analysis tool and becomes the system of record. The sign is easy to recognize: if somebody asks which version of the file is the good one, the spreadsheet is no longer helping.

ShareLink copied