Calculating working capital: formula, example and what a healthy level is

7 min read

Making a profit and still being short of cash: usually the money is tied up in invoices and stock. Here is how to calculate working capital, how to assess it and what you can adjust.

Illustratie: een weegschaal met drie blokken tegenover een enkel blok

A business that turns a profit and yet struggles to pay the wages every month almost always has the same issue: the money is tied up. In customers who still have to pay, in stock that still has to be sold, or in suppliers who get paid faster than they need to be.

The measure for this is working capital, and it is one of the few figures on your balance sheet that you can do something about right away. In this article you will read how to calculate working capital, with the formula and an example, what a healthy level is, how DSO and DPO fit in and how you free up cash. And how to pull it from your administration every month without reaching for the balance sheet.

The formula

Working capital is the difference between your current assets and your current liabilities. Current assets are the possessions that turn into cash within a year: debtors, stock and the cash itself. Current liabilities are what you have to pay within a year: creditors, VAT and payroll tax due, short-term credit and other debts.

Working capital = current assets minus current liabilities

Anyone who wants to steer on operations often leaves out the cash and the bank credit and looks only at the operational items:

Operational working capital = debtors plus stock minus creditors

That second figure tells you how much cash is tied up in your business process, aside from whatever happens to be in the bank.

An example

The balance sheet of a wholesaler at the end of the quarter, fictitious figures:

Current assetsEuroCurrent liabilitiesEuro
Debtors184,500Creditors96,000
Stock62,000VAT and payroll tax34,000
Cash48,200Short-term credit40,000
Other debts12,000
Total294,700Total182,000

The working capital is 294,700 minus 182,000, so 112,700 euros. The operational working capital is 184,500 plus 62,000 minus 96,000, so 150,500 euros.

That last figure is the most interesting. After deducting what you still owe suppliers, well over 150,000 euros is tied up in invoices and stock, while there is 48,200 euros in the bank. Every day that customers pay faster or stock moves faster, part of that comes free.

What a healthy level is

For that you look not at the amount but at the ratio. The current ratio is the current assets divided by the current liabilities; in the example 294,700 divided by 182,000, so 1.62. The rule of thumb is that you want to sit above 1.5, so that you can still meet your short-term obligations even when something goes wrong.

The quick ratio leaves stock out of the picture, because it does not always turn into cash quickly. There the rule of thumb is above 1. In the example that is 294,700 minus 62,000, divided by 182,000: 1.28.

Let's be honest: those rules of thumb differ quite a bit per industry. A wholesaler with a lot of stock is structurally in a different position than a service provider without stock, and a company that invoices in advance can run perfectly well with a low ratio. Statistics Netherlands publishes financial indicators per industry, but those cover all private and public limited companies in a sector. So compare your ratio mainly with your own history: is it moving in the right direction, or has it been declining for three quarters already?

DSO and DPO: the two sides of the same money

Working capital is a snapshot. DSO and DPO tell you how that snapshot comes about.

DSO (Days Sales Outstanding) is the average number of days your sales invoices remain outstanding before they are paid: the balance of your outstanding sales invoices, divided by the turnover in the period, times the number of days. DPO (Days Payables Outstanding) is the same for your purchase invoices: the balance of your outstanding purchase invoices, divided by the purchases, times the number of days.

In the example, with a quarterly turnover of 405,000 euros, the DSO is 184,500 divided by 405,000, times 91 days: 41 days. With 257,000 euros of purchases in the quarter, the DPO is 96,000 divided by 257,000, times 91: 34 days. Calculate turnover and purchases including VAT, because the outstanding invoices include it too.

So on average you pay your suppliers a week earlier than your customers pay you. You finance that week yourself, every month again. And if you hold stock, you also finance the days it sits on the shelf. Reverse the ratio between DSO and DPO and money is freed up structurally without you generating a single euro more in turnover.

Watch one calculation choice: take the balances from your outstanding items list, not from the Accounts Receivable and Accounts Payable ledger accounts. Those ledger accounts also contain entries that are not an invoice, such as a manual correction or a credit note that has not yet been settled, and these distort the average.

How to free up money from your working capital

  • Invoice faster. The clock on your DSO starts at the invoice date, not at delivery. Every day between delivery and invoice is a day you give away yourself.
  • Follow up more consistently. Our experience is that a fixed weekly routine for outstanding items does more for your DSO than stricter payment terms.
  • Don't pay too early. Make use of your suppliers' payment terms, unless there is a payment discount that yields more than the interest on your credit.
  • Tackle stock that sits still. Items that don't sell are money that doesn't come back. A list of the slowest-moving items with their stock value is often confronting, and useful for exactly that reason.

Every month from your administration

Everything above is in your balance sheet and your outstanding items, so you can recalculate it every month. In practice that only happens once the accountant asks about it during the annual accounts. The logical moment is the monthly closing, and there is a dedicated checklist as a dashboard for that, which first checks whether the month is complete.

The liquidity dashboard, one of the financial dashboards, shows your working capital per month, along with the DSO, the DPO and the age of your outstanding receivables and payables. The DSO and DPO come from the outstanding invoices, and the breakdown is based on the type of the general ledger account, so you do not need to connect a chart of accounts beforehand. The dashboard runs in Claude, connected through Exact AI Connect or the variant for AFAS and Twinfield.

We believe working capital should come up more often than once a year during the annual accounts. It is a figure you can already influence this month, without a single euro of extra turnover.

Want to try it yourself? Start for free with Exact AI Connect →

Try these questions in your own AI assistant

  • "Calculate my working capital and current ratio per quarter for the past two years."
  • "What is my DSO and DPO based on the outstanding invoices, and how do they compare?"
  • "Which ten products have the highest stock value and the lowest turnover rate?"
  • "How much money is freed up if my customers pay five days earlier on average?"

Benefits and points of attention

Benefits of tracking working capital every month: you see the direction instead of a single figure, you know where the money is tied up, and every improvement in DSO or stock shows up in the bank.

Points of attention: ratios differ by sector, so compare mainly against your own history. DSO and DPO from the general ledger balances give a distorted picture, so use the outstanding items. And for the dashboard you need the Analytics subscription and a paid Claude subscription.

Frequently asked questions

Subtract your current liabilities from your current assets. With 294,700 euros in debtors, stock and cash and 182,000 euros in current liabilities, the working capital comes to 112,700 euros. Leave out the bank and the credit and you get the operating working capital: debtors plus stock minus creditors.

No. A company that gets paid in advance and purchases afterwards, such as a webshop with quick turnover or a subscription business, can run healthily with negative operating working capital, because customers finance the operations. For a wholesaler or a project business, negative working capital is a warning sign.

Divide the balance of your outstanding sales invoices by the turnover over a period, then multiply by the number of days in that period. With 184,500 euros outstanding and 405,000 euros in turnover in a quarter of 91 days, you arrive at 41 days. Take the balance from your list of outstanding items, not from the general ledger account.

Liquidity is whether you can pay your bills in the short term; working capital is the amount you have available for that in current items. The current ratio expresses this as a ratio, and that is the figure a bank looks at when it talks about liquidity.

Every month, at the monthly close, and compared each quarter. A single measurement tells you little; the direction across four quarters tells you far more.