Service Invoice Template in Excel Office 365 – {with Example}
Tags: exceltemplates, serviceinvoicetempla
Published: 2021-01-06 14:51:22

---
title: Service Invoice Template in Excel Office 365 – {with Example}
published: true
date: 2020-12-25 12:46:24 UTC
tags: ExcelTemplates,ServiceInvoiceTempla
canonical_url: https://geekexcel.com/service-invoice-template-in-excel-office-365-with-example/
---

 **Service Invoice Template** is used to calculate line item totals, sales tax. It allows you to give input like the Salesperson’s name, job description, payment details, and the due date for this invoice. You can easily customize this template as per your need. We also provide a free download of this template for your use. Let’s see how to use the **Service Invoice Template in Excel Office 365**.
## Service Invoice Template – Description:

![Example Template](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-80.png)<figcaption id="caption-attachment-20350">Example Template</figcaption>

### Subtotal:

- This template will calculate all line total amount automatically in **Cell E26** , and it uses the [SUM Function](https://geekexcel.com/sum-function/) in this [Excel cell](https://geekexcel.com/excel-cells-options/).
- Refer to the below formula.

**=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([SUM](https://geekexcel.com/sum-function/)(E16:E25)>0,SUM(E16:E25),””), “”)**

### Sales Tax:

- The default tax rate is **9.50%** in this invoice template.
- You can change the value of the tax rate in **cell D27**.
- If you don’t want to use the tax rate, simply leave it.

### Salesperson:

- You need to **enter** the **salesperson’s name** in **cell B13**.

### Job:

- You can enter the job description in **cell C13**.

### Payment Terms:

- Kindly, enter payment terms in **cell D13**.

### Total:

- The total amount will be calculated automatically in **cell E28** by using the below formula.

**=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([SUM](https://geekexcel.com/sum-function/)(Invoice[[#Totals],[Line Total]])>0,SUM(Invoice[[#Totals],[Line Total]],E27),””), “”)**  

- You can give your company information like logo, company name, [address](https://geekexcel.com/how-to-use-address-function-in-microsoft-excel-365/), phone number, and so on.
- Then you need to enter the invoice number, customer ID, and company information of your customer.

## Download the Template:

Just click the below download button to get the service invoice template in Zip File format. After downloading, you need to extract it.

[Download Service Invoice Template](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Service-Invoice-Template-Geek-Excel.zip)

## Wrap-Up:

In this short article, you can easily learn what is **Service Invoice Template** and how to use it in Excel Office 365. If this article is useful to you, then leave your **feedback** in the below comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!