CalcCAGR Calculator
Calculate the compound annual growth rate of an investment.
What is VAT?
VAT (Value Added Tax) is a consumption tax applied to goods and services at each stage of the supply chain where value is added. Unlike sales tax collected only at the final sale, VAT is collected incrementally — from raw material supplier to manufacturer to wholesaler to retailer — with each business paying VAT on purchases and charging VAT on sales. The final consumer bears the full VAT cost, while businesses in the chain recover VAT they've paid on inputs.
For example, a wooden table's journey: A logger sells timber to a sawmill for €100 plus 21% VAT (€21) = €121 total. The sawmill pays €21 VAT but will recover it when filing their VAT return. The sawmill processes timber into wood and sells to a furniture maker for €250 plus 21% VAT (€52.50) = €302.50. The sawmill remits €31.50 to tax authorities (€52.50 collected minus €21 paid). The furniture maker sells the table to a retailer for €450 plus 21% VAT (€94.50) = €544.50, remitting €42 (€94.50 − €52.50). Finally, the retailer sells to you for €800 plus 21% VAT (€168) = €968, remitting €73.50 (€168 − €94.50). Total VAT remitted: €21 + €31.50 + €42 + €73.50 = €168 — exactly what you, the consumer, paid.
How it Works: Formulas Explained
VAT calculations involve three key figures: the net price (before VAT), the VAT amount, and the gross price (including VAT). The formula depends on what you're solving for.
VAT Amount = Net Price × (VAT Rate ÷ 100)
Gross Price = Net Price + VAT Amount
Combined: Gross Price = Net Price × (1 + VAT Rate ÷ 100)
Let's work through a concrete example. A laptop has a net price of €850 and the VAT rate is 21%:
VAT amount: €850 × 0.21 = €178.50
Gross price: €850 + €178.50 = €1,028.50
Or combined: €850 × 1.21 = €1,028.50
Sometimes you know the gross price and need to find the net price and VAT amount (called "extracting VAT"):
Net Price = Gross Price ÷ (1 + VAT Rate ÷ 100)
VAT Amount = Gross Price − Net Price
Or: VAT Amount = Gross Price × [VAT Rate ÷ (100 + VAT Rate)]
Example: You paid €1,452 for a service including 21% VAT. What was the net price and VAT amount?
Net price: €1,452 ÷ 1.21 = €1,200
VAT amount: €1,452 − €1,200 = €252
Verification: €1,200 × 0.21 = €252 ✓
For businesses calculating VAT payable to tax authorities:
VAT Payable = VAT Collected on Sales − VAT Paid on Purchases
If your business collected €8,450 VAT on sales and paid €5,280 VAT on purchases during the quarter:
VAT payable: €8,450 − €5,280 = €3,170 remitted to tax authorities
If VAT paid exceeds VAT collected, you have a VAT credit refundable or applicable to future periods.
Step-by-Step Guide
- Identify the correct VAT rate: VAT rates vary by country, product type, and customer location. In Spain, the general rate is 21%, reduced rates are 10% (hotels, restaurants, some food), and super-reduced rate is 4% (basic necessities like bread, milk, books, medicines). In Germany, the standard rate is 19% with 7% reduced rate. In France, 20% standard with 10%, 5.5%, and 2.1% reduced rates. Always verify the applicable rate for your specific product or service in your jurisdiction.
- Determine if you're calculating VAT to add or extract: Adding VAT means you have a net price and need the gross price (common for businesses setting prices). Extracting VAT means you have a gross price and need to find the net price and VAT component (common for expense accounting or verifying invoices). The formulas differ — adding multiplies by (1 + rate), extracting divides by (1 + rate).
- For adding VAT: multiply net price by (1 + rate): If your service costs €450 net and VAT is 21%, calculate €450 × 1.21 = €544.50 gross. The VAT amount is €544.50 − €450 = €94.50. For quick mental math on common rates: 21% is roughly "add one-fifth plus a bit," 10% is "add one-tenth," 19% is "add one-fifth minus 1%."
- For extracting VAT: divide gross price by (1 + rate): If your invoice shows €726 including 21% VAT, find the net price: €726 ÷ 1.21 = €600. VAT amount: €726 − €600 = €126. Common mistake: don't multiply €726 × 0.21 = €152.46 — that's wrong because you're applying 21% to the gross instead of the net. Always divide to extract.
- For businesses: track input and output VAT separately: Maintain records of VAT charged to customers (output VAT) and VAT paid to suppliers (input VAT). Use accounting software or spreadsheets categorized by VAT rate. At filing period end (monthly, quarterly, or annually depending on your country), sum each category. Output VAT minus input VAT equals VAT payable (or refundable if negative).
- Verify calculations on invoices: Before paying any business invoice, verify the VAT calculation. Check that net price × (1 + rate) equals the gross price shown. Check that the VAT amount shown matches net × rate. Errors are common — a €2,500 invoice at 21% should show €525 VAT and €3,025 total. If it shows €500 VAT or €3,000 total, something's wrong. Correct invoices are essential for VAT recovery.
Real-World Examples
Example 1: Freelancer Invoicing a Client
María is a graphic designer in Spain (21% VAT). She quotes a client €2,400 for a branding project. Her invoice must show: Net price €2,400, VAT (21%) €504, Total €2,904. María collects €2,904 from the client. She keeps €2,400 as revenue and must remit €504 to tax authorities. However, if María paid €180 VAT on a new computer and €45 VAT on software subscriptions this quarter, she can deduct those from VAT collected. Net VAT payable: €504 − €180 − €45 = €279. Her effective VAT burden is reduced by business expenses.
Example 2: Retail Purchase with VAT Refund for Tourist
Yuki, a tourist from Japan, buys a €1,800 watch in Paris. French VAT is 20%, so the price includes €300 VAT (€1,500 net + €300 VAT = €1,800). As a non-EU resident, Yuki can claim a VAT refund minus processing fees. She requests a VAT refund form at the store, gets it stamped at customs when leaving the EU, and submits for refund. She receives back approximately €240 (€300 VAT minus 20% processing fee). The watch effectively cost her €1,560. This is why luxury shopping in Europe attracts tourists — VAT refunds reduce prices by 10-15% after fees.
Example 3: E-commerce Sale Across EU Borders
A German company sells €5,000 of products to a Spanish customer. Before 2021, rules varied. Now under EU VAT e-commerce rules: For B2C sales under €10,000 annual cross-border threshold, charge German VAT (19%). Above threshold, charge customer's country VAT. The company registered for OSS (One Stop Shop) and charges Spanish VAT (21%) on the €5,000 sale: €5,000 × 1.21 = €6,050 total. They remit Spanish VAT through Germany's OSS portal, simplifying compliance across 27 EU countries with one quarterly filing.
Example 4: Restaurant Bill Calculation
A couple dines at a Madrid restaurant. Their meal totals €85 before VAT. Spain applies reduced 10% VAT to restaurant services (temporarily reduced from 21% during certain periods — rates can change with government policy). VAT amount: €85 × 0.10 = €8.50. Total bill: €85 + €8.50 = €93.50. The menu must display prices including VAT by law, so the €85 net isn't shown — instead, items are priced with VAT included. To find the VAT component: €93.50 ÷ 1.10 = €85 net, VAT = €8.50. The restaurant remits €8.50 to tax authorities but can deduct VAT paid on food purchases, utilities, and equipment.
Example 5: B2B Transaction with Reverse Charge
A UK software company (post-Brexit) sells €10,000 of software to a Spanish business. This is a cross-border B2B service. Instead of charging VAT, the reverse charge mechanism applies. The UK company invoices €10,000 with no VAT, noting "Reverse charge: VAT to be accounted for by the recipient." The Spanish business self-accounts for Spanish VAT (21%): €10,000 × 0.21 = €2,100. They record €2,100 as output VAT and simultaneously deduct €2,100 as input VAT (assuming full deductibility). Net VAT effect is zero, but the transaction is reported. This prevents foreign companies from needing to register for VAT in every customer country.
Common Mistakes to Avoid
1. Applying the wrong VAT rate: Many products qualify for reduced rates, but the rules are specific. Restaurant food is 10% in Spain, but takeaway food might be 21%. E-books are 4% while physical books are 4%, but digital magazines might be 21%. Using 21% when 10% applies overcharges customers and creates VAT filing discrepancies. Using 10% when 21% applies means you owe the difference plus penalties. Maintain a VAT rate matrix for your products and review when laws change.
2. Extracting VAT incorrectly by multiplying instead of dividing: This is the most common calculation error. Given €1,210 including 21% VAT, some calculate VAT as €1,210 × 0.21 = €254.10. Wrong. Correct: €1,210 ÷ 1.21 = €1,000 net, VAT = €210. The €44.10 difference compounds across many transactions. If you deduct €254.10 input VAT instead of €210 on tax filings, you've underpaid VAT and face penalties when audited. Remember: divide to extract, multiply to add.
3. Charging VAT to VAT-registered EU businesses: For B2B sales within the EU to VAT-registered customers, you should not charge VAT — the reverse charge applies. If you invoice a German company with a valid VAT ID and charge 21% Spanish VAT, both you and the customer have problems. You'll owe Spanish VAT you shouldn't have collected, and the customer can't properly deduct it. Always validate EU VAT IDs via VIES (VAT Information Exchange System) before applying reverse charge.
4. Missing VAT filing deadlines: VAT returns have strict deadlines — typically monthly or quarterly with filing due within 20-30 days after period end. Missing a deadline triggers automatic penalties (often 5-20% of VAT due) plus interest (currently 4-10% annually depending on country). Set calendar reminders 1 week before deadlines. If you can't pay, file on time anyway and arrange a payment plan — penalties for late filing exceed penalties for late payment in most jurisdictions.
Pro Tips
Register for OSS if selling digitally across the EU: The One Stop Shop (OSS) scheme lets you file one quarterly VAT return covering all EU B2C digital sales instead of registering in every country. If you sell €50,000 of software to customers across 15 EU countries, OSS means one filing in your home country rather than 15 separate registrations. You still charge each customer's local VAT rate, but compliance is centralized. Register via your home country's tax authority portal.
Keep VAT invoices organized by rate and period: Use accounting software that tags every transaction with its VAT rate and period. At filing time, you need totals for each VAT rate (21%, 10%, 4% in Spain). Manual sorting of receipts is error-prone and time-consuming. Software like QuickBooks, Xero, or Holded automatically categorizes VAT, generates preview reports, and often files directly with tax authorities. The time saved and error reduction justify the subscription cost.
Understand VAT grouping if you have multiple businesses: Some countries allow VAT grouping — multiple legal entities under common control register as one VAT group. Intra-group transactions aren't subject to VAT, simplifying administration. If you own three companies that trade with each other, VAT grouping eliminates VAT on internal transactions, improving cash flow. However, all group members are jointly liable for VAT debts. Consult a tax advisor about whether grouping benefits your structure.
Price your products with VAT included for B2C, exclusive for B2B: Consumer psychology responds better to "€99 including VAT" than "€81.82 + VAT." For B2B customers, prices are typically shown exclusive of VAT since businesses deduct VAT anyway — they care about the net cost. If you serve both markets, display both prices: "€99 (€81.82 + VAT)" for transparency. This is legally required in most EU countries for B2C sales.
Monitor VAT threshold limits for registration: Most countries have VAT registration thresholds — annual turnover below which you don't need to register. In Spain, it's €0 for most businesses (must register immediately), but some countries have thresholds like €85,000 in the UK or €22,000 in Poland. If you're near the threshold, timing sales to stay under can defer VAT registration and administrative burden. However, unregistered businesses can't deduct input VAT, so calculate whether registration benefits you even below mandatory thresholds.
FAQs
For physical goods exported outside the EU, sales are generally zero-rated (0% VAT) if you have proof of export (customs documentation). The customer pays import VAT and duties in their country. For digital services to non-EU customers, rules vary — many countries exempt these from EU VAT, but you may need to charge VAT or GST in the customer's country (e.g., Australia's GST, UK VAT post-Brexit). Keep detailed records of customer location and export proof for zero-rated sales.
Generally no. Most EU countries restrict VAT recovery on entertainment, meals, and client hospitality. In Spain, you can't deduct VAT on restaurant meals, event tickets, or gifts to clients. VAT on employee meals may be partially deductible if provided on business premises. VAT on vehicles is restricted unless the vehicle is used 100% for business (taxis, driving schools). Keep separate records for non-deductible VAT — you still pay it but can't claim it back.
You cannot charge VAT without a valid VAT number. If you're waiting for registration, invoice without VAT and add a note explaining VAT will be added once registered. Once you receive your VAT number, you can issue supplementary invoices charging VAT retroactively for sales made after your registration date (not before). Charging VAT without a number is illegal and penalties apply. Customers can't deduct VAT on invoices from unregistered suppliers.
VAT record retention periods vary by country: Spain requires 4 years, Germany 10 years, UK 6 years, France 10 years. Records include invoices issued and received, VAT account summaries, import/export documentation, and VAT returns. Digital storage is acceptable if records are legible and accessible. Tax authorities can audit past periods within the retention window, so maintain organized archives. Good practice: keep records for the maximum period applicable if you operate across borders.