About this calculator
The Cash Flow Gap Calculator estimates how much working capital a business may need when customers pay later than suppliers, stock ties up cash, or growth increases the funding gap. It is useful for SMEs, wholesalers, agencies, retailers, and service firms planning invoice finance, overdraft needs, or payment-term negotiations. Use this expanded guide when you need more than a quick result. It explains the assumptions behind the Cash Flow Gap Calculator, the records to gather, and the decisions the estimate can support. It is especially useful for business owners and finance teams checking whether growth, stock, or payment terms are creating a cash shortfall. The strongest use of the page is scenario comparison: change one input at a time, compare the output, and keep a note of which assumption changed.
Cash Flow Gap Calculator calculation method
The calculator estimates days sales outstanding, days inventory outstanding, days payable outstanding, and the cash conversion cycle. A positive cycle is multiplied by daily revenue to estimate the funding gap, then a growth buffer is added where monthly growth is entered. The calculator result depends on the quality of the inputs and on the rule set or formula selected in the calculator above. For practical use, treat the output as a structured estimate: start with the core inputs, review the main outputs, then test the decision points that matter most to your situation. Key decisions include whether a funding gap exists, whether payment terms need renegotiation, whether invoice finance or overdraft capacity may be needed.
- cash conversion cycle = DIO + DSO - DPO
- funding gap = daily revenue x positive cash conversion cycle
- total working capital needed = funding gap + growth buffer
- better estimate = accurate inputs + correct rule set + realistic assumptions
- scenario difference = revised result - original result
How to use the Cash Flow Gap Calculator
- Gather the main inputs first: monthly revenue, monthly COGS, average inventory value.
- Check supporting records such as management accounts and aged receivables report before entering final figures.
- Enter a realistic base case using current documents, not best-case expectations.
- Review the main outputs: DIO, DSO, DPO.
- Run a conservative case with less favourable timing, rates, costs, or returns.
- Compare the result with management accounts, customer contracts, supplier terms, and lender requirements where rules, rates, or reporting duties matter.
- Save the inputs and calculation date so you can update the estimate when circumstances change.
- Gather the main inputs first: monthly revenue, monthly COGS, average inventory value.
- Check supporting records such as management accounts and aged receivables report before relying on a final number.
- Enter one realistic scenario first, using conservative assumptions where the future is uncertain.
- Review the main outputs: DIO, DSO, DPO.
- Run at least one alternative scenario so you can see which input changes the answer most.
- Compare the result with management accounts, customer contracts, supplier terms, and lender requirements or the relevant contract, bill, statement, or professional document.
- Keep the calculation date and assumptions with your notes so you can revisit the estimate when rates, rules, or circumstances change.
Worked example
Growing B2B supplier
Input: Monthly revenue GBP 50,000, COGS GBP 30,000, inventory GBP 15,000, customer terms 45 days, supplier terms 30 days, growth 5%.
Calculation: DIO is 15 days and cash conversion cycle is 30 days.
Result: Funding gap is about GBP 50,000 before the growth buffer.
Favourable cash cycle scenario
Input: Retailer takes card payments immediately and pays suppliers after 30 days.
Calculation: DIO plus DSO can be lower than DPO, creating a negative cash conversion cycle.
Result: The calculator shows little or no funding gap, but the advantage should be protected.
Agency late-payment scenario
Input: Service agency has 60-day customer terms and 14-day supplier or payroll obligations.
Calculation: DSO exceeds DPO by 46 days, creating a large working capital need.
Result: Invoice finance or tighter credit control may be worth reviewing.
Before you rely on the result
The Cash Flow Gap Calculator is most useful when it is treated as a structured estimate rather than a final decision. It can organise the arithmetic, but it cannot verify bank data, contracts, tax status, crypto exchange records, funding terms, investor documents, or future market conditions.
Use the result to decide what to check next. For business and tax topics, the supporting documents often matter as much as the headline number.
| Input | Why it matters | What to check |
|---|---|---|
| monthly revenue | This input changes either the calculation amount, the classification, or the scenario result. | Check the period, source document, units, tax year, and whether the value is final or estimated. |
| monthly COGS | This input changes either the calculation amount, the classification, or the scenario result. | Check the period, source document, units, tax year, and whether the value is final or estimated. |
| average inventory value | This input changes either the calculation amount, the classification, or the scenario result. | Check the period, source document, units, tax year, and whether the value is final or estimated. |
| customer payment terms | This input changes either the calculation amount, the classification, or the scenario result. | Check the period, source document, units, tax year, and whether the value is final or estimated. |
| supplier payment terms | This input changes either the calculation amount, the classification, or the scenario result. | Check the period, source document, units, tax year, and whether the value is final or estimated. |
How to interpret the output
Read the output as a set of decision signals. A low ratio, high cost, short runway, large tax estimate, or long payback period does not automatically decide the issue, but it tells you which assumption deserves attention first.
- DIO
- Use this output alongside the other figures. Finance results are easiest to misuse when one attractive number is separated from timing, risk, tax, fees, or cash-flow pressure.
- DSO
- Use this output alongside the other figures. Finance results are easiest to misuse when one attractive number is separated from timing, risk, tax, fees, or cash-flow pressure.
- DPO
- Use this output alongside the other figures. Finance results are easiest to misuse when one attractive number is separated from timing, risk, tax, fees, or cash-flow pressure.
- cash conversion cycle
- Use this output alongside the other figures. Finance results are easiest to misuse when one attractive number is separated from timing, risk, tax, fees, or cash-flow pressure.
- funding gap
- Use this output alongside the other figures. Finance results are easiest to misuse when one attractive number is separated from timing, risk, tax, fees, or cash-flow pressure.
Scenario checks worth running
A single calculation can hide risk. Run a base case, a conservative case, and an upside case. If the result changes dramatically after one small input change, that input is probably the assumption to validate before acting.
| Scenario | Change to test | What it shows |
|---|---|---|
| Base case | Use current evidence and current terms. | Shows the expected result if nothing material changes. |
| Conservative case | Use higher costs, slower receipts, lower returns, or less favourable rates. | Shows whether the decision still works with weaker assumptions. |
| Upside case | Use realistic improvements, not wishful thinking. | Shows the possible benefit if the controllable parts improve. |
Records to keep
Finance calculations are easier to defend when you can trace each figure back to a document. This is especially important for tax, investor, lender, payroll, crypto, and pension calculations.
- management accounts
- Keep this with the calculation so that the assumptions can be reviewed later. If it is estimated, label it clearly.
- aged receivables report
- Keep this with the calculation so that the assumptions can be reviewed later. If it is estimated, label it clearly.
- supplier terms
- Keep this with the calculation so that the assumptions can be reviewed later. If it is estimated, label it clearly.
- inventory report
- Keep this with the calculation so that the assumptions can be reviewed later. If it is estimated, label it clearly.
- sales forecast
- Keep this with the calculation so that the assumptions can be reviewed later. If it is estimated, label it clearly.
Common mistakes and edge cases
Most mistakes come from mixing periods, using gross and net figures together, ignoring fees, assuming rules are unchanged, or treating projections as guarantees.
- Fast growth can increase a cash gap even when profit is improving.
- Check this before using the result for borrowing, investing, tax reporting, employment decisions, pricing, or business planning.
- Late customer payment can make DSO worse than agreed terms.
- Check this before using the result for borrowing, investing, tax reporting, employment decisions, pricing, or business planning.
- Inventory estimates should use average stock, not only month-end stock.
- Check this before using the result for borrowing, investing, tax reporting, employment decisions, pricing, or business planning.
- Seasonal businesses need separate high-season scenarios.
- Check this before using the result for borrowing, investing, tax reporting, employment decisions, pricing, or business planning.
What to check before relying on the result
A useful Cash Flow Gap Calculator result starts with the same evidence you would use if you were checking the answer manually. The calculator can organise the arithmetic, but it cannot know whether a payslip is final, a bill is estimated, a quote excludes fees, or a personal circumstance has changed since the last statement.
Before making a decision, compare the calculator result with the source document that controls the real outcome. For this topic, that usually means checking management accounts, customer contracts, supplier terms, and lender requirements. If there is a difference between the calculator and an official statement, contract, assessment, or professional advice, treat the official document as the stronger source.
- management accounts
- Use this as supporting evidence for the calculation. If it is out of date, estimated, or based on a different period, the calculator output may look precise while still being wrong for the decision.
- aged receivables report
- Use this as supporting evidence for the calculation. If it is out of date, estimated, or based on a different period, the calculator output may look precise while still being wrong for the decision.
- supplier terms
- Use this as supporting evidence for the calculation. If it is out of date, estimated, or based on a different period, the calculator output may look precise while still being wrong for the decision.
- inventory report
- Use this as supporting evidence for the calculation. If it is out of date, estimated, or based on a different period, the calculator output may look precise while still being wrong for the decision.
- sales forecast
- Use this as supporting evidence for the calculation. If it is out of date, estimated, or based on a different period, the calculator output may look precise while still being wrong for the decision.
Inputs that usually change the answer
The most important input is not always the largest number on the form. Sometimes a date, threshold, percentage, eligibility flag, or timing assumption changes the result more than the headline amount. This is why scenario testing is more useful than a single calculation.
| Input | Why it matters | What to double-check |
|---|---|---|
| monthly revenue | It feeds directly into the estimate or changes which rule is applied. | Check the period, units, eligibility, and whether the figure is final or estimated. |
| monthly COGS | It feeds directly into the estimate or changes which rule is applied. | Check the period, units, eligibility, and whether the figure is final or estimated. |
| average inventory value | It feeds directly into the estimate or changes which rule is applied. | Check the period, units, eligibility, and whether the figure is final or estimated. |
| customer payment terms | It feeds directly into the estimate or changes which rule is applied. | Check the period, units, eligibility, and whether the figure is final or estimated. |
| supplier payment terms | It feeds directly into the estimate or changes which rule is applied. | Check the period, units, eligibility, and whether the figure is final or estimated. |
How to interpret the output
The output should be read as a decision aid, not just a number. For Cash Flow Gap Calculator, the useful question is often what the result means for timing, affordability, eligibility, comparison, or next steps.
- DIO
- Use this output alongside the other results rather than in isolation. A monthly amount, percentage, date, or payback figure can look acceptable until fees, timing, evidence, or eligibility conditions are added.
- DSO
- Use this output alongside the other results rather than in isolation. A monthly amount, percentage, date, or payback figure can look acceptable until fees, timing, evidence, or eligibility conditions are added.
- DPO
- Use this output alongside the other results rather than in isolation. A monthly amount, percentage, date, or payback figure can look acceptable until fees, timing, evidence, or eligibility conditions are added.
- cash conversion cycle
- Use this output alongside the other results rather than in isolation. A monthly amount, percentage, date, or payback figure can look acceptable until fees, timing, evidence, or eligibility conditions are added.
- funding gap
- Use this output alongside the other results rather than in isolation. A monthly amount, percentage, date, or payback figure can look acceptable until fees, timing, evidence, or eligibility conditions are added.
Scenarios worth comparing
A single estimate is a snapshot. A better approach is to save a base case, then adjust one assumption at a time. This shows whether the result is stable or whether a small change in timing, rate, usage, income, or cost creates a very different answer.
| Scenario | Change one assumption | What the comparison shows |
|---|---|---|
| Base case | Use the best current evidence. | Shows the result you would expect if nothing important changes. |
| Conservative case | Use lower income, higher cost, slower growth, or less favourable timing. | Shows whether the decision still works with less optimistic assumptions. |
| Improved case | Use the realistic upside, such as lower cost, better rate, higher usage, or stronger evidence. | Shows the potential benefit without treating it as guaranteed. |
Common mistakes and edge cases
Most errors come from using the right formula with the wrong assumption. Dates can be counted differently, rates can change, official thresholds can move, and real bills or contracts often include conditions that a simple calculator cannot infer automatically.
- Fast growth can increase a cash gap even when profit is improving.
- Check this point before using the estimate for a payment, claim, purchase, application, employment decision, or health-related decision.
- Late customer payment can make DSO worse than agreed terms.
- Check this point before using the estimate for a payment, claim, purchase, application, employment decision, or health-related decision.
- Inventory estimates should use average stock, not only month-end stock.
- Check this point before using the estimate for a payment, claim, purchase, application, employment decision, or health-related decision.
- Seasonal businesses need separate high-season scenarios.
- Check this point before using the estimate for a payment, claim, purchase, application, employment decision, or health-related decision.
Next steps after calculating
Once you have a result, write down the key assumptions and compare them with management accounts, customer contracts, supplier terms, and lender requirements. If the number affects a deadline, tax return, benefit claim, employment issue, medical question, finance agreement, or major purchase, use the calculator as preparation for a more formal check.
For lower-stakes use, the next step may simply be comparing two or three scenarios. For higher-stakes use, the next step should be checking the official guidance, speaking to the relevant organisation, or getting qualified advice before acting.
Important edge cases
- Fast growth can increase a cash gap even when profit is improving.
- Late customer payment can make DSO worse than agreed terms.
- Inventory estimates should use average stock, not only month-end stock.
- Seasonal businesses need separate high-season scenarios.
Limitations and advice boundary
This guide is for general information only and is not financial advice. Tax rules, lender rules, market prices, pension rules, cryptoasset values, and business conditions can change. The calculator is for education and planning, not personalised advice. This guide is for general information only and is not financial advice. The calculator is designed to support understanding and planning, but it cannot verify documents, predict future rule changes, or account for every exception. Use it as an estimate and check the official source before acting where the result matters.
- Check management accounts, customer contracts, supplier terms, and lender requirements where the result affects tax, payroll, borrowing, reporting, or a binding commercial decision.
- Do not rely on a single scenario where rates, dates, fees, valuations, income, or costs may change.
- Keep the records used for the inputs so the calculation can be updated or explained later.
- Check management accounts, customer contracts, supplier terms, and lender requirements for current rules, rates, definitions, and eligibility where relevant.
- Do not rely on a single scenario where income, costs, dates, rates, usage, or health circumstances may change.
- Keep records of the inputs used so that the estimate can be reviewed later.
Frequently asked questions
Is the Cash Flow Gap Calculator result guaranteed?
No. It is an estimate based on the inputs and calculator assumptions. Real outcomes can change because of tax rules, contracts, lender decisions, market prices, or business performance.
Should I use gross or net figures?
Use the figure requested by the calculator. Mixing gross and net values is one of the fastest ways to distort a finance result.
When should I get professional advice?
Get qualified advice where the result affects tax filing, legal obligations, employment status, investment decisions, lending, insolvency risk, or a major purchase.
Is a cash-flow gap the same as a loss?
No. A profitable business can still run out of cash if receipts arrive after payments.
What is DSO?
Days sales outstanding estimates how long customers take to pay.
What is DIO?
Days inventory outstanding estimates how long cash is tied up in stock.
Why does growth need more cash?
More sales often mean more stock, payroll, VAT, and receivables before customers pay.
Should I use invoice date or due date?
Use the timing that reflects when cash is actually received and paid.
Related calculators
- Working Capital Calculator
- Invoice Finance Cost Calculator
- Business Runway Calculator
- Merchant Cash Advance Calculator