Who it's for: anyone preparing month-end reconciliations and schedules in a SaaS or tech finance team who would rather not rebuild them all in January for the auditors.
What you'll get: what makes a working paper "audit-ready", a standard layout, a folder structure, a monthly checklist, a worked example of a good accruals working paper, and a one-slide pitch for your boss.
Reading time: about 10 minutes. Best read with one of your current reconciliations open.
Why monthly working papers matter
A working paper is the evidence behind a number. If it is built properly every month, year-end is mostly a matter of handing over files. If it isn't, the audit turns into a scramble to remember what a balance was in March and why.
Good working papers also help the team itself: they make reviews faster, handovers easier and month-end less dependent on one person's memory. Auditors don't expect beautiful spreadsheets. They expect to follow your logic from the ledger to the evidence without having to ring you. They will ring you anyway, but less.
Key terms
- Working paper: a schedule, reconciliation or file that supports a balance or journal, with its evidence.
- Lead schedule: a summary that lists every ledger account in an area (for example, all accruals accounts) and links each to its working paper.
- Tick and tie: showing, with references, that each number agrees to a source: the ledger, a report or a document.
- PBC list ("prepared by client"): the list of documents and schedules the auditor asks you to provide.
- Audit trail: the ability to follow a number from the financial statements back to the source document, and the reverse.
- Preparer and reviewer sign-off: the names and dates showing who built the working paper and who checked it.
What "audit-ready" means
An audit-ready working paper answers six questions without anyone needing to ask:
| Question | Where the answer lives |
|---|---|
| What is this, and for which period? | Header: entity, account code and name, period end |
| Does it agree to the ledger? | Balance per trial balance vs balance per working paper, difference shown as nil |
| What makes up the balance? | A breakdown by item, customer, supplier or invoice |
| Where's the evidence? | A reference for each line to a source document, saved alongside |
| Who did it and who checked it? | Preparer and reviewer names and dates |
| Anything odd? | A short notes section: judgements, unusual items, follow-ups |
Step 1: set up a standard layout
Use the same layout for every balance sheet working paper. It makes review faster because the reviewer always knows where to look.
- Header: entity name, account code and name, period end, preparer, reviewer, dates.
- Agreement to ledger: balance per trial balance, balance per this working paper, difference (should be nil, or every item explained).
- Breakdown: the items that make up the balance, each with a reference to evidence.
- Roll-forward (where useful): opening balance, additions, releases or payments, closing balance.
- Notes: judgements, estimates, method, and anything to follow up next month.
- Evidence: attached or saved in the same folder with matching references (E1, E2 and so on).
AI shortcut: give an approved AI assistant one of your messier reconciliations and the six-part layout above, and ask it to restructure the spreadsheet into that layout without changing any numbers. Then check that every total still agrees to the original.
Step 2: set up a folder structure that mirrors the balance sheet
A common approach is one folder per month, with sub-folders numbered to follow the balance sheet order:
| Folder | Contents |
|---|---|
| 2026-10 / 00 Trial balance and lead schedules | Final trial balance, close checklist, lead schedules |
| 2026-10 / 10 Bank | Bank reconciliations, statements |
| 2026-10 / 20 Debtors and accrued income | Aged debtors, bad debt provision, accrued income |
| 2026-10 / 30 Prepayments | Prepayment schedule, invoices |
| 2026-10 / 40 Fixed assets | Fixed asset register, additions invoices, depreciation |
| 2026-10 / 50 Creditors and accruals | Aged creditors, accruals schedule, support |
| 2026-10 / 60 Deferred revenue | Deferred revenue roll-forward, billing system report |
| 2026-10 / 70 Tax and payroll | VAT, PAYE and pension control reconciliations |
| 2026-10 / 80 Equity and intercompany | Share capital, intercompany reconciliations |
| 2026-10 / 90 Journals | Manual journal listing and approvals |
Name files the same way every month, for example "2026-10 50 Accruals.xlsx". Searching for "50 Accruals" then finds every month in seconds.
Step 3: the monthly working paper checklist
| Task | What "done" looks like | |
|---|---|---|
| ☐ | Roll forward last month's working papers into this month's folder | Opening balances agree to last month's closing balances |
| ☐ | Update each working paper after the ledger is final | Balance per TB matches the final trial balance, not a draft |
| ☐ | Reference every line to evidence | No line without a reference; evidence saved in the folder |
| ☐ | Hard-code or save the source reports | Reports saved as PDF or values, not live links that change later |
| ☐ | Write notes on any judgement or estimate | Method and reason written down, in plain words |
| ☐ | Preparer signs off | Name and date in the header |
| ☐ | Reviewer checks and signs off | Name and date; review notes cleared |
| ☐ | Update the lead schedule | Every account in the area listed and linked to its working paper |
| ☐ | Lock the folder after close | Read-only or moved to an archive, so files can't change after sign-off |
AI shortcut: ask an approved AI assistant to compare this month's trial balance with your list of working papers and flag any balance sheet account that has a balance but no working paper, or a working paper that doesn't agree to the trial balance. It's a quick completeness check before review.
Worked example: an accruals working paper
Here's what an audit-ready accruals working paper looks like for MonthEndClub Co Ltd at 31 October.
Header: MonthEndClub Co Ltd · 2100 Accruals · Period end 31 October 2026 · Prepared: management accountant, 4 Nov · Reviewed: financial controller, 5 Nov
| Ref | Item | Basis | Evidence | £ |
|---|---|---|---|---|
| A1 | Cloud hosting, October | Usage dashboard at 31 Oct | E1: dashboard export | 18,500 |
| A2 | Audit fee, year to Dec 2026 | Engagement letter £24,000 ÷ 12 × 10 months | E2: engagement letter | 20,000 |
| A3 | Contractor: design agency, 12 days | 12 days × £500, confirmed by budget holder | E3: timesheet and email | 6,000 |
| A4 | Sales tool usage, October | Head of sales estimate | E4: email 31 Oct | 4,500 |
| A5 | Sales commission, October deals | Commission schedule | E5: commission calculation | 9,200 |
| Total per working paper | 58,200 | |||
| Balance per trial balance | TB 31 Oct | 58,200 | ||
| Difference | 0 |
Roll-forward:
| Accruals | £ |
|---|---|
| Opening balance, 30 September | 52,900 |
| Less: September accruals reversed on 1 October | (36,900) |
| Add: October accruals booked (A1, A3, A4, A5) | 38,200 |
| Add: audit fee accrual for October (£24,000 ÷ 12) | 2,000 |
| Closing balance, 31 October | 56,200 |
The roll-forward gives £56,200, but the breakdown and the trial balance both say £58,200. That £2,000 difference is exactly what a roll-forward is there to catch. The preparer investigates: the September opening balance of £52,900 included £18,000 of audit fee accrual (nine months at £2,000), and only £34,900 of September accruals were reversed, not £36,900. The roll-forward line was wrong, not the ledger. Corrected:
| Accruals | £ |
|---|---|
| Opening balance, 30 September (including £18,000 audit fee) | 52,900 |
| Less: September accruals reversed on 1 October (£52,900 − £18,000) | (34,900) |
| Add: October accruals booked (A1, A3, A4, A5) | 38,200 |
| Add: audit fee accrual for October | 2,000 |
| Closing balance, 31 October | 58,200 |
Check: A1 + A3 + A4 + A5 = £18,500 + £6,000 + £4,500 + £9,200 = £38,200. Audit fee £18,000 + £2,000 = £20,000 (A2). The roll-forward, the breakdown and the trial balance now all agree.
Notes: "A4 is an estimate; actual invoice to be compared in November and the difference noted. Audit fee accrued evenly over the year per engagement letter."
An auditor can follow every line to evidence, see who prepared and reviewed it, and see the method behind each estimate, without asking a single question.
Common mistakes and audit watch-outs
- Working papers that don't agree to the final ledger. Built on a draft trial balance, then late journals moved the balance.
- Live links to source data. A formula pulling from a live report shows today's number, not the month-end one. Save values or PDFs.
- Plugs and "unreconciled differences". A small unexplained difference every month adds up and attracts audit attention.
- Evidence saved somewhere else. "It's in someone's inbox" isn't an audit trail. Keep evidence in the same folder.
- No reviewer sign-off. A reconciliation nobody checked is a weaker control, and auditors will treat it that way.
- Editing files after sign-off. Changes after the close break the trail. Lock or archive the folder.
- AI-restructured files that changed numbers. When AI reformats a working paper, check every total against the original before saving it as final.
- Uploading working papers to unapproved AI tools. They often contain payroll, customer and supplier details. Only use company-approved tools.
Tools that can help
Excel and Google Sheets are where most working papers live, and a standard template does most of the work. Shared drives with version history help keep the trail intact. Close management and reconciliation tools, often connected to NetSuite, Xero or QuickBooks, can hold reconciliations with sign-offs and attachments in one place. Tools don't replace the process; the habit of referencing evidence and signing off every month is what makes a working paper audit-ready.
Take it to your boss: one slide
Audit-ready every month, not just in January
The problem: working papers are built differently by each person, evidence is scattered, and year-end means rebuilding months of support.
Three changes
- One template for every balance sheet working paper: header, agreement to ledger, breakdown, roll-forward, notes, evidence.
- One folder structure that mirrors the balance sheet, locked after each close.
- An AI completeness check each month: every balance has a working paper that agrees, reviewed by a person.
| Risk | Control |
|---|---|
| Balances without support | Lead schedule plus monthly completeness check |
| Files changed after close | Folder locked or archived after sign-off |
| Unchecked reconciliations | Reviewer sign-off required before close sign-off |
| AI error or data leak | Approved tools only; totals checked after any AI change |
How we'll measure it: share of balance sheet accounts with a signed-off working paper by Day 5, and number of auditor follow-up questions at year-end.
Rates, thresholds and rules in this guide
Figures were checked against the pages below in October 2026. They change regularly (often each April or at Budget time), and we can't guarantee they're still current or right for your situation. Always check the official page before relying on them.
- Running a limited company: company and accounting records (GOV.UK): keeping records for 6 years from the end of the financial year they relate to
Key takeaways
- A working paper is audit-ready when someone can follow it from ledger to evidence without asking you.
- Use one layout: header, agreement to ledger, breakdown, roll-forward, notes, evidence.
- Mirror the balance sheet in your folder structure and lock it after close.
- Roll-forwards catch errors that a simple breakdown can hide.
- Use AI for completeness checks and tidying; people check the numbers and sign off.
FAQs
Do auditors require a particular format?
Not usually. They need to see the balance agree to the ledger, the make-up of the balance and the evidence. A consistent, clear layout makes their testing quicker.
How long should we keep working papers?
UK companies have legal duties to keep accounting records, and HMRC has its own record-keeping rules for tax. Many teams keep working papers for at least six years. Check the current requirements on gov.uk for your situation.
Should every account have a working paper every month?
High-risk and high-value accounts typically do. Some teams prepare low-risk, low-movement accounts quarterly, as long as that's a documented decision.
Can AI prepare our working papers?
AI can restructure spreadsheets, check completeness and draft notes. A person still checks the numbers, confirms the evidence and signs off, and only company-approved AI tools are used for financial data.
What's the single most useful habit?
Saving the evidence in the same folder, with a reference on the line it supports, at the time you prepare the working paper.
Related guides
- Balance Sheet Reconciliations: What Good Looks Like
- Surviving Your First Audit: What to Prepare and When
- Year-End Close Checklist for SaaS Companies
- Spreadsheet Standards for Finance Teams
More in Reconciliations and Controls guides.
From the Club
Fully referenced, reviewed and signed off. The Team Mug · The Dad Hat
Join the Club. New guides, early access and members-only batches. Join here.
This guide is general information about common practice. It isn't tailored to any business, and standards, tax rules and figures change. Check your own circumstances, the latest rules and, where needed, a qualified professional before acting.
Last reviewed: October 2026.