If your Something Real project sells anything, hires a venue, or buys materials, the price on the shelf is rarely the full story. In Ireland, Value-Added Tax (VAT) sits on top of many net prices, and a spreadsheet that cannot handle euro formatting or percentage rates will give you the wrong total every time.
Today you will build a clean net-to-gross VAT calculator: proper euro currency, a rate that really means 23% (not 2300%), and formulas that update the moment a net price changes.
Today's class working rate is Ireland's standard VAT rate of 23% (confirm with your teacher if they want you to check Revenue or Citizens Information first). In your head: if a net price is €10.00 and VAT is 23%, is the VAT amount €2.30 or €23.00? How would you write that rate in a spreadsheet cell so the formula gets it right?
These five ideas stop the sheet lying to your budget. Your teacher will walk the rows; you will use every one in the build that follows.
| Concept | Why it matters | Example |
|---|---|---|
| Net price — the amount before VAT is added | Suppliers and invoices often quote net; if you treat net as gross you under-charge or under-budget | A Centra stock order lists 24 multipacks at a net unit price; VAT is calculated on top for the full bill |
| VAT (Value-Added Tax) — a tax added to many goods and services sold in Ireland | Your Something Real budget is wrong if VAT is missing or applied at the wrong rate | Custom stickers sold at a school fair may need standard-rate VAT on top of the net craft cost |
| Gross price — net plus VAT; what the customer usually pays | Pitch decks, enterprise sheets, and Work Experience costings need the real out-the-door figure | Net €10.00 at 23% VAT becomes gross €12.30 |
| The percentage trap — typing 23 then formatting as % turns the value into 2300% | One wrong rate multiplies every row and quietly wrecks a whole budget | Type 0.23 then format as percentage, or type 23% including the % sign so the cell stores 0.23 |
| Currency format (€) — displays numbers with the euro symbol and two decimal places | Readers trust a sheet that looks like money; 12 vs €12.00 is not the same professional signal | Format the Net, VAT, and Gross columns as euro currency so every total reads cleanly |
Keep this five-item sticker-and-print example beside you while you work in the next step. VAT rate is 23% on every row. VAT amount uses =B2*C2. Gross uses =B2+D2.
| Item | Net (€) | VAT rate | VAT (€) | Gross (€) |
|---|---|---|---|---|
| Vinyl sticker pack | 12.00 | 23% | 2.76 | 14.76 |
| Shipping labels (100) | 8.50 | 23% | 1.96 | 10.46 |
| A4 card stock pack | 15.00 | 23% | 3.45 | 18.45 |
| Ink cartridge | 22.00 | 23% | 5.06 | 27.06 |
| Table display stand | 35.00 | 23% | 8.05 | 43.05 |
Note: Before you apply Currency format, a raw formula such as 8.50 × 0.23 may show as 1.955 (and gross as 10.455). That is fine. Currency format then displays €1.96 and €10.46. Change any net price and both VAT and gross should recalculate automatically.
Build the worked-example VAT calculator for a small sticker-and-print side hustle. Use the five items from the Key concepts snapshot. Save this practice file as {{code:sm3_vat_calc_practice}} (Excel Online adds {{code:.xlsx}}). When you finish, every money column should show euro currency and every rate should display as 23% while storing 0.23. You will create a separate project file in Independent practice.
| Issue | Solution |
|---|---|
| My VAT rate shows 2300% instead of 23% | You typed 23 then applied percentage format. Clear the cell, type 0.23 (or type 23% including the % sign), then apply percentage format only if you used 0.23. |
| Only C2 has a rate; C3:C6 are blank | Formatting a range does not fill empty cells. Click C2 only, drag the fill handle down to C6 so 0.23 copies, then select C2:C6 and apply Percentage. |
| VAT amounts look right but have many decimal places | Select the VAT and Gross columns and apply Currency (euro) with two decimal places. The formula can still be exact underneath; the display rounds for reading (for example 1.955 becomes €1.96). |
| Currency shows $ or £ instead of € | Re-open the number format or custom currency picker and choose Euro. School accounts sometimes default to another currency. |
| Autofill copied the same VAT number on every row | Check the formula is {{formula:=B2*C2}} not a fixed value. If you pasted values only, delete column D and enter the formula again, then refill. |
| I cannot find my practice or project file | Go to {{code:Project_Portfolio}} → {{code:09_specialism}} → {{code:sm3}}. Practice is {{code:sm3_vat_calc_practice}} (Excel Online: {{code:sm3_vat_calc_practice.xlsx}}). The project file you bank is {{code:sm3_vat_calc}} (Excel Online: {{code:sm3_vat_calc.xlsx}}). Online apps save in the folder where you created the file, not in Downloads. |
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.