Get Access to World’s largest Template Library & Tools

How to Create an Invoice on Excel

Microsoft Excel is a marvelous work management tool that can handle many of the financial calculations you make in running your business. Among many other business functions, Excel can also help you in making invoice for your products; i.e., prepare an itemized list of products sold or services offered. You can create an invoice template in Excel by downloading a pre-made invoice template or creating an invoice sample from a blank workbook.

Start-up

Click the Start button on the Windows taskbar. You can see it on the bottom, left-hand corner of your computer’s desktop or “home” screen)

start upThe first step of course is to open the file. On the desktop screen, click on the Start Menu, go to Microsoft Office, click on Microsoft Office Excel and open the application. If you have the Excel sheet already saved in your system already, go to its location and open it.

open microsoft office excel You will now have a blank worksheet of MS Excel open in front of you. Almost all the commands and functions are on top; categorized in tabs, and further organized as groups.

blank worksheet of ms excel

Option1: Downloading a Pre-Made Template

Locating a Template

Click on the tab File, and from the menu underneath it, click New. You will see many a few templates categorized under Available Templates and many more under Microsoft Office Templates. In the latter category, templates for Invoices can be seen.

locating a template

Selecting the Desired Template

There are many ready-to-use templates available for the user under Available Templates in Invoices. You do not have to open each and every sample before selection; rather if you just click on a template, a preview appears on the right side the Available Template window. This will give you an idea of how the template will look like. All these templates are complete in term of layout and formatting with formulae inserted. And all these templates are completely customizable, i.e. you can change any aspect of the template according to your requirement.

selecting the desired template

Download the Template

After you have finalized the selection, you can easily download the template. The Download button is given right under the preview. Although the templates are customizable, yet it is advised to gather the required information in choosing the best suitable template for your invoice.

download the template

Option 2: Creating Your Own Invoice

Invoice Size

On launching MS Excel, a blank worksheet is shown. So, technically our first step in creating an Microsoft Invoice starts after that. We will first decide on a paper size. The option is available in Page Setup group in Page Layout tab. A dotted line appears to show the height and width of the paper or printable region. These are the paper boundaries and the invoice template word should be created within these dotted lines.

invoice sizeNote: You can also confirm your boundaries by viewing Page Layout in Workbook Views group in View tab.

page layout in workbook views group

Invoice Heading Labels

Typically, any invoice header consists of following parts:

Note: There is no position defined for these entries. These can be placed according to your own requirements and presentation needs.

invoice heading labels

Sender and Recipient Contact Information

This is the most important information and should come right after the heading. The sender’s information precedes the client’s information.

sender and recipient contact information

Billing Information

Now, it’s time to actually prepare the ‘body’ of the invoice. For the basic invoice, we will require the following columns: Quantity, Description, Unit Price and Total Price. The Total Amount to be added in the end.

billing information

Additional Tax

If there are taxes applicable on the Total Amount, you’d have to type it under ‘Applicable Tax’. This is will be go in just below the ‘Total Amount’ and ‘Total Payable’. Next, proceed with specifying the Tax percentage as well. The formula to input for this calculation is as Total Payable =E35+(E35*E36)

additional tax

Terms of Payment and Other Notes

To finish off, don’t forget to include the terms and conditions of payment, which is generally inserted just above the billing invoice details. The common vocabulary used to specify payment terms are as follows: “Due on receipt,” “Due within 14 days,” “Due within 30 days,” or “Due within 60 days.”

Further notes or information related to invoice or payment can be included at the bottom of the invoice. This could include a memo for accepted methods of payment, or just a thank-you note.

terms of payment and other notes

Save Your Invoice

Save your invoice with a namerelevant to the client and/or your product or service. This will help you in remembering what the invoice was made for. Some examples could be your company name, your Product or service nameor clients name and the type and number of invoice.

More in Tutorials

How to Create a Professional Resume Using Microsoft Word - TutorialHow to Write a Cover Letter - Tutorial
How to Write a Professional Resignation Letter - TutorialHow to Make/Create a Thank You Letter for a Scholarship [Templates + Examples] 2023
How to Create a Lesson Plan in Word - TutorialHow To Make/Create a Business Letter [Templates + Examples] 2023
How to Create an Affirmative Action Plan - TutorialHow to Create a Gantt Chart in Excel Easily - Tutorial
How to Create a Resume on a Mac - TutorialHow to Create an Action Plan - Tutorial
How to Create a Lesson Plan for Elementary School - TutorialHow to Create a Family Tree Chart in Excel, Word, Numbers, Pages, PDF - Tutorial
How to Create a Pie Chart in Microsoft Excel - TutorialHow To Make/Create a Receipt [Templates + Examples] 2023
How to Create a Project Schedule in Excel - TutorialHow to Make a Certificate in Microsoft Word - Tutorial
How to Create a Calendar in Word - TutorialHow to Create a Birth Certificate using Word - Tutorial
How to Create a Calendar in Excel - TutorialHow to Make a Gift Certificate on Microsoft Word - Tutorial
How to Create a Family Tree in Microsoft Word - TutorialHow to Make/Create a Timeline in Microsoft Word [Templates + Examples] 2023
How to Create a TimeSheet in Excel - Tutorial5+ How to Make an Inventory Using Excel - Tutorial
How to Create an Invoice on ExcelHow to Create Receipts in Excel
How to Create a Family Tree in PowerPoint - TutorialHow to Use Bootstrap Tooltip
How to Use Glyphicons in Bootstrap 3How to Create Custom PHP Contact Forms
How to Use PHPBrew & VirtPHP - TutorialUnderstanding Bootstrap Grid - Column Wrapping
How to Create a Basic Timeline Template in Excel 2023 - Tutorial10 Top YouTube Channels for Game Development Tutorials in 2023!
What is a CSS Preprocessor and Why You Should Use IT?25+ Great Examples of InDesign In Use - Tutorials
Top Ui Photoshop Tutorials for Freshers5 Tips to Make Your Website Invincible From Hackers!
20 Easy Illustrator Tutorials For Beginners!19+ Illustrator Tutorials For Creating Isometric Illustrations!
20+ Useful Responsive Web Design TutorialsHow to Make an App - Free Online Tutorials
Html5 Tutorial for Beginners - Techniques and Examples
bottom banner