Cosmovex/tools

Turn invoice PDFs into one row per invoice: number, date, supplier, totals

One row per invoice with Invoice to Spreadsheet

This page opens on the invoice summary: one row per invoice with the number, dates, supplier, subtotal, tax, total, the sum of the lines and a check result. It is the register view of a pile of invoices, without the line items.

  1. Open an invoice PDF, or use the sample to see the layout.
  2. Choose One row per Invoice (summary) in the export bar.
  3. Check the number, date and supplier on the invoice card.
  4. Read the Check column in the preview: it says whether the lines add up to the subtotal and the total.
  5. Download. With Pro, add several invoices first and get one row each in a single sheet.
invoice register spreadsheet from pdf one row per invoice excelinvoice summary from pdfpurchase invoice registerlist invoices in excel from pdf
Open Invoice to Spreadsheet Free to start · no account

What to know

A register wants the totals, not the lines. In summary mode each invoice becomes one row: source file, invoice number, invoice date, due date, supplier, subtotal, tax, total, the sum of the line items, and a check that says OK, that the lines do not match the subtotal, or that subtotal plus tax does not match the total. Dates and amounts are real date and number cells in Excel.

The check column is the point of building the summary from the lines rather than only from the printed total: it catches an invoice where a line was misread or the supplier's own arithmetic is wrong. Nothing is corrected silently.

One invoice at a time is free. Pro reads up to 40 invoices in one go, merges them into one sheet with a Source column, and can add a Totals by supplier sheet. Free reads one invoice at a time, the first 3 pages, up to 15 line items per export and 3 exports a day, which is enough to try the tool on a real invoice. Pro merges many invoices into one sheet, reads up to 30 pages per invoice and removes the line and export limits.

Updated · Cosmovex

Questions

Can I get the summary for many invoices at once?

Yes, with Pro: add up to 40 PDFs, then choose One row per Invoice. Free reads one invoice at a time.

What does the Check column mean?

OK means the lines add up to the subtotal or subtotal plus tax equals the total. Otherwise it says which of the two does not match. Not checked means the invoice has no subtotal or total the tool could find.

Where does the supplier come from?

From the top of the first page of each invoice. It is a guess when the name is in a logo or an image, and you can edit it before you download.

Can I get both lines and the summary in one workbook?

Yes, with Pro and Excel: tick Invoices sheet and the workbook has a Line items sheet and an Invoices sheet.

The free plan covers everything on this page. Invoice to Spreadsheet Pro ($9/mo, billed monthly) is described on the Invoice to Spreadsheet page.