The Price List and Invoice (up to 100 items) allows you to set the following in the price list:

• Company Name
• Price List: S/N, Item Code, Description, Unit Price, GST, Total Price [Up to 100 items]
• Customer details (Name, address, contact, payment method) and quantity of items to be ordered – these are filled in by the customer

With these inputs, it will automatically generate the invoice:

• Items ordered (including S/N, Item Code, Description, Unit Price, GST, Total Price) and customer details automatically generated
• Company Name, address, other details to be filled in by you

This template is most useful for small businesses that are starting out and use Excel-based order forms in the beginning. The Price List and Invoice (up to 100 items) template allows you to enter your price list, which you can use as an order form for your customer to enter in the order quantities. The invoice is then automatically generated based on what the customer entered.

Check out the pictures to see how the price list and invoice looks like!

NOTE: This Excel template is NOT protected and locked, so it is fully editable, including the formulas. It works for Excel 2003 or later versions of Excel. No macros are used.