The rental ledger, which is used to track rent collection, acts as a ledger that provide that payments between the landlord and the tenant are recorded regularly. This ledger, which you can sort chronologically by date, amount and description of each payment, also prevents “rent arrears” disputes that may occur with the tenant. In addition, it can be used as proof of income for mortgage renewal at the bank.

Rental Ledger
Rental Ledger

Records that are not kept regularly or consist of mixed handwritten notes are considered weak evidence, especially in “tenancy tribunal” sessions; however, a fully completed Rental Ledger clearly reveals the “due date”, “amount paid”, “payment method” and “balance forward” information, thus clarifying who is right. Therefore, using a correct rental ledger template is extremely important.

Rental Ledger Templates

A well-designed rental ledger template should include all important financial details regarding the rental relationship and have an easy-to-understand structure. As the TemplateCalendar team, we have designed more than 41 rental ledger templates in Word, Excel, and high-resolution PDF formats. Thanks to its simple design that does not include macros or automatic formulas, even users who do not know how to use MS Office can easily fill in the sections in the templates by following the guidelines. In standard templates, we positioned the titles “Tenant Name”, “Property Address” and “Lease Period” as a single line at the top; and at the bottom, we made it possible to archive copies without damage with the 12-month table, “Rent Due”, “Date Paid”, “Receipt Number” and “Running Balance” columns for each month. We also designed “multi-property rental ledger” templates for real estate investors who operate more than one apartment. Templates come in both A4 and U.S. Letter sizes, so you can print in either format.  For those who do not want to deal with manual editing, our templates in Excel format will also make balance calculations much easier.

Although the Rental Ledger template may seem like nothing more than a payment log, it can also be used to document “property tax deduction” items in the year-end income-expense declaration or to present “tenant payment history” in a court summons. For example, when you regularly send your tenant a statement of account by e-mail, you fulfill your legal duty to remind them of upcoming payments and provide legal grounds for implementing your “late payment fee”. Of course, this ledger protects not only the property owner but also the tenant in many ways. For example, when there is a dispute with the landlord about the return of the deposit, the every charge—rent, repairs, or extra fees clearly constitutes evidence in favor of the tenant. Claims such as the tenant not reflecting the maintenance and repair fee or not paying extra fees the rental ledger quickly disproves such claims

Using professionally designed, ready-made rental ledger templates throughout every step will provide that both parties manage the process smoothly. You can download the format that suits you with a single click from the rental ledger templates that we offer completely free of charge. After downloading, also be sure to edit the file with compatible software. Those who want to keep them as documents, in addition to keeping a digital copy, can easily print the rental ledger templates after making all the edits. That’s it. Getting a professional rental ledger template takes only a few minutes.