Sales template
Quote and Estimate Template
Put together a clean quote in minutes. Subtotal, discount, VAT and the final total are calculated.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Item | Qty | Unit price | Line total |
| 2 | Design | 10 | 950 | =B2*C2 |
| 3 | Development | 40 | 1,100 | =B3*C3 |
| 4 | Subtotal | =SUM(D2:D3) | ||
| 5 | Discount | 0.1 | =-D4*C5 | |
| 6 | VAT | 0.25 | =(D4+D5)*C6 | |
| 7 | Total | =D4+D5+D6 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
D2 =B2*C2
Quantity times unit price.
D5 =-D4*C5
Discount as a negative amount.
D7 =D4+D5+D6
Final amount to pay, including VAT.
Make it yours by asking
Try a request like this in Tabstra:
"Create a customer quote with line items, quantity, unit price, line total, subtotal, discount, VAT and total"