Cash Flow Forecast Template Canada: How to Build a 13-Week View of Your Business

Cash flow trouble rarely arrives all at once.

It usually starts quietly. A few customers pay late. Payroll lands before receivables clear. Inventory needs to be purchased before the next sales cycle begins. GST, PST, loan payments, tax instalments, and owner draws all compete for the same dollars.

On paper, the business may look profitable.

In the bank account, it may feel very different.

That is why a 13-week cash flow forecast is one of the most useful financial tools a growing business can build. It gives you a practical, week-by-week view of what cash is expected to come in, what cash must go out, and where pressure may appear before it becomes urgent.

For BC small-business owners with payroll, inventory, debt payments, tax obligations, and seasonal revenue patterns, this kind of forecast is not just a bookkeeping exercise. It is a business tool. Used well, it can help you make better decisions about hiring, spending, purchasing, borrowing, tax planning, and owner compensation.

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a short-term projection of your business’s cash inflows and outflows over the next three months.

Unlike an annual budget, which often looks at profitability over a longer period, a 13-week forecast focuses on timing. It answers a more immediate question:

Will the business have enough cash available each week to meet its obligations?

That distinction matters. A business can be profitable and still run short of cash if money comes in after major expenses are due. A 13-week forecast helps you see those gaps in advance.

Why 13 weeks?

Thirteen weeks is long enough to show meaningful patterns, but short enough to stay practical.

It captures roughly one quarter of business activity. That makes it useful for tracking payroll cycles, customer collections, supplier payments, GST/PST remittances, loan payments, tax instalments, and inventory needs. It also gives you enough time to respond if a shortfall is coming.

How to build a 13-week cash flow forecast

To build a 13-week cash flow forecast, start with your current bank balance. Then map expected cash receipts and cash payments by week. Include customer collections, payroll, rent, suppliers, inventory, GST/PST, loan payments, income tax instalments, and owner draws. Subtract each week’s cash outflows from available cash to estimate your ending cash balance. Then update the forecast weekly using actual results.

The goal is not perfection. The goal is visibility.

Step 1: Start with your actual cash balance

Begin with the cash you have today.

Use your real bank balance, not your accounting software balance, unless you have fully reconciled the account. If there are uncleared cheques, pending transfers, credit card payments, or scheduled withdrawals, account for them.

Your opening cash balance should reflect what the business can actually use.

Step 2: Forecast cash receipts by week

Next, estimate when money will come in.

Start with accounts receivable. Look at open invoices and assign each expected payment to the week you realistically expect to receive it.

Do not assume every invoice will be paid on the due date.

If a customer usually pays 15 days late, build that into the forecast. If a large client has a history of paying in batches, reflect that pattern. A useful cash flow forecast is based on expected behaviour, not wishful thinking.

Then add other receipts, such as:

• Service deposits
• Retainers
• Financing proceeds
• Tax refunds
• Owner contributions
• Asset sale proceeds

For a growing business, this is where the forecast starts to become useful. You may discover that your sales are fine, but your collection timing is creating pressure.

Step 3: Add payroll and payroll remittances

Payroll is often one of the largest and least flexible cash outflows in a growing business.

Enter each payroll date in the correct week. Then add related payroll remittances, including source deductions and employer contributions.

For forecasting purposes, the key is simple: do not only include net payroll. Include the full cash impact of payroll, including remittances.

Step 4: Map GST/HST and PST obligations

Sales tax can create a misleading sense of cash availability.

When your business collects GST or PST, that money may sit in your bank account temporarily, but it is not truly available for operating expenses. In your forecast, enter GST/HST and PST payments in the week they are due.

This helps prevent one of the most common cash flow mistakes: spending tax money before it is remitted.

Step 5: Add supplier payments and inventory purchases

For businesses that carry inventory, cash often leaves before revenue arrives.

You may need to buy materials, products, or supplies weeks before the related sale is collected. That timing gap can become a major source of pressure, especially during periods of growth.

List expected supplier payments by week. Then separate regular supplier payments from inventory purchases if inventory is significant in your business.

Step 6: Include loan payments and financing obligations

Debt payments should be entered by date and amount.

Include:

• Term loan payments
• Line of credit interest
• Equipment financing
• Vehicle loans
• Merchant cash advances
• Credit card payments
• Shareholder loan repayments

Be careful with lines of credit. If your business relies on a line of credit to smooth timing gaps, your forecast should show both the available borrowing room and the expected repayments.

Step 7: Add corporate tax instalments

Many incorporated businesses in Canada are required to pay corporate income tax through instalments during the year, followed by a balance of tax after year-end.

If tax instalments are part of your business’s cash cycle, include them in the correct weeks.

This is where many owners get caught. Tax obligations can feel distant until they become immediate. A 13-week forecast brings them into view early enough to plan.

Step 8: Be honest about owner draws

Owner draws, dividends, bonuses, and shareholder loan repayments should be included in the forecast.

The business has to support its operating needs, tax obligations, debt payments, reinvestment, and owner compensation. If owner draws are not included in the cash flow forecast, the forecast is incomplete.

This does not mean owners should not pay themselves. It means owner compensation should be planned with the same care as payroll, inventory, and tax payments.

A growing business needs both a healthy owner and a healthy balance sheet.

Step 9: Calculate ending cash balance each week

Once receipts and payments are entered, calculate:

Opening cash balance + cash receipts – cash outflows = ending cash balance

The ending cash balance for Week 1 becomes the opening cash balance for Week 2.

Repeat this across all 13 weeks.

Now look for warning signs:

• Negative cash balances
• Weeks where cash drops below your comfort level
• Large payments clustered together
• Receivables that arrive after obligations are due
• Tax payments that are not funded
• Inventory purchases that strain working capital
• Owner draws that create pressure

These are the moments where the forecast earns its keep.

Step 10: Update it weekly

A cash flow forecast is not a one-time document.

Each week, replace last week’s forecast with actual results. Then roll the forecast forward by adding a new thirteenth week.

This weekly rhythm helps you improve accuracy. It also creates accountability. Over time, you will see where your assumptions are strong and where they need work.

How a 13-week forecast improves decision-making

A good forecast helps you act earlier.

If you see a shortfall six weeks out, you have options. You can accelerate collections, adjust spending, delay a purchase, discuss terms with a supplier, plan financing, or revisit owner compensation.

If you discover the problem six days out, your options are fewer and usually more stressful.

This is why cash flow forecasting belongs in the advisory category. The spreadsheet is only the tool. The real value is the decision-making it supports.

Common mistakes to avoid

The most common mistake is being too optimistic about collections. If customers usually pay late, forecast late.

Another mistake is forgetting tax. GST, PST, payroll remittances, and tax instalments should not be treated as available operating cash.

A third mistake is leaving out owner draws. Your business exists to support your lifestyle, but it also needs enough cash to stay strong.

Finally, many businesses build a forecast once and then ignore it. The real benefit comes from updating it weekly.

The bottom line

A 13-week cash flow forecast does not remove uncertainty from business ownership, but it does reduce surprises.

It gives you a clearer view of what is coming, where pressure may build, and what decisions need to be made before cash becomes tight. For growing BC businesses, that visibility can be the difference between reacting under stress and leading with confidence.

At Avisar Chartered Professional Accountants, we help business owners understand the numbers behind their business so they can make better decisions. If your cash flow feels harder to manage as your business grows, a practical forecasting conversation may be a good next step.

Ready to take a deeper look at your cash flow? Book a free consultation.

FAQ

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a short-term projection of your expected cash receipts and payments over the next 13 weeks. It helps you see whether your business will have enough cash to meet obligations as they come due.

Why is a 13-week forecast useful for small businesses in BC?

It helps BC business owners plan for payroll, supplier payments, inventory, GST/PST, loan payments, tax instalments, and owner compensation. It is especially useful for growing businesses where cash timing can change quickly.

What should be included in a cash flow forecast?

A cash flow forecast should include opening cash, customer receipts, payroll, rent, suppliers, inventory, GST/HST, PST, debt payments, tax instalments, owner draws, and other operating expenses.

Is a cash flow forecast the same as a budget?

No. A budget usually focuses on expected income and expenses over a longer period. A cash flow forecast focuses on when cash actually enters and leaves the business.

How often should I update my cash flow forecast?

For most growing businesses, weekly is best. Updating weekly allows you to compare forecasted results to actual results and adjust the next 13 weeks based on current information.

Can a profitable business still have cash flow problems?

Yes. A business can show profit on its income statement while still running short of cash because of late receivables, inventory purchases, debt payments, tax obligations, or timing gaps between sales and collections.