Free Printable Rent Receipt Template (Excel)
What's inside the free rent receipt template
The file has two sheets that work together: a Rent Receipt form you fill in and print for each payment, and a Receipt Log that records every payment across all your tenants and properties.
The receipt form covers what a tenant actually needs to see: who paid, the property or unit, the period the payment covers, the date received, the amount, the payment method, and who received it.
The Receipt Log is a 100-row table, so a landlord with a handful of units and a full year of monthly payments has plenty of room to keep every receipt on record in one place.
Recording a payment and printing the receipt
To issue a receipt, fill in the Rent Receipt sheet with the tenant, property, period, date, amount, and payment method, then print it or export to PDF and hand it to your tenant - it's laid out to print cleanly on a standard page.
Separately, add a row to the Receipt Log with the same details (receipt number, date, tenant, property, period, amount, method) so the payment is on record even after you've reused the receipt form for the next tenant.
The log's Tenant paid to date column totals every payment logged for that tenant automatically, so you always know where a tenant's account stands without adding up rows by hand.
Rent invoice vs rent receipt: what's the difference
A rent invoice is a request for payment sent before rent is due; a rent receipt is proof that a payment was already received. They serve opposite moments in the same transaction - one asks for money, the other confirms it arrived.
This template is built for the receipt side: recording and printing proof of payment. If you also need to bill tenants before they pay, pair it with a rent ledger that tracks amounts owed.
Some landlords use both: an invoice or reminder sent near the due date, and a receipt issued once the rent actually comes in - the receipt is what most tenants keep for their own records.
What a rent receipt must include (and when landlords are required to give one)
A rent receipt should show who paid, the property or unit, the period the payment covers, the date received, the amount, and how it was paid - the fields this template's receipt form already has laid out.
Several states require landlords to provide a rent receipt on request, or automatically for cash payments - check your state and local landlord-tenant law, since requirements vary and this template doesn't track jurisdiction-specific rules for you.
Even where it's not legally required, giving a receipt every time protects both sides: it's the tenant's proof of payment and the landlord's proof of when and how much was collected.
Keeping a year of payment history for taxes and disputes
The Receipt Log keeps a full year (or more, across 100 rows) of every payment logged, with the date, amount, and method for each - useful when you're reconciling rental income at tax time.
If a payment dispute comes up, the log is your record: the date, amount, and method are right there next to every other payment for that tenant, not scattered across individual printed receipts.
Because the log's paid-to-date total updates automatically as you add rows, it also works as a quick health check on which tenants are current and which are falling behind.
How to use it
- Fill in the Rent Receipt sheet with the tenant, property, period, date, amount, and payment method - then print it or export to PDF for your tenant.
- Add the same payment as a new row in the Receipt Log.
- The Tenant paid to date column totals every payment logged for that tenant automatically.
- Reuse the Rent Receipt sheet for the next payment - the log keeps a running record independent of it.
Download the free Free Printable Rent Receipt Template (Excel)
No spam — template updates and new free templates only. Unsubscribe anytime.
Real Estate Investor Pack
Once you're tracking rent collected, the paid Real Estate Investor Pack ($39) adds a full rental P&L with live cash-on-cash return, DSCR, and a 360-month amortization schedule.
See the full versionFrequently asked questions
Can I print these receipts?
Yes - the Rent Receipt sheet is laid out to print cleanly on a standard page, so you can print it directly or export it to PDF to email or hand to your tenant.
Can I use this in Google Sheets?
Yes. Upload the file to Google Drive and open it with File > Save as Google Sheets. The paid-to-date formula in the log keeps working.
What's the difference between a rent receipt and a rent invoice?
A rent invoice requests payment before it's due; a rent receipt confirms payment after it's received. This template handles the receipt side - recording and printing proof of payment.
Does the receipt auto-fill from the log?
No - they're two separate sheets. Fill in the Rent Receipt sheet to print a receipt, and separately add the same payment as a row in the Receipt Log to keep a running paid-to-date total.
How many payments can I log?
The Receipt Log has 100 rows, enough for a year or more of payments across several tenants.
Is it free?
Yes, in exchange for your email address. It's yours to use afterward with no further cost.