A business can be profitable on paper and still struggle to pay employees, suppliers, rent or taxes.
The problem is often not a lack of sales. It is timing.
Customers may take 30, 60 or even 90 days to pay, while payroll, loan payments and supplier invoices continue to fall due. A large tax remittance, inventory purchase or annual insurance payment can place additional pressure on the bank account.
A 13-week cash flow forecast gives business owners a clearer view of what is expected to enter and leave the bank account over the next three months.
Unlike a yearly budget, which provides a broad financial plan, a 13-week forecast focuses on short-term liquidity. It helps answer a more immediate question:
Will the business have enough cash to meet its obligations every week?
BDC recommends a rolling 13-week forecast as a practical way to obtain tighter cash visibility than a traditional monthly budget. Updating it at the beginning of every week allows a business to continuously look approximately one quarter ahead.
This guide explains how Canadian business owners can build, update and use a 13-week cash flow forecast.
Important: This article provides general information only. Forecasting methods and tax obligations vary between businesses. Consult a qualified accountant or advisor when making significant financial, borrowing or tax decisions.
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a weekly projection of the cash expected to enter and leave your business over the next 13 weeks.
Thirteen weeks roughly represents one financial quarter. It is long enough to identify developing problems, but short enough to use detailed and reasonably reliable information.
Each weekly column normally contains:
- Opening bank balance
- Expected customer receipts
- Other cash inflows
- Payroll
- Supplier payments
- Rent and occupancy costs
- Loan and lease payments
- Tax remittances
- Capital purchases
- Owner withdrawals
- Other cash outflows
- Net cash movement
- Closing bank balance
The basic calculation is:
Opening cash + cash received − cash paid = closing cash
The closing balance for one week becomes the opening balance for the following week.
A 13-week forecast is not the same as an income statement. It records when cash is expected to move, not when revenue or expenses are recognized for accounting purposes.
Why Use 13 Weeks?
A one-week forecast is usually too short to support meaningful planning. A one-year weekly forecast may require too many uncertain assumptions.
Thirteen weeks creates a practical middle ground.
It gives owners enough time to:
- Follow up on overdue accounts receivable
- Delay or reschedule non-essential spending
- Negotiate payment arrangements with suppliers
- Request a line-of-credit increase
- Prepare for payroll and tax remittances
- Adjust purchasing and inventory levels
- Discuss financing before cash becomes critical
BDC also notes that a 13-week rolling forecast can help a business assess its cash burn rate and estimate how much financial runway remains.
The forecast is especially useful for businesses experiencing:
- Rapid growth
- Seasonal revenue
- Long customer-payment terms
- Large inventory purchases
- Construction or project-based billing
- Irregular contracts
- Tight margins
- Financing pressure
- Significant tax obligations
Cash Flow Forecast vs Profit Forecast
Profit and cash are related, but they are not the same.
Suppose your company completes a $50,000 project in Week 2 and records the revenue immediately. If the customer pays in Week 8, the sale may improve accounting profit in Week 2, but it does not provide cash for six more weeks.
At the same time, the business may need to pay employees and subcontractors before collecting from the customer.
A profit forecast asks:
Will the business earn more revenue than expenses?
A cash flow forecast asks:
Will money be available in the bank when payments are due?
A healthy company needs to understand both.
Step 1: Choose the Starting Date
Start with the beginning of your next working week.
Create 13 weekly columns. For example:
| Category | Week 1 | Week 2 | Week 3 | Week 4 | … | Week 13 |
|---|---|---|---|---|---|---|
| Opening cash | ||||||
| Cash inflows | ||||||
| Cash outflows | ||||||
| Net cash movement | ||||||
| Closing cash |
Use consistent start and end dates. Many businesses forecast from Monday to Sunday, but the exact weekly period matters less than applying it consistently.
Step 2: Calculate Available Opening Cash
Begin with the cash genuinely available to operate the business.
Review:
- Operating bank accounts
- Savings accounts available for business use
- Cash held by payment processors
- Available operating lines of credit
- Restricted cash
- Outstanding cheques or electronic payments
- Deposits that have not yet cleared
Do not automatically include every amount shown in the bank as available cash.
For example, part of the bank balance may represent:
- GST/HST collected
- Payroll source deductions
- Customer deposits required for future work
- Funds restricted for a specific project
- Money needed for an upcoming loan payment
Using an unrealistic opening balance will make every following week unreliable.
Step 3: Forecast Customer Receipts
Customer collections are often the largest and most uncertain section of the forecast.
Start with your accounts receivable report. Review each outstanding invoice rather than applying one general collection percentage to the total.
For every significant invoice, ask:
- Has the customer approved the invoice?
- What are the payment terms?
- Does the customer normally pay on time?
- Is the invoice disputed?
- Has a payment date been confirmed?
- Will payment arrive by cheque, electronic transfer or credit card?
- Is a holdback or retention amount involved?
- Will processing delays affect the deposit date?
Record the payment in the week you reasonably expect the money to reach the bank.
Avoid entering an invoice based only on its contractual due date when the customer has a history of paying late.
Separate receipts by confidence level
You may divide expected receipts into three groups:
Committed receipts: Payments already processed or confirmed.
Highly probable receipts: Invoices expected to be paid based on normal customer behaviour.
Uncertain receipts: New sales, disputed invoices or payments without a confirmed collection date.
Only include uncertain receipts when there is a reasonable basis for estimating them. Consider showing them separately rather than relying on them to fund essential payments.
Step 4: Estimate New Sales Collections
After entering existing receivables, forecast cash from new sales expected during the 13-week period.
The timing depends on the business model.
Retail business
Cash and card sales may be received quickly, although payment processors can create a short delay.
Professional-services firm
The business may invoice after completing the work and collect 15 to 60 days later.
Construction company
Payments may depend on progress billings, approvals, holdbacks and contract terms.
Subscription business
Receipts may occur monthly or annually on known renewal dates.
Seasonal business
Historical results from the same period in previous years may provide a more realistic starting point than a simple annual average.
Use confirmed orders, signed contracts, active proposals and previous collection patterns. Do not treat every sales lead as incoming cash.
Step 5: List Payroll Costs
Payroll is often one of the largest fixed cash requirements.
Include:
- Net employee wages
- Owner-manager salary
- Bonuses and commissions
- Vacation pay
- Employer CPP contributions
- Employer EI premiums where applicable
- Benefits and pension contributions
- Workers’ compensation payments
- Payroll-service fees
- Payroll source-deduction remittances
Enter wages in the week they will be paid, not simply the period in which employees perform the work.
Payroll deductions and employer contributions must also be entered based on the corporation’s CRA remitter type and due date. The CRA uses different schedules for quarterly, regular and accelerated remitters, so businesses should confirm the schedule assigned to their payroll account rather than assuming every employer follows the same deadline.
For example, many regular remitters are required to remit deductions for a month by the 15th day of the following month, while accelerated remitters may have more frequent deadlines.
Step 6: Enter Supplier and Operating Payments
Review the accounts payable report and recurring-expense schedule.
Common cash outflows include:
- Inventory
- Materials
- Subcontractors
- Freight and delivery
- Rent
- Utilities
- Insurance
- Software subscriptions
- Advertising
- Professional fees
- Repairs and maintenance
- Telephone and internet
- Vehicle costs
- Credit-card payments
- Equipment leases
- Bank charges
- Loan payments
Enter payments based on when you expect them to leave the bank.
Do not simply divide annual expenses by 52. Some costs occur monthly, quarterly or annually. A yearly insurance premium or software renewal can create a large one-week cash requirement even when the annual budget appears manageable.
Step 7: Add GST/HST and Other Tax Payments
Tax payments are commonly missed in informal forecasts.
Depending on the business, include:
- GST/HST remittances
- Provincial sales taxes
- Payroll source deductions
- Corporate income-tax instalments
- Corporate income-tax balances
- Property taxes
- Customs duties
- Workers’ compensation payments
- Employer health taxes
- Other provincial obligations
Most GST/HST payments are due at the same time as the associated return, but the actual deadline depends on the business’s reporting period. GST/HST instalments, where required, are generally due within one month after the end of each fiscal quarter.
Corporate tax instalments may be monthly or quarterly depending on whether the corporation meets the applicable requirements. The dates should be confirmed using the company’s CRA account and advice from its tax professional.
Taxes collected on behalf of the government should not be mistaken for operating profit.
Step 8: Include Debt and Financing Activity
Enter all scheduled financing transactions, including:
- Loan principal payments
- Loan interest
- Equipment-financing payments
- Vehicle leases
- Line-of-credit interest
- Credit-card repayments
- Shareholder-loan repayments
- New loan proceeds
- Owner contributions
- Government funding
- Investor funding
Only include new financing when the facility has been approved and the expected funding date is reasonably certain.
A pending bank application should not be treated as available cash.
You may include it in a separate scenario to understand what the forecast would look like if financing is approved.
Step 9: Include Capital Purchases and One-Time Costs
Capital spending can quickly change the forecast.
Examples include:
- New machinery
- Computers
- Vehicles
- Leasehold improvements
- Office furniture
- Security deposits
- Business-acquisition costs
- Legal settlements
- Major repairs
- New-location costs
Record the cash payment, not the accounting depreciation expense.
When an equipment purchase is financed, show the deposit and scheduled financing payments rather than the full equipment value as an immediate cash outflow, unless the entire amount will be paid at purchase.
Step 10: Calculate Weekly Closing Cash
For each week, calculate:
Total inflows − total outflows = net cash movement
Then:
Opening cash + net cash movement = closing cash
For example:
| Forecast item | Week 1 |
|---|---|
| Opening bank balance | $75,000 |
| Customer receipts | $42,000 |
| Other receipts | $3,000 |
| Total cash available | $120,000 |
| Payroll | $28,000 |
| Suppliers | $31,000 |
| Rent and overhead | $9,000 |
| Tax remittance | $15,000 |
| Loan payments | $4,000 |
| Total cash paid | $87,000 |
| Closing cash balance | $33,000 |
The $33,000 closing balance becomes the Week 2 opening balance.
Continue the calculation through Week 13.
Step 11: Set a Minimum Cash Threshold
A positive closing balance does not always mean the business has enough cash.
A company ending a week with $5,000 may technically remain positive, but that amount may be dangerously low when the next payroll is $30,000.
Set a minimum operating-cash threshold based on:
- Normal weekly expenses
- Payroll requirements
- Supplier commitments
- Seasonal volatility
- Customer concentration
- Available credit
- Management’s risk tolerance
Highlight every week in which forecast cash falls below the minimum threshold.
These are the weeks requiring management attention.
Step 12: Build More Than One Scenario
A single forecast may create false confidence.
Build at least three versions:
Base case
This represents management’s most reasonable expectation.
Downside case
Assume that:
- Major customers pay later
- New sales are lower
- Costs increase
- A project is delayed
- Financing is not approved on time
Upside case
Assume that:
- Customers pay earlier
- Sales exceed expectations
- A large contract closes
- Costs remain controlled
Scenario planning helps management understand which assumptions create the greatest financial risk.
Aterna Advisors’ advisory services similarly emphasize using forecasts and “what-if” scenarios to identify potential problems and opportunities before making major business decisions.
Step 13: Turn It Into a Rolling Forecast
A 13-week forecast should not be prepared once and forgotten.
At the beginning of each week:
- Replace the previous week’s forecast with actual cash received and paid.
- Compare actual results with the forecast.
- Investigate significant differences.
- Update the remaining 12 weeks.
- Add a new Week 13.
- Review low-cash weeks.
- Assign actions and owners.
This process keeps the forecast at 13 weeks and improves its reliability over time.
For example, suppose you expected a customer to pay $25,000 in Week 2, but the payment was delayed. Move it to the updated expected week and review whether the delay creates a payroll or supplier-payment problem.
How to Analyse Forecast Variances
The forecast becomes more valuable when you compare projections with actual results.
Common variances include:
- Customers paying later than expected
- Sales being lower than forecast
- Payroll being higher because of overtime
- Inventory purchases occurring earlier
- Supplier prices increasing
- Unexpected repairs
- Tax payments being omitted
- Loan payments being entered incorrectly
- Credit-card spending being underestimated
Do not only correct the number. Identify why the difference occurred.
Repeated collection delays may indicate that the company needs better invoicing and accounts-receivable procedures. Repeated cost overruns may reveal a pricing, purchasing or operational-control problem.
What to Do When the Forecast Shows a Cash Shortfall
A projected shortfall is not a failure of the forecast. It is the reason the forecast exists.
The earlier management sees the problem, the more options it may have.
Possible actions include:
- Contacting customers before invoices become overdue
- Requesting deposits or progress payments
- Offering electronic payment methods
- Reviewing credit terms
- Delaying non-essential purchases
- Reducing excess inventory
- Negotiating supplier-payment timing
- Rescheduling capital spending
- Using available lines of credit
- Seeking working-capital financing
- Reducing owner withdrawals
- Improving margins on low-profit work
- Selling unused assets
- Controlling discretionary expenses
Avoid treating tax funds or payroll deductions as available financing. Late remittances can result in interest, penalties and additional compliance problems. CRA guidance describes payroll deductions as amounts employers are responsible for remitting according to their assigned schedule.
Common Forecasting Mistakes
Using accounting revenue instead of cash receipts
Record when customers are expected to pay, not when invoices are issued.
Assuming every customer will pay on time
Use individual customer history and confirmed payment dates.
Forgetting sales taxes
GST/HST collected is not unrestricted business income.
Omitting annual and quarterly expenses
Review the calendar for insurance, licences, subscriptions, tax payments and other irregular costs.
Ignoring credit-card payments
A business may record purchases today but experience the cash impact when the card balance is paid.
Entering unapproved financing
Do not rely on a loan until approval and funding are sufficiently certain.
Forecasting only the total bank balance
Separate receipts and payments into meaningful categories so management can understand what is driving the result.
Never comparing forecasts with actual results
Without variance analysis, the same forecasting errors will continue.
Allowing too many people to edit the file
Assign one person to maintain the model while department leaders provide their expected receipts and spending.
Making the forecast unnecessarily complicated
A forecast should contain enough detail to support decisions, but not so much that it becomes impossible to update each week.
Who Should Maintain the Forecast?
In a small business, the forecast may be maintained by:
- The owner
- A bookkeeper
- A controller
- An accountant
- A fractional CFO
- A financial advisor
The person preparing the forecast needs access to current information from sales, operations, payroll, purchasing and management.
Bookkeeping records are essential because they provide the starting information, but forecasting goes beyond recording historical transactions. It requires management assumptions about what will happen next.
Aterna Advisors provides accounting, budgeting, cash flow management and business-forecasting support designed to help owners make decisions using timely financial information.
A Simple Weekly Review Agenda
A useful cash flow meeting does not need to be long.
Review:
- Current bank position
- Previous week’s forecast versus actual results
- Large customer receipts expected
- Overdue accounts receivable
- Major supplier and payroll payments
- Tax and debt obligations
- Lowest projected cash week
- Available credit
- Decisions required
- Person responsible for each action
Focus the discussion on actions, not only numbers.
Final Thoughts
A 13-week cash flow forecast gives Canadian business owners a practical view of their short-term financial position.
It does not predict the future perfectly. Its purpose is to show what may happen based on the best available information and to help management respond before a cash shortage becomes urgent.
The strongest forecasts are:
- Updated every week
- Based on expected payment dates
- Connected to accurate bookkeeping
- Compared with actual results
- Tested using different scenarios
- Used to make decisions
When prepared properly, a 13-week forecast can help a business plan payroll, manage tax obligations, improve collections, control spending and approach lenders before additional financing becomes critical.
Aterna Advisors can help Canadian business owners prepare realistic cash flow forecasts, evaluate financial risks and develop practical plans for growth or challenging operating periods.
