Ontario-based accounting & tax supportClear books. Better decisions.

Bookkeeping & Self-Employment

13-Week Cash Flow Forecast: A Practical Guide for Small Businesses

By Presyz Accounting · · 6 min read

At a glance

A 13-week cash-flow forecast estimates how much money a business expects to receive and pay each week over the next three months. It helps an owner see a cash shortage before it happens, even when the business is profitable on paper. The forecast focuses on payment timing: when customers are likely to pay, when payroll is due, when suppliers need to be paid and when tax obligations fall.

A forecast is not a promise that the cash will arrive exactly as shown. It is a planning tool built from current information and assumptions. Its value comes from updating those assumptions as invoices are paid, projects change and new expenses appear.

Why use 13 weeks?

Thirteen weeks gives a business a view across roughly one quarter. That is long enough to see several payroll cycles, customer collection patterns, supplier commitments and upcoming tax payments, while remaining short enough to estimate individual weeks with reasonable detail.

An annual budget is useful for planning revenue and costs over a longer period, but it may not show which Friday the bank balance will fall below the amount needed for payroll. A 13-week forecast is more operational: it shows the timing and amount of cash movement.

What goes into the forecast?

Start with the opening cash balance from the bank accounts included in the forecast. Add expected cash receipts by week, then subtract expected payments. The closing cash for one week becomes the opening cash for the next week.

  • Customer receipts, including expected collection dates for outstanding invoices.

  • New sales expected to be collected during the forecast period.

  • Payroll, employer costs and benefit payments on their actual payment dates.

  • Supplier invoices, subcontractors, rent, insurance and recurring expenses.

  • GST/HST and payroll remittances on the applicable due dates.

  • Loan payments, lease payments, equipment purchases and other commitments.

  • Owner contributions or withdrawals, where applicable and properly planned.

Do not count an invoice as cash merely because it has been issued. Estimate when the customer is expected to pay, based on the contractual due date and actual payment history. If the timing is uncertain, place the receipt in a later week or create a separate cautious scenario.

Build the forecast one week at a time

Create 13 columns, one for each week. Record the opening bank balance, expected receipts and expected payments. Calculate the closing balance. Keep the assumptions visible so someone reviewing the forecast can understand why a $12,000 customer payment has been placed in week four rather than week two.

A basic format can be simple: opening cash plus receipts, less payments, equals closing cash. More detailed forecasts can separate operating cash, payroll, HST, debt, capital spending and other movements. The format should match the decisions the owner needs to make.

Worked example: a cash shortage appears in week three

Assume a small service business begins the forecast with $12,000 in the bank. The owner expects the following receipts and payments. All amounts are illustrative and do not represent a recommended cash reserve for every business.

  • Week 1: receive $3,000 and pay $5,500; closing cash is $9,500.

  • Week 2: receive $2,500 and pay $4,100; closing cash is $7,900.

  • Week 3: receive $800 and pay $5,000; closing cash is $3,700.

  • Week 4: receive $6,000 and pay $3,200; closing cash is $6,500.

The business may have enough revenue over the month, but the lowest projected cash balance is $3,700 in week three. If management has identified $5,000 as the minimum operating buffer, the forecast shows a potential $1,300 gap. That is useful information while there is still time to follow up on invoices, review discretionary spending or arrange appropriate funding.

Scenario A: a customer says payment is coming

A customer owes $7,000 and says payment will arrive next week. The business should consider its payment history and whether there is a confirmed remittance date. If the customer often pays late, the cautious forecast may place the receipt a week later. A best-case forecast can show the effect of receiving it on time.

Do not make an essential payment dependent on an unconfirmed customer promise without considering the downside. The forecast should show the difference between confirmed cash and expected cash.

Scenario B: payroll and HST fall in the same week

An employer has payroll scheduled and a GST/HST payment due during the same week. These are separate cash obligations, and the owner should plan for both. The cash forecast can show the dates and amounts so the business does not mistake the bank balance before remittance for money available to spend.

The employer should not solve a cash shortage by casually delaying payroll or tax remittances. If the forecast shows a risk, review lawful options early and confirm the applicable payment deadlines and responsibilities.

Scenario C: a business is planning to buy equipment

A business wants to purchase $9,000 of equipment. The budget may show that the purchase fits within the annual plan, but the 13-week forecast shows whether the payment will leave enough cash for payroll, suppliers and tax obligations. Management can compare paying now, staging the purchase or arranging financing, while considering the total cost and business need.

How to make the forecast more accurate

Use the accounts receivable report to identify invoices and realistic collection dates. Use supplier bills and recurring schedules to map out payments. Use the payroll calendar and CRA account information for payroll remittances. Use the GST/HST reporting calendar for tax payments. Update the forecast with actual bank activity each week rather than keeping old estimates after circumstances have changed.

Separate fixed commitments from discretionary spending. Rent and payroll are different from an optional marketing project or equipment upgrade. Do not treat every planned payment as equally flexible, and do not assume that a tax due date can be moved simply because cash is low.

Create three versions when the future is uncertain

A base forecast uses the most likely assumptions. A cautious forecast assumes selected customer receipts are delayed, sales are lower or costs are higher. A stronger forecast assumes a new contract or an expected payment arrives on time. The difference between the three helps owners understand what could happen and which assumptions matter most.

For a cautious version, move uncertain receipts later rather than changing every line by an arbitrary percentage. For a stronger version, add the expected contract only when the key conditions are clear. Note any assumptions that still need confirmation.

What a 13-week forecast cannot do

A forecast cannot guarantee customer payments, prevent unexpected costs or replace accurate bookkeeping. If the opening cash balance is wrong or unpaid invoices are missing, the forecast will be unreliable. It should also be used with a longer-term budget and financial statements rather than in isolation.

A cash-flow forecast is different from a profit forecast. A loan principal payment reduces cash but is not generally an income-statement expense. Depreciation is an expense in the profit and loss statement but does not usually involve a cash payment in the week it is recorded. HST collected may increase the bank balance temporarily but should not be treated as unrestricted revenue.

Presyz offers fractional CFO support for businesses that need practical cash-flow forecasting, budgeting and financial planning. For reliable opening balances and customer records, see

A weekly cash-flow review checklist

  • Update the opening bank balance using actual records.

  • Mark receipts as confirmed, expected or uncertain.

  • Check overdue customer balances and update likely collection dates.

  • Add payroll, tax, supplier and debt payments on their actual due dates.

  • Compare forecast closing cash with the minimum operating buffer.

  • Review what changed since the previous forecast and why.

  • Roll the forecast forward one more week.

Frequently asked questions

Is a 13-week forecast only for businesses in financial trouble?

No. It is useful for growing businesses, seasonal businesses and companies planning a hire or large purchase. The forecast can help an owner see the timing of cash needs before a shortage appears.

Should I include HST in sales receipts?

Include the actual cash received from customers, which may include HST, but keep the tax component identified as a liability to be remitted where applicable. Do not treat tax collected as unrestricted sales income.

How often should I refresh it?

A weekly refresh is common for a 13-week forecast. Replace estimates with actual results and update future weeks as invoices, payroll and payment commitments change.

Official references

CRA: GST/HST records and reporting.

CRA: Payroll remittance due dates.

General educational content only. Verify current CRA and provincial guidance before acting.

A PRACTICAL NEXT STEP

More clarity for your next business decision.

We can help with flexible cash-flow planning, budgeting and meaningful financial insight as your business grows.

Explore Fractional CFO services
Contact Us Tell us what you need. We’ll help clarify the next step.