Core-Mark Invoice to Excel for Convenience Stores and QuickBooks

Upload Core-Mark invoices as PDFs, emailed copies or phone photos of the delivery paperwork, and every line comes back as a spreadsheet row: item number, UPC, description, pack, quantity, unit cost, deal and extension. A tobacco, candy, beverage and grocery delivery that runs for pages becomes one sheet you can sort by category.

Reads Core-Mark PDFs, emailed invoices, delivery copies, credit memos and phone photos with no EDI setup.

Drop in a Core-Mark invoice

Compare the extracted fields and line items against your own document.

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your invoices

The short answer

To convert a Core-Mark invoice to Excel, upload the PDF, the emailed copy or a photo of the delivery invoice to InvoiceExtraction and export XLSX or CSV. Each line becomes one row with item number, UPC, description, pack, quantity, unit cost, deal and extended price, and credits come out as separate negative rows. It works without EDI, so a single store can use it. Plans start at $49 a month, or $24 a month billed yearly, with no per-location fee.

What every Core-Mark invoice line becomes

Item number and UPC as text

Item numbers and UPCs stay in text columns exactly as printed, so leading zeros survive and the same product matches across every delivery.

Pack notation split out

Case packs such as 12 count or 24 count sit in their own columns, so cost per unit is one formula before you set the shelf price.

Category per line

Cigarettes, other tobacco, candy, snacks, beverages and grocery lines carry a category, so margin can be checked the way your store is laid out.

Taxes and fees apart

Tax and fee lines come out as their own rows instead of being buried in the invoice total, so cost of goods stays clean.

Credits and shorts apart

Short shipments, returns and credits come out as their own negative rows, so they never hide inside the total.

Excel, CSV or QuickBooks

One combined file for the week, or bills sent to QuickBooks on the Plus plan with the invoice image attached.

Core-Mark invoice to spreadsheet in four steps

  1. 1

    Get the invoice

    Save the PDF from your Core-Mark account or email, or photograph the delivery invoice that came with the order.

  2. 2

    Upload the week

    Core-Mark and your other suppliers can go in one batch. Each document is read on its own, with no templates.

  3. 3

    Review flagged lines

    Lines are summed against the invoice total. Anything that does not tie, such as a faded photo, is highlighted.

  4. 4

    Export

    Download XLSX or CSV with one row per item, or send bills to QuickBooks with vendor, dates and line amounts filled in.

Staff member checking a delivery invoice against cases in a stockroom

Convenience store margins are decided line by line

A c-store sells thousands of low-priced items, and distributor cost moves on cigarettes, candy and drinks all the time. If invoices stay as PDFs, the shelf price update happens late or never, and the difference comes straight out of margin.

Converting each Core-Mark delivery when it lands gives you cost by item over time. Sort by item and date and you see the week a case cost moved, which deal ended and which short shipment was never credited.

Convert a Core-Mark invoice

How do I convert a Core-Mark invoice to Excel?

Upload the Core-Mark invoice PDF, the emailed copy or a photo of the delivery invoice, then export XLSX or CSV. The header (invoice number, date, account and ship-to) is read once and repeated on every row, and each line is split into item number, UPC, description, pack, quantity, unit cost and extended price. Lines are checked against the invoice total before the file is built, so the sheet you download ties out.

A generic PDF to Excel tool copies the page layout, which on a dense distributor invoice usually means description and pack in one cell and numbers shifted between columns. Here every item is a row and every number sits in a number cell, ready for a lookup against your point of sale item list.

Do I need EDI to get Core-Mark invoice data into a spreadsheet?

No. Large chains receive Core-Mark invoices as EDI 810 files, which need a translator and a mapping project before they reach a spreadsheet. A single store or a small group usually gets a PDF or a paper copy instead, and reading that document directly avoids the setup. If you already receive electronic files, a PDF copy of the same invoice still goes through here the same way.

Sample rows from a Core-Mark invoice export

A single delivery mixes tobacco, candy and beverage lines. These sample rows show how they come out, with the category column that lets you total each one separately.

Line on the invoice Pack Qty Unit cost Extension Category
Chocolate bar, king size 24 CT 2 $26.40 $52.80 Candy
Energy drink, 16 oz 12 CT 4 $21.60 $86.40 Beverage
Potato chips, 2.5 oz 28 CT 1 $24.50 $24.50 Snacks
Cigarette carton 10 PK 5 $68.00 $340.00 Tobacco
Credit, short shipped item 1 CS -1 $26.40 -$26.40 Credit

Core-Mark and your other suppliers in one cost sheet

Most c-stores buy from Core-Mark plus a beer and soda route, a bread vendor and a warehouse club for the gaps. The Jetro receipts converter and the Costco Business Center converter export into the same columns, so a week of mixed deliveries becomes one sheet you can total by category, supplier or item.

For every other supplier at the back door, the invoice scanner covers the rest, and the invoice to Excel converter handles any document that is not on a vendor page.

Who uses a Core-Mark invoice converter

Independent convenience store and gas station owners and small chains that buy from Core-Mark, and the bookkeepers who keep their books and need each invoice split by line and category rather than posted as one lump sum.

  • Cost history by item, so a case cost change shows up on the next order.
  • Spend by category for margin reviews.
  • Credits and short shipments checked against the statement.
  • Cost by store for owners with more than one location.
  • A month of invoices that ties to the supplier statement before you pay it.

Can I import Core-Mark invoices into QuickBooks?

Yes. Export a CSV in the shape QuickBooks expects, or use the QuickBooks export on the Plus plan, which creates bills with vendor, invoice number, invoice date, due date and line amounts, with the invoice image attached. Most bookkeepers post distributor invoices as bills, split across tobacco, merchandise and beverage cost of goods accounts. The QuickBooks AP automation page covers the bill workflow.

How much does a Core-Mark invoice converter cost?

You pay for pages processed, not per invoice, supplier or location. Starter is $49 a month ($24 a month billed yearly) for up to 500 pages on the most accurate model or 2,500 on the faster one. Plus is $149 a month ($74 billed yearly) and adds bulk upload of 50 files at a time, custom extraction templates, category normalization, QuickBooks export and three seats. Full details are on the pricing page.

Frequently asked questions

Upload the Core-Mark invoice PDF, the emailed copy or a photo of the delivery invoice and export XLSX or CSV. Each line becomes a row with item number, UPC, description, pack, quantity, unit cost and extended price, and the invoice number and date repeat on every row.

No. The tool reads the PDF or photo of the invoice directly, so a single store or small group does not need an EDI translator or a mapping project.

Yes. Credit and short shipment lines are extracted as separate negative rows, so returns and shorts never inflate your cost of goods.

Yes. Invoices from Core-Mark and any other supplier are read without templates and land in the same columns, so a week of deliveries can go in one batch and come out as one combined file.

Plans start at $49 a month, or $24 a month billed yearly, for up to 500 pages on the most accurate model. Pricing is by pages processed across all suppliers and locations, with no per-location or per-vendor fee.

No. Your invoices are processed only to create your export and are never shared with other customers or with the suppliers whose documents you upload.

Run your own invoices through it

Upload a few of your least tidy supplier invoices and compare the extracted fields against the documents. That tells you more than any feature list.