Download Annual Rental Ledger Free Excel Template

Filter by Categories
Select all
Budget
Business Statements
Calendars
Federal Income Tax
Gantt Chart
GST India
Health, Logs and Personal Trackers
Inventory
Investments
Invoice/ Bill
Maintenance
Payroll & HR
Project Reports & Timelines
Purchase Order/Requisition
Quotation
Rental Ledger
Risk Registers
Sales/ Marketing
SWOT Analysis
Timesheet/ Attendance
UAE VAT
UK VAT
Filter by File Types






Download free excel template for tracking yearly or annual rental income. This template is useful for property managers, property owners, agencies etc.

About Annual Rental Ledger Excel Template

Once you download this template, you will see that this template comes with single worksheet. One sheet is useful to update detail of annual rental income from one property. If you have multiple properties, you can either create additional worksheet (by copying) for each property or use our comprehensive general ledger account excel template.

Coming back to this template, this template gives your liberty to update following information:

  • Tenant Name
  • Email of tenant
  • Property Code/ Address
  • Phone
  • Year (The year you want to track rental income)

The above details are basic information which will change very rarely. Now, in the lower section there is a table which will be used to track the rental income and other details.

Monthwise table is prepared to capture details like Rent Due, Date of receiving rent, Amount Received, Not paid, Late fees. Now, YTD (Year to Date) details in the last section helps you track summary of all the above information for that particular year.

Some of the good practises for rental income and property managers can be:

  • Reminding tenant about upcoming rent due via email for timely collection.
  • Inclusion of late fees for delay in rent payment. Late fees clause can be part of rent agreement.
  • Some commercial properties include rebates and discounts for bulk payments of rent, which can ensure good liquidity and early receipt of all the rent dues.
  • Periodic communication of statement of account (SOA) for each property with the tenant to avoid disputes.

Download and use Annual Rental Ledger Excel template

To use this free annual rental ledger excel template, you should have Microsoft Office/ Microsoft Excel installed in your system.

After installing Excel or Spreadsheet, download the zip file of this template, extract the template using WinRAR or 7Zip or WinZIP (Recommended) decompressing software.

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click the button below to Download Annual Rental Ledger Excel Template

By Downloading this Free Excel Template, it is implied that you comply with Download Instructions

Download Instructions

If the excel templates can not be downloaded, Leave us a feedback at admin@exceldownloads.com. We will solve the related problems/ query for you as soon as possible. All Excel templates and dashboards and tools are sole property of exceldownloads.com. As a User, you can download and use the excel templates, dashboards and calculators for personal and business use with no payment i.e. for free. But without permission, you can not distribute it on the Internet website or any other online or offline medium !

Without permission granted from us/ management team of ExcelDownloads.com, use of these excel templates and dashboards is not allowed. However, if you want to share this templates and dashboards with your friends and peers, we have provided sharing option in various social media and platform via which you can share our content.

We hope that you can get our help in making your personal and business activities easier with the use of free excel templates and dashboards, and at the same time, support the construction of our website by considering our efforts and aforesaid instructions.