ReceiptTrack
A month-end invoice reconciliation checklist for a small business
Choose a review date, check sales and purchases against their sources, match recorded payments to the documents they settle and list unresolved differences. Review accounting posts separately. Reconciliation should explain balances, not force every invoice to zero. Turn a monthly review into a repeatable check of source documents, allocations and open questions, rather than a rush to make every balance disappear.
Month-end does not need to mean rebuilding the whole month from memory. A focused review can answer a smaller set of questions: what did we invoice, what do we owe, what money actually moved and which items still need attention? The aim is a traceable position at a chosen date, including honest exceptions.
Quick answer
Choose a review date, check sales and purchases against their sources, match recorded payments to the documents they settle and list unresolved differences. Review accounting posts separately. Reconciliation should explain balances, not force every invoice to zero.
Choose the boundary of the review
Write down the period and review date before working through the lists. A payment received on the first day of the following month can explain why an invoice was outstanding at the previous month-end. Do not change the real payment date to make an earlier report look settled. Keep a brief note if your review includes later information.
Choose the correct business workspace and gather the relevant issued sales documents, approved supplier bills, payment register and source evidence. GOV.UK requires self-employed businesses to keep income and expense records. The practical review described here helps you organise those records; it does not decide which accounting or tax treatment applies to your business.
Review sales without confusing drafts and issued work
Start with issued invoices and their supporting documents. Check customer identity, references, dates and totals. Keep drafts and quotes separate from the list of amounts you are asking customers to pay. A draft left over from an abandoned job should not make your receivable position appear larger.
Look at outstanding balances and ask whether each is explained. An invoice may be legitimately unpaid because its due date has not arrived. Another may be disputed, partly paid or waiting for a payment allocation. These situations need different next actions. Chasing every non-zero balance with the same message can create unnecessary confusion.
Review any full credit notes and related corrections with their source records. A credit changes the commercial record; it is not on its own proof that a refund was sent. Where the correct treatment is unclear, preserve the evidence and include the question in the handoff rather than changing dates or amounts to produce a preferred result.
Review supplier bills and duplicate evidence
For purchases, check that the bill represents a genuine supplier document and that the proposed supplier match was reviewed. Compare the reference, dates, lines and total with the original PDF or image. A scan marked needs review has not completed that check. An approved bill is a checked document, not a statement that it has been paid.
Look for duplicate entries, missing documents and credits requiring attention. A supplier statement can help identify a missing invoice, but it should not automatically become an additional purchase alongside the invoices already recorded. Ask for the missing evidence where necessary and keep the question visible until resolved.
Take particular care with a receipt uploaded through a supplier invoice workflow. The record should reflect the source and the real process, not simply whichever upload button was easiest to find. ReceiptTrack keeps receipt capture and supplier bill review distinct, so use the relevant tutorial when deciding where an item belongs.
Explain payments and allocations
Compare the recorded payments with the evidence of actual money movement. Check direction, date, amount and reference. Recording that a payment was made does not send money, and an invoice status does not replace bank or other payment evidence. Investigate missing or duplicated payment records before changing document balances.
A single payment may settle part of an invoice or be split across supported documents. Work from the actual payment and account for its allocations. The allocated total must not exceed the money recorded. Any remainder should stay visible until you know where it belongs. Similar amounts or customer names are clues for review, not sufficient authority for an automatic match.
For example, if a fictional business records a £500 payment and allocates £300 to one invoice and £150 to another, £50 remains unallocated. Do not invent a £50 sale to remove the remainder. Check the references and underlying documents, then either make the supported correct allocation or keep the difference on the exception list.
| Finding | Next check | Evidence to keep |
|---|---|---|
| Invoice outstanding | Due date, dispute or missing allocation | Invoice and customer reference |
| Unallocated payment | Payer, date and matching documents | Payment evidence and allocation history |
| Possible duplicate bill | Supplier reference and original source | Both records and review decision |
| Posting question | Accounting policy and source status | Candidate or posted-record link |
Check posts separately and hand over the questions
After the operational review, check which records were explicitly posted into Income or Expenses and which remain candidates. In ReceiptTrack, an allocation and an accounting post are separate actions. Confirm the source link before manually entering anything that could duplicate an existing post. A reimbursed mileage claim provides a posting preview only; it should not be treated as proof that an expense was created.
Prepare the handoff around documents and unresolved questions, not just a total. Include the review date, explained outstanding amounts and the evidence needed for each exception. Use existing supported reports and exports where appropriate; do not assume every Business Hub screen has its own export or that downloading an operational PDF submits a tax return.
- Owners reviewing invoices without a finance team
- Sole traders preparing an accountant handoff
- Businesses with partial or unallocated payments
Your repeatable monthly review
- Record the workspace, period and review date.
- Separate quotes/drafts from issued invoices.
- Review supplier evidence and duplicate decisions.
- Match actual payments and check remaining allocations.
- Explain open balances instead of forcing them to zero.
- Verify explicit posts and preserve source links.
- Give unresolved questions an owner and next action.
Finish with a position you can explain
A useful month-end review leaves a clear trail: what was checked, what remains outstanding and which questions still need an answer. Repeat the same steps next month and improve the evidence as you go. For the actual product controls, use the Business Hub payments, purchases and posting tutorials. The checklist supports record organisation, not a guarantee of accounting or tax compliance.
Sources
- GOV.UK: what an invoice must include
- GOV.UK: business records if you are self-employed
- ReceiptTrack Business Hub workflow tutorials
Related guides
- Quote, invoice, payment and receipt: how the records fit together
- How to prepare your records for an accountant
- Late payments: how small businesses can get paid faster
Key takeaways
- An unpaid invoice can be correct.
- An unallocated payment needs investigation, not duplication.
- A monthly review is not a tax return or an automatic accounting close.