Extract VAT from UK receipts into Excel
Get net, VAT, gross, VAT rate and the supplier's VAT number for every receipt, in pounds.
Fişleriniz
Fişleri veya faturaları buraya bırakın
PDF, JPG, PNG · en fazla 200 dosya · tek fotoğrafta birden çok fiş olabilir
İşlenir, sonra silinir. Dosyalarınızı asla saklamayız. · Vergi tavsiyesi değildir.
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 — sorular
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.
Diğer dönüştürmeler
GST/HST receipts
GST/HST and PST/QST each get their own column, read straight from the receipt, in CAD.
Açfreelancer receipts
Software, equipment, travel, meals and home-office costs, categorised and totalled, in an hour or less.
AçPDF receipts
One drop, one spreadsheet. Every PDF receipt or invoice becomes a row you can check and edit.
Açtrip receipts
Hotels, flights, taxis and meals from one trip in a single spreadsheet, totalled by category and currency.
AçUK VAT receipts, tek düzenli dosyada.
10 fiş ücretsiz, kayıt gerekmez.