How to Calculate Working Capital: Balance Sheet to Cash

Your balance sheet can show positive working capital while the bank balance is too small for Friday's payroll. The calculation includes more than cash: customers may still owe you, stock may remain unsold, and prepaid expenses cannot necessarily be converted into a payment today. The useful question is both how much working capital the business reports and when its resources become spendable.

This guide calculates a small-business working-capital position, separates it from operating cash, and tests the payment calendar. It applies to inventory businesses and invoice-based services. All USD amounts are invented planning examples, not benchmarks, lending criteria or recommended reserve amounts.

Quick answer: working capital equals current assets minus current liabilities

Working capital = current assets − current liabilities. If current assets total $62,000 and current liabilities total $38,000, working capital is $24,000. This is a balance-sheet amount at a stated date, not $24,000 available in the bank and not a period's profit.

We use “working capital” to mean this standard net balance. Some reports use gross working capital for current assets alone, or an operating working-capital definition that excludes cash and financing debt. Write the definition on your worksheet before comparing results from different tools.

Start with a balance sheet and reconciled detail

Use the same reporting date for assets and liabilities. A quarter-end inventory value combined with today's payable balance is not a consistent snapshot. Reconcile cash to the bank, receivables to the customer ledger, stock to counted inventory and obligations to the payable, payroll, tax and debt records.

For the usual simplified classification, current items relate to the next year or operating cycle. Use your applicable accounting classification when the operating cycle or financing arrangements are different. Long-term equipment is not made a current asset because you hope to sell it quickly. Conversely, the current portion of a long-term borrowing belongs among current obligations when your reporting rules classify it that way.

Do not net every balance informally. A tax refund expected later and a tax payment due tomorrow can have different cash timing even when they seem to offset. Keep restrictions and currency differences visible; translate currencies consistently for the financial snapshot and schedule cash in the currency in which it must be paid.

Worked example: $24,000 working capital and only $8,000 cash

Assume the following reconciled balance sheet. Receivables and inventory are already stated at the values appropriate to this illustrative report; there are no other current items.

Working capital is $62,000 − $38,000 = $24,000. The business has more current assets than current liabilities at this date. However, $54,000 of current assets is outside cash. Receivables require collection, inventory requires sale or another realization, and the prepaid amount is a benefit already purchased rather than a bank balance.

This is why a healthy-looking difference cannot replace a cash forecast. The quality and timing of the current assets matter as much as the headline total. Compare the position with the actual due dates and the reliability of expected receipts.

Compare working capital with the current and quick ratios

The current ratio uses the same totals but a different operation: current assets ÷ current liabilities. Here it is $62,000 ÷ $38,000 = 1.63, rounded. Working capital is a dollar difference; the current ratio is a ratio. They should not share the same cell label.

For a stricter liquidity check in this guide, quick assets include cash and collectible trade receivables, and would include eligible short-term liquid investments if present. We exclude inventory and prepaid expenses. Quick assets here are $30,000, and the quick ratio is $30,000 ÷ $38,000 = 0.79, rounded. Other published quick-ratio variants use different exclusions, so preserve the definition when comparing results.

No single ratio guarantees that every bill can be paid. A mostly cash business with fast stock turnover differs from a slow project business with long credit terms. A ratio improvement created by doubtful receivables is different from an improvement created by cleared cash. If current liabilities are zero, these division-based ratios are undefined; working capital itself still equals current assets.

Use a dated cash test before spending the reported cushion

Return to the $8,000 bank balance. Suppose $6,000 payroll is due on day one, a $7,000 supplier payment on day two and $4,000 taxes on day three. A $12,000 customer receipt clears on day five. Assume no other transactions and that the receipt is not available early.

The negative balances identify an unfunded requirement; the table does not assume an overdraft is available. The lowest modeled balance is −$9,000. If the owner separately chooses a $3,000 reserve, the schedule requires $12,000 additional available cash or a verified change in receipt/payment timing to preserve it. That reserve is an illustrative choice.

Ending with $3,000 does not erase the earlier shortage. Confirm timing with the relevant parties before moving a payment or treating an expected collection as certain. The weekly cash forecast guide provides a rolling layout; expand tight weeks into individual dates. The cash runway calculator models constant monthly flows and is not a substitute for this event calendar.

Why better cash availability may leave working capital unchanged

Consider each following transaction independently from the original $62,000/$38,000 snapshot. Assume no new profit, fee or valuation adjustment.

Collecting an invoice can make payroll easier without increasing the net balance-sheet amount. Buying stock for cash can make payroll harder without reducing it. Financing can change payment timing and liquidity while also creating an obligation. These are classification illustrations, not financing recommendations.

If instead a $6,000 inventory write-down is recognized with no offsetting current item, working capital falls to $18,000 while cash remains $8,000 at that moment. A loss of asset value and a cash payment are different events. Check required allowance or valuation adjustments before relying on an old balance.

Define operating working capital before comparing it

For a narrow trade-cycle view, use trade receivables + inventory − trade payables. The original example gives $22,000 + $30,000 − $18,000 = $34,000 tied up under that particular definition. It excludes cash, borrowing, prepaid expenses, accrued wages and taxes; it is not the $24,000 standard net working-capital balance.

A broader operating definition might include additional operating current assets and liabilities. Do not compare the narrow $34,000 with another report's broader number as though one must be wrong. List the included accounts and reconcile the bridge. This is especially useful when a lender, valuation model and internal dashboard all use “working capital” differently.

Inventory businesses need both stock and supplier timing. Invoice-based services may have little merchandise stock but substantial receivables and payroll obligations. The DSO guide translates receivables into a consistent days measure, while the COGS guide separates the cost sold from the cost still in stock.

Test the working-capital effect of faster growth

In an independent steady-sales scenario, a service business makes $60,000 net credit sales over 30 days, or $2,000 per day. At a modeled 30-day receivable cycle, the associated balance is $60,000. At 45 days it is $90,000: $30,000 more sales value remains in receivables under unchanged daily sales.

This is an exposure estimate, not automatically $30,000 of extra payroll cost or a guaranteed financing need. A cash forecast must include actual margins, payroll, supplier dates, deposits, tax payments and existing cash. Growth can create more receivables before collections catch up even when each job has positive contribution.

For ecommerce, larger purchase batches may tie up cash before stock sells. A discount that moves stock can also reduce contribution or increase fulfillment cost. Check replenishment cash and holding-cost economics together rather than optimizing one balance alone.

Build a repeatable working-capital worksheet

Put current asset balances in B2:B5 and current liabilities in D2:D5. Add a date and source reference beside every line. Then use:

• Total current assets, B6: =SUM(B2:B5).
• Total current liabilities, D6: =SUM(D2:D5).
• Working capital, B8: =B6-D6.
• Current ratio, B9: =IF(D6>0,B6/D6,NA()).
• Quick ratio, B10: =IF(D6>0,(B2+B3)/D6,NA()), assuming B2 is eligible cash and B3 collectible trade receivables with no other quick assets.

Those cells calculate the stated snapshot, not future payment feasibility. Add separate columns for expected realization or due date, restrictions and overdue status. Do not apply the B2+B3 quick formula blindly if the account layout changes. Reconcile the next reporting date with the same definitions and explain changes in stock, invoices and obligations.

Turn the result into a specific review

1. Identify the assets that will become usable cash before the next major payments.
2. Review overdue or disputed invoices individually rather than applying an optimistic average date.
3. Check stock aging and upcoming purchase commitments before assuming inventory is liquid.
4. Map payroll, tax, debt and supplier dates against realistic collections.
5. Test the downside case with a delayed receipt and preserve the forecast you compared it with.

Positive working capital is a starting position, not spending permission. Negative working capital deserves a close look at timing, turnover, customer advances and current obligations; it does not by itself prove insolvency or establish a financing solution. Use the cash-versus-profit guide to reconcile the different questions.

Sources and definition boundaries

The scenarios and worksheet are original illustrations. OpenStax's working-capital chapter explains current assets, obligations and liquidity limitations. CFI describes the working-capital formula. BDC's cash-flow planning guidance supports a dated forecast alongside balance-sheet analysis. Keep your applicable reporting classifications and agreement dates separate from these fictional amounts.