PROPERTY GUIDE

How to Track Rental Property Income and Expenses

A practical monthly workflow, category list and free spreadsheet for organizing rental property income, expenses and performance.

A useful rental-property record should answer four questions without reopening a bank statement: what happened, which property or unit it belongs to, how it was categorized and where the supporting document is stored. Record transactions as they occur and keep each property separate.

What to record for every transaction

Date paid or received
Property and unit
Payer, tenant, vendor or contractor
Income or expense category
Description and amount, including sales tax where relevant
Payment method or account
Invoice, receipt, lease or work-order reference
A short note for anything unusual

Use consistent descriptions. A clear entry such as “Unit 2 kitchen faucet replacement” is more useful than “plumbing.”

Track income separately

Separate scheduled rent from other income such as parking, storage, laundry, pet fees, reimbursements and late fees. Record collected rent rather than assuming every scheduled payment arrived. Track unpaid rent and vacancy separately so the difference between potential and actual income remains visible.

Use consistent expense categories

Common categories include advertising, insurance, interest and bank charges, office and administration, professional fees, management, repairs and maintenance, property taxes, utilities, travel or vehicle costs, supplies and other operating expenses. The Canada Revenue Agency's rental-income guide and the U.S. Internal Revenue Service's Publication 527 use comparable property-level income and expense groupings, although the forms and rules differ.

Keep three items separate from ordinary operating expenses:

Capital work: improvements or equipment that may need to be tracked over multiple years.
Loan principal: the part of a debt payment that reduces the balance rather than an operating expense.
Personal or mixed-use costs: amounts that may need allocation before tax reporting.

Do not use the tracker alone to decide deductibility. Mark uncertain items for review because tax treatment depends on the country, property and circumstances.

A 15-minute monthly workflow

Enter or import the month's transactions.
Attach or reference receipts, invoices and lease records.
Reconcile the tracker to the property bank and credit-card statements.
Confirm rent collected, unpaid rent, vacancy and other income.
Review uncategorized, duplicated and unusually large entries.
Compare actual results with the property budget.

Numbers worth reviewing each month

Use the records to calculate scheduled rent, collected rent, vacancy and credit loss, operating expenses, net operating income, debt service, cash flow and capital spending. Keep operating performance separate from financing so a change in the loan does not hide a change in the property.

For a fuller analysis, use the rental property cash-flow calculator, net operating income calculator or rental taxable-income calculator.

Year-end review checklist

Reconcile all bank, card and payment-platform totals.
Find missing receipts and contractor invoices.
Separate repairs from capital improvements for review.
Split loan interest from principal.
Check personal, shared and mixed-use expenses.
Confirm totals separately for every property.
Export the ledger and supporting documents for your tax preparer.

Common tracking mistakes

Combining several properties in one undifferentiated total
Recording the full mortgage payment as an expense
Mixing capital projects with routine repairs
Netting costs against rent instead of recording both
Counting a credit-card payment as a second expense
Waiting until year-end to reconstruct missing records

Download the free rental income and expense tracker

You may also find the annual property budget and rent roll and lease tracker useful.