A rent ledger is a monthly record used to document rent charges, payments made, late fees, and any unpaid amounts for the term of a lease. It serves as a history of rental activity and can be used by both landlords and tenants to maintain accountability throughout the rental period. It’s especially useful for long-term agreements, payment tracking, or keeping consistent records over time.
This rent ledger template is designed for landlords, managers, or tenants seeking a simple way to record lease details and track payments throughout the year. It includes a section for property and tenant information, a 12-month payment log, and space for additional remarks. It’s available in multiple file formats and can be printed or filled out digitally.
Rent Ledger Template
How to Use This Template
As designed in multiple file formats, this template includes basic automated calculations in the payment table and is arranged for easy, month-by-month updates. It includes the following sections:
Property Information
This section is used to record key details about the tenant, rental unit, and lease terms. It ties the payment log to a specific property and lease, especially when managing multiple units or tenants. Fill out this section at the start of the tenancy. If a field doesn’t apply, it can be left blank or marked with a dash.
- Address & Unit – The full street address and unit number, if applicable.
- Tenant(s) – Names of tenants listed on the lease.
- Other Occupants – Individuals living in the unit who are not named on the lease.
- Phone (x2) – One for the tenant’s main contact, the second for a backup or emergency contact.
- Monthly Rent – The fixed rent amount due each month.
- Year – The calendar year this ledger covers.
- Lease Start Date (optional) – Can be added below the year to mark when the lease began.
Rental Charges and Payments
This section is used to record rent charges, payments made, additional fees, and the resulting balance for each month. The table includes pre-filled rows for all twelve months and a final row to calculate the yearly totals. Use this section to update the ledger whenever a rent payment is made or when any extra charges are applied. The columns in this section include:
- Month – Each row represents one calendar month, listed from January to December.
- Date Paid – The date the payment was received.
- Rent Charge – The expected rent amount for the month.
- Additional Fees – Any charges beyond rent, such as late fees, utility costs, or repair fees.
- Rent Paid – The actual amount paid by the tenant.
- Balance – The difference between total charges and payments made. This is calculated as:
Balance = (Rent Charge + Additional Fees) – Rent Paid
In Excel and Google Sheets version, these calculations are automated; the balance can show a positive number if an amount is still due, zero if the payment was complete, or a negative number if there was an overpayment or advance.
Notes
The notes section can be used to record any information that doesn’t fit within the payment table. This includes explanations for partial payments, agreements on future payment adjustments, or any remarks related to communication, late fees, or changes in tenancy. Use this area to document exceptions or important details that may come up during the rental period. Notes can be added at any point throughout the year.
FAQs
The rent ledger is typically maintained by the landlord or property manager, but tenants may also keep a copy for personal records. In shared units, one person may be responsible for submitting payments, but all tenants can reference the same record to avoid confusion.
Yes. Begin by entering the lease start month in the “Month” column and leave the earlier rows blank or marked with dashes. The rest of the year can be filled in normally as payments are made.
Enter the amount received under “Rent Paid” and let the balance column reflect the difference. You can use the “Notes” section to explain when the remaining amount is expected or if a payment plan was agreed upon.
Update the “Rent Charge” field in the relevant month’s row to reflect the new amount. If the change is temporary or needs clarification, note the reason and date in the “Notes” section.
Yes. Use the “Additional Fees” column to enter any extra charges each month. You can specify the type of fee in the “Notes” if needed for future reference.
This rent ledger template is available in Excel, Word, Google Docs, Google Sheets, and PDF. The spreadsheet versions are ready for digital use with auto-calculating columns, while the PDF version is fillable and can be typed into directly without printing. All formats follow the same layout and can be saved, printed or shared as per preference.