GST, QST, HST: automating tax calculation in your accounting software
Why tax calculations cost you 6h/month on average, and how a well-configured accounting software reduces it to 5 minutes. Concrete examples.
Based on our calculations with 50 Quebec SMB customers, calculating and filing taxes (GST, QST, HST) takes on average 6 hours per month without automation. With well-configured software, you drop to 5 minutes. Here's how.
Why taxes take you so long
Typical friction sources:
- Tax codes per customer/vendor: an Ontario vendor charges HST 13%, a Quebec one charges GST+QST, an Alberta one just GST. Manually, this is constant.
- ITC/RTI to separate: on every purchase, you must identify recoverable tax (business) vs non-recoverable (personal, 50% meals, etc.)
- Monthly/quarterly/annual remittance based on your turnover — calculating the net to remit is a manual Excel chore
- Documentary compliance: Revenu Québec requires visible GST/QST numbers on vendor invoices > $30
The 4 possible automation levels
Level 0 — Manual (Excel)
You track taxes in a separate Excel sheet. You manually total each month. Time: 6-8 h/month. Error risk: high. Audit risk: significant.
Level 1 — Configured tax codes
Your software has codes (GST, GST+QST, HST ON, Exempt, Zero). When you enter an invoice, you select the right code. Calculation is automatic but entry remains manual. Time: 3-4 h/month.
Level 2 — Default codes on customer/vendor records
One-time configuration: "Customer ABC in Montreal → GST+QST code". All future invoices apply the right code automatically. Time: 1-2 h/month.
Level 3 — Automatic geographic detection
Software detects tax code from the customer/vendor address. No configuration needed. Time: 15-30 min/month.
Level 4 — Tax report generated + filed
At period end, software directly generates the FPZ-500-V form (GST-QST) with all amounts pre-filled, ready to submit via ClicSÉQUR Enterprises or My Account. Time: 5 minutes.
How each software stacks up
| Software | Level reached |
|---|---|
| Excel / manual | 0 |
| Wave (free) | 1 |
| QuickBooks Online | 2-3 |
| Sage 50 | 2-3 |
| Acomba | 2-3 |
| Forge Tech Accounting | 4 |
Common trap: exceptions
A level 3-4 software is great, but 5-10% of your transactions will be special cases requiring manual intervention:
- Non-profit vendor: GST-exempt, sometimes QST — check status
- Out-of-Canada purchases: no GST/QST to recover (you pay customs fees separately)
- Meals and entertainment: only 50% of tax recoverable federally
- Mixed-use vehicle: recovery prorated to business km
Good software offers "special" tax codes for these cases (e.g., "Meals 50%" code that auto-calculates the deductible portion).
Cost savings
Valuing your time at $50/h (reasonable for a SMB leader):
- Level 0 (manual Excel): 6 h × $50 = $300/month of your time = $3,600/year
- Level 2-3 (QuickBooks): 1.5 h × $50 = $75/month = $900/year
- Level 4 (Forge Tech): 0.1 h × $50 = $5/month = $60/year
Forge Tech vs manual savings: $3,540/year. The Pro plan at $1,188/year pays for itself 3× just on tax time alone — not counting the 30 other modules.
Getting started
- Download our free GST/QST calculator: Resources page
- Try Forge Tech 14 days and import your last GST-QST report to compare: start
- Register for the webinar "How to cut 80% of GST/QST time" on June 15: free registration
— Guillaume Regimbald, Founder, Forge Tech Accounting