Customer and insurer overlap register
Trace each collection and approved allocation before correcting an apparent excess.
No signup. Enter reference codes, add records and download a CSV. Entries stay in the browser tab. Filled fields do not establish completion, approval or compliance.
| Invoice reference | Original collection reference | Payer role code | Gross collected amount | Approved invoice allocation | Correction decision reference | Responsible office role |
|---|---|---|---|---|---|---|
| Collision-invoice-example-3 | Insurer-payment-example | Insurer-role | 5000 | Review current accepted invoice | Bookkeeper-role | |
| Collision-invoice-example-3 | Customer-payment-example | Customer-role | 1500 | Review current accepted invoice | Bookkeeper-role |
- Starting records are fictional examples, not merchant evidence.
- Keep private documents and actual contacts in your approved business system. Use internal reference codes here.
- Missing required fields indicate an unresolved record. Filled fields do not prove authorization, completion, compatibility or compliance.
- Export to approved business storage. Browser edits are cleared on reload.
When insurer and customer payments overlap, reconstruct the invoice allocation before sending money back. Two deposits into the shop account do not prove which person should receive a refund. Match each collection to its original payer, invoice charges and provider reference. Resolve the commercial allocation, then use the actual processor’s refund procedure rather than returning money through whichever method is easiest.
Use with this guide
body-shop payment-mix guide
The body-shop payment-mix guide helps identify the distinct sources behind overlapping collections.
failed-refund exception tracker
Use the failed-refund exception tracker when the approved correction does not complete.
Browse the complete auto body guides and worksheets.
Rebuild the invoice from approved charge groups
Keep amounts for insurer-authorized work, accepted customer-pay work, the customer’s deductible and prior deposits to the shop account separate. Get current supporting records. A supplement or payer adjustment to a previous estimate may affect how much is allocated to each party. Don’t rely on the customer’s best estimate for the excess , use the current version of the invoice that both the estimator and bookkeeper are using to review the balance.
Leave disputed allocations for qualified review only. This tool is intended to identify what has been billed and collected, and record to what invoice payments have been applied. The agreements and requirements relating to the insurance coverage, ownership of proceeds, and who is entitled to reimbursement of expenses must be recorded in the approved system before any payment corrections are made. The body-shop payment-mix guide helps identify the distinct sources behind overlapping collections.
Trace each payment to its source
List the customer card collection, insurer remittance and any other payment separately. Retain the original provider or bank reference, collected amount, charge allocation and current correction status. A bank deposit alone might combine multiple invoices or have processing charges deducted. Compare the gross collection evidence with the invoice before labeling the net deposit an overpayment.
Use the overlap register to record the invoice, collection reference, payer role, gross collected amount, approved invoice allocation, correction decision and office owner. Use internal codes only. Do not put customer contact information, bank details or virtual-card credentials in the tool. Protected supporting documents belong in the controlled business system where the authorized reviewer can inspect them.
Calculate the excess without deciding the recipient
Consider a fictional invoice with an accepted total of $6,000. The shop has verified collections of $5,000 from an insurer and $1,500 from the customer, for $6,500 collected. The arithmetic indicates $500 above the accepted invoice total before other adjustments. It does not establish whether the customer, insurer or another party should receive the $500. The approved allocation decision must supply that answer.
Check whether any collection has already been reversed, refunded or disputed. A ledger showing the original $1,500 customer payment beside a completed $500 refund needs a different action from an untouched $1,500 collection. Preserve both references. Do not erase the original event to make the invoice appear balanced, because the bookkeeper still needs to trace the money through settlement.
Submit one approved correction and verify completion
Stripe’s refund guidance states a refund returns to the original payment method and uses the available merchant balance. It also distinguishes pending and failed requests. Those instructions describe Stripe, not every account. Ask your provider how to handle the actual original collection and retain the supported procedure. A pending refund should not trigger another cash or card reimbursement without an authorized review.
Record the refund or correction reference and inspect the final outcome. Update the invoice allocation from verified evidence, then reconcile the related payout or account debit. Tell the appropriate payer the status you have confirmed through the agreed channel. The result should be a traceable correction, not a mystery credit hiding in the next bank reconciliation or a second repayment issued because the first update was missed. Use the failed-refund exception tracker when the approved correction does not complete.
Sources for this section: Stripe: refund destinations, funding, statuses and failures
Primary sources
BlueFinch last reviewed these sources on October 4, 2026. Payment rules and state requirements can change.
Use this page for general business information. It is not legal, tax, or accounting advice.