An invoice PDF as a spreadsheet row

Drop an invoice as a PDF, a scan or a photo and have its date, the name at the top, the invoice number, the total and the VAT read into one row. Only the first page is read, and only these header fields: no line items, no supplier address or VAT number, no IBAN. You check the row against the invoice, then open it in Excel.

The steps

  1. Read the header into a row. Only page 1 is read. The name goes in the Shop cell and the invoice number in the Receipt number cell. Check every cell, yellow ones first, correct what is wrong, and save the CSV. Receipt scanner
  2. Open it as Excel. Save the Excel file, or copy the row into the sheet you already keep. CSV to Excel

One row in Excel: date, name, invoice number, total, VAT, currency.