Promise-to-pay tracker for overdue B2B invoices

Record every promise with an invoice number, an amount and a date. At the next cash posting cutoff, compare the commitment with the receipts applied to those invoices. Keep the promised amount separate from the open balance so you can see both whether the customer kept the promise and how much they still owe.
Upload a case

Key facts

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 currencyOpen when agreedPromised by 17 NovApplied at cutoffPromise shortfallInvoice still openNext action
INV-1842, EUR4,0002,5001,5001,0002,500Confirm the remaining commitment with the buyer
INV-1870, EUR90090090000Mark 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.

Source: Oracle Fusion Cloud Financials, Promise to Pay

RELATED ARTICLES

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.