Simple Invoice Template In MS Excel

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 invoice template for excel 1

Simple invoice Templates Description

Invoice Subtotal: This excel invoice template will calculate the subtotal amount automatically in Cell G21, and it call one SUM function (=SUM(SimpleInvoice[Price])) in this excel cell.

Sales Tax: If you do not want to calculate the Sales Tax, just leave “TaxRate” as blank. Or it will convert the value to percentage format.

Deposit Received: if your customer pays the deposit, then you need to add value in Deposit Received.

TOTAL:  The Total Amount will be calculated automatically in Cell G26 using excel Formula: (G21+G23+G24)-G25

Simple invoice Templates Download

You can click the below download button to get this simple 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.