Messy2Sheet workflow

OCR Invoice Scanning.

Use OCR invoice scanning when the source is a photo, scan, or image-based PDF.

CSV rows
6
CSV columns
11
Visible total
£48.74
Try one file

Start with the file you already have.

Upload or paste the source, then check the workbook before export.

Create the sheet

Upload or paste the source. The cleanup rule is loaded.

  1. 1Source
  2. 2Instructions
  3. 3Create
Source
Loaded rule

Map fields, clean rows, and keep review notes.

Preview the workbook before export.

Real sample

Sample scanned invoice to CSV

A public Parcelforce import charge invoice photo becomes OCR CSV rows with visible charge labels, amounts, total flag, payment URL, and review notes.

6 OCR CSV rows with 11 review columns
Customs Duty, Excise Duty, Import VAT, Other, Clearance Fee, and Total rows
Sender, country of origin, payment URL, and visible amounts preserved
Blurred recipient and parcel reference fields left unguessed
Download
Proof from a public scanned invoice

A public scanned invoice becomes 6 OCR CSV rows.

This OCR invoice scanning sample uses a public Wikimedia Commons photo of a Parcelforce import charge invoice. The output keeps six visible charge rows, the total row, sender, country of origin, payment URL, payment note, and review boundaries in CSV columns.

6
CSV rows
11
CSV columns
£48.74
Visible total
2722 x 3994
Scan size

OCR invoice scanning CSV preview

These rows come from the public scanned invoice photo. The preview shows the checkable CSV output before download.

source_filesendercharge_labelamountcurrencyis_totalreview_note
parcelforce-import-charge-invoice.jpgParcelforce WorldwideCustoms Duty£0.00£falseVisible zero amount kept
parcelforce-import-charge-invoice.jpgParcelforce WorldwideExcise Duty£0.00£falseVisible zero amount kept
parcelforce-import-charge-invoice.jpgParcelforce WorldwideImport VAT£36.74£falseVisible charge amount kept
parcelforce-import-charge-invoice.jpgParcelforce WorldwideOther£0.00£falseVisible zero amount kept
parcelforce-import-charge-invoice.jpgParcelforce WorldwideClearance Fee (zero rated for VAT)£12.00£falseVisible clearance fee kept
parcelforce-import-charge-invoice.jpgParcelforce WorldwideTotal£48.74£trueTotal row marked true

Scanned source context

The source photo context stays on each row so a reviewer can trace every charge back to the scanned invoice.

parcelforce-import-charge-invoice.jpgParcelforce WorldwideUNITED STATES OF AMERICA

OCR charge rows

Each visible line in the scanned charge table becomes a CSV row, including zero-amount rows and the final Total row.

Customs DutyExcise DutyImport VATClearance FeeTotal

Scanned values

The visible amounts and currency stay separate from labels so spreadsheet review can filter, audit, or export the result.

£0.00£36.74£12.00£48.74is_total

Scanning boundary

Blurred recipient fields, parcel references, dates, tax advice, approval state, and payment completion are not guessed from the scan.

no private fields guessedno tax advicereview_note
Scanned invoice photo vs OCR CSV

Scanned invoice

A scanned invoice photo may be readable, but OCR text still leaves charge labels, totals, payment notes, and blurred fields mixed together.

  • Photo text is not row data
  • Payment note is mixed with body copy
  • Blurred fields must not be guessed

OCR scanning CSV

Messy2Sheet uses the requested columns to turn the readable scan into CSV rows that finance or operations can review.

  • One row per visible charge
  • Total row explicitly flagged
  • Unclear fields left blank
Extraction details

What scanned invoice OCR needs to keep.

OCR invoice scanning only helps when the scanned text becomes checkable rows instead of a raw transcript.

Target fields

Set the CSV fields before extraction

Set fields such as source file, document type, sender, country of origin, charge label, amount, currency, is total, payment URL, payment note, review note. Messy2Sheet uses those fields to shape the CSV output before extraction starts.

Scan quality

Scan first, then group OCR text into fields

Scanned invoices need two steps: read the text, then group it into invoice fields. Keep quantity, unit price, tax, total, and source notes available for checking.

Check

Check the result before downloading CSV

Compare the generated rows with the source, fix unclear values, then export CSV when the table is ready.

Fit check

Use it when scanned invoice, PDF, screenshot, or pasted invoice text needs structured CSV rows.

OCR Invoice Scanning works best when the source is readable and the target fields are clear. Keep review notes when the source layout or values need human judgment.

Best OCR Invoice Scanning inputs

  • Readable scanned invoice, PDF, screenshot, or pasted invoice text where a person can identify the important values.
  • Cases where you already know the output fields: source file, document type, sender, country of origin, charge label, amount, currency, is total, payment URL, payment note, review note.
  • Sources with repeated business layouts that can become a saved workflow.
  • Files that need Excel or CSV output you can check before using.

Check before exporting CSV

  • The source is blurry, cropped, skewed, or low contrast.
  • Important values are handwritten, hidden, or missing.
  • Several unrelated layouts are mixed in one upload.
  • The result requires business decisions that are not visible in the source.
Template and workflow

Start with a ocr invoice scanning layout you can reuse.

For repeated files, set the output fields once, check one result, then reuse the saved layout for the next similar source.

Template

CSV output layout

Use a target sheet when the final CSV file needs stable fields every time.

Output fields: source file, document type, sender, country of origin, charge label, amount, currency, is total, payment URL, payment note, review note
Check fields: source page, unclear value, cleanup note
Optional fields: category, normalized label, confidence, source text
Saved workflow
Reuse

Saved OCR Invoice Scanning workflow

Save the instructions that handle repeated headings, wrapped text, missing fields, and source-specific cleanup rules.

  1. 01Keep rows in a checkable order.
  2. 02Split source text into the requested columns.
  3. 03Flag unclear cells for manual checking.
Workflow

Save this OCR invoice layout for the next scan batch.

Start from the real file

Upload a scanned invoice, PDF, screenshot, or pasted invoice text or paste source text if you already have it.

Set the fields

Use fields like source file, document type, sender, country of origin, charge label, amount, currency, is total, payment URL, payment note, review note so the generated CSV file matches the job.

Save the layout

Save the setup when the result looks right, then reuse it for similar files.

FAQ

Questions before you upload?

What does OCR invoice scanning do?+

OCR invoice scanning reads scanned invoice text and groups supplier, invoice number, line items, quantities, unit prices, tax, and total into Excel rows.

What scan quality works best?+

Flat, readable scans work best. Angled photos, glare, stamps, handwriting, and cut-off totals need manual checking.

Can it scan invoice screenshots?+

Yes, if the screenshot text is readable and invoice fields are visible.

Can I extract quantities and unit prices?+

Yes. Add quantity, unit price, line item, tax, total, and notes fields before scanning.

Can I save a scan layout?+

Yes. Save the OCR invoice fields after one result works.

Try it on one real file.

Upload the document, keep or edit the template instructions, and check the workbook before you download it.

Start