Rental Property Profit and Loss Template - Expense and Income Tracking

Sep 4, 2026

Upload by Himbo

Rental property profit-and-loss worksheet template for tracking rental income and operating expenses across multiple properties. Includes sections for property addresses, fair rental days and personal days, income entries such as rents received, and a detailed expense breakdown including advertising, travel, maintenance, commissions, insurance, management fees, mortgage interest, repairs, supplies, taxes, and utilities. Also provides structured space for other expenses and dedicated auto expense tables.

LanguageEnglish

CategoryInvoices

FormatPDF

Pages2

Reading Time1 min

AccessFree to download

Property Details

Days Allocation

Income

Expenses

Other Expenses

Auto Expenses

| Property | Address of each property (street, city, state, ZIP code) | Fair Rental Days | Personal Days | | --- | --- | --- | --- | | 1 | | | | | 2 | | | | | 3 | | | | | 4 | | | | | Description | Property 1 | Property 2 | Property 3 | Property 4 | | --- | --- | --- | --- | --- | | Income | | | | | | Rents Received | $ | $ | $ | $ | | Expenses | | | | | | Advertising | $ | $ | $ | $ | | Auto | See Part 2 | See Part 2 | See Part 2 | See Part 2 | | Travel | $ | $ | $ | $ | | Cleaning & Maintenance | $ | $ | $ | $ | | Commissions | $ | $ | $ | $ | | Insurance | $ | $ | $ | $ | | Management Fees | $ | $ | $ | $ | | Mortgage Interest | Give Form 1098 | Give Form 1098 | Give Form 1098 | Give Form 1098 | | Other Interest | $ | $ | $ | $ | | Repairs | $ | $ | $ | $ | | Supplies | $ | $ | $ | $ | | Taxes | $ | $ | $ | $ | | Utilities | $ | $ | $ | $ | | Other Expenses | Property 1 | Property 2 | Property 3 | Property 4 | | --- | --- | --- | --- | --- | | Description | Amount | Amount | Amount | Amount | | | $ | $ | $ | $ | | | $ | $ | $ | $ | | | $ | $ | $ | $ | | | $ | $ | $ | $ | | | $ | $ | $ | $ | | | $ | $ | $ | $ | | | $ | $ | $ | $ | | | $ | $ | $ | $ | | | $ | $ | $ | $ | | AUTO EXPENSE | | | | | --- | --- | --- | --- | | Car 1 | | Car 2 | | | Property \# | | Property \# | | | Description of Vehicle: | | Description of Vehicle: | | | Date placed in Service: | | Date placed in Service: | | | Description | Amount | Description | Amount | | 2020 Bus. Miles | | 2020 Bus. Miles | | | 2020 Total Miles | | 2020 Total Miles | | | Parking Fees | $ | Parking Fees | $ | | Tolls | $ | Tolls | $ | | Car 3 | | Car 4 | | | Property \# | | Property \# | | | Description of Vehicle: | | Description of Vehicle: | | | Date placed in Service: | | Date placed in Service: | | | Description | Amount | Description | Amount | | 2020 Bus. Miles | | 2020 Bus. Miles | | | 2020 Total Miles | | 2020 Total Miles | | | Parking Fees | $ | Parking Fees | $ | | Tolls | $ | Tolls | $ | | AUTO EXPENSE | | | | | | | | | --- | --- | --- | --- | --- | --- | --- | --- | | Car 1 | | Car 2 | | Car 3 | | Car 4 | | | Description | Amount | Description | Amount | Description | Amount | Description | Amount | | Garage Rent | $ | Garage Rent | $ | Garage Rent | $ | Garage Rent | $ | | Gas | $ | Gas | $ | Gas | $ | Gas | $ | | Insurance | $ | Insurance | $ | Insurance | $ | Insurance | $ | | Licenses | $ | Licenses | $ | Licenses | $ | Licenses | $ | | Oil | $ | Oil | $ | Oil | $ | Oil | $ | | Rental Fees | $ | Rental Fees | $ | Rental Fees | $ | Rental Fees | $ | | Repairs | $ | Repairs | $ | Repairs | $ | Repairs | $ | | Interest | $ | Interest | $ | Interest | $ | Interest | $ | | Property Tax | $ | Property Tax | $ | Property Tax | $ | Property Tax | $ | | Tires | $ | Tires | $ | Tires | $ | Tires | $ | | Other Exp. | $ | Other Exp. | $ | Other Exp. | $ | Other Exp. | $ |

FAQs

How many properties can this profit-and-loss template track?

The template is structured with columns for four properties (Property 1 to Property 4), allowing side-by-side tracking.

What income fields are included for each property?

Each property includes an Income section with a line for Rents Received.

Does the template include both general expenses and auto-related expenses?

Yes. It provides a comprehensive expenses list (e.g., advertising, maintenance, taxes, utilities) plus separate auto expense tables for multiple cars.

Sep 4, 2026

Upload by Himbo