How to reconcile a vendor statement by hand

Gather the statement and the invoices

Get the statement for the period. Then pull every invoice and credit memo from that vendor dated in that period. That means emailed PDFs, counter tickets, priced delivery slips, and the folded one that came back from the truck. Pull last month’s reconciliation notes too; anything you held or carried forward will show up again.

Sort the invoices by invoice number. Statements run in number or date order, and matching goes faster when both piles do.

Tick off each statement line

Go down the statement one line at a time. For each line, find the invoice with the same number and check that the amount matches to the cent. If it does, tick both and move on. Everything without a tick at the bottom is the actual work.

Three rules keep the ticking honest.

• Match by number, then confirm by amount. Never match by amount alone. A parts counter can print two $87.50 tickets in one week.
• Watch for number formats. The statement says 0004512; your copy says 4512 or INV-4512. Same document if the amount matches. Tick it.
• Don’t skip ahead to the interesting lines. Every line gets looked at once.

What to do with each kind of leftover

You’ll end up with five kinds of leftovers. Each has a next step.

• Credit lines on the statement. A negative line for a return or a price adjustment. Match it to your credit memo or return receipt. If you don’t have one, note what it’s for and confirm it’s the credit you were promised, not a different one.
• Statement lines with no invoice. The vendor says you owe it; you have nothing. Usually a ticket still in the truck, or a delivery someone at the building signed for. Sometimes a keying error. If the number is one you already ticked, it’s listed twice; tell the vendor and hold the second line. Otherwise don’t pay it on faith: ask for a copy and hold the line until it arrives.
• Invoices not on the statement. You have paper the vendor hasn’t billed yet. Often it’s timing: it was cut on the 30th and will show next month. Carry it forward. The one to chase is a credit memo that isn’t there. A missing credit is money you lose quietly; nobody sends a reminder for it.
• Amounts that differ. Same number, different total. Usual causes: freight added after the pick ticket printed, a case price that changed between order and delivery, tax applied differently, or a return taken off one side and not the other. Compare the two documents line by line before deciding who’s right.
• Prior-period carry-forwards. Lines dated before this period. Check the statement date and last month’s sheet. If you paid it after the statement date, it’s in transit and will clear next month. If you paid it before, send the check number or payment reference. If you held it last month, it’s still held and goes to the top of the chase list.

A worked example

Say the August statement is from an HVAC supply house. Six lines, total $4,628.40. You have four invoices and one return receipt in the folder, plus last month’s sheet.

• Inv 22871, $612.00. Matches. Tick.
• Inv 22910, $1,240.75. Their copy has a $50.00 freight line; yours is the pick ticket printed before it shipped. Freight was in the quote, so you probably owe it, but your paper says $1,190.75. Ask for the final invoice with the freight line, file it, then tick.
• Inv 22958, $388.20. Nothing in the folder. Hold it and ask for a copy.
• Credit 1177, −$145.00. The condensate pump you returned. Matches the return receipt. Tick.
• Inv 23004, $2,222.45. Matches. Tick.
• Inv 22790, $310.00, dated July 28. Last month’s sheet says you paid it August 2, before the statement date. Send the remittance detail and don’t pay it again.
• Inv 23051, $96.10, dated August 29. In your folder, not on the statement. Carry it forward.
• Result: pay $2,689.45 (two ticked invoices less the credit). Hold $1,240.75 and $388.20 until the paper arrives. Query $310.00 as already paid. One item carried forward.

When to call the vendor

Call, or email and keep the email, in four cases: a line has no invoice behind it; an amount differs and the two documents don’t explain why; a promised credit hasn’t shown after a full statement cycle; a prior-period line you already paid is still there.

Don’t call about timing differences you can already explain. Have the invoice number, the date, your amount and theirs ready. Ask for a copy, not an argument; a copy settles the clerical ones. One call per vendor per month, with a list, not five as you find things.

Record the result

One sheet per vendor per month. Write the statement total, the amount you’re paying, each held line with its reason, and each carry-forward. Staple it to the statement.

Then pay what matched. Send a remittance listing the invoices you’re paying and the ones you’re holding, so their receivables clerk can apply it without guessing. Don’t pay the statement total and sort it out later. Later doesn’t come, and the overpayment becomes a credit you have to chase.

Next month, start from this sheet: held lines and carry-forwards first.

Doing it monthly without it eating a day

The by-hand method holds up if you stop treating it as a month-end event.

• Do it the day the statement lands. The invoices are fresh and the people who signed for deliveries still remember them.
• File invoices per vendor as they arrive, one folder or email label each. Sorting a mixed pile is the slow part.
• Get counter tickets and delivery slips turned in daily. The “no invoice” line you can prevent is the ticket still in a truck.
• Size the effort to the vendor. A landscaping yard with forty lines needs an hour; three lines need five minutes.
• Chase open items once, from the sheet, in one message per vendor.
• Keep ticking after three clean months. A careful vendor last month isn’t proof of this one.

How InvoiceAnchor handles this

InvoiceAnchor does the gathering and the ticking, with forwarding in place of the folder. Each invoice goes to a private Inbox address as it arrives (email, PDF, scan, phone photo, handwritten counter ticket) and waits under the vendor’s name. When that vendor’s statement comes in, it triggers a line-by-line match against the held invoices, amounts side by side. Clean matches queue for one-click approval. Each unmatched line carries one reason label: Statement credit, Invoice number format, Amounts differ, Not on the statement, Different month, or No invoice provided. Five of those are the leftovers above; Invoice number format is the 0004512-versus-4512 case from the ticking rules, shown with both numbers so you can compare. Add a late invoice and re-run the match; the re-run is free and never counts against your document allowance. Every reconciliation is kept permanently, downloads as one package (summary plus every source document), and your accountant can have read-only access. It’s invite-only right now.

Questions that come up