The four numbers that break quotes
Sales teams dread「how did you get this total?」Spreadsheet mistakes include:
- Missed or double-counted line subtotals
- Discount before or after tax—inconsistent policy
- Tax rate entered as 13 instead of 0.13
- Prepayment not subtracted from balance due
Professional quotes should chain: qty change → subtotal → total → tax → discount → balance. Below: Excel checklist vs ComTools Quotely (/Quotely).
Excel formula pattern (audit checklist)
Typical ex-tax model with order-level discount:
Line subtotal = Qty × Unit price
Subtotal = SUM(lines)
Tax = Subtotal × Rate
After discount= Subtotal + Tax − Discount
Balance due = After discount − Prepayment
Watch merged cells, text-formatted numbers, and percent vs amount discounts. If every copy-paste needs formula repair, move to online templates + formula engine.
ComTools Quotely dynamic engine
At ComTools Quotely register, templates bind fields and formulas:
- Edit qty / unit price → line totals update
- Edit tax / discount → summary rolls up
- Enter prepayment → balance due live
See the summary block on this sample quote.
AI generator vs Quotely
| Scenario | Tool |
|---|---|
| First draft from plain language | AI quote generator |
| Standard template, repeat clients | ComTools Quotely |
| Finance archive | Excel export or PDF |
Draft with AI; standardize with ComTools Quotely — workflow guide.
By industry
- Export: state FX date; FOB/CIF columns differ
- Construction: materials + labor + % management fee
- IT: man-days × rate; milestone prepay 30–50%
Templates: quotation template hub, software quotation.
Pre-send checklist
- Tax-inclusive vs exclusive matches invoice policy
- Discount type documented in notes
- Prepayment tied to contract milestone
- Validity period (often 14–30 days)
- PDF matches share link totals
FAQ
Best quotation auto-calculate software?
For templates, libraries and PDF/share: ComTools Quotely. One-offs: online quotation generator.
Excel tax formula?
=Subtotal*Rate with a locked rate cell—or use hosted engines to avoid broken ranges.
Tax or discount first?
Follow contract; state the rule on the quote.