Boxes, pieces and hours
Keep the unit beside each quantity. Three boxes of bolts are not three individual bolts. Convert units only after you establish what each supplier’s unit contains.
FOR ACCOUNTS PAYABLE & PURCHASING
Extract invoice line items to Excel.
Keep the detail.
Turn supplier invoice tables into rows you can filter, compare and check. Keep each item connected to its invoice, from the first quantity to the final total.
No credit card required
FROM INVOICE TO ITEM ROWS Fictional example
Alder Industrial SupplyALD-1048 · 6 October 2026 · USD
Steel brackets12 EA × $45.00$540.00
M8 bolts, box of 1003 BOX × $28.00$84.00
Item subtotal$624.00
Two items → two Excel rows
| Invoice | Qty | Unit | Amount |
|---|---|---|---|
| ALD-1048 | 12 | EA | $540.00 |
| ALD-1048 | 3 | BOX | $84.00 |
Invoice charges stay separate. See the full calculation below.
THE DETAIL BEHIND THE TOTAL
One invoice. Two item rows.
One total to reconcile.
A bill total tells you how much is due. Item rows tell you what was bought. Use both views when you check a supplier charge, prepare purchasing reports or review a PO.
| Supplier SKU | Description | Quantity | Unit | Unit price | Line amount |
|---|---|---|---|---|---|
| BRK-04 | Steel brackets | 12 | EA | $45.00 | $540.00 |
| BOLT-M8 | M8 bolts, box of 100 | 3 | BOX | $28.00 | $84.00 |
Scroll the table sideways on a small screen to see all columns.
Item subtotal$624.00
+Freight$36.00
+Tax$33.00
=Invoice total$693.00
Keep the invoice total out of the item sum.
If you repeat $693 on both item rows and sum that column, you get $1,386. Keep the bill total in an invoice register, then connect the item sheet with the supplier and invoice number. The example tax is a supplied amount, not a tax rule.
A SPREADSHEET THAT FITS THE JOB
Choose the columns
before the upload.
Start with the decision your team needs to make. For a price check, retain the supplier SKU and unit. For a PO review, retain the purchase order reference. For invoice reconciliation, keep charges and currency explicit.
Use one consistent set of column names across vendors. Preserve the original descriptions, even when you later map several supplier codes to one internal item.
Let missing data stay missing.
A blank SKU means the source may not provide one. A zero price means something else. Review the source before you fill either value.
Your two connected tables
Invoice register · one row per bill
Supplier, invoice number, invoice date, PO reference, currency, item subtotal, freight, tax, discount and invoice total.
Line items · one row per item
Supplier, invoice number, row number, description, supplier SKU, quantity, unit, unit price and line amount.
Source reference · keep on both
Retain a filename or document reference in your working spreadsheet. Use supplier plus invoice number to avoid mixing bills that share the same number.
FROM A TRIAL BATCH TO REPEATABLE WORK
Review the rows
that matter most.
Use DigiParser to extract document fields and item tables. Then compare the result with the source before it becomes a purchasing report or accounting import.
Start with a small, varied batch: a clear PDF, a scan, and an invoice with a table that spans pages. These show more than ten copies of the same layout.
- 01
Set up fields and item columns
Choose the invoice fields and table columns your export needs. Keep unit, quantity and price separate so the result can be checked in Excel.
- 02
Compare the source and extracted rows
Check long descriptions, negative amounts, decimal places and continued tables. Correct a field or table cell in the document review screen.
- 03
Export, reconcile and use
Check the item sum against the invoice subtotal. Add the invoice charges once, then compare with the printed total. Use your team’s rules for rounding and discounts.
OPEN IT. FILTER IT. CHECK THE MATH.
A real workbook.
A clear example.
Explore three fictional supplier invoices and six item rows. See how the invoice register and item sheet work together without repeating bill totals.
- Line amounts calculated from quantity × price
- Separate freight, tax and invoice totals
- Source references and reconciliation checks
Designed sample output, not a live extraction result. All names and transactions are fictional.
Invoice line-item example
Two sheets: Invoice register and Line items. Open the source pack alongside the workbook to check each value.
Download Excel example Download matching source invoices (.zip)BEFORE YOU USE THE EXPORT
Handle the details that change the answer.
Freight and discounts
A shipping charge may appear below the item table. Keep invoice-level charges in the register. Retain a line discount in its own column if your source uses one.
Credits and adjustments
Identify credit notes separately. Keep the document’s sign convention clear and check the net effect before you combine credits with invoices in a report.
YOUR QUESTIONS, ANSWERED
More than copying
a PDF table.
Can I extract line items from different supplier layouts?
Yes. Configure the item columns you need, then test invoices from several suppliers. Compare wrapped descriptions, quantities, units and totals with each source before you export the full batch.
What about a table that continues onto another page?
DigiParser supports long tables. For a difficult invoice, check that the first and last rows of every page are present and that repeated column headings have not become item rows. Advanced table extraction is available in the parser settings.
Can I include PO numbers, supplier SKUs or project references?
Add a document field for a reference that applies to the whole invoice, or an item column when it differs by row. Capture a code that is printed on the invoice. A code that you assign internally needs your own mapping rules.
Should I put invoice tax on every item row?
Keep invoice-level tax, freight and discounts in the invoice register. Only use item-level tax when the source provides it. If you need to allocate invoice charges to items, use a separate calculation and make the allocation rule clear.
Does the example workbook convert my documents?
No. The workbook shows a designed output using fictional invoices. Get started for free to upload your own files in DigiParser, configure the fields, review the result and export your data.
Can I use the data for a supplier price comparison?
Yes, after you check that the items and units are comparable. A box of 100 and a single item are different units. Keep the original supplier SKU and unit, then add your own normalized item code or unit price in a separate column.