3 spreadsheets every CFO should stop maintaining by hand

The spreadsheet that survives any system change

Almost every company this size has switched ERPs or CRMs at some point, and yet three spreadsheets survive each migration untouched. Nobody designed them on purpose. They appeared one at a time, each one patching a specific gap the official system did not cover well, and over time they became the mandatory step before closing the month or preparing the board pack.

These three spreadsheets share the same problem. They are not one off mistakes but manual work that repeats every month, every week, or every time someone asks for an updated figure. It is worth going through them one by one.

1. The consolidated month end spreadsheet

Each subsidiary or department sends its part of the close in a slightly different format, and someone on the finance team spends several days copying those figures into a shared template before the consolidated number can be signed off.

The problem is not only the time lost copying and pasting. Any last minute change in one subsidiary forces much of the process to be redone by hand, and the room for a copy paste mistake grows with every row that gets touched.

2. The cash flow forecast spreadsheet

The cash forecast usually lives in a sheet someone updates every week, matching the bank balance against expected receipts and payments, often requested by email from sales, from purchasing and from the bank separately.

When the forecast depends on gathering scattered data from several people, it always arrives later than the moment it is actually needed for a decision, for example before approving a large payment or negotiating a credit line.

3. The budget versus actual spreadsheet

Tracking budget against actual by department is usually built by emailing each department head and asking for their figures, each with their own judgment about what belongs in each line and what does not.

The result is a report that takes days to close and that, by the time it is finally ready, no longer helps correct the deviation within the same month. It only helps explain it afterwards.

What to do about it

None of these three spreadsheets disappears just because the company buys a new ERP. All three exist because they cover a real gap between systems that do not talk to each other, or between people working with different criteria, and that gap only closes by designing the process, not by switching tools.

I automate exactly this kind of financial reporting. The first meeting is one hour and free of charge, and it is there to go through together which of these three spreadsheets is costing you more time than you think.