GE | SOLUTIONS Tax Solutions
  • HOME
  • SOLUTIONS
    • TAX RETURN PROCESS
    • Covid work from home
    • TOP TAX TIPS
    • AUTHORIZATION FORM
    • TAX ORGANIZER
    • TAX CHECKLIST
    • TAX WORKSHEETS
    • LINKS
  • ARTICLES
    • TFSA Will Yours Be Audited
    • TFSA Succesor-Holder Designation
  • CONTACT
    • MUSE
  • ONLINE PAYMENT

FREE Worksheets

WE WANT TO HELP YOU
PREPARE YOUR TAX INFORMATION
Please take advantage of us, and use these free resources, to help you prepare your tax information for the current tax year.  Tell your friends.
SELF-EMPLOYED?

Are you a self-employed contractor or other unincorporated business?  Please feel free to use our Business Income and Expenses Worksheet to compile your business income and expenses for the year.  Once you've entered your information, the Excel spreadsheet can easily be sent to us to help us prepare your personal tax return which includes your business.
​
If you are a GST/HST Registrant, these worksheets will help you summarize your GST or HST data for quarterly and annual report filings.
EMPLOYED and INCUR ALLOWABLE EMPLOYMENT EXPENSES?
​Many people are employed by someone else, but in the course of their employment activities incur expenses that are directly related and connected to the earning of their income.  If this is you, and you are not reimbursed for some or all of those expenses, please feel free to use our Employment Expenses Worksheet to compile your allowable employment expenses for the year.  Send the completed form to us to help us prepare your personal tax return and to claim the expenses that you are entitled.  You will also need to obtain and send us Form T2200 Declaration of Conditions of Employment, completed and signed by your employer.
​
OWN A RENTAL PROPERTY?

If you own a rental property, or if you rent out a portion of your own home, please use the Rental Income and Expenses Worksheet to compile your income and expenses for the year. Once you've entered your information, the Excel spreadsheet can easily be sent to us to help us prepare your personal tax return which includes your rental property activities.

BUSINESS INCOME AND EXPENSES WORKSHEET
for self-employed individuals


The attached spreadsheets are made available online to provide self-employed individuals with a user-friendly means to accumulate their business income and expense information for the year.

Simply download the appropriate spreadsheet file, open it and begin to enter your data into the applicable rows and columns on the various tabs provided, as they apply to your circumstances.  As you enter your information (from your receipts, payments, etc.), the worksheet automatically accumulates your raw data into useful, usable and informative summaries.

When you've completed your data entry and checked your work for completeness and accuracy, simply attach your saved file to an e-mail and send it to me.  I will use this data to prepare year-end financial reports and other tax requirements.

Any use of this file presumes your ability to enter data completely and accurately onto a spreadsheet.  If you require assistance from us to use this tool, you are welcome to contact us by phone or e-mail.  However, our services will be charged to your account at $100 / hour for any such assistance, with a minimum one-hour charge per call.
2022.income_and_expenses_ws.xlsx
File Size: 97 kb
File Type: xlsx
Download File


2021.income_and_expenses_ws.xlsx
File Size: 97 kb
File Type: xlsx
Download File


2020.income_and_expenses_ws.xlsx
File Size: 97 kb
File Type: xlsx
Download File


2019.income_and_expenses_ws.xlsx
File Size: 97 kb
File Type: xlsx
Download File


Please note: as a result of many requests, we have attempted to make these Income and Expense worksheets accurate for all Canadian provinces and territories. Some anomalies or exceptions may arise. Please report any that you discover so we can try to fix the problem. Thank you.

EMPLOYMENT EXPENSES WORKSHEET
for employees (T4 slip) eligible to claim Employment Expenses


If you were employed during the tax year and you were eligible to claim expenses incurred by you during the earning of your income (e.g. salesman, broker, etc.), this spreadsheet may be useful to you to accumulate your expenses for the year.

To ensure your eligibility to claim Employment Expenses you must obtain a completed copy of CRA form T2200 - Declaration of Conditions of Employment.  This form is to be completed by your employer (authorized individual), and provided to you for your use in completing your tax return.

It is important that you and your employer be familiar with CRA booklet T4044 - Employment Expenses.

Any use of this file presumes your ability to enter data completely and accurately onto a spreadsheet.  If you require assistance from us to use this tool, you are welcome to contact us by phone or e-mail.  However, our services will be charged to your account at $100 / hour for any such assistance, with a minimum one-hour charge per call.
2022.employment_expenses.xlsx
File Size: 29 kb
File Type: xlsx
Download File


2021.employment_expenses.xlsx
File Size: 30 kb
File Type: xlsx
Download File


2020.employment_expenses.xlsx
File Size: 30 kb
File Type: xlsx
Download File


2019.employment_expenses.xlsx
File Size: 30 kb
File Type: xlsx
Download File



RENTAL INCOME AND EXPENSES WORKSHEET
​for individuals or couples who own a rental property or rent out a portion of their principal residence


Please download and complete the appropriate Rental Income and Expenses Worksheet and forward the completed worksheet to us so that we may use the data to complete your personal income tax return to include your rental property activities. If you have more than one property, use a separate worksheet for each property.

​Any use of this file presumes your ability to enter data completely and accurately onto a spreadsheet.  If you require assistance from us to use this tool, you are welcome to contact us by phone or e-mail.  However, our services will be charged to your account at $100 / hour for any such assistance, with a minimum one-hour charge per call.

​These Rental worksheets have been designed primarily for use in Ontario. If you choose to use them in provinces and territories other than Ontario, please be aware of sales tax differences that will occur.

2022.rental_property_income_and_expenses.xlsx
File Size: 12 kb
File Type: xlsx
Download File


2021.rental_property_income_and_expenses.xlsx
File Size: 12 kb
File Type: xlsx
Download File


2020.rental_property_income_and_expenses.xlsx
File Size: 12 kb
File Type: xlsx
Download File


2019.rental_property_income_and_expenses.xlsx
File Size: 12 kb
File Type: xlsx
Download File


Acknowledgements:
I am grateful to Mark Coons, a Realtor in Kelowna BC, who found a flaw in LINE 101 of the SUMMARY tab of my "Business Income and Expenses Worksheet", and was kind enough to point it out to me. I have corrected the worksheets as of Oct-29-2019. The error affects users doing business outside of Ontario, not subject to 13% HST.
Similarly, Amir Tangestani, a BIM and Design Technology expert in North Vancouver, pointed out some further formula flaws that would affect non-Ontario users. I so much appreciate these findings that help me make the worksheets more a Canadian product, not just Ontario. I have updated t
he worksheets as of May 20, 2020.

OUR SERVICES

Financial
Accounting
Tax
Students
Web & Media

COMPANY

About Us
Contact Us
Articles

SUPPORT

Support Page
Freebies
Important links
Picture
| Copyright © 2021  | Gord Evans |
  • HOME
  • SOLUTIONS
    • TAX RETURN PROCESS
    • Covid work from home
    • TOP TAX TIPS
    • AUTHORIZATION FORM
    • TAX ORGANIZER
    • TAX CHECKLIST
    • TAX WORKSHEETS
    • LINKS
  • ARTICLES
    • TFSA Will Yours Be Audited
    • TFSA Succesor-Holder Designation
  • CONTACT
    • MUSE
  • ONLINE PAYMENT