Canadian Bookkeeping

Bookkeeping for Canadian small businesses and the self-employed. Type what comes in and goes out: your dashboards, GST/HST and T2125 numbers fill themselves in. Works in Google Sheets (free) and Excel 365.

Get it on Etsy

Google Sheets (free) and Excel 365 · Four themes · Instant download · Works on phone and tablet in the Google Sheets app

WATCH IT WORK

GST/HST

• Collected on sales, paid on expenses (your input tax credits) and owing, for each monthly, quarterly or yearly filing period, with due dates and filed ticks
• A second tax table for PST or QST
• Etsy collects and remits GST/HST on Canadian orders itself: leave the GST/HST blank on those sales and they're left out of what you owe

YEAR-END TAX

• Every category on its T2125 line (Statement of Business or Professional Activities), with what to set aside
• Mileage in km, the business share of your vehicle worked out
• US sellers: the same sheet has Schedule C lines too

SEE YOUR NUMBERS

• Dashboard: pick the whole year, year to date, a quarter or a month. Income, expenses, profit, profit vs your goal, vs the same months last year, GST/HST owing; four charts; every category
• Year by month, 5 years, and Compare any months against any months

TYPE HERE

• Transactions: 10,000 rows, GST/HST in its own column, receipt tick, account, customer or vendor
• Recurring: subscriptions, rent, insurance, weekly to yearly, counted on their dates
• Find: filter by type, category, account, dates or words

WHAT YOU GET

• A PDF with your Google Sheets copy links (four themes: Sage, Dark, Light, Pastel)
• Four Excel files and a sample copy filled with five years of example data
• A YouTube tutorial