Skip to content
Rental Income and Expense Log cover: a sample sheet with rent received, costs paid and net before depreciation and a bar chart, beside the Dashboard tab

Rental Income and Expense Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This log is for landlords who rent out one house, several units or a cottage. The Rent tab logs every payment against its unit, tenant household and whether it arrived on time, while the Expenses tab records repairs, utilities, insurance, property tax, management fees, advertising and mortgage interest with a vendor or note. The Dashboard reports rent collected, costs paid, the net before depreciation and two charts, one of costs by category and one of rent against costs by unit.

Add each payment as it arrives rather than at year end, so late rent and large repairs show up early. Keep the invoice or lender statement beside each cost, and use the vendor column to say whose bill it was. Depreciation and the split between repairs and improvements are not worked out on this sheet, so settle those with a tax preparer before filing.

Useful for

  • Tracking rent from several units each month
  • Totaling repairs and fees for a tax return
  • Comparing the net income of two properties

What's included

  • 4 tabs: Dashboard, Rent, Expenses, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Rent: a table
  • Expenses: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Rent tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Does this log cover depreciation?

No. The sheet shows rent received and costs paid, with the net before depreciation. Depreciation is a separate calculation with its own rules, so look at up-to-date IRS publications or have a tax preparer work it out.

How do I record a late rent payment?

Record the amount when the money actually lands, then mark Status as Late. The rent still counts in the totals, and the Dashboard shows how many payments were late.

Can I split one cost between two units?

Yes. Enter one row for each unit with its share of the amount, and write the split in the vendor or note column. The Dashboard then adds each part to the right unit.

  • #tax-tracker
  • #rental-income-tax-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tax tracker templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…