What is working capital?
Working capital is the money a company has available to fund its day-to-day operations, measured as current assets minus current liabilities. Current assets are what converts to cash within a year (cash, receivables, inventory); current liabilities are what comes due within a year (payables, short-term debt). Positive working capital means a company can cover its near-term obligations; negative working capital is a liquidity warning.
How to calculate working capital
Working Capital = Current Assets – Current Liabilities
Worked example:
- Current assets: $4,000,000
- Current liabilities: $2,500,000
- Working capital: 4,000,000 – 2,500,000 = $1,500,000
Some teams also track the working capital ratio (current assets divided by current liabilities), which expresses the same relationship as a multiple rather than a dollar amount.
Working capital in Power BI (DAX)
The pattern depends on how your balance sheet accounts are modeled. A common approach references a base measure for each total:
Current Assets = CALCULATE ( [Account Balance], Accounts[Class] = "Current Asset" )
Current Liabilities = CALCULATE ( [Account Balance], Accounts[Class] = "Current Liability" )
Working Capital = [Current Assets] - [Current Liabilities]CALCULATE filters the ledger to the right account class. Replace the table, column, and class names with the ones in your model.
What is a good level of working capital?
Enough to cover obligations with a cushion, without tying up so much cash that it sits idle. A very high balance can mean slow-moving inventory or uncollected receivables rather than strength; a thin or negative balance can signal strain. As with most metrics, the trend and the composition matter more than a single figure.
Working capital vs cash flow
Working capital is a snapshot of liquidity at a point in time. Cash flow is the movement of cash over a period. A company can show healthy working capital on paper while still running short on cash if too much is locked in inventory or receivables. Reading them together gives the real picture.
Common working capital reporting pitfalls
The figure drifts when accounts are classified inconsistently as current or long-term, when intercompany balances are not eliminated, or when receivables and payables are pulled at different cut-off dates. Across multiple systems, the same balance can land in different buckets, which changes the result.
Reporting working capital from your ERP data
Working capital draws on receivable, payable, inventory, and cash accounts that often sit in different ERP modules or separate systems. When account classification is not consistent, the number shifts by report. A governed data foundation classifies each account once so working capital reads the same everywhere. QuickLaunch ships pre-built models for JD Edwards, Vista, NetSuite, and OneStream that surface balance sheet figures directly from the ledger.
Frequently Asked Questions
How is working capital calculated?
Subtract current liabilities from current assets. A company with $4M in current assets and $2.5M in current liabilities has $1.5M in working capital.
What is the difference between working capital and the current ratio?
Working capital is a dollar amount (assets minus liabilities); the current ratio is the same relationship as a ratio (assets divided by liabilities).
Is negative working capital always bad?
Not always. Some businesses with fast inventory turnover and favorable payment terms run on negative working capital by design, but for most companies it signals liquidity strain.
