Asset Rental Invoice and Receipt – Free Excel Download

Posted on

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.

Features

  1. Create invoices for your asset rental business
  2. Customize invoice and receipt to your business need
  3. Automatically calculate totals and subtotals
  4. Handles tax rates at the order level
  5. Accommodates products that are not taxable
  6. Handles discounts at product and order levels
  7. Save time by storing customer and product data

Limitation

  • 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.

Requirements

  • Microsoft Excel for Windows (2010 and above)
  • Microsoft Excel for Mac (2011 and above)

Downloads


How to use the template

Initial Setup

  • Enter Business Information in Settings sheet
  • Enter Payment Methods in Settings sheet.

If you are new to Excel Tables, please read the article on how to use Excel Tables for data entry.

  • Enter Assets details in the Assets sheet

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.


Generate Invoice

The Invoice sheet explained below in detail

1.Invoice:  Enter the Invoice number in cell G5.

2. Date:  Enter the date of the invoice in cell G7.

3. Place your Business logo:  Right-click on the Your logo Here image and click on Change Picture. If you don’t need a logo, just select the logo image and press the delete key.

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.

You can choose to display either Amount Before Tax or Amount After Tax

Continue entering assets as many there are in the invoice. The maximum allowed is 20 in this template.


Get Receipt

To create a receipt, just choose Receipt (instead of invoice) on the top left.

 

Receipt for rental business
Receipt for rental business

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

2 options:

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.

  1. Keep the Invoice sheet on which the initial setup was done as the master sheet.
  2. Take a copy of the master sheet.
  3. Rename the copy with the invoice number.
  4. Edit the input fields along with the asset details.
  5. Print the invoice if needed. Export to PDF.
  6. 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


Support Articles

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.

You can choose to use a Product ID or Product Name or your own field as a key identifier of products.

If you choose Name, the drop-down list automatically will use Product Name instead of Product ID. Everything works smoothly.

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.

Changing Invoice Currency – Press Ctrl+G and select CURR

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.

2 thoughts on “Asset Rental Invoice and Receipt – Free Excel Download

  1. I like your effort because this whole process takes a lot of time. Storing all assets and customer details is also a big problem. You can solve all my problems. I appreciate it.

    1. Thank you for sharing your valuable feedback.

      If you could spare some of your valuable time, requesting to check our Rental Inventory and Sales Manager template at the below link, which is the premium version of the template and I believe you will like it as well.
      https://indzara.com/product/rental-inventory-sales-manager-excel-template/

      Best wishes.

Leave a Reply

Your email address will not be published. Required fields are marked *