How to turn a supplier invoice PDF into a priced Excel sheet
Converting the invoice is only the first step. What a shop really needs is the next one: unit costs and selling prices.
· 6 min read
Every delivery comes with an invoice, and every invoice has to end up in the spreadsheet you price from. For most shops, wholesalers and restaurants that still means typing it in: product, pack size, price, line after line. A 90-line invoice can take an hour, and one wrong digit changes a selling price you will charge for months.
Why copy and paste from a PDF doesn't work
A PDF stores words where they are drawn on the page, not in rows and columns. Paste it into Excel and the columns run together, long descriptions break across two lines, and the totals land in the middle of your products. Free PDF-to-Excel converters fix the layout, but they stop there: you still get the invoice's columns, not your price sheet.
What you actually need from an invoice
The conversion is not the goal. The goal is the price on your shelf. From each invoice line you need:
- the product name, exactly as the supplier writes it, so the next invoice matches;
- the pack size, such as 24 × 100 g, to turn a case price into a unit cost — see case price vs unit cost;
- the price, and a check that every line adds up to the invoice total;
- your own columns next to it: transport, markups and the selling prices for each kind of customer.
The three steps, by hand or automatically
- Read the lines. Take every product line with its quantity, pack and price. Check the sum against the invoice total, so no line is missing.
- Work out the unit cost. Divide the case price by the units in the case, and add your share of transport — see adding transport to product costs.
- Apply your markups. One formula per price list: retail, wholesale, restaurant. Mixing up markup and margin here is the most expensive mistake — see markup vs margin.
How SAMZY does it
In SAMZY you click New from invoice and choose the PDF. SAMZY reads every product line, in any language, and checks the lines against the invoice total. You pick one of your own sheets as the template, and the invoice's products go into a new Smart Sheet with your headers, your formulas and your markups already applied. Case prices are divided by the pack size, so the item cost is per unit.
You review everything before the sheet is created, and the PDF is read on your device: it is not uploaded. Once the sheet exists, SAMZY compares it with the supplier's previous invoice, so you also see which prices went up.
SAMZY reads PDFs made by a supplier's system (with selectable text). Scanned or photographed invoices are not supported yet.
Também em português: como converter faturas PDF para Excel.
Questions
- Can I convert a supplier invoice PDF to Excel for free?
- Yes. Free converters turn a PDF into a spreadsheet, but you still have to move the data into your price sheet and work out unit costs and selling prices. SAMZY does those steps too, using your own template.
- Does it work with invoices in other languages?
- Yes. SAMZY recognises invoice columns in English, Portuguese, Spanish, French, German, Italian and Dutch, such as Omschrijving, Designação or Bezeichnung.
- Is my invoice uploaded anywhere?
- No. SAMZY reads the PDF in your browser. Only the sheet you create is saved to your account.
