Supplier Payment Schedule Template for Accounts Payable

What a payment schedule should contain

At minimum, a supplier payment schedule lists every outstanding invoice alongside the supplier name, invoice number, invoice date, due date, amount, currency, and payment method. Additional columns for purchase order reference, department, VAT amount, and approval status turn it from a simple list into a controlled accounts-payable register.

Group invoices by payment run rather than by supplier. This reflects how cash actually leaves the business and makes it straightforward to calculate total outgoings for a given week or fortnight before authorising a run.

Structuring payment runs

Most SMEs run supplier payments once or twice a week on fixed days — for example, every Tuesday and Thursday. Fixing payment days reduces the administrative overhead of ad hoc transfers and gives your suppliers predictable settlement. It also means you retain cash longer on invoices due mid-week, which has a marginal but real benefit on working capital.

• Column: Invoice due date
• Column: Payment run date (next fixed run on or before due date)
• Column: Days early / days overdue (auto-calculated)
• Column: Authorised by
• Column: Payment reference sent

Linking the schedule to cash-flow forecasting

A payment schedule that only records what is due today is less useful than one that projects two to four weeks ahead. Add all received but not yet due invoices to the schedule immediately on receipt. This gives your finance director a forward view of committed cash outflows that can be reconciled against your thirteen-week cash-flow forecast.

Where the combined payment run for a given week exceeds available cash, the schedule makes it visible early enough to act — whether that means requesting extended terms from a supplier, drawing on a revolving facility, or deferring a discretionary payment.

Approval and control columns

For companies with more than one director or a finance manager, the schedule should record who approved each invoice for payment and when. This is particularly important where payments exceed a delegated authority threshold. A simple approval column (name, date, and whether over-threshold sign-off was obtained) satisfies basic internal control requirements without requiring a separate approval workflow system.

Archive completed payment schedules by period. They form part of your accounts payable records and may be requested during an audit or due diligence process.