Build a cash flow forecast lenders can follow

The principle

Begin with available opening cash, then estimate receipts and payments for each period. Use weeks for near-term pressure and months for a longer project. Include payroll, suppliers, taxes, rent, debt service, capital spending, and owner distributions. Separate confirmed events from assumptions so changes can be traced.

Put it into practice

Model receipts when customers are expected to pay, rather than when an invoice is issued. Apply realistic collection delays and seasonality. Add the proposed financing as an inflow only when its conditions could actually be met, then include every related payment and fee. Identify the lowest cash point and the buffer required around it.

What people often miss

A forecast that always balances because borrowing is assumed to fill every gap is circular. Test a delayed customer, lower sales, and an expense overrun. Check whether facility limits and collateral still permit the planned draws. Update the model against actual results so forecasting becomes an operating discipline rather than a document created only for the lender.

Separate the business result from the bank balance

A profitable month can still produce a cash shortage. An invoice may be recognized as revenue before the customer pays; equipment may consume cash without becoming a single immediate operating expense; loan principal uses cash without being an income-statement expense. BDC's cash-flow guidance distinguishes profit from actual cash movement. Build the forecast around the dates money is expected to enter or leave the bank.

Start the bank-cash forecast with the actual reconciled opening bank balance. Show every expected receipt and payment once. Maintain a separate calculation of cash reserved, restricted or committed for specific obligations. This shows both where the bank balance will land and how much is available for another purpose. Show undrawn borrowing capacity separately, with its conditions for access; a credit limit is not cash already received.

Give every important assumption an owner

For near-term decisions, a weekly forecast makes payroll and supplier dates visible. BDC describes a rolling 13-week forecast as a useful cash-management tool. A longer monthly view can explain a seasonal cycle or expansion. Make the weekly and monthly views consistent where they overlap; do not maintain two conflicting versions of the same future.

Attach an assumption register: customer, amount, expected collection date, confidence level and person checking it. Model new sales using realistic payment timing, not immediate collection by default. Include taxes, debt payments, equipment deposits and owner withdrawals. Put prospective financing in a conditional scenario until availability and timing are supported. Record what must happen before the proposed money could arrive.

Worked example: a delay changes the funding question

Fictional example, in one currency: opening bank cash is $30,000, with no separate reserve assumed. In week one, $18,000 arrives and $28,000 leaves, giving $20,000 closing cash. Week two has $25,000 of receipts and $35,000 of payments, leaving $10,000. In week three, receipts of $45,000 and payments of $30,000 restore cash to $25,000. These are assumed cash movements, not a lender forecast or recommendation.

Now move $15,000 of week-two receipts into week four, keeping every other assumption unchanged. Week two falls to negative $5,000. If management also wants a $10,000 operating buffer, the gap to that buffer is $15,000, not merely the $5,000 negative balance. Possible responses need their own evidence: accelerated collections, agreed payment timing, available owner funds or confirmed financing. Do not silently force the spreadsheet to balance.

A weekly operating routine

BDC recommends comparing actual cash movements with projections and adjusting the forecast. Preserve the prior version so you can learn why the estimate changed rather than overwrite the evidence.

• Replace the completed week with actual bank movements and reconcile the opening balance.
• Explain material collection or spending differences; distinguish timing changes from permanent changes.
• Roll the model forward and refresh customer commitments, payroll, taxes and supplier due dates.
• Recalculate the lowest cash point and available capacity under the actual financing terms.
• Assign actions with owners and dates, then check whether last week's actions happened.

Questions to test before sending it to a lender

Ask: Which receipt would hurt most if it arrived late? What changes if sales fall while fixed costs remain? Have the proposed loan's fees and every repayment been included? Is a seasonal draw actually available under the facility's collateral or reporting conditions? What cash buffer is management trying to protect, and why?

A forecast is a decision aid with assumptions, not a guarantee that cash or credit will be available. U.S. and Canadian tax deadlines, sales-tax treatment and payroll obligations depend on the business and jurisdiction. Confirm those dates with the appropriate adviser; a generic template should not decide them.

Worked example: a reserve is not a second payment

Fictional example in one currency: the bank holds $50,000, including $8,000 reserved for a tax payment. Available cash before other commitments is $42,000. If the $8,000 is paid and nothing else changes, the bank balance falls to $42,000 and that reserve falls to zero. Available cash remains $42,000. Starting at $42,000 and subtracting the same $8,000 again would incorrectly show $34,000.

If you begin with a net available-cash figure, reconcile excluded amounts explicitly. Do not deduct a tax or payroll reserve from opening cash and then subtract its payment again without releasing the corresponding reserve. Whether money is legally restricted, held in trust or simply earmarked by management depends on the obligation and jurisdiction.

Show the cash effect of taxes and currency

For Canadian GST/HST registrants, expected customer receipts and supplier payments may include tax amounts that are not operating revenue or expense. CRA guidance explains that tax collected must be held in trust and that reporting can depend on invoice timing even before payment arrives. Forecast remittances and eligible recoveries using the business’s actual reporting obligations. Do not treat a predicted refund as cash already received.

U.S. sales-tax obligations require state and local analysis; Canadian GST/HST rules should not be applied to a U.S. forecast. If the business receives and pays different currencies, retain each currency’s cash schedule and document conversion timing, assumed exchange rates and charges. A single converted total can hide a shortage in the account that must make the payment.

Source: CRA: Charging and collecting GST/HST

Your next-step checklist

• Opening available cash
• Dated receipts and obligations
• Financing conditions and payment schedule
• Downside scenarios and actual-versus-forecast updates