Stop Editing the Spreadsheet
A hand-kept workbook drifts away from the books a little every week. Rebuild it from the source each time and it has nowhere to drift.
Almost every small business has one. The cash flow workbook. The AR aging the owner tidies up before the bank meeting. The job cost tracker that started clean two years ago.
It began tied to the books. Then someone added a row by hand because the export was missing a job. Someone nudged a total so it matched the bank. Someone typed a number straight into a cell because pulling the report felt like a chore that afternoon. A year later nobody can tell the imported figures from the typed ones. It still opens. It adds up. It just isn't right anymore.
The workbook is a picture, not the record
The real record is the ledger: the transactions, the bills, the invoices. A workbook built from it is a picture of that record at one moment. Trouble starts when people treat the picture as the source and begin editing it.
The fix isn't more care while editing. It is not editing at all. Keep the inputs in one place, the books, and build the workbook fresh whenever you need it. When a figure comes out wrong, leave the cell alone. Correct the entry in the books and build it again.
What changes when you work this way
Two things happen, and both matter.
New items appear automatically. Create a job, customer or vendor in the books and it appears in every report built from them. Nobody has to remember to add a row.
Bad inputs get stopped at the door. A process that builds a report can refuse to finish when something doesn't tie: an account with no category, a bill with no vendor, a total that disagrees with the trial balance. Someone keeping a sheet up to date by hand tends to accept the odd number and carry on, since halting the whole report seems worse. Hand edits hide errors. A rebuild exposes them, and an exposed error is one you can correct.
Where this shows up in our work
Every report we hand over is generated from the books, not kept up alongside them. The aging comes from open invoices. The close package comes from the trial balance. If a number in a report looks wrong, the correction goes into the books and the report is rebuilt. The report and the ledger can't disagree, because one is made from the other.
So when a spreadsheet arrives that someone has faithfully updated for a year, we don't start by asking whether it is right. We ask what it is built from, and whether we can produce it straight from the books instead.
The takeaway: For any workbook you update by hand each month, find out whether it could be rebuilt straight from your books instead.
Want these checks running on your books?
We set this up on your books and your rules, and nothing posts without your approval.
Book a call