Invoice Template with Finance Charge (Gray) in Excel Office 365!!
Tags: exceltemplates, invoicetemplatewithf
Published: 2021-01-03 16:16:17

---
title: Invoice Template with Finance Charge (Gray) in Excel Office 365!!
published: true
date: 2020-12-30 16:27:20 UTC
tags: ExcelTemplates,InvoicetemplatewithF
canonical_url: https://geekexcel.com/invoice-template-with-finance-charge-gray-in-excel-office-365/
---

The invoice template with finance charge (gray) is used to calculate the line item total. You can enter the description, quantity, and amount. When charging interest on unpaid customer account balances, you can use this invoice template with a finance charge to create a bill for the interest. In this guide, we will show you the steps to use the **invoice template with Finance Charge (Gray) in Excel Office 365**.

## Invoice Template – Description:

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

### Total Due:

- It will calculate the total amount in **Cell E25. **
- To calculate the total amount, use the below-given formula.

**=[SUBTOTAL](https://geekexcel.com/excel-subtotal-function-in-office-365-with-examples/)(109,[TOTAL])**  

- **109** – This number will call the **[SUM Function](https://geekexcel.com/sum-function/).**
- You can fill the company information in the range **B8:B12.**
- In **cell E3,** you can enter your invoice number.

To get this template in Excel for free by using the below steps.

- You need to [open the Excel Workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) and click **File Tab-> New** option.
- Then you need to **enter “invoice with finance charge (gray)”** in the search box.
- You can select the template as shown in the below screenshot.

![Click New option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/1-31.png)<figcaption id="caption-attachment-20515">Click New option</figcaption>

- Now, you need to **click** the **Create** button to create an Excel Finance Invoice Template in a new workbook.

![Click Create option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/2-21.png)<figcaption id="caption-attachment-20516">Click Create option</figcaption>

## Download the Template:

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

[Download Finance Invoice Template](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Invoice-with-finance-charge-gray1.zip)

## Bottom-Line:

In this guide, you can easily learn the steps to customize and use the **invoice template with Finance Charge (Gray) in Excel Office 365**. Kindly, drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Related Articles:

- [Service Invoice Template in Excel Office 365](https://geekexcel.com/service-invoice-template-in-excel-office-365-with-example/)
- [Invoice Template that Calculates Total in Excel 365](https://geekexcel.com/invoice-template-that-calculates-total-in-excel-office-365/)
- [Billing Invoice Template in Excel Office 365](https://geekexcel.com/billing-invoice-template-in-excel-office-365-simple-steps/)