EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Invoice Template in Excel

Invoice Template in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated August 22, 2023

Invoice Template in Excel

Invoice Template in Excel (Table of Contents)
  • How to Create an Invoice in Excel?
  • Examples of Invoice Template in Excel

How to Create an Invoice in Excel?

It is very easy to create an Invoice in Excel. First, we must have a template and some important fields that usually are part of any regular invoice, such as Company Name, Order Date, Item, Quantity, and Delivery Address. Every field we choose has a definite position in Excel which we can put in any of the cells we want with the required font size and font type. Also include a table where we can enter the item name, quantity, and price it has. It is important to keep at least 3 to 4 lines for address along with a section for contact details.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Examples of Invoice Template in Excel

Let’s look at some examples of Invoice Templates in Excel and see how to create the Invoice Template in Excel.

Example #1 – How to Create Invoice in Excel using a Predefined Template

Step 1: Open Microsoft Excel in your Windows system by typing “excel” in the search box. A Microsoft Excel home page will open.

Invoice template in excel 1-1

Step 2: In the search box, search for inbuilt invoice templates by typing “invoice” and pressing Enter. You will see thousands of online invoice templates present in Excel. Make sure you are connected to the internet to search for those templates.

Invoice template in excel 1-2

Step 3: Select and click on a template appropriate and fulfilling your needs.

Invoice template in excel 1-3

Step 4: Once you select any template, Excel allows you to download the same and use it in Excel for further purposes. Click on Create Button to download and create the template in Excel.

Invoice template in excel 1-4

Step 5: Once you click Create button, excel downloads the template for you and opens it. You’ll see a template in Excel, like the screenshot below.

Invoice template in excel 1-5

Step 6: You can edit and customize this invoice template as needed. Add the company name in this template, then add the amount associated with the goods.

Invoice template in excel 1-6

Step 7: You can add them as per the service provided and also should have a look at the final total amount. Most Excel invoice templates use formulas that keep your Final Total updated.

Invoice template in excel 1-7

Step 8: Once you are done with the invoice update, you need to save this template. Click on the File menu from the Excel ribbon at the uppermost corner. Click on Save As. Enter a name suitable for your invoice and click on the Save button. You can save your invoice at any location in your system and send it. This step is essential because if you fail to save the updated invoice, you will lose all the updated data from your invoice.

Invoice template in excel 1-8

Example #2 – How to Create an Invoice in Excel from Scratch

Step 1: Open an Excel file by typing “excel” in the search box and double click on it. Double click on Blank Workbook; it will open up a blank Excel workbook.

Blank Workbook 1

Step 2: You should add the following details under each cell per the table below.

  • Company Name: Your company’s name for which we should make payments.
  • Company Address: The address of the company, along with contact details.
  • Date: The date the invoice is being allocated to your customer.
  • Customer Details: Company name and address details of the same.
  • Product Description and Amount: It allows you to add the product description you are selling and the amount to be added under each category.

With these details, there should be additional details such as Subtotal, Final Total, Tax amount, Thank You note, etc.

Step 3: In cell A1, add the Company Name with alignment on the left with font size 16. Make it bold and merge cells A1 and B1.

Blank Workbook 2

Step 4: Add the company address and postal details on cell A2:A4.

Blank Workbook 3

Step 5: Add the date the invoice is being issued to the customer under cell A5.

Blank Workbook 4

Step 6: From cell A7:A10, add the customer details, including name, address, and contact details.

Blank Workbook 5

Step 7: From cells A12: B18, add the product description column and the Amount associated with each product category. In column A, the Product Description gets added, and column B adds the Amount.

Blank Workbook 6

Step 8: It’s good to have these details formatted in a table. Select a block of cells from A12 to B18 and click on the “Cell Styles” menu (present under the Home tab).

cell styles

You can change the style of these blocks of cells. I prefer “Light Yellow, 60% – Accent 4 Style”.

cell styles 1

Step 9: Add a thick border to this range of cells through the Border Menu present under the Home tab. Your invoice should look like the one below.

Product Description

Step 10: In cell A19, add Sub Total fields associated with the subtotals being captured and calculated under cell B19. It’s nothing but the total Amount column.

Sub Total

Step 11: Similarly, add the Tax Rate and Final Total columns on cells A20 and A21, respectively. They will be reflecting the amounts in cells B20 and B21, respectively.

Final Total

Please note that the Final Total is formulated to add up the Sub Total and the Tax Amount, which gets calculated using the Tax Rate on Sub Total amount.

Step 12: Add a Thank You note in cell A22 to complete your invoice.

Final total 1

Step 13: Save this file, and you are through.

save file

This is it from this article. Let’s wrap things up with some things to be remembered.

Things to Remember About Invoice Template in Excel

  • Most of the time, using the default invoice template provided in Excel in-built is good. Make sure you have an active internet connection to download the same.
  • It’s always recommended to have your invoice formatted in case you are generating it on your own through scrap.

Recommended Articles

This is a guide to Invoice Templates in Excel. Here we discuss how to create an invoice template in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles to learn more –

  1. Create an Excel Template
  2. Excel Business Plan Template
  3. Estimate Template in Excel
  4. Blank Invoice Excel Template
All in One Excel VBA Bundle
500+ Hours of HD Videos
15 Learning Paths
120+ Courses
Verifiable Certificate of Completion
Lifetime Access
Financial Analyst Masters Training Program
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Data Science Bundle
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
All in One Software Development Bundle
5000+ Hours of HD Videos
149 Learning Paths
1050+ Courses
Verifiable Certificate of Completion
Lifetime Access
Primary Sidebar
All in One Excel VBA Bundle500+ Hours of HD Videos | 15 Learning Paths | 120+ Courses | Verifiable Certificate of Completion | Lifetime Access
Financial Analyst Masters Training Program2000+ Hours of HD Videos | 43 Learning Paths | 550+ Courses | Verifiable Certificate of Completion | Lifetime Access
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more