Automated Invoice Sample In Excel

Excel Invoice Template

With the automated invoice template, invoice creation process is carried out faster.
Customer information on the invoice is brought from the Company sheet with a searchable data validation list and VLOOKUP formula.
The product name, price, discount rate info to be entered in the invoice is brought from the Products sheet with a searchable data validation list and VLOOKUP formula.

For example ; the formula for cell C17 is:
=IF(ISERROR(VLOOKUP(A17,Products,2,FALSE)),"",VLOOKUP(A17,Products,2,FALSE))

The “Products” expression seen in the formula indicates Products name that we created earlier. ↓

Transactions such as product price, discount rate, grand total on the invoice are performed by formulas. ↓ 

Using “Save Invoice” button ,invoices can be saved on the selected sheet in the workbook if desired. ↓

Data can be searched with the userform in the saved invoices. Results are listed on the listbox. If clicking on the search results, the worksheet containing the result and the cell address are displayed. ↓