13-Week Cash Flow Forecast for Small Business: Template and Worked Example

A business can look profitable on paper and still struggle to pay a supplier, cover payroll, or meet rent when the money is due. The problem is often timing: customer payments arrive later than expenses need to be paid.

A 13-week cash flow forecast helps you look ahead one week at a time. It estimates the cash your business will receive, the payments it expects to make, and the balance likely to remain at the end of each week.

This guide gives you a practical template, a worked example, formulas you can use in a spreadsheet, and a weekly routine for keeping the forecast useful. The figures are illustrative examples, not financial projections for any particular business.

What Is a 13-Week Cash Flow Forecast?

A 13-week cash flow forecast is a short-term planning tool that projects a business's cash position for the next 13 weeks—approximately one quarter.

Unlike a profit and loss report, which measures financial performance over a period, a cash forecast focuses on when money is expected to enter and leave the business.

The basic calculation is:

Opening cash balance
+ Expected cash inflows
- Expected cash outflows
= Closing cash balance

The closing balance for one week becomes the opening balance for the next week.

A 13-week forecast is useful for businesses that need a closer view of upcoming payroll, supplier payments, customer collections, tax obligations, loan repayments, or seasonal changes. It does not guarantee what will happen; it makes your assumptions visible so you can update them as circumstances change.

When Should a Small Business Use a 13-Week Forecast?

Consider creating one when:

• Customer payments are irregular or often late.
• Payroll, rent, supplier bills, or loan payments are due on fixed dates.
• You are preparing for a seasonal sales period.
• You are considering a large purchase or hiring decision.
• Your business is growing quickly and needs more working capital.
• You want to identify a potential cash shortage before it becomes urgent.

A 13-week forecast can be especially useful when a monthly forecast hides important timing differences. For example, a business might receive enough cash during the month overall but still be short of money on the day payroll is due.

The 13-Week Cash Flow Forecast Template

You can build this template in a spreadsheet. Use one row per week and enter expected cash movements in the week you realistically expect the money to arrive or leave your account.

What belongs in each column?

• Opening cash: Cash actually available at the start of the week. Reconcile this with your bank and cash records.
• Expected inflows: Customer payments you reasonably expect to receive, cash sales, confirmed deposits, and other expected receipts.
• Expected outflows: Payments expected to leave the business, including payroll, rent, suppliers, inventory, utilities, taxes, debt payments, and other planned expenses.
• Net cash flow: Expected inflows minus expected outflows.
• Closing cash: Opening cash plus net cash flow.

Keep a supporting list of individual receipts and payments behind the weekly totals. This makes it easier to see which customer payment or bill explains a change in the forecast.

Worked Example: A 13-Week Cash Flow Forecast

Imagine a small business starts with $25,000 in available cash. The following table uses sample amounts to show how weekly cash movements affect the closing balance.

Illustrative example only. Your results will depend on actual balances, payment dates, and business conditions.

The example shows why net cash flow and cash balance are different. Week 10 has a negative net cash flow of $7,000, but the business still ends the week with $17,000. A negative week is not automatically a crisis; the important questions are whether the remaining balance is enough to meet upcoming obligations and whether it stays above the business's minimum cash threshold.

The lowest closing balance in this example is $14,000 in Week 12. Management can investigate whether that balance provides a sufficient buffer before making new spending commitments.

How to Build the Forecast Step by Step

1. Start with cash you actually have

Use the current available balances in the business's bank accounts and cash records. Account for outstanding transactions that have already occurred but have not yet appeared in the bank balance.

Do not include unpaid customer invoices in opening cash. Those belong in the forecast as expected inflows on the dates you estimate the payments will arrive.

2. Estimate customer receipts by expected payment date

Review unpaid invoices, payment terms, customer communication, and past payment patterns. Record when you reasonably expect each payment—not just the invoice date or contractual due date.

Separate confirmed or highly likely receipts from uncertain sales. If a sale has not been agreed, avoid treating it as guaranteed cash. You can create a separate scenario for uncertain income instead of relying on it in the main forecast.

3. List bills and other cash payments

Review supplier invoices, payroll schedules, rent, utilities, taxes, loan repayments, subscriptions, inventory purchases, and planned equipment purchases.

Enter payments in the week they are expected to leave the business. Include irregular or one-off costs, not just routine monthly expenses. Check whether a large annual or quarterly bill falls within the 13-week period.

4. Calculate weekly net cash flow and closing cash

For each week, calculate:

Net cash flow = Expected inflows - Expected outflows

Closing cash = Opening cash + Net cash flow

Next week's opening cash = Previous week's closing cash

Check that the opening balance flows correctly from one week to the next. If it does not, the forecast may contain a formula error or a missing cash movement.

5. Set a minimum cash threshold

Choose a minimum balance based on your business's own risks and obligations. Consider payroll, supplier commitments, revenue volatility, seasonal patterns, and how quickly you could access additional funding if needed.

There is no single cash-buffer amount that fits every business. The threshold is a warning line for planning—not a guarantee of financial safety.

6. Investigate any week below the threshold

If a projected closing balance falls below your threshold, identify what is driving the shortfall. Is a major customer expected to pay late? Are several supplier payments due in the same week? Is an annual expense included?

Use the forecast to evaluate options, such as following up on overdue invoices, discussing payment timing with suppliers, delaying a discretionary purchase, or reviewing financing needs. Consider the contractual, legal, tax, and relationship implications before changing payment dates or commitments.

7. Compare the forecast with actual results

At the end of each week, replace estimates for the completed week with actual cash movements. Compare actual inflows and outflows with what you expected.

Ask:

• Which customers paid later or earlier than expected?
• Which costs were missing or higher than estimated?
• Did the timing of supplier or payroll payments change?
• What assumption should be updated for the remaining weeks?

This process makes the next forecast more realistic and helps reveal patterns in your cash cycle.

Spreadsheet Formulas to Use

Suppose your spreadsheet uses these columns:

• Column B: Opening cash
• Column C: Expected inflows
• Column D: Expected outflows
• Column E: Net cash flow
• Column F: Closing cash

If the first weekly row is row 2, use these formulas:

Copy the formulas down through Week 13. Confirm that your spreadsheet uses the same column layout before copying them.

You can add another column for a minimum cash threshold and use conditional formatting to highlight weeks where projected closing cash falls below it. A separate notes column can record the assumptions behind major receipts and payments.

Common 13-Week Forecasting Mistakes

Counting invoices as if they were cash

An invoice is not cash until the customer pays. Use a realistic expected collection date and update it when new information arrives.

Forgetting one-off payments

Taxes, insurance, equipment, annual renewals, and irregular repairs can materially change a weekly cash position. Check the full 13-week period for these items.

Assuming every estimate is certain

Forecasts contain uncertainty. Mark uncertain receipts and costs, and test what happens if a major payment is delayed or an expense increases.

Keeping the forecast unchanged

A forecast that is not updated becomes less useful as actual results differ from expectations. Review it weekly and revise the remaining weeks.

Confusing a positive balance with available spending money

A projected cash balance may already be needed for payroll, taxes, supplier obligations, or other commitments. Consider those obligations before deciding how much cash is available for discretionary spending.

How Often Should You Update a 13-Week Forecast?

For a useful rolling forecast, review it at least weekly. A rolling forecast always extends 13 weeks into the future: after one week closes, add a new week at the end.

A simple routine is:

1. Reconcile the completed week's cash movements.
2. Compare actual results with forecast amounts.
3. Update customer collection dates and supplier payment dates.
4. Add new commitments and unexpected costs.
5. Review the lowest projected cash balance across the next 13 weeks.
6. Record the assumptions behind any significant change.

Businesses with highly volatile cash flows may need to check the forecast more frequently.

How Accounting Software Can Help

A spreadsheet can be enough for a simple business with few transactions. As activity grows, it may become harder to keep invoices, expenses, bank activity, and payment dates aligned.

Accounting software can help organize financial records and provide clearer information for forecasting. The exact benefit depends on the software's features, the quality of the underlying records, and whether expected payment dates can be represented accurately. Do not assume that accounting software automatically produces a reliable 13-week forecast unless that capability is available and configured.

FinFlow Track provides tools for organizing business finances. Explore FinFlow Track to see whether its current features fit your workflow. Keep the forecast's assumptions under review even when you use software.

For related guidance, read Managing Business Cash Flow and Understanding Cash Flow: A Beginner's Guide.

Frequently Asked Questions

Is a 13-week cash flow forecast the same as a budget?

No. A budget usually plans revenue, costs, and financial performance over a period. A 13-week cash flow forecast focuses on when cash is expected to arrive and when payments are expected to leave, helping you assess short-term liquidity.

Can I make a 13-week cash flow forecast in Excel or Google Sheets?

Yes. A spreadsheet can work well for a straightforward forecast. Use one row per week, track opening cash, expected inflows, expected outflows, net cash flow, and closing cash, and link each week's opening balance to the previous week's closing balance.

Should I include unpaid invoices?

Include them as expected inflows in the weeks you realistically expect to receive payment. Do not count them as cash already available. If collection timing is uncertain, make the uncertainty visible and consider a more conservative scenario.

What should I do if the forecast shows a cash shortage?

First verify the inputs and payment dates. Then identify the weeks and transactions driving the gap. You might follow up on overdue invoices, review discretionary spending, discuss payment timing with suppliers, or explore appropriate financing options. Evaluate each option against your obligations and business circumstances.

Is a 13-week forecast accurate?

It is an estimate, not a guarantee. Accuracy depends on how complete your records are, how realistic the assumptions are, and how often you update the forecast. Comparing each completed week with actual results helps improve future estimates.

Final Takeaway

A 13-week cash flow forecast turns scattered invoices, bills, and payment expectations into a week-by-week view of your likely cash position. Start with the cash you have, estimate receipts and payments by realistic dates, calculate each week's closing balance, and review the forecast every week.

The most valuable result is not a perfect prediction. It is earlier visibility into a possible cash shortage—while there is still time to investigate the cause and make informed decisions.