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.

Download

 

 

Comments

So empty here ... leave a comment!

Leave a Reply

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

Sidebar