The true cost of spreadsheet accounting

Where the money actually goes

Ask an owner what bookkeeping costs and they quote the accountant’s fee. The real cost is larger and never invoiced: the reconciliation skipped each year, the hours after every month end spent proving to the bank that the figures are fine, the evening before each BAS deadline. None of this appears in any ledger.

The arithmetic of small errors

Manual data entry produces errors at a low, steady rate that compounds. One percent of entries carrying a small error is invisible in a week’s figures and awkward in a quarter’s. Spreadsheet errors cluster in the formulas, maintained by the one person who understands them, never independently checked. When that person is on leave, the organisation has no independent check.

What the hours cost

Manual bookkeeping has a measurable cost: the hours spent reconciling, correcting and proving figures. A ledger records the same transactions with an audit trail and automated reconciliation.

What to do about it, whatever you buy

First, measure: have the person who closes the month log their hours for one cycle, without polishing the numbers. Second, separate the two jobs spreadsheets fuse — recording transactions (which software should do) and explaining them (which humans should). Third, insist on drill-down: any figure you are shown should open to its source entry in two clicks. These three habits are why our ledger was designed the way it was — and they are worth adopting even if you buy somebody else’s software.

When a spreadsheet is enough

A spreadsheet is the right tool for a small operation: a sole trader, a club with forty transactions a month, or a single bookkeeper who owns the file. The argument changes when the same numbers are entered twice, when more than one person shares the file, or when a statutory deadline depends on a formula nobody else can read.

Questions this view raises