DPO Calculator — Days Payable Outstanding

DPO measures the average number of days a company takes to pay suppliers after making a purchase. The formula is: DPO = (average accounts payable ÷ COGS) × 365. Example: average accounts payable of Rp200 million with annual COGS of Rp1.5 billion gives a DPO of 48.67 days — meaning the company pays suppliers about 49 days after purchase on average.

Take the accounts payable balance at the beginning and end of the period, average them, divide by annual COGS (cost of goods sold), then multiply by 365. Example: (Rp150 million + Rp250 million) ÷ 2 = Rp200 million; Rp200 million ÷ Rp1.5 billion × 365 = 48.67 days. Use COGS, not revenue, because accounts payable relates to purchasing goods, not sales.

All three measure days, but of different things. DIO (days inventory outstanding) = how long inventory sits before being sold. DSO (days sales outstanding) = how long customers take to pay after a sale. DPO (days payable outstanding) = how long the company takes to pay suppliers after a purchase. DIO and DPO use COGS as the denominator, while DSO uses revenue.

CCC = DIO + DSO − DPO. DPO is subtracted because supplier credit finances part of the cash cycle: while the company has not yet paid suppliers, those funds cover cash already spent on inventory and receivables. A longer DPO shortens the CCC. See also: /tools/cash-conversion-cycle/.

Not always. A longer DPO does keep cash in the company longer, but paying too late can trigger late penalties, damage supplier relations, forfeit early-payment discounts, and cause suppliers to tighten terms or hold shipments. A healthy DPO is one agreed with suppliers, not imposed unilaterally.

The ending balance is only a single date’s snapshot and can be distorted by large end-of-period purchases. Averaging beginning and end smooths those fluctuations so DPO better represents conditions across the period. For seasonal periods, averaging more points (e.g. monthly) gives a more accurate picture.

Both are used in practice; this calculator uses 365 days following common convention. Some analysts use 360 days for simplicity. The difference is small — what matters is consistency: every comparison across periods or companies must use the same number of days.

Four common limitations. First, DPO uses a period average, so seasonal spikes or large purchases can distort it. Second, DPO does not show the spread of due dates — one large supplier with long terms can mask many small suppliers paid quickly. Third, an improving DPO can mislead when it comes from falling purchases rather than better management. Fourth, DPO ignores hidden costs such as forgone early-payment discounts. Use DPO alongside cash flow statements and purchase trends.