When is my next cash crunch likely to hit?
Every business has a cash crunch somewhere on the calendar. The question is whether you see it six weeks out or six days out. Here's how to find yours.
The short answer
When will your cash crunch hit?Build a week-by-week cash forecast for the next 90 days. Start with today's bank balance, add expected receivables by week, subtract committed expenses by week. The week where your balance dips lowest is your crunch point.
The difference between a cash crunch and a crisis is timing
A cash crunch you see six weeks out is a planning problem. You can speed up collections, delay a purchase, arrange a line of credit, or push a vendor payment. A cash crunch you discover on a Friday afternoon when payroll is due Monday is a crisis.
Most small businesses have at least one predictable crunch point per year. For service businesses, it is often January (slow collections after the holidays). For seasonal businesses, it is the month before peak season when you are spending to ramp up but revenue has not arrived yet. For everyone, it is the month when quarterly taxes, insurance renewals, and a big payroll all land in the same week.
The data to predict these crunches already lives in your accounting software. You just need to assemble it in the right way.
How a weekly cash forecast model works
A cash forecast is not a single report. It is a simple spreadsheet model with one row per week for the next 13 weeks (90 days). Each row has three columns:
- Opening balance.Last week's closing balance (or today's bank balance for week 1).
- Cash in. Expected receivable payments, new sales deposits, and any other incoming cash for that week.
- Cash out. Payroll dates, rent, loan payments, vendor bills, tax due dates, insurance, and subscriptions mapped to the specific week they hit.
The closing balance for each week (opening + in - out) becomes the opening balance for the next week. The lowest closing balance across all 13 weeks is your cash crunch point.
How to build a cash crunch forecast from QuickBooks Online
You will need to pull data from QuickBooks and assemble it in a spreadsheet. Budget about 30-40 minutes the first time.
- 1Get your starting cash balance
Go to Reports→ “Balance Sheet” as of today. Note “Total Bank Accounts” under Current Assets.
- 2Map your receivables to specific weeks
Go to Reports→ “A/R Aging Detail.” This shows each open invoice with its due date. Place each invoice into the week it is due. For clients who routinely pay late, push the date out by their average delay.
- 3Map your payables and recurring costs to weeks
Go to Reports→ “A/P Aging Detail” for bills due. Check Gear icon → Recurring Transactions for payroll dates, rent, and subscriptions. Place each into the correct week.
- 4Add known one-time expenses
Quarterly tax estimates, insurance renewals, equipment purchases, annual subscriptions. Check your calendar and email for anything not yet in the system.
- 5Calculate the weekly waterfall
In your spreadsheet, run the opening + in - out calculation for each week. The week with the lowest closing balance is your crunch point. If it goes negative, you have a problem to solve now.
Total time: 30-40 minutes the first time. About 15-20 minutes to update each week after that. Most businesses stop updating after week three.
How to build a cash crunch forecast from Xero
Xero's short-term cash flow tool gives you a starting framework, but it does not show week-by-week detail.
- 1Start with the short-term cash flow tool
Go to Business → Short-term cash flow. This gives you the big picture, but you need more granularity to find the exact crunch week.
- 2Export receivables and payables detail
Go to Accounting → Reports→Aged Receivables and Aged Payables. Export both to a spreadsheet so you can sort by due date.
- 3Add recurring expenses Xero does not track
Payroll, quarterly taxes, and annual renewals may not be in Xero as scheduled bills. Add them manually to your spreadsheet in the correct weeks.
- 4Build the same 13-week waterfall
Map each inflow and outflow to its specific week. Run the cumulative balance calculation. Find your lowest point.
Total time: 25-35 minutes. Xero's cash flow tool saves a few steps, but you still need the spreadsheet for weekly granularity.
What it takes to keep your cash crunch forecast current
A cash crunch forecast is only useful if it is current. Here is the ongoing commitment:
- Weekly updates are ideal. Update actual cash received and paid, extend the forecast by one more week, and adjust any receivable timing assumptions.
- It breaks down when you get busy. The weeks where you most need the forecast (busy, stressful, lots of obligations) are the exact weeks you stop updating it.
Or let Bottomline find your next cash crunch automatically
Bottomline connects to your QuickBooks or Xero account and builds a rolling cash forecast. It identifies your next crunch point and tells you exactly when it will hit and how big the gap will be:
Bottomline factors in each client's actual payment history (not just due dates), includes recurring expenses your accounting software may not have entered yet, and stress-tests against late-payment scenarios. You get an honest forecast, not a best-case one.