Bookkeeping Software Setup Checklist for Canadian Businesses | Custom CPA
Bookkeeping Software Setup Checklist
📌 Quick Summary
Setting up bookkeeping software correctly from day one is one of the highest-leverage actions a Canadian small business owner can take. A properly configured accounting system means accurate financial reports, seamless CRA compliance, correct GST/HST tracking, and clean data your accountant can actually use. This step-by-step checklist walks through every phase of bookkeeping software setup — from choosing the right platform and configuring your chart of accounts, to connecting bank feeds, setting up payroll, and ensuring your system is fully CRA-compliant before your first transaction is entered.
1. Why Proper Bookkeeping Software Setup Matters
Most Canadian small business owners open their bookkeeping software, create a few accounts, and start entering transactions — without ever doing a proper setup. The result? A chart of accounts that doesn't reflect how the business actually works, GST/HST tracked inconsistently or not at all, bank balances that never quite match, and year-end financials that require hours of cleanup before a CPA can use them.
A well-configured bookkeeping system, on the other hand, practically runs itself. Transactions are automatically categorized, sales taxes are tracked in real time, bank reconciliations take minutes instead of hours, and your accountant can jump straight into tax planning rather than untangling your books. The difference between a good setup and a bad one can easily translate to $1,000–$3,000 in reduced year-end CPA fees — not to mention avoided CRA penalties from incorrect GST/HST filings.
This checklist is designed for Canadian businesses setting up QuickBooks Online, Xero, or Sage 50 for the first time — or cleaning up an existing setup that was never done properly. Work through it phase by phase and you'll have a bookkeeping system that gives you accurate financial data, full CRA compliance, and genuine peace of mind. For a broader picture of what professional bookkeeping involves, see our Monthly Bookkeeping Review Checklist.
⏱️
8 hrs
Average time wasted monthly on poorly set-up bookkeeping systems
💰
$2K+
Typical year-end cleanup cost when books were set up incorrectly
🔒
6 yrs
CRA minimum record retention — your software must be configured to support this
✅
1 day
Time needed for a proper setup — done once, saves years of headaches
ℹ️
The CRA expects businesses to maintain organized, accessible records that support every number on your tax return. A properly configured bookkeeping system is your primary line of defence in a CRA audit — and your primary tool for making better business decisions every day.
🖥️ Need Help Setting Up Your Bookkeeping Software?
Custom CPA configures QuickBooks, Xero, and Sage for Canadian businesses — done right the first time, fully CRA-compliant.
Before you configure anything, you need to be on the right platform. The three most widely used bookkeeping platforms for Canadian small businesses each have distinct strengths — and the wrong choice will create friction every day. Here's an honest comparison:
QuickBooks Online
🏆 Most Popular in Canada
~$35–$100/month
Full Canadian GST/HST/PST support
Native payroll add-on
Largest Canadian accountant network
POS & e-commerce integrations
CRA My Business Account integration
Strong mobile app
Xero
Best for Tech-Forward Businesses
~$20–$80/month
Clean, intuitive interface
Unlimited users on all plans
Strong bank feed automation
Good Canadian tax support
500+ app integrations
Excellent reporting
Sage 50 Canada
Best for Inventory-Heavy SMBs
~$60–$200/month
Deep inventory management
Strong Canadian payroll
Desktop + cloud hybrid
Job costing capabilities
CRA-certified for T4/T5
Long track record in Canada
Feature
QuickBooks Online
Xero
Sage 50 Canada
Canadian GST/HST
✅ Native
✅ Native
✅ Native
Saskatchewan PST
✅ Configurable
✅ Configurable
✅ Configurable
Payroll (Canada)
✅ Add-on
⚠️ 3rd party
✅ Built-in
Bank Feed Automation
✅ Excellent
✅ Excellent
⚠️ Limited
Multi-Currency
✅ Plus+
✅ All plans
✅ Premium
Inventory Tracking
⚠️ Basic
⚠️ Basic
✅ Advanced
Accountant Access
✅ Free accountant login
✅ Free accountant login
⚠️ Separate licence
Setup Complexity
🟢 Easy
🟢 Easy
🟡 Moderate
⚠️
Important: Whatever platform you choose, make sure it is Canadian-edition software — not the US version. The US editions of QuickBooks and Xero have different tax tables, reporting formats, and do not support Canadian payroll deductions or CRA filings. Always verify you are purchasing the Canadian version.
3. Phase 1 — Company Profile Setup
The foundation of your bookkeeping system is your company profile. Every setting here flows through to your financial reports, tax filings, and invoices. Get this right before entering a single transaction.
1
Company Information
Takes ~15 minutes — do this before anything else
Enter your legal business name exactly as it appears on your CRA Business Number registration. CRA Required
Enter your Business Number (BN) — the 9-digit CRA number. Add the RT (payroll) and RC (corporate tax) program accounts if applicable. CRA Required
Set your fiscal year start date — this determines your tax year and when annual reports reset. For most corporations, this is your incorporation anniversary month.
Select Canadian dollar (CAD) as your home currency. If you deal in USD or other currencies, enable multi-currency in your settings now.
Set your industry type — this pre-populates a relevant chart of accounts template that you'll customize in Phase 2.
Upload your company logo — it will appear on all invoices, quotes, and statements automatically.
Set the accounting method — accrual (recommended for most businesses) or cash basis. Confirm with your CPA before changing this after setup.
4. Phase 2 — Chart of Accounts Configuration
Your chart of accounts (COA) is the backbone of your bookkeeping system. Every transaction is categorized to an account in your COA, which determines how it appears on your financial statements. A well-structured COA makes your P&L and Balance Sheet genuinely useful — a poorly structured one creates confusion and wasted time.
2
Chart of Accounts Setup
Takes ~45–60 minutes — the most important setup step
Start with the default Canadian template for your industry — then customize. Don't build from scratch unless you have a specific reason.
Create separate bank accounts for every business bank account and credit card. Never use one account for multiple banks.
Add GST/HST Payable and (if in SK/BC/MB) PST Payable as separate current liability accounts. CRA Required
Create Payroll Liability accounts: CPP Payable, EI Payable, Income Tax Withholding Payable, and Employer CPP/EI Payable. CRA Required
Set up Owner's Draw / Shareholder Loan accounts in equity — separate from operating expenses. Owner withdrawals are NOT business expenses. Key
Create revenue sub-accounts by income stream (product sales, service revenue, other income) so you can track profitability by line of business.
Archive or delete any default accounts you will never use — a cleaner COA means fewer miscategorization errors.
Add account numbers if not present — standardized numbering (1000s = Assets, 2000s = Liabilities, 3000s = Equity, 4000s = Revenue, 5000s = Expenses) speeds up data entry and reporting. Pro Tip
Canadian Small Business COA — Standard Account Groups
Correct sales tax configuration is non-negotiable for CRA compliance. This is the area where most DIY setups go wrong — either because the wrong rate is applied, or because sales tax is being mixed with revenue instead of tracked as a separate liability. Our dedicated GST/HST Filing Checklist provides the complete filing framework once your software is set up correctly.
3
Tax Configuration
Takes ~20 minutes — critical for CRA compliance
Enter your GST/HST registration number (the RT account from your BN, e.g., 123456789 RT0001). CRA Required
Select your province to automatically apply the correct GST/HST rate (5% GST for SK/AB/BC, or combined HST for ON/NS/NB/NL/PEI).
Set your GST/HST filing frequency — Monthly, Quarterly, or Annual. Must match what the CRA has on file for your account. CRA Required
For Saskatchewan businesses: configure Saskatchewan PST (6%) as a separate tax code. PST is NOT tracked through CRA — it's filed separately with Saskatchewan Finance.
Create tax codes for zero-rated supplies (basic groceries, exports) and exempt supplies (residential rent, health services) if your business has these.
Enable Input Tax Credit (ITC) tracking — your software should automatically track GST/HST paid on purchases as recoverable ITCs. Key
Set up the 50% meals & entertainment tax rule — only 50% of GST/HST on meals is claimable as an ITC. Most Canadian editions have a specific tax code for this.
Run a test transaction — enter a sample $100 sale and verify that $5 GST (or applicable HST) is separated into your GST/HST Payable liability account, not included in revenue.
Canadian Sales Tax Rates by Province — Quick Reference (2025/2026)
Alberta
5% GST
5%
Saskatchewan
5% + 6% PST
11%
British Columbia
5% + 7% PST
12%
Ontario
13% HST
13%
Quebec
5% + 9.975% QST
14.975%
NS / NB / NL / PEI
15% HST
15%
6. Phase 4 — Bank Feeds & Credit Card Connections
Connecting your bank accounts and credit cards to your bookkeeping software via live bank feeds is a game-changer. Instead of manually entering every transaction, your bank feed automatically imports transactions daily — you simply review, categorize, and match. This alone can save 3–5 hours of bookkeeping per month.
4
Bank & Credit Card Feed Setup
Takes ~30 minutes — saves hours every month
Connect each business bank account via direct bank feed (most major Canadian banks are supported: TD, RBC, BMO, Scotiabank, CIBC, ATB, Credit Unions). Key
Connect all business credit cards — Visa, Mastercard, and Amex all support direct feeds in QuickBooks and Xero.
Set the feed start date to your accounting start date (usually the first day of your fiscal year or the date you began using the software).
Create bank rules for recurring transactions — payroll, rent, utilities, insurance. Rules auto-categorize these entries correctly without manual review. Pro Tip
Enter your opening balance for each account — the balance on the day your bookkeeping period begins. This creates a starting point for reconciliation.
Perform your first bank reconciliation immediately after setup — reconcile to a recent bank statement to confirm your opening balance is correct before importing transactions.
If a direct feed is unavailable, set up CSV import from your bank's export — most Canadian banks support this format as a backup.
Import or enter your customer list — include billing address (for correct place of supply tax rules on invoices), email, and payment terms.
Import or enter your vendor/supplier list — include their GST/HST registration number for ITC documentation. CRA Required for ITCs
Enter outstanding customer invoices as of your start date — these are your opening Accounts Receivable balance.
Enter outstanding supplier bills as of your start date — these are your opening Accounts Payable balance.
Set up invoice templates — include your BN, GST/HST number, payment terms, and logo. Invoices missing your GST/HST number are not valid for your customer's ITC claims.
Configure default payment terms (Net 15, Net 30) and late payment reminders to automate AR follow-up.
8. Phase 6 — Payroll Integration Setup
If you have employees, payroll must be integrated with your bookkeeping software from day one. Payroll transactions — wages, CPP, EI, income tax deductions, and employer contributions — must flow correctly into your books every pay cycle. For a full review of Canadian payroll services, see our guide on the Best Payroll Services for Small Business in Canada.
6
Payroll Integration
Takes ~60 minutes — essential if you have any employees
Enter your CRA Payroll (RP) account number — required before processing any payroll. CRA Required
Set up each employee profile — legal name, SIN, province of employment, TD1 claim amounts, pay frequency, and direct deposit banking information.
Configure payroll accounts in the COA — Wages Expense, CPP Payable, EI Payable, Income Tax Withholding Payable, Employer CPP, and Employer EI accounts.
Set your pay frequency — weekly, bi-weekly, semi-monthly, or monthly — and confirm it matches your CRA remittance schedule.
Configure vacation pay — either accrued at a rate (e.g., 4% or 6%) or paid out each period, depending on your employment agreements and provincial employment standards.
Run a test payroll — process a $1 payroll and verify that the journal entries correctly debit Wages Expense and credit all payroll liability accounts.
✅
Pro Tip: If your payroll software is separate from your bookkeeping software (e.g., Wagepoint + QuickBooks), ensure the payroll journal entry export from your payroll platform maps correctly to your bookkeeping COA. Mismatched mappings are one of the most common causes of payroll errors in financial statements. Our Core Accounting & Tax Services include payroll setup and integration support.
Your setup is nearly complete. These final configuration steps ensure your reports are meaningful, your data is secure, and your monthly close process runs like clockwork. A clean monthly close is what separates businesses with useful financial data from those flying blind. See our Monthly Bookkeeping Review Checklist for the ongoing process that builds on this setup, and our CFO Advisory Services for businesses that want strategic insights from their financial data.
📊 Overall Setup Completion Progress — Use This to Track Your Setup
Company Profile
Phase 1
Chart of Accounts
Phase 2
Tax Configuration
Phase 3
Bank Feeds
Phase 4
Customers & Vendors
Phase 5
Payroll Integration
Phase 6
Reporting & Close
Phase 7
7
Reporting, Users & Close Procedures
Takes ~20 minutes — completes your setup
Set up user access levels — give your accountant/CPA full access; restrict employees to data entry only. Never share the admin login. Key
Enable two-factor authentication (2FA) on all user accounts — financial data is a prime target for cybercriminals.
Configure your standard monthly report set — Profit & Loss, Balance Sheet, Cash Flow Statement, Aged AR, Aged AP. Schedule automatic delivery to your inbox on the 5th of each month.
Set up closing date protection — lock prior periods after reconciliation so historical data can't be accidentally changed. Requires a password to edit closed periods.
Enable automatic cloud backups — most cloud software (QBO, Xero) backs up automatically, but verify this is active and periodically export a full data backup to your own secure storage.
Schedule a quarterly review with your CPA — a brief check-in every quarter ensures your setup continues to meet CRA requirements as your business grows. See our Business Planning & CFO services.
🔧 Want a CPA to Review Your Bookkeeping Setup?
Custom CPA offers a bookkeeping system health check — we'll identify gaps, fix configuration errors, and ensure full CRA compliance.
These are the top questions Canadians search for online about bookkeeping software setup:
What is the best bookkeeping software for small business in Canada?
▼
QuickBooks Online Canada is the most widely used bookkeeping software for Canadian small businesses, with the largest network of Canadian accountants and the most comprehensive Canadian tax support. Xero is an excellent alternative, particularly for businesses that want a cleaner interface and unlimited user access. Sage 50 Canada is best for businesses with complex inventory or job costing needs. All three support GST/HST, Canadian payroll, and CRA compliance. The best choice depends on your industry, team size, and whether you need integrated payroll.
How do I set up GST/HST in QuickBooks Online Canada?
▼
In QuickBooks Online Canada, navigate to Taxes > Set up GST/HST. Enter your GST/HST registration number (from your CRA Business Number, ending in RT0001), select your province, choose your filing frequency (monthly, quarterly, or annual — must match your CRA designation), and set your reporting period start date. QBO will then automatically create the required tax codes, track GST/HST collected and paid, and calculate your net tax owing for each filing period. For Saskatchewan businesses, you'll also need to set up a separate PST tax code in the same section.
What accounts should be in a Canadian small business chart of accounts?
▼
A Canadian small business chart of accounts should include five main sections: Assets (chequing account, savings, accounts receivable, inventory, prepaid expenses, fixed assets); Liabilities (accounts payable, GST/HST payable, PST payable if applicable, payroll liabilities — CPP/EI/income tax withholding — and any business loans); Equity (share capital, retained earnings, owner's draw); Revenue (sales, service income, other income); and Expenses (COGS, rent, utilities, payroll wages, professional fees, insurance, vehicle, marketing). Your CPA can customize this structure for your specific industry.
How often should I reconcile my bank accounts in bookkeeping software?
▼
Monthly reconciliation is the minimum for Canadian small businesses — ideally completed within the first week of the following month. High-volume businesses (retail, restaurants, e-commerce) should reconcile weekly. Bank reconciliation confirms that every transaction in your accounting software matches your actual bank statement, catches data entry errors and bank errors, and ensures your financial reports reflect reality. Unreconciled accounts are one of the most common triggers for CRA audit scrutiny and one of the most reliable indicators of bookkeeping problems. Most modern software with bank feeds makes reconciliation a matter of minutes each month.
Do I need a separate bookkeeping file for each business I own?
▼
Yes — absolutely. Each separate legal entity (each corporation, sole proprietorship, or partnership) must have its own bookkeeping file. The CRA treats each legal entity as a separate taxpayer with separate tax obligations. Mixing two businesses in one bookkeeping file violates CRA record-keeping requirements, makes tax preparation extremely complicated, creates significant liability if one entity is audited, and may invalidate deductions if personal and business expenses are combined. Both QuickBooks Online and Xero offer multi-company plans (you pay for each company separately) that allow you to easily switch between files with one login.
✅ Let Custom CPA Set Up Your Bookkeeping System Right
From software selection to full CRA-compliant configuration — our team handles your entire bookkeeping setup so you can focus on running your business.
Disclaimer: The above contents are provided for general guidance only, based on information believed to be accurate and complete, but we cannot guarantee its accuracy or completeness. It does not provide legal advice, nor can it or should it be relied upon. Please contact/consult a qualified tax professional specific to your case.
