DPO Calculator

The cheapest financing you will ever be offered

When a supplier sends goods and gives you thirty days to pay, they have lent you money. No interest, no application, no paperwork. For those thirty days you hold stock you have not paid for, and the cash sits in your account instead of theirs.

Days payable outstanding measures how long you actually take. It is one of the few numbers in business where the obvious answer, take as long as possible, is wrong in a way that costs real money. This calculator works out your figure, and the sections below are mostly about when stretching is smart and when it is quietly expensive.

Six figures, and why it works from purchases

The tool asks for beginning and ending accounts payable, and averages them, which smooths out the fact that a single day's balance can be unrepresentative.

Then it asks for beginning and ending inventory alongside cost of goods sold, and this is where it does something more careful than most versions of this calculation. The natural denominator is what you actually bought during the period, not what you sold, and those differ whenever your stock level moves. So the tool derives purchases: cost of goods sold, plus the increase in inventory, or minus the decrease. If your stock grew, you bought more than you sold, and that extra buying belongs in the calculation.

Finally, days in the accounting period, with a unit selector so you can enter 365 days, or 12 months, or 1 year, whichever matches how you think. Because the calculation is built from inventory movement, it suits a business that carries stock, which is exactly where payables management tends to matter most.

44.5 days

Take a business whose payables ran from 180,000 to 220,000, whose inventory rose from 300,000 to 340,000, with cost of goods sold of 1,600,000 over a 365 day year.

Average payables come to 200,000. Purchases work out at 1,600,000 plus the 40,000 the inventory grew, so 1,640,000. That gives a days payable outstanding of 44.51 days.

The careful denominator earns its keep here. Had the calculation used cost of goods sold on its own, the answer would have been 45.62 days, about a day longer, purely because the business bought more than it sold that year. Small on one reading, and steadily misleading if you track the figure quarter after quarter while your stock levels move.

The 37 percent question

Now the part that changes how you should think about this number, and it involves some arithmetic worth doing once and never forgetting.

Suppliers commonly offer terms written as 2/10 net 30. It means the full amount is due in thirty days, but pay within ten and you take two percent off. Most businesses focused on cash flow let that pass, because holding the cash feels like the prudent move.

Work out what declining actually costs. By not taking the discount you are paying an extra 2 percent to keep your money for an additional twenty days. Two percent on the 98 percent you would otherwise have paid, repeated across the roughly eighteen twenty-day periods in a year, works out to an annualised cost of about 37 percent.

Thirty-seven percent. That is a worse rate than almost any borrowing you could arrange, including a credit card. On 500,000 of annual spend with those terms, the discount is worth 10,000 a year, and turning it down to hold cash a few weeks longer is one of the more expensive habits a business can develop quietly.

Which reframes the whole exercise. The right question is not how late you can pay, it is when each supplier should be paid. Suppliers offering a real discount should be paid early, almost always. Suppliers with no discount and no relationship risk can be paid at the agreed limit. Suppliers you genuinely depend on should be paid promptly, because goodwill with a critical supplier tends to be worth more than a few weeks of float. A blanket policy of paying everyone as late as possible destroys value on the invoices where paying early was the financially correct answer.

Your own terms are the benchmark that matters

You will find industry figures for this, roughly twenty to thirty-five days in services and forty-five to sixty in manufacturing, and they are worth a glance. But the comparison that actually tells you something is against the terms you agreed.

If your suppliers have given you net 30 and your figure is 44 days, you are not optimising working capital, you are paying late. That has consequences beyond an awkward phone call: suppliers reprice for the risk, tighten terms, ask for deposits, and quietly move you down the queue when stock is short. In much of Europe there is a legal dimension too, with rules setting default payment periods for commercial transactions and giving suppliers an automatic right to interest and recovery costs when payments run over.

If your terms are net 60 and your figure is 44, the picture inverts. You are paying about sixteen days earlier than you agreed to, and unless you are capturing discounts for it, that is free financing you have been offered and declined. Either situation is worth knowing, and neither shows up in an industry average.

Four reasons the number moves, and only one is good news

A rising figure looks like an improvement on a working capital dashboard. It is worth knowing which of four quite different things is behind it.

You renegotiated terms. Suppliers agreed to give you longer. This is the good one: deliberate, predictable, and a sign of decent buying power.

Cash is tight. Payables are stretching because the money is not there, not because anything was agreed. Suppliers usually notice this before the finance team names it, and it is a symptom rather than an achievement.

Your process is slow. Invoices sit waiting for approval, so payments go out late by accident. This is the most expensive version, because it costs you discounts and supplier goodwill while delivering none of the strategic benefit. You cannot time a payment you have not approved yet.

Your supplier mix changed. You added vendors on different terms and the average shifted without any behaviour changing at all.

The last thing worth saying is that this figure has a twin. Days payable is what you do to your suppliers; debtor days is what your customers do to you. If you pay in 44 days and collect in 60, you are funding that sixteen-day gap out of your own pocket on every sale, and neither number tells you that on its own.

Questions people ask

How is days payable outstanding calculated?

Divide average accounts payable by purchases for the period, then multiply by the number of days. This tool derives purchases from cost of goods sold adjusted for the change in inventory, which is more precise than using cost of goods sold alone.

Is a higher DPO better?

Only up to a point. Holding cash longer helps working capital, but paying beyond your agreed terms damages supplier relationships and can trigger late payment interest, and stretching past an early payment discount is usually far more expensive than it looks.

Should I take a 2/10 net 30 discount?

Almost always. Declining a 2 percent discount to hold the money twenty extra days works out to roughly a 37 percent annualised cost, which is worse than nearly any financing you could arrange instead.

What is a good DPO?

Around 20 to 35 days is common in services and 45 to 60 in manufacturing, but the meaningful comparison is against the terms your suppliers actually gave you. Sitting well above them means paying late, not optimising.

References

The calculation follows standard working capital analysis. The rules on commercial payment periods come from the legislation below.

1. European Union. Directive 2011/7/EU on combating late payment in commercial transactions (default payment periods, statutory interest, and recovery costs). eur-lex.europa.eu
2. Horngren, C. T., Datar, S. M., and Rajan, M. V. Cost Accounting: A Managerial Emphasis (working capital measures and the cash conversion cycle). Pearson.