You open your accounting system on the first of the month and see $150,000 in booked revenue. Then you check the bank balance β there is only $12,000 in cash, and a $30,000 payroll run is due in two weeks. This is the weekly reality for invoice-based businesses. Booked revenue does not pay the bills. To keep your business running, you need a cash flow forecast built on actual collections β not sales targets.
The challenge of forecasting cash when invoices dominate
Standard cash forecasting models often assume that when a sale is closed, cash arrives. In the B2B world, a sale simply starts a waiting period.
Clients pay late. Payment terms like Net 30 or Net 60 are often treated as suggestions by your customers. If you build a cash forecast by looking only at your sales pipeline or your profit and loss (P&L) statement, you will face unexpected cash crunches.
A P&L statement shows earned revenue β but it does not show bank balances. Accrual accounting records the revenue the moment you send the invoice. However, you cannot pay payroll with an unpaid invoice. To build an accurate forecast, you must shift your focus from sales projections to your accounts receivable (AR) ledger. Your current outstanding invoices are the most reliable source of short-term cash.
Step 1: Clean up your accounts receivable data
Before you open a spreadsheet or build a forecasting model, you must clean your data. Outdated data leads to inaccurate forecasts. If your AR ledger is cluttered with old invoices that you will never collect, your cash projections will be artificially high.
Start by identifying uncollectible invoices. If a client went out of business six months ago, write off that bad debt. It is not incoming cash.
Next, resolve disputed invoices. If a customer is withholding payment on a $5,000 invoice due to a service disagreement, do not count that money in next month's cash projection. Move disputed amounts to a separate category until your team resolves the issue.
Finally, ensure your team logs every sent invoice in your accounting system immediately. If invoices sit in draft status or on a managerβs desktop, your forecast will miss critical incoming cash.
Step 2: Use your AR aging report as the foundation
Your AR aging report categorizes unpaid invoices by how long they have been outstanding. Typically, these are grouped into standard buckets: 0β30 days, 31β60 days, 61β90 days, and over 90 days.
Do not assume every invoice will be paid in full on its due date. Instead, assign a collection probability to each bucket based on your historical payment patterns.
For a realistic worked example, let us look at a business with $100,000 in total outstanding invoices. Here is how you can apply collection probabilities to your aging buckets for the upcoming 30-day period:
- 0β30 days (Current): You have $60,000 outstanding. Historically, 90% of these clients pay on time. Projected cash: $54,000.
- 31β60 days past due: You have $25,000 outstanding. You find that 70% of these late payers eventually clear their balance this month. Projected cash: $17,500.
- 61β90 days past due: You have $10,000 outstanding. Collection probability drops to 40%. Projected cash: $4,000.
- 90+ days past due: You have $5,000 outstanding. These are highly delinquent. You assign a conservative 10% probability. Projected cash: $500.
By applying these probabilities, your projected cash collections for the month are $76,000 β rather than the full $100,000 shown on paper. Using these adjusted numbers prevents you from making critical business decisions based on cash that may not arrive for months.
Step 3: Adjust payment dates using your average DSO
Many finance teams look at the due date on an invoice and place that cash directly into that week's forecast column. This method assumes your clients are perfectly punctual.
To find out when cash will actually land in your bank account, you must calculate your Days Sales Outstanding (DSO). This metric tells you the average number of days it takes your company to collect payment after a sale.
To find your DSO, divide your average accounts receivable balance by your total credit sales, then multiply by the number of days in that period.
If your standard payment terms are Net 30, but your average DSO is 42 days, your clients are taking an extra 12 days to pay.
When building your forecast, adjust your expected payment dates by this collection lag. If you send a $10,000 invoice on October 1 with Net 30 terms, do not schedule that cash for October 31. Based on your 12-day collection lag, schedule it to arrive on November 12. This simple shift keeps your weekly cash projections aligned with real-world behavior.
Step 4: Layer in fixed expenses and recurring billing
Once you have a realistic timeline for your incoming cash, you must layer in your predictable cash outflows.
List your fixed expenses by their actual payment dates. This list should include:
- Payroll and payroll taxes
- Office rent or utilities
- Software subscriptions
- Insurance premiums
- Inventory or supplier payments
If your business uses recurring billing, add these predictable inflows to your model. Treat recurring retainers differently than one-off project invoices. Recurring payments usually have a much higher probability of clearing on time β especially if they are tied to automatic ACH or card payments.
Subtract your total cash outflows from your adjusted AR inflows for each week. The result is your net cash position. If you see a week where the net position dips below your target cash reserve, you have an early warning. You can use this lead time to delay non-essential purchases, negotiate longer terms with suppliers, or follow up aggressively on outstanding invoices.
How LedgerFlow keeps your cash projections accurate
Managing these calculations manually in spreadsheets is time-consuming and prone to human error. LedgerFlow helps small finance teams keep their cash projections accurate by automating the collections process. The platform features a two-way sync with QuickBooks Online and Xero β ensuring your AR aging reports are always up to date. By sending automated payment reminders to clients with outstanding balances, the system helps lower your DSO and makes your incoming cash flow more predictable. If you want to move away from manual spreadsheets and get a clearer view of your cash position, you can learn more about how LedgerFlow streamlines invoicing and collections by visiting our website.
FAQs
How far out should an invoice-heavy SMB forecast cash flow?
For most small and mid-size businesses relying on invoice payments, a rolling 13-week (3-month) cash flow forecast is the most practical. This window is long enough to spot upcoming cash crunches but short enough to maintain high accuracy based on your current accounts receivable ledger.
What is the difference between cash flow forecasting and AR aging?
An AR aging report shows you who owes you money and how long those invoices have been outstanding. A cash flow forecast takes that aging data, combines it with your historical collection speeds and expected expenses, and projects the actual dates cash will enter and leave your bank account.
How do past-due invoices affect cash flow projections?
Past-due invoices distort your forecast if you assume they will be paid immediately. To maintain accuracy, apply a lower collection probability to older buckets β expecting only 50% of invoices over 60 days past due to be collected next month β and actively push them toward resolution with automated reminders.
Should I include unbilled work in my cash forecast?
You can include unbilled work or signed contracts in a conservative forecast, but they should be categorized separately from sent invoices. Give these pipeline items a later expected payment date to account for the time it takes to draft, send, and process the invoice.