On the first of the month, your bank account looks healthy. By the fifteenth — after payroll clears and a major vendor runs an ACH payment — you are suddenly scrambling to cover upcoming liabilities. This cash flow whiplash is a constant challenge for growing business-to-business (B2B) companies. When you bill clients on terms, your bank balance is a lagging indicator of financial health. Your outstanding invoices are the actual engine of your cash flow.
To manage your cash effectively, you must stop looking backward at past revenue. Instead, you need to look forward at when cash will actually land in your account. A rolling 13-week cash flow forecast allows you to project your liquidity with precision using the accounts receivable (AR) data you already own.
Why invoice-backed cash flow forecasting matters for SMBs
For B2B companies, revenue and cash are two entirely different metrics. You might book $100,000 in sales this month — but if those clients pay on 60-day terms, that revenue cannot pay this week's rent.
Traditional accounting tools like profit and loss (P&L) statements show your performance over time, but they do not show weekly liquidity. Your outstanding invoices are the most accurate leading indicator of your cash inflows over the next 90 days.
By anchoring your cash projections to your actual AR ledger, you remove guesswork. You transition from hoping clients pay on time to actively predicting when they will pay. This foresight gives you the lead time needed to delay capital expenditures, renegotiate vendor terms, or draw on a line of credit before a cash crunch occurs.
The anatomy of a simple rolling 13-week forecast
A 13-week horizon represents one full business quarter. This timeframe is the industry standard for short-term liquidity management. It is long enough to spot upcoming deficits and short enough to maintain high accuracy.
The core formula of a rolling forecast is straightforward:
$$\text{Starting Cash} + \text{Expected Collections} - \text{Planned Outflows} = \text{Ending Cash}$$
To build this, you do not need complex enterprise resource planning (ERP) software. A standard spreadsheet in Microsoft Excel or Google Sheets is the best place to start.
Your spreadsheet will have 13 columns, each representing one week. Every week, you will roll the sheet forward. You will delete the week that just ended, add actual cash balances to reconcile any differences, and append a new "Week 13" at the end of the sheet.
Step 1: Categorize your AR by expected payment dates
Do not build your forecast based on the due dates printed on your invoices. Clients rarely treat net-30 terms as a hard deadline. If a client historically pays 15 days late, you must model their payment at 45 days.
To categorize your inflows accurately, export your AR aging report from your accounting software, such as QuickBooks Online or Xero. Group your outstanding invoices into realistic collection weeks based on these guidelines:
- The Prompt Payers: Identify clients who consistently pay within terms. Place their invoice values in the weeks matching their actual due dates.
- The Chronic Late Payers: Look at historical payment patterns. If a client consistently pays 15 days past the due date, place their expected cash in the week that aligns with their actual behavior.
- The At-Risk Invoices: For invoices that are already 60 or 90 days overdue, do not assume they will be paid in Week 1. Push these expected funds further out, or exclude them entirely from your short-term forecast until you receive a firm payment commitment.
Step 2: Map out your fixed and variable cash outflows
Once you map your expected collections, you must list your weekly cash obligations. Outflows are usually easier to predict than inflows.
Group your outflows into clear, weekly buckets:
- Fixed Operating Expenses: These include rent, insurance, and software subscriptions. Map these to the exact weeks the ACH drafts or credit card charges occur.
- Payroll and Taxes: Payroll is usually your largest and most rigid outflow. Ensure your payroll weeks reflect the actual day funds leave your bank account, not just the pay period end date.
- Variable Vendor Payments: List your trade payables. If cash is tight, you can strategically schedule these payments across different weeks to preserve your cash buffer.
An illustrative 13-week forecast example
To see how these pieces fit together, consider a simple three-week snapshot of a hypothetical business.
In this example, the business starts Week 1 with a bank balance of $25,000.
Week 1
- Starting Cash: $25,000 (Example)
- Expected Collections:
- Example: $12,000 from Client A (historically prompt payer)
- Example: $3,000 from Client B (partial payment agreement)
- Total Collections: $15,000 (Example)
- Expected Outflows:
- Example: $8,000 payroll
- Example: $2,000 software subscriptions
- Total Outflows: $10,000 (Example)
- Ending Cash: $30,000 (Example)
Week 2
- Starting Cash: $30,000 (Example)
- Expected Collections:
- Example: $5,000 from Client C
- Total Collections: $5,000 (Example)
- Expected Outflows:
- Example: $12,000 rent and office utilities
- Example: $4,000 inventory vendor payment
- Total Outflows: $16,000 (Example)
- Ending Cash: $19,000 (Example)
Week 3
- Starting Cash: $19,000 (Example)
- Expected Collections:
- Example: $20,000 from Client D (large project milestone payment)
- Total Collections: $20,000 (Example)
- Expected Outflows:
- Example: $8,000 payroll
- Example: $3,000 marketing agency retainer
- Total Outflows: $11,000 (Example)
- Ending Cash: $28,000 (Example)
By mapping these weeks out, the business owner can see that while Week 2 experiences a dip in cash due to rent and vendor payments, the large collection in Week 3 recovers the balance. If Week 3 collections were delayed, the business would quickly see its cash buffer drop to a risky level.
How to maintain and update your forecast weekly
A cash forecast is a living document. It loses its utility if it sits untouched for weeks. Establish a weekly routine — preferably every Friday afternoon or Monday morning — to update your numbers.
- Reconcile the past week: Replace last week's projected numbers with your actual bank balance. Note where your projections were off. Did a client fail to pay? Did an unexpected expense pop up?
- Roll the timeline forward: Delete the week that just ended. Move Week 2 into the Week 1 position, and add a new Week 13 at the end of your sheet.
- Adjust future weeks: Update your expected collection dates based on your latest AR aging report. If a client missed their payment date this week, move their expected payment to next week or the week after.
This weekly 15-minute maintenance habit helps you spot cash flow trends and continuously improves your forecasting accuracy.
Streamlining your forecast with LedgerFlow
Manual spreadsheets work well, but they require clean, up-to-date accounts receivable data. If your invoicing process is disorganized, your cash flow forecast will be inaccurate.
LedgerFlow simplifies this process by keeping your accounts receivable organized and predictable. The platform syncs directly with QuickBooks Online and Xero to keep your outstanding invoices updated in real time. With automated payment reminders and a clear AR aging dashboard, you can reduce late payments and gain a clearer picture of exactly when cash will enter your business. This clean data flows directly into your planning, making your weekly spreadsheet updates faster and far more reliable.
If you are ready to take control of your cash flow and eliminate the stress of manual AR tracking, consider exploring how LedgerFlow can simplify your invoicing and collections.
FAQs
What is the difference between a cash flow forecast and a budget?
A budget is a static plan outlining your financial goals for the year, while a cash flow forecast is a dynamic tool that tracks the actual timing of cash entering and leaving your bank account week by week.
How do I handle chronically late-paying clients in my forecast?
Do not model late payers by their invoice due dates. Instead, look at their historical average days delinquent and schedule their expected cash inflow in the week that aligns with their actual behavior.
Should I include potential sales pipeline deals in a 13-week forecast?
Only include signed contracts or highly probable recurring invoices. For a short-term 13-week operational forecast, relying on unclosed sales pipeline deals introduces too much risk into your liquidity planning.