Short-paid B2B invoice worksheet
Key facts
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
When a business customer pays less than the invoice total, match the bank receipt to their remittance advice, then apply any approved credit notes. Split the remainder into amounts the customer acknowledges, amounts they dispute, and amounts you still cannot explain. If there is a payment plan, record which part of the acknowledged balance is due now.
Use the worksheet to reconcile your ledger and organize evidence. The contract and applicable law determine liability, set-off, waiver, recoverability and VAT treatment. Seek advice for the relevant jurisdiction before starting collection or issuing a corrective document.
Reconcile a short payment
- Start with the invoice number, legal customer name, original amount and currency. Match the actual bank receipt to the remittance reference. For a combined payment, get the invoice-by-invoice allocation from the customer's accounts payable team. Track currency differences and bank fees separately until you know how to account for them.
- Match each approved credit note to the original invoice and line. Have the billing and tax owner confirm the credit and its accounting and VAT treatment before applying it once. If you discover a billing error, have the billing owner approve and post the correction, then rerun the reconciliation.
- Ask the customer to identify the invoice line, amount and reason for each deduction. Ask them to confirm the remaining balance and expected payment date. If they dispute liability for a line, keep the amount and their explanation together. Record the deduction as disputed while you check its basis against the contract and supporting documents.
- For any agreed installment plan, attach the written schedule and record what is already overdue and what is due later. Keep any unexplained difference visible and assign someone to reconcile it.
Worked example
A fictional Dutch supplier invoiced a German business customer €12,480.00 for equipment and installation. All dates and references below are illustrative.
| Entry | Reference | Amount | How finance handles it |
|---|---|---|---|
| Original invoice | INV-NL-261042, due 10 Nov | €12,480.00 | Starting balance |
| Cleared cash | Bank receipt BK-261114-073 and remittance RA-77421 | €8,300.00 | Match and apply once |
| Approved billing correction | CN-26118, duplicate freight line | €380.50 | Apply the posted credit once |
| Customer deduction | DM-77421-02, disputed installation charge | €1,200.00 | Keep open for assessment. Attach the buyer's explanation and the installation sign-off |
| Acknowledged and overdue | AP confirmation 16 Nov, equipment balance | €1,599.50 | Request a payment date. Record the dispute on the same invoice if asking for outside help |
| Acknowledged and scheduled | Written plan dated 16 Nov, installment due 30 Nov | €1,000.00 | Track against the agreed schedule |
The ledger balances. €12,480.00 - €8,300.00 - €380.50 = €3,799.50 open. That equals €1,599.50 overdue and acknowledged + €1,000.00 scheduled + €1,200.00 disputed. The unexplained difference is €0.00.
The buyer's deduction explains why €1,200.00 was withheld. It stays in the disputed column while finance checks the purchase order and installation sign-off. The €1,000.00 installment stays in the schedule column because both parties agreed its payment date.
Copy the worksheet
Paste the tab-separated fields into a spreadsheet. Keep one summary row per invoice and attach a line-level breakdown if the customer withheld multiple amounts.
Invoice ID Customer legal name Debtor country Currency Invoice date Original due date Original amount Bank and remittance refs Cash allocated Credit note refs Approved credits Open principal Acknowledged overdue Acknowledged future Disputed Unallocated Evidence links Owner Next action Review date
- Open principal = original amount - cash allocated - approved credits.
- Unallocated = open principal - acknowledged overdue - acknowledged future - disputed.
- Record the date and source of each classification. Unallocated may initially be positive. A negative amount signals a possible duplicate allocation, overpayment or classification error to reconcile before handoff.
Decide what to hand off
Identify disputed amounts explicitly in the handoff. Before pursuing the remaining balance, check how the governing law and contract treat the allocation of the payment, any installment agreement, interest and recovery costs. Confirm the local collection requirements and whether the agreement affects the remaining claim.
| Situation | Next action |
|---|---|
| The customer confirms an overdue amount, and the evidence ties out | Prepare the itemized balance, invoice, agreement or order, delivery evidence, remittance, credit notes and relevant correspondence. Start a Debitura case when the claim fits the intake criteria. |
| The same invoice contains both an acknowledged balance and a dispute | Share the split and the full correspondence when asking Debitura about assessment. Ask how to present the acknowledged portion before submitting it separately. |
| Cash or credit allocation is uncertain | Ask accounts payable for the invoice-level remittance or ask the bank for settlement details. Record the unresolved difference and hold the handoff until it can be explained or assessed. |
| An installment is still due in the future | Keep it on the payment schedule. If an installment is missed, review the written schedule and confirm which amounts are overdue. |
For a payment or dispute on a case you have already submitted, follow the active-case guidance.


.webp)