If you are landlord or a property agent managing numerous properties then you need to provide rent receipt either on demand or when the tenant pays you in cash. From the tenant's point of view it is important to seek rent receipts when you pay in cash or for keeping record of recurring monthly expenses. In addition to this, if a dispute arises regarding the payment then this rent receipt works as a proof of payment.
Most of the time tenants demand all the twelve receipts at the time of tax payment. It creates piles of work for landlords and property agents. Spreadsheet123 provides this Rent Receipt template to make your task easier. Use this rent receipt to simply confirm the payments made on your home or apartment. You can either print it blank and write with pen or fill it with relevant details and then print.
NOTE: If for any reason you prefer to invoice your tenants instead of issuing rent receipts, you can use Spreadsheet123's customizable simple invoice template, which can help you to do so.
Rent Receiptfor Excel® 2003+
How to use rent receipt template
First of all setup the tenants details in the first sheet where you can write the name of tenant who can be an individual or a company followed by recording the address. Each time your tenant changes or you manage a new property, you need to customize it again. You can also specify the currency and the pickup a most suitable colour.
This template has two worksheets with different formats mentioned as below:
This worksheet has rent receipts as three copies. You can record Rent Receipt number, date of issuance, amount received, period for which receipt is issued, tenant name, property address, name and address of receiver. In addition to these, you can indicate the instrument of payment with details or mark as cash.
Rent Receipt with Slip
This worksheet has rent receipts as four copies along with Rent Receipt Slips which you can keep for your records. You can record Rent Receipt number, date of issuance, amount received, period for which receipt is issued, tenant name, property address, name and address of receiver. In addition to these, you can indicate the instrument of payment with details or mark as cash. All the information submitted in Rent Receipt automatically appears in Rent Receipt Slip section on the left Just remember not to delete formulas that is contained in Rent Receipt Slip section and date field. Once you become more familiar with the template you can simply protect these columns from unnecessary changes using Excel's Protect Sheet option.
We recommend you to send a PDF version of your rent receipt instead of excel file. You can use PDF converter or printer to create a PDF file for Microsoft Excel 2010 and earlier or use built in PDF converter of Excel 2013. Alternatively you can also print it and send it by mail service or FAX.
Function used in template
- IF(logical_test, [value_if_true], [value_if_false])