Rent Receipt Template (Free Excel)
A free rent receipt and ledger. Give tenants a clear receipt and track 12 months of rent, late fees and balances.
Download the free Excel template (.xlsx)
Free. No email or sign-up needed. One Excel file, 3 sheets.
What is inside the rent receipt template
| Sheet | What it does |
|---|---|
| Receipt | Receipt number, tenant, property, rent period, rent, late fee, amount paid, balance and payment method. The period end date and status calculate. |
| Ledger | 12 months of rent due, late fees, payments and a running balance. |
| Read me | Short instructions. |
Yellow cells are for your own numbers and text. Green cells calculate by themselves, so do not type over them. Sample data is included so you can see how it works, then replace it with your own.
How to use it
- Download the file and open it in Excel 2010 or later. It also opens in Google Sheets and LibreOffice.
- Replace the sample data in the yellow cells with your own.
- Read the totals and results that update automatically.
- Save a copy for each month, project or client, or print it from File > Print.
The template is free to use and edit. If you want a version built around your own process, with your branding, extra sheets or automation, tell us what you need.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
Do I need to give a tenant a rent receipt?
Many places require a receipt for cash payments and it is good practice for every payment. Check local law.
What should a rent receipt include?
Date, amount, period covered, property, names and payment method.
How do I track unpaid rent?
Use the Ledger. The balance column carries forward.
Is this legal advice?
No. Check landlord and tenant rules where you live.
Need a custom spreadsheet built for your business?
Talk to usMore free tools: All free Excel templates · Receipt template · Invoice template · Income and expense template