Canadian Small-Business Bookkeeping Spreadsheet 2026 – GST/HST, PST/QST & T2125

A clean, ready-to-use bookkeeping spreadsheet built for Canadian sole proprietors and freelancers.

• Income and expense ledgers (500 rows each) with automatic GST/HST and PST/QST by province of sale, covering all 13 provinces and territories
• Expense categories mapped to CRA Form T2125 lines; meals at 50% for both the expense and the GST/HST input tax credit; non-registrant mode
• Monthly and quarterly GST/HST summaries: tax collected, input tax credits and net tax owing
• T2125 summary and a one-page dashboard with a chart
• Rates sourced from the CRA (as of Oct 2026) and fully editable; Nova Scotia's 14% HST included
• Built with Sheets-compatible functions and tested in Excel/LibreOffice. Formula protection applies in Excel only. Includes an Instructions tab

Instant download: .xlsx, README and test cases.

A record-keeping tool, not tax or accounting advice. Not affiliated with or endorsed by the CRA.

Licence: In addition to Payhip's standard licence, you may use this template for your own business records, personal or commercial; don't resell or share the file.