Download free excel format for tenant general ledger. This is also understood as “General Rental Ledger Format” in the business parlance. You can easily download this template and keep track of your rental payments or receivables.
- For Tenants – this template can be helpful to track all your upcoming rental payments and paid amount.
- For Owners – this template can be helpful to track all rental receivables and received amount as rentals.
About Rental Ledger Excel Format
Once you download this free excel template for rental ledger, you will see that this template is a basic template with very crux fields. It comprises of fields like –
- Name of tenant
- Due date
- Payment Amount
- Balance amount
If you are a tenant, what you can do is write down the name of owner in place of name of tenant. This is printable ledger format in excel, so you can take a print out of this template and share with your counterparty.
Furthermore, if you own more than 3 houses and want to consolidate all the rental income and tracking in one single excel file, you can copy the sheet and create various versions and sub-sheets in the same excel file. Additionally, you can add new column to capture the address of your property or any additional details like security deposits or advances received etc.
Download and use tenant rental ledger excel format
To use this free tenant rental ledger template in excel, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets.
Once extracted, you can open the file using Excel and start entering data or customizing the template.