Using Accounts Payable in a Cash Flow Projection the Right Way

A cash flow projection is only as good as its payables data. The Accounts Payable side of a projector pulls your unpaid bills, vendor by vendor, and lays them onto a week-by-week timeline. Here is how to read that data, adjust it safely, and avoid the double-counting trap that catches most people eventually.

Where does the projected payables figure come from?

The projector reads your open bills directly from the ledger: vendor, amount, and due date for each unpaid bill. Nothing is typed in by hand at that stage, which is the whole point. The projection is a photograph of your accounts payable subledger, sorted onto a calendar.

That also means the projection is only as complete as your bill entry. If a stack of supplier invoices is sitting in a tray waiting to be keyed, the projector cannot see it. Enter every bill you know about before you run the projection, or plan to adjust for the gap manually.

Why the payment date matters more than the due date?

By default, the projector assumes you pay each bill on its due date. That is a reasonable first pass, but it is rarely the truth. Some suppliers get paid early for a discount. Some get paid late, consistently, because that is the agreed rhythm of the relationship.

If you know the actual expected payment date differs from the due date, override it. A bill due on the 5th that you always pay on the 20th belongs in week three, not week one. Left on the default, it will make the early weeks of the projection look tighter than they really are.

What do the adjustment fields do?

The summary view totals your payables by week across the projection period, typically six weeks. The adjustment fields let you overlay amounts that are not in the ledger yet.

The classic case is the bill you know is coming but have not entered. You expect a quarterly insurance invoice of about 1,800 landing in week four. Key that into the week four adjustment line and the projection now reflects reality.

Two rules keep adjustments honest:

• Adjustments are date specific, so put the amount in the week you expect to pay, not the week the bill arrives.
• Adjustments live in the projector only. They do not post anything to your ledger, and they vanish when you rebuild the projection unless you carry them forward.

How does the double-counting trap work?

This is the failure mode worth memorising. Suppose you adjusted for that 1,800 insurance bill in week four. Later, you enter the actual bill into your bookkeeping software. The projector now sees the real bill, and the adjustment is still sitting there too. The projection subtracts 3,600 from week four, and your cash position looks artificially bad.

The fix is discipline, not cleverness. The moment a bill you adjusted for is entered into the ledger, delete the matching adjustment from the projector. We recommend keeping a short note of open adjustments alongside the projection so nothing lingers unnoticed.

A clean working routine

Run the projection the same way each time. Enter all known bills first. Override payment dates where the due date misleads. Adjust only for payables that are genuinely absent from the ledger. Review the adjustment list before you trust the output, and clear any adjustment whose bill has since been entered.

Do that, and the payables side of your projection stays a faithful picture of money leaving the business, week by week.