Days Payable Outstanding Calculator

What is Days Payable Outstanding (DPO)?

Days Payable Outstanding (DPO) is a financial metric that measures the average number of days a company takes to pay its suppliers and trade creditors after receiving goods or services. It is a core component of working capital analysis and is used by finance directors, credit analysts and investors to assess how efficiently a business manages its outgoing payments.

The DPO formula is straightforward:

Where Accounts Payable is the total outstanding balance owed to suppliers as shown on the balance sheet, Cost of Goods Sold (COGS) is the direct cost of production or procurement for the period, and Number of Days is the length of the period (30 for monthly, 90 for quarterly, 365 for annual).

A higher DPO means the business holds cash for longer before settling supplier invoices, which improves short-term liquidity and reduces the need for external financing. However, an excessively high DPO — particularly one that exceeds agreed payment terms — can damage supplier relationships, attract late payment penalties under UK law, and signal financial distress to creditors.

DPO is most meaningful when compared against industry benchmarks and tracked over time. A retailer with a DPO of 35 days is performing normally; a food manufacturer with the same DPO may be missing an opportunity to extend terms further given typical industry norms of 45–65 days.

DPO vs DSO — The Cash Conversion Cycle

DPO does not exist in isolation. It forms one of three components of the Cash Conversion Cycle (CCC), which measures the total number of days cash is tied up in the operating cycle of a business:

Where:

• DSO (Days Sales Outstanding) — how long it takes to collect cash from customers after a sale
• DIO (Days Inventory Outstanding) — how many days inventory sits in storage before being sold
• DPO (Days Payable Outstanding) — how many days you take to pay suppliers

The goal is a lower CCC. Reducing DSO (collect faster), reducing DIO (sell faster), and increasing DPO (pay later) all shrink the CCC and free up cash. The most efficient businesses — Amazon, Spotify, Zara — achieve negative CCC, meaning they collect customer payments before they need to pay their own suppliers. In effect, their suppliers finance their operations.

For a UK SME with DSO of 45 days, DIO of 30 days and DPO of 35 days: CCC = 45 + 30 − 35 = 40 days. That company has cash tied up for 40 days on average. Extending DPO to 50 days would reduce CCC to 25 days — a significant improvement.

How to Improve DPO Without Damaging Supplier Relationships

Extending DPO is most sustainable when done through negotiation and process improvement rather than simply delaying payments. Here are the most effective strategies used by UK businesses:

1. Negotiate Extended Payment Terms

The most direct approach is to renegotiate contractual payment terms with suppliers — moving from 30-day to 45-day or 60-day net terms. Larger businesses have more leverage to do this, particularly with smaller suppliers who value the relationship. When negotiating, consider offering something in return: guaranteed order volumes, faster dispute resolution, or preferred partner status.

2. Use Supply Chain Finance (Reverse Factoring)

Supply chain finance allows your suppliers to receive early payment from a third-party finance provider, while you pay the provider on your extended terms. The supplier gets paid promptly (reducing their DSO), and you keep cash longer (increasing your DPO). Programmes such as those offered by Barclays, HSBC and specialist fintechs like Taulia and Greensill (now replaced by newer providers) can significantly extend effective DPO without straining supplier relationships.

3. Dynamic Discounting

The inverse of reverse factoring — you offer suppliers the option to receive early payment in exchange for a discount on the invoice value. This works well when you have surplus cash and your cost of capital is lower than the discount rate. Suppliers benefit from improved cash flow; you benefit from lower procurement costs.

4. Centralise and Automate Payables

Many companies inadvertently pay invoices too early because of poor visibility across departments or manual processing delays that then over-correct. Centralising accounts payable into a single shared service centre, combined with AP automation software, allows precise payment timing — ensuring every invoice is paid on the last acceptable day, not early and not late. Tools such as Xero, Sage, and Coupa are widely used by UK businesses for this purpose.

5. Segment Suppliers by Strategic Importance

Not all suppliers should be treated equally. Single-source critical suppliers warrant careful treatment and possibly faster payment to protect the relationship. Commodity suppliers with many alternatives can sustain longer payment terms. A supplier segmentation exercise allows you to maximise DPO across the portfolio while ring-fencing the relationships that matter most.

DPO and Working Capital Impact

Every extra day of DPO releases cash equivalent to your daily COGS expenditure. The formula for quantifying the working capital benefit of extending DPO is:

For example, if a manufacturing business has annual COGS of £5,000,000 and extends DPO from 30 to 45 days, the working capital benefit is: (45 − 30) × (£5,000,000 ÷ 365) = 15 × £13,699 = £205,479 of additional cash held at any point in time. This cash can reduce an overdraft (saving interest at 8–12% per annum), fund growth investment, or simply provide a liquidity buffer during seasonal troughs.

The calculation above assumes consistent COGS throughout the year. In practice, seasonal businesses will see larger cash flow benefits in their peak purchasing periods.

DPO Health Ratings — What Does Your Score Mean?

Frequently Asked Questions About DPO