Your POS counts bottles at the register, but the cost behind every SKU still comes from the distributor invoice, and someone has to type it. Upload the invoices and each line comes back as a spreadsheet row with case size, case price, discount, bottle cost and extended price, ready to import into your liquor store POS or margin sheet.
Reads spirits, wine and beer distributor PDFs, emailed invoices and phone photos with no templates and no per-store fee.
Compare the extracted fields and line items against your own document.
Upload your invoices
Drop files here or click to upload
3 demo documents, no account needed
Uploading...
The short answer
Liquor store inventory software tracks stock in the POS, but its margin reports are only right when bottle cost is current. InvoiceExtraction reads distributor invoices, splits each line into case size, quantity, case price, quantity discount, deposit and bottle cost, and exports Excel or CSV for the POS cost import or QuickBooks bills. Plans start at $49 a month, or $24 a month billed yearly, for every store combined.
Case size and case price come out as separate numbers, so cost per bottle is one division and the POS cost field stays true.
Quantity discounts, mixed case deals and post offs are read as separate lines, so you can spread them over the bottles they apply to.
Distributor item numbers and sizes stay in their own columns, which makes matching invoice lines to your POS SKUs a lookup instead of guesswork.
Spirits, wine, beer and mixer suppliers are read without a template built for each one, including the beer wholesaler with the handwritten delivery copy.
Broken bottles, short ships and credit memos come out as negative rows you can tick off against the statement.
One file for the POS cost import or your margin sheet, or bills in QuickBooks on the Plus plan with vendor, dates and line amounts filled in.
Save the PDFs from distributor portals and email, and photograph the paper invoices signed at the back door.
Spirits, wine and beer invoices go in together. Each one is read on its own with no layout setup.
Lines are summed against the invoice total, and anything that does not tie is highlighted before you export.
Download XLSX or CSV, match item codes to your SKUs and paste the new bottle cost into the POS or your price sheet.
Distributors change case prices monthly and run discounts that change with the quantity you buy. When the POS still holds the cost someone typed in spring, the margin report looks fine while a fast mover quietly sells below target.
Converting each invoice when it arrives keeps the cost column current. Price changes surface the week they hit, and repricing a shelf becomes a sort in a spreadsheet instead of a Saturday of typing.
Convert a liquor invoiceFour numbers per item: the distributor item code, how many units the case holds, what the case cost after discounts, and how many cases arrived. Bottle cost, margin and reorder points all come from those. A POS that counts sales but does not read invoices leaves you typing exactly these numbers for every SKU on every delivery, which in a store with a few thousand SKUs is where costs go stale.
Reading the invoice puts them in columns, checked against the invoice total, so updating cost in the POS becomes a file import or a paste.
One delivery usually mixes full cases, a quantity discount and a credit. These rows show how they come out, with bottle cost from the case price and the shelf price that keeps a target margin (price equals cost divided by one minus the margin). Round to your own price points after that.
| Line on the invoice | Case | Qty | Case price | Bottle cost | Target margin | Price at margin |
|---|---|---|---|---|---|---|
| Vodka 1.75 L | 6 | 3 | $132.00 | $22.00 | 25% | $29.33 |
| Bourbon 750 ml | 12 | 1 | $252.00 | $21.00 | 25% | $28.00 |
| Cabernet 750 ml | 12 | 2 | $96.00 | $8.00 | 33% | $11.94 |
| Lager 12 oz, 24 pack case | 4 six packs | 5 | $26.40 | $6.60 per six pack | 20% | $8.25 |
| Quantity discount, 3 case vodka | 1 | 1 | -$18.00 | -$1.00 per bottle | none | Vodka cost becomes $21.00 |
| Credit, broken bourbon bottle | 1 | -1 | $21.00 | -$21.00 | none | Credit row |
Both, for different jobs. A liquor store POS runs the register, age checks, case breaks and the stock count. Invoice reading fills the cost side that most POS systems still expect you to type, at $49 a month for all stores combined. If you already like your POS, keep it and feed it better costs. Bars and restaurants with a counting app have the same gap, covered on the bar inventory invoice entry page.
Some stores also sell to on premise accounts or run a tasting bar. The same converted rows work for both sides, because cost per bottle does not care where the bottle is sold.
The Southern Glazer's invoice converter, the Breakthru Beverage invoice to Excel page and the Johnson Brothers converter export into the same columns, so a month of mixed deliveries becomes one sheet. Beer wholesalers and local craft distributors are read the same way, without a template.
In control states the state agency sets the wholesale price, and the invoice from the state warehouse is still a document with lines that need typing. The tool reads it like any other distributor invoice. The Alcohol and Tobacco Tax and Trade Bureau explains federal permits and record rules, while your state ABC board sets the rest.
Owners and managers of independent liquor, wine and beer stores, small chains with two to ten stores, and the bookkeepers who close their month.
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. The QuickBooks AP automation page shows how bills are split across spirits, wine, beer and supplies accounts.
You pay for pages processed, not per invoice, distributor or store. 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. See pricing for the full plan list.
A liquor store POS handles the register, age checks and stock counts, but most still expect you to type costs. InvoiceExtraction fills that gap by turning distributor invoices into rows with bottle cost and discounts, at $49 a month for all stores, alongside the POS you already use.
Upload the invoice PDFs or photos and export XLSX or CSV. Each line has item code, case size, quantity, case price and extended price, so you can match codes to SKUs and import or paste the new bottle cost.
Yes. Discount lines come out as their own negative rows next to the items they belong to, so you can spread them over the bottles and see your true cost per bottle.
Yes. Spirits, wine and beer invoices are read without templates and land in the same columns, so a week of deliveries comes 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 across all distributors and stores, with no per-store 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.
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.
Convert Johnson Brothers invoices from JB Hub to Excel or CSV line by line. Wine, spirits and beer with cases, bottles and cost per bottle for bars and liquor stores.
Bar inventory software is only as good as the costs you feed it. Turn liquor, wine and keg invoices into Excel or QuickBooks rows with case price, bottle cost and 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.
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.