13 Week Cash Flow Forecast: Step-by-Step Guide

This guide walks you through building a 13-week cash flow forecast for your small business. You’ll map every expected cash inflow and outflow over the next quarter, giving you a rolling view of your cash position. By the end, you’ll know exactly when you might face a shortfall and have time to act.

What You’ll Need

• Your accounting software or bank statements for the last 3 months
• A list of upcoming invoices and bills (or your accounts payable/receivable aging report)
• Your sales pipeline or expected revenue for the next 13 weeks
• A spreadsheet (Excel, Google Sheets) or a simple table on paper
• Knowledge of your payment terms (e.g., net 30, due on receipt)
• Any seasonal patterns you know about (e.g., slow summer months, holiday rush)

Step-by-Step

1. Set up your spreadsheet. Create 13 columns, one for each week, starting with the current week. Label the first column “Week 1” and the last “Week 13”. Add rows for categories: Starting Cash, Cash In (receipts), Cash Out (payments), Net Change, and Ending Cash.
2. Enter your starting cash balance. In the first row, put the actual cash you have in your bank accounts today. This is your Week 1 starting point.
3. List all expected cash inflows. Go through your invoices, sales pipeline, and any other income sources (loans, investments, refunds). For each, estimate which week the money will actually hit your bank account. Be conservative—if a customer usually pays 10 days late, push the receipt to the later week.
4. List all expected cash outflows. Include rent, payroll, supplier payments, loan payments, taxes, insurance, and any other recurring bills. Also add one-off purchases you know are coming. Again, estimate the week the payment will actually leave your account.
5. Calculate weekly net change. For each week, subtract total outflows from total inflows. Write this number in the “Net Change” row. A negative number means you’re spending more than you’re bringing in that week.
6. Compute ending cash for each week. Add the net change to the starting cash of that week. That gives you the ending cash. Then, carry that ending cash forward as the starting cash for the next week.
7. Review and adjust. Look for weeks where ending cash is negative or dangerously low (below your minimum comfort level). If you see a shortfall, go back and see if you can shift a payment later or push a customer to pay earlier. Update your forecast with those changes.
8. Update weekly. Each Monday, replace Week 1 with actual numbers, then add a new Week 14 at the end. This keeps your forecast rolling forward and always 13 weeks ahead.

Common Mistakes

• Confusing profit with cash. A sale on credit is not cash until the invoice is paid. Your forecast must reflect when money actually lands, not when you issue the invoice.
• Being too optimistic. Assuming every customer pays on time and every sale closes is a recipe for a false sense of security. Build in a buffer or use conservative estimates.
• Forgetting irregular expenses. Quarterly taxes, annual insurance premiums, and maintenance contracts often get missed. Scan your last 12 months of bank statements for anything that doesn’t appear monthly.
• Ignoring timing of payroll taxes. Payroll taxes are often due a few days after payday. Make sure you account for the lag.
• Not updating the forecast. A forecast that sits stale for a month is nearly useless. It must be refreshed at least weekly to stay accurate.

Tips

• Use separate rows for major categories. Instead of one big “inflows” row, break it into “Customer payments”, “Other income”, etc. This makes it easier to spot where a variance came from.
• Color-code negative balances. Use conditional formatting to highlight weeks where ending cash is below zero or below your minimum threshold. It makes problems pop out instantly.
• Keep a “buffer” row. Add a row for “Minimum cash cushion” (e.g., two weeks of operating expenses). If your ending cash dips below this, treat it as a red flag even if it’s still positive.
• Link to your accounting software. If you use QuickBooks, Xero, or similar, see if you can export a cash flow report to speed up data entry.
• Get input from your team. Salespeople know when deals are likely to close; your bookkeeper knows when suppliers expect payment. Ask them before finalizing numbers.

Troubleshooting

What if my forecast shows a negative balance in Week 6?

First, double-check your numbers—are you missing an inflow or overestimating an outflow? If the shortfall is real, you have several options: delay a large purchase, negotiate extended payment terms with a supplier, offer a small discount for early payment from a customer, or arrange a short-term line of credit. The forecast gives you time to pick the best option.

What if actual numbers differ wildly from my forecast?

That’s a signal your assumptions are off. Compare each week’s actuals to your forecast and note where the variance came from. Was a customer later than expected? Did a supplier invoice come in higher? Adjust your future weeks accordingly. Over time, you’ll get better at predicting.

What if I don’t have historical data?

If you’re a new business, start with your best guesses based on your sales pipeline and known expenses. Then review and adjust weekly. The forecast is a living document, not a one-time exercise.

What if my business is seasonal?

Build in the seasonality. If you know summer is slow, your forecast will show lower inflows in those weeks. Use the strong months to build a cash buffer so you can cover the slow ones. Your 13-week window will show the dip coming.

Frequently Asked Questions

How far ahead should I forecast?

13 weeks is a good balance. It covers a full quarter and is long enough to see seasonal patterns, but short enough that your estimates are still reasonably accurate. Some businesses also do a 12-month forecast, but that’s more strategic than operational.

Should I include credit card sales?

Yes, but only when the money actually lands in your account. Credit card settlements often take 1-3 business days. If you process a sale on Friday, the cash may not arrive until Tuesday. Put it in the week it arrives.

What’s the difference between a cash flow forecast and a budget?

A budget is a plan for what you expect to earn and spend over a period. A cash flow forecast specifically tracks the timing of cash movements. You can have a profitable budget but still run out of cash if payments are delayed.

How often should I update it?

At least weekly. Many businesses update it every Monday morning with the previous week’s actuals. The more frequently you update, the more accurate it becomes.

What if I’m already in a cash crunch?

Build the forecast immediately to see how bad it is and when the low point hits. Then prioritize: cut non-essential spending, chase overdue invoices, and talk to your bank or a lender about a bridge loan. The forecast will show you how much you need and for how long.

Can I use accounting software instead of a spreadsheet?

Yes, many tools like QuickBooks, Xero, and Float offer cash flow forecasting features. They can pull data automatically from your accounts. However, understanding the manual process first helps you interpret what the software shows and catch errors.

Related

• Steam Booster Packs: How to Get Them
• Convert TS to FLV on Mac: Easy Ways
• Pixel 10 Release Date: Why Not August?