Invoice Builder (Basic) – Free Excel Template

Posted on
This is a simple template that helps in creating invoices for businesses. If you are running a small business, you will have the need to create invoices. However, you don’t need a sophisticated and expensive software. If your requirements are specific and simple, this template may help. 

Update (July 2016):  A new and improved version is available now. Please visit this page to download the latest free sales invoice template. 


Features

  • Creates a basic invoice instantly
  • Calculates total amounts automatically
  • Enter product information once and avoid repeated data entry
  • Enter customer information once and avoid repeated data entry
  • Allows taxes to be added to the invoice
  • Can use for products and/or services
  • Up to 20 items in an invoice
  • Print or save as PDF and e-mail
  • Can be used to create multiple invoices and store them
  • Use with any currency

 


 

Invoice Builder Excel Template - Invoice
Invoice Builder Excel Template – Invoice

VIDEO

 

 

 


Preparation

    • Complete the Your Information section in the Settings worksheet
Invoice Builder Excel Template
Invoice Builder Excel Template
  • Enter information about Products in the Settings worksheet.
Invoice Builder Excel Template - Products
Invoice Builder Excel Template – Products

Delete the sample data in the template by selecting all the rows, Right Click and Choose Delete Table Rows.

Invoice Builder Excel Template
Invoice Builder Excel Template
    • Enter information about Customers in the Settings worksheet. Delete the sample data in the template.
Invoice Builder Excel Template - Customers
Invoice Builder Excel Template – Customers
  • Change Logo in the Invoice worksheet: Click on the picture and right click on your mouse. Select Change Picture. You can choose any of the images in your computer to use as logo. You can also resize the image however you like.  
  • Invoice Builder Excel Template - Logo
    Invoice Builder Excel Template – Logo
    • You can also just click Delete if you don’t need a logo
 
Steps to create an invoice (Invoice Worksheet)
  1. Delete the sample invoice items (Product, Qty) in the template before you begin. 
  2. Enter Date 
  3. Enter Invoice #
  4. Choose Customer from drop down menu
  5. Choose Product Name
  6. Enter Quantity
  7. Repeat steps 4 and 5 for each product
  8. Enter Other Charges if needed
  9. Enter Comments if needed
  10. Review the invoice
  11. Print or Save as PDF

Invoice Builder Excel Template - Invoice Number
Invoice Builder Excel Template – Invoice Number

Invoice Builder Excel Template - Invoice
Invoice Builder Excel Template – Invoice

Invoice Builder Excel Template - Invoice
Invoice Builder Excel Template – Invoice

Tips:
  • Changing currency
    • In the Settings worksheet, choose the cells in the Unit Price column and change Number format (Currency). 
    • Invoice Builder Excel Template - Invoice
      Invoice Builder Excel Template – Invoice


      In the Invoice worksheet, choose the cells in the Unit Price and the Amount column and change Number format (Currency). Also, change the Number format for the Total, Tax, Other Charges and Grand Total. 

  • Using the Template for services 
    • You can also use this template for services that you may charge hourly. In such cases, you will enter the number of hours in the Qty column in the invoice. In the Products table, you will enter the Service name and provide the hourly rate as the Unit Price. Please see the image below for how I have entered labour cost as a Product.
Invoice Builder Excel Template - Invoice
Invoice Builder Excel Template – Invoice
  • Using the Template for Projects
    • You can also use this template if you don’t sell products but work on consulting projects. You can enter your Project ID in the Product ID field and enter Project description in the Product Name field. You can enter the project’s cost in the Unit Price field. If the Product Name is long, it may appear incomplete in the Invoice sheet. Please adjust the row heights to make sure you can see the entire text.  
  • Storing invoices in the Excel Workbook
    • After you finish the Preparation steps (outlined above), make a copy of the invoice worksheet. You can create any number of copies of the worksheet. When you are ready to create an invoice, rename that specific worksheet with a unique name. I recommend using invoice numbers if you use invoice numbers. By this method, you will be creating invoices instantly from this template, and also storing copies of each invoice all in one Excel workbook. 
    • Invoice Builder Excel Template - Invoice
      Invoice Builder Excel Template – Invoice
    • Invoice Builder Excel Template - Invoice
      Invoice Builder Excel Template – Invoice
  • How to sort data in Product list
    • 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 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 easier selection of products in the invoice. 
    • Choose the cells in the Products table, Right Click –> Sort.

      Invoice Builder Excel Template - Invoice
      Invoice Builder Excel Template – Invoice
    • You can also sort Customers using the same method in the Customers table.
  • How to Delete data in invoice and start over
    • Delete rows in Products Table. Use the method explained above in this post. 
    • Delete rows in Customers Table. Use the method explained above in this post. 
    • Delete Date and Invoice # information in the invoice.
    • Delete Product and Qty information in the invoice. 
    • Delete any Comments entered in the Comments box.

 

I hope you find this basic Invoice Builder template useful. I look forward to your feedback. I would also love to hear how you use this template, if you find this useful.

39 thoughts on “Invoice Builder (Basic) – Free Excel Template

  1. you contribution is very useful and very intellectual!

    1. Thank you very much.

  2. I want to use ur software on my accounting firm. what I do for that?????

    Best regards

    1. You can download the template in the post above (or other templates on this site) and use it. You would need Microsoft Excel for Windows (preferably 2010 or 2013 versions).

  3. Dear Sir, I appreciate this great invoice generator but i have a small problem in my country we use Cyrillic’s sow its kind a problem for me not to be able to remove protection on the invoice its self ( to change it in to Cyrillic ). Please advise.

    Regards,
    Small business owner

    1. P.S. In order to use the invoice Builder i need to be able to translate it in Macedonian. For example: INVOICE ( English ) – ФАКТУРА ( Macedonian )

    2. Thank you. You can unlock the sheets using keyword indzara and make changes as necessary.

  4. Great blog! I’m so glad to find your page.I really appreciate the concept you have posted here. Thanks for sharing !

  5. Hi, Really great work, but can you please combine you inventory sales manager and invoice files so it can auto adjust the stock and also allow a line item to indicate tax registration number….Thanks

  6. Its so simple that we dont have to think about brain teasing programming requirement. One gr8 pleasure is that you are allowing to customise the template as per user requirement, with no any royalty, terms conditions and not the least as acknowledgement.

  7. veary nice dear i am realy apperciate

    1. Thank you very much. I am glad that it’s useful.

  8. Thank you very much….very useful!!! Just what we needed

    1. You are welcome. I am glad that it is helpful.
      Thanks for taking the time to post a comment.

  9. i need some changing in this template please add the sales register in this template

    1. I will work on an improved template soon. I will post it when I have it. Thanks.

  10. loving your work!! great job!! Much Thanks!!

    1. Very glad to hear. Thank you. Best wishes.

Leave a Reply

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