Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
Glossary

What Is DPO? Days Payable Outstanding Meaning, Formula and Example

For finance managers, CFOs and owners of Indian SMEs: know how long you take to pay suppliers, and whether that pace helps cash flow or hurts relationships.

A finance manager sorting supplier bills by date in a fabric trading office

What is DPO? DPO, or days payable outstanding, is the average number of days a business takes to pay its suppliers. It turns the trade payables on your balance sheet into a number of days, so you can compare it with the credit terms you agreed.

A higher DPO keeps cash in the business longer. Stretched too far, it means late payments, lost discounts and suppliers who quietly raise prices or stop giving credit.

This page gives the formula with a worked example, the common mistakes in calculating it, an illustrative business, and how Apragya gives you the payables data behind the number.

DPO meaning and formula

Days payable outstanding measures how many days of purchases are still unpaid. The usual formula is DPO = trade payables divided by credit purchases, multiplied by the number of days in the period. Some analysts use cost of goods sold instead of purchases.

A worked example: a business buys INR 1.2 crore on credit in a quarter of 90 days. Trade payables at the end of the quarter are INR 40 lakh. Purchases per day are INR 1.33 lakh, so DPO is 40 divided by 1.33, or about 30 days.

Read DPO next to your agreed terms and your DSO. If customers pay in 60 days and you pay suppliers in 30, the business funds the 30 day gap from its own cash or a loan.

  1. Take trade payables at period end, or the average.
  2. Take credit purchases for the same period.
  3. Divide purchases by the days in the period.
  4. Divide payables by that daily figure.

DPO before and after payables are on one record

Payables in Apragya

  • Bills recorded against the purchase order and goods receipt
  • Ageing of payables by supplier, ready to read
  • Payment runs planned around due dates
  • Payables and purchases available for any period you pick

An example: a Coimbatore textile trader

Take an illustrative yarn and fabric trader with purchases of INR 3.65 crore in the year and trade payables of INR 60 lakh at year end. Suppliers mostly offer 45 days of credit.

The trader's DPO worksheet

  1. Purchases on credit for the year.

  2. Purchases divided by 365 days.

  3. Owed to suppliers at year end.

  4. Payables divided by purchases per day.

  5. The terms most suppliers offered.

  6. Paying later than agreed, on average.

A DPO above the agreed terms means the business is paying late, not managing cash well.

The ageing report showed that most of the delay sat with three mills that had not been chased. The trader agreed a payment calendar, paid within terms and asked two mills for an early payment discount instead.

Bundles of bills placed on a calendar on evenly spaced days next to cones of yarn
With a payment calendar, the trader paid mills within terms instead of 15 days late.

How Apragya supports the DPO calculation

Step 1 of 5

Bills on record

Purchase invoices are recorded with supplier, amount and due date.

  1. Bills on record: Purchase invoices are recorded with supplier, amount and due date.
  2. Matched first: Bill totals are checked against the purchase order and goods receipt.
  3. Payables ageing: Amounts owed are grouped by how long they have been outstanding.
  4. Payment runs: Choose which bills to pay together, around due dates and cash.
  5. Period figures: Purchases and payables for the period feed your DPO calculation.

DPO formula in practice: what to watch for

The formula is simple; the inputs are where it goes wrong. Payables that include non-trade dues, purchases that include cash buys, or a year-end balance that is unusually high all distort the answer. Clean payables data matters more than the arithmetic.

DPO from a spreadsheet, against Apragya

FeatureSpreadsheet DPOApragya payables
Payables figureTaken from the trial balanceSupplier balances from recorded bills
Unbooked billsOften missingCaptured when the bill arrives
By supplierWorked out separatelyPayables ageing by supplier
Payment planningAd hocPayment runs around due dates
Link to purchasesSeparate sheetSame record as the purchase order

Checked against public information on 16 September 2026.

Getting started with a DPO calculation example of your own

  1. Take credit purchases for the last twelve months.
  2. Take trade payables at the end of the period.
  3. Divide payables by purchases per day.
  4. Compare the result with your agreed terms.
  5. Look at the ageing report to find where the gap is.

Work it out every quarter; a single year-end figure hides seasonal swings.

What sets Apragya apart for payables

One record

Order, receipt, bill and payment sit on the same chain.

AI with human review

An agent can flag duplicate or unusual bills for someone to check.

TDS on payments

Tax deducted at source is worked out when you pay.

Multi-company

Track payables separately for each company in the group.

Audit log

Who approved and who paid is recorded.

Access by role

Buyers, accountants and approvers each see what they should.

Read about AP ageing, payment runs and the matching measure on the customer side, DSO.

What it costs to start

INR 3,999
Starter, a month
Up to 10 users, CRM and HR plus Purchase and Payables
2,000
AI Credits a month
Included on Starter
Free
Up to 3 users
CRM, HR and Vendor Onboarding

Days payable outstanding, answered

Should we use purchases or cost of goods sold?
Both are used. Credit purchases suit a trader; cost of goods sold is common in published analysis. Pick one and use it consistently.
Is a high DPO good?
Only up to the agreed terms. Beyond that it usually means late payment, which can cost discounts and goodwill.
Should we use average or closing payables?
Average payables, opening plus closing divided by two, smooths out a single unusual month end.
Does Apragya show DPO as a single number?
Apragya gives the payables ageing, supplier balances and purchases for a period; use them in the formula above or in a report you set up.
What does it cost to start?
Purchase and Payables is available from the Starter plan, INR 3,999 a month for up to 10 users, which includes CRM and HR plus a choice of enterprise apps and 2,000 AI Credits a month. Pro, at INR 7,999 a month, covers 25 users and every enterprise app.

See what you owe, and when

Record bills against orders and read your payables ageing by supplier.