Blog · Finance metrics and formulas · Finance and FP&A teams
Cash turnover compares revenue with the average cash balance supporting the period. Calculate it from matched financial exports, check the denominator, and separate sales growth from a shrinking liquidity buffer.
The cash turnover ratio is revenue divided by average cash and cash equivalents for the same period. It measures sales supported by each dollar of average cash, rather than the number of times cash physically moves through a bank account. A rising ratio deserves two questions: did revenue grow, and did the liquidity buffer shrink?
Cash turnover ratio = Revenue for the period / Average cash and cash equivalents
Simple average cash = (Opening cash and cash equivalents + Closing cash and cash equivalents) / 2
Report the result in times, with the period attached: monthly turns, quarterly turns, or annual turns. Revenue accumulates over time, while cash is a balance. The SEC's financial statement guide distinguishes income statements covering a period from balance sheets showing a position at a particular date. Averaging cash makes that balance more representative of the revenue period.
Use revenue after returns, discounts, and allowances, reconciled to the income statement. Include both cash and credit sales. The ratio describes revenue relative to cash holdings; substituting customer receipts would create a separate receipts-to-cash measure.
It also differs from the cash conversion cycle, which measures days rather than turns. Do not use the two names interchangeably in a management pack.
Finance needs revenue by period and cash balances at matching boundaries. A bank statement alone does not provide recognized revenue, and a sales invoice register may omit revenue adjustments recorded in the ledger.
| Field | What to bring | Check before calculating |
|---|---|---|
| Reporting period | Month, quarter, or fiscal year | Same start and end dates throughout |
| Net revenue | Income statement or mapped ledger rows | Tie to the approved revenue subtotal |
| Opening cash | Prior closing balance for included accounts | Tie to the opening balance sheet |
| Closing cash | Current closing balance for included accounts | Tie to reconciled cash accounts |
| Cash definition | Included cash and equivalent accounts | Apply the same mapping every period |
Use the company's documented classification of cash equivalents. Keep separately reported investments outside this denominator unless the policy expressly includes them and the label says so. Avoid expanding the definition in a month when cash happens to look low.
For liquidity analysis, identify restricted balances separately. Regulation S-X's balance sheet rules require separate disclosure of cash items restricted as to withdrawal or usage. The example below uses unrestricted cash and cash equivalents; a comparison that includes restricted cash needs a clear label and an availability warning.
An illustrative US distributor compares the first three months of 2026. Opening cash equals the prior month's closing cash. All revenue and balances are USD.
| Month | Net revenue (USD) | Opening cash (USD) | Closing cash (USD) | Average cash (USD) | Cash turnover |
|---|---|---|---|---|---|
| January | 1,200,000 | 400,000 | 500,000 | 450,000 | 2.67 times |
| February | 1,200,000 | 500,000 | 300,000 | 400,000 | 3.00 times |
| March | 1,500,000 | 300,000 | 450,000 | 375,000 | 4.00 times |
Average cash is the mean of the opening and closing balances. Ratios are rounded to two decimal places; calculations retain the unrounded values.
For January, (400,000 + 500,000) / 2 = 450,000. Dividing revenue of 1,200,000 by average cash of 450,000 gives 2.67 times after rounding. For March, the same method gives 1,500,000 / 375,000 = 4.00 times.
If revenue is in B2, opening cash in C2, and closing cash in D2, the spreadsheet formulas are:
Average cash in E2: =(C2+D2)/2
Cash turnover in F2: =IF(E2>0,B2/E2,NA())
A missing balance should remain missing until it is resolved. Treating a blank as zero can manufacture an apparently strong turnover ratio from an incomplete export.
The calculation must satisfy this identity:
Average cash × Unrounded cash turnover = Revenue
| Month | Check using unrounded turnover | Reconstructed revenue (USD) | Difference from reported revenue (USD) |
|---|---|---|---|
| January | 450,000 × (1,200,000 / 450,000) | 1,200,000 | 0 |
| February | 400,000 × (1,200,000 / 400,000) | 1,200,000 | 0 |
| March | 375,000 × (1,500,000 / 375,000) | 1,500,000 | 0 |
Using the displayed rounded January ratio will create a rounding difference, so validate against the stored quotient. Then complete the independent checks: monthly revenue ties to the income statement, cash accounts tie to the balance sheet, and each opening balance equals the previous closing balance.
This proves the arithmetic and continuity. It does not prove that the endpoints represent typical cash holdings during the month. A large middle-of-month receipt or payment can still make the simple average misleading.
February's ratio rises from January's even though revenue is unchanged. Average cash falls from $450,000 to $400,000. The higher turnover therefore comes from a smaller cash balance, with no sales improvement demonstrated.
March combines two changes. Revenue rises from $1,200,000 to $1,500,000, while average cash falls from $400,000 to $375,000. Hold average cash at February's level and March's revenue would produce 1,500,000 / 400,000 = 3.75 times. Using the actual smaller denominator takes the result to 4.00 times.
That comparison gives management a useful explanation without treating all increases as success. Treasury should review upcoming disbursements before releasing additional cash. If the question is how much of the balance sheet is held in cash, use the cash to assets ratio alongside turnover.
Credit sales can increase turnover before the related cash arrives. Check accounts receivable turnover when sales growth and collection timing diverge. A company with low cash and weak collections can have a high cash turnover ratio and still face a payment problem.
For volatile cash balances, sum the daily closing balances across the period and divide by the number of daily observations. Include every calendar day consistently, carrying the latest balance through nonbusiness days where needed. Document this method separately from the simple endpoint average.
For a quarter, divide total quarterly revenue by the quarter's own average cash. Do not average or add the monthly turnover ratios to produce quarterly turnover. Similarly, comparing one month's ratio with a full year's ratio mostly measures different period lengths.
The finance team should retain both the ratio and its inputs. A review table with revenue, average cash, minimum observed cash, and known payment obligations supports a more useful conversation than a turnover target alone. Use burn rate and runway when the decision concerns how long available cash can support ongoing consumption.
Bring a file with net revenue, cash balances, reporting dates, and the account mapping. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the reporting context.
Only in context. Higher turnover can mean the company supports more sales with the same cash balance. It can also mean cash has fallen below the amount needed for payroll, suppliers, or debt payments. Read the revenue and cash changes separately.
Use average cash for this definition. Opening and closing balances provide a simple average, while daily balances can better represent a volatile period. Ending cash alone is a snapshot and can be distorted by a receipt or payment near the reporting date.
No. Cash turnover divides revenue by average cash and is expressed in times. The cash conversion cycle measures days tied up across inventory, customer collection, and supplier payment. A company can report high turnover while customers still pay slowly.