UK VAT invoices to Excel

Updated

A full UK VAT invoice usually shows a unique invoice number, the supplier’s name, address and VAT registration number, the tax point and invoice date, the customer’s details, a description of the goods or services, unit prices, the VAT rate for each item, the total excluding VAT and the total VAT. AlFasil extracts these into a spreadsheet ready for your bookkeeping.

What AlFasil checks on UK invoices

  • VAT number format: GB followed by 9 digits (or 12 for branch traders).
  • VAT rates: 20% standard, 5% reduced, 0% zero-rated. Anything else is flagged.
  • VAT by rate: invoices that mix 20% and 0% items are common; AlFasil keeps a breakdown per rate and checks each.
  • Totals: net + VAT = gross.

Simplified invoices

Retail sales up to £250 may use a simplified invoice without the customer’s details. AlFasil treats these as receipts.

Making Tax Digital

If you keep digital records for Making Tax Digital, AlFasil’s export gives you clean, consistent data to import into your bookkeeping software. This page is general information, not tax advice — check HMRC guidance for your situation.

Try it on one of your invoices

No account needed. The original is deleted right after processing.

Drop invoices or receipts here

PDF, JPG, PNG, iPhone photos, e-invoice XML or a ZIP — up to 10 MB each

Questions

Can AlFasil handle invoices with mixed VAT rates?

Yes. Each line keeps its own rate, and the VAT breakdown is checked rate by rate.

Does it work for EU suppliers too?

Yes. EU VAT numbers and rates for the main EU countries are recognised.

Ready for a whole month of invoices?

Start free with 50 pages a month. Paid plans add more pages, the API and Xero, QuickBooks and Zoho Books layouts.

Start freeSee plans and prices