Invoice to Excel: pull the fields, don't retype them

A structured e-invoice already holds number, date, supplier, net, VAT and gross. Exporting to Excel means reading those fields, not typing them.

5 documents free. PDF, photo or XML — data out as CSV, Excel or JSON.

Columns that survive an audit

One row per invoice: number, date, supplier name, TRN, net amount, VAT rate, VAT amount, gross, currency.

If one invoice has several VAT treatments, use several summary rows or separate columns — a single VAT column hides zero-rated supplies.

Copying from a PDF loses structure: amounts land in the wrong column, thousands separators break formulas, decimals get swallowed.

At a hundred invoices this becomes half a day of work and errors that surface months later, during reconciliation.

Structured files can be processed in bulk: drop a folder, get one sheet with a row per invoice.

This also gives a duplicate check for free: same TRN and same invoice number means the document arrived twice.

Sum of VAT lines equals total VAT on the invoice.

Quantity × unit price equals the line amount.

Zero-rated and standard-rated lines are not merged.

Only through text recognition, and the result needs checking. If the supplier sends XML, use that instead — it is exact.

No. Structured files are free to read and export at DueBuddy.