Reconcile one glass invoice by payer
Use the latest invoice and confirmed payment responsibility. Amounts received must refer to this same invoice, before payment-processing fees.
No signup. The interactive tool runs in your browser tab. Change the inputs, save a comparison, download the results, or print a working copy. Your entered numbers are not sent to BlueFinch.
Illustrative example inputs
Starting values demonstrate the math. These are not industry averages, a customer result, or a quote.
| Input | Example value |
|---|---|
| Final invoice total | $1,500.00 |
| Confirmed customer responsibility | $500.00 |
| Confirmed insurer responsibility | $1,000.00 |
| Confirmed other-payer responsibility | $0.00 |
| Customer receipts applied | $200.00 |
| Insurer receipts applied | $800.00 |
| Other-payer receipts applied | $0.00 |
Example results
| Measure | Result |
|---|---|
| Invoice balance after all receipts | $500.00 |
| Customer balance / excess receipt | $300.00 |
| Insurer balance / excess receipt | $200.00 |
| Unassigned amount / over-assignment | $0.00 |
Calculation detail
| Measure | Result |
|---|---|
| Invoice total | $1,500.00 |
| Customer responsibility entered | $500.00 |
| Insurer responsibility entered | $1,000.00 |
| Other payer responsibility entered | $0.00 |
| Total assigned | $1,500.00 |
| Customer receipts | $200.00 |
| Insurer receipts | $800.00 |
| Other payer receipts | $0.00 |
| Total receipts | $1,000.00 |
| Other payer balance / excess receipt | $0.00 |
| Assigned balances after receipts | $500.00 |
Model assumptions
- Defaults are a fictional example. No deductible, coverage or payer amount is inferred.
- Use one invoice version and a consistent tax basis. This worksheet is not an insurance coverage determination.
- Receipts are gross applied payments before card fees. Payment fees belong in the shop's expense records.
- Negative payer balances and over-assignment remain visible for review. They are not automatic refunds or permission to rebill.
Read alongside these results
- Enter payer amounts only after responsibility has been confirmed. This tool does not determine insurance coverage, deductibles or reimbursement rights.
- Receipts are gross amounts applied to this invoice before processing fees. A processor fee does not create a new customer or insurer balance.
- Negative payer balances identify an excess receipt or an allocation error to review. They do not authorize a refund automatically.
- Use the same invoice version and currency throughout. Include tax consistently in the invoice and assigned payer totals.
Download this worked example (CSV). The interactive version also exports your own inputs and results.
Download infographic (PNG) · Download vector (SVG) · Link to the source and methodology
The short version
- Enter confirmed payer responsibility instead of assuming the insurer pays the remainder.
- Gross receipts satisfy invoice amounts before processor fees.
- Keep an unassigned amount visible until responsibility is resolved.
The customer paid part of the glass invoice. An insurer remittance arrived later. The office still needs to know whether the unpaid amount belongs to the customer, the insurer or an unresolved approval. One invoice balance is not enough to answer that question.
This calculator reconciles the final invoice with assigned payer amounts and actual receipts. It does not calculate insurance coverage or automatically assign a deductible. Start with the confirmed records for the specific repair, then enter the amounts.
Use with this guide
Fleet invoice checklist
Review the payer, PO, approval record and invoice handoff.
Confirm responsibility before entering the split
Safelite's coverage FAQ directs customers to confirm their specific policy and deductible with their insurer. Use the same discipline in the billing file: record the payer decision for the actual job instead of treating a familiar deductible as proof of coverage.
Enter the amount assigned to the customer, the insurer and any other payer. Leave an unresolved supplement or unapproved item in the unassigned amount until the responsibility is established. The calculator deliberately does not fill the insurer field from the invoice remainder. That would hide a missing payer decision.
Sources for this section: Safelite: insurance coverage and claims questions
Worked example: $500 still open across two payers
The fictional invoice totals $1,500. Confirmed responsibility is $500 for the customer and $1,000 for the insurer. The shop has applied a $200 customer payment and an $800 insurer receipt. Total receipts are $1,000, leaving a $500 invoice balance.
That $500 is made up of a $300 customer balance and a $200 insurer balance. All responsibility is assigned. If the insurer amount were only $900 while the customer amount stayed $500, the worksheet would show $100 unassigned instead of silently transferring it to the customer.
| Payer | Assigned | Received | Balance |
|---|---|---|---|
| Customer | $500 | $200 | $300 |
| Insurer | $1,000 | $800 | $200 |
| Other | $0 | $0 | $0 |
| Total | $1,500 | $1,000 | $500 |
Keep payment fees outside the payer balance
A $200 customer card payment is a $200 applied receipt even if the processor deposits less after fees. Entering only the net deposit would make the customer appear to owe the shop's processing cost again. Record fees separately and reconcile the gross payment to the bank deposit in your payment records.
Use the current invoice version when calibration or another approved service changes the total. California BAR's windshield estimate guidance includes identifying OEM or non-OEM glass and the period the installation prevents vehicle operation. This is a state-specific documentation example, not a coverage rule or a substitute for current job requirements.
Sources for this section: California Bureau of Automotive Repair: Write It Right
Use exception amounts to locate the missing record
A negative unassigned amount means the entered responsibilities add up to more than the invoice. A negative customer or insurer balance means that payer's receipts exceed its assigned amount. Check duplicated receipt applications, the invoice version and the recorded payer approval before moving money.
The tool identifies the arithmetic difference. It cannot decide who owes a disputed supplement, whether a refund is due or whether an insurer will approve calibration. Keep those decisions linked to the applicable agreement, approval and service records in your own system.
Questions business owners ask
Does this calculate the customer's deductible?
No. Enter confirmed customer responsibility from the specific claim and agreement. The calculator does not read a policy or assume coverage.
Should I enter a net bank deposit as the receipt?
Use the gross payment applied to the invoice before processing fees. Otherwise a fee could appear incorrectly as an unpaid payer balance.
What does a negative payer balance mean?
Receipts exceed that payer's entered responsibility. Review the payment application, invoice and approval records before making a refund or changing an allocation.
Primary sources
BlueFinch reviewed these sources on September 7, 2026. Payment rules and state requirements change.
- Safelite: insurance coverage and claims questions
- California Bureau of Automotive Repair: Write It Right
This page provides general business information, not legal, tax, or accounting advice.