Consulting Services
How to Build a 13-Week Cash-Flow Forecast for an Ontario Business
Build a rolling 13-week cash forecast using realistic collections, committed payments and scenarios. Includes worked examples and BDC and CRA sources.
Sources checked: . General educational information; no individual professional review is implied.
On this page
A cash-flow forecast is a decision tool for the weeks ahead. It estimates when money will enter and leave the business and shows the resulting cash balance. For an Ontario owner-managed business, that can help identify a shortfall before payday, a tax remittance, a supplier payment, or a planned purchase. The value is not a promise that the future will match the spreadsheet. It is a structured way to examine assumptions and choose actions early.
This guide describes an original practical approach to a rolling 13-week forecast. BDC offers tools for both 13-week and twelve-month cash planning [1]. The method here is a management recommendation, not a statutory format or financing guarantee. All examples are hypothetical. Tax and payroll obligations must be determined using applicable official guidance and your facts; forecast entries do not change those obligations. Obtain advice before relying on projections for a material financing or investment decision.
Separate cash from profit
Profit measures performance under the relevant accounting basis; cash reflects actual receipts and payments. A customer invoice may be recorded before it is collected. Equipment purchases and loan repayments may use cash without being identical expenses in the same period. Owner funding can increase cash without representing sales. These distinctions are essential before building a forecast.
Suppose a hypothetical business reports $15,000 of monthly profit but has $10,000 of customer invoices still unpaid and a $7,000 equipment payment. Profit alone does not show whether cash will be available for next week's wages. A full reconciliation can involve other balances and adjustments, but the simple example explains why a separate cash schedule is needed.
Use the financial-statements guide to understand historical reporting, then build the forecast from expected payment dates. Do not simply copy revenue and expense totals into weekly columns. Ask when each amount is expected to move through the bank and how confident you are about that timing. A profitable business can still experience a timing shortage that needs a collection or financing response.
Establish a verified opening cash position
Begin with reconciled bank balances and identify which funds are available for the forecast's purpose. Outstanding payments, restricted balances, or commitments may affect interpretation. State the forecast's start date and accounts included. A screenshot of one account may omit another account's obligations or a payment already authorized but not yet cleared.
For an illustration, the bank shows $22,000, but an approved $4,000 supplier payment remains outstanding. The forecast must handle that payment consistently: either adjust the opening available position or include the outflow once in the schedule, according to the chosen method. Do not subtract it twice or ignore it. Explain the approach so users can reproduce the starting point.
Keep the forecast linked to reconciliations and outstanding-item schedules. If the opening balance is unreliable, future calculations can look precise while resting on a faulty foundation. Before considering growth assumptions, resolve missing statements, unexplained transfers, and duplicated transactions. Reliable bookkeeping and a practical close process are prerequisites for dependable cash planning, not separate administrative projects.
Forecast receipts by realistic collection date
Use customer invoices, contracts, payment histories, and current communication to estimate receipts. Invoice due dates are a starting point, not proof that cash will arrive. Separate confirmed payment commitments from assumptions and uncertain prospects. A proposed sale should not have the same confidence level as a payment already scheduled by a reliable customer.
For example, a hypothetical $12,000 invoice due in week two has a history of customer payment after internal approval. If approval has not occurred, showing the entire amount as certain in week two can conceal risk. Ask what evidence supports the expected date and model a delay. Document the owner of collection follow-up and the next contact date.
Avoid counting receipts twice across a sales forecast and an aged-receivable schedule. Existing invoices and future sales need a clear boundary. Refunds, credits, processor reserves, and net settlement arrangements also require consideration. Use the amount expected to reach the bank while preserving the underlying explanation. The forecast should make uncertainty visible rather than smooth it away.
List committed outflows first
Start with known supplier invoices, rent, scheduled financing payments, payroll, taxes, and other commitments. Identify dates and amounts from supporting records. Then add estimated operating costs and planned discretionary spending. Separating committed and discretionary items helps management see which decisions remain open and which obligations cannot simply be postponed by editing the spreadsheet.
Use current contracts and statements rather than last year's average alone. A renewal, annual subscription, insurance payment, or equipment deposit may create a concentrated outflow in one week. A monthly average can hide that peak. If an amount is uncertain, state the basis and show a range or scenario instead of presenting an unsupported exact figure.
Include owner withdrawals or distributions only with appropriate consideration of the entity and circumstances. Cash availability alone does not settle whether a proposed payment is permitted or has tax consequences. The forecast can display a proposed outflow, but it does not authorize it. Obtain professional advice about material owner transactions and financing restrictions before making a commitment.
Treat tax and payroll obligations explicitly
GST/HST, income tax, payroll remittances, and employee pay are different obligations with potentially different periods and deadlines. CRA separates those workstreams in its business and payroll guidance [2][3]. Use the actual account requirements and prepared calculations. Do not infer every deadline from a calendar template or assume that monthly bookkeeping means monthly filing.
CRA explains that collected or collectible GST/HST is held in trust and that tax charged generally belongs in the reporting period covering the invoice date, even if not collected [2]. A forecast should therefore consider the cash effect of unpaid customer invoices carrying tax obligations. Do not treat amounts retained for remittance as unrestricted money for growth purchases.
For corporations, CRA states that the T2 filing deadline is generally six months after year-end, while the ordinary tax balance-due day is generally two months, with a three-month rule where specific conditions are met [4][5]. Filing time is not automatic payment time. For a hypothetical 31 December year-end, the ordinary two-month point is the end of February, not June; the actual due date and any extension require confirmation.
Calculate each week's movement transparently
The basic cash equation is opening balance plus receipts minus payments equals closing balance. The closing balance becomes the next week's opening balance under a consistent method. Show the components separately so that a reader can identify which assumptions drive the result. Complex formulas are not a substitute for clear inputs and explanations.
An illustrative week starts with $18,000, expects $9,000 in receipts, and has $14,000 in payments. The projected closing balance is $13,000. If $6,000 of those receipts is delayed, the same week's balance becomes $7,000, assuming other items remain unchanged. The arithmetic shows sensitivity, not a prediction that the customer will or will not pay.
Check totals, signs, dates, and links to source schedules. A negative payment entered as a positive receipt can create a misleading improvement. Keep a notes column for unusual items and avoid overwriting assumptions without preserving the reason. A forecast is easiest to review when calculations are simple enough for another authorized person to follow.
Build scenarios around material risks
Create a base case using reasonable expected assumptions, then test the events most likely to change decisions. Examples include delayed collections, a lower sales volume, a supplier deposit, or an unexpected repair. A scenario should change specific inputs with a clear explanation, not simply reduce every figure by an arbitrary percentage and call it a risk assessment.
For a hypothetical business dependent on two large customers, model one payment arriving two weeks late. Identify the lowest projected balance and the week it occurs. Then test whether a discretionary purchase can be deferred without breaching a commitment. The exercise should produce a decision or trigger, such as beginning a financing conversation before the shortfall becomes urgent.
Do not present scenarios as probabilities unless you have an appropriate basis. A downside case can be useful without claiming a quantified likelihood. Likewise, an optimistic case is not evidence that financing will be approved. Label assumptions, distinguish commitments from possibilities, and explain what information would lead you to update the forecast.
Connect working capital with operating decisions
Receivables, inventory, and supplier terms influence cash timing. A business can grow sales while using more cash to fund work before customers pay. Analyze the timing gap rather than assume increased revenue automatically solves a cash shortage. BDC's cash-planning tools are designed to help examine inflows and outflows over the relevant horizon [1].
Consider a hypothetical service contract requiring $8,000 of delivery costs before a $15,000 customer payment. The overall commercial margin may be attractive, yet the business needs funding during delivery. Ask whether a deposit, milestone billing, or different purchasing schedule is commercially and contractually possible. The forecast reveals the timing issue; it does not decide the contract terms.
Review the practical cause of overdue invoices. Missing documentation, a disputed scope, and genuine customer distress need different responses. A collection target without an operational plan can be ineffective. Assign responsibility for invoice accuracy, approval follow-up, and dispute resolution. Improving the process can be more useful than adding an unsupported assumption that all overdue balances will arrive next week.
Use financing assumptions cautiously
An undrawn facility or proposed loan should be treated according to its actual availability, terms, and approvals. Do not include financing as certain merely because the business intends to apply. Keep the supporting agreement or written confirmation and identify conditions. Understand repayments, costs, security, and restrictions before treating funding as a simple positive cash entry.
For an illustration, a forecast may show a $20,000 financing inflow in week five. If approval is still pending, a separate case without that inflow helps identify the exposure. Include the associated payments and costs where applicable. A model that includes borrowing proceeds but omits repayments can overstate future flexibility.
Discuss material financing questions with appropriate advisers and the lender. This article does not recommend a particular product or determine eligibility. A well-organized forecast can support a conversation, but it does not guarantee approval, a rate, or adequate funding. Present assumptions honestly and retain versions so changes in the financing plan can be understood.
Update weekly and learn from differences
A rolling forecast should be refreshed with actual receipts and payments and extended with a new future week. The weekly frequency is a recommended management practice for this method, not a legal requirement. Compare actual results with the prior forecast and distinguish timing differences from permanent changes. A delayed receipt and a lost sale require different updates.
Suppose $5,000 expected in week three arrives in week four. Record the timing difference and revise later assumptions if the delay reveals a pattern. If the invoice is disputed, do not simply move it one week forward indefinitely. Document the collection status and consider an appropriate downside treatment. Repeatedly rolling uncertain items forward can hide the problem.
Keep an action log alongside the forecast. Record the decision, owner, deadline, and evidence needed. Limit distribution to appropriate users because projections can contain sensitive commercial information. An accessible version history helps explain why a purchase or financing decision was made on the information available at the time.
Make the forecast part of governance
Agree who prepares inputs, reviews assumptions, and approves significant decisions. The forecast should not become an isolated spreadsheet known only to its creator. Define the questions considered at the cash meeting: the lowest balance, collections at risk, obligations due, discretionary spending, and financing status. Keep the meeting focused on actions rather than arguing about spreadsheet formatting.
Use thresholds appropriate to your business for further review, but do not portray them as universal industry rules. A minimum cash buffer depends on obligations, volatility, available financing, and risk appetite. When circumstances materially change, revisit both the assumptions and the decision process. A forecast that once worked well may need revision as the business adds staff, locations, or new services.
LMAR's consulting and accounting pages describe relevant support. Bring reconciled balances, aged receivables, commitments, financing terms, and your current assumptions to a discussion. The forecast is a framework for informed judgment, not a guarantee against cash shortages. Verify tax and payroll requirements, seek tailored advice for material decisions, and use the month-end and financial-statements guides to strengthen the underlying information.
Official sources & research dates
Numbered references link to the official pages below. Source page modification dates are shown only where supplied by the publisher. A source-check date is not a professional sign-off, and rules may change. Some BDC downloads require a form; their linked explanatory pages are publicly readable.
- Cash flow calculator: 13-week and 12-month planningBusiness Development Bank of Canada · Checked October 18, 2026Back to sources
- Charge and collect GST/HST: rates, invoices and reportingCanada Revenue Agency · Checked October 18, 2026 · Source modified April 8, 2026Back to sources
- Payroll: setup, deductions, remittances and information returnsCanada Revenue Agency · Checked October 18, 2026 · Source modified February 16, 2026Back to sources
- When to file your corporation income tax returnCanada Revenue Agency · Checked October 18, 2026 · Source modified May 26, 2025Back to sources
- Corporation tax balance-due dayCanada Revenue Agency · Checked October 18, 2026 · Source modified January 21, 2026Back to sources