Catch Up Bookkeeping Checklist Template
Three documents and three sheets, including the missing-documentation list ranked by the tax behind each line rather than by date.
Free download · No account needed
Missing Documentation List
[Business] — what is claimed with nothing behind it
Ranked by the tax behind each line rather than by date. Sorted by count this list is fuel and lunch receipts. Sorted by money it is a handful of invoices from a handful of suppliers, and those suppliers still hold the record.
| Rank | Month | Vendor | Category | Amount | Tax behind it | Cumulative | Reconstruction may serve |
|---|---|---|---|---|---|---|---|
| 1 | — | — | — | — | — | — | — |
| 2 | — | — | — | — | — | — | — |
| 3 | — | — | — | — | — | — | — |
| 4 | — | — | — | — | — | — | — |
| 5 | — | — | Meals | — | — | — | no, needs a contemporaneous record |
| 6 | — | — | Travel and lodging | — | — | — | no, needs a contemporaneous record |
The last column is the one that splits the work in two. Travel, meals, gifts and car expenses sit under a stricter standard, and the IRS guidance says outright that an amount you approximate or estimate is not deductible. Those lines are a decision to take once, not a chase to run.
Everything else wants documentary evidence, which a vendor statement or a duplicate invoice from the supplier's own portal usually satisfies. That half is worth working in order of the money.
Every page that ranks for this gives the same six steps. Gather the statements, connect the software, categorise every line by month, reconcile each account, check the result against last year's return, then set up a routine so it does not happen again. The sequence is right. It is also what a bookkeeper already knows, and it says nothing about which half of the work has to be finished by the payment deadline or what any of the missing paperwork is actually worth.
Bramblewood Tree Care, invented for this page, is eleven months behind across three accounts and 2,039 transaction lines. After every line had a category, the books looked finished. Measured against the statement ending balance instead, 24 of 33 account-months reconciled. The nine that did not were hiding transfers counted as costs, a bank feed that had re-imported itself, and deposits landing net of the processor's fee: $35,660 of overstated expense, which is $12,330 of tax.
None of that needed a receipt, which is the finding that sets the order. Reconciling changes the number you owe. Documentation decides whether a number already claimed survives a question, and it moves the amount by nothing. Since an extension defers the return and not the payment, the corrections go first and the drawer goes second. The tax deadline calendar prices what the April payment has to cover, and this pack produces the profit figure underneath it.
What's in the pack
Missing Documentation List sheet
Every expense line with no document behind it, ranked by the tax at risk rather than by date, with a running cumulative share so the point where the rest of the list stops mattering is visible on the page. On the worked example that is 147 items and $39,410, of which nine items carry 64 per cent. It is the sheet the catalog calls the actual blocker, and pricing it is what makes it workable.
Reconciliation Status sheet
One cell per account per month: statement ending balance, book balance, the difference, and a named cause wherever there is one. This is the progress measure in the space, because percent categorised reaches 100 while the books are still wrong. No difference is ever closed with a journal entry. It is explained or it stays open with the amount and the account named.
Transaction Register sheet
Every line from every account with its category, the vendor's real name rather than the payment processor's descriptor, and a confidence flag. A category assigned from a thin statement description is marked as a guess, which lets forty line-level questions collapse into six questions about six recurring vendors. Personal-card lines carrying business spending are marked rather than absorbed.
Catch-up Plan
The two passes with hours against each step and a date on each pass. Pass one runs entirely off statements already in hand and moves the tax number. Pass two waits on suppliers and moves it by nothing. The plan also names what is deliberately excluded, including the ongoing monthly routine, which is right to build and wrong to build in the same weeks as the payment. That routine becomes the owner financial dashboard once the books are current.
Category Guidance
The rules that make March and September agree with each other: where the small-tools threshold sits, when hire with an operator becomes a subcontractor, how owner draws and transfers are treated. It also carries the substantiation boundary, because that is what decides how a line gets worked six months later rather than how it gets labelled today.
Accountant Handover Note
Written to remove questions before they are asked. What was done and how far it got, every judgement made with its reasoning in a sentence, the missing-documentation list in its two halves, and an explicit list of what was deliberately not decided. A preparer who has to discover an open variance charges for the discovery. Which lines are profitable at all is a separate read, in profitability by job.
Eight prompts and one standing rule
The rule is that categorised is not reconciled, and it governs how progress is reported everywhere in the space. The prompts run the sequence: build the register from statements before categorising anything, reconcile month by month, then find the corrections that need no receipts. After that, price the missing documentation, split it by what can be reconstructed, and sequence the work against the payment date.
Missing-document chase automation
Groups the outstanding items by supplier rather than by date, so one request covers eleven months of a trade account instead of eleven requests covering one month each. It reports what has come back, what is still out and how long it has been out, and it leaves the non-estimable half alone, because that half is a decision and not a chase.
How it works
- 1
Send the statements, not the receipts
Every bank and card statement covering the backlog, including a personal account if business spending ran through it. The statements are the complete record and the drawer is a sample of it, which is why starting with the drawer is how catch-ups stall in week two. A sales export too, if there is one.
- 2
Reconcile before categorising anything
Build the register from the statements, then compare each account-month's book balance against its statement ending balance, oldest first. Report account-months reconciled against the total. That fraction is usually much worse than expected, and it reframes the job from a paperwork problem into an arithmetic one in the first hour.
- 3
Clear what needs no paperwork, then pay
Transfers between your own accounts categorised as expenses, duplicated feed imports, deposits landing net of a processor fee. Priced at your own marginal rate, these gave the worked example a $12,330 correction before a single receipt was found. The result is a profit figure the payment can rest on, and it feeds straight into the owner cash flow forecast.
- 4
Chase in order of the money, decide the rest
The documentation list ranked by tax at risk, worked from the top, with the estimable half batched by supplier. The non-estimable half gets a position taken on each line rather than an open question carried into the handover. Then the note that goes to whoever prepares the return.
Frequently asked questions
Can I just estimate the receipts I cannot find?
It depends entirely on the expense, which is why the list is split rather than sorted. Most business costs want documentary evidence such as a receipt, a cancelled cheque or a bill, so a vendor statement often serves. For travel, meals, gifts and car expenses the IRS says plainly that you cannot deduct amounts that you approximate or estimate.
I am filing an extension, so does the whole catch-up not have until October?
No, and this is the assumption that costs the most. The IRS is direct about it: make sure you pay any tax you owe by the April filing date. The extension is only for filing the return. So the work that changes the amount owed has a hard deadline and the work that does not can run past it.
Where does the 34.6 cents on the dollar come from?
A sole proprietor's deduction moves two taxes. Self-employment tax applies to 92.35 per cent of net earnings, at 12.4 per cent for Social Security plus 2.9 per cent for Medicare. One half of that is itself deductible, which claws part of the income tax back. At a 22 per cent bracket the two combine to 34.6.
My books are 100 per cent categorised. Is that not finished?
It is the most common false finish. Categorising asks whether a line has a label. Reconciling asks whether the account agrees with the bank, and only the second question catches a missing transaction, a duplicated one, or a transfer counted as a cost. On the worked example 33 of 33 were categorised and 24 reconciled.
I have not filed at all for some of these years. Does that change anything?
Yes, and it is worth knowing early. Record retention normally runs to the period of limitations, but the IRS is explicit that you should keep records indefinitely if you do not file a return. Unfiled years also need sequencing with whoever prepares them, because each year's closing positions open the next.
How long does eleven months actually take?
On the worked example, 32 hours for the pass that changes the tax number and 23 for the pass that does not, spread over six months and mostly spent waiting on suppliers. The expensive part is not the volume of lines. It is the nine account-months that will not reconcile and the reason each one will not.
Should I not just hand the whole box to a bookkeeper?
Often yes, and this makes that cheaper rather than replacing it. What a professional charges for is discovery: the unexplained variance, the judgement nobody wrote down, the forty questions. If admin time is the real constraint, the administrative workload audit prices your own hours against the alternative.
Find out which of your months actually reconcile
Download the blank pack as Word and CSV files, or open it in River, send the statements for every month you are behind, and get the reconciliation grid and the priced correction list back first.
Edit with AI