End of month, twenty supplier invoices in your inbox as PDFs. You need them into your reconciliation sheet. Manual data entry takes a Wednesday. PDF-to-Excel takes ten minutes.
Invoices are very converter-friendly
Modern invoice templates — whether from QuickBooks, Xero, Stripe, or a custom system — have a clear line-items table, a totals block, and metadata at the top (invoice number, date, supplier). Flint's PDF to Excel finds the table reliably and pulls each line as its own row.
What doesn't always come across cleanly: the metadata block, which arrives as free-form text above the table. You can usually copy what you need from there into your own columns.
Reconcile a batch in one go
If you have multiple invoices to process, convert them one at a time and concatenate into a single sheet, adding a column for invoice number per group. Then group by supplier or by category. SUMIF gives you the totals to cross-check against the actual invoice amount — if your sheet total matches each invoice's printed total, the conversion went clean.
Tax columns and rounding
Watch tax columns specifically. Some invoices include VAT/sales tax inline; some break it out per line; some only show it in the totals block. After conversion, your Excel may have a tax column with mixed signal — values for some lines, blanks for others. Standardise before you reconcile.
Skip the round-trip for one-offs
If you only need a single number from an invoice (e.g. the total), don't convert — just open the PDF and copy. PDF-to-Excel earns its place when there's a table to extract. For everything else, view and edit the PDF directly instead.
FAQ
Will the totals row come across?
Usually yes, but flagged as a row of its own. You may want to delete it before applying SUMIF so you don't double-count.
What about line items in foreign currencies?
Numbers come across as numbers. The currency symbol is text and may be merged with the amount — quick text-to-columns fixes it.
Can I convert several invoices at once?
On the free flow, one at a time. For batch processing, the API or paid tiers handle multiple uploads.
Will the supplier name be on every row?
No — it usually appears once in the metadata block. Add it as a column manually so you can sort and filter mixed batches.
End of month doesn't have to mean retyping. Convert your invoice PDF to Excel in under a minute.