< FormatWorks >

Simple Monthly Rental Ledger Template

| |
Simple Monthly Rental Ledger Excel Template Feature Image




Keep track of your monthly rental income from specific apartment, flat, commercial property or any other real estate property with the help of this simple monthly ledger format. Customize as per your requirement.
Features of Simple Monthly Rental Ledger

Just like any other rental ledger for personal and business uses available here, this one also serves similar purpose. You can capture the rental income from one specific property using this excel template. However, in single workbook you can create multiple sheet for multiple properties. This template is useful for flat owners, residential apartment owners, real estate agents and even useful to personal level for keeping track on rental payments.

With this rental ledger template you can capture the following kind of information with the pre-defined columns, rows and fields;

  • Address of your property
  • Year to keep track (example, 2024, 2023)
  • Tenant name
  • Move-in date
  • Security Deposit
  • Monthly rent
  • Payment Due date
  • Email of tenant
  • Payment date
  • Amount due
  • Amount paid
  • Late Fees
  • Balance payment
  • Notes (terms and conditions)

Now, as per the rent agreement with the tenant, you will get many information required in the fields. For any lease or rent, there should be an agreement between the tenant and owner. This will give legal validity to the transaction. You can find the total income from renting out with the help of this template. If you want to capture the expenditure done on the specific apartment (from your pocket) you can also find rental ledger template with expenses here. You will need to deduct the expenses to find out the “Net Rental Income“.

Download Instructions

Follow the download instructions below, if you need any assistance. You can download this template for free and start customizing or using it. All the templates, resources, formats and designs are free of cost. However, By downloading this template, you also accept our terms of use policy and privacy policy.

Once you download this template, by default, the file/ folder extension will be compressed (zip). You will require decompressing software to get all the template files. You can use 7ZIP, WINRAR etc. Also, ensure that you have the appropriate software installed on your system for the file type you are downloading (e.g., Microsoft Office for DOCX, PPTX and XLSX files, a PDF reader for PDF files). Now, Right-click on the template file you’ve downloaded and Select “Open With” from the context menu.

You can choose the relevant software/application to open the file. For DOCX files, use a word processing application (e.g., Microsoft Word or any other document reader). For XLSX files, use a spreadsheet application (e.g., Microsoft Excel or Google Sheets or Spreadsheet or Apple Numbers). For PDF files, use a PDF reader (e.g., Adobe Acrobat). For PPTX files, use a presentation software like Microsoft PowerPoint, Google Slides or Prezi or even upload it to Canva and use it. Alternatively, you can double-click on the template file, and it will open in the default application associated with that file type on your system.

If you encounter any issues, ensure your software is up-to-date or consider using an alternative application that supports the file type.

Picture of FormatWorks
FormatWorks Inc. offers free designs, templates, formats and layouts for various personal and business use cases. Our aim is to deliver resources free of cost. You can get templates for presentation, spreadsheet, CV/ Resume, agreements and more.

Related Templates