Messy2Sheet workflow

Invoice OCR.

Run invoice OCR on readable invoice photos, scans, PDFs, or screenshots.

CSV rows
6
CSV columns
11
Total row
£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 invoice photo to OCR CSV

A public Parcelforce import charge invoice photo becomes a CSV with visible charge rows, totals, payment notes, and review boundaries.

6 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 private fields and parcel references left unguessed
Download
Proof from a public invoice photo

A public invoice photo becomes 6 reviewable OCR rows.

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

6
CSV rows
11
CSV columns
£48.74
Total row
2722 x 3994
Source photo

OCR CSV preview from the Parcelforce invoice photo

These rows come from the public invoice photo. The CSV keeps OCR-visible charges and the total row, while private or unclear fields remain out of scope.

charge_labelamountcurrencyis_totalsendercountry_of_originpayment_url
Customs Duty£0.00£falseParcelforce WorldwideUNITED STATES OF AMERICAwww.parcelforce.com
Excise Duty£0.00£falseParcelforce WorldwideUNITED STATES OF AMERICAwww.parcelforce.com
Import VAT£36.74£falseParcelforce WorldwideUNITED STATES OF AMERICAwww.parcelforce.com
Clearance Fee (zero rated for VAT)£12.00£falseParcelforce WorldwideUNITED STATES OF AMERICAwww.parcelforce.com
Total£48.74£trueParcelforce WorldwideUNITED STATES OF AMERICAwww.parcelforce.com

Source context

The source file, document type, sender, and country of origin stay attached to each row so reviewers can trace the OCR result back to the photo.

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

Charge rows

Each visible charge in the invoice table becomes a row, including zero-amount rows and the final total row.

Customs DutyImport VATClearance FeeTotal

Visible values

Amounts and currency are preserved exactly as visible in the photo instead of being normalized into a guessed accounting format.

£0.00£36.74£12.00£48.74

OCR boundary

Recipient, address, parcel reference, tax advice, approval state, and payment completion are not invented from the blurred or missing parts of the source.

no private fields guessedno tax advicereview_note
Invoice photo vs OCR CSV

Raw OCR text

OCR text alone can read parts of the invoice but still leaves the charge table, payment note, and total row for manual cleanup.

  • Charge labels mixed with paragraphs
  • Payment instructions copied as text
  • Blurred fields may look tempting to guess

Reviewable OCR CSV

Messy2Sheet uses the requested columns to turn the visible OCR result into checkable rows.

  • One row per visible charge
  • Total row explicitly flagged
  • Private or unclear fields left unguessed
Extraction details

What invoice OCR needs to keep.

Invoice OCR is useful when recognized text becomes structured rows and the output makes unclear fields visible instead of guessing them.

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.

OCR to fields

Turn recognized text into invoice fields

OCR text still needs invoice logic. Supplier names, invoice numbers, dates, tax, totals, and line items should land in separate fields, not one text block.

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 invoice PDF, scan, screenshot, or pasted invoice text needs structured CSV rows.

Invoice OCR 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 Invoice OCR inputs

  • Readable invoice PDF, scan, 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 invoice ocr 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 Invoice OCR 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 invoice OCR layout for repeat invoice scans.

Start from the real file

Upload an invoice PDF, scan, 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 Invoice OCR do?+

Invoice OCR reads invoice text and organizes supplier, invoice number, dates, line items, tax, totals, and terms into Excel or CSV.

Does OCR quality matter?+

Yes. Clear printed text works best. Handwriting, stamps, glare, and cut-off totals need manual checking.

Can it extract line items?+

Yes. Ask for line item, quantity, unit price, tax, total, and notes fields when line items are visible.

Can I review OCR results before export?+

Yes. Check unclear fields, invoice totals, and item rows before downloading Excel or CSV.

Can I reuse invoice OCR rules?+

Yes. Save the layout for repeated invoice scans or similar vendor formats.

Try it on one real file.

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

Start