How to create and print invoice for rental orders in Excel?
Creating invoices for rental orders using the Rental Business Manager is very easy. In this article, we will see how we can create them on-demand and then print or export to PDF.
This article is part of a series of support articles of Rental Business Manager Excel template. For more information on the product, please visit Rental Business Manager Excel template.
We had discussed in the earlier article on how we can customize the invoice. I am assuming that we have already done that, for the purposes of this article.
Creating and Viewing the Invoice
To view the invoice, let’s go to Invoice sheet and enter the order number at the top.
If we enter an invalid order number, we will see this warning message.
Let’s enter 1 as Order Number. The invoice will now auto-populate. It’s that simple. You can generate an invoice whenever needed. The data comes primarily from Order Details sheet and some information from Customers, Orders and Assets sheets.
Printing the Invoice
Press Ctrl+P to open the print preview dialog box. Preview the sheet and then click print.
By default, one page is printed that can handle up to 25 lines of the order. If the order has more than 25 lines, please change the number of pages in the Print Preview dialog box so that 2 pages can be printed. The template can handle up to 65 line items.
Exporting the Invoice as PDF
To export as PDF, Click File – Export as PDF.
Choose a place to store the file, name it as desired (recommend adding the order number and/or invoice number) and click Publish.
Then, we can email the file to our customer.
In the next article, we will learn more about finance management and accounting in Rental Business Manager.
Leave a Reply