Download your Johnson Brothers invoices from JB Hub, forward the emailed PDFs or photograph the signed delivery copy, and every wine, spirits and beer line comes back as a spreadsheet row with item number, description, size, cases, bottles, unit price and extended price. Pour cost, shelf margins and the bookkeeper's monthly file stop depending on someone retyping invoices.
Reads JB Hub PDFs, Maverick portal invoices, credit memos, scans and phone photos of delivery tickets.
Compare the extracted fields and line items against your own document.
Upload your invoices
Drop files here or click to upload
Up to 50 files
Uploading...
The short answer
To convert a Johnson Brothers invoice to Excel, download the PDF from JB Hub (the distributor's customer portal) or use the emailed copy or a photo of the paper ticket, upload it to InvoiceExtraction and export XLSX or CSV. Every product line becomes one row with item number, description, bottle size, cases, loose bottles, unit price and extended price, checked against the invoice total. Plans start at $49 a month, or $24 a month billed yearly, priced by pages rather than by store or bar.
Liquor stores get cost per bottle next to each line, ready to compare with the shelf price and see margin by brand before the next order.
A line of two cases plus three bottles lands in two numeric columns, so counts and cost per bottle stay right.
Johnson Brothers item codes keep their leading zeros, so a lookup against your POS or inventory sheet matches every time.
Keg and bottle deposits, delivery charges, discounts and credit memos are separated instead of being folded into a unit price.
Invoice number, date, account number and ship-to repeat on each line, so a city with two liquor stores or a group with four bars can pivot by location.
Line amounts are added up against the invoice total before export, and any gap is flagged for you instead of guessed.
Download them from JB Hub or your Maverick state portal, save the emailed PDFs, or photograph the signed delivery copy flat on the counter.
Johnson Brothers, Southern Glazer's, Breakthru, beer wholesaler and food invoices can share one batch.
On liquor invoices that is usually a split case, a deposit or a credit memo.
One file with a row per line for cost and margin work, or bills sent to QuickBooks on the Plus plan.
Wine and spirits prices move with monthly programs, and the deal your rep quoted only matters if it is on the invoice. When each Johnson Brothers invoice is a set of rows, you can sort by item and date, see what you really paid per bottle this month and fix a menu or shelf price before the margin is gone.
Most bars and stores also buy from a second wine and spirits house. The Southern Glazer's invoice to Excel converter and the Breakthru Beverage invoice converter export into the same columns, so a full beverage month sits in one workbook.
Convert a Johnson Brothers invoiceUpload the Johnson Brothers invoice as a PDF or photo and download XLSX or CSV. The header (invoice number, invoice date, account number, ship-to and terms) is read once and repeated on every row, and each product line is split into item number, description, size, cases, bottles, unit price and extended price. Lines are totaled against the invoice before export, so a missed deposit or credit shows up right away.
Copying from the PDF or using a general PDF to Excel tool tends to produce merged cells, page headers in the middle of the data and deposit lines glued to the wine above them. That is tolerable for one invoice and a lost afternoon for a month of deliveries.
Johnson Brothers customers use JB Hub, the company's customer portal, for 24/7 online ordering and for access to invoices, payment history and credit details, with ACH payments in the same place. Accounts served by Johnson Brothers Maverick use the Maverick portal for their state, which covers Arizona, Colorado, Florida and Texas. Many accounts also get invoices by email.
If you need older invoices that are no longer online, the customer accounts team for your state can send PDF copies. Those files, a scanner copy or a phone photo of the signed ticket all convert the same way here.
This is how a few typical lines come out. Descriptions and pack formats differ by state and by wine, spirits or beer division, but the columns stay fixed, which is what makes month over month price checks work.
| Line on the invoice | Size | Cases | Bottles | Unit price | Cost per bottle |
|---|---|---|---|---|---|
| Vodka, 1 cs | 1.75L | 1 | 0 | $162.00 per case | $27.00 |
| Cabernet Sauvignon, 2 cs | 750ml | 2 | 0 | $144.00 per case | $12.00 |
| Rye whiskey, 3 btl | 750ml | 0 | 3 | $31.50 per bottle | $31.50 |
| Bottle deposit | n/a | n/a | n/a | Separate line | Kept on its own row |
In Minnesota and other Midwest states a lot of Johnson Brothers volume goes to off-sale stores, including city-owned municipal liquor stores that report to a finance director and a council. Those stores need two things from every invoice: the cost per bottle to set shelf prices, and a clean record of what was bought for the city's books and audits.
With each invoice exported as rows, the store manager can join cost per bottle to the POS price list and spot thin margins, and the finance office gets a monthly file of vendor, invoice number, date, amount and line detail instead of a stack of PDFs. Pricing is by pages, so a second store or a busy holiday month does not change the plan.
The invoice total tells you what to pay. The lines tell you why beverage cost moved.
Yes. Export a CSV shaped for a QuickBooks bill import, or use the direct QuickBooks export on the Plus plan, with vendor, invoice number, date, due date and line amounts filled in and the PDF attached. Map liquor, wine, beer and deposits to their own accounts once and every delivery posts the same way. For approvals and payment workflow see QuickBooks AP automation.
You pay by pages processed, not per store, bar or distributor. 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, enough for several busy bars or liquor stores. 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. Bar inventory suites that include invoice entry are usually priced per location per month, as our BevSpot alternative comparison shows. Plan details are on the pricing page.
Download the invoice from JB Hub or save the emailed PDF, upload it here and export XLSX or CSV. Each product line becomes a row with item number, description, size, cases, bottles, unit price and extended price, and the invoice number and date repeat on every row.
JB Hub is the Johnson Brothers customer portal for 24/7 online ordering, the product catalog, invoices, payment history, credit details and ACH payments. Invoices downloaded from it convert directly here.
Yes. Invoices from the Maverick state portals in Arizona, Colorado, Florida and Texas are read the same way as JB Hub invoices and export into the same columns.
Yes. Cases, bottles and bottles per case are separate columns, and a cost per bottle is calculated for each line, so you can compare it with your shelf price in the same sheet.
Yes. Southern Glazer's, Breakthru, beer wholesaler and food invoices are read without templates and exported into the same columns, so all purchasing sits in one file.
No. Your invoices are processed only to produce your export and are never shared with other customers or with the distributors whose documents you upload.
Convert Southern Glazer's invoices from Proof to Excel or CSV line by line. Item, cases, bottles, bottles per case and cost per bottle for bars and restaurants.
Convert Breakthru Beverage invoices to Excel or CSV line by line. Wine, spirits and beer items with cases, bottles and cost per bottle for bar pour cost.
Restaurant invoice scanner that turns Sysco, US Foods and every supplier invoice into Excel, CSV or QuickBooks lines with item, pack, weight and price.
Convert Ben E. Keith invoices from Entree to Excel or CSV line by line. Item number, pack, catch weight and extended price for food cost and QuickBooks.
Convert Sysco invoices to Excel line by line: item code, pack size, quantity, unit price and extended price from Sysco, US Foods and GFS PDFs, ready for food cost.
Convert PDF invoices to Excel or CSV with every line item in its own row. Batch upload PDFs, scans and photos, keep invoice numbers intact, export to QuickBooks.
How AP automation works with QuickBooks Online and Desktop: how bills enter the file, how vendors are matched, how expense coding and class tracking are applied, and where QuickBooks stops being enough.
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.
