By Paras Saini & Shubham Sharma ·
Cash Flow Forecast for Small Business: How to Use Your Invoices to Predict Cash
You have £23,800 in outstanding invoices and a rent payment due in 18 days. How much of that £23,800 will actually land in your account before then? The honest answer: significantly less than the headline number — because a $7,800 invoice is 65 days overdue (collection probability: 25%), and another $2,200 has been disputed for three weeks. The gap between invoiced revenue and collectible cash is what a proper AR-based forecast reveals. Here is how to build one in under an hour.
Key takeaways
- Outstanding invoices — not bank balance — are the primary driver of your next 30–90 days of incoming cash
- A $10,000 invoice at 31–60 days overdue has an expected value of $5,000, not $10,000 — applying collection probabilities prevents cash flow surprises
- Collection probability drops sharply after 60 days: 95% for current, 80% at 1–30 days overdue, 50% at 31–60 days, 25% at 61–90 days, 10% at 90+
- A 90-day rolling forecast gives you enough lead time to act on cash gaps — at 30 days, you have almost no options left
- Two red flags that signal a cash flow problem in the making: DSO trending up month-over-month, and 20%+ of AR older than 60 days
What Is a Cash Flow Forecast (and Why AR Is the Key Input)?
A cash flow forecast answers one question: how much cash will I have at a given point in the future? It's not the same as profit and loss — you can be profitable on paper and still run out of cash if your invoices aren't being paid on time.
For product businesses, cash flow is driven by inventory cycles and sales volume. For service businesses and freelancers, it's simpler: the money you expect to receive is almost entirely your accounts receivable — the invoices you've issued but haven't yet collected. That's why the quality of your AR management directly determines the accuracy of your forecast. See accounts receivable management tips for a practical primer.
The catch: not all AR will actually convert to cash. Some invoices will be paid late. Some will be disputed. A small percentage will never be paid at all. A good cash flow forecast accounts for this reality instead of assuming 100% collection.
How to Calculate Expected Collections from Your AR
The core calculation is straightforward. For each outstanding invoice, you assign a collection probability based on how old the invoice is, then multiply the invoice amount by that probability to get your expected cash inflow.
The collection probabilities below are reasonable starting defaults for most service businesses. Adjust them based on your own payment history:
| Invoice Age | Collection Probability | Example: $10,000 invoice |
|---|---|---|
| Current (not yet due) | 95% | $9,500 |
| 1–30 days overdue | 80% | $8,000 |
| 31–60 days overdue | 50% | $5,000 |
| 61–90 days overdue | 25% | $2,500 |
| 90+ days overdue | 10% | $1,000 |
The collection probability drop at 60+ days is significant. This is why chasing invoices before they age past 30 days has an outsized impact on actual cash collected — not just on principle, but in forecast dollars.
The AR Age Bucket Method (30/60/90 Day Forecast)
The AR age bucket method groups your outstanding invoices by age, applies collection probabilities to each bucket, and maps expected collections onto a timeline. Here's how to build one:
Step 1 — List all open invoices
Pull your full AR list from your invoicing tool or use your invoice aging report. You need: client name, invoice number, issue date, due date, and outstanding amount.
Step 2 — Assign each invoice to an age bucket
Calculate the number of days since the due date. Group into Current, 1–30, 31–60, 61–90, and 90+ buckets. This is your AR aging snapshot.
Step 3 — Apply collection probabilities
Use the table above (or your own historical rates) to calculate expected cash from each bucket.
Step 4 — Map to a 90-day timeline
Current invoices land in your 30-day window. 1–30 day overdue invoices should land in the next 2–4 weeks (optimistically). 31–60 day overdue invoices may land in the 60-day window if you chase aggressively. Beyond 60 days, treat collections as uncertain income.
See also: how to avoid late payments — prevention is the most reliable way to keep your current bucket as large as possible.
Simple Cash Flow Forecast Template
This template captures the key fields for an AR-based 30/60/90 day cash flow forecast. Add a row per invoice, then sum by month to get your expected incoming cash for each period.
CASH FLOW FORECAST — AR COLLECTIONS Period: [Month/Quarter] Last Updated: [Date] Invoice | Client | Due Date | Amount | Age Bucket | Confidence | Expected Cash | Expected By ----------|----------------|------------|-----------|--------------|------------|---------------|------------- INV-1042 | Apex Studio | 2026-02-28 | $4,500.00 | 1–30 days | 80% | $3,600.00 | Mar 2026 INV-1038 | Brightline Co | 2026-02-15 | $2,200.00 | 31–60 days | 50% | $1,100.00 | Apr 2026 INV-1031 | Clarity Design | 2026-01-20 | $7,800.00 | 61–90 days | 25% | $1,950.00 | Apr–May 2026 INV-1055 | Dune Agency | 2026-03-15 | $6,000.00 | Current | 95% | $5,700.00 | Mar 2026 INV-1060 | Echo Films | 2026-03-30 | $3,300.00 | Current | 95% | $3,135.00 | Apr 2026 SUMMARY BY PERIOD ----------------- March 2026 (0–30 days): $9,300.00 expected April 2026 (31–60 days): $5,185.00 expected May 2026 (61–90 days): $975.00 expected TOTAL EXPECTED AR COLLECTIONS: $15,460.00 (vs. $23,800.00 invoiced — gap of $8,340.00 = at-risk AR) Known outgoings this period: Rent / overheads: $2,000.00 Contractor / freelancer: $1,500.00 Software / tools: $350.00 Total outgoings: $3,850.00 NET EXPECTED CASH (March): $5,450.00 NET EXPECTED CASH (April): $1,335.00
You can also use our free cash flow calculator to run these numbers without building a spreadsheet from scratch.
Warning Signs: When Your AR Is Hurting Your Cash Flow
Your AR aging report is an early warning system. These are the patterns that signal a cash flow problem in the making:
- ⚠
Rising days sales outstanding (DSO)
DSO = (Total AR / Total Credit Sales) × Number of Days. If your DSO is trending up month over month, clients are taking longer to pay even if they're eventually paying. This compresses your cash position.
- ⚠
Growing proportion of 60+ day AR
If more than 20% of your total AR is older than 60 days, your effective collection rate on that portion is likely below 50%. This significantly overstates the cash you can actually expect to receive.
- ⚠
Concentration in one or two clients
If 50%+ of your AR is from a single client who is paying slowly, your cash flow forecast is highly sensitive to their behaviour. One delayed payment can collapse your near-term cash position.
- ⚠
Invoices that keep slipping buckets
An invoice that was in the "current" bucket last month and is now in the 31–60 day bucket — despite your follow-ups — is a client relationship problem as much as a cash flow one.
How to Improve Forecast Accuracy Over Time
The collection probability defaults above are industry averages. Your actual rates may be better or worse depending on your client mix, industry, and how aggressively you chase. Improving your forecast means calibrating these numbers to your reality.
After each month, compare your forecast to actual collections. Track:
- What percentage of current invoices actually paid on time?
- What was the actual collection rate on 30-day overdue invoices?
- Which clients consistently pay late, and by how many days?
- Which invoices were written off entirely?
After 3–6 months of tracking, you'll have client-level and industry-level collection data that makes your forecasts substantially more accurate than using generic benchmarks.
InvoiceGrid tracks payment history per client automatically, so you can see average days to pay and payment reliability without building a separate tracking spreadsheet. For more context, see accounts receivable management tips.
Ready to Track Your Invoices Visually?
Stop losing track of who owes you money. InvoiceGrid gives you a visual Kanban board, chase history, and professional email reminders.
Frequently Asked Questions
My bank balance looks fine but I'm worried about next month — how do I know if there's actually a problem?+
Run an AR aging report right now and apply collection probabilities to each bucket: 95% for current, 80% for 1–30 days overdue, 50% for 31–60 days, 25% for 61–90 days. Sum the expected cash, subtract your known outgoings for the next 30 days. If the net is negative or uncomfortably tight, you have a problem regardless of what your bank balance shows today. The bank balance reflects the past; the forecast reflects what is actually coming.
How do outstanding invoices affect cash flow?+
Every unpaid invoice represents revenue earned but not collected. The older it gets, the less likely it is to be paid in full — so your actual cash inflow will be lower than your invoiced revenue. A business with $50,000 in AR might realistically expect only $35,000–$40,000 if 20% of that AR is 60+ days old. Applying collection probabilities by age bucket converts your AR balance from a theoretical number into a realistic cash flow projection.
How do I create a simple cash flow forecast?+
List all outstanding invoices with due dates and amounts. Assign each to an age bucket: current, 1–30 days overdue, 31–60 days, 61–90 days, 90+. Apply collection probabilities to each bucket (see the table in this guide). Map expected collections onto a 30/60/90-day timeline. Subtract known outgoings for each period. The gap between your total AR and your expected cash is your at-risk amount — that is what needs aggressive chasing this week.
What is a good collection rate for AR?+
Industry benchmarks: current invoices collect at 90–98%. At 1–30 days overdue, expect 75–85%. At 31–60 days overdue, 50–65%. Beyond 90 days, median collection rate falls below 40% without professional escalation. Your actual rates depend on your client base and how aggressively you chase — after 3–6 months of tracking, you will have client-level data that makes your forecasts significantly more accurate than generic benchmarks.
How far ahead should I forecast cash flow?+
A 90-day rolling forecast is the practical sweet spot. The first 30 days are high-confidence — you know exactly what is owed and roughly when it arrives. Days 31–60 are medium-confidence. Beyond 90 days, forecasts are directional unless you have long-term contracts with fixed payment schedules. Update the forecast weekly — an AR position can shift significantly in 7 days if a large invoice pays or a client goes silent.