| INVOICE |
|---|
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. |
|
| From | Bright Harbor Studio LLC (sample) | | Bill to | Northwind Retail Co. (sample) | | | Invoice No. | INV-2026-0042 |
| Address | 120 Market Street, Suite 4, Springfield | | Address | 45 Harbor Road, Riverside | | | Invoice date | 2026-10-19 |
| Tax ID | TIN-000-000-000 | | Tax ID | TIN-111-222-333 | | | Payment terms (days) | 30 |
| E-mail | billing@example.com | | Contact | Accounts Payable | | | Due date | 2026-11-18 |
| | | | | | | Currency | USD |
| Tax | |
| Code | Tax name | Rate | | Type the tax rates that apply to you (VAT 12%, sales tax 8.25%, GST 18% …). Each line picks a code. |
| A | Standard rate (e.g. VAT / sales tax) | 12.00% |
| B | Reduced rate | 5.00% |
| C | Other rate | 0.00% |
| E | Exempt / zero-rated | 0.00% |
|
| # | Description | Qty | Unit price | Disc. % | Tax code | Net amount | Tax | Line total |
| 1 | Website redesign — fixed fee | 1 | 2,400.00 | 0% | A | IF(OR(C17="",D17=""),0,ROUND(C17*D17*(1-N(E17)),2)) | IF(G17=0,0,ROUND(G17*IFERROR(INDEX($C$11:$C$14,MATCH(IF(F17="","A",F17),$A$11:$A$14,0)),0),2)) | G17+H17 |
| 2 | Hosting, 12 months | 12 | 25.00 | 10% | A | IF(OR(C18="",D18=""),0,ROUND(C18*D18*(1-N(E18)),2)) | IF(G18=0,0,ROUND(G18*IFERROR(INDEX($C$11:$C$14,MATCH(IF(F18="","A",F18),$A$11:$A$14,0)),0),2)) | G18+H18 |
| 3 | Copywriting (hours) | 8 | 45.00 | 0% | B | IF(OR(C19="",D19=""),0,ROUND(C19*D19*(1-N(E19)),2)) | IF(G19=0,0,ROUND(G19*IFERROR(INDEX($C$11:$C$14,MATCH(IF(F19="","A",F19),$A$11:$A$14,0)),0),2)) | G19+H19 |
| 4 | Stock photos licence | 5 | 12.00 | 0% | E | IF(OR(C20="",D20=""),0,ROUND(C20*D20*(1-N(E20)),2)) | IF(G20=0,0,ROUND(G20*IFERROR(INDEX($C$11:$C$14,MATCH(IF(F20="","A",F20),$A$11:$A$14,0)),0),2)) | G20+H20 |
| 5 | | | | | | - | - | - |
| 6 | | | | | | - | - | - |
| 7 | | | | | | - | - | - |
| 8 | | | | | | - | - | - |
| 9 | | | | | | - | - | - |
| 10 | | | | | | - | - | - |
| 11 | | | | | | - | - | - |
| 12 | | | | | | - | - | - |
| 13 | | | | | | - | - | - |
| 14 | | | | | | - | - | - |
| 15 | | | | | | - | - | - |
|
| Tax summary | | | | | | Subtotal (before tax) | | SUM(G17:G31) |
| Code | Taxable base | Rate | Tax | | | Discounts given | | 30.00 |
| A | SUMIF($F$17:$F$31,A35,$G$17:$G$31)+SUMPRODUCT(($F$17:$F$31="")*($G$17:$G$31)) | 12.00% | SUMIF($F$17:$F$31,A35,$H$17:$H$31)+SUMPRODUCT(($F$17:$F$31="")*($H$17:$H$31)) | | | Tax total | | SUM(H17:H31) |
| B | SUMIF($F$17:$F$31,A36,$G$17:$G$31) | 5.00% | SUMIF($F$17:$F$31,A36,$H$17:$H$31) | | | Shipping / other charges | | - |
| C | - | 0.00% | - | | | TOTAL | | I33+I35+I36 |
| E | SUMIF($F$17:$F$31,A38,$G$17:$G$31) | 0.00% | SUMIF($F$17:$F$31,A38,$H$17:$H$31) | | | Amount paid | | - |
| Check: tax summary = tax total | | | IF(ABS(SUM(D35:D38)-I35)<0.005,"OK","CHECK") | | | BALANCE DUE | | I37-I38 |
|
| Payment details | Bank: Example Bank · Account name: Bright Harbor Studio LLC · Account No.: 000-000000-0 · Reference: invoice number |
| Notes | Thank you for your business. Please pay by the due date. |
|
| Yellow cells = you type · blue cells = calculated (do not overwrite) · example rows are fictional — replace them. |
| © Layers (layers.md) · CC BY 4.0 · Free template. Check figures against your own rules and advisers. |