Most finance teams rely on spreadsheets for numbers that end up in the accounts. The controls around them should match that reliance.
Control a finance spreadsheet by separating inputs, calculations and outputs, locking formulas, adding check cells that prove totals agree, keeping one master version in a controlled folder, logging changes and recording a reviewer sign-off. Test for hard-coded numbers inside formulas and broken links before each use. Rank spreadsheets by risk and apply the strongest controls to the ones that feed the accounts.
List the spreadsheets that feed the accounts or important decisions: reconciliations, accrual calculations, depreciation, forecasts, commission and bonus calculations, consolidation workings. For each, record the owner, purpose, how often it is used and what it feeds. Rate each one high, medium or low risk based on the size of the numbers and how complex the file is. Spend your control effort on the high-risk files first.
Unlock the input cells, then protect the sheet so formula cells cannot be overwritten. Keep the password with the file owner, not on a sticky note in the file. Protection is not security, but it stops accidental overwrites, which cause most spreadsheet errors.
Every important spreadsheet should prove itself. Typical checks:
=IF(ROUND(SUM(Detail[Amount])-LedgerTotal,2)=0,"OK","CHECK")
Bring every check onto one summary cell at the top of the cover sheet:
=IF(COUNTIF(Checks,"CHECK")=0,"All checks OK","Checks failing: "&COUNTIF(Checks,"CHECK"))
where Checks is a named range holding every check cell. Using ROUND avoids tiny floating-point differences showing as failures. See fixing rounding differences.
Hard-coded numbers typed over formulas, or added inside them (such as =SUM(B2:B20)+1500), are a common source of errors.
=ISFORMULA(C5) in a helper column, or with conditional formatting, to highlight cells in a formula column that are not formulas.Use Data > Edit Links (or Workbook Links in newer versions) to see every external file the workbook depends on. Broken or out-of-date links mean the numbers may be stale. Prefer importing source data into an input sheet each period over live links to other people's files.
A reviewer should check the check cells, trace a sample of numbers back to source, read the outputs for reasonableness and then record their name and date. A review that leaves no evidence cannot be shown to an auditor. The reconciliation review checklist works for most spreadsheet reviews too.
Consider it when a file is very large, used by several people at once, broken often, or repeated in the same form every month for years. Until then, a well-controlled spreadsheet is a perfectly acceptable tool. The Excel vs accounting software guide helps with that decision for reconciliations.
The controls are the same in the UK and the US. US teams under SOX often call these "end-user computing" (EUC) controls and test them as part of the control framework. UK teams may use the same term or simply "spreadsheet controls".
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
A check cell that proves the spreadsheet agrees to its source, combined with a reviewer who looks at it. Most errors are caught by a total that does not agree.
No. Sheet protection stops accidental overwrites, but it is easy to remove. Use folder permissions to control who can open or change the file.
Show formulas with Ctrl + `, use Go To Special to select constants in calculation areas, and use ISFORMULA to highlight cells that should be formulas but are not.
Last updated 11 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.