Promise-to-pay tracker for overdue B2B invoices
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.
Copy the tracker
Use one row per invoice and due date. Give each instalment its own row. If a customer promises one transfer for several invoices, ask how they want it allocated. Link those rows with one promise ID and check that the allocations add up to the promised transfer.
| Invoice and currency | Open when agreed | Promised by 17 Nov | Applied at cutoff | Promise shortfall | Invoice still open | Next action |
|---|---|---|---|---|---|---|
| INV-1842, EUR | 4,000 | 2,500 | 1,500 | 1,000 | 2,500 | Confirm the remaining commitment with the buyer |
| INV-1870, EUR | 900 | 900 | 900 | 0 | 0 | Mark the promise kept and close the follow-up |
Add the customer’s legal entity, promise ID, person who confirmed it, confirmation date, link to the correspondence, owner and next action date to your working sheet. Keep the original due date on the invoice. Record the promise date separately.
The first customer promised €2,500 and paid €1,500 against that promise. The promise is €1,000 short, and the invoice still has €2,500 outstanding. If you ask for the promise shortfall, quote €1,000. If you send an account statement, show the full €2,500 still open.
Work the exceptions after posting cash
- Kept. The receipts assigned to the promise cover the amount. Check whether the invoice still has a balance before closing the collection task.
- Partial. A receipt covers part of the commitment. Reconcile the amount received and agree who will follow up on the gap.
- Missed. The cutoff has passed and there is no matching receipt or credible evidence of a transfer in flight. Follow up with the person who confirmed the commitment.
- Cash under review. A bank or processor entry looks relevant, but the payer, invoice or allocation is unclear. Ask cash application to match it and give the review an owner and a date.
If the customer gives a new date, keep the first row’s cutoff result and add a linked commitment for the outstanding amount. Record any later payment separately with its receipt reference and the amount allocated to each promise or instalment. Check the cumulative allocations against the receipt before recording another allocation. Oracle’s collections documentation also calls for applying cash before reconciling open promises.
For several instalments, start with the payment plan agreement worksheet. Use the cash application guide if the payment reference is missing. When repeated commitments slip and you have a supported overdue business claim, keep the original invoices and promise history together before submitting a collection case.


.webp)