A business owner reviews the company's quarterly financial results.
Revenue is growing.
Operating expenses appear under control.
The income statement reports a positive operating result.
Yet the bank account tells a different story.
The company is struggling to pay suppliers.
Several customer invoices remain unpaid.
Inventory is accumulating.
Management is considering a short-term loan despite reporting a profit.
How can a profitable business be short on cash?
The answer often lies in the timing of cash movements and the amount of money tied up in working capital.
Revenue, profit, and cash flow describe different aspects of business performance.
Understanding those differences is essential for financial planning, operational decisions, and sustainable growth.
The Short Answer: Profit Is Not the Same as Cash
A company can recognize revenue before receiving payment.
It can purchase inventory before selling the products.
It can record expenses before paying suppliers.
These timing differences affect cash availability.
Under accrual accounting, the income statement measures financial performance according to recognition rules.
The cash flow statement measures actual cash inflows and outflows.
The U.S. Securities and Exchange Commission explains that income statements show whether a company earned a profit, while cash flow statements show whether it generated cash.
Source:
https://www.sec.gov/investor/pubs/begfinstmtguide.htm
Both measures are important.
Neither should replace the other.
A profitable company may consume cash during a period of rapid growth.
A company generating positive cash flow may also have weak underlying profitability.
The relevant management question is not simply whether profit and cash agree.
It is why they differ, whether the difference is temporary or persistent, and what the business should do about it.
Three Financial Concepts That Should Not Be Confused
Revenue
Revenue represents income recognized from selling goods or services according to the applicable accounting framework.
It is not necessarily the amount of cash collected during the same period.
Profit
Profit measures recognized revenue less the relevant recognized costs and expenses.
Different profit measures include gross profit, operating income, and net income.
These are not interchangeable.
Operating Cash Flow
Operating cash flow reflects cash generated or consumed by operating activities.
It is affected by operating receipts and payments, including movements in receivables, inventory, and payables.
The IFRS Foundation's IAS 7 guidance explains that operating cash flows can be reported using a direct method or an indirect method that adjusts accounting profit for noncash items and relevant timing differences.
Source:
https://www.ifrs.org/issued-standards/list-of-standards/ias-7-statement-of-cash-flows/
The practical implication is straightforward.
A sale can improve accounting revenue without immediately increasing cash.
A company needs both profitability analysis and cash-flow analysis to understand its financial position.
A Worked Example: $50,000 in Operating Income but Negative Cash Flow
Consider a hypothetical company over a 90-day quarter.
Its simplified income statement is:
| Financial Item | Amount |
|---|---|
| Revenue | $500,000 |
| Cost of goods sold | $300,000 |
| Operating expenses | $150,000 |
| Operating income | $50,000 |
The business reports $50,000 in operating income.
For this illustration, assume:
- No depreciation or amortization.
- No income taxes or interest payments.
- No other noncash income or expenses.
- No changes in other operating assets or liabilities.
- No investing or financing cash flows.
- All revenue is credit sales.
- All amounts use the same currency and reporting period.
These assumptions are deliberately simplified.
The example is not a complete audited financial statement or a substitute for applicable accounting standards.
Now examine the company's working capital.
| Balance Sheet Item | Beginning | Ending | Change |
|---|---|---|---|
| Accounts receivable | $120,000 | $200,000 | +$80,000 |
| Inventory | $100,000 | $130,000 | +$30,000 |
| Accounts payable | $70,000 | $95,000 | +$25,000 |
Each change has a different cash-flow implication.
Step 1: Accounts Receivable Consumed $80,000
Accounts receivable represents amounts customers owe the business.
At the beginning of the quarter:
Accounts receivable = $120,000.
At the end:
Accounts receivable = $200,000.
The increase is:
$200,000 - $120,000 = $80,000.
Under the simplified assumptions, the company recognized more credit sales than it collected in cash, increasing outstanding receivables by $80,000.
This reduces the cash generated from operations relative to accounting income.
The company may have earned the revenue, but it has not yet collected all the associated cash.
An increase in receivables is not automatically evidence of poor collection performance.
It may reflect legitimate sales growth, changes in customer mix, or contractual payment terms.
The reason must be investigated.
Step 2: Inventory Consumed Another $30,000
Inventory increased from $100,000 to $130,000.
The increase is:
$130,000 - $100,000 = $30,000.
The business has more resources tied up in unsold inventory.
Under the example's assumptions, this represents an additional $30,000 use of operating cash relative to the income statement.
Inventory growth may be intentional.
Management might be preparing for seasonal demand.
It might be building safety stock.
Or it might be purchasing ahead of an anticipated supplier disruption.
Alternatively, inventory may be accumulating because sales are weaker than expected.
The cash-flow effect is visible.
The business reason requires further analysis.
Step 3: Accounts Payable Provided $25,000 of Temporary Cash Support
Accounts payable increased from $70,000 to $95,000.
The change is:
$95,000 - $70,000 = $25,000.
Under the simplified model, the company has delayed or not yet made $25,000 of payments relative to recognized expenses and inventory purchases.
This increases current-period operating cash flow.
But it does not mean the company earned an additional $25,000.
The obligation remains.
Supplier invoices will eventually become due.
A growing payable balance can be a normal consequence of business expansion.
It can also signal payment pressure.
The interpretation depends on due dates, contractual terms, and payment behavior.
Step 4: Reconcile Operating Income to Operating Cash Flow
Now combine the movements.
Start with operating income:
$50,000.
Subtract the increase in receivables:
-$80,000.
Subtract the increase in inventory:
-$30,000.
Add the increase in payables:
+$25,000.
The simplified operating cash flow is:
$50,000 - $80,000 - $30,000 + $25,000
= -$35,000.
The result is:
| Component | Cash Flow Effect |
|---|---|
| Operating income | +$50,000 |
| Increase in receivables | -$80,000 |
| Increase in inventory | -$30,000 |
| Increase in payables | +$25,000 |
| Simplified operating cash flow | -$35,000 |
The company reports $50,000 in operating income but consumes $35,000 in operating cash.
The difference between those measures is:
$50,000 - (-$35,000)
= $85,000.
That $85,000 gap is explained by the net cash absorbed by the modeled working capital changes.
The business is not necessarily unprofitable.
Its cash conversion process is creating pressure.
This distinction changes the management response.
A profitability problem might require changes to pricing, costs, or business strategy.
A working capital problem may require better collections, inventory planning, supplier payment scheduling, or liquidity forecasting.
Some businesses face both problems simultaneously.
What Is Working Capital?
Working capital is commonly defined as:
Working Capital = Current Assets - Current Liabilities.
This broad definition includes cash and other current assets and liabilities.
For operating analysis, businesses often examine a narrower concept:
Operating Net Working Capital =
Operating Receivables + Inventory - Operating Payables.
This simplified operating measure excludes cash and financing-related balances.
It is useful for understanding how daily business activities tie up or release funds.
However, the exact definition should be documented.
Different financial models may include or exclude additional operating items such as accrued expenses, prepaid expenses, or deferred revenue.
The formula should not be treated as universally identical across all companies.
In our example:
Beginning operating net working capital:
$120,000 + $100,000 - $70,000
= $150,000.
Ending operating net working capital:
$200,000 + $130,000 - $95,000
= $235,000.
Increase:
$235,000 - $150,000
= $85,000.
The company has tied up an additional $85,000 in operating working capital.
This exactly reconciles the difference between the simplified operating income and operating cash flow.
How Long Does It Take Customers to Pay?
One useful metric is Days Sales Outstanding, commonly abbreviated DSO.
DSO estimates the number of days of sales represented by accounts receivable.
A simplified ending-balance formula is:
DSO =
Ending Accounts Receivable /
Credit Sales During the Period
× Number of Days in the Period.
Using the hypothetical company's quarter:
Ending receivables = $200,000.
Quarterly credit sales = $500,000.
Period length = 90 days.
Therefore:
DSO = ($200,000 / $500,000) × 90
= 36 days.
The ending receivable balance is equivalent to approximately 36 days of the quarter's average credit sales.
This is a useful descriptive indicator.
It does not mean every customer takes exactly 36 days to pay.
It is also not a direct calculation of the average elapsed time between invoice issuance and payment.
The estimate can be distorted by seasonality, changing sales levels, credit memos, overdue invoices, and customer concentration.
Some organizations use average accounts receivable rather than ending receivables.
Others calculate DSO using rolling periods or detailed invoice-level methods.
The definition must remain consistent when comparing performance over time.
What If Collections Improved by 10 Days?
Suppose management wants to understand the potential liquidity benefit of reducing DSO from 36 days to 26 days.
Assume:
- Credit sales remain $500,000 per 90-day quarter.
- The business operates at a stable sales run rate.
- The same receivables definition is used.
- All modeled receivables are collectible.
- There are no changes to discounts, bad debts, or other working capital balances.
Average daily credit sales are:
$500,000 / 90
= approximately $5,555.56.
A 10-day reduction in DSO corresponds to:
10 × $5,555.56
= approximately $55,556.
Under those assumptions, the business could release approximately $55,556 from receivables.
Its modeled ending receivables would decline from:
$200,000
to approximately:
$144,444.
This is a working capital release.
It is not additional revenue.
It is not additional operating profit.
The business is collecting cash sooner from sales already recognized.
If this improvement occurred within the same modeled quarter, with all other assumptions unchanged, operating cash flow would improve by approximately $55,556.
The original -$35,000 cash flow would become approximately +$20,556.
This is a hypothetical counterfactual scenario, not an observed result or a forecast supported by actual customer payment data.
Why Faster Collections Are Not Always Free
Management may attempt to improve collections by offering early-payment discounts.
Suppose customers are offered a discount for paying sooner.
The company might collect cash earlier.
But it also receives less revenue from qualifying invoices.
Whether the strategy creates value depends on the discount cost, financing alternatives, customer response, and operational consequences.
Similarly, stricter credit terms may reduce receivables but discourage some customers from purchasing.
A lower DSO does not automatically imply a better overall business outcome.
The appropriate decision should consider incremental economic value.
This is why working capital optimization should not be reduced to minimizing one KPI.
The Cash Conversion Cycle Connects Three Operating Processes
Another useful concept is the cash conversion cycle, or CCC.
A common simplified formula is:
Cash Conversion Cycle =
Days Inventory Outstanding
+ Days Sales Outstanding
- Days Payables Outstanding.
The components are:
DSO:
Days Sales Outstanding.
DIO:
Days Inventory Outstanding.
DPO:
Days Payables Outstanding.
Conceptually, the cash conversion cycle estimates the time between cash committed to operating resources and cash recovered through customer collections, after accounting for supplier payment timing.
A shorter cycle may reduce the amount of capital tied up in operations.
But the calculation requires consistent definitions.
DIO is often based on inventory relative to cost of goods sold.
DPO may use cost of goods sold as a proxy, although purchases can be a more appropriate denominator depending on the available data and purpose.
These differences matter.
A company should not compare cash conversion cycles across businesses without examining accounting definitions, operating models, and industry conditions.
The Office of the Comptroller of the Currency discusses receivables, inventory, payables, and trade-cycle analysis in its Accounts Receivable and Inventory Financing guidance.
Reference:
A Profitable Quarter Can Still Contain a Cash Shortage
Quarterly financial statements summarize activity across a period.
But supplier payments and payroll have specific due dates.
Suppose a business begins a four-week planning period with $40,000 in available cash.
Consider this separate hypothetical short-term forecast.
| Week | Cash Receipts | Cash Payments | Ending Cash |
|---|---|---|---|
| Opening | — | — | $40,000 |
| Week 1 | $55,000 | $70,000 | $25,000 |
| Week 2 | $45,000 | $75,000 | -$5,000 |
| Week 3 | $80,000 | $55,000 | $20,000 |
| Week 4 | $60,000 | $40,000 | $40,000 |
The business begins with $40,000 and ends with $40,000.
Net cash movement across the four weeks is zero.
Yet the forecast shows a $5,000 cash deficit at the end of Week 2.
That temporary shortfall may create a real liquidity problem even though the period-end balance appears healthy.
The table illustrates why timing matters.
A forecast that reports only monthly or quarterly totals can miss periods when the business cannot meet its obligations.
Actual cash balances may move within each week, so a production forecast should use the level of detail appropriate to payment deadlines.
What Should a 13-Week Cash Flow Forecast Include?
A rolling 13-week cash forecast is one possible management tool for monitoring near-term liquidity.
The forecast should begin with reconciled available cash.
It should then estimate cash receipts and payments by week.
Potential receipt categories include:
Customer invoice collections.
Cash sales.
Contractual payments.
Other verified operating receipts.
Potential payment categories include:
Payroll.
Supplier invoices.
Rent and facilities.
Taxes.
Debt service.
Capital expenditures.
Other scheduled obligations.
The forecast should distinguish confirmed cash movements from uncertain estimates.
A signed contract does not necessarily imply immediate collection.
An issued invoice does not guarantee payment on its due date.
An expected customer payment should be modeled using evidence about collection behavior, contractual terms, and current account status.
The forecast should also reconcile to bank and accounting records.
A model that produces plausible numbers but cannot be reconciled is difficult to trust.
Why Invoice-Level Data Is More Useful Than a Single DSO Number
DSO provides a summary.
Invoice-level data can explain the summary.
Consider two companies with the same DSO.
Company A may have many invoices paid a few days late.
Company B may have most customers paying promptly but one large customer carrying a severely overdue balance.
Their DSO values may be similar.
Their liquidity risks may differ substantially.
A practical receivables analysis should examine:
- Invoice issuance date.
- Payment due date.
- Original invoice amount.
- Applied payments.
- Credit memos.
- Outstanding balance.
- Customer identifier.
- Contractual payment terms.
- Payment history.
- Disputed invoices.
- Collection status.
This makes it possible to construct aging buckets and estimate expected receipts.
For example:
- Not yet due.
- 1–30 days overdue.
- 31–60 days overdue.
- 61–90 days overdue.
- More than 90 days overdue.
The buckets should be based on a clearly defined reporting date.
Invoices must not be duplicated by joining invoice headers directly to multiple payment or line-item records without proper aggregation.
A dashboard can show incorrect receivables even when the SQL query executes successfully.
For more on this analytical problem, see:
Why Your Dashboard Numbers Don't Match: The Data Quality Problem Behind Business Analytics
Why Collection Forecasts Need Historical Validation
A company may assume that every invoice will be paid on its due date.
That assumption can produce an overly optimistic cash forecast.
A better approach may estimate payment timing using historical invoices and actual collection events.
For example, the business could analyze the proportion of invoice value collected within 15, 30, 45, and 60 days.
The analysis should account for invoices that have not yet completed their payment observation period.
It should also distinguish partial payments, disputed balances, write-offs, and credit adjustments.
Customer characteristics may matter.
Large enterprise customers may have different payment schedules from smaller clients.
Seasonal purchasing patterns may also influence collection timing.
However, an observed relationship does not automatically establish a causal explanation.
For example, if enterprise customers have longer payment delays, that does not prove their size causes those delays.
Contractual terms, invoice approval procedures, transaction size, and industry characteristics may also contribute.
The model should distinguish descriptive patterns from causal claims.
How to Build a Working Capital Analytics Dashboard
A useful dashboard can connect accounting records with operational decisions.
| Metric | Business Question |
|---|---|
| Operating cash flow | Are operations generating or consuming cash? |
| Accounts receivable | How much recognized revenue remains uncollected? |
| Receivables aging | Which balances are becoming overdue? |
| DSO | How much sales activity is represented by outstanding receivables? |
| Inventory balance | How much capital is tied up in stock? |
| DIO | How long is inventory held relative to the selected cost base? |
| Accounts payable | What obligations remain unpaid? |
| DPO | How long does the business take to pay suppliers under the chosen definition? |
| Cash conversion cycle | How do operating timing differences interact? |
| Forecast minimum cash | When could liquidity become insufficient? |
The dashboard should not merely display these metrics.
It should allow users to investigate their drivers.
For example, a rising DSO might be traced to a specific customer group, aging bucket, product line, or change in payment terms.
A declining cash balance might reflect higher inventory purchases, delayed collections, or scheduled debt payments.
The next analytical step depends on the underlying cause.
Data Quality Is Essential for Cash Forecasting
Financial analytics often combines accounting systems, CRM platforms, inventory databases, and payment records.
These systems may represent transactions differently.
A CRM opportunity is not an invoice.
An invoice is not a cash receipt.
A payment authorization is not necessarily a settled payment.
A purchase order is not necessarily an accounts payable liability.
These distinctions must be preserved in the data model.
Useful validation checks include:
- Reconciliation of receivables to the accounting ledger.
- Reconciliation of cash to bank records.
- Detection of duplicate invoices.
- Validation of payment allocation.
- Consistent reporting cutoffs.
- Correct handling of refunds and credit memos.
- Explicit treatment of foreign currencies.
- Validation of outstanding invoice balances.
For a related framework, see:
Before You Trust the Dashboard: Data Quality Checks Every Analytics Pipeline Needs
A financial dashboard should be built on reconciled records rather than simply combining whatever values are available.
Can Analytics Prove That a Collection Policy Improved Cash Flow?
Suppose management introduces automated invoice reminders.
Over the next three months, DSO declines from 36 days to 29 days.
Did the reminders cause the improvement?
Not necessarily.
The customer mix may have changed.
A large overdue invoice may have been paid.
Seasonal sales may have affected the ratio.
Payment terms may have changed.
The company may have offered discounts.
A before-and-after comparison alone cannot separate these explanations.
A credible evaluation would consider appropriate comparison groups, timing, policy eligibility, and alternative explanations.
Where practical and appropriate, the business could evaluate different reminder processes across comparable customer groups.
The objective would be to estimate whether the policy caused earlier collections, not merely whether collections improved after implementation.
A causal evaluation should also consider customer experience, costs, and possible changes in future sales.
The distinction between association and causation remains important even when the outcome is cash.
A Practical Six-Step Working Capital Framework
1. Reconcile the Financial Baseline
Begin with the income statement, balance sheet, cash flow statement, and bank records.
Confirm the reporting period and accounting definitions.
2. Identify the Working Capital Movements
Calculate changes in receivables, inventory, payables, and other relevant operating balances.
Separate operating effects from investing and financing activities.
3. Diagnose the Drivers
Analyze invoice aging, collection patterns, inventory turnover, purchasing schedules, and payment terms.
Avoid assuming that every increase in receivables represents a collection failure.
4. Forecast Cash Timing
Create a rolling short-term forecast with expected receipts, scheduled payments, and a clearly defined starting cash balance.
Identify the lowest projected cash balance, not only the period-end total.
5. Evaluate Alternatives
Compare collection improvements, inventory policies, payment schedules, financing options, and other relevant actions.
Include costs, operational constraints, and uncertainty.
6. Monitor Actual Outcomes
Compare realized collections and payments against the forecast.
Investigate material differences.
Update assumptions as new evidence becomes available.
The goal is not to eliminate every working capital requirement.
It is to understand the amount, timing, and business value of capital committed to operations.
Frequently Asked Questions
Can a profitable business have negative cash flow?
Yes. Accounting income and cash flow differ because of timing, noncash items, and movements in operating assets and liabilities. A company can recognize profit while cash remains tied up in receivables or inventory.
Does an increase in accounts receivable reduce cash flow?
Under the simplified indirect cash-flow reconciliation, an increase in operating receivables reduces operating cash flow relative to income, assuming other effects are unchanged.
Is a lower DSO always better?
Not necessarily. Faster collections can improve liquidity, but stricter credit terms or payment discounts may introduce costs or affect customer relationships. The economic trade-off should be evaluated.
What is the cash conversion cycle?
It is a working capital measure commonly calculated as DIO plus DSO minus DPO. It summarizes selected operating timing relationships, subject to consistent definitions and data.
Is working capital the same as cash?
No. Working capital generally refers to current assets minus current liabilities. Operating net working capital is a narrower measure of selected operating balances. Neither is identical to available cash.
How often should a cash flow forecast be updated?
The appropriate cadence depends on liquidity risk, transaction volume, payment deadlines, and business needs. A company facing near-term cash pressure may require more frequent updates than a company with substantial liquidity reserves.
Can SQL and BI tools help forecast cash flow?
Yes. SQL can help organize invoices, payments, inventory, and other records. BI tools can visualize trends, aging, scenarios, and projected balances. Reliable results still require accurate definitions, reconciled data, and defensible forecasting assumptions.
The Bottom Line: Profitability and Liquidity Require Different Questions
Return to the hypothetical business.
Quarterly revenue is $500,000.
Operating income is $50,000.
But receivables increase by $80,000.
Inventory increases by $30,000.
Payables increase by $25,000.
The result is a simplified operating cash outflow of $35,000.
The company is profitable under the modeled income statement, but it is consuming cash through its working capital cycle.
A hypothetical 10-day reduction in DSO could release approximately $55,556 under stable sales and collection assumptions.
That would improve liquidity, not create new operating profit.
The distinction is essential.
Revenue measures recognized business activity.
Profit measures financial performance under accounting rules.
Cash flow measures the movement of cash.
Working capital analytics helps connect these perspectives.
A business that understands its cash conversion process can make more informed decisions about collections, inventory, supplier payments, and financing.
The most useful question is not simply:
"Are we profitable?"
It is:
"Where is our cash tied up, when will it become available, and what decisions could improve the situation?"
That is where working capital analysis becomes practical business decision support.
References and Methodological Notes
- U.S. Securities and Exchange Commission. Beginners' Guide to Financial Statement. February 4, 2007. https://www.sec.gov/investor/pubs/begfinstmtguide.htm
- IFRS Foundation. IAS 7 Statement of Cash Flows. Official standards overview. https://www.ifrs.org/issued-standards/list-of-standards/ias-7-statement-of-cash-flows/
- Office of the Comptroller of the Currency. Comptroller's Handbook: Accounts Receivable and Inventory Financing. Trade Cycle Analysis guidance. https://www.occ.gov/publications-and-resources/publications/comptrollers-handbook/files/accts-rec-inventory-financing/pub-ch-accts-rec-inventory-financing.pdf
- UAD Consulting. Why Your Dashboard Numbers Don't Match: The Data Quality Problem Behind Business Analytics. https://www.uadconsulting.com/why-dashboard-numbers-dont-match
- UAD Consulting. Before You Trust the Dashboard: Data Quality Checks Every Analytics Pipeline Needs. https://www.uadconsulting.com/data-quality-checks-analytics-pipelines
Methodological Note
All financial amounts, company circumstances, payment scenarios, and forecasts are hypothetical educational illustrations.
They are not actual UAD Consulting client results or financial advice.
The quarterly cash-flow bridge assumes no depreciation, amortization, taxes, interest, other noncash items, additional operating balance changes, or investing and financing activities.
The simplified operating income-to-cash reconciliation is not presented as a complete statement of cash flows prepared under a specific accounting standard.
The DSO calculation uses ending accounts receivable divided by quarterly credit sales, multiplied by 90 days.
This is an ending-balance DSO proxy, not a measured average invoice collection duration.
The 10-day collection improvement assumes a stable credit-sales run rate and unchanged other conditions.
The estimated $55,556 release is a scenario calculation, not a guaranteed result.
The four-week cash forecast is a separate hypothetical example illustrating payment timing.
The article does not claim that historical correlations establish causal effects of collection policies.
Actual working capital recommendations require reconciled accounting data, appropriate financial definitions, uncertainty analysis, and professional review where relevant.
Turn Financial Data Into Better Business Decisions
Understanding profitability is only part of the picture. UAD Consulting helps organizations connect financial and operational data, develop reliable KPIs, investigate performance drivers, and build decision-focused reporting and analytical models.
Explore ServicesGet in Touch