Skip to content
Open workspace
中文EspañolРусский
Home/Delivery Note PDF to Excel
Delivery / Receipt / Reconciliation

Delivery Note PDF to Excel

Turn delivery notes, PODs and goods receipts into item rows with delivered, received and exception fields.

Header and item rowsDelivered vs receivedSignature detailsShortage and damage flags
Synthetic delivery note with received quantity and exception fields
Synthetic example with delivered quantity, received quantity and exception reason kept in separate columns.
Output blueprint

Separate document identity, item rows and receipt exceptions

This structure supports review and later matching without pretending every source document has the same role.

01

Document identity

Name the source and its business role.

Document TypeDelivery Note No.PO No.Source File
02

Delivery context

Keep dates, parties and destination together.

Delivery DateSupplierShip-toReceiver
03

Item row

Preserve each product and quantity pair.

SKUDescriptionDelivered QtyReceived QtyUOM
04

Exceptions

Make operational follow-up explicit.

Shortage QtyDamage NoteRejected QtyReview Status

What makes this document hard

These are the real formatting and workflow issues teams usually run into.

01

Supplier layouts move delivery, PO, item and quantity fields to different positions.

02

Stamps, signatures and handwritten damage notes can overlap the values that matter most.

03

Header data and repeating item rows must stay related without shifting quantities between products.

How FOVATA handles it

The goal is not just conversion. The goal is structured output your team can use immediately.

Capture delivery number, PO, delivery date, supplier, destination and receiver fields.

Create one row per item and keep delivered quantity, received quantity and unit separate.

Send shortages, rejected items, damage notes and unreadable values to an exception queue.

AI Smart Extraction

Best when the source layout is inconsistent and the target output needs to follow business logic.

Excel-ready output

The point is not to mirror the source page. It is to create an output file that saves follow-up work.

Fields teams usually extract

Document TypeDelivery Note No.PO No.Delivery DateSupplierShip-toSKUDescriptionDelivered QtyReceived QtyUOMReceiverException

Teams that benefit most

Warehouse receiving
Procurement operations
Accounts payable
Retail and project sites

Recommended workflow

A practical three-step path from source file to usable Excel output.

1

Upload delivery note, proof-of-delivery or goods-receipt PDFs and scans.

2

Define header, item and exception fields, then confirm quantity units.

3

Review signatures, shortages and damage notes before exporting the receipt register.

FAQ

Can one workflow handle delivery notes, PODs and goods receipts?

Yes, but keep a Document Type column because dispatch, delivery confirmation and system receipt records serve different purposes.

Does this complete three-way matching?

The output can prepare structured PO, receipt and invoice data for matching, but it does not replace your ERP approval and matching controls.

Can handwritten delivery notes be extracted?

Readable notes can be captured, but signatures, shortages and damage conclusions should be checked against the source page.

Use this page as your first test scenario

Test a batch containing both clean deliveries and quantity exceptions to validate the review workflow.