InvoiceXL / Practical guide

Hand off PDF invoices to accounts payable as checked Excel tables

Deliver source-linked invoice and item tables with explicit exceptions, rather than an unexplained collection of extracted cells.

Agree on the handoff before extraction

When you hand PDF invoices to accounts payable as an Excel workbook, tell the recipient what each row represents and what remains unchecked. Ask whether the recipient needs a document register, detailed items or both, and whether it expects a particular date or currency convention. Keep original PDFs in a separate source folder and work on copies. For a small collection, manually preparing a register in an existing spreadsheet can avoid converter charges. A supplier's CSV export is another useful starting point when available. Choose the simplest source that supplies the required fields without inventing missing data.

Build two tables with a traceable key

Use one table for invoice headers and totals, and another for item detail when needed. Include a stable working document reference and source filename in both. An invoice number alone may not be unique across suppliers, so inspect supplier and reference together. Keep page references for items on multi-page documents. Store printed tax and total once in the document table rather than repeating them as summable values on every item. This lets the recipient review totals without multiplying them by the number of lines in the invoice.

Keep business decisions outside extracted facts

Printed supplier names, currency codes and amounts are source data. Supplier account IDs, expense accounts, approval status and tax treatment are decisions or destination-specific fields. Use separate columns for those decisions and identify who must supply them. Do not automatically mark a document approved because its arithmetic matches. A missing tax amount is not evidence of zero tax or a particular treatment. Similarly, a PDF conversion does not verify payment details or establish that a document is genuine. Keep the handoff focused on checked source values and explicit unresolved questions.

Create an exception list that someone can act on

List unreadable fields, ambiguous dates, recognition warnings, omitted pages and unexplained arithmetic differences with source references. Distinguish a failed document from a document that produced usable but flagged data. If repeated invoice numbers appear, compare the source documents before deleting anything: they could be duplicates, corrections or separate suppliers. Keep any exclusions and their reasons alongside the delivered workbook. A filtered view containing only clean-looking rows is insufficient if the recipient cannot tell that other invoices were omitted from the batch or need another review.

Validate and package the result

Compare the expected document list with the processed list and count items for each invoice. Check identifiers, signs, dates and currencies, then reconcile detail amounts with printed charges and totals. Tabula or an available Excel PDF connector can extract simple text tables without an additional converter fee, but header and exception tracking still need deliberate work. Open the delivered workbook and confirm filters, numeric values and source references remain usable. Include the original documents and the exception list through your normal handoff process; a temporary conversion result should not become the only retained record.

Include a receipt checklist for the recipient

Prepare a short delivery note naming the number of source PDFs, successful documents, failed documents and invoices awaiting clarification. Give the workbook sheet names and state whether one row means an invoice or an item. Explain how the working document reference links the tables and source files. Identify the person responsible for resolving each exception and whether the spreadsheet is ready for review or still incomplete. Avoid calling a document paid, approved or posted unless that status comes from the responsible system or person; a successful extraction establishes none of those business states.

Freeze one handoff version and track later changes

Name the delivered workbook and exception list consistently, and retain the exact source set used for that version. If a supplier sends a corrected invoice later, compare it with the earlier document and ask how the recipient wants the revision identified. Do not silently replace one file in a source folder while leaving a workbook that still describes the previous version. Record corrected fields, affected document references and whether the recipient has acknowledged the change. This lets accounts payable distinguish a revised handoff from an additional invoice and prevents a later reviewer from reconciling against the wrong source version.

Where InvoiceXL fits

InvoiceXL can supply the two extraction tables for a handoff, with item source references, arithmetic flags and a failure list. It does not approve invoices or post to accounts payable. One account trial needs no card and covers one invoice PDF up to 20 pages; paid batches allow ten PDFs, 15 MiB combined and 3,000 line items, one invoice per file. Every successful PDF uses one credit, including usable flagged results; failed files cost none. Handwriting, rotation, faint scans, inclusive tax, repeated tax summaries and complex discounts may fail or need manual checking. Uploads and outputs are deleted within 24 hours.

Try a real free conversion See one-time packs

Written by Zijian Xiao. Examples are synthetic. Review all extracted results against your original source file.