Getting paid back fully and in time, starts with issuing clear and accurate invoices to your clients.
A helpful, free program that can help you streamline this invoice creation process is Microsoft Excel.
Now, you may be thinking: isn’t Excel used for complicated spreadsheets and graphs? Yes, but it’s only one of the many functions of the program.
Excel also comes with a gallery of customizable invoice templates you can use to generate different types of invoices for your small business accounting. The software also allows you to make your own invoice from scratch, in case templates aren’t what you prefer.
In this guide, we will show you exactly how to create an invoice in Excel, both from a template and from a blank sheet.
Read on to learn about:
Creating an invoice in Excel from a template is a pretty simple and straightforward process.
Templates usually come with premade instructions that guide you through what each section of the document needs to include. Also, the design can be easily personalized with your brand colors, logo, and preferred font.
Here’s the step-by-step guide on how to make an invoice from an Excel template:
After you’ve launched and opened Microsoft Excel on your PC, look for the File menu at the top left of the page. From there, click on New from Template to find the Excel Workbook Gallery.
In the gallery, use the search bar at the top right of the page to type the word “invoice”. A list of invoice templates should appear. Check out their preview, and scroll down the list until you’ve found the right template for your business.
To pick the template, either double-click on it or click on it once and press the Choose button at the bottom of the page.
Before you start editing and customizing the template, make sure it fits your needs and involves all of the appropriate elements of an invoice.
An invoice template should always have:
To learn more about all of the information you need to include in your invoice, head over to our guide on how to make an invoice.
After you’ve double-checked all of the sections, and added any missing pieces, it’s time to start personalizing the template.
Start by designing the template with your business colors, logo, and preferred font, by using the Home menu formatting features at the top of the page.
Then, add in the purchase details.
As you can see in the image below, the invoice template already has instructions on what information to include in each section.
Fill in the entire invoice with the corresponding details of the purchase you’re billing, and you’re done! You’ve created an invoice from an Excel template.
To save your finished invoice, click on File and then Save As.
A popup will appear, prompting you to name the invoice and to choose the type of format to save it in.
We recommend saving the invoice in PDF, to avoid any document compatibility issues and make sure the client receives an uneditable, and clear invoice.
After you’ve saved the document, it’s time to send it out and get paid!
There are three main ways to send out an invoice: physically by fax or in person, via email, or through invoicing software.
Read our guide on how to send an invoice, to learn the best way to send an invoice that saves your business time and money.
If you want to go the extra mile and manually make your own invoice template in Excel, follow this step-by-step guide:
To open a blank workbook on Excel, press on File and then New Workbook. Skip this step, if when you enter Excel, it automatically opens up a blank spreadsheet.
Removing gridlines gives you a cleaner sheet to work with, however, this step is optional.
You can keep the format as it is, or remove gridlines in the end once you’re done creating the invoice.
To do so, go to the Layout menu, and on the View section uncheck the Gridlines box.
The elements of an invoice header include:
Enter all of these details on the sheet, with the color, font, and font size you prefer, like the example below.
On the right side of the header, make three lines detailing the billing date, payment due date, and unique invoice number.
Client contact details include the client’s name, street address, city, and phone number. Preface this section with the words “invoice to” or just “to”, and then fill in all of the details.
An itemized list of services and products includes:
The easiest way to create this list is by adding in a table, with a column and row for every element.
Do this by going to Tables, and clicking on New.
Then, you can personalize the table colors with the color scheme you prefer, by using the Table Styles feature on the top left of the same Table menu.
After choosing the design, fill in the table with the appropriate details of the sale. By now, your invoice should be looking something like this:
Now, keep in mind that these elements are the standard components of a regular sales invoice. Extra details might need to be included in an invoice, depending on the type of industry, client, and products you’re selling.
If you want to simplify math calculations, you can insert a SUM function in your worksheet, which automatically adds up your totals.
For example, let’s say you want to find out the subtotal of the line totals shown in the image below.
All you have to do is submit the SUM formula on the formula builder, which is located right next to the fx symbol at the top of the page.
In our case, we want to find the sum of our line totals placed in between cell H20 to H23. So, the SUM formula would be: =SUM(H20:H23)
Repeat this process to automatically add up your tax and the ending total amount as well.
At the bottom of the invoice, include your payment terms with a short “thank you” note.
Save the completed invoice as a PDF file, by following the steps we previously explained.
Then send it out to your customer with the preferred method, and finally get paid!
Here is our selection of some of the free and downloadable invoice templates in Excel, you can use to create invoices for your small business accounting:
If your small business bills services by the hour, or from any other time-basis, this professional and clear service invoice template has everything you need. The document offers an itemized table of services with a column for the hours, rate, and amount you’re charging.
It also comes with a built-in SUM function that automatically calculates your subtotal, sales tax, and ending total.
This two-paged clean invoice template is suitable for businesses providing products to their clients, rather than services. What is special about this template is that it comes with a separate second sheet displaying the business contact information along with any other additional notes.
Do you want to stand out to your clients with a modern, but still professional template? Then this Microsoft sales invoice is the perfect choice for you.
The invoice information is displayed stylishly, with big bold borders and colorful lines, which you can customize according to your brand colors. The template still looks professional, though, with all of the sections well-organized and clear to see.
Similar to the time-based invoice, this Excel invoice template is made for businesses offering hourly services, such as consulting.
The template design is bright, with big, colorful headers that you can personalize depending on your preference. It includes both hourly charges and costs for fees, parts, and other equipment.
Where to find it: Vertex42
Does your small business ship products internationally? If so, you’ll need to issue a commercial invoice that covers extra shipping fees, commercial incoterms, type of packaging, the weight of product, country of origin, and so much more.
Consider this light blue Excel commercial invoice template as a solution. The document includes all of the appropriate shipment details, in a customizable and well-organized manner.
Where to find it: Invoice templates
Invoicing in Excel can take up a lot of unnecessary time.
From creating the document to printing it, recording it in accounts receivable, and then finally sending it to your clients, you’ll end up spending more time as a mailman rather than a business manager.
Luckily, there’s a solution to all of these worries.
In today’s digitized world you can automate your invoicing with cloud-based accounting software.
With integrated invoicing software like Deskera or with other accounting software, you can create and send invoices in just a few touches!
Deskera comes with over 100+ premade professional templates you can choose from, and tailor to your business brand with your preferred colors, font, business logo, and signature.
After customizing, all you have to do is fill in the left sidebar of the Deskera invoice generator with the necessary invoice details, and you’re done!
Send the invoice by pressing Share at the top right of the page, to download, print, or email the invoice to your client. You can also choose to export the invoice as a PDF, DOC, or XLS file.
Deskera’s invoicing features don’t end here.
On the Deskera Books platform, there is a Sell dashboard that allows you to get an overview of your issued invoices and their payment status.
From there, you can also request advance payments and deposits, set recurring invoices for repeated services, get notifications for payment due dates, and so much more.
Access the software anywhere, phone, tablet, or desktop by downloading the Deskera mobile app.
Still not convinced Deskera is the right choice for you? Well, you can check the program out yourself, with our completely free trial.
And that’s a wrap! We hope you enjoyed our guide to invoicing in Excel.
Here’s a recap of the main points we’ve covered:
Deskera featured posts
While businesses located in the US are imposed a retail sales tax, many other countries across the world are subject…
10 min read Feb 28, 2021People often confuse a purchase order with an invoice [https://www.deskera.com/blog/what-is-an-invoice/] and use the terms interchangeably.…
6 min read Feb 20, 2021While both an invoice [http://deskera.com/blog/what-is-an-invoice/] and a receipt are commercial documents, invoices are issued to request…
8 min read Jan 31, 2021Hey 👋! Discover the best! Now!
Get Accounting, CRM & Payroll in one integrated package with Deskera All-in-One.
Hey 👋! Discover the best! Now!
Get Accounting, CRM & Payroll in one integrated package with Deskera All-in-One.