Blog · Finance metrics and formulas · Finance and FP&A teams
Days sales in cash expresses a cash balance in units of average daily revenue. Calculate it from balance-sheet and sales exports, reconcile the inputs, and distinguish it from collection days and expense-based runway.
Days sales in cash is cash divided by average daily revenue. It translates a cash balance into an equivalent number of sales days: $700,000 of cash against $30,000 of daily revenue equals 23.3 days. It does not measure collection speed or how many days the company can pay its bills.
Average daily revenue = Revenue for the period / Days in the period
Days sales in cash = Defined cash balance / Average daily revenue
Equivalent form: Days sales in cash = Defined cash balance / Period revenue × Days in the period
Treat this as an explicitly defined internal ratio. State which cash accounts are included, the balance date, the revenue period and the day convention. Those choices matter more than the label when comparing reports.
The numerator is a balance at a date; the denominator is activity over time. The SEC's financial-statement guide distinguishes the balance sheet's snapshot from the income statement's period revenue and the cash flow statement's movements. This ratio combines the first two, so it cannot replace the third.
Use recognized revenue, rather than bank deposits, in the denominator. Under accrual accounting, earning income and receiving payment can happen at different times; the IRS's accounting-method guidance explains that distinction for accrual income. A collection of an earlier invoice increases cash without becoming another sale in the current period.
Start with the period-end trial balance or balance sheet, the cash reconciliation and a revenue summary for the selected period. Keep company scope and reporting currency identical. For a US business reporting in USD, translate foreign balances through the approved reporting process before combining them.
| Input | Source rows | Definition to record |
|---|---|---|
| Operating cash | Cash-account balances | Balance date and accounts included |
| Cash equivalents | Approved cash-equivalent accounts | Which instruments meet the company's accounting policy |
| Restricted balances | Restricted-cash accounts or reconciliation | Included or excluded, with the reason |
| Revenue | Income-statement sales accounts | Period, net-sales treatment and entity scope |
| Days | Calendar or fiscal-period dates | Actual calendar days or a stated convention |
For the worked example, management wants available operating cash, so the numerator includes unrestricted cash and approved cash equivalents and excludes restricted cash. That is the example's measurement policy, rather than an assumption that every organization uses the same numerator.
Do not add an unused credit facility to cash. Borrowing capacity and a cash balance answer different questions. Likewise, keep marketable investments outside this calculation unless the approved definition expressly includes them and reports that choice consistently.
An illustrative US distributor reviews January 1 through March 31, 2026, a 90-day quarter. Its March 31 cash accounts are:
| Cash account | Closing balance (USD) | Included cash (USD) |
|---|---|---|
| Operating bank account | 520,000 | 520,000 |
| Payroll bank account | 80,000 | 80,000 |
| Approved cash-equivalent account | 100,000 | 100,000 |
| Restricted bond collateral | 120,000 | 0 |
| Total | 820,000 | 700,000 |
The sales export gives these recognized net-revenue totals:
| Revenue period | Revenue (USD) |
|---|---|
| January 2026 | 900,000 |
| February 2026 | 840,000 |
| March 2026 | 960,000 |
| Quarter | 2,700,000 |
The calculation follows directly from those rows:
| Step | Calculation | Result |
|---|---|---|
| Included cash (USD) | 520,000 + 80,000 + 100,000 | 700,000 |
| Quarter revenue (USD) | 900,000 + 840,000 + 960,000 | 2,700,000 |
| Average daily revenue (USD) | 2,700,000 / 90 | 30,000 |
| Days sales in cash | 700,000 / 30,000 | 23.3 days |
The unrounded result is 23.3333 recurring; the report shows one decimal place. Keep unrounded values for calculations and round only the presentation.
For a summary sheet with included cash in B2, period revenue in C2 and days in D2, use:
=IF(C2>0,B2/C2*D2,NA())
The formula returns an unavailable result for zero or negative revenue. A zero denominator does not imply unlimited operating coverage. Negative net sales caused by exceptional credits also need an explanation rather than a routine ratio.
First, reconcile the numerator. The selected cash accounts total $700,000, while total listed balances of $820,000 less restricted collateral of $120,000 also equal $700,000. Keep that exclusion visible so a reviewer can connect the ratio to the balance sheet.
The unrestricted cash movement report provides an independent tie:
| Cash reconciliation | Amount (USD) |
|---|---|
| Opening unrestricted cash and equivalents | 650,000 |
| Cash receipts | 2,600,000 |
| Cash payments | (2,550,000) |
| Closing unrestricted cash and equivalents | 700,000 |
These receipts are cash movements, not a replacement for the $2,700,000 revenue denominator. Reconcile the revenue summary separately to the income statement, including credits and revenue-recognition adjustments.
Finally, reverse the ratio with its unrounded result: $30,000 of daily revenue × 23.3333 recurring days = $700,000. Multiplying by the displayed 23.3 creates a rounding difference, so the check must use the underlying value.
Compare periods only after standardizing the definitions. Suppose the preceding quarter had the following cash and revenue, and the following quarter has higher sales but unchanged cash:
| Period | Days | Included cash (USD) | Revenue (USD) | Daily revenue (USD) | Days sales in cash |
|---|---|---|---|---|---|
| October–December 2025 | 92 | 800,000 | 2,760,000 | 30,000 | 26.7 |
| January–March 2026 | 90 | 700,000 | 2,700,000 | 30,000 | 23.3 |
| April–June 2026 scenario | 91 | 700,000 | 3,640,000 | 40,000 | 17.5 |
The first decline comes entirely from cash: daily revenue is unchanged. Using unrounded ratios, the decrease is 3.3 days after rounding. The scenario then lowers the result to 17.5 days because daily revenue increases to $40,000, despite the same $700,000 cash balance.
That second decline does not, by itself, prove deteriorating liquidity. Finance should review upcoming obligations and the cash flow forecast before drawing that conclusion. Treasury owns the cash definition and reconciliation; accounting validates revenue; FP&A explains the ratio's movement alongside the forecast.
Days sales outstanding uses receivables and credit sales to assess collection timing. Its companion, accounts receivable turnover, expresses collection activity as turns rather than days. Neither uses the cash balance as its numerator.
Expense-based days cash on hand compares available cash with a defined daily cash-expense base. Burn rate and runway focus on the pace of cash use. Those measures answer spending-coverage questions that a revenue-denominated ratio cannot answer. A distributor can have a substantial sales-day cash equivalent and still face a large supplier payment tomorrow.
Bring a sample of your own balance-sheet or cash-account export and the matching period's sales summary, with your cash definition stated. Covirage maps the columns, and its tools compute and check the cash-to-daily-revenue calculation; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.
See Covirage for finance teams for the supporting reporting context.
No. Days sales in cash uses a cash balance and revenue. Days sales outstanding uses trade receivables and credit sales to assess collection timing. Collecting a receivable can increase the first measure while reducing the second, even when no new sale occurs.
No. Revenue is the denominator, so the measure does not represent payroll, supplier payments, debt service or other cash outflows. Use an expense-based coverage measure or a dated cash forecast to assess how long funds can support operations.
Define the purpose before choosing the numerator. For an internal view of cash available to support operations, exclude restricted balances and show the adjustment separately. If another report includes them, label the definition clearly and avoid comparing the two series as if they match.
There is no useful universal target without knowing payment cycles, cash commitments and seasonal sales patterns. Compare a consistently defined measure over time, then review the cash forecast and obligations. A higher ratio caused by falling revenue is not automatically an improvement.