Cash visibility

How to Forecast Accounts Payable: The DPO Method, Formula, and a Worked Example

admin  ·  November 21, 2026  ·  7 min read

The short answer: To forecast accounts payable, measure days payable outstanding (DPO) from recent actuals, then multiply each future month’s daily spend by that DPO. A company with $1,050,000 of average AP against $2,760,000 of quarterly COGS runs a 35-day DPO, so a month with $33,000 of daily COGS ends with about $1,155,000 in AP.

  • DPO formula: average accounts payable divided by cost of goods sold, times the days in the period.
  • Forecast ending AP: forecast daily spend times DPO. Cash paid to vendors: opening AP plus purchases minus ending AP.
  • Each day of DPO is worth one day of spend in cash, $33,000 per day in the example below.
  • Use vendor-level payment runs for the next four weeks and DPO for everything after that.

Last updated November 2026.

Accounts payable is the largest source of free financing most operating companies have. Vendors deliver now and get paid in 30, 45, or 60 days.

That float moves cash by six or seven figures, and it rarely appears in a founder’s forecast with any precision. This guide covers the DPO formula, the choice of denominator, a three-month worked schedule, and the way the AP line feeds the cash flow forecast.

Etching by Adriaen van Ostade of a man settling his bill with an innkeeper inside a busy seventeenth-century tavern
Peasant Paying his Bill, Adriaen van Ostade, Metropolitan Museum of Art, via Wikimedia Commons, CC0.

What is the formula for forecasting accounts payable?

Forecast ending AP equals forecast spend per day times DPO. Spend per day is the period’s cost of goods sold, or other AP-eligible spend, divided by the days in that period.

DPO itself comes from history. Divide average accounts payable by cost of goods sold for the same period, then multiply by the number of days. The result is the average number of days the company takes to pay a vendor invoice.

The two formulas run in opposite directions. The first measures behavior from the balance sheet. The second projects the balance sheet from assumed behavior. A forecast is only as good as the link between them.

How do you calculate days payable outstanding?

Use one completed quarter of actuals from the closed books. Take the average of opening and closing AP, divide by the quarter’s COGS, and multiply by the days in the quarter.

Consider an illustrative $11.6M-revenue distributor closing the third quarter. Opening AP was $1,010,000 and closing AP was $1,090,000, so average AP was $1,050,000. COGS for the 92-day quarter was $2,760,000.

The arithmetic: $1,050,000 divided by $2,760,000 is 0.3804. Multiplied by 92 days, that is a DPO of 35.0 days. On average, the company pays suppliers 35 days after it records the cost.

A single quarter can mislead. A large year-end purchase or a delayed payment run can swing the result by five days or more. Calculate the last four quarters and look for a stable band before picking the forecast input.

Should you forecast AP as a percentage of COGS or with DPO?

Use DPO for any monthly forecast. Percentage of COGS works only when every period has the same number of days and the same spending rhythm.

The two methods share one ratio. The distributor’s AP equals 38.0% of quarterly COGS, which is the same fact as a 35-day DPO. The difference shows up when periods change length or spend shifts inside the period. DPO adjusts for both; a fixed percentage does not.

Method Formula Best fit Main weakness
DPO Daily spend × DPO Monthly and quarterly forecasts Assumes payment behavior stays stable
Percentage of COGS Period COGS × AP ratio Annual plans with even periods Breaks when month lengths or spend timing change
Vendor-level schedule Open bills by due date, plus new bills by terms The next 4–6 weeks of a 13-week forecast Too detailed to maintain beyond one quarter
Weighted payment terms Spend share × contractual days, summed Testing whether actual DPO matches terms Ignores early and late payment habits

Which spend belongs in the denominator?

Use the spend that actually flows through accounts payable. For a distributor or manufacturer, COGS is a fair proxy because inventory purchases dominate the vendor ledger.

Software and services companies are different. Their AP holds hosting, contractors, legal fees, and marketing tools, while payroll never touches the vendor ledger. Dividing that AP by a thin COGS line can produce a DPO above 90 days that means nothing.

For those companies, build an AP-eligible spend line: COGS plus non-payroll operating expense, excluding depreciation, amortization, and credit card spend. That denominator is less elegant. It produces a DPO that matches how bills arrive and leave in QuickBooks Online or Bill.com.

Worked example: how to forecast accounts payable for one quarter

The distributor forecasts fourth-quarter COGS of $3,036,000, a 10% increase on the third quarter. Holding DPO at 35 days, each month-end AP balance is that month’s daily COGS times 35.

Cash paid to vendors then falls out of a roll-forward. Opening AP plus new purchases, minus closing AP, equals cash paid. The example assumes purchases equal COGS, meaning inventory is flat.

Line October (31 days) November (30 days) December (31 days)
Forecast COGS $992,000 $990,000 $1,054,000
Daily COGS $32,000 $33,000 $34,000
Opening AP $1,090,000 $1,120,000 $1,155,000
Closing AP (daily COGS × 35) $1,120,000 $1,155,000 $1,190,000
Cash paid to vendors $962,000 $955,000 $1,019,000

Over the quarter, the company buys $3,036,000 of goods and pays $2,936,000 in cash. The $100,000 gap is the AP increase, a source of cash that funds part of the growth in inventory and receivables.

The sensitivity matters more than the base case. At $33,000 of daily spend, every day of DPO is worth $33,000 of cash. Sliding from 35 days to 30 days would consume $165,000 the forecast never mentioned.

How does the AP forecast feed the cash flow forecast?

The change in AP is a line in operating cash flow. An increase adds cash; a decrease uses it. In the example, the $100,000 increase lifts fourth-quarter operating cash flow by exactly that amount.

In a direct forecast, the same number appears as cash paid to vendors, $2,936,000 for the quarter. In an indirect forecast, it appears as a working-capital adjustment to net income. The two methods should reconcile to the dollar, which is covered in more depth in direct vs. indirect cash flow forecasting.

Most operating teams blend both views. A 13-week cash flow forecast uses the vendor-level schedule for the first four to six weeks, because open bills and their due dates are already known. DPO takes over for the remaining weeks, where individual invoices do not yet exist.

How do payment terms and early-payment discounts change DPO?

Contractual terms set the ceiling for a healthy DPO. Weight each vendor group’s terms by its share of spend to find the number the company should be running.

Suppose 50% of the distributor’s spend is on net-30 terms, 30% on net-45, and 20% on net-60. The weighted contractual DPO is 15.0 plus 13.5 plus 12.0, or 40.5 days. The actual 35-day DPO means the company pays roughly 5.5 days early, which ties up about $181,500 at $33,000 of daily spend.

Early-payment discounts are the exception worth paying early for. Terms of 2/10 net 30 offer a 2% discount for paying 20 days sooner. Skipping it costs 2% divided by 98%, times 365 divided by 20, or about 37.2% annualized on a 365-day year. Few companies borrow at that rate, so capturing the discount usually beats holding the cash.

Does stretching payables through supplier finance change the accounting?

Supplier finance programs let a buyer extend its own payment date while a bank pays suppliers early. They lengthen DPO, and GAAP now requires the buyer to disclose them.

Under FASB ASU 2022-04, Subtopic 405-50, the buyer discloses the program’s key terms, the confirmed amount still unpaid at period end, where it sits on the balance sheet, and an annual rollforward. The requirements took effect for fiscal years beginning after December 15, 2022, with the rollforward following a year later.

The FASB is explicit that the amendments “do not affect the recognition, measurement, or financial statement presentation of obligations covered by supplier finance programs.” The forecast still carries those obligations in the AP line. A board, a lender, or an acquirer will read the disclosure, so a DPO that depends on the program should be labeled that way.

How often should you update an accounts payable forecast?

Recalculate DPO monthly at close and roll the vendor-level schedule weekly. A forecast built on a DPO more than one quarter old will drift.

The useful discipline is a variance check. Compare forecast closing AP with actual closing AP each month, then split the gap between spend volume and payment timing. Aaron Ressel and Kevin Cahill review that variance in every client close packet under the Debit & Co. Continuous Close Method™, because a timing miss in AP usually shows up first as an unexplained cash shortfall.

Clean inputs come first. A forecast cannot beat an AP subledger with duplicate bills or stale open items, which is why the accounts payable month-end close carries as much weight as the model.

Frequently asked questions

What is the formula for forecasting accounts payable?

Forecast ending accounts payable equals forecast daily spend times days payable outstanding. Daily spend is the period’s cost of goods sold, or AP-eligible spend, divided by the days in the period.

How do you use days payable outstanding to project AP?

Calculate DPO from recent actuals as average AP divided by COGS, times the days in the period. Then multiply each future month’s daily COGS by that DPO to get the projected month-end AP balance.

Should you forecast AP as a percentage of COGS or with DPO?

DPO is the better choice for monthly forecasts because it adjusts for month length and spend timing. A fixed percentage of COGS works only when every period is the same length with even spending.

How does the AP forecast feed the cash flow forecast?

The change in accounts payable flows into operating cash flow. An increase in AP is a source of cash and a decrease is a use. In a direct forecast, the same number appears as cash paid to vendors.

How often should you update an accounts payable forecast?

Recalculate DPO monthly as part of the close and update vendor-level payment schedules weekly. Compare forecast and actual AP each month to separate volume differences from payment-timing differences.

Written by

Founding Partner & Senior Controller

Aaron leads quality assurance and oversight at Debit & Co. with 20 years building high-performing accounting teams. He reviews every client deliverable to ensure accuracy, GAAP compliance, and strategic value — turning good bookkeeping into Financial Clarity™.

LinkedIn →

More from Insights

Ready for Financial Clarity™?

Book a 30-minute discovery call. Tell us your situation, we’ll be honest about fit, and you get a custom proposal in 48 hours.