How to Record Sales Tax in Canadian Bookkeeping

If you have ever stared at a bank feed full of untagged transactions and wondered whether the GST portion was properly recorded, you are not alone. Knowing how to record sales tax in Canada bookkeeping is one of those skills that separates a clean set of books from a file that keeps the accountant up at night. Between provincial variations, input tax credits, and CRA remittance deadlines, getting it wrong can cost money and trigger audits.

This article walks through the mechanics of recording sales tax, from setting up your chart of accounts to filing returns. Whether you are a bookkeeper cleaning up a client's file or a small business owner trying to stay compliant, the steps here will help you build a reliable process.

Table of Contents

• Understanding Sales Tax in Canada
• Setting Up Sales Tax Codes in Your Books
• Recording Sales Tax on Invoices and Receipts
• Handling Sales Tax on Expenses and Input Tax Credits
• Filing and Remitting Sales Tax: CRA Deadlines
• Frequently Asked Questions
• What to Do Next

Understanding Sales Tax in Canada: GST/HST, QST, PST, and Provincial Differences

Canada has a layered sales tax system that varies by province. The federal Goods and Services Tax (GST) applies nationwide at 5%. Some provinces harmonize their provincial sales tax with GST into the Harmonized Sales Tax (HST) at rates from 13% to 15%. Others collect a separate Provincial Sales Tax (PST) or Quebec Sales Tax (QST).

Understanding which rates apply to your clients or your own business is the first step in getting the bookkeeping right. Here is a quick reference:

> Note: Rates can change. Always verify current rates on the CRA website or provincial finance sites.

For bookkeeping purposes, the key difference is whether you track one bundled tax (HST) or two separate taxes (GST plus PST/QST). In HST provinces, you simply record the total tax amount. In non-harmonized provinces, you need separate general ledger accounts for GST and the provincial tax.

Setting Up Sales Tax Codes in Your Books: Chart of Accounts and Tax Rates

Before you record a single transaction, your accounting system needs the right tax codes. This is where many bookkeepers stumble, especially when converting from a generic system to a Canadian-specific one.

Chart of Accounts

Create separate liability accounts for each tax you collect:

• GST/HST Collected (liability)
• PST Collected (liability) - if in BC, SK, MB, or QC
• QST Collected (liability) - Quebec only
• ITC Recoverable (asset) or GST/HST Paid (asset) - for input tax credits

If you use an accounting platform like Awditify, these accounts are often pre-configured. But even if you set them up manually, the structure is the same. The collected accounts track what you owe to the government; the recoverable accounts track what you can deduct.

Tax Codes and Rates

Every transaction needs a tax code that tells the system which rate to apply and which account to post to. You will typically need codes like:

• GST 5% on sales
• HST 13% (Ontario)
• HST 15% (Atlantic provinces)
• GST 5% + PST 7% (BC)
• GST 5% + QST 9.975% (QC)
• Exempt - for zero-rated or exempt supplies

In a manual setup, you might use a lookup table. In a properly configured system, you assign the rate once and it auto-calculates on invoices. The Awditify Help Center walks through how to configure these codes if you are using their platform.

A common mistake is using the wrong PST rate on services. For example, in BC, many services are PST-exempt, while goods are taxable. Check provincial exemption lists carefully.

Recording Sales Tax on Invoices and Receipts

Once your tax codes are in place, recording transactions is straightforward in theory but error-prone in practice. Let us walk through a typical Ontario business example.

Scenario: A small marketing agency in Toronto sells $5,000 of services to a client.

• HST at 13% = $650
• Total invoice = $5,650

Manual entry:

Debit Accounts Receivable $5,650 Credit Revenue $5,000 Credit HST Collected $650

If you are using bank feeds and manual categorization, you would match the deposit to the invoice. But what if the client pays in partial amounts? Or what if you use cash accounting for GST/HST? Then you only record the tax when payment is received.

This is where automation helps. Many bookkeepers now use AI-driven tools that read invoices and automatically post the split to revenue and tax accounts. For example, Awditify's AI transaction categorization can recognize a payment from a client and match it to the invoice, reducing manual data entry.

Manual vs Automated Workflow

Let me compare the typical manual process with an automated one.

Manual process:

1. Create invoice manually or in a template.
2. Calculate tax manually or with a calculator.
3. Enter transaction in accounting system with correct accounts.
4. Reconcile payments against invoices.
5. Periodically sum up all sales tax collected for the return.

Pain points: math errors, wrong accounts, missed invoices, time wasted.

Automated process (using a Canadian accounting platform):

1. Create invoice with tax code applied automatically.
2. System calculates and posts tax to the correct liability account.
3. Payment received, automatically matched to invoice.
4. Tax reports populate real-time.
5. CRA return data is pre-filled from transactions.

For a small business or firm managing many clients, the time saved is substantial. And because the data is structured, the audit trail is clear. If you are still doing manual calculations for your sales tax postings, consider switching to a platform designed for Canadian rules.

Handling Sales Tax on Expenses and Input Tax Credits

Recording sales tax on purchases is just as important. Input Tax Credits (ITCs) allow you to deduct the GST/HST you paid on business expenses from the tax you collected. The net amount is what you remit to the CRA.

How ITCs work in bookkeeping:

When you buy office supplies for $100 plus HST:

Debit Office Supplies $100 Debit HST Paid (ITC) $13 Credit Accounts Payable / Cash $113

Your HST Paid account is an asset. At the end of the period, you net it against HST Collected to determine your remittance.

Common traps:

• Not tracking ITCs on expenses paid personally by the owner.
• Missing ITCs on capital purchases like computers or vehicles.
• Confusing provincial tax treatment: In BC and Quebec, the PST/QST is not recoverable for most businesses. Only the GST portion is an ITC.
• Using the wrong date: ITCs must be claimed in the period the expense is incurred (or paid, depending on your accounting method).

Sorting ITCs in a multi-jurisdiction business

If your client has expenses in multiple provinces, you need to track which tax rate applies and whether the expense is taxable. For example, a truck driver based in Ontario buys fuel in Quebec. That fuel includes QST, but the QST may be recoverable under certain rules. This requires careful coding.

A good practice is to use a purchase categorization system that prompts for the tax code at entry. Many features in Awditify allow you to set default tax rates per vendor or expense type, reducing the chance of error.

Filing and Remitting Sales Tax: CRA Deadlines and Common Pitfalls

Once your books are up to date, the last step is filing the GST/HST return. The frequency depends on your annual revenues:

• Annual filers (under $1.5M in taxable supplies): file once a year, monthly or quarterly instalments may be required.
• Quarterly filers ($1.5M to $6M): file every three months.
• Monthly filers (over $6M): file monthly.

Deadlines

For monthly and quarterly filers, the return is due one month after the end of the reporting period. Annual filers have three months after the year-end, but only if they do not have instalments.

If you are using the quick method, the filing deadlines are the same but the calculation is different.

Common pitfalls in the bookkeeping files

1. Mixing personal and business expenses - Personal purchases are not eligible for ITCs. Bank feeds with uncategorized transactions often cause this.
2. Not reconciling tax accounts - If your GST/HST Collected account balance does not match your sales records, something is wrong. Reconcile monthly.
3. Ignoring foreign exchange - If you sell or buy in USD, the GST/HST is calculated on the Canadian dollar equivalent. Use the Bank of Canada exchange rate on the transaction date.
4. Forgetting to apply the rebate for charities - Charities and non-profits can claim a 50% rebate of GST/HST paid. That requires a separate adjustment.

How to catch errors before filing

Run a trial balance and review the tax-related accounts. Compare the net tax amount to your sales and expense totals. A variance of more than a few dollars should trigger a review.

If you are using a proper accounting system like Awditify, the GST/HST report will aggregate all transactions and show the expected net remittance. This saves hours of manual spreadsheet work.

Frequently Asked Questions

How do I record HST collected in QuickBooks?

I cannot comment on specific software, but in general, you need to create a liability account called HST Collected. When you create an invoice, apply the HST tax code. The system will post the tax amount to that account automatically. The same principle applies in any accounting software that supports multi-rate taxes.

What is the difference between GST and HST in bookkeeping?

GST is the federal tax at 5%. HST combines the federal 5% with a provincial portion (8% in Ontario, 10% in Atlantic provinces) into one tax. In bookkeeping, HST simplifies recording because you only track one rate per province. With GST and PST separate, you need two liability accounts and two lines on each transaction.

How do I claim input tax credits on my bookkeeping?

You claim ITCs by recording the GST/HST paid on eligible expenses as a separate account (e.g., HST Paid). At the end of the reporting period, you net the total collected against the total paid. The difference is what you remit or receive as a refund. Ensure you keep all receipts and invoices to support your claims.

What is the best software for Canadian sales tax bookkeeping?

For Canadian sales tax bookkeeping, you need a platform that understands provincial rates, ITCs, and CRA filing. Awditify is built for Canadian accounting firms and businesses, with built-in tax codes for every province, automatic calculations on invoices, and real-time tax reports. It handles the complexity so you do not have to manually track separate PST and GST accounts in non-harmonized provinces.

How often do I need to remit sales tax to the CRA?

Remittance frequency depends on your taxable supplies. Most small businesses file and remit quarterly. The return is due one month after the end of the quarter. If you are a new registrant, you may be assigned annual filing until you exceed the $1.5M threshold. Always check your CRA account for your assigned period.

What to Do Next

Recording sales tax correctly in Canadian bookkeeping comes down to three things: the right setup, consistent transaction coding, and regular reconciliation. If you are manually entering tax amounts or relying on spreadsheets, you are spending time that could be used for higher-value work. For small business owners and CPA firms alike, a dedicated Canadian platform like Awditify automates the tax recording process, from invoice creation to pre-filled CRA returns. If you are ready to stop chasing tax errors, take a look at Awditify's features or book a demo.