Billing invoice template In MS Excel

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

If you are looking for a professional billing invoice template for MS excel, this billing invoice template can be used for you freely.

 Billing invoice template1

Billing invoice template Description

Net TOTAL: It will calculate all items Total amount automatically in Cell E25, it will call one excel formula as below:

=SUM(InvoiceDetails[LINE TOTAL])-E24

Tax: the default TaxRate is 0  in this invoice template, you can change the value of TaxRate in the Cell E26.

USD TOTAL:  The Total Amount will be calculated automatically in Cell E27.

All company information is located in the worksheet “Company Setup”, so you need to edit it firstly.

All fields of payment details will use one formula that defined a Special name, such as:

Name of Bank:  =CompanySetup_BankName

CompanySetup_BankName – it is a defined name and refers to the below excel formula:

=INDEX(CompanySetup[VALUE],MATCH("Name of Bank",CompanySetup[INVOICING COMPANY DETAILS],0))

CompanySetup[VALUE]: it is an excel range in the worksheet “Company Setup” and refers to $C$3:$C$20

CompanySetup[INVOICING COMPANY DETAILS] : it is an excel range in the worksheet “Company Setup” and refers to $B$3:$B$20

MATCH(“Name of Bank”,CompanySetup[INVOICING COMPANY DETAILS],0):  it will return the position of value “Name of Bank” in the range CompanySetup[INVOICING COMPANY DETAILS]. This function will return : 14

x
How to Select Every Other Row in Excel

So this excel formula can be reduce to: =INDEX($C$3:$C$20, 14,0), it will return value “Adventure Works” from range “$C$3:$C$20“ on the index 14.

How to get this free Billing invoice template in Excel?

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

Billing invoice template2

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

 

Related Posts

Invoice template with finance charge In MS Excel
Invoice template with finance charge2

This finance invoice template for excel will calculate line item total automatically, you need to enter customer and shipping details, descriptions and amount. And it is very easy to customize and use. And also is a very simple invoice finance ...

Invoice template that calculates total In MS Excel
Invoice template that calculates total In MS Excel2

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 ...

Sales Invoice Tracker Template In MS Excel
get this free Sales Invoice Tracker template in Excel

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. And it is a little complicated and ...

Service Invoice Template In MS Excel
Service Invoice Template for 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. ...

Simple Invoice Template In MS Excel
simple invoice template for excel 1

This invoice template for excel will calculate line item totals, sales tax, Deposit Received and deduct discount offered.  And it is very easy to customize and use. And you can download it freely to use it in your business. Simple ...

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 ...

Free Microsoft Excel Spreadsheet Templates

This excel tutorial will give you a simple introduction of MS excel spreadsheet template and a collection of Microsoft Excel Spreadsheet templates for free download. If you are looking for an easy to use and free Microsoft excel templates, this ...

How To Use Template In MS Excel spreadsheet
excel template 6

Excel template is also a workbook, the only different is that it can be as a template or module to create other similar workbooks. There are many free excel templates in the internet or you can create your own excel ...

Sidebar