13-Week Cash Flow Forecast: What It Is and How to Build One

A business can be profitable on paper and still run short of cash.

Customers may pay invoices late. A large supplier payment may be due next week. Payroll might fall before your biggest customer payment arrives. Tax payments, subscriptions, inventory purchases, and other expenses can all hit at different times.

Looking at today’s bank balance doesn’t tell you what your cash position could look like several weeks from now.

That’s where a 13-week cash flow forecast becomes useful.

A 13-week cash flow forecast gives you a week-by-week view of expected cash coming into and leaving your business over roughly the next three months.

Instead of asking:

“How much cash do I have today?”

you can start asking:

“What is likely to happen to my cash over the next 13 weeks?”

This guide explains how a 13-week cash flow forecast works, what to include, and how to build one for a small business.

What Is a 13-Week Cash Flow Forecast?

A 13-week cash flow forecast is a short-term financial planning tool that estimates your business’s cash position for each of the next 13 weeks.

A basic forecast tracks:

Beginning Cash Balance

+ Cash Inflows

– Cash Outflows

= Ending Cash Balance

The ending balance from one week then becomes the beginning balance for the following week.

For example:

Continue the same structure across 13 weeks and you get a forward-looking view of when cash may increase or tighten.

Why 13 Weeks?

Thirteen weeks represents approximately one quarter of a year.

It is long enough to see beyond the immediate bank balance while remaining short enough for many businesses to make reasonably informed assumptions about upcoming receipts and payments.

A one-week view can be too short.

A full-year cash forecast can become increasingly uncertain the further you look ahead.

A 13-week horizon sits between the two.

It can help you see:

• Upcoming payroll
• Supplier payments
• Expected customer receipts
• Rent
• Loan payments
• Taxes
• Inventory purchases
• Recurring expenses
• Planned investments
• Potential cash shortages

The purpose isn’t to predict every dollar perfectly.

The purpose is to see potential cash pressure early enough to make a decision.

Cash Flow Is Not the Same as Profit

This distinction is essential.

Profit measures revenue against expenses under accounting rules.

Cash flow tracks when money actually enters and leaves the business.

Suppose you complete $20,000 of work this month and invoice the customer.

The sale may contribute to your reported revenue.

But if the customer doesn’t pay for 45 days, that $20,000 is not available in your bank account today.

Meanwhile, you may still need to pay:

• Employees
• Contractors
• Suppliers
• Rent
• Software
• Taxes

That timing difference is one reason a profitable business can still experience a cash shortage.

A 13-week forecast focuses on the timing of cash.

What Should a 13-Week Cash Flow Forecast Include?

The exact categories depend on the business, but most forecasts contain four core sections.

1. Beginning Cash Balance

Start each week with the cash you expect to have available at the beginning of that week.

For the first week, this may be based on your current available cash balance.

For subsequent weeks:

Previous Week’s Ending Cash = Next Week’s Beginning Cash

2. Cash Inflows

List the cash you realistically expect to receive.

Examples include:

• Customer payments
• Cash sales
• Ecommerce payouts
• Marketplace payouts
• Subscription revenue
• Loan proceeds
• Owner contributions
• Refunds received
• Other expected cash receipts

The important word is cash.

If you’ve issued an invoice but don’t expect it to be paid until Week 5, place the expected receipt in Week 5 rather than Week 1.

3. Cash Outflows

Next, list expected cash payments.

Common categories include:

• Payroll
• Contractors
• Inventory
• Suppliers
• Rent
• Utilities
• Software
• Advertising
• Shipping
• Insurance
• Loan payments
• Taxes
• Professional services
• Equipment
• Owner withdrawals
• Other operating expenses

Place each payment in the week you expect the cash to actually leave the business.

4. Ending Cash Balance

Finally calculate:

Beginning Cash + Total Inflows – Total Outflows = Ending Cash

This is one of the most important numbers in the forecast.

It shows the cash you expect to have after that week’s projected activity.

How to Build a 13-Week Cash Flow Forecast

You can build a basic forecast in Excel or Google Sheets.

Start with columns for:

Week 1 through Week 13

Then organize the rows into cash inflows and cash outflows.

A simple structure might look like this:

Let’s build it step by step.

Step 1: Enter Your Current Cash Position

Begin with the amount of cash actually available to the business.

Be careful about simply copying a bank balance if part of that money is restricted or already committed.

The objective is to create a useful operating forecast, so start with a cash figure that accurately represents what the business can use.

Suppose:

Beginning Cash = $20,000

That becomes Week 1’s opening balance.

Step 2: Estimate Weekly Cash Inflows

Now determine what money you reasonably expect to receive each week.

Suppose you expect:

Week 1: $7,000
Week 2: $11,000
Week 3: $5,000
Week 4: $9,000

Don’t automatically spread monthly sales evenly across four weeks.

Cash rarely arrives that neatly.

If a customer normally pays around a particular date, put the expected payment in the corresponding week.

If your ecommerce platform pays out on a regular schedule, reflect that timing.

The closer your forecast reflects real payment behavior, the more useful it becomes.

Step 3: Estimate Weekly Cash Outflows

Do the same for outgoing cash.

For example:

Week 1: Payroll $6,000 + software $500
Week 2: Supplier payment $8,000
Week 3: Rent $3,000 + payroll $6,000
Week 4: Tax payment $5,000 + supplier payment $4,000

This is where weekly forecasting becomes valuable.

A monthly total might look manageable while hiding the fact that several large payments fall in the same week.

Step 4: Calculate Net Cash Flow

For each week:

Net Cash Flow = Cash Inflows – Cash Outflows

Suppose Week 1 has:

Cash inflows: $7,000

Cash outflows: $6,500

Net cash flow:

$7,000 – $6,500 = $500

Your business generated $500 more cash than it spent during that week.

If outflows exceed inflows, net cash flow will be negative.

That isn’t automatically a problem.

The important question is what it does to your ending cash position.

Step 5: Calculate Ending Cash

Suppose Week 1 begins with:

$20,000

and net cash flow is:

+$500

Then:

$20,000 + $500 = $20,500

Week 1 ending cash is therefore:

$20,500

That $20,500 becomes the beginning cash balance for Week 2.

Repeat this process through Week 13.

Step 6: Look for Low-Cash Weeks

Once all 13 weeks are populated, don’t focus only on the final week.

Look across the entire forecast.

For example:

Week 6 looks healthier.

But Week 5 is the important warning.

If the business needs at least $6,000 of operating cash, Week 5 could create a problem even though the balance recovers afterward.

A forecast helps reveal that issue before Week 5 arrives.

What Can You Do When the Forecast Shows a Cash Shortage?

Finding a future shortage is not a failure of the forecast.

It is one of the main reasons to create one.

If you identify a potential cash gap several weeks in advance, you have more time to investigate your options.

Depending on the situation, a business might consider:

• Following up on overdue receivables
• Asking customers to pay deposits
• Adjusting payment timing where appropriate
• Delaying nonessential purchases
• Reducing discretionary spending
• Reviewing inventory orders
• Changing the timing of planned investments
• Discussing supplier terms
• Reviewing financing options before cash becomes critical

The appropriate action depends on the business.

But discovering a problem six weeks early generally gives you more options than discovering it when a payment is due tomorrow.

Don’t Make Every Forecast Number Optimistic

A cash flow forecast becomes less useful if every assumption represents the best possible outcome.

Suppose a customer owes you $10,000.

The invoice is due next week, but the customer regularly pays two weeks late.

Putting the $10,000 into next week’s forecast simply because that is the invoice due date may overstate your expected cash.

Use realistic timing based on what you know.

You can also create alternative scenarios where uncertainty is significant.

For example:

Expected case: Customer pays in Week 3
Best case: Customer pays in Week 2
Downside case: Customer pays in Week 5

This helps you understand how sensitive your cash position is to uncertain payments.

Update the Forecast Every Week

A 13-week cash flow forecast should not be created once and forgotten.

A common approach is to use it as a rolling forecast.

At the end of each week:

1. Replace estimates with what actually happened.
2. Update expected future receipts.
3. Update upcoming payments.
4. Remove the completed week.
5. Add a new Week 13.

You continue looking approximately 13 weeks ahead.

This keeps the forecast relevant as new information becomes available.

Forecast vs Actual: Why the Difference Matters

Your forecast will rarely match reality perfectly.

That is normal.

The useful question is:

Why was actual cash different from forecast cash?

Suppose you expected $15,000 in customer receipts but received only $10,000.

Investigate the $5,000 difference.

Maybe:

• A customer paid late
• Sales were weaker than expected
• A payout was delayed
• An invoice was disputed

The same applies to expenses.

If supplier payments were consistently higher than forecast, your future assumptions may need updating.

Over time, comparing forecast vs actual can improve the quality of your forecasting.

Common 13-Week Cash Flow Forecasting Mistakes

Using Revenue Instead of Cash Receipts

Revenue and cash receipts are not necessarily received at the same time.

Forecast when you expect the money to arrive.

Forgetting Irregular Expenses

Monthly subscriptions are easy to remember.

Quarterly tax payments, annual insurance, equipment purchases, and occasional inventory orders are easier to miss.

Review upcoming obligations carefully.

Assuming Customers Always Pay on Time

Invoice due dates are useful, but actual customer payment behavior may provide a better forecasting assumption.

Ignoring Small Recurring Expenses

Individual subscriptions may seem insignificant, but multiple recurring expenses can add up.

Never Updating the Forecast

A forecast built two months ago using outdated assumptions is much less useful than a rolling forecast updated regularly.

Looking Only at the Final Balance

A positive Week 13 balance doesn’t mean every week before it is safe.

Always examine the lowest projected cash point.

How Often Should You Update a 13-Week Forecast?

For a weekly model, updating it once a week is a practical approach for many businesses.

Choose a consistent day.

For example, every Monday you could:

• Update the current bank balance
• Record actual receipts and payments
• Review accounts receivable
• Review upcoming bills
• Adjust uncertain payments
• Add the newest forecast week

The process becomes much easier once it is part of a routine.

Who Can Benefit From a 13-Week Cash Flow Forecast?

A short-term cash forecast can be useful for many small businesses, particularly those with uneven timing between income and expenses.

Examples include:

• Service businesses waiting on invoices
• Ecommerce businesses purchasing inventory
• Agencies with payroll commitments
• Contractors
• Seasonal businesses
• Businesses with large supplier payments
• Businesses experiencing rapid growth

Rapid growth can create cash pressure too.

A business may need to purchase inventory, hire people, or spend on fulfillment before the resulting sales turn into available cash.

Growth and healthy cash flow are not always the same thing.

Build the Forecast Without Starting From Scratch

You can create a 13-week forecast manually in Google Sheets or Excel.

But the recurring calculations, weekly structure, categories, and rolling balances need to stay organized.

The 13-Week Cash Flow Forecast Spreadsheet from Start Unlimited is designed for small business owners who want a ready-to-use structure for tracking weekly inflows, outflows, and projected cash balances.

Instead of managing the business using only today’s bank balance, you can see how expected cash movements affect the weeks ahead.

View the 13-Week Cash Flow Forecast Spreadsheet

13-Week Cash Flow Forecast Checklist

Before relying on your forecast, check that you have:

• Entered an accurate beginning cash balance
• Listed expected customer payments
• Used realistic payment dates
• Included ecommerce or marketplace payouts
• Included payroll
• Included supplier payments
• Included rent and utilities
• Included software and subscriptions
• Included tax payments
• Included loan payments
• Included planned inventory purchases
• Included irregular expenses
• Calculated weekly net cash flow
• Calculated weekly ending cash
• Identified the lowest projected balance
• Reviewed uncertain inflows
• Planned to update the forecast weekly

A forecast doesn’t need to be perfect to be useful.

It needs to be realistic enough to help you see what could happen before it happens.

Frequently Asked Questions

What is a 13-week cash flow forecast?

A 13-week cash flow forecast estimates expected cash inflows, cash outflows, and ending cash balances for each of the next 13 weeks.

It provides a short-term view of how the timing of receipts and payments could affect available cash.

Why use 13 weeks for cash flow forecasting?

Thirteen weeks covers approximately one quarter.

It provides more visibility than looking only a few days ahead while remaining more focused on short-term cash movements than a full-year forecast.

How do you calculate weekly ending cash?

A basic calculation is:

Beginning Cash + Cash Inflows – Cash Outflows = Ending Cash

That ending balance then becomes the next week’s beginning balance.

How often should a 13-week cash flow forecast be updated?

A weekly update is a practical approach because the model itself is organized by week.

Update actual activity and revise future assumptions as new information becomes available.

Can I build a 13-week cash flow forecast in Excel?

Yes.

Excel and Google Sheets can both be used to create a 13-week cash flow forecast with weekly columns, cash inflow and outflow categories, and formulas for net and ending cash.

Final Takeaway

A 13-week cash flow forecast does not tell you exactly what will happen.

It gives you a structured view of what could happen based on the information you have today.

That distinction is important.

The objective isn’t perfect prediction.

It’s earlier visibility.

Instead of discovering a cash shortage when the bank balance is already low, a weekly forecast can show you potential pressure several weeks in advance.

Start with your available cash.

Estimate when money will actually arrive.

Map when payments will actually leave.

Calculate your weekly ending balance.

Then update the forecast as reality changes.

For a small business, that simple routine can turn cash management from reacting to today’s bank balance into planning for the weeks ahead.

This article provides general educational information and is not financial, accounting, tax, or legal advice.