Accounts Payable Forecasting: How to Forecast AP Cash Flow

Accounts payable forecasting is the process of predicting how much your business will owe suppliers, and when those payments will come due, so you can plan cash flow with confidence. The most common method uses days payable outstanding (DPO): forecast your cost of goods sold, then multiply by your expected DPO and divide by 365 to project the payables balance. Add your open purchase orders and recurring bills, and you get a payment schedule you can fund on time without surprises.

Last updated July 2026.

What is accounts payable forecasting?

Accounts payable forecasting is the practice of estimating your future supplier obligations, both the total balance and the timing of individual payments, over a defined period. A good AP forecast answers two questions at once: how much cash will leave the business, and on which days. Controllers and CFOs use it to keep enough cash on hand to pay vendors without holding idle balances that could be working elsewhere.

It sits at the center of cash flow planning. Accounts receivable forecasting tells you when money comes in; AP forecasting tells you when it goes out. Line the two up and you can see your net cash position weeks or months ahead, spot a shortfall before it happens, and decide whether to accelerate a payment for an early-payment discount or stretch one to protect liquidity.

How to forecast accounts payable using DPO

The DPO method is the standard approach for a top-down forecast. Days payable outstanding measures the average number of days you take to pay suppliers after receiving an invoice. To forecast payables with it, take your projected cost of goods sold for the period, multiply by your expected DPO, and divide by the number of days in the period.

The formula is:

Forecasted accounts payable = (Forecasted COGS / 365) × Expected DPO

Say you expect $3,650,000 in COGS over the next year and your historical DPO is 45 days. Divide $3,650,000 by 365 to get $10,000 of daily purchasing, then multiply by 45 for a forecasted payables balance of $450,000. If you are forecasting a single quarter, use that quarter's COGS and divide by 91 or 92 days instead of 365. To learn how the underlying ratio works, see our guide to days payable outstanding and the DPO formula.

The DPO method is fast and works well for a high-level view, but it assumes your payment behavior stays steady. If you plan to change payment terms, onboard a large new supplier, or shift a seasonal buying pattern, adjust the DPO input to reflect it rather than trusting last year's average.

The three main methods for forecasting accounts payable

There is no single right way to build an AP forecast. Which method you pick depends on how much detail you need and how far out you are looking.

1. The DPO (ratio) method

Best for medium-term and annual planning tied to your income statement. You forecast COGS or total purchases, apply an expected DPO, and get a projected balance. It is quick and ties cleanly to your budget, but it smooths over the day-to-day timing of individual payments.

2. The balance-sheet roll-forward method

Start with your current AP balance, add forecasted purchases, and subtract forecasted payments. This roll-forward gives you an ending balance for each period and works well when you have a reliable purchases budget and a clear payment policy. It is more granular than the ratio method and better for tracking the balance month to month.

3. The invoice-level (direct) method

The most accurate approach for short-term cash forecasting. Instead of ratios, you build the forecast from the actual invoices and bills already in your system, each with its due date, plus your open purchase orders and known recurring costs like rent, payroll-adjacent vendors, and subscriptions. This produces a dated payment schedule, not just a balance, which is exactly what a 13-week cash flow forecast needs. Because it depends on clean, current invoice data, it is far easier to run when your accounts payable software already holds every invoice with its approval status and due date.

How to build an accounts payable forecast step by step

Here is a practical workflow that combines the ratio and direct methods so you get both a balance and a payment schedule.

1. Set your forecast horizon. Decide whether you are forecasting the next 13 weeks for cash management, the next quarter for a budget, or the full year for planning. Short horizons call for invoice-level detail; longer ones can lean on DPO.
2. Pull your open payables. Export every unpaid invoice with its amount, due date, and approval status. Group them by the week or month they fall due. Your accounts payable aging report is the starting point for this.
3. Add committed spend from open purchase orders. Approved purchase orders that have not yet been invoiced are future payables you already know about. Pulling them from your purchase order management system turns a backward-looking forecast into a forward-looking one, because it captures obligations before the invoice even arrives.
4. Layer in recurring and predictable costs. Rent, utilities, software subscriptions, and standing supplier agreements repeat on a schedule. Add them to the right periods even if no invoice exists yet.
5. Apply DPO for the unknown remainder. For purchases you expect but cannot yet name, use the DPO ratio against forecasted COGS to estimate the balance and spread it across the horizon.
6. Reconcile and review. Compare last month's forecast to what actually happened, note the variance, and adjust your DPO assumption and payment-timing rules. A forecast you never check against reality drifts quickly.

Many finance teams still run this in a spreadsheet. If you build your model in Excel, exporting invoice and aging data cleanly matters; a PDF-to-Excel converter helps when vendor statements or reports only arrive as PDFs and you need the numbers in your workbook.

Why accounts payable forecasting matters for cash flow

An accurate AP forecast is one of the most direct levers a finance team has over working capital. Knowing exactly when payments are due lets you time them for the best cash outcome: pay early to capture a 2/10 net 30 discount when cash is comfortable, or pay on the due date (not before) when it is tight. Either way, you decide deliberately instead of reacting to whatever invoices land that week.

It also prevents the two failures that hurt vendor relationships and your credit: paying late because you did not see the obligation coming, and paying twice because the same invoice slipped through. Forecasting forces you to look at the full payables picture on a schedule, which surfaces problems early. Pair the forecast with automation that catches duplicate invoice payments and the forecast stays trustworthy.

Common accounts payable forecasting mistakes

Three errors show up again and again. First, relying on a stale DPO. Payment behavior changes with new terms and new suppliers, so a DPO from twelve months ago can be off by a week or more, which is a lot of cash on a large balance. Second, ignoring open purchase orders, which means the forecast only sees invoices that have already arrived and misses obligations you have already committed to. Third, forecasting a single balance instead of a dated schedule; a total tells you how much but not when, and cash management lives in the "when." The fix for all three is cleaner data and shorter feedback loops, which is where automation earns its place.

How automation improves AP forecast accuracy

The hard part of forecasting is not the math, it is getting timely, accurate data to feed it. When invoices are captured the day they arrive, coded correctly, and matched against purchase orders automatically, your forecast is built on real due dates instead of estimates. Payables automation software keeps a live view of every approved and pending invoice, so the invoice-level forecast updates itself as new bills come in rather than waiting for a month-end scramble.

Automation also improves the DPO input over time. With every invoice and payment recorded consistently, your actual DPO becomes a reliable number you can trust in the ratio method, and you can watch it trend rather than guess. The result is a forecast that gets more accurate the more you use it, and a cash position you can see clearly weeks ahead. Teams moving from spreadsheets usually start by digitizing capture and approvals, then let the dated forecast fall out of the data. Our guide on how to automate accounts payable walks through that transition.

Frequently asked questions

How do you forecast accounts payable?

You forecast accounts payable by projecting future supplier obligations and their timing. The quickest method uses days payable outstanding: divide forecasted cost of goods sold by 365, then multiply by your expected DPO to get the projected balance. For a dated payment schedule, build the forecast from open invoices and purchase orders with their due dates and add recurring costs.

What is the formula to forecast accounts payable?

The standard formula is: Forecasted accounts payable = (Forecasted COGS / 365) × Expected DPO. For example, $3,650,000 of annual COGS at a 45-day DPO gives $10,000 of daily purchasing multiplied by 45, or a $450,000 projected payables balance. For a quarter, use that period's COGS and divide by the number of days in it.

How do you forecast accounts payable on a balance sheet?

To forecast accounts payable on a balance sheet, use the roll-forward method: start with the current AP balance, add forecasted purchases for the period, and subtract forecasted payments. The ending balance carries into the next period. Many models tie the balance to COGS using an assumed DPO so the payables line moves in step with projected spending.

What is the difference between forecasting accounts payable and accounts receivable?

Accounts payable forecasting predicts cash going out to suppliers, while accounts receivable forecasting predicts cash coming in from customers. AP forecasting commonly uses days payable outstanding (DPO); AR forecasting uses the mirror metric, days sales outstanding (DSO). Finance teams forecast both and combine them to project the net cash position and the cash conversion cycle.

How far ahead should you forecast accounts payable?

It depends on the goal. For active cash management, a rolling 13-week forecast built from actual invoices and open purchase orders is the standard, because it is detailed enough to schedule specific payments. For budgeting and planning, a quarterly or annual DPO-based forecast is enough. Most teams run a short, precise forecast alongside a longer, directional one.

Can accounts payable forecasting be automated?

Yes. When AP software captures every invoice with its due date, matches it to purchase orders, and records payments consistently, the invoice-level forecast updates automatically as new bills arrive. Automation also produces a reliable DPO you can trust in ratio-based projections, so both the short-term schedule and the longer-term balance forecast become more accurate over time.