At $3 million to $10 million in revenue, cash rarely becomes a problem because the business has no sales. More often, the problem is timing: customers pay later than expected, payroll hits before a major project payment, or a large inventory purchase lands in the same week as several vendor bills.
Cash flow forecasting gives you a clear view of what is likely to happen next. A rolling 90-day forecast helps you see your expected cash position, identify pressure points early, and make decisions before a short-term gap becomes an operational crisis.
This is not about predicting the future perfectly. It is about building enough visibility to lead the business with confidence.
Why a 90-day cash flow forecast matters at the $3M–$10M stage
When your company was smaller, you could often manage cash by checking the bank account, reviewing a spreadsheet, and staying close to every transaction.
That approach becomes unreliable as the business grows. More customers create more complicated payment patterns. More employees create more payroll commitments. More vendors, projects, locations, and inventory purchases make it harder to know what will happen over the next several weeks.
At this stage, the business is moving from founder-led decisions to repeatable operating systems. That transition requires more than an accounting balance. You need a forward-looking view that connects:
- Customer payment timing
- Vendor and accounts payable commitments
- Payroll runs and payroll taxes
- Inventory and raw material purchases
- Loan, lease, and tax payments
- Month-end cash activity
- Expected sales-related receipts and major one-time expenses
A 90-day forecast gives leadership a practical decision window. It is long enough to see upcoming payroll cycles, customer collections, planned purchases, and month-end obligations, but short enough to use realistic assumptions.
A weekly view is especially useful. A month can hide a cash squeeze that appears clearly when payments are mapped by week.
The basic cash flow forecasting formula
A 13-week rolling forecast can be built around a simple equation:
Opening cash + expected inflows − expected outflows = projected closing cash
Each week should include:
- Opening cash balance
- Expected cash inflows
- Expected cash outflows
- Net cash flow
- Projected closing cash balance
The closing cash balance from Week 1 becomes the opening balance for Week 2. The process continues through Week 13.
The goal is not to produce a complicated model. The goal is to create a reliable operating view that answers questions such as:
- When will cash reach its lowest point?
- Can we cover the next two payroll runs?
- Which customer payments are essential to the next 30 days?
- Can we make a planned inventory purchase without creating unnecessary pressure?
- Should we accelerate collections, adjust payment timing, or delay discretionary spending?
Established guidance from organizations such as the British Business Bank also emphasizes the importance of mapping expected receipts and payments over a defined period rather than relying only on historical results.
Step 1: Forecast inflows based on when cash will arrive
Your sales results do not automatically equal available cash. The forecast should focus on when money is expected to reach the bank account.
Start with accounts receivable and review:
- Open invoices
- Contractual due dates
- Customer payment history
- Known disputes or approval delays
- Recurring customer payments
- Deposits, retainers, or milestone billing
- Large invoices expected to be issued during the next 90 days
For each expected receipt, assign the amount to a specific week. Use realistic collection timing, not only the invoice due date.
For example, suppose a customer owes $120,000 on Net 30 terms. If that customer routinely pays 10 days late, the forecast should place the expected receipt closer to Week 6 than Week 4. That adjustment may reveal a cash pressure point that would otherwise be missed.
This is where real-time business insights become valuable. A performance dashboard for business leaders should show not only revenue activity, but also expected cash receipts and the confidence level behind those assumptions.
Step 2: Map outflows by actual payment date
The same principle applies to outflows. Record when cash will leave the business, not simply when an expense is recorded.
Accounts payable
Review your vendor bills and payment commitments. Map payments according to:
- Invoice due dates
- Vendor terms
- Scheduled payment runs
- Early-payment decisions
- Contractor payments
- Rent, utilities, insurance, and subscriptions
A bill may be recorded today but paid two weeks from now. The forecast should reflect the payment date.
Payroll
Payroll is usually one of the most predictable and significant cash commitments. List every payroll run over the next 13 weeks, including:
- Gross wages
- Employer payroll taxes
- Benefits
- Bonuses or commissions
- Contractor payments
- Any planned hiring or compensation changes
If you are considering adding three employees, model the full cash effect before approving the decision. Include the likely start date, payroll cycle, taxes, benefits, and any recruiting or onboarding costs.
Inventory and purchasing
Inventory purchases can create sudden cash dips, especially when a business buys ahead of demand or places a large order to support a new customer.
Map:
- Purchase order date
- Deposit requirements
- Expected delivery date
- Balance payment date
- Freight and related charges
- Payment terms
A large purchase may not affect cash when the order is placed. It may affect cash 30 or 60 days later, depending on the supplier agreement. Your forecast should make that timing visible.
Step 3: Include month-end activity and reconcile actuals
Month-end close is not just an accounting exercise. It is an opportunity to improve the quality of your cash flow forecasting.
Include recurring month-end activity such as:
- Rent or lease payments
- Loan principal and interest
- Tax payments
- Software renewals
- Insurance installments
- Scheduled vendor payment runs
- Customer receipts that typically arrive at month-end
After each month-end close, compare what actually happened with what was forecasted. Replace estimates with actual bank movements and update the assumptions for future weeks.
If a customer was consistently expected to pay in Week 4 but paid in Week 6, that pattern should influence the next forecast. If payroll taxes were larger than expected, correct the model rather than carrying the error forward.
This feedback loop improves forecasting accuracy over time and can support a faster close because the team is working from cleaner, more current information.
A practical example: finding a cash gap early
Imagine a growing services company with:
- $250,000 in opening cash
- $310,000 in expected customer receipts over the next 30 days
- $180,000 in payroll and payroll-related costs
- $145,000 in vendor payments
- $90,000 in inventory and equipment purchases
- $35,000 in rent, taxes, software, and other recurring payments
The business appears healthy when viewed through monthly revenue. But the weekly forecast shows that a $90,000 inventory payment lands in the same week as payroll and several vendor payments.
The projected closing cash balance falls to $68,000 before recovering two weeks later when a large customer payment arrives.
That insight creates options:
- Confirm the customer payment date
- Request a deposit or milestone payment
- Adjust the inventory purchase schedule
- Coordinate a vendor payment plan
- Delay a discretionary purchase
- Preserve a minimum cash threshold
Without the forecast, leadership may only discover the issue after the bank balance is already under pressure.
Make the forecast a management rhythm, not a static file
A 90-day forecast is most useful when it becomes part of your weekly operating rhythm.
Each week:
- Remove the completed week.
- Add a new Week 13.
- Update open receivables and expected payment dates.
- Add new vendor commitments and purchase orders.
- Confirm payroll, taxes, and recurring payments.
- Compare actual cash activity with the previous forecast.
- Review the lowest projected cash point and assign actions.
This is where an ERP or connected operating system becomes essential infrastructure for scaling a business. The objective is not to eliminate spreadsheets overnight. It is to reduce manual re-entry and connect the information that drives cash decisions.
A properly designed system can bring together finance, CRM, purchasing, inventory, projects, and payroll-related inputs so leaders are not waiting for separate departments to reconcile competing versions of the numbers.
Brown Paper Analytics’ Measurement & Clarity framework is built around creating one shared view of performance, reducing manual reconciliation, and connecting metrics to accountable owners. The Growth & Sustainability pillar extends that visibility into the systems and operating discipline required for durable expansion.
Common objections to cash flow forecasting
“We already have a spreadsheet.”
A spreadsheet can be a useful starting point. The issue is whether it is current, trusted, and connected to the decisions being made.
If one person owns the file, updates happen irregularly, or leaders spend meetings debating which version is accurate, the spreadsheet is not providing enough visibility. A practical first step is to define the key inputs, owners, update cadence, and minimum cash threshold.
“An ERP or dashboard implementation will be too disruptive.”
It can be disruptive if the business attempts to change every process at once. A phased rollout is more practical.
Start with the cash-critical workflows: receivables, payables, payroll commitments, purchasing, and leadership visibility. Map the current process, identify the highest-impact gaps, and improve the operating rhythm before expanding into additional modules.
“We’ll do it later.”
Waiting often increases the cost of change. More customers, employees, transactions, and workarounds create more data cleanup and more resistance.
You do not need a perfect system to begin. You need a clear baseline, a focused 90-day forecast, and a roadmap for strengthening the process as the business grows.
The payoff: better decisions with less cash uncertainty
Consistent cash flow forecasting can help you achieve:
- Earlier visibility into cash pressure
- Faster month-end close
- Fewer payment and timing surprises
- Better coordination between sales, operations, and finance
- Improved customer collection planning
- More confident hiring and purchasing decisions
- Cleaner handoffs and stronger auditability
- Better forecasting as the business scales
The larger point is that cash visibility should become part of how the business operates, not a report created only when cash is tight. It is a foundational habit for sustainable business growth.
Build your cash visibility roadmap
If your business is moving beyond founder-led, spreadsheet-driven operations, a 90-day cash flow forecast is a practical place to start. Brown Paper Analytics can help you assess your current data, define the metrics that matter, and create a phased process-to-system roadmap.
Book a discovery call or request an ERP readiness assessment to identify the visibility gaps affecting your next stage of growth.