Accounting template
Invoice Template with Automatic Totals
A clean invoice with totals that add up by themselves. Download it as Excel and send it on.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Description | Qty | Price | Amount |
| 2 | Consulting hours | 12 | 1,200 | =B2*C2 |
| 3 | Travel | 1 | 1,800 | =B3*C3 |
| 4 | Subtotal | =SUM(D2:D3) | ||
| 5 | VAT | 0.25 | =D4*C5 | |
| 6 | Amount due | =D4+D5 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
D2 =B2*C2
Quantity times price.
D6 =D4+D5
Subtotal plus VAT.
Make it yours by asking
Try a request like this in Tabstra:
"Create an invoice with line items, quantity, price, line totals, subtotal, VAT and amount due"