Running Your Books in a Spreadsheet: What Works, What to Watch
A well-organized spreadsheet is a legitimate way for a Canadian sole proprietor to keep books. What makes it work is not the software — it is the discipline around it: consistent columns, tax kept separate from income, entries made weekly, and a monthly check against the bank statement. This guide covers the judgment calls the template itself cannot make for you.
Why Sales Tax Gets Its Own Columns
When a registered business invoices $1,000 plus tax, the tax portion was never the business's money. It is collected on behalf of the government and remitted when you file. That is why the income log separates the before-tax amount from the tax collected, and why the monthly summary calculates profit from before-tax figures only. The same logic applies in reverse on purchases: the tax you pay on business expenses is generally recoverable through input tax credits once you are registered, so it is not really a cost — but only if you recorded it in its own column and can support it with receipts. A spreadsheet that lumps tax into one "total" column makes both filing numbers unrecoverable without redoing every row.
Watching the $30,000 Threshold
An unregistered business must register for GST/HST once its revenue passes $30,000 over four consecutive calendar quarters. The phrase "four consecutive calendar quarters" matters: it is a rolling measure, not a calendar-year reset. Your income log is the instrument for watching it — keep a running total of the last four quarters' before-tax revenue, and check it every quarter. Registering late means owing tax you never collected from clients. See how to register for GST/HST for the registration process itself, and when to charge GST/HST for what changes on your invoices afterward.
Categories That Match Your Tax Return
The category column in the expense log is worth setting up carefully on day one. If your categories match the expense lines you will report at tax time — advertising, office supplies, phone, professional fees, vehicle, home office — then your year-end numbers are a one-click filter. If they are ad-hoc ("stuff", "misc", "online"), you will re-read every receipt in April. The standard Canadian expense categories are listed in business expense categories in Canada; start from those rather than inventing your own.
The Records Behind the Rows
The spreadsheet is a summary, not the record itself. Canadian tax requirements are that business records — invoices issued, receipts for purchases, bank statements — be kept for six years from the end of the tax year they relate to, and digital copies are acceptable. Practically, that means every row in your expense log should have a receipt you can produce, and every row in your income log should trace to an invoice. A tidy pattern: a folder per year, a subfolder per month, receipts named by date and vendor. For the full picture, see record keeping for Canadian taxes.
The Monthly Reconciliation Habit
Once a month, put your bank statement beside the spreadsheet and tick each statement line against a row. Three kinds of problems surface immediately: money that arrived but was never logged (missed income), payments that left but were never logged (missed deductions), and rows in the sheet with no matching bank line (typos or double entries). This single habit is what separates books that can be trusted from books that merely exist. It is also the exact process accounting software automates with a bank import — the habit transfers directly when you graduate.
Knowing When You've Outgrown It
The spreadsheet fails gradually, then suddenly. Gradually: entries slip a week behind, a category gets sloppy, an unpaid invoice sits unnoticed. Suddenly: you register for GST/HST and now every row has tax implications, or tax season arrives and the summary tab disagrees with the bank. The switch to software is easiest before the sudden part — you can bring your client list with you, and invoicing plus bookkeeping collapse into one step. iBill's free accounting software gives you double-entry books, automatic tax on every invoice, and unpaid-invoice reminders without the retyping.