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.

 

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar