How to extract prices from delivery dockets
Price creep is rarely announced. It arrives a few cent at a time on dockets nobody reads, and is only visible once the figures sit in a column you can sort.
Extract prices freeEncrypted files
Protected in transit and at rest
Private to your account
Never used to train AI models
Payments by Stripe
We never store your card number
Test before you buy
Check accuracy on your own docket
Which price fields matter
Unit price is the one to track over time. Line total is the one to check arithmetic against. Discount and VAT decide what you actually owe. Keeping all four in separate columns is what lets you answer 'has this gone up?' in a few seconds rather than an afternoon.
- Unit price, before and after discount where both are shown
- Line total, useful as a check on quantity times price
- Discount percentage or net price per line
- VAT rate or amount, where the docket carries it
Why prices are harder to read than quantities
Price columns sit tight against each other, use currency symbols inconsistently, and often run to three or four decimal places for bulk goods. A converter that returns them as text leaves you with a column that won't add up — and a comma used as a decimal separator quietly turns 1,50 into 150.
Getting clean, comparable figures
Each price column is classified by what it holds rather than by its heading, and values are returned as numbers with the currency stripped. Because the column layout is the same for every supplier, two dockets months apart line up without any reformatting.
- Currency symbols removed, decimals preserved
- Discount and net price kept apart from list price
- Totals and footer rows excluded from the data
- Same headings across suppliers so sheets can be stacked
What to do with the numbers
Match on product code between an old and a recent docket to see every change in unit price. Check line totals against quantity times price to catch arithmetic errors. And compare docket prices against the invoice before it's paid, which is the only point at which a query is cheap to raise.
Frequently asked questions
- What if the docket shows no prices at all?
- Many dockets don't. You still get the quantities and product codes, which can be priced against your agreed price list or the supplier's invoice.
- Are discounts picked up?
- Where a discount percentage or a net price is shown on the line, it comes through in its own column rather than being folded into the unit price.
- Is VAT separated?
- Where the docket shows a VAT rate or a VAT amount, it is kept as its own field. Many dockets show net figures only, with tax applied at invoice stage.
- Can I compare prices between two dates?
- Yes. Convert both dockets and match on product code — differences in unit price then stand out in a single column of your own making.
- Are prices returned as numbers or text?
- As numbers, with the currency symbol stripped out, so arithmetic and conditional formatting work without cleaning the column.
Stop re-typing paperwork
Check accuracy on your own test document free within 7 days. No card needed, no automatic charge.
Get started