Short-paid B2B invoice worksheet

Match cash and credits to a short-paid B2B invoice, split the remaining balance and prepare a documented handoff with a copyable worksheet.
Upload a case

Key facts

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.

EntryReferenceAmountHow finance handles it
Original invoiceINV-NL-261042, due 10 Nov€12,480.00Starting balance
Cleared cashBank receipt BK-261114-073 and remittance RA-77421€8,300.00Match and apply once
Approved billing correctionCN-26118, duplicate freight line€380.50Apply the posted credit once
Customer deductionDM-77421-02, disputed installation charge€1,200.00Keep open for assessment. Attach the buyer's explanation and the installation sign-off
Acknowledged and overdueAP confirmation 16 Nov, equipment balance€1,599.50Request a payment date. Record the dispute on the same invoice if asking for outside help
Acknowledged and scheduledWritten plan dated 16 Nov, installment due 30 Nov€1,000.00Track 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.

SituationNext action
The customer confirms an overdue amount, and the evidence ties outPrepare 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 disputeShare 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 uncertainAsk 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 futureKeep 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.

References

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.