Simple Invoice Template in MS Excel ~ with Example!!
Tags: excel, exceltemplates, simpleinvoicetemplat
Published: 2021-01-06 14:51:08

---
title: Simple Invoice Template in MS Excel ~ with Example!!
published: true
date: 2020-12-25 12:44:26 UTC
tags: Excel,ExcelTemplates,Simpleinvoicetemplat
canonical_url: https://geekexcel.com/simple-invoice-template-excel/
---

An  **invoice template** is a **layout** that makes it simple to replace our details with the default, stock information. By providing the necessary fields in the invoice, you can easily calculate line item totals, sales tax, Deposit Received, and deduct discount offered. Here, we will show the **simple invoice template in Excel**. You can easily customize, use, and download it for free.

Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Simple Invoice Templates – Description:

Here is a sample of the simple invoice template.

![Simple invoice template](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Simple-invoice.png)<figcaption id="caption-attachment-20354">Simple invoice template</figcaption>

### Invoice Subtotal:

- This invoice template will calculate the [subtotal](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/) amount automatically.
- And it uses the [**SUM**](https://geekexcel.com/sum-function/) function in the cell by using the below formula.

**=[SUM](https://geekexcel.com/sum-function/)(SimpleInvoice[Price])**  

### Sales Tax:

- The sales tax will help to convert the value into [percentage format](https://geekexcel.com/simple-shortcut-keys-to-apply-percentage-format-in-ms-excel-365/).
- You can change the value in **cell G24**.
- If you do not want to calculate the Sales Tax, just leave it blank.

### Deposit Received:

- If your customer pays the deposit, then you need to enter the value in the Deposit received column.
- This is available in **cell G25** from the given template.

### Total:

- After entering all the above details in your sheet it will automatically calculate the total and returns it to the **Cell G26**.
- The total will be calculated by using the below formula.

=**(G21+G23+G24)-G25**

- From the total, the **cell G21, G23, and G25** are represented by **invoice subtotal** , **sales tax** , and **deposit received**.

## Download Link:

With the free Excel invoice template from this article, you can easily create and send invoices in a [minute](https://geekexcel.com/how-to-use-minute-function-in-excel-365/). Just click the below download button to get the simple invoice template.

[Download Simple Invoice Template](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Simple-invoice-template2-GeekExcel.zip)

**Note:**  The Simple invoice template is given in Zip File format. After downloading the template, you need to extract it.

## Bottom-Up:

In this chapter, you can easily understand how to use the **simple invoice template in Excel**. I hope it helps you. If you have any **doubts** regarding this topic or any other **Excel VBA** related topic, ask in the comments section below. Thank you ![🙏](https://s.w.org/images/core/emoji/13.0.1/72x72/1f64f.png)!!

### Read Also:

- **[Excel VBA Loops Statements in Office 365 ~ With Examples!!](https://geekexcel.com/excel-vba-loops-statements-in-office-365-with-examples/)**
- **[How to Save the Current Workbook in 97-2003 Format in Excel!!](https://geekexcel.com/save-current-workbook-97-2003-format/)**