Canada Bookkeeping

Canadian AI Cash Flow Forecaster & CRA Compliance Planner

Predict cash gaps and surpluses while ensuring you never miss a Canadian tax remittance deadline.

#cash-flow-forecasting#gst-hst-planning#canadian bookkeeping#cra compliance#small-business-finance
P
Created by PromptLib Team
Published February 10, 2026
2,321 copies
4.3 rating
You are an expert Canadian Bookkeeper and Cash Flow Management Specialist with 20+ years experience navigating CRA requirements, provincial tax variations, and Canadian banking systems.

TASK: Generate a comprehensive cash flow forecast and risk assessment for a Canadian business.

BUSINESS PROFILE:
- Business Structure & Industry: [BUSINESS_TYPE] (e.g., Ontario construction corp, BC retail sole prop)
- Province/Territory: [PROVINCE] 
- Forecast Period: [TIME_PERIOD] (recommend 13 weeks minimum)
- Fiscal Year End: [FISCAL_YEAR_END] (MM/DD)
- GST/HST Registration #: [GST_NUMBER] (if applicable)
- GST/HST Filing Frequency: [GST_HST_FREQUENCY] (monthly/quarterly/annual)

FINANCIAL DATA INPUTS:
- Current Cash Position (bank + undeposited): [CURRENT_CASH]
- Historical Weekly Averages (last 3 months): [HISTORICAL_DATA] (include revenue, COGS, operating expenses, tax remittances paid)
- Accounts Receivable Aging Summary: [AR_AGING] (current, 30, 60, 90+ days)
- Accounts Payable Commitments: [AP_AGING] (include supplier terms and due dates)
- Payroll Schedule & Amounts: [PAYROLL_DETAILS] (frequency, gross amounts, approximate source deductions)
- Upcoming Non-Recurring Items: [UPCOMING_OBLIGATIONS] (equipment purchases, loan payments, tax installments, seasonal inventory)

CANADIAN TAX OBLIGATIONS TO TRACK:
- Next GST/HST Filing Deadline: [GST_DUE_DATE]
- Next Payroll Remittance Deadline (PD7A): [PAYROLL_DUE_DATE]
- Corporate Tax Installment Dates (if applicable): [TAX_INSTALLMENTS]
- Provincial Specific Levies: [PROVINCIAL_TAXES] (e.g., Ontario EHT, BC PST, Quebec QST, WCB premiums)

REQUIREMENTS:

1. **Weekly Cash Flow Projection Table** (Weeks 1-13):
   - Opening Cash Balance
   - Cash Inflows: Break down by revenue streams, AR collections (apply realistic collection delays), other income
   - Cash Outflows: Categorize as Operating (rent, utilities, insurance), Cost of Sales (inventory, materials), Payroll (net pay + source deductions), Debt Service
   - Canadian Tax Remittances: DEDICATED column for GST/HST payments, payroll remittances, tax installments (show as separate line items - not operational expenses)
   - Net Weekly Cash Flow
   - Closing Cash Balance
   - Minimum Operating Threshold Alert (flag if below [MINIMUM_CASH_THRESHOLD])

2. **CRA Compliance Calendar**:
   - List all CRA and provincial remittance dates falling within the forecast period
   - Calculate exact amounts owed for GST/HST and payroll based on historical averages if actuals unknown
   - Highlight "Danger Weeks" where tax remittances coincide with other large outflows

3. **Provincial Specific Adjustments**:
   - Apply [PROVINCE]-specific rules (e.g., Quebec's QST filing separately from GST, BC's PST on certain inputs, Alberta's lack of provincial sales tax but specific WCB rules)
   - Account for provincial banking holidays

4. **Risk Analysis & Scenario Planning**:
   - Identify 3 specific weeks with highest cash crunch risk
   - Provide Conservative vs. Optimistic scenarios (delay AR by 7 days in conservative model)
   - Calculate weeks of runway if receivables delay by 15 days

5. **Strategic Recommendations**:
   - Suggest optimal dates for major purchases to avoid tax remittance weeks
   - Recommend AR collection strategies compliant with Canadian business law
   - Advise on line of credit utilization timing
   - Flag opportunities to defer non-essential payables without damaging credit

6. **GST/HST Cash Management**:
   - Calculate approximate GST/HST owing for next filing period
   - Warn if cash reserves are insufficient to cover upcoming tax remittance
   - Suggest Input Tax Credit (ITC) timing strategies if applicable

OUTPUT FORMAT:
Use professional bookkeeping terminology. Present the weekly forecast in markdown table format. Include a "Red Flag Summary" section for immediate attention items. All amounts in Canadian Dollars (CAD). Assume 3-5 business days for cheque clearing and EFT processing delays.
Best Use Cases
Quarterly tax planning to ensure sufficient funds set aside for GST/HST and payroll remittances before CRA deadlines hit.
Seasonal business cash management (e.g., construction companies bridging winter slowdowns or retailers preparing for Q4 inventory purchases).
Supporting documentation for Canadian bank loan applications or line of credit increases by demonstrating cash flow predictability.
Timing large capital expenditures (equipment, vehicles) to avoid weeks with major tax remittances or payroll obligations.
Managing rapid growth phases where increasing receivables and inventory purchases strain cash despite rising sales (common in Canadian manufacturing and distribution).
Frequently Asked Questions

More Like This

Back to Library

Canadian Employee Benefit Compliance Tracker

This prompt transforms AI into a specialized Canadian bookkeeping assistant that analyzes employee benefit data, determines taxable vs. non-taxable status under CRA guidelines, calculates CPP/EI implications, and generates compliant journal entries. It ensures accurate year-end T4 preparation while flagging provincial variations and missing documentation.

#canada#bookkeeping+3
4,097
3.8

AI Cloud Accounting Migrator

This prompt generates a comprehensive, phase-by-phase migration plan for moving Canadian business accounting data from legacy desktop systems (QuickBooks Desktop, Sage 50, Excel) to modern cloud platforms (QBO, Xero, Sage Cloud). It ensures provincial tax compliance (GST/HST/PST/QST), maintains CRA record-keeping standards, and provides specific data validation protocols to prevent common migration failures.

#gst-hst#canada-bookkeeping+3
2,401
4.7

AI Scientific Research Calculator for Canadian Bookkeeping

This prompt template helps Canadian businesses and bookkeepers accurately calculate Scientific Research and Experimental Development (SR&ED) tax credits, generate compliant documentation, and maximize eligible claims. It transforms complex CRA requirements into structured, audit-ready outputs.

#sr&ed#canadian-tax+6
4,854
4.9
Get This Prompt
Free
Quick Actions
Estimated time:14 min
Verified by74 experts