Billing Invoice Template in Excel Office 365!! – {Simple Steps}
Tags: billinginvoicetempla, exceltemplates
Published: 2020-12-30 15:52:43

---
title: Billing Invoice Template in Excel Office 365!! – {Simple Steps}
published: true
date: 2020-12-25 12:35:57 UTC
tags: BillingInvoiceTempla,ExcelTemplates
canonical_url: https://geekexcel.com/billing-invoice-template-in-excel-office-365-simple-steps/
---

Billing Invoice Template in Excel is used to calculate line item total and payment details. Excel has a built-in billing invoice template. You can use it for free. In this article, we are going to the usage of **Billing Invoice Template in Excel Office 365** with its description and example.
## Billing Invoice Template – Description:

![Sample Billing Invoice](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/EXCEL_ocwNDsGG7U.png)<figcaption id="caption-attachment-20418">Sample Billing Invoice</figcaption>

### Net Total:

- It will calculate the total amount automatically in Cell E25.

**=[SUM](https://geekexcel.com/sum-function/)(InvoiceDetails[LINE TOTAL])-E24**

### Tax:

- The default tax rate is 0.
- You can change the value of the tax rate in **Cell E26**.

### USD Total:

- The total amount will calculate automatically in **Cell E27**.
- All company information is located in the worksheet “ **Company Setup** “, so you need to edit it.
- You can see that all fields of payment details will use one formula. Let’s see them one by one.

![Company Setup](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/EXCEL_WwiSkhqo3A.png)<figcaption id="caption-attachment-20419">Company Setup</figcaption>

### Name of Bank:

**=CompanySetup\_BankName**

### **CompanySetup\_BankName:**

- It is a defined name, and it refers to the below given Excel formula.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(CompanySetup[VALUE],[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(“Name of Bank”,CompanySetup[INVOICING COMPANY DETAILS],0))**

### CompanySetup[VALUE]:

- It is the range in the Excel Worksheet called Company Setup and refers to **$C$3:$C$20.**

### CompanySetup[INVOICING COMPANY DETAILS]:

- This is a range in the Excel worksheet called “Company Setup” and refers to **$B$3:$B$20**.
- The below given formula will return the position of value “Name of Bank” in the range CompanySetup[INVOICING COMPANY DETAILS].

=**[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(“Name of Bank”, CompanySetup[INVOICING COMPANY DETAILS],0)**  

- This Excel formula can be reduced as given below, and it will return “Adventure Works” from the range **$C$3:$C$20**.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)**(**$C$3:$C$20, 14, 0)**  

## Use Free Billing Invoice Template:

- Excel provides free Billing Invoice Template, you can make use of it.
- To get this template, you need to **click** the **File Tab** and **select** the **New** option.

![Select the New Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/EXCEL_QoedWQsx1P.png)<figcaption id="caption-attachment-20416">Select the New Option</figcaption>

- Then you have to **enter Billing invoice** in the **search**  box and click the result.

![Search for Billing Invoice](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/EXCEL_AHnK7QAjNA.png)<figcaption id="caption-attachment-20417">Search for Billing Invoice</figcaption>

- At last, you need to **click** the **Create** button to create a new workbook based on this template.

## Verdict:

In the above article, you can easily learn the usage of **Billing Invoice Template in Excel Office 365** with its description and example. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!