free landlord rental income and expense tracking excel template

Notes. This is a section for any important notes you want to make about a rental unit.

Type of property (e.g., single-family, duplex, etc.).

This is necessary to know when returning a tenant’s deposit and making deductions from their security deposit for damages or repairs. It’s important to know how much a tenant provided for their security deposit.

Lease start and end date. This information will help you keep track of where a tenant is in their lease to plan for inspections and to determine whether or not you will be renewing a tenant’s lease.When you maintain a rent ledger over time you will have a picture of the complete payment history of all of your rental units. This column will consist primarily of rent payments with real-time payment updates. Total due. In addition to the base rent, you should have a column that contains the total amount due for that month which can include late fees and a tenant’s outstanding balance.Monthly rent payment. This column should list the base rent amount along with any recurring fees (e.g.This is especially important if you have multiple rental properties with due dates on different days of the month. A consistent item on every landlord’s rent ledger should be the date the rent is due. Here are some examples of expenses you may have on a rent ledger: This can include entries for upcoming payments as well as payments made. Here are some additional details it should include: It should also contain any other information that is helpful in managing the property. The ledger should contain information to assist in keeping track of all of the expenses and income for properties the landlord is managing. Property address(es) and unit number(s).

Description. In this section you can provide specific details regarding repairs or whether rent was paid/received timely and in the full amount.

Amount of income received or expense paid.

Regardless of the type of property, your rent ledger should include the following information: Some landlords choose to use one ledger for all their rental properties while others prefer one ledger per property. Rent Ledgers can contain a variety of information. A rent ledger (also called a lease ledger) is a document used to keep track of income, expenses, repairs, and other important information for a rental property or group of rental properties.

Free landlord rental income and expense tracking excel template