AP cash forecasting: schedule supplier payments

AP cash forecasting schedules the supplier payments expected to leave the bank, using open invoices and planned purchases with explicit payment dates. It is the supplier-payment input to a company cash forecast. Reconcile the unpaid amounts first, then review the timing with the AP and procurement owners.

Start with outstanding obligations

Export the open-payables report at a fixed cutoff. Keep invoice ID, supplier, entity, currency, invoice amount, payments already applied, credits, due date and payment status. Add a separate expected cash date rather than overwriting the due date. The two fields answer different questions: what was agreed and when cash is currently expected to move.

The SEC's financial statements guide distinguishes what a company owes on its balance sheet from movements of cash over a period. That distinction matters here. A payable balance is a stock of obligations; the forecast schedules when those obligations become payments.

Tie the opening report to the trade-payables ledger using the same entities, currencies and cutoff. Explain unmatched credits, invoices posted after the cutoff and payments in transit. Keep payroll, tax and debt payments outside the supplier schedule unless the scope explicitly includes them. They still belong in the broader cash flow forecast.

Use payment history to inform assumptions, not to override current evidence. A supplier may usually be paid during a weekly run, but a new contract, payment hold or changed terms can invalidate that pattern. Ask the AP owner to supply the expected date and document the reason for any material deviation from terms.

Calculate the unpaid amounts

Invoice cash still outstanding = Invoice gross amount − Settlements already applied − Credits applied

A US distributor prepares four weekly payment buckets starting November 2, 2026. The example has no unapplied credits, disputed balances or foreign-currency invoices. All invoice amounts include any applicable charges already billed, so the forecast does not add them again.

Put the table on an Invoices sheet, with its headers in row 1. Open amount in G2 is:

=E2-F2

Fill down through G6. If credits exist in your export, add a distinct credit column and subtract it too. Do not force negative results to zero automatically; a negative amount may reveal an overpayment, a credit or a mistaken settlement link that needs review.

P102 illustrates why gross invoice values are unsafe forecast inputs. Only $30,000 remains payable after its $15,000 settlement. The invoice-level identity is $170,000 gross − $15,000 already settled = $155,000 still open. The settled amount should agree to the payment applications in the export.

Add firm purchases without duplication

Procurement supplies two additional commitments that are not yet invoiced. Their amounts and dates are approved assumptions for this example, not automatic predictions.

Create a Payments sheet with source reference in A, source type in B, expected cash date in C and amount in D. Bring across the five open invoices and these two commitments, giving seven scheduled rows. The schedule totals $155,000 + $20,000 = $175,000.

When PC201 becomes an invoice, replace the matching commitment record with the invoice's remaining amount. Link both records using the purchase reference. If only part of an order is invoiced, reduce the commitment by the matched part and keep the uninvoiced remainder. This prevents ordinary invoice processing from making the forecast grow without any new purchase.

If a supplier will be paid in installments, use a separate schedule row for each installment while keeping the same invoice reference. The installment amounts must sum to the outstanding balance. A disputed payment needs a visible assumption and owner; removing it without explanation can make headroom look stronger than it is.

Group the payments into weeks

On a Weekly sheet put November 2, 2026, in A2 and =A2+7 in A3, then fill down. Use actual date values. In the layout below, total weekly supplier outflow in D2 is:

=SUMIFS(Payments!$D$2:$D$8,Payments!$C$2:$C$8,">="&A2,Payments!$C$2:$C$8,"<"&A2+7)

The lower boundary is inclusive and the next week's boundary is exclusive, so a payment appears in exactly one week. Microsoft documents SUMIFS as a way to sum values meeting multiple criteria. Covirage is not affiliated with Microsoft.

The weekly sum equals the source schedule. That is a cash-schedule coverage check, not a ledger reconciliation of future AP: the purchase commitments are not posted invoices yet. Separately list payments falling outside the displayed horizon and rows with blank dates so neither can disappear unnoticed.

Connect supplier timing to available cash

For illustration, assume opening bank cash is $250,000 and other cash receipts are $40,000 each week. This limited schedule includes no other payments; a real company forecast must include them.

Each closing balance is opening plus receipts minus payments. The period check is $250,000 + $160,000 − $175,000 = $235,000. All figures are whole dollars. Extend the schedule using the 13-week cash flow structure, and distinguish the forecast from the historical cash flow statement format.

Where it goes wrong

• Gross invoices replace open balances. Subtract settlements and valid credits before scheduling cash.
• A purchase order and invoice both remain. Match them and retain only the uninvoiced commitment balance.
• Blank dates drop from the sum. Put unresolved dates on an exception list with an owner.
• Due dates are changed to fit cash. Keep contractual dates intact and record proposed payment changes separately.
• All balances are assumed payable immediately. Preserve holds, disputes, currencies and installment arrangements as explicit assumptions.

Check your supplier schedule in Covirage

Bring a sample of your own open-payables export, payment history and supplied purchase schedule. Covirage maps the columns; its tools compute and check payment totals and comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.

See Covirage for finance teams for the supporting finance workflow.