Extract VAT from UK receipts into Excel
Get net, VAT, gross, VAT rate and the supplier's VAT number for every receipt, in pounds.
Twoje paragony
Przeciągnij tu paragony lub faktury
PDF, JPG, PNG · do 200 plików · kilka paragonów na jednym zdjęciu to nie problem
Przetwarzane, a potem usuwane. Nigdy nie przechowujemy twoich plików. · Nie stanowi porady podatkowej.
If you are VAT-registered or self-employed in the UK, you need the VAT amount and supplier VAT number from each receipt, not just the total. Drop your receipts and invoices and get a spreadsheet with the net amount, VAT, gross total, the VAT rate shown on the receipt and the VAT registration number when it's printed. Each row also carries a general expense category you can edit. Amounts are read from the receipt and never calculated, so what you see matches the paper.
Why VAT receipts are fiddly
- Net, VAT and gross are printed in different places on each receipt.
- Some items are zero-rated or reduced-rate.
- You need the supplier's VAT number for your records.
| Date | Vendor | Net | VAT | VAT rate | Gross | |
|---|---|---|---|---|---|---|
| 1 | 2026-04-08 | Ryman | 20.83 | 4.17 | 20% | 25.00 |
| 2 | 2026-04-11 | Trainline | 42.50 | 0.00 | 0% | 42.50 |
UK VAT receipts — pytania
Does it calculate VAT at 20%?
No. It reads the VAT amount and rate printed on the receipt. If a receipt shows no VAT, the VAT column stays empty or zero.
Is the supplier VAT number extracted?
Yes, when it's printed on the receipt. It goes in its own column.
Does it fill in my VAT return?
No. It gives you a clean spreadsheet of receipts and totals. Your VAT return is still filed through your usual software or accountant.
Więcej konwersji
GST/HST receipts
GST/HST and PST/QST each get their own column, read straight from the receipt, in CAD.
Otwórzfreelancer receipts
Software, equipment, travel, meals and home-office costs, categorised and totalled, in an hour or less.
OtwórzPDF receipts
One drop, one spreadsheet. Every PDF receipt or invoice becomes a row you can check and edit.
Otwórztrip receipts
Hotels, flights, taxis and meals from one trip in a single spreadsheet, totalled by category and currency.
OtwórzUK VAT receipts — jeden czysty plik.
Darmowe paragony: 10, bez rejestracji.