pdf to excel6 min read

How to Convert a PDF Invoice to Excel and Reconcile It (2026 Guide)

Turn a PDF invoice into a clean, checkable Excel sheet: convert it with PurePDF, fix the numbers and dates, then reconcile every line against the invoice total.

SM
Sarah Mitchell

An invoice arrives as a PDF, but your bookkeeping lives in a spreadsheet. Copying each line by hand is slow, and a single mistyped amount can throw off a whole month. Converting the PDF to Excel first, and then reconciling it properly, is much safer than retyping it. This guide shows how to do both, using the PurePDF PDF to Excel tool, so the finished sheet matches the invoice exactly.

Before you convert: check the invoice

Start with the original PDF, not the spreadsheet. Note the supplier name, invoice number, invoice date, due date, and the currency. Then look at the line items: description, quantity, unit price, tax, and line total. Finally, find the three numbers that matter most for reconciliation: the subtotal, the tax amount, and the grand total. If any of those are missing or unclear in the PDF, ask the supplier for a corrected invoice before you spend time cleaning a spreadsheet. A conversion can only be as good as the source document.

Also check whether the invoice is a real text PDF or a scanned image. A text PDF usually converts cleanly, with rows and columns in the right places. A scanned invoice may need optical character recognition first, and its numbers should be checked even more carefully. If the PDF has several pages, confirm that every page belongs to the same invoice and that no page is duplicated or missing.

Step 1: Convert the PDF to Excel

Open the PurePDF PDF to Excel tool and upload the invoice PDF. Convert it, then download the resulting spreadsheet. Keep the original PDF beside the spreadsheet while you work, because you will compare them line by line later. Do not delete the PDF after conversion. It remains your proof of what the supplier actually charged.

When the spreadsheet opens, look at its overall shape before you edit anything. The header information, such as supplier name and invoice number, may sit above the table. The line items should form one table, with one row per item. Totals may appear below the table. If a row is split across two lines, or if two columns are merged into one cell, note it now. Those are the first things to fix, not problems to work around later.

Step 2: Clean the numbers, dates, and headings

Give each column a clear heading: Item, Description, Quantity, Unit Price, Tax, and Line Total, or whatever matches the invoice. Delete blank rows at the top and bottom of the table, but keep a copy of the unedited conversion until you finish. That way, if you delete something by mistake, you can check it again.

Next, fix the formats. Amounts that look like numbers but behave like text will not add up in formulas. Select the amount columns, remove currency symbols and thousands separators where needed, and format them as numbers or currency. Dates are a common trap too. A date written as 03/04/2026 could mean March 4 or April 3, depending on the supplier's country. Check one date against the PDF, set the column to a clear date format, and make all dates consistent.

Watch for quantities and prices that were split or joined during conversion. A quantity of 2 and a unit price of 25 should not become 225 in one cell. If that happens, split the cell manually and re-enter both values from the PDF. Similarly, a tax rate shown as 20 percent should not be confused with a tax amount. Keep rate and amount in separate columns if the invoice shows both.

Step 3: Reconcile the spreadsheet against the invoice

Reconciliation simply means proving that the spreadsheet agrees with the invoice. Do it in three passes. First, add a formula that multiplies quantity by unit price for each line, and compare the result with the line total on the PDF. Any difference, even a small one, needs an explanation. Rounding can cause a difference of a cent or two, but a larger gap usually means a mistyped quantity or price.

Second, sum the line totals and compare the result with the invoice subtotal. Then add the tax and compare the result with the grand total. If the spreadsheet total matches the invoice total, you have strong evidence that the lines are right. If it does not match, do not force it by changing the total. Instead, work line by line until you find the row that differs.

Third, check the non-amount details. Confirm the invoice number, dates, supplier name, and payment terms in the spreadsheet against the PDF. These details matter when you later search for the invoice, chase a payment, or answer a question from an accountant. A spreadsheet with correct amounts but the wrong invoice number is still wrong.

Add a short reconciliation note at the top or bottom of the sheet, for example: Checked against PDF invoice number, date, subtotal, tax, and grand total. Then save the file with a clear name that includes the supplier and invoice number. That note and file name will save you time months later, when the invoice is no longer fresh in your mind.

Common problems and how to fix them

If totals do not add up, check for text-formatted numbers first, then for hidden rows or blank cells inside the sum range. If a column is missing, the conversion may have merged it with a neighboring column, so split the values manually. If dates sort incorrectly, the column probably contains a mix of text and real dates, so convert the whole column to one date format.

If the invoice has multiple pages, check the last line of each page and the first line of the next page. Page breaks sometimes split a row, and a split row can easily be counted twice or not at all. If the same item appears twice, compare both rows with the PDF before deleting one. A genuine repeat order can look like a duplicate, so never delete a row on suspicion alone.

FAQ

Can I convert a scanned invoice PDF to Excel?

You can try, but scanned invoices need extra care. The text must be recognized from the image before it can become a table, and recognition errors are common in amounts and dates. Always check every line against the original scan, and treat the total comparison in Step 3 as mandatory, not optional.

What should I do if the spreadsheet total does not match the invoice?

Do not change the total to force a match. Check each line total, then the subtotal, then the tax. Look for text-formatted numbers, split rows, missing lines, and duplicated rows. The error is usually in one line, and finding it is exactly what reconciliation is for.

Should I keep the original PDF after conversion?

Yes. Keep the PDF with the spreadsheet. The PDF is the supplier's original document, while the spreadsheet is your working copy. If a payment is questioned later, the PDF is the version you will need.

Is one spreadsheet per invoice better than one sheet for many invoices?

For most small businesses, yes. Keep one sheet per invoice, with a clear file name, and use a separate summary sheet if you need monthly totals. That makes each invoice easy to find, check, and correct without disturbing the others.

A clean conversion is only half the job. The reconciliation step is what turns a spreadsheet into a record you can trust. Convert with the PurePDF PDF to Excel tool, clean the formats, prove the totals, and file the PDF with the finished sheet.

Ready to pdf to excel?

Use our free online tool to process your files securely in high quality. No sign-up required.

Open pdf to excel Tool

Continue Reading