A profitable business can still struggle to pay its bills when cash is tied up in stock and unpaid invoices. Working capital analysis explains this timing gap. By examining inventory, receivables and payables together, managers can identify where money is committed and choose improvements without damaging customer service or supplier relationships.
Follow the timing of cash
Net working capital equals current assets minus current liabilities. Current assets include cash, inventory and amounts owed by customers. Current liabilities include short-term obligations such as amounts owed to suppliers. This is a monetary measure at a particular date, not a ready-to-spend cash balance.
This article focuses on inventory, trade receivables, meaning amounts customers owe, and trade payables, meaning amounts owed to suppliers. When these items become cash receipts and payments explains an important part of the gap between profit and cash.
Revenue recognition and cash collection do not always occur together. A credit sale may contribute to reported profit before the customer pays. Inventory can require payment before it is sold, while supplier terms may delay the outflow. These differences explain why profit alone cannot establish the cash available for next week’s obligations.
For a cash forecast, add expected receipts to opening available cash, then subtract expected payments. The result is forecast closing cash; each amount must be linked to its expected date. Include taxes, financing and capital expenditure in the cash forecast where applicable, even though they are not all components of the operating cash cycle. Keep the forecast separate from the profit statement and reconcile their differences.
Read the cash conversion cycle carefully
The cash conversion cycle (CCC) equals inventory days plus receivables days minus payables days. It estimates the interval between paying suppliers and collecting from customers, rather than the number of days overdue.
For a trading business, calculate inventory days as average inventory value divided by cost of sales, multiplied by days in the period. Calculate receivables days as average trade receivables divided by the period’s credit sales, multiplied by its number of days. For payables days, divide average trade payables by the period’s credit purchases, then multiply by its number of days.
Use consistent periods and definitions. A simple average adds opening and closing balances and divides the result by 2. Use more frequent observations when balances change substantially during the period. If total sales or cost of sales are used as substitutes because credit data are unavailable, disclose the limitation. A service business with little inventory may need different operational measures. Seasonality, rapid growth and year-end balances can distort a simple annual average.
Hypothetical example: measuring timing in days
| Illustrative measure | Days |
|---|---|
| Inventory held | 45 |
| Customer collection | 35 |
| Supplier payment | 30 |
| Cash conversion cycle | 50 |
The calculation is 45 + 35 − 30 = 50 days. These fictional figures describe timing; they do not mean the company has 50 days of cash available. Estimating funding needs also requires the value and pattern of purchases, sales and other payments. A shorter cycle can help, but should not be pursued at any cost.
Cash cycle: hypothetical example
45 + 35 − 30 = 50
Result: 50 days
Investigate overdue invoices by cause
Review a receivables ageing report by customer and invoice. It groups balances by how long they have been outstanding or overdue. State whether the age starts at the invoice date or the due date. Then separate disputes, missing documents, credit problems and administrative delays. Assign an owner and next action to material items. A reminder cannot resolve an invoice that lacks an approved delivery record.
Monitor invoice accuracy and time from delivery to billing, not only collection days. Agree credit limits and approval rules appropriate to the business. Record disputed balances separately from ordinary overdue amounts so management can see whether the problem lies in sales terms, fulfilment or collection.
Release inventory without breaking service
Segment inventory by demand, replenishment lead time and operational importance. Investigate slow-moving items, duplicate purchasing and inaccurate stock records. Reducing every item by the same percentage can create shortages while leaving obsolete stock untouched.
Review the financial effect of disposal or discounting before acting. Writing down an unsaleable item’s accounting value does not create cash; it changes the recorded value. Collecting proceeds from a sale affects cash according to the price and payment date. Where possible, improve ordering and forecasting so the problem does not recur. Check service failures and expedited freight alongside stock reductions to see whether costs have merely moved elsewhere.
Manage supplier terms deliberately
Use agreed payment terms and accurate due dates. Extending payment unilaterally can damage supply continuity and may breach contractual obligations. Evaluate negotiated terms, early-payment discounts and supplier resilience together. The longest payment period is not automatically the best commercial outcome.
A fictional retailer reduces excess stock but pays a critical supplier late, causing missed deliveries. Its cash-cycle indicator improves briefly while sales are lost. This illustrates why the indicator needs operational context and why finance and operations should review actions together.
Locate the week when cash becomes insufficient
Consider a separate fictional weekly forecast in AED. Opening available cash is 20,000, expected customer receipts are 15,000 and scheduled payments are 28,000. The calculation is 20,000 + 15,000 − 28,000 = AED 7,000.
If 10,000 of the receipts moves to the following week, receipts for this week fall to 5,000 and 20,000 + 5,000 − 28,000 = −3,000, a shortfall of AED 3,000. The annual profit and the 50-day cycle do not answer this timing question.
Check due dates inside the week as well. A receipt expected on Friday cannot fund a payment due on Monday unless another available source covers the interval. A positive weekly closing balance can therefore conceal an earlier shortage. For a tight period, review daily movements and distinguish unrestricted available cash from amounts that cannot be used for the payment in question.
The collections owner verifies the delayed customer's position and supporting evidence. Finance assesses the gap and authorised options. Do not insert an unapproved overdraft, uncertain sale or postponed supplier payment merely to make the forecast balance. If a supplier agrees to reschedule, document the agreement and reflect the payment in the new week, rather than deleting it. Assign someone to follow up the agreed action before the payment becomes due.
At the next review, compare forecast receipts and payments with actual movements using the same categories. Separate a timing difference from a permanent loss, a missing payment or a duplicate entry. Keep the previous forecast so that repeated optimism remains visible. This example illustrates a review method, not a recommendation for a particular borrowing or payment decision.
Build a practical weekly review
Use a rolling cash forecast: when one week ends, add a new week at the end of the forecast horizon. Name owners for major receipts and payments, and use previous forecast differences to improve dates and assumptions. Use scenarios for uncertain receipts rather than treating every invoice as certain cash. Escalate projected shortfalls early enough to consider realistic actions.
Choose one recurring cause of tied-up cash and assign a corrective action. ATMACSS business and operations modelling can help connect purchasing, billing and collection processes. This operational analysis supports decisions; it does not replace an audit or tailored accounting and financing advice.