Are you profitable on paper but still sweating payroll? You’re not alone. For many owners in Alberta, Saskatchewan, and BC, timing—not revenue—is the biggest cash challenge. The good news: a simple cash-flow forecast can give you clear visibility weeks (or months) ahead so you can plan with confidence, not panic.
At Big Country Accounting Group, we help entrepreneurs, family businesses, and growing companies turn uncertainty into action. Here’s a straightforward way to get started.
What Is Cash-Flow Forecasting—and Why It Matters
Cash-flow forecasting estimates how much cash will come in and go out of your business over a set period. It helps you:
- See cash crunches before they happen
- Decide when to invest, hire, or delay spending
- Align timing for GST/HST, PST, payroll, and corporate tax payments
- Communicate clearly with lenders and investors
If your books are up to date (hello, calgary bookkeeping services), a forecast is simpler than you think.
The 13-Week Cash-Flow Forecast: Your Best Starting Point
Thirteen weeks (one quarter) is long enough to catch seasonal swings, yet short enough to be accurate. Here’s how to build it.
Step 1: Start With Opening Cash
- List your bank balance(s) as of Day 1.
- Include available line of credit (LOC) limits separately.
Step 2: Map Cash Inflows by Week
- Customer receipts: Use your AR aging report, add expected payment dates per customer.
- New sales: Forecast conservatively using your average conversion cycle.
- Other inflows: Grants, loans, GST/HST refunds, seasonal deposits.
Tip: If you offer net-30 terms but customers pay in 45 days on average, use 45 in your model.
Step 3: Map Cash Outflows by Week
- Payroll and source deductions: Align with pay dates and CRA remittance deadlines. If you use payroll services calgary, ask for a schedule export.
- Rent, utilities, subscriptions: Plug in calendar dates.
- Inventory and COGS: Time payments to supplier terms (e.g., 50% deposit, 50% on delivery).
- Taxes: Add quarterly corporate tax instalments, GST/HST and PST BC dates.
- Debt and leases: Loan payments, credit card due dates, equipment leases
Step 4: Add Seasonality and One-Offs
- Busy seasons (e.g., construction and agriculture) often need working capital ramp-ups.
- Lumpy expenses like insurance renewals, property taxes, or equipment purchases.
- Don’t forget owner draws or dividends if applicable.
Step 5: Calculate Weekly Ending Cash
- Beginning cash + inflows – outflows = ending cash
- Flag negative weeks to trigger action (collections, financing, expense deferrals).
Step 6: Review Weekly and Update
- A forecast is a living document. Update assumptions as invoices are paid, projects shift, or prices change.
- Tie this into your monthly bookkeeping services to keep it clean and actionable.
A Simple Example
A Calgary landscaping company expects $80,000 of receipts over the next four weeks, mostly from jobs just completed. Payroll runs bi-weekly at $22,000 (including source deductions). Rent is $4,000 monthly. Spring equipment purchases need $15,000 in two weeks. Corporate tax instalment of $6,000 is due next month.
- Week 1: Opening cash $35,000; receipts $25,000; payroll $0; other outflows $3,000; ending cash $57,000
- Week 2: Receipts $20,000; payroll $22,000; outflows $2,000; ending cash $53,000
- Week 3: Receipts $15,000; payroll $0; equipment $15,000; outflows $2,000; ending cash $51,000
- Week 4: Receipts $20,000; payroll $22,000; rent $4,000; tax instalment $0; ending cash $45,000
This owner can see they’re fine near-term but will need to plan for the upcoming corporate tax instalment. With visibility, they can accelerate collections or adjust purchases ahead of time.
Tools That Make It Easy
- Spreadsheet templates: Great for startups and bookkeeping for small businesses. Keep it on one tab with clear categories.
- Cloud accounting: QuickBooks Online and Xero handle AR/AP reports and integrate with cash-flow apps.
- Dashboards: Tie your forecast into calgary financial forecasting planning for scenario analysis and KPIs.
If you don’t have time to build and maintain this, our part-time cfo services calgary can set it up, update it, and walk you through decisions.
Western Canada Timing Tips: Avoid the “Surprise” Outflow
- CRA source deductions: Know your remitter frequency (regular, threshold 1, threshold 2). Add due dates to your calendar.
- GST/HST: Quarterly or annual filers often face big lump sums—model these by week, not month.
- PST in BC: Separate this from GST/HST to avoid double-counting. Add filing frequency and deadlines.
- WCB/WSIB and insurance: Annual premiums can create cash spikes—set aside weekly accruals.
- Corporate tax planning: Work with your advisor on instalment strategies, dividend timing, and accelerated CCA so your forecast reflects smart corporate tax planning, not just obligations.
Turn Forecasts Into Decisions: 5 Practical Levers
- Speed up collections
– Offer small early-payment discounts or ACH/credit card options. – Set reminders at invoice + 7 days and invoice + 30 days. - Smooth out payables
– Negotiate supplier terms (e.g., net-45 instead of net-30) in slow months. – Split larger purchases into staged payments. - Right-size inventory
– Use sell-through data to trim slow-moving items. – Align purchase orders with booked work, not forecasts alone. - Align staffing with demand
– Use variable scheduling and cross-training. – Leverage seasonal contracts during shoulder seasons. - Secure flexible financing
– Keep LOCs active and in good standing. – Compare leasing vs. buying to protect cash.
How Big Country Accounting Group Helps
We combine hands-on bookkeeping with forward-looking advice to keep your plan realistic and up to date.
- Calgary bookkeeping services that keep your AR/AP accurate, so your forecast isn’t guesswork
- Monthly bookkeeping services and payroll services calgary to sync timing of receipts, pay runs, and CRA remittances
- Small business financial forecasting and part-time cfo services calgary to build 13-week forecasts, scenarios, and cash dashboards
- Corporate tax planning to reduce surprises and align instalments with cash availability
- Business incorporation calgary guidance to structure new ventures for cash efficiency from day one
- Support for accounting for families in alberta with seasonal or multiple-income streams who need cash clarity across business and household budgets
Real-World Example
A Saskatoon manufacturing startup faced a recurring cash crunch every quarter when inventory purchases hit before customers paid. We implemented a 13-week forecast, restructured terms with two key suppliers to net-45, and introduced milestone billing for custom orders. With monthly bookkeeping services and a standing cash review, the company smoothed outflows, reduced LOC usage by 28%, and confidently hired two technicians ahead of a busy season.
Quick-Start Template: What to Include
- Opening cash balance
- Inflows: customer receipts, new sales, loans/grants, tax refunds
- Outflows: payroll and source deductions, rent, utilities, subscriptions, inventory/COGS, taxes (GST/HST, PST, corporate), loan/lease payments, insurance, owner draws
- Net cash change and ending cash by week Notes/assumptions section with dates and terms
Update weekly. Save versions so you can see how assumptions evolve.
Additional Local Search Terms We See Owners Use
If you’re researching more on this topic in Western Canada, you might search:
- cash flow forecast alberta
- 13-week cash flow canada
- gst/hst remittance schedule canada
- pst bc filing deadlines
- cra payroll remittance dates
- working capital management calgary
- saskatchewan small business accountant
- bc small business cash flow help
Frequently Asked Questions
How is a cash-flow forecast different from a budget?
A budget sets targets for a period (like annual revenue and expenses). A cash-flow forecast focuses on timing—exactly when cash enters and leaves your bank account. You need both, but the forecast keeps you solvent.
How far ahead should I forecast?
Start with 13 weeks. It balances accuracy with visibility. For capital-heavy industries or high growth, layer a 12-month monthly view for strategic planning.
Do I need special software?
No. A clean spreadsheet works well for most bookkeeping for small businesses. As volume grows, we can integrate your accounting system with forecasting tools for automation and scenario planning.
How often should I update my forecast?
Weekly is best. Tie updates to your bookkeeping cycle, bank feed reconciliation, and sales pipeline review for accuracy and actionable insights.
Ready to See Around Corners?
Cash clarity reduces stress, improves decision-making, and supports growth. Whether you need a simple template or an ongoing advisory partner, Big Country Accounting Group is here to help across Alberta, Saskatchewan, and BC.
Contact us to set up your cash-flow forecast and align it with your operations, taxes, and growth plans. Let’s turn uncertainty into a plan—so you can lead with confidence.
