Invoice extraction guides
From invoice files
to data you can use.
Practical workflows for capture, review, and CSV export. Find a specific problem, compare worked examples, or run a small browser-based check.
Choose your next step
100 pages · Worked examples, worksheets & 8 tools
100 pages available
Export
How to extract PDF invoice data into Excel
A practical route from a PDF invoice to spreadsheet columns, with an import checklist that protects identifiers and dates.
Read guide →ExportInvoice to CSV: choose columns and avoid broken imports
Understand the CSV itself: column design, quoting, missing values, and a sample file you can import.
Read guide →Capture
Scanned invoice data extraction: prepare readable files
A scan preparation and troubleshooting guide for invoice PDFs, images, and phone photos.
Read guide →CaptureBuild an invoice extraction schema with clear field descriptions
A field dictionary and description examples for a reusable invoice schema, including missing-value handling.
Read guide →CaptureInvoice line item extraction: preserve rows and reconcile totals
Separate invoice headers from repeated item rows and test whether the exported structure meets your needs.
Read guide →Workflow
Batch invoice processing: reconcile files, results, and exports
A controlled batch workflow that accounts for successful files, failures, retries, and exported rows.
Read guide →WorkflowInvoice extraction for bookkeepers: a repeatable client workflow
A client-by-client intake and handoff method that keeps extraction, review, and accounting import traceable.
Read guide →Review
Invoice data validation: a checklist before spreadsheet import
A source-to-output checklist and arithmetic example for reviewing extracted values before use.
Read guide →ReviewInvoice date and currency formats: normalize without guessing
A raw-versus-reviewed mapping for dates and amounts, with clear rules for unresolved ambiguity.
Read guide →ReviewHow to test invoice OCR accuracy on your own documents
A reproducible pilot scorecard that measures field errors and review effort instead of relying on a headline accuracy claim.
Read guide →Field references
Invoice number vs PO number: which reference should you extract?
Keep the supplier’s invoice identifier and the buyer’s purchase-order reference in separate fields.
Read guide →Field referencesInvoice date vs due date: keep issue and payment dates separate
The invoice date records when the document was issued; the due date is a separately stated payment deadline.
Read guide →Field referencesInvoice total vs amount due: extract both without double counting
An invoice can show the full charge and a different remaining balance after a deposit, payment, or credit.
Read guide →Field referencesSupplier vs bill-to customer: avoid extracting the wrong company
The supplier issues the invoice; the bill-to party is the customer receiving it.
Read guide →Field referencesShipping address vs billing address on an invoice
Billing and delivery addresses describe different roles, even when the street text is identical.
Read guide →Field referencesExtract invoice payment terms without inventing a due date
Capture payment terms as the wording printed on the invoice, including any discount condition or starting event.
Read guide →Field referencesIdentify invoice currency when symbols and codes disagree
Capture the explicit currency code where the document provides it, and retain the original symbol as evidence when it does not.
Read guide →Field referencesInvoice tax amount vs tax rate: choose the right field
A tax rate is a percentage; a tax amount is a monetary value.
Read guide →Field referencesExtract invoice discounts at header and item level
Record whether a discount belongs to one item, the whole invoice, or a conditional payment offer.
Read guide →Field referencesExtract freight and delivery charges from invoice summaries
Capture a delivery charge according to where and how it is printed.
Read guide →Line items
Quantity, unit price, and line total: review invoice row alignment
Keep quantity, pricing basis, unit price, and printed line amount attached to the same description.
Read guide →Line itemsExtract invoice units of measure without changing quantities
Keep the quantity’s unit and the unit-price basis visible.
Read guide →Line itemsExtract invoice SKUs and part numbers as text
Treat a printed SKU or part number as an identifier.
Read guide →Line itemsHandle wrapped invoice descriptions without inventing extra items
A description can occupy several printed lines while representing one billed item.
Read guide →Line itemsReview invoice item tables that continue onto another page
Review the end of one page and the start of the next as a single table boundary.
Read guide →Line itemsReview discounted invoice line items without applying the discount twice
Establish whether the printed unit price is gross or already discounted.
Read guide →Line itemsTax-inclusive invoice line items: keep net and gross labels
A printed item amount may include tax or exclude it.
Read guide →Line itemsSeparate shipment charges within a freight invoice
A freight invoice can contain several charge types for a shipment.
Read guide →Line itemsExtract negative invoice line items and returns
Preserve the sign and description of a negative row.
Read guide →Line itemsRemove repeated invoice table headers from extracted item rows
A repeated Description / Quantity / Amount header is table structure, not a purchased item.
Read guide →Document types
Credit note data extraction: retain the original invoice reference
Capture a credit note as its own document, keeping its number, the invoice reference it adjusts, and the printed amount.
Read guide →Document typesDebit note data extraction: record issuer and adjustment context
Capture the document title, issuer, reference, and stated adjustment before deciding how a debit note should affect another record.
Read guide →Document typesProforma vs final invoice: classify the source before extraction
Retain the printed document title when an intake set contains proforma and final invoices.
Read guide →Document typesInvoice vs supplier statement: avoid counting charges twice
A supplier statement can summarize invoices, credits, and payments already represented by other documents.
Read guide →Document typesReceipt vs invoice data: preserve document and payment evidence
Keep a receipt’s payment evidence separate from the invoice’s charge information.
Read guide →Document typesPurchase order vs invoice data: prepare separate records for matching
A purchase order and an invoice describe different stages of a transaction.
Read guide →Document typesRecurring invoice extraction: distinguish each billing period
Keep the invoice number, issue date, and service period for each recurring bill.
Read guide →Document typesExtract partially paid invoices without replacing the original total
Preserve the invoice total, payments shown, and remaining balance as separate facts.
Read guide →Document typesDeposit invoice data extraction: distinguish request, payment, and final charge
Record whether the document requests a deposit, acknowledges one, or applies a deposit to a final invoice.
Read guide →Document typesPrepare a PDF containing several invoices before extraction
Separate unrelated invoices into individual files before a workflow that returns one result per uploaded file.
Read guide →Scan preparation
Prepare phone photos of invoices for data extraction
Photograph the whole invoice with the camera parallel to the page, steady focus, and even lighting.
Read guide →Scan preparationFix rotated and skewed invoice scans before reviewing extraction
Correct obvious orientation and inspect skew when a table’s columns are difficult to follow.
Read guide →Scan preparationBlurry invoice scans: when to rescan instead of retrying extraction
If the source cannot distinguish the final digit, decimal mark, or currency symbol, request a clearer document.
Read guide →Scan preparationExtract data from faded thermal receipts without filling gaps
Capture a thermal receipt before further fading and inspect the total, date, and seller reference closely.
Read guide →Scan preparationRemove glare and shadows from invoice photos at capture time
Move the light or camera so reflections and shadows no longer cover printed values.
Read guide →Scan preparationCropped invoice edges: check missing digits and continuation text
A cropped edge can remove a sign, first digit, final column, or page number while leaving most of the invoice readable.
Read guide →Scan preparationLow-contrast invoice scans: preserve text while improving readability
Use an original digital file or a clearer rescan when pale text blends into a coloured or noisy background.
Read guide →Scan preparationHandle handwritten notes on invoices without replacing printed facts
Keep annotations separate from the printed invoice fields unless a reviewer explicitly establishes their role.
Read guide →Scan preparationPrepare a password-protected invoice PDF for extraction
If you are authorized to access the invoice, obtain an accessible copy from the sender or remove its password using the known password and an approved document tool.
Read guide →Scan preparationDigital PDF vs scanned invoice: choose the clearest source
A digital PDF can contain selectable text, while a scan can contain page images; some files contain both.
Read guide →CSV troubleshooting
Preserve leading zeros in invoice numbers when importing CSV
Import invoice identifiers as text before a spreadsheet interprets them as numbers.
Read guide →CSV troubleshootingStop invoice identifiers turning into scientific notation
Treat long invoice and account references as text from the start.
Read guide →CSV troubleshootingInvoice CSV encoding: preserve accented and non-English supplier names
Choose the file’s actual encoding in the import preview and compare names with the source.
Read guide →CSV troubleshootingInvoice CSV opens in one column: check the delimiter
If every value appears in one spreadsheet column, inspect the delimiter selected during import.
Read guide →CSV troubleshootingHandle quotation marks inside invoice CSV descriptions
A CSV field can contain a literal quotation mark when it is escaped according to the file’s quoting convention.
Read guide →CSV troubleshootingMultiline invoice CSV descriptions: count records instead of text lines
A quoted CSV field can contain a line break, so the number of physical text lines need not equal the number of records.
Read guide →CSV troubleshootingInvoice CSV formula safety: treat imported descriptions as data
Untrusted text starting with spreadsheet formula characters can be interpreted as a formula when opened in some spreadsheet applications.
Read guide →CSV troubleshootingMissing invoice CSV values: distinguish unavailable data from zero
Keep unavailable values distinct from legitimate zeros.
Read guide →CSV troubleshootingMap invoice CSV columns to a destination template
Create an explicit mapping between source column meaning and the destination’s required fields.
Read guide →CSV troubleshootingDuplicate invoice CSV column names: prevent silent overwrites
Give each column a distinct meaning and name before converting rows into records.
Read guide →Batch controls
Reconcile invoice batch retries without importing records twice
Track the original attempt, failure, retry, and accepted result for each source file.
Read guide →Batch controlsInvoice file naming conventions for traceable extraction batches
Choose stable filenames that distinguish source documents and connect them to the intake manifest.
Read guide →Batch controlsTrace invoice data from source file to reviewed export
Retain a chain linking the source document, extraction attempt, exported row, review decision, and destination reference.
Read guide →Batch controlsVersion invoice extraction schemas without breaking CSV mappings
Record which field definitions were used for each batch when you change a schema.
Read guide →Batch controlsCheck invoice export row counts against completed files
Compare logical CSV records with the completed-file list, then account for failed, held, and retried sources separately.
Read guide →Batch controlsKeep invoice reports separated by currency
Group amounts by their confirmed currency before reporting totals.
Read guide →Batch controlsBuild an invoice data review queue with clear exception owners
Separate extraction status from review status.
Read guide →Batch controlsCheck invoice document completeness before extracting data
Confirm that the file contains the entire invoice, with pages in order and readable required sections.
Read guide →Batch controlsMerge invoice CSV exports without repeating headers or records
Align columns by reviewed header meaning, keep one header row, and review overlap between source exports before appending data.
Read guide →Batch controlsChoose a representative invoice extraction pilot test set
Build a small set that reflects the invoices you actually receive, including difficult layouts and source problems.
Read guide →Industry workflows
Prepare freight invoices for extraction and shipment-level review
Separate invoice identity from shipment identity, and keep each charge type attached to the shipment it describes.
Read guide →Industry workflowsUtility bill data extraction: separate usage, charges, and balance
Keep the service period, account reference, service location, usage, current charges, and overall balance distinct.
Read guide →Industry workflowsTelecom invoice extraction: preserve recurring, usage, and one-time charges
Keep recurring plan charges, usage, device payments, adjustments, and one-time charges distinguishable when they are printed separately.
Read guide →Industry workflowsExtract software subscription invoices with seats and service periods
Preserve the subscription period, item description, seat or usage quantity, and any printed proration.
Read guide →Industry workflowsProfessional-services invoice extraction: retain hours and billing basis
Keep service dates, descriptions, hours, rates, fixed fees, and reimbursable items distinct.
Read guide →Industry workflowsConstruction progress invoice extraction: distinguish current and cumulative values
Capture column labels that distinguish current-period work, cumulative work, prior billing, retention, and current payment due.
Read guide →Industry workflowsWholesale invoice extraction: preserve item codes, packs, and returns
Retain supplier item codes, pack descriptions, quantities, price bases, and return rows.
Read guide →Industry workflowsRestaurant supplier invoice extraction: distinguish weight, cases, and credits
Keep units, quantities, actual weights, and printed row amounts attached to the correct ingredient or supply item.
Read guide →Industry workflowsEquipment rental invoice extraction: keep period, rate, and deposit separate
Record the rental period, equipment reference, billing unit, charge, and any deposit or extra fee under their printed roles.
Read guide →Industry workflowsPrinting invoice extraction: separate run quantity and setup charges
Keep the print job reference, run quantity, price basis, setup, finishing, and delivery charges distinguishable.
Read guide →Review checks
Reconcile invoice subtotals with printed adjustments
Compare the printed item amounts, discounts, additional charges, and tax presentation with the source summary.
Read guide →Review checksReview invoice rounding differences without hiding mismatches
Retain printed values at their displayed precision and calculate differences separately.
Read guide →Review checksReview repeated invoice numbers across suppliers and versions
Treat repeated invoice numbers as duplicate candidates in context, not automatic deletion instructions.
Read guide →Review checksMissing PO number on an extracted invoice: locate the cause
Determine whether the purchase-order reference is absent, unreadable, mislabelled, or missed by extraction.
Read guide →Review checksReview ambiguous invoice dates with a documented decision
Keep an ambiguous numeric date unchanged until evidence resolves its meaning.
Read guide →Review checksCheck invoice amount signs before combining credits and charges
Review the document type, printed sign, and column meaning before producing a normalized signed amount.
Read guide →Review checksExtract invoices with multiple printed tax rates
Preserve each tax-summary row’s labelled base, rate, and amount rather than forcing all details into one percentage field.
Read guide →Review checksOrder date vs invoice date: extract the date attached to the right event
Keep order, dispatch, service, and invoice dates under distinct names when they appear on the same document.
Read guide →Review checksAccount number vs invoice number: keep persistent and document references separate
An account number can identify a continuing customer relationship, while an invoice number identifies a specific billing document.
Read guide →Review checksCapture invoice bank details without treating extraction as verification
Transcribing printed bank details does not establish that they are authentic, current, or authorized for payment.
Read guide →Spreadsheet import
Import an invoice CSV into Google Sheets and check the result
Use Google Sheets’ file-import workflow, select the matching separator, and inspect the resulting columns before using the data.
Read guide →Spreadsheet importImport invoice CSV data with Excel Power Query
Use Power Query’s Text/CSV connector to preview the delimiter, encoding, headers, and data types before loading an invoice export.
Read guide →Tools
Invoice CSV to JSON converter: preserve identifiers as strings
Convert a small invoice CSV into JSON records without guessing dates, amounts, or identifier types.
Read guide →ToolsInvoice CSV to TSV converter for simple flat tables
Convert a reviewed CSV table to tab-separated text while retaining field values and refusing multiline cells.
Read guide →ToolsInvoice CSV header checker: find collisions and uneven records
Check CSV structure for blank headers, duplicate column names, and records with the wrong field count.
Read guide →ToolsInvoice total checker: compare printed amounts with a separate calculation
Add line amounts, subtract a discount, add charges and tax, and compare the result with a printed total.
Read guide →ToolsInvoice CSV completeness checker for required fields
Find records missing the fields you specify, while keeping legitimate zero values present.
Read guide →ToolsInvoice batch manifest checker: compare expected and exported filenames
Compare two filename lists in CSV form and identify missing, unexpected, or repeated source references.
Read guide →ToolsInvoice review time calculator: compare your own workflow estimates
Compare manual handling time with a proposed extraction-and-review workflow using your own inputs.
Read guide →ToolsInvoice duplicate candidate finder for CSV review
Group records by the key columns you choose without automatically deleting anything.
Read guide →Start with a small invoice sample.
Define your fields in Parzable and review the output against your source.