Every rent payment you receive should have a paper trail behind it. A rent receipt creates a written record of when money changed hands, how much was paid, and which property the payment applies to. For landlords, it serves as proof during disputes over missed or late payments. For tenants, it doubles as documentation they may need for tax filings, reimbursement claims, or proof of residence.
This rent receipt template for Excel is designed as a printable, fill-in-the-blank receipt that landlords, property managers, or tenants can complete each time a rent payment is received. The layout places three separate receipt blocks on a single page, so you can record up to three transactions before printing another copy. Each block contains labeled fields for tenant and property identification, payment amounts (including any late fees), the rental period covered, and the payment method used. Checkbox selectors for Cash, Order No, and Check No let you mark how the payment was made, and a dedicated space at the bottom right of each block gives the landlord room to sign. The template is compatible with both Microsoft Excel and Google Sheets, so you can fill it in digitally before printing or print blank copies and complete them by hand.
Here is a closer look at each section of the template and how to fill it out accurately.
Tenant and Payment Information
The left side of each receipt block is where you record who made the payment and how much was received. Getting these fields right is important because they form the financial core of the receipt, the part both parties are most likely to reference later.
- Received From is where you enter the full name of the tenant making the payment. If multiple tenants share the lease, use the name of the person who physically handed over the payment or initiated the transfer.
- Amount Paid should reflect the exact dollar (or currency) amount received for that transaction. If the tenant paid rent plus an additional amount for utilities or other agreed-upon charges, enter only the rent portion here, and note extras separately if needed.
- Late Payment Fees is a separate field specifically for any penalty amount charged when rent arrives past the due date. If no late fee applies, you can leave this blank or enter zero. Keeping late fees on their own line rather than bundling them into the total amount paid gives both parties a transparent breakdown of the payment.
If your lease agreement specifies a grace period (for example, five days after the first of the month), note the actual date of receipt in the Date field on the right side of the receipt. That timestamp, paired with the late fee amount, creates a self-explanatory record if either party questions the charge later.
Property Details
Below the payment fields, two fields connect the receipt to the specific rental unit. This is particularly useful if you own or manage more than one property, since it removes any ambiguity about which address the payment belongs to.
- Property Name is intended for the name or identifier of the building or complex, if applicable. For a single-family rental, you might enter a shorthand label like “Oak Street House” or leave it blank if the address alone is sufficient.
- Property Address should include the full street address of the rented property, including the unit or apartment number. This is especially important for landlords who manage multiple properties, because it links each receipt to the correct unit in your records.
Rental Period
Every receipt block includes a Rental Period row with two sub-fields: From and To. These represent the start and end dates of the period the payment covers. For a standard monthly rent payment, you would enter the first and last day of the month (for example, From: June 1, 2035 and To: June 30, 2035).
If a tenant makes a partial payment that does not cover the entire month, adjust the “To” date to reflect only the portion of the period paid for, or note the partial amount in a comment. This avoids confusion during reconciliation and keeps each receipt accurate to the amount actually received.
Landlord and Contact Details
The lower portion of each receipt block identifies who collected the rent and how the tenant can reach them. These fields tie the receipt to a responsible party, which adds accountability and gives the tenant a reference point if they need to follow up.
- Received By is the name of the landlord, property manager, or authorized representative who accepted the payment. This should match the person who signs at the bottom of the receipt.
- Email Address and Phone Number provide the contact information of the person or management entity that received the rent. Including these details on the receipt itself means the tenant always has a point of contact attached to their proof of payment, which can be helpful if questions arise weeks or months later.
Date, Receipt Number, and Payment Method
The right-hand column of each receipt block covers when the payment was received, how to identify the transaction, and what form the payment took. Together, these three fields turn each receipt into a traceable record you can cross-reference with bank statements or accounting logs.
- Date is the calendar date the payment was received. This is distinct from the rental period. For instance, a tenant might pay July’s rent on June 28, and the Date field would reflect June 28 while the Rental Period would read July 1 through July 31.
- Receipt No gives you a space to assign a unique identifier to each receipt. Numbering receipts sequentially (001, 002, 003, and so on) is an easy way to keep your records organized and to reference specific transactions during bookkeeping or audits.
- Paid By includes three checkbox options: Cash, Order No, and Check No. You select the one that matches how the tenant paid. If payment was made by money order, check the Order No box and write the money order number in the adjacent space. The same applies for checks. If the tenant paid in cash, check the Cash box. Only one method should be selected per receipt.
When receiving cash, filling out the receipt on the spot and handing the tenant a signed copy is especially critical, since there is no bank record or digital trail to fall back on. For check or money order payments, noting the order or check number on the receipt creates a cross-reference you can verify against bank deposits.
Landlord’s Signature
At the bottom right of each receipt block, you will find a space labeled LandLord’s Signature. This is where the landlord or authorized receiver signs after confirming the payment. A signed receipt carries more weight as a legal record than an unsigned one, so it is worth making this step a consistent habit, especially for cash transactions.
Printing and Using Multiple Receipts Per Page
Because the template arranges three receipt blocks vertically on one page, you can record three separate payments on a single printed sheet. This could be three different tenants on the same day, or three consecutive monthly payments from the same tenant. After printing, you can cut the page along the borders of each block to give tenants individual receipts, or keep the full sheet as a consolidated record in your files.
File Formats and Customization
This rent receipt template is available in Excel (.xlsx) and Google Sheets. You can open the file in either application, type directly into the fields, and print as needed. If you prefer handwritten entries, printing blank copies works just as well.
Since the template is built on a standard spreadsheet grid, you can customize it to suit your needs. For example, you could add your company logo at the top of each receipt block, adjust field labels, or insert additional rows for extra line items like parking fees or utility surcharges. If you manage a large number of units and want a running digital log in addition to printed receipts, you could duplicate the sheet and use each tab for a different property or a different month.
