A template gives you somewhere to put numbers. A control tells you when the numbers are wrong.
A free template gives you a layout to fill in. A control system tests what you enter, such as duplicates, unreconciled differences and missing evidence, counts the exceptions, and blocks sign-off until they are resolved, with preparer and reviewer recorded. A template is enough when someone experienced reviews it closely every time; a control system makes the checks happen even when they do not.
| Typical free template | Control system | |
|---|---|---|
| Layout for your data | Yes | Yes |
| Tests the data you enter | Rarely | Yes, on every entry |
| Counts exceptions | No | Yes, in one exception panel |
| Blocks sign-off while exceptions are open | No | Yes |
| Records preparer, reviewer and dates | Sometimes a blank box | Required fields |
| Worked example included | Sometimes | Yes |
| Tested against planted errors | Rarely | Should be |
Most finance errors are not hidden. They sit in the spreadsheet, visible to anyone who looks: a reconciliation difference carried forward, an invoice keyed twice, a balance marked reconciled with no evidence. Templates rely on someone looking every time. Controls make the check happen, and make it impossible to finish without dealing with it.
One detail matters more than it sounds: count exceptions by occurrence, not by net value. Two errors of +500 and −500 net to zero and look clean; counted as two exceptions, they are caught.
Many good free templates exist, including our own free tools. Use them.
Plant errors in a copy: a duplicate invoice, a broken formula, a missing date, a balance that does not reconcile. If the file does not flag each one, it is a template, whatever it is called. See how to find duplicate invoices in Excel for one test you can add to any file.
The distinction is the same in the UK and the US. For US public companies, spreadsheets used in financial reporting are often treated as end-user computing controls and need their own testing, which is much easier when the controls are built into the file.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
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.
Partly. Add tests that flag problems, an exception count and a sign-off cell that only shows complete when the count is zero. Then test it with planted errors to check it works.
No. Tests, exception counts and sign-off gates can be built with ordinary formulas, which also makes the file safer to open and easier to audit.
Clear instructions, a worked example, protected formulas, and at least one check that the totals agree, such as a reconciliation difference that must be zero. If it has none of these, treat it as a blank form.
No. Accounting software records transactions. A control system checks that a process around them, such as a reconciliation or a payment run, has been done correctly and reviewed.
Last updated 18 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.