This Excel spreadsheet will allow you to track your rental income and expenses, in a way that makes preparing your 2022 Tax Return simple by tracking data in real time.
Answer easy questions to determine:
- The revenue generated by your rental units;
- Any personal portion of the expenses claimed; and
- Whether or not you’re eligible to claim motor vehicle expenses.
At this time, the spreadsheet is limited to the earnings from three properties (unlimited units in each property).
Further, this spreadsheet indicates whether there are additional accounting issues that need to be considered when preparing your tax return, and whether the assistance of an accountant would be necessary at tax time.

