Small business outsourcing workflow guide
Write a supplier statement reconciliation routine for a virtual bookkeeper
A supplier statement routine that matches invoices line by line, keeps credits visible, and closes the month with a signed variance note.

Key takeaways
- Match supplier statements to the ledger at the invoice level, never only at the total.
- Classify each difference before asking the supplier a question.
- Keep credits and disputed invoices visible instead of netting them away.
- Close with a variance note that names the cause, owner, and next date.
Collect the statement and the ledger extract together
Start by collecting the supplier statement and the accounts payable ledger extract for the same period. Record the statement date, the ledger cut-off, and the currency before comparing anything. A statement that ends on a different day than the ledger will always show a timing difference that is not an error. Keep both files together so a later reviewer can repeat the comparison.
Check that the statement belongs to the right supplier entity and the right bank account before matching. A statement from a parent company may include invoices that belong to a subsidiary, and a changed bank account may signal a fraud attempt. Confirm the supplier name, the remit-to address, and the account reference against the master record. Any mismatch is a reason to pause, not a detail to fix later.
Match at the invoice level, not the total
A matching total can hide a missing invoice and a duplicate payment at the same time. Match each statement line to an invoice, a credit, or a payment in the ledger. Record the invoice number, the date, the amount, and the match status. When a line cannot be matched, leave it unmatched rather than assigning it to the nearest amount. The detail is what makes the reconciliation useful.
Use the same key in both systems, and write down what the key is. If the supplier uses a different invoice number, record both numbers on the line. A key that changes between months makes the next reconciliation slower and the history harder to follow. The bookkeeper should be able to explain every matched pair without opening the supplier's portal.
Classify differences before chasing the supplier
Group the differences into timing, missing invoice, duplicate, price or quantity variance, credit not applied, and payment not allocated. Each category has a different next step and a different owner. A timing difference may need only a note, while a missing invoice needs a request to the supplier. Do not send a general query that asks the supplier to explain the whole balance.
For a price variance, compare the invoice with the purchase order and the receiving record before calling the supplier. The error may be in the order, the delivery, or the invoice, and each has a different fix. For a credit, check whether the credit note was received and whether it was applied to the right invoice. Record the evidence for the classification so the supplier conversation starts from a specific question.
Keep credits and disputed items visible
A credit that is expected but not received should stay on the reconciliation as an open item with an expected date. Do not net it against the balance and mark the account clean. The same applies to a disputed invoice: keep the full amount visible and record the part the business accepts. Netting a dispute into a single number makes it easy to pay something the business did not agree to.
Age the open items and assign a follow-up date to each one. An item that has been open for two cycles needs an owner decision, not another reminder. Record the supplier contact and the date of the last response. A reconciliation that shows only the current difference hides the items that have been waiting the longest.
Close with a signed-off variance note
End the reconciliation with the opening balance, the matched amount, the open differences, and the closing balance. Add a short note for each remaining difference that names the cause, the owner, and the next date. The note should be specific enough that the owner can approve the position without reading every line. Keep the statement and the ledger extract with the note.
Have a second person review the reconciliation before the payment run when the balance is material or the supplier is new. The reviewer should check the matching key, the open items, and the bank details rather than re-performing every line. Record the review date and the reviewer. A reconciliation is complete when the remaining differences are understood, not when the totals happen to agree.
Sources and next steps
- U.S. Small Business Administration, manage your business
- U.S. Government Accountability Office, internal control standards
- Association of Certified Fraud Examiners, fraud resources
- IRS, recordkeeping for small businesses
Compare this workflow with the small-business outsourcing service guides and bring a redacted source record to the scoping call.
Related guides
Set a weekly payroll hours exception review for a small-business assistant
A weekly payroll hours review that lets a small-business assistant catch missing approvals and disputed time before the pay run closes.
Prepare a quarterly certificate-of-insurance tracker for a small-business assistant
A certificate-of-insurance tracker that keeps policy dates, contract requirements, and renewal reminders in one reviewable place.