Cash Flow Analysis: Ratios and Examples

Using the operating cash flow, capital expenditures, and current liabilities from the report, calculate the operating cash flow ratio, free cash flow, and cash conversion cycle. QuickBooks Online does not calculate these automatically, so this step happens outside the software.

At this point, look for specific patterns that most often signal a real problem: a shrinking operating cash flow ratio or a lengthening cash conversion cycle. A financing category propping up an otherwise negative total is another red flag. A common pattern is growing operating cash flow with negative free cash flow, which often means capital spending outpacing internal cash generation. Another pattern to watch: receivables growing faster than revenue and operating cash flow. That turns paper sales into a cash flow drain until invoices are collected.

Cash flow analysis is only useful if it leads somewhere. A declining operating cash flow ratio might mean it is time to tighten collections. A lengthening cash conversion cycle might point to a receivables policy that needs adjusting. Positive free cash flow might support a reinvestment decision.

Here is what this process looks like applied to actual numbers. A small service business pulls its Statement of Cash Flows from QuickBooks Online for Q1 and Q2.

At a glance, the business looks stronger in Q2. Total cash increased from $16,000 to $22,500. Breaking it down by category tells a different story. Operating cash flow dropped by half, from $18,000 to $9,000. The only reason total cash still increased is a $15,000 financing inflow, most likely a loan or line of credit draw. Without that financing activity, the cash position would have declined quarter over quarter.

Running the ratios confirms the concern. The operating cash flow ratio dropped from 1.5 to 0.8, meaning operating cash flow no longer covers current liabilities. Free cash flow fell from $12,000 positive to $3,000 negative. The cash conversion cycle lengthened from 45 days to 60 days. Every ratio points the same direction. The business is not in trouble yet. The Q2 numbers only look healthy because of a financing draw covering for weaker operations. Without the analysis, that would be easy to miss since the top-line cash balance is climbing.

The software used does not change the methods. QuickBooks Online generates the Statement of Cash Flows with the operating, investing, and financing split already done. Xero produces a similar report. Neither calculates the ratios automatically. A spreadsheet can run the calculations. The tradeoff with a spreadsheet is that categorizing transactions by hand takes time as transaction volume grows.

Common pitfalls include treating a high total cash balance as proof of strong operations. A company can have plenty of cash in the bank while its core business burns money, propped up by debt draws. Ignoring working capital changes is another mistake. An increase in accounts receivable or inventory consumes cash even if revenue is growing. Overlooking that shift can make operating cash flow look healthier than it really is. A third pitfall is using a cash flow statement prepared on the direct method without adjusting for actual cash received from customers. The direct method shows actual cash collections and payments, which is more informative for small businesses than the indirect method that starts with net income.

Frequently asked questions: What is a good operating cash flow ratio? A ratio above 1.0 means operating cash flow covers current liabilities without relying on financing. Consistently below 1.0 is worth a closer look. Can a profitable business have negative cash flow? Yes. Profit reflects revenue minus expenses on paper, including unpaid invoices. Cash flow reflects money that has actually moved. A business can be profitable and run short on cash if collections lag. How often should cash flow analysis be run? Monthly is typical. Businesses with tight margins or seasonal swings often benefit from reviewing more frequently. Which software is best? QuickBooks Online and Xero both generate a clean statement. A spreadsheet fills the gap for ratio calculations.