Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Create invoice in Excel – Excelchat

An invoice is a bill or statement of charges that includes a list of goods or services and the corresponding amount.  It is issued to a client prior to payment and keeps a record of the sale. This article will guide us on how to create an invoice by using a pre-set template or by making it manually in Excel.  

Figure 1.  Final result:  How to create an invoice

Make invoice using a template

There are several free invoice templates from the database that we can readily use.  These templates are very useful especially when we are in a rush.  The templates contain the relevant information and are filled with the necessary formulas.  All we need to do is download, edit and save. Here are the steps:

  • Click File > New
  • In the search box, enter “invoice”
  • The results will display some invoice templates.  To preview an invoice, click on it.

Figure 2.  Invoice templates search results

  • When we have decided on which template to use, click Create to download it.

Figure 3.  Invoice Template Preview

Excel will open the template on a new workbook, with the same file name as the template.

Figure 4.  Sample Invoice

We can now start editing the invoice by entering the pertinent information such as company name, address and contact details, as well as the list of items and corresponding quantity, unit price and tax rates.  

Figure 5.  Output: Make invoice using a template

Click File > Save As or press Ctrl + S to save the invoice.

Create invoice manually

We can also opt to create an invoice manually.  Although this method will improve our skills in editing and formatting, it will certainly take time because we will be making it from scratch.  

These are the parts of an invoice:

  • Heading – contains the date, invoice number, company name, address and contact details
  • Recipient Details – client’s company name, address and contact details
  • Billing Information  – items and description, quantity, unit price and total price
    • The total price can be calculated by multiplying the quantity and the unit price
  • Total Bill – the sum of the total price per item and can be calculated using the SUM function
  • Payment Terms – contains the date or period for which the bill or charge is due (example: “Due within 30 days” or “Due upon receipt”)

Below is an example of an invoice created manually in Excel.

Figure 6.  Output: Create invoice manually

How to save an invoice template

  • In order to save the invoice template, we press Ctrl + S.  

Figure 7.  Save As dialog box

  • In the Save As dialog box, enter “Invoice1” in the File name text box
  • Click the arrow in Save as type and select Excel Template (*.xltx)

Figure 8.  Saving as Excel Template (*.xltx)

  • When we choose the file type “Excel template”, the file location is automatically changed to the Custom Office Template folder.  We can change the destination folder by navigating the dialog box and choosing our preferred location.

Figure 9.  Choosing the location

  • Click Save

We have successfully created an invoice.  We can now use it for future transactions or send to clients as record for products or services rendered.

Figure 10.  Output: Saving an invoice template

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc