Reviewed & updated by WordNExcel Team — Updated November 10, 2026
A rent receipt template gives landlords and tenants a simple written record that rent was paid, how much, for which period and by what method. On this page you can use the free rent receipt calculator above to work out pro-rated rent, late fees and the balance due, then download five free rent receipt templates in Excel: a rent receipt, a monthly rent payment receipt and a 12-month rent payment ledger, plus a security deposit receipt and a late rent and partial payment receipt.
Each file is a real, editable .xlsx spreadsheet created for this page. The total received is calculated automatically from the rent and any extra charges, and the ledger keeps a running balance month by month. The templates also open in Google Sheets and LibreOffice Calc, and each receipt prints on one page or saves as a PDF to send to the tenant.
Rent Receipt Calculator (Pro-Rated Rent and Late Fee)
Runs in your browser; nothing is sent or saved. Check your lease and local law for allowed late fees.
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is a Rent Receipt?
A rent receipt is a document a landlord or property manager gives a tenant to confirm that a rent payment was received. It normally shows the receipt number, the date, the tenant's name, the property address, the rental period covered, the amount paid, the payment method and the landlord's signature.
Receipts protect both sides. The tenant has proof of payment if there is ever a dispute, and many tenants need receipts to claim housing allowances or tax relief. The landlord has a clear record of income for accounts and tax returns, and can show exactly which months were paid if a tenancy ends in a disagreement.
How to Use the Rent Receipt Calculator
Enter the monthly rent, the number of days in the month and the number of days the tenant occupied the property. If the tenant moved in or out partway through the month, the calculator pro-rates the rent. Then enter how many days late the payment was, the grace period in the lease and the flat late fee. A late fee is added only when the payment is later than the grace period. Add any other charges, such as parking or utilities, and the amount the tenant actually paid.
The calculator shows rent for the period, the late fee, the total due and the balance. With the example figures, rent of 1,200 paid in full on time leaves a balance of zero. Change days occupied to 15, days late to 8 and amount paid to 600, and the result is rent of 600, a late fee of 50 and a balance of 50. If the tenant paid more than was due, the balance shows as a credit. Everything runs in your browser and nothing is saved.
Download the Free Rent Receipt Templates
The five Excel files below cover single receipts and a full year of payment records.
Rent Receipt Template
The standard rent receipt has a receipt number, date, tenant name, property address, rent period from and to, landlord or agent name and payment method. The payment table lists monthly rent, late fee, utilities or service charge and parking, with a line to subtract a deposit if one is applied. The total received and balance due sit at the bottom with a signature line.

Monthly Rent Payment Receipt
This version uses the same structure with a different colour and heading, which some landlords prefer for regular monthly payments. Keep one sheet per month in a single workbook for each tenant, and you have a full set of receipts for the year.

Rent Payment Ledger
The ledger tracks a whole year of rent for one tenant. Enter the monthly rent once and each row shows the month, the due date, the rent due, the amount paid, the date paid and a running balance. Totals at the bottom show rent due and rent received for the year. It is the quickest way to see at a glance whether a tenant is up to date or in arrears.

Security Deposit Receipt

A deposit is not rent, so it deserves its own receipt. This one records the tenant and property, the lease start date, the amount received and the payment method, where the deposit is held (the landlord, an agent or a protection scheme), and the conditions for returning it. Landlords and tenants both keep a copy with the tenancy agreement. In many places deposits must be protected or returned within a set time, so check the local rule and write it in the return conditions line.
Late Rent and Partial Payment Receipt

For the months when rent arrives late or in part. Enter the rent due, any late fee and the amount received today; the balance still due calculates. The note column holds the period and the date agreed for the rest. Giving a receipt for part of the rent, with the balance shown, avoids arguments later about what was paid. The note at the foot makes clear that accepting a partial payment does not waive the balance.
What to Include on a Rent Receipt
- Receipt number: a unique number for each receipt, in sequence, so none go missing.
- Date of payment: the date the money was received, not the date the receipt was written.
- Tenant name exactly as it appears on the lease.
- Property address, including unit or flat number.
- Rental period: the dates the payment covers, such as November 1 to November 30.
- Amount paid, split into rent and any other charges.
- Payment method: cash, cheque (with number), bank transfer or online payment.
- Balance due, if the payment was partial.
- Landlord or agent name and signature.
Cash payments especially need a receipt, because there is no bank record. Many local laws require landlords to give a receipt for cash rent.
How to Fill In the Rent Receipt
- Enter the next receipt number in sequence.
- Enter the date the payment was received.
- Type the tenant's name and the property address.
- Enter the rent period start and end dates.
- Enter the landlord or agent name and the payment method.
- Enter the rent and any other charges in the payment table. Enter a deposit amount only if part of the deposit is being applied to rent.
- Check the total received, enter any balance still due and sign the receipt.
- Give or send the tenant a copy and keep one for your records.
Pro-Rated Rent Explained
When a tenancy starts or ends partway through a month, the tenant usually pays only for the days they occupy the property. The common method is to divide the monthly rent by the number of days in that month and multiply by the days occupied. For example, rent of 1,200 in a 30-day month is 40 per day, so 15 days costs 600. Some leases use a fixed 30-day month or an annual daily rate instead. Write the method into the lease so there is no argument later, and use the same method every time.
Late Fees and Grace Periods
Many leases allow a short grace period, such as five days, before a late fee applies. After that, a flat fee or a daily fee may be charged. Late fees must be reasonable and, in many places, are limited by law, so check your local rules and your lease before charging one. When a late fee is paid, show it on its own line on the receipt so the tenant can see exactly what they paid for.
Keeping Good Rent Records
- Use one receipt book or workbook per property. It keeps the sequence of receipt numbers clean.
- Record every payment the day it arrives. Update the ledger at the same time as you write the receipt.
- Match receipts to bank deposits. At the end of each month, the receipts should add up to the money received.
- Keep copies for several years. Rent income records are needed for tax returns and may be requested if there is ever a dispute.
- Note partial payments clearly. Show the balance still owed so the next receipt starts from the right figure.
Rent Receipts for Tenants
Tenants should keep every receipt in one place, either a folder or a scanned copy in cloud storage. If the landlord does not provide receipts, a tenant can fill in the template and ask the landlord to sign it. Paying by bank transfer creates an additional record, but a signed receipt that names the property and period is still the clearest proof that a specific month's rent was paid.
Sending Receipts as PDF
To email a receipt, save or export the sheet as a PDF from Excel or Google Sheets. The print area is set, so the receipt fits on one page. Name each file with the receipt number and month, such as "R-0001-November-2026.pdf".
Related Templates
You can also check these important templates like the lease agreement templates for setting rent, due dates and late fees in writing, and the receipt templates for other kinds of payments.
Frequently Asked Questions
Is a rent receipt legally required?
It depends on where you live. Many places require landlords to give receipts for cash rent, and some require them for all payments. Even where it is not required, a receipt is good practice for both sides.
How do I calculate pro-rated rent?
Divide the monthly rent by the number of days in the month and multiply by the days the tenant occupied the property. The calculator above does this for you.
Can I use the rent receipt template in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas keep working.
What should I do if the tenant pays only part of the rent?
Write a receipt for the amount actually received and enter the remaining balance in the balance due cell. The ledger will carry the unpaid amount forward.
Should the deposit appear on a rent receipt?
Only if part of the deposit is being applied to rent, for example at the end of a tenancy. Security deposits are usually recorded on a separate receipt.
How long should I keep rent receipts?
Keep them for as long as your local tax rules require, often five to seven years, and at least until any tenancy dispute is settled.
