If you run an asset rental business, download this Free Asset Rental Invoice & Receipts Template to create simple and effective invoices and receipts. You can store all your assets and customer details to create unlimited invoices and receipts and manage them all in one file.
- Create invoices for your asset rental business
- Customize invoice and receipt to your business need
- Automatically calculate totals and subtotals
- Handles tax rates at the order level
- Accommodates products that are not taxable
- Handles discounts at product and order levels
- Save time by storing customer and product data
- The template is designed to accommodate 20 line items per invoice or receipt.
- Designed for daily (one or multiple days) rentals and not hourly rentals.
- Microsoft Excel for Windows (2010 and above)
- Microsoft Excel for Mac (2011 and above)
How to use the template
If you are new to Excel Tables, please read the article on how to use Excel Tables for data entry.
You can add columns or rename existing columns as per your business need. You can maintain all your assets in one place.
- Enter Customer details in the Customers sheet
You can add columns or rename existing columns as per your business need. You can add and maintain all your customers on this sheet.
1.Invoice: Enter the Invoice number in cell G5.
2. Date: Enter the date of the invoice in cell G7.
4. Customer: This cell lists down all the customer names in a drop downfield. Enter the Customer’s name in cell C14. On selection of this field, the corresponding customer information below (billing address) gets populated. You can choose to have any other customer information field here – use the dropdown to select the information you want to populate.
5. Out Date: Enter the Out Date in cell F14. This is the start date of the asset rental.
6. Return Date: Enter the Payment Due Date in cell F17. This is the return date of the asset rental.You can choose whether to include the return date to be charged:The number of days rented will be automatically calculated based on this selection.This will be multiplied by the total amount of each asset.
7. Payment Due Date: Enter the Payment Due Date in cell I14. This is the date by which the payment has to be made.
8. Tax @Rate: Enter the Tax Rate in cell I44. You can change this later for each invoice if needed.
9. Discount Amt: Enter the Discount Amount in cell I46. Your value can change for each invoice. Leave this field empty if you do not want to give any discount.
Now, how to enter the list of assets into the invoice – please refer to the screenshot given below for the section that can be editable and others that are auto-populated based on the fields edited.
To create a receipt, just choose Receipt (instead of invoice) on the top left.
Enter the Mode of payment using the drop down list. This cell I14 picks up the value from the data entered in the payment section of the settings sheet.
Enter the Paid Date as well.
Creating multiple Invoices/Receipts
Option 1: Save each invoice as a separate Excel file. To create a new one, just do File –> Save As, and give a new name for the new file.
Option 2: Save multiple invoices in 1 Excel file. Follow the steps given below.
- Keep the Invoice sheet on which the initial setup was done as the master sheet.
- Take a copy of the master sheet.
- Rename the copy with the invoice number.
- Edit the input fields along with the asset details.
- Print the invoice if needed. Export to PDF.
- Save the excel file.
Repeat this process to create as many invoices/receipts as needed.
Record Keeping – Save your invoices and receipts
Save each invoice and receipt as PDFs (Export as PDFs). Give the Invoice Number as the file name. Eg. Invoice_123.pdf
After reviewing and making sure everything looks good, it’s time to print or export.
Press Ctrl+P to preview print.
Print Preview and Print Invoice
The page is set up to be print-friendly. So, you should be able to just print as it is.
To export to PDF, select the Export menu option.
Export to PDF Menu Option
In the following window, choose a location in your computer to store the PDF file and give a name to it. Tip: use your invoice number in the file name. Save all your invoices with the Invoice Number in the PDF file name in the folder. Thus, you will be able to easily identify a specific PDF if needed in the future.
We will be coming up with another free template to handle hourly rentals.
All the formatting options are available to you. Just select the cells you need to modify the format and use Excel’s default formatting options (in the Home ribbon) to change fonts, colors, appearance, number format, or alignment.
Excel Formatting Options to customize the invoice
If you change the font size or font, you can adjust the column widths and/or row heights to ensure that the print view is good.
When you have a lot of products, it might become challenging to choose from the drop-down menu in the Invoice worksheet, especially if the product IDs/Names are not sorted. By default, the order in which you entered the products in the Products table will be used as it is in the drop-down menu. That means you could sort the products in the Products table and this would automatically give you sorted products in the drop-down menu. This should help you in the easier selection of products in the invoice.
Choose the cells in the Products table, Right Click –> Sort.
The template comes with no currency formatting by default as I would like the template to be useful in all countries. It’s easy to apply your currency.
In the Invoice sheet, press Ctrl+G. This opens a new dialog box.
Choose CURR_INV or CURR_RCPT and click OK. This will select all the cells that need to be formatted as currency. Press Ctrl+1.