Downloading and Saving the Template
Similar to our free printable receipt, the rent receipt template comes in two styles – one with a grey background and the other has lines with no shading.
The shaded one looks a little more professional, but if you want to save on printer ink then go with the lined one.
They are both included in the Excel download above. Here is a screenshot of the Excel tabs:
Once you have opened the Excel download, click on ‘File’ then ‘Save As’ and give the receipt a name of your choice, saving it to a folder you can remember on your computer.
If you want to make changes to the layout, then save it as an Excel document, make your changes and once you are satisfied save it again as an Excel template.
If you want to leave our download as it is without making any changes, simply save it as a template.
Saving it as a template means that every time you want to issue a receipt and you fill in all the information such as date, tenant’s name etc., when you go to save the receipt to your computer, it will save to a new document which you can give a unique name, like the tenant’s name and month of receipt [Abigail Johnson – January].
Meanwhile, the original template stays exactly the same so you can use it again and again!
Filling in the Rent Receipt Template
Typing in the Cells/Fields
Each blank cell holds instructions, like the following that says 'Tenant's Name':
In your Excel document, click your mouse pointer into this field and start typing the name of the tenant – the instruction will automatically be removed and the information you typed in will be there instead.
You can do this with all the cells/fields.
Right click your mouse over the date cell, then click on ‘format cells’ then on the ‘number’ tab, then on ‘date’. This will bring up a selection of date formats for you to choose from as in the above example.
As you may already know, some countries like the USA use a different date format to other countries i.e. the USA puts the month first, then the day, then the year [January 28, 2018] whereas many other countries put the day first [28 January, 2018]