Build an Invoice Collection Schedule

An invoice collection schedule answers when customer money is expected to arrive. It starts with invoices and collection evidence, not with the assumption that sales equal cash. For a small invoice book, list each invoice separately. For many similar invoices, group them by billing period and apply an explicitly chosen collection pattern.

Use invoice cohorts rather than one sales percentage

Suppose a hypothetical business expects to collect 30% of each month's invoiced sales in that month and 70% the following month. January invoices total $20,000 and February invoices total $30,000. With no opening receivables, January receipts are $6,000. February receipts are $14,000 from January plus $9,000 from February, or $23,000.

The percentages use each cohort's original invoiced amount as their base. They total 100%, so this particular scenario assumes eventual full collection. It does not claim that full collection is certain. If you assume some invoices will not be collected, make that share explicit and do not quietly place it in a later month merely to balance the schedule.

Reconcile the remaining receivable

At the end of February, cumulative invoices are $50,000 and cumulative receipts are $29,000. Remaining receivables are $21,000. The rollforward is opening receivables plus invoices minus receipts minus applicable credit adjustments or write-offs. In this example those adjustments are zero. A mismatch often means an opening invoice was omitted or a receipt was counted twice.

Separate payment settlement timing from customer payment timing. A customer may pay on the last day of a month while the usable bank receipt arrives later. If a payment provider deducts a fee, record the gross customer payment and the fee separately, or consistently use net receipts with a reconciliation. Do not subtract the same fee again in the cash payments schedule.

Update large exceptions individually

An average pattern is a useful starting point, but a large disputed invoice should follow its own expected resolution date. Mark promised payment dates, partial payments, retainage, and customer-specific delays. If a $10,000 invoice moves from February to March, shift that amount between periods rather than reducing annual revenue by $10,000.

Compare actual receipts with the previous schedule each week. Separate timing differences from genuine changes in collectible amounts. This forecast does not establish accounting write-offs, collection rights, or customer creditworthiness. It organizes your own invoices and assumptions so the cash plan shows both the expected receipts and the uncertainty surrounding them.

Method references: OpenStax: Prepare Financial Budgets. Accessed October 22, 2026. All dollar figures are hypothetical worked examples.