Calculator
Formula used
- Rate = VAT% / 100
- Line base: Unit × Quantity
- Discount amount: Base × Discount%
- Taxable total: Base − Discount + Shipping
- Exclusive pricing: VAT = Net × Rate, Gross = Net + VAT
- Inclusive pricing: Net = Gross / (1 + Rate), VAT = Gross − Net
How to use this calculator
- Select whether your price is inclusive or exclusive.
- Enter unit amount, quantity, and VAT rate.
- Optionally add a discount and shipping/fees.
- Pick your rounding rule for reporting.
- Press Submit to view totals above the form.
- Download CSV or PDF for your records.
Example data table
| Scenario | Unit | Qty | VAT% | Discount% | Shipping | Net | VAT | Gross |
|---|---|---|---|---|---|---|---|---|
| Exclusive sale | 1000.00 | 2 | 15 | 0 | 0.00 | 2000.00 | 300.00 | 2300.00 |
| Inclusive receipt | 575.00 | 1 | 15 | 0 | 0.00 | 500.00 | 75.00 | 575.00 |
| Discount + shipping | 1200.00 | 3 | 10 | 5 | 150.00 | 3570.00 | 357.00 | 3927.00 |
Pricing inputs and taxable base
Most VAT mistakes start with the taxable base. This calculator multiplies unit amount by quantity, subtracts a percentage discount, then adds shipping or fees as taxable charges. Example: unit 1,000 and quantity 2 gives 2,000. A 5% discount removes 100, leaving 1,900. Adding 150 shipping creates a taxable total of 2,050 before tax. If discount is 10%, the base falls to 1,800, lowering VAT directly.
Exclusive and inclusive pricing differences
With exclusive pricing, the taxable total is net. VAT equals Net × Rate, and Gross equals Net + VAT. At 15% on net 2,000, VAT is 300 and gross is 2,300. With inclusive pricing, the taxable total is gross. Net equals Gross ÷ (1 + Rate). For gross 575 at 15%, net is 500 and VAT is 75.
Rounding and reconciliation controls
Teams often round to 0.01, 0.05, 0.10, or whole units. Rounding each component can break the identity Gross = Net + VAT. The calculator rounds totals and then adjusts VAT so the totals always reconcile, reducing manual balancing during ledger posting. Use the same rounding rule used by your invoice system.
Session history and repeat checks
The tool stores up to 10 recent results in the session, including pricing type, VAT rate, and timestamp. This supports quick repeat checks during month-end close, supplier verification, and cash register reconciliation. For multi-line invoices, run each line and export each result. A typical three-line invoice can be verified in under two minutes.
Exports for spreadsheets and audit folders
CSV export produces a structured Field/Value summary suitable for spreadsheets, filtering, and comparisons. The PDF export is a compact, text-only report for attachments and approvals. Both outputs include taxable total, rounding rule, and computed net, VAT, and gross amounts. Keep the PDF with the invoice image to document the rate applied.
Data checks and practical use cases
Use this calculator to validate invoices, confirm inclusive receipts, or estimate VAT on services with fees. As a check for inclusive prices, the VAT share of gross equals Rate ÷ (1 + Rate). At 20%, VAT is 16.6667% of gross. At 5%, it is 4.7619%. Large gaps usually indicate an incorrect price type or rate selection.
FAQs
1) What should I enter as unit amount?
Enter the price per unit for one item or service. Then set quantity to match the number of units. Choose inclusive if the price already includes VAT; otherwise choose exclusive.
2) How is VAT calculated for inclusive prices?
The tool treats your taxable total as gross. It derives net using Net = Gross / (1 + Rate). VAT is VAT = Gross − Net, which preserves the original gross amount.
3) Does shipping always attract VAT?
Rules vary by jurisdiction and item type. Here, shipping and fees are treated as taxable for simplicity. If shipping is non-taxable in your case, enter it as zero and add it separately outside the base.
4) Why does VAT change after rounding?
Rounding can break the identity Gross = Net + VAT. The calculator rounds totals, then adjusts VAT to keep the equation consistent, matching common invoicing and reconciliation practices.
5) Can I use this for multiple invoice lines?
Yes. Run each line separately using its unit amount and quantity. Export each result and combine them in your spreadsheet or accounting system. The session history helps you track recent lines.
6) What do the three bars in the chart represent?
The chart visualizes the computed totals: net, VAT, and gross. It helps you see how tax changes when you adjust the rate, discount, shipping, or pricing type.