Match repair invoices with payments, refunds and credits

The short answer

To reconcile a repair shop account, list every document and every money movement for one vehicle and one period on its own row, then match each one in two directions. First, match charges: each invoice total should appear on the shop's statement exactly once. Second, match money: each payment, deposit, credit and refund should be tied to a specific invoice through a reference such as a receipt number, card authorization or check number. Do not rely on matching amounts alone. Add up your rows to rebuild the balance yourself and compare it with the statement's closing balance. Any difference that you cannot trace to a specific row is the item to take to the shop, along with the reference numbers and dates on both sides.

One condition changes the outcome more than any other. A payment the shop has received but not yet applied to an invoice, called an unapplied or pending payment, can make the statement look wrong even when nothing is missing. Leave those entries open until the shop confirms how it treated them. Do not count them as errors.

Terms you will see on shop paperwork

• Estimate: the proposed cost of the work before it is done. It is not a charge, so it does not belong in the balance.
• Repair order or work order: the record of work authorized and performed. The final version often becomes, or is attached to, the invoice.
• Invoice: the bill for completed work, with parts, labor, fees and tax. This is the charge you reconcile.
• Statement: a summary of the account over a period. It lists invoices, payments and credits along with opening and closing balances. An invoice that appears on a statement is the same charge, not a second one.
• Deposit: money paid before or during the job, often for parts. It reduces the balance only once the shop applies it to an invoice.
• Credit or credit memo: a reduction the shop grants against a charge, such as a goodwill discount or a returned part.
• Refund: money sent back to you. It undoes a payment or pays out a credit, so it raises the balance or uses up a credit.
• Reversal or void: a cancelled transaction, such as a declined card payment or a voided invoice.
• Posting date: the date the shop entered the transaction. It can differ from the date you paid.
• Allocation: which invoice a payment or credit was applied to.

Gather the records first

Pull together the shop statement or account history, every invoice in the period, your receipts, and your bank or card records showing each payment and refund. Find the previous statement as well, because its closing balance becomes your opening balance. If you approved extra work by phone or message, keep that record too. It explains why an invoice total may be higher than the original estimate.

Set up the reconciliation worksheet

Start with a header that defines the scope. Then add one row per transaction. Use a spreadsheet or plain paper. The layout below is a starting point you can copy and adjust.

ACCOUNT / CUSTOMER NAME:
VEHICLE (year, make, model, VIN or plate):
STATEMENT PERIOD:            to
CUTOFF DATE (last posting included):
OPENING BALANCE:             (from prior statement dated      )

Row | Type     | Doc no. | Txn ref   | Txn date | Posting date | Amount  | Applied to invoice | Effect on balance | Match status
----|----------|---------|-----------|----------|--------------|---------|--------------------|-------------------|-------------
1   | Invoice  |         |           |          |              |         |                    | +                 |
2   | Deposit  |         |           |          |              |         |                    | -                 |
3   | Credit   |         |           |          |              |         |                    | -                 |
4   | Payment  |         |           |          |              |         |                    | -                 |
5   | Refund   |         |           |          |              |         |                    | +                 |
6   | Reversal |         |           |          |              |         |                    | +/-               |

RECONSTRUCTED CLOSING BALANCE: opening + charges - payments - credits + refunds +/- reversals =
STATEMENT CLOSING BALANCE:
DIFFERENCE:
OPEN ITEMS FOR SHOP:

Fill in the match status column with a short code, such as Matched, Amount differs, Missing on statement, Missing from my records, Pending or Unapplied. Record the shop's balance effect separately from your own understanding. That way the worksheet shows where the two versions disagree.

Matching workflow, step by step

• 1. Confirm the opening balance against the previous statement. If it does not match, sort that out first, because every later figure inherits the error.
• 2. Match each invoice total to its line on the statement. Check the invoice number, date and total, including tax and shop fees. Look for duplicates, such as a revised invoice that was posted next to the original.
• 3. Match each payment to your bank or card record by reference number, not just by amount. Two payments of the same amount on different invoices are easy to cross.
• 4. Check that each deposit was applied. A deposit shown as received but not deducted from the final invoice is a common gap.
• 5. Add up split payments. If you paid partly by card and partly by cash or check, the parts should equal the amount the shop shows as applied.
• 6. Confirm each credit appears once and reduces the right invoice. A credit printed on the invoice and also listed separately on the statement may be counted twice, or it may be two different credits. The document numbers tell you which.
• 7. Track refunds on their own rows. For each one, note which charge, payment or credit it relates to. A refund alone does not prove that you still owe money or that the shop owes you more.
• 8. Account for reversals. A declined or reversed card payment brings the charge back. A voided invoice should disappear from the balance, along with any credit tied to it.
• 9. Watch the cutoff. A payment made just before the statement date may post in the next period. Mark it as a timing difference, not a missing payment.
• 10. Rebuild the closing balance from your rows and compare it with the statement. Note each unexplained difference as a specific amount with references.

Worked example (hypothetical figures)

The numbers below are made up to show the method. They do not come from a real shop account.

Item	Amount	Effect on balance
Invoice for repair	$900	+$900
Documented credit on that invoice	$50	-$50
Deposit applied to the invoice	$200	-$200
Final payment applied to the invoice	$650	-$650
Calculated balance		$0

Suppose the shop's statement applies only $600 of the final payment and shows $50 still owed. Your worksheet now has a $50 allocation discrepancy. Record your payment reference and date next to the shop's posting reference and posting date for the same payment. Then ask the shop for its transaction detail and an explanation. The $50 could be a payment split across another invoice, a fee you have not seen, or a posting error. The worksheet shows where the gap is. It does not show who caused it. Recheck your rebuilt closing balance against the statement, and keep the $50 as an open item until the shop's answer resolves it.

Common causes of a mismatch

• A deposit received but never applied to the final invoice.
• A payment applied to a different invoice or vehicle on the same account.
• A revised invoice posted next to the original instead of replacing it.
• A credit shown on the invoice but missing from the statement, or listed twice.
• A card payment that was reversed or declined after you left the shop.
• A refund issued against the wrong transaction.
• A timing difference, where a transaction posted after the statement cutoff.
• Added charges such as storage, diagnostic or supply fees that were not on the estimate.

Asking the shop to clarify

Send a short, specific request. Cover each open item in one or two lines: the amount, your reference and date, what the statement shows, and the question you need answered. For example: "Final payment of $650 on card, authorization ending 1234, dated March 3. Your statement shows $600 applied to invoice 4417. Where was the remaining $50 applied?" Ask for an itemized account history covering the period. Keep a copy of your worksheet and the shop's reply. Specific questions get faster answers than a general claim that the bill is wrong.

If the shop's answer does not resolve a card payment you think is wrong, and you are considering a dispute with your card issuer, check the issuer's terms first. Disputes have filing deadlines, so waiting for a slow reply can cost you that option.