Extract tabular PDF data into XLSX.
Open tool
Use-case page
Invoice PDF workflows
Send invoices with their timesheets and delivery notes attached, pull line items into Excel, and handle supplier invoices that arrive as PDFs.
Invoices move in two directions in most businesses. Accounts receivable sends them out to customers, often with backup the customer needs before approving payment. Accounts payable receives them from suppliers and has to check them against purchase orders and delivery records. Both sides spend time on PDFs that are nearly right but not quite ready.
Sending invoices that get approved first time
A customer’s payables team usually wants to see what they are paying for. For a service business that might be a timesheet; for goods, a signed delivery note or proof of delivery.
- Export the invoice from your billing system as PDF. If it is generated from a web template, HTML to PDF can render it; the guide HTML to PDF for invoices or reports covers page breaks and print styles.
- Convert a timesheet workbook with Excel to PDF, or photographed delivery notes with JPG to PDF.
- Merge the invoice first and the backup after it using Merge PDF, with Sort files on Keep uploaded order. Put the invoice number in the file name so it is easy to search.
- If the customer has asked for invoices to be password protected, set an Open password in Protect PDF and agree a password with them in advance, rather than inventing a new one each month.
Some customers’ accounts payable inboxes read data from incoming PDFs automatically. Avoid locking those invoices, flattening them into images, or adding a watermark over the totals unless you have been asked to, because it can stop that processing.
Checking supplier invoices against orders
When an invoice arrives with dozens of lines, retyping them to compare against a purchase order is slow.
- Run PDF to Excel on the supplier’s invoice. Use
Pages to skip terms and conditions pages, for example
1-2. - In the workbook, check that quantities and unit prices landed in the right columns. Multi-line item descriptions sometimes wrap into an extra row.
- Compare the extracted lines with your purchase order or goods-received record.
This works on invoices produced digitally by an accounting system. A paper invoice that was scanned has no text layer, so the spreadsheet will not contain the line items; ask the supplier for the digital original.
A worked illustration
A consultancy bills a client monthly. The invoice comes out of its accounting
software, the consultant timesheets live in a shared workbook, and the client
requires both together. Each month, the office converts the timesheet tab to
PDF, merges it behind the invoice, names the file INV-1042-October.pdf, and
emails it. The client’s payables team can approve without asking for
timesheets separately.
Keeping attachments a sensible size
Merged backup with scanned delivery notes can grow larger than expected. Run Compress PDF at Level 5 and check the result. Personal Gmail accounts have a 25 MB attachment limit, and business Outlook accounts on Exchange often default to a 10 MB total message size, so a large packet may bounce on the customer’s side even if it left your inbox.
When to skip these steps
If you and your customer exchange e-invoices or structured data through an accounting network, a PDF is just a human-readable copy and the steps above are optional. See accounting PDF workflows for related tasks.
Trust center
Trust pages
How We Want PDF handles your files: privacy, security, and how long uploads are kept.
privacy
Privacy
How We Want PDF handles the files you upload, what is needed to use the tools, and which tools send content to an AI provider.
security
Security
How We Want PDF checks uploads, delivers results, limits abuse, and removes queued job files.
retention
File retention
How long We Want PDF keeps uploaded files and results, and when they are removed.