Invoice template with finance charge (gray) In MS Excel

This invoice template with finance charge (gray) for excel will calculate line item total automatically, you need to enter descriptions, quantity and amount. And when charging interest on unpaid customer account balances, use this invoice template with finance charge to bill for the interest.

It is very easy to customize and use. And also is a very simple invoice finance template for your finance business, and you can download it freely to use it in your business.

Invoice template with finance charge gray1

Invoice Template Description

TOTAL DUE: It will calculate all items Total amount automatically in Cell E25, and it call excel formula in this excel cell formula:

=SUBTOTAL(109,[TOTAL])

109 – It means that the subtotal function will call Excel SUM Function

You need to enter into your company information in the bottom of the invoice template. Such like: company logo, company name, address, phone…

You still need to enter your invoice number in Cell E3 and the company information of your customer in range B8:B12.

How to get this free invoice template with finance charge in MS Excel?

Click “File” Tab ->”New”, then input “Invoice with finance charge (gray)”to search online template in the search box. Click it.

Invoice template with finance charge gray2

Then click “create” button to create a new workbook based on this invoice template.

Or

You can click the below download button to get this simple invoice template for free.

[pdownload]Download[/pdownload]

 

Invoice template that calculates total In MS Excel

This invoice template for excel will calculate line item Amount, sales tax, and Less Deposit Received to get invoice Total value. And it is very easy to customize and use. And also is a very simple invoice template for your small business, and you can download it freely to use it in your business.

 Invoice template that calculates total In MS Excel1

Service Invoice Template Description

Total items:  it will count the number of cells that contain numbers in Range F7:F31, it will call one excel formula as below:

="Total items: "&SUBTOTAL(103,[Description])

103 – It means that the subtotal function will call excel COUNT Function

 Subtotal: It will calculate all items Total amount automatically in Cell I32, and it call excel formula in this excel cell formula:

=SUBTOTAL(109,[Amount])

109 – It means that the subtotal function will call Excel SUM Function

Sales Tax: the default TaxRate is 5.0% in this invoice template, you can change the value of TaxRate in the Cell F34.  If you do not want to calculate the Sales Tax, just leave “TaxRate” as blank

TOTAL:  The Total Amount will be calculated automatically in Cell E28 using excel Formula:

=(tblInvoice[[#Totals],[Amount]]+SalesTax)-Deposit

tblInvoice- it’s a defined name of a range of cell and refers to “=’Simple Invoice’!$E$7:$i$31”

You need to enter into your company information in the bottom of the invoice template. Such like: company logo, company name, address, phone…

You still need to enter your invoice number in Cell F1 and the company information of your customer in range B5:B16.

How to get this free Sales Invoice Tracker template in Excel?

Click “File” Tab ->”New”, then input “invoice that calculates total” to search online template in the search box. Click it.

Invoice template that calculates total In MS Excel2

Then click “create” button to create a new workbook based on this invoice template.

 

 

Service Invoice Template In MS Excel

This service invoice template for excel will calculate line item totals, sales tax, and allow you to input Salesperson name , job description, Payment Terms and Due Date for this invoice. And it is very easy to customize and use. And you can download it freely to use it in your business.

Service Invoice Template for excel

Service Invoice Template Description

 Subtotal: This excel service invoice template will calculate all Line Total amount automatically in Cell E26, and it call one SUM function in this excel cell formula: =IFERROR(IF(SUM(E16:E25)>0,SUM(E16:E25),””), “”)

Sales Tax: the default TaxRate is 9.50% in this invoice template, you can change the value of TaxRate in the Cell D27.  If you do not want to calculate the Sales Tax, just leave “TaxRate” as blank

Salesperson: enter sales person name in cell B13

Job: enter job description in Cell C13

Payment Terms: enter payment terms in cell D13

TOTAL:  The Total Amount will be calculated automatically in Cell E28 using excel Formula: =IFERROR(IF(SUM(Invoice[[#Totals],[Line Total]])>0,SUM(Invoice[[#Totals],[Line Total]],E27),””), “”)

You need to enter into your company information in the left upper of the invoice template. Such like: company logo, company name, address, phone…

You still need to enter your invoice number and customer ID and the company information of your customer.

Service invoice Template Download

You can click the below download button to get this service invoice template for free.

[pdownload]Download[/pdownload]

 

 

 

Free invoice Templates In MS Excel spreadsheet

If you are still looking for a reliable and easy to use invoice template in MS Excel Spreadsheet, and here is a right place, and this post will provide you with various types of excel invoice template for your free download.

1. Simple Invoice template

This invoice template will calculate line item totals, sales tax, Deposit Received and deduct discount offered.

2. Service Invoice Template

This service invoice template for excel will calculate line item totals, sales tax, and allow you to input Salesperson name , job description, Payment Terms and Due Date for this invoice.

3. Sales Invoice Tracker template

This Sales Invoice Tracker template for excel will calculate line item of invoice subtotals, sales tax, and allow you choose the different type of invoice and then display the corresponding customer invoiced data.

4. Invoice template that calculates total 

This invoice template for excel will calculate line item Amount, sales tax, and Less Deposit Received to get invoice Total value.

5. Billing invoice template

This billing invoice template for excel will calculate line item total. And payment details can be find in another worksheet named as “Company Setup”.

6. Invoice template with finance charge

This finance invoice template for excel will calculate line item total automatically, you need to enter customer and shipping details, descriptions and amount.

7. Invoice template with finance charge (gray)

This invoice template with finance charge (gray) for excel will calculate line item total automatically, you need to enter descriptions, quantity and amount.