Excel template · Instant download

Tallyfern Books 2026: Canadian Bookkeeping Spreadsheet

See your $30,000 GST/HST small-supplier position quarter by quarter, sort income and expenses by T2125 line, and convert sales in other currencies to CAD. One Excel file you buy once and keep. No account, no bank connection, no subscription.

C$24.99 CAD on Etsy

Buy on Etsy See the CRA Mileage Log

Etsy may show prices in your local currency.

Cover image for Tallyfern Books 2026: Canadian bookkeeping for T2125 and GST/HST, a one-time C$24.99 file for Microsoft Excel with no account or subscription, a $30,000 small-supplier tracker and multi-currency to CAD. The screenshot shows the included fictional sample. Not affiliated with the CRA.

What it does

Setup: tax year, your business name, GST/HST registration (No / Yes, regular / Yes, Quick Method), your sales platforms and the T2125 category list with deductible shares. The threshold, early-warning % and deductible shares are all editable.
Sales: 500 rows for date, platform, reference, description, currency, gross, fees and GST/HST you charged. Other currencies convert to CAD with the exchange rate you enter. Mark whether each sale counts toward the GST/HST threshold.
Expenses: 500 rows with a T2125 category dropdown (the line number fills in for you), currency and CAD conversion, optional GST/HST paid, business-use % and receipt Y/N. Deductible amounts are worked out per row, including 50% for meals and entertainment.
Summary: sales and expense totals by T2125 line, in form order, a simple profit figure (sales after fees minus deductible expenses), a month-by-month table and checks that flag a missing exchange rate, a missing category or a date outside your tax year.
GST-HST Tracker: taxable sales by quarter, a rolling four-quarter total, your % of the $30,000 threshold and a plain-language status with a pointer to canada.ca. Enter last year’s four quarters so the rolling total works from January.
Capital purchases and home office: log them under CCA (line 9936) and business-use-of-home (line 9945) so your accountant sees them. They’re listed, not calculated.
No double counting: platform fees go to a T2125 line you choose on Setup, and Start Here explains how to avoid entering them twice.

Expenses sorted by T2125 line, with fictional sample data: 500 rows, each converted to CAD with its exchange rate, business-use % and receipt Y/N per row, and meals worked out at 50%.

Your year in T2125 form order, with fictional sample data: the Checks section, which flags a missing exchange rate, category or out-of-year date, and the Income section with sales totals by T2125 line in CAD. Callouts note that platform fees go to the line you choose and that capital items and home office are listed for your accountant, not calculated.

The GST-HST Tracker with fictional sample data: taxable sales by calendar quarter, a rolling four-quarter total and the % of the $30,000 small-supplier threshold.

What’s included: a blank workbook, a filled sample workbook, a README (PDF) and the free Work Trip Claim Checklist. General information, not tax advice; not affiliated with the CRA.

Key facts

Who it’s for: Canadian sole proprietors, freelancers, side hustlers and online sellers who want their income and expenses sorted the way Form T2125 asks for them, in CAD, with an early heads-up on the $30,000 GST/HST small-supplier threshold. Your numbers stay in your own file, on your own computer.
Compatibility: Tested in Microsoft 365 Excel on Windows and in Excel for Mac. Works offline in desktop Excel. No macros, no add-ins, no account, no subscription.
What’s included: Blank workbook (.xlsx) for one tax year

Filled SAMPLE workbook (.xlsx) for a fictional Guelph paper studio, so you can see how it all fits together

README (PDF, 2 pages): download, setup and quick start for Excel

Free bonus: Work Trip Claim Checklist (fillable PDF)
Price: C$24.99 CAD, sold as an instant digital download on Etsy.
Returns: Because it’s an instant digital download, returns aren’t accepted. If something isn’t working, message us on Etsy or email hello@tallyfern.com and we’ll help.
Licence: Licensed for use by one person (personal or business use). Each additional user needs their own copy; no resale or sharing.
How it’s made: Made by Tallyfern with the help of AI tools. Formulas are tested by automated checks before release. The GST/HST rates and the $30,000 threshold are checked against CRA’s published figures.

General information, not tax advice. Books organizes your records; it doesn’t file returns or decide what you can deduct. It doesn’t calculate CCA, the business-use-of-home claim, Quick Method remittances or input tax credits, and it’s not for payroll, inventory, corporations or partnerships. Check canada.ca or talk to an accountant about your situation. Tallyfern is not affiliated with the Canada Revenue Agency.

Frequently asked questions

Does it calculate CCA, PST or QST?

No. Capital items (line 9936) and home-office costs (line 9945) are listed for your accountant, not calculated, and PST/QST aren’t tracked. The Setup sheet shows each province’s GST/HST rate for reference.

Which Excel do I need?

Tested in Microsoft 365 Excel on Windows and in Excel for Mac. It works offline in desktop Excel.

Does it connect to my bank or need an account?

No. No account, no bank connection, no subscription. Your numbers stay in your own file, on your own computer.

Does it work if I'm registered for GST/HST?

Yes. Choose not registered, registered (regular method) or Quick Method on Setup. Your choice sets how GST/HST paid is treated in deductible expenses. The Quick Method remittance itself isn’t calculated.

Does it use macros?

No. No macros, no add-ins.

How do I get the files?

Buy it on Etsy, then go to You › Purchases and reviews › Download files (or use the link in your order email). It’s a digital download; nothing is shipped.

Get Tallyfern Books

C$24.99 CAD on Etsy, instant download. Made by Tallyfern with the help of AI tools.

Buy on Etsy