To get from a stack of PDF invoices to one clean Excel sheet, decide the layout first: one row per invoice for a summary, one row per line item for an expense review. Then read each invoice into the same fixed columns, convert amounts and dates stored as text, and check the totals before anyone imports the sheet.
One row per invoice or one row per line in an invoice-to-Excel sheet?
An invoice-to-Excel sheet can hold one row per invoice or one row per invoice line. One row per invoice suits a payables summary, a vendor total or a later import into accounting software. One row per line suits an expense review, where a single bill mixes office supplies, freight and a repair that belong in different accounts.
The invoice-level layout is the default for most firm work. Each row is one document, so the row count matches the number of invoices in the folder. That makes it easy to see whether every PDF made it into the sheet, and it keeps duplicates obvious: two rows with the same vendor and invoice number stand out when the sheet is sorted.
The line-level layout repeats the header fields on every line. If invoice 7710 from Example Building Supply has four lines, the sheet holds four rows, each carrying the vendor, invoice number and date, plus that line's description, quantity and amount. Repeating the header looks wasteful, but it lets you filter and sum by any column without breaking the table.
Choose one layout per sheet. Mixing them, with a header row followed by indented line rows, produces a sheet that reads well on screen and fails the moment it is sorted, filtered or imported.
A sample invoice-level column layout
The table below is an example layout for one fictional client, with three made-up invoices. Every name, number and amount is an example.
| Vendor | Invoice number | Invoice date | Due date | Subtotal | Tax | Total | Currency | Source file |
|---|---|---|---|---|---|---|---|---|
| Example Building Supply | 7710 | 2026-09-02 | 2026-10-02 | 1,240.00 | 99.20 | 1,339.20 | USD | 2026-09_example-building-supply_7710.pdf |
| Northgate Cleaning Co. | NC-0458 | 2026-09-05 | 2026-09-20 | 450.00 | 0.00 | 450.00 | USD | 2026-09_northgate-cleaning_NC-0458.pdf |
| Harbor Office Supply | 20931 | 2026-09-11 | 2026-10-11 | 186.40 | 14.91 | 201.31 | USD | 2026-09_harbor-office-supply_20931.pdf |
Two columns earn their place even though they look optional. Currency stops a Canadian-dollar invoice from being added to US-dollar totals without anyone noticing. Source file lets a reviewer open the original PDF behind any row in seconds, which is the first thing anyone asks for when a number looks wrong.
Tracking which of these invoices are paid, and which are overdue, belongs in a separate sheet with status columns. The post on the columns an invoice tracking spreadsheet needs covers that layout.
Converting a PDF invoice to Excel, step by step
Converting a PDF invoice to Excel means reading each invoice's vendor, number, dates and amounts into the columns of one sheet, then checking the result against the PDFs. The work runs in five steps: gather the files in one folder, name them, read each invoice, convert text to numbers, and reconcile the sheet totals to the invoices.
Step 1: Put every invoice in one folder
Start with a single folder per client and period, such as "Example Client, September 2026 invoices". Invoices arrive by email, as phone photos and as portal downloads, and a sheet built from three places tends to miss one of them. If invoices come in through a shared inbox, the post on processing vendor invoices from an email inbox covers getting them out of email and into a folder each week.
Step 2: Name each file by period, vendor and number
A name such as "2026-09_harbor-office-supply_20931.pdf" sorts by month, groups by vendor and goes straight into the source file column. It also shows duplicates before any data entry starts: two files with the same vendor and invoice number are probably the same bill sent twice.
Step 3: Read the fields from each invoice
There are two ways to get data out of a PDF with Excel alone. The first is reading and typing, which works for any invoice. The second is Power Query. Microsoft's guide to importing data from data sources with Power Query gives the path Data > Get Data > From File > From PDF, after which a Navigator window shows the tables Excel found in the file.
That last point matters for invoices. The Power Query PDF connector documentation says the connector returns any tables found in a PDF. The line-item grid on an invoice is often a table. The vendor name, invoice number and dates usually sit outside it, in a header block, so Power Query may return the lines without the fields that identify the invoice. Expect to type those.
Power Query can also read a whole folder at once with Data > Get Data > From File > From Folder. Microsoft's article on importing a folder with multiple files says the files need the same structure: matching column headers, data types and number of columns. Invoices from one vendor's billing system may meet that test. Invoices from twenty vendors almost never do.
A scanned invoice is an image of a page with no text inside it, so neither method can read it without optical character recognition first. The difference between a scan and a PDF with a text layer is covered in the post on scanned invoices versus emailed PDF invoices.
Step 4: Convert text to numbers and dates
Amounts and dates copied from a PDF often arrive as text. Currency symbols, brackets for negatives and stray spaces are the usual causes, and Excel's Convert to Number command or the VALUE function fixes most of them. Do this before any formula touches the sheet.
Step 5: Reconcile the sheet to the invoices
Add a check column that computes Subtotal plus Tax minus Total for each row. Every result should be zero. A non-zero row is a typing error, a misread digit or an invoice with a discount or shipping line that needs its own column. Then compare the row count with the number of PDFs in the folder.
Credit memos need a rule before they reach the sheet. A credit memo reduces what the client owes, so enter it as its own row with a negative total and a note in the invoice number column, such as "CM-0112 (credit for 7710)". Entering it as a positive amount, or netting it silently against the original invoice, makes the vendor total impossible to trace back to the documents.
Why do invoice amounts land in Excel as text?
Invoice amounts land in Excel as text when the copied value contains something Excel does not read as part of a number, or when the cell was formatted as text before the value arrived. Currency symbols, thousands separators in an unexpected style, negative amounts written in brackets, trailing minus signs and spaces copied from the PDF are the usual causes.
Microsoft's guide to converting them says numbers stored as text can cause unexpected results, such as a formula that shows instead of its result, and it refers to a green triangle warning on those cells. A quick test is to total the amount column and compare it with an adding-machine total of the invoices.
Common causes on vendor invoices:
- Currency symbols and codes. "$1,339.20" or "USD 1,339.20" pasted as one string.
- Brackets for negatives. A credit shown as "(125.00)" may stay text instead of becoming -125.
- Trailing minus signs. Some billing systems print "125.00-" for a credit.
- European separators. "1.339,20" means one thousand three hundred thirty-nine and twenty cents, in that style, while a sheet built around US conventions treats the comma as a thousands separator. Check any invoice from a vendor abroad by hand.
- Hidden spaces. A space before or after the digits, often a non-breaking space carried over from the PDF.
Microsoft's guide to converting numbers stored as text to numbers gives two fixes. Select the cells, select the error indicator and choose Convert to Number. Or add a helper column with =VALUE() pointing at the text cell, fill it down, and paste the results back with Paste Special > Values. Strip currency symbols, brackets and stray spaces first, because a value Excel cannot parse stays text either way.
Dates go wrong in the same way. "09/02/2026" is September 2 in a US file and 9 February in a UK one. Pick one format for the sheet, ideally year-month-day as in the sample layout, and convert every date to it before sorting or filtering.
Invoice-to-Excel mistakes that break later imports
Invoice-to-Excel mistakes that break later imports are layout choices that look tidy to a person and confuse a program. Merged cells, subtotal rows inside the data, more than one date format in a column, and notes typed into amount cells are the main ones. Each one produces an import error or, worse, an import that succeeds with wrong numbers.
Merged cells. A vendor name merged across four line rows looks clean. Sorted, filtered or saved as CSV, only the first row keeps the name. Repeat the value on every row instead.
Subtotal rows. A "September total" row in the middle of the table gets imported as an invoice. Keep totals outside the data range or on a separate sheet.
Mixed date formats. A column with some true dates and some text dates sorts wrongly and may import as blanks. Convert every date the same way.
Notes in number cells. "450.00 (disputed)" is text. Put notes in their own column so the amount stays a number.
Several sheets saved as one CSV. Microsoft's page on saving a workbook to text format says the CSV format saves only the active sheet and removes all formatting. A workbook with a sheet per month becomes one month in the CSV. Save each sheet separately, or keep every invoice in one sheet with a period column.
Header rows that change. An import maps columns by their headers. Renaming "Invoice date" to "Date" halfway through the year breaks a saved mapping. Settle the headers once.
The finished sheet usually goes somewhere next. Importing it into accounting software has its own column and format rules, covered in the post on how to import a CSV into QuickBooks Online or Xero.
Exporting vendor invoices to Excel or CSV from Schema CPA
Schema CPA exports the vendor invoices it reads to Excel or CSV, so a firm starts from a filled sheet instead of a blank one. Clients upload invoices through their link, each page is classified and read, and the same invoice forwarded twice is flagged rather than written into the export a second time.
The export is a starting point for review, not the end of it. The firm still checks a few things before the sheet moves on:
- Totals. Add a check column of Subtotal plus Tax minus Total, which should be zero on every row, and spot-check rows against their PDFs.
- Flagged duplicates. Look at each flagged pair and confirm it is the same bill, not a revised invoice that reuses the number.
- Columns for the destination. Rename or reorder headers to match whatever the sheet is imported into. Schema CPA exports Excel and CSV today; it has no QuickBooks Online or Xero connection yet.
- Coding. Which account each invoice belongs in is the firm's judgment. Schema CPA reads what the invoice says and gives no accounting or tax advice.
The document categories on the Schema CPA homepage list vendor invoices alongside receipts in the expenses category, with the other document types it reads.