Blog · Finance metrics and formulas · Finance and FP&A teams
Financial gap analysis compares dated cash needs with the cash and committed funding available to meet them. Work through a funding workbook, a minimum-cash check and a receipts downside case.
Financial gap analysis identifies when a business's planned cash payments exceed the cash and committed funding available while preserving a chosen reserve. It is a corporate funding review: the useful answer is an amount, a date and the assumptions behind both. Start with a finance-prepared cash workbook, not the income statement alone.
Choose the business entity, reporting currency, planning horizon and minimum available cash. State whether the reserve is a management preference or a contractual requirement. Also decide whether restricted cash belongs outside available funds; money the company cannot use for operating payments cannot close an operating shortfall.
Closing cash before additional funding = Opening cash + Customer receipts + Committed funding draws − Cash payments
Reserve shortfall = MAX(0, Minimum cash − Closing cash before additional funding)
The shortfall is the extra funding requirement relative to the base case. A positive bank balance can still leave a shortfall when it falls below the reserve. This is one focused part of financial analysis, rather than a complete assessment of business performance.
Use payment dates. Revenue recognition does not tell you when money arrives: IRS Publication 538 distinguishes cash receipts from income earned under accrual accounting. A signed customer order therefore needs an expected collection date before it enters this calculation.
Use a row for each expected cash movement, with entity, currency, counterparty, cash category, due date, expected payment date, amount and source reference. Bring the reconciled bank opening balance separately. Keep receipts, operating payments, equipment purchases and debt payments in distinct categories so a reviewer can follow the totals.
Add funding rows from approved agreements, including the available draw amount and date. Check conditions that could prevent a draw. Do not count the full facility limit if part is already borrowed, and do not count the same proceeds in both opening cash and a future draw.
Distinguish recurring payments from isolated purchases. The SBA's startup-cost guidance separates one-time and monthly expenses, a useful discipline for established companies planning an expansion too. Include cash taxes and scheduled principal payments even when they are absent from the operating expense budget.
A US parts distributor plans January through March 2027 in USD. Opening available cash is $180,000 and management requires a $50,000 reserve. Customer receipts come from the collections schedule; operating payments include suppliers, payroll, rent and cash taxes. Equipment and debt payments are separate, with no other cash movements assumed.
All amounts below are whole dollars. Positive entries in payment columns are amounts paid out.
| Month | Opening cash (USD) | Receipts (USD) | Operating payments (USD) | Equipment payments (USD) | Debt payments (USD) | Committed draws (USD) | Closing cash (USD) | Reserve shortfall (USD) |
|---|---|---|---|---|---|---|---|---|
| January | 180,000 | 95,000 | 170,000 | 20,000 | 10,000 | 0 | 75,000 | 0 |
| February | 75,000 | 140,000 | 185,000 | 30,000 | 10,000 | 40,000 | 30,000 | 20,000 |
| March | 30,000 | 190,000 | 195,000 | 25,000 | 10,000 | 30,000 | 20,000 | 30,000 |
The company needs additional funds by February, when closing cash falls below the reserve. March's cumulative requirement is $30,000. The $20,000 February shortage is already inside that figure; adding the two shortfalls would count part of the requirement twice.
Use columns A through I in the table's order, with January on row 2. Put the minimum cash balance, 50000, in K2. Closing cash in H2 is:
=B2+C2+G2-SUM(D2:F2)
The reserve shortfall in I2 is:
=MAX(0,$K$2-H2)
Fill both down through row 4. Opening cash in B3 is =H2, and B4 is =H3. The largest base-case shortfall is:
=MAX(I2:I4)
That returns $30,000. If borrowing costs would change with the extra funding, revise the payment schedule and rerun the calculation rather than treating the first result as final.
An executable funding schedule would add $20,000 in February and $10,000 in March. February would then close at $50,000, and that revised balance would become March's opening cash. Keep this funded scenario separate from the base-case table so the original shortage remains visible.
The quarter's receipts total $425,000. Operating, equipment and debt payments total $655,000, while committed draws total $70,000. The whole-period reconciliation is:
| Reconciliation step | Amount (USD) |
|---|---|
| Opening available cash | 180,000 |
| Add customer receipts | 425,000 |
| Add committed draws | 70,000 |
| Subtract all cash payments | -655,000 |
| Closing cash before additional funding | 20,000 |
| Reserve less closing cash: 50,000 − 20,000 | 30,000 |
The reconciled closing amount must equal March's closing cash. Opening cash must also tie to reconciled bank accounts, and each payment category must tie to its underlying schedule. A correct formula cannot rescue a missing payroll run.
Now change just March receipts from $190,000 to $175,000, leaving every other input unchanged. Closing cash becomes $5,000 and the reserve shortfall becomes $45,000. This makes the discussion concrete: slower collections increase the requirement by $15,000, so the team needs evidence about those receipts before relying on the base case.
Finance owns the cash calculation. Sales or credit owns customer collection assumptions; procurement owns supplier timing; operating managers own spending commitments. Review the working capital behind the gap before assuming borrowing is the only response.
Compare actions by date and consequence: collect an overdue invoice, defer an uncommitted purchase or arrange additional funding. Do not assume a supplier payment can move without agreement. For early-stage companies, financial analysis for startups connects this dated requirement with burn and runway.
Upload your finance-prepared cash workbook; Covirage maps the columns, and its tools compute and check the period totals and funding gaps. The external AI model explains the results 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 supporting business context.
No. A company can earn an accounting profit while customer receipts arrive after payroll, inventory payments or equipment purchases. A funding gap measures cash timing against an agreed minimum balance; a loss measures revenue against expenses under the company's accounting basis.
Keep uncommitted borrowing outside the base case. Record the amount, expected date and approval conditions separately, then show a clearly labeled scenario. A facility limit also differs from the amount that is actually drawable after existing borrowings and contractual restrictions.
Not when each month already includes the prior month's closing cash. The same unresolved shortage carries forward and would be counted again. Calculate the cumulative cash path first, then determine the incremental funding needed at each date to preserve the chosen reserve.