Room Rental Ledger Template

Summary

You can keep track of expenses and income from renting out rooms and apartments with the help of this template. You can modify this template as per your business model and keep track of all the transactions to compute net rental income.
Features of Room Rental Ledger

If you are in the businesses of renting out rooms on short term or long term basis, you can use this free ledger template for rental income. In many tourist locations, people rent out rooms on sharing basis or give out studio apartments. This helps in hassle free income and no need for rental agreements and all. This is useful for independent room rental business or Air BNB rental owners. This excel template will help you capture the following information;

  • Name of your building or property and address
  • Tenant name
  • Period of stay or rental
  • Payment date (date or receipt)
  • Rent Amount
  • Total rental Income (Year to Date)
  • Expenses in the rooms
  • Net room income

This template will give you details for each room. You can create separate net rental income tracking for individual rooms in different worksheet. Or, Explore other rental ledger template and see if you find any other template which can help you capture more details in single worksheet for multiple rooms rental business. Also, explore business invoice templates to invoice your tenants. If you want to update or keep track of income from renting out, you can find similar templates too.

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
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