Value added tax on receipts can be hard to track when different purchases carry different rates. This tool extracts VAT totals from a receipt list where each receipt carries its own VAT amount, grouped by rate. Enter the net amount and VAT rate for each receipt, and the tool shows net, VAT, and gross totals per rate, plus grand totals.
Small businesses in VAT systems must often report how much VAT they paid at each rate. A single total is not enough, because returns usually ask for the split. Grouping by rate turns a pile of receipts into the exact figures a return needs. Without that split, preparing a return means reworking every receipt by hand.
Enter one row per receipt with the net amount and the VAT rate percentage. The tool multiplies net by rate to get the VAT for that receipt, then adds receipts with the same rate together. The result shows each rate with its net total and VAT total, plus the overall net, VAT, and gross totals. A gross total is simply net plus VAT.
For example, receipts of 100 dollars net at 21 percent and 50 dollars net at 21 percent give 31 dollars and 50 cents of VAT at that rate. Add a receipt of 200 dollars net at 10 percent, which gives 20 dollars of VAT. The grand totals are 350 dollars net, 51 dollars and 50 cents of VAT, and 401 dollars and 50 cents gross. Each rate stays visible in its own line.
The formula for each receipt is VAT equals net amount multiplied by VAT rate divided by 100. Grouping then adds all receipts sharing the same rate. This only works when the net amount and rate are entered correctly, so check a few receipts by hand the first time you use the tool. If a rate looks wrong, the grouped total for that rate will look wrong too, which helps you spot the error.
A common mistake is entering the gross amount instead of the net amount, which inflates the VAT figure. Another mistake is mixing rates, such as entering a reduced rate for a standard-rated item. Keep the rate from the receipt itself, not from memory, and double-check items that seem unusual. Receipts that show VAT already included need the net figure worked out first.
Some receipts show only the gross total and the VAT rate, not the net amount. In that case, divide the gross amount by one plus the rate as a decimal to get the net amount, then use that net figure here. For example, a gross of 121 dollars at 21 percent gives a net of 100 dollars. Doing that step carefully keeps the grouped totals accurate.
This tool is a calculation aid only, not tax advice. VAT rules, rates, registration thresholds, and reclaim conditions differ by country and change over time. Check the rules that apply to your business and ask a tax adviser about anything uncertain. The calculator organises your figures; it does not decide what you may reclaim or report.
Keep the receipts behind every total, organised by period, so the figures can be checked later. A grouped total is useful, but an inspector or accountant will want the underlying receipts. File this tool’s output with the receipts for the same period, and note the date range covered. That habit turns a quick calculation into a defensible record.
Use the tool at the end of each VAT period, not once a year. Regular extraction catches rate errors early, when receipts are still easy to check. Over time, the grouped totals also reveal which rates dominate your spending, which helps with pricing and cash flow planning. Small, regular VAT work beats a large, stressful catch-up every time.
Versión en español: Extractor de IVA de Recibos para Pymes – Totales de IVA de tus Recibos