Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Rental Invoicing Template. Double-click the downloaded file to extract all files.
  2. Open the template "rental1.xls" or "rental1-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Rental Invoicing Template

Rental Invoicing Template (c7001)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Rental Invoicing Template - freeware edition

Rental Invoicing Template - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Rental Invoicing Template - Uniform Invoice Software V3 edition

Rental Invoicing Template - Uniform Invoice Software V3 edition

Download Rental Invoicing Template (c7001)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

353 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.82 MBDownload

Detail

This free blank Rental Invoicing Templates offers an easy way for you to create rental invoices or rental receipts. The rent invoice form is in Microsoft Excel format and is printable on standard A4 paper.

So what is a rent invoice? If you are a landlord or an estate agency when you receive rent from tenant, a rental invoice is a formal document you could give. A rental invoice, as its name implies, should details information like date, amount of rent, installment detail if any and signature of the concerned person. A rent invoicing sample or rental billing form helps you create these types of documents with easy and quick. For example, you can use it as an apartment rental invoicing layout or car rental invoicing design.

You can download the rental invoicing sample for free from here on InvoicingTemplate.com. The free rent invoice format is in Microsoft Excel format. If you are looking for a rental invoicing sample in Microsoft Word or Open Office format, we recommend you to try the Excel formatted rental invoicing spreadsheet template. A PDF rental version is also available here on InvoicingTemplate.com. So how to prepare a rent invoice with this template? It is as easy as filling a paper form using a pen. The rental invoicing format offers an intuitive form so there is no hard learning curve as compared to some complex accounting systems or invoicing programs. The printable free template also allows you to get a hard copy if that is required.

The rent invoice design differs from the standard template in that is has two additional columns, Start Month and End Month, on the body of the rental invoice form. Rental Invoice as the name is very much synonym for hire and leasing activities, anything which was given for a third party for temporary use could be charged with this rental invoice. For this reason, it is necessary to detail the start and end date on the invoice. Every business is different, you might find our free rent invoicing template does not 100% meet your requirements. If this is the case you can still use our free template as a rent invoice sample.

If you are familiar with Microsoft Excel and are interesting in the design details on the template, go on reading; otherwise, go to download rental invoicing sample. InvoicingTemplate.com offers the template in several formats, please choose the one you like and download it.

The free rent invoice layout has two additional columns than the standard sales invoicing layout design, so the most important thing while designing this invoice layout based the default sales invoice design is to adjust the existing 5 columns in the sales invoicing template to leave space for the two new columns (Start Month and End Month).

To adjust the existing columns to leave space for new column or columns that will be added to the printable form for Rental Invoicing Template, we first unmerge the item# (or product#), description and quantity columns - these are usually merged columns that each contains several Excel raw columns. To do this, after opening Rental Invoicing Template as usual, select all the cells belong to these columns and then click the "Merge and Center" button on the Format toolbar in Excel 2003; in Excel 2003, the "Merge and Center" button can be found on the Home ribbon tab. Drag your mouse to select the Description column (this time, you select Excel raw column since the Description is no longer a merged column) and drag it one column left. Select the "oknProductName_1" cell (the first cell on the moved Description column) and drag your mouse to select the two adjacent cells at the right-hand too - so, you now select 3 cells started with the "oknProductName_1" cell. Now click the Merge and Center command again. This will expand the width of "oknProductName_1" to 3 columns. Do this process for all the other Description cells. Once done, you have one empty column that was left by moving the Description column to the left-hand of this original position. Adjust the columns widths of all the columns to make sure they have the proper widths that are able to hold the content they will display on this Rental Invoicing Template.

If you use the Uniform Invoice Software version of this template, it is also required to add Start Month and End Month as custom fields to the Invoice Body database table. They are all fields of type "DateTime".

Adding a custom field to the "InvBdy" database table makes it possible to save the data on the invoice spreadsheet to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the "InvBdy" database table allows save the type value on the invoicing form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Rental Invoicing Template.

With the Uniform Invoice Software version of the rental invoicing template or rental receipt template, there need be a way to identify to which cell or field the invoicing program should write data retrieved from the database. This is done by using cell names. All cells on the printable rental invoice form or rental receipt form should be named if the cells should interact with database.

When working with Uniform Invoice Software (UIS) version of Rental Invoicing Template, how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template Rental Invoicing Template and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

If you own a property management service, this rental invoicing template or rental receipt template might be helpful. This rental billing form was designed for rental properties or monthly subscription service. It includes an area for the property address and tenant name. There are also fields for commonly use items.

Like other form designs here on InvoicingTemplate.com, Rental receipt form is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2003, 2007, 2010, 2013 or 2016.

Format and Specification

Template#c7001
NameRental Invoicing Template
CategoryService Invoice Template
Release DateTuesday, December 10, 2013
Format (XLS or XLSX).xls
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns7
Lines6
Line Height (Points)49.50
Print Area$F$2:$P$34
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left15.12
Right20.88
Top72.00
Bottom72.00

Sample Templates