Interactive calculator inputs and results
Before calculating: Enter average invoice counts, amounts and payment times for comparable periods; averages may include decimals. The result estimates money tied up in receivables, not lost revenue or a guaranteed cash shortage. Compare it with actual invoice and settlement dates. When essential monthly business expenses are zero, reserve coverage displays “Not calculated” because a months-of-coverage measure is undefined.
Interactive calculator unavailable: JavaScript is required to process your own inputs. The worked example, calculation assumptions and related guidance on this page remain available without JavaScript.
Worked example: measure invoice cash tied up by a payment delay
This fictional cash-flow scenario assumes an evenly distributed flow of invoices. A freelancer issues an average of 3.5 invoices a month, each worth $1,000. Average collection time increases from 15 days to 30.5 days. Essential business costs are $2,000 per month and available business reserves are $5,000. This is a sensitivity calculation—not a forecast of actual customer payment behavior.
| Step | Calculation | Result |
|---|---|---|
| Monthly invoiced value | 3.5 × $1,000 | $3,500 |
| Added average collection delay | 30.5 − 15 | 15.5 days |
| Illustrative additional cash tied up | $3,500 × 15.5 ÷ 30 | $1,808.33 |
| Business reserve coverage | $5,000 ÷ $2,000 | 2.5 months |
Interpretation: The $1,808.33 is an estimated change in average receivables under this simplified 30-day-month model, not lost sales, profit, an additional invoice, interest payable, or a cash deficit that necessarily happens on one day. The reserve coverage assumes the entered cash can be used for those essential bills and ignores other obligations.
Important limitations: If average payment time decreases, the model floors the additional delay at zero; it does not show a negative cash-tied-up figure. Reserve coverage displays “Not calculated” when essential monthly expenses equal zero. The estimate assumes an even flow of invoices and a 30-day month, so use your actual payment schedule to locate a specific cash gap.
Practical next step: Compare the estimate with actual invoice issue, due, and settlement dates. Use the overdue-invoice escalation worksheet to investigate unexplained delays instead of assuming every unpaid invoice will be collected. An invoice’s treatment in the business records is a separate accounting question; see the IRS recordkeeping guidance.
Monthly invoiced value
$3,500
3.5 invoices × $1,000
Additional collection time
15.5 days
30.5 days − 15 days
Extra receivables estimate
$1,808.33
$3,500 × 15.5 ÷ 30
Method and assumptions
Use averages from comparable periods. For example, seven invoices over two months is 3.5 invoices per month. The worked table above shows the three formulas: invoiced value, additional receivables exposure and reserve coverage.
This is a simplified cash-flow sensitivity test, not a prediction of collections. It assumes invoices are issued relatively evenly through the month and does not model partial payments, invoice disputes, taxes, seasonality, bad debt, changing invoice sizes, or clients paying on different schedules. Use actual receivables data when available.
Translate a delay estimate into a collection decision
A delayed invoice can tie up working capital without changing the revenue earned. For example, assume a fictional freelancer issues four invoices per month averaging $900 and that typical collection time increases by 10 days. An even-activity approximation gives 4 × $900 × 10 ÷ 30 = $1,200 of extra receivables outstanding. That is not $1,200 of lost revenue, a bank balance, an interest charge or a prediction of actual customer behavior.
Use the result with a real payment calendar
- Confirm the facts: Check whether each invoice was approved, the agreed due date, any dispute and the customer’s documented payment date. Keep invoices not yet due separate from genuinely overdue balances.
- List obligations by date: Map rent, payroll, subscriptions, taxes and other essentials to actual dates; a monthly average will not show which bill is due first.
- Run a cautious scenario: Exclude unconfirmed receipts and calculate how far accessible cash will go until the next cleared payment.
- Choose a measured response: Verify receipt of the invoice, request a concrete processing date, review agreed milestones or negotiate permissible payment terms. Avoid assuming a financing solution is necessary.
Sanity check: Re-run with the original collection time to see zero additional delay exposure. A zero-expense scenario has no meaningful months-of-coverage result. Neither check establishes whether a particular bill will be paid.
Use the weekly cash-flow forecasting guide and 13-week worksheet to turn approximate exposure into a date-specific forecast. See the overdue-invoice follow-up guide for payment communication steps that depend on actual contract terms.