Small Business Bookkeeping Template (English)

Your numbers, made clear. A complete bookkeeping spreadsheet for your small business in Canada. Record your income and expenses, and the template calculates your profit, your GST/HST, your income statement and your balance sheet for you.

I built it as an accountant with 20 years of experience, for entrepreneurs and self-employed people who want organized books without the stress. It works in Microsoft Excel and Google Sheets.

What's inside · 11 connected tabs

• Setup: your business, year, province (your GST/HST rate fills in automatically), categories and accounts.
• Income and expenses: 1,000-row logs with drop-down lists. GST/HST is calculated for you.
• Monthly dashboard: income, expenses, profit, margin, GST/HST to remit and what to set aside for tax, with charts.
• Annual summary: every category month by month, with a chart.
• Taxes: GST/HST by quarter, income tax reserve and your expenses by T2125 line.
• Accounts: each account balance and transfers between accounts.
• Income statement (P&L): gross and net profit by year, quarter or month.
• Balance sheet: assets, liabilities and owner's equity.
• Goals: monthly income goals and expense budget.

What you receive

One .zip file with the blank template (.xlsx), the same template with a full sample year and a 5-page PDF getting-started guide. This is a digital product: nothing is printed or shipped.

How it works

1. Buy and download the .zip.
2. Open the template in Excel, or upload it to Google Drive and open it with Google Sheets.
3. Fill in Setup in 15 minutes and start recording.

Before you buy

• You need Microsoft Excel or a free Google account.
• Made for Canada: GST/HST by province and T2125 lines. Quebec's QST is not included.
• It's an organizing tool and not accounting or tax advice.
• For personal or your own business use only. Reselling or sharing is not allowed.

Prefer it in Spanish? See the Spanish edition.