Organize your finances, track your income and expenses, and stay prepared for tax season with this Canadian small business bookkeeping spreadsheet designed for entrepreneurs who want a simple alternative to accounting software.
This Google Sheets bookkeeping template was created after several small business owners asked for a way to track their business finances without paying monthly for bookkeeping software. Itโs designed to help you keep all your financial information in one organized place while tracking your numbers throughout the year.
Whether you're a sole proprietor, freelancer, or small business owner in Canada, this spreadsheet makes it easier to track your income, expenses, GST/HST, and profit so you can stay organized and confident at tax time.
Whatโs Included in This Spreadsheet
๐ธ ๐ ๐ผ๐ป๐๐ต๐น๐ ๐๐ป๐ฐ๐ผ๐บ๐ฒ & ๐๐
๐ฝ๐ฒ๐ป๐๐ฒ ๐ง๐ฟ๐ฎ๐ฐ๐ธ๐ฒ๐ฟ
Track your business revenues and expenses each month with easy-to-use monthly tabs.
๐ธ ๐๐ฆ๐ง/๐๐ฆ๐ง ๐๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ผ๐ฟ
Automatically track and calculate GST/HST by month, quarter, or year, depending on your filing frequency.
๐ธ ๐ฃ๐ฟ๐ผ๐ณ๐ถ๐ & ๐๐ผ๐๐ ๐ฆ๐๐ฎ๐๐ฒ๐บ๐ฒ๐ป๐ (๐ฃ&๐)
A full yearly profit and loss report showing totals before tax, tax collected, totals with tax, and your final profit or loss.
๐ธ ๐๐๐๐ถ๐ป๐ฒ๐๐ ๐จ๐๐ฒ ๐ผ๐ณ ๐๐ผ๐บ๐ฒ ๐๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ผ๐ฟ
Enter your home and office dimensions to calculate your business use of home expenses for tax deductions.
๐ธ ๐ฉ๐ฒ๐ต๐ถ๐ฐ๐น๐ฒ ๐ ๐ถ๐น๐ฒ๐ฎ๐ด๐ฒ ๐ง๐ฟ๐ฎ๐ฐ๐ธ๐ฒ๐ฟ
Track your business trips and mileage by month to calculate your business use of vehicle.
๐ธ ๐๐๐๐๐ผ๐บ๐ถ๐๐ฎ๐ฏ๐น๐ฒ ๐๐ต๐ฎ๐ฟ๐ ๐ผ๐ณ ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐
Add and customize your income categories and business expense categories to fit your business needs.
๐ธ ๐ฃ๐ฟ๐ผ๐ฑ๐๐ฐ๐ & ๐ฆ๐ฒ๐ฟ๐๐ถ๐ฐ๐ฒ ๐ฃ๐ฟ๐ถ๐ฐ๐ถ๐ป๐ด ๐๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ผ๐ฟ
Price your products or services confidently with built-in cost and profit calculations.
๐ธ ๐๐ฒ๐ฏ๐ & ๐ฆ๐ฎ๐๐ถ๐ป๐ด๐ ๐๐ผ๐ฎ๐น ๐ง๐ฟ๐ฎ๐ฐ๐ธ๐ฒ๐ฟ๐
Set financial goals by entering your start date, end date, amount, and frequency, and the spreadsheet calculates the rest.
๐ธ ๐๐ฒ๐น๐ฝ๐ณ๐๐น ๐ฅ๐ฒ๐๐ผ๐๐ฟ๐ฐ๐ฒ๐ & ๐๐ถ๐ป๐ธ๐ ๐๐ป๐ฐ๐น๐๐ฑ๐ฒ๐ฑ
๐ฃ๐ฒ๐ฟ๐ณ๐ฒ๐ฐ๐ ๐๐ผ๐ฟ:
โ Canadian small business owners
โ Freelancers and self-employed individuals
โ Sole proprietors preparing a T2125 Statement of Business Activities
โ Entrepreneurs who want to organize their finances without accounting software
โ Anyone looking for a Google Sheets bookkeeping template or expense tracker
Why This Spreadsheet Helps
This spreadsheet helps you:
โข Track income and expenses in one place
โข Understand your profit and cash flow
โข Stay organized for income tax and GST/HST filing
โข Prepare information for your bookkeeper or accountant at year-end
If you ever need help using the spreadsheet, Iโm always happy to assist. You can reach me through Etsy messages or by email at roxanne@openbookca.ca.
Happy tracking!
โ Roxanne, Open Book
Organize your finances, track your income and expenses, and stay prepared for tax season with this Canadian small business bookkeeping spreadsheet designed for entrepreneurs who want a simple alternative to accounting software.
This Google Sheets bookkeeping template was created after several small business owners asked for a way to track their business finances without paying monthly for bookkeeping software. Itโs designed to help you keep all your financial information in one organized place while tracking your numbers throughout the year.
Whether you're a sole proprietor, freelancer, or small business owner in Canada, this spreadsheet makes it easier to track your income, expenses, GST/HST, and profit so you can stay organized and confident at tax time.
Whatโs Included in This Spreadsheet
๐ธ ๐ ๐ผ๐ป๐๐ต๐น๐ ๐๐ป๐ฐ๐ผ๐บ๐ฒ & ๐๐
๐ฝ๐ฒ๐ป๐๐ฒ ๐ง๐ฟ๐ฎ๐ฐ๐ธ๐ฒ๐ฟ
Track your business revenues and expenses each month with easy-to-use monthly tabs.
๐ธ ๐๐ฆ๐ง/๐๐ฆ๐ง ๐๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ผ๐ฟ
Automatically track and calculate GST/HST by month, quarter, or year, depending on your filing frequency.
๐ธ ๐ฃ๐ฟ๐ผ๐ณ๐ถ๐ & ๐๐ผ๐๐ ๐ฆ๐๐ฎ๐๐ฒ๐บ๐ฒ๐ป๐ (๐ฃ&๐)
A full yearly profit and loss report showing totals before tax, tax collected, totals with tax, and your final profit or loss.
๐ธ ๐๐๐๐ถ๐ป๐ฒ๐๐ ๐จ๐๐ฒ ๐ผ๐ณ ๐๐ผ๐บ๐ฒ ๐๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ผ๐ฟ
Enter your home and office dimensions to calculate your business use of home expenses for tax deductions.
๐ธ ๐ฉ๐ฒ๐ต๐ถ๐ฐ๐น๐ฒ ๐ ๐ถ๐น๐ฒ๐ฎ๐ด๐ฒ ๐ง๐ฟ๐ฎ๐ฐ๐ธ๐ฒ๐ฟ
Track your business trips and mileage by month to calculate your business use of vehicle.
๐ธ ๐๐๐๐๐ผ๐บ๐ถ๐๐ฎ๐ฏ๐น๐ฒ ๐๐ต๐ฎ๐ฟ๐ ๐ผ๐ณ ๐๐ฐ๐ฐ๐ผ๐๐ป๐๐
Add and customize your income categories and business expense categories to fit your business needs.
๐ธ ๐ฃ๐ฟ๐ผ๐ฑ๐๐ฐ๐ & ๐ฆ๐ฒ๐ฟ๐๐ถ๐ฐ๐ฒ ๐ฃ๐ฟ๐ถ๐ฐ๐ถ๐ป๐ด ๐๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ผ๐ฟ
Price your products or services confidently with built-in cost and profit calculations.
๐ธ ๐๐ฒ๐ฏ๐ & ๐ฆ๐ฎ๐๐ถ๐ป๐ด๐ ๐๐ผ๐ฎ๐น ๐ง๐ฟ๐ฎ๐ฐ๐ธ๐ฒ๐ฟ๐
Set financial goals by entering your start date, end date, amount, and frequency, and the spreadsheet calculates the rest.
๐ธ ๐๐ฒ๐น๐ฝ๐ณ๐๐น ๐ฅ๐ฒ๐๐ผ๐๐ฟ๐ฐ๐ฒ๐ & ๐๐ถ๐ป๐ธ๐ ๐๐ป๐ฐ๐น๐๐ฑ๐ฒ๐ฑ
๐ฃ๐ฒ๐ฟ๐ณ๐ฒ๐ฐ๐ ๐๐ผ๐ฟ:
โ Canadian small business owners
โ Freelancers and self-employed individuals
โ Sole proprietors preparing a T2125 Statement of Business Activities
โ Entrepreneurs who want to organize their finances without accounting software
โ Anyone looking for a Google Sheets bookkeeping template or expense tracker
Why This Spreadsheet Helps
This spreadsheet helps you:
โข Track income and expenses in one place
โข Understand your profit and cash flow
โข Stay organized for income tax and GST/HST filing
โข Prepare information for your bookkeeper or accountant at year-end
If you ever need help using the spreadsheet, Iโm always happy to assist. You can reach me through Etsy messages or by email at roxanne@openbookca.ca.
Happy tracking!
โ Roxanne, Open Book
