Extract VAT from UK receipts into Excel
Get net, VAT, gross, VAT rate and the supplier's VAT number for every receipt, in pounds.
Bonurile tale
Trage aici bonuri sau facturi
PDF, JPG, PNG · până la 200 de fișiere · poți pune mai multe bonuri într-o poză
Procesate, apoi șterse. Nu stocăm niciodată fișierele tale. · Nu constituie consultanță fiscală.
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 — întrebări
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.
Mai multe conversii
GST/HST receipts
GST/HST and PST/QST each get their own column, read straight from the receipt, in CAD.
Deschidefreelancer receipts
Software, equipment, travel, meals and home-office costs, categorised and totalled, in an hour or less.
DeschidePDF receipts
One drop, one spreadsheet. Every PDF receipt or invoice becomes a row you can check and edit.
Deschidetrip receipts
Hotels, flights, taxis and meals from one trip in a single spreadsheet, totalled by category and currency.
DeschideUK VAT receipts, un singur fișier curat.
10 bonuri gratuite, fără cont.