A brewery system can tell you how much malt is in the silo, but cost per barrel is only right when the price behind every sack, box of hops and pallet of cans matches the latest supplier invoice. Upload the malt, hops, yeast and packaging invoices and each line comes back as a row with pack, quantity, unit cost and extended price, with freight on its own line so you can spread it.
Reads supplier PDFs, emailed invoices, credit memos and phone photos for any brewery, with no EDI and no per-supplier setup.
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
Brewery inventory software tracks ingredients, tanks and finished goods, but cost per batch, cost per can and margin by beer depend on current unit costs from supplier invoices. InvoiceExtraction reads malt, hops, yeast, packaging and freight invoices, splits each line into item, pack, quantity, unit cost, extended price, fees and credits, and exports Excel or CSV for your costing sheet, brewery system or QuickBooks bills. Plans start at $49 a month, or $24 a month billed yearly, for every supplier combined.
A 55 lb sack, an 11 lb box of pellets or a 1,000 count case of cans is read into quantity and pack, so a line price becomes a price per pound or per can.
Unit cost sits in its own column, so ingredient cost per batch is unit cost times the amount in your recipe sheet.
Freight and fuel charges are separate lines, so you can spread them over the goods on the same invoice and see landed cost.
Short shipments and credit memos come out as negative rows, so the amount you owe ties to what actually arrived.
Every invoice is summed against its printed total. A line that does not tie is highlighted before export.
One file for the costing sheet or brewery system import, or bills in QuickBooks on the Plus plan with vendor, dates and line amounts filled in.
Save the emailed PDFs from your malt, hops and packaging suppliers and photograph the paper copies that arrive with the truck.
Ingredient and packaging invoices go in one batch. Each one is read on its own, with no template per supplier.
A blurry photo or a line that does not tie to the total is highlighted so you check only what needs it.
Download XLSX or CSV, update the unit costs in your costing sheet or brewery system and read the new cost per batch.
Aluminum, malt and hops are bought in large lots, and a price change on one order feeds every batch brewed from it. A brewery that updates costs once a quarter prices beer on numbers that are already stale.
Converting each invoice the week it arrives keeps the unit cost column current, so the next batch is costed at what you now pay.
Convert a supplier invoiceFour things per line: the item and pack, the quantity received, the unit or case price and the extended price. Ingredient cost, packaging cost and margin by beer all start there. Brewery software that counts stock but does not read invoices leaves someone typing those fields for each delivery, which is where costs go stale first.
Reading the invoice puts them in columns, checked against the invoice total, so updating cost becomes a file import and not an evening at a keyboard.
The delivery below is an illustration with round numbers, not a quote from any supplier. It mixes malt, hops, cans and freight. The invoice total is $2,110.00, of which $1,965.00 is goods and $145.00 is freight.
| Line on the invoice | Pack | Qty | Price | Extended | Unit cost |
|---|---|---|---|---|---|
| Pale malt, 2 row | 55 lb sack | 20 | $38.50 | $770.00 | $0.70 per lb |
| Cascade hops, pellets | 11 lb box | 2 | $93.50 | $187.00 | $8.50 per lb |
| Aluminum cans, 16 oz | 1,000 ct case | 6 | $168.00 | $1,008.00 | $0.168 each |
| Freight | 1 | 1 | $145.00 | $145.00 | Fee, 7.4% of goods |
Take a simplified 10 barrel pale ale that uses 300 lb of malt and 12 lb of hops and fills 2,400 cans. Malt is 300 x $0.70 = $210.00, hops 12 x $8.50 = $102.00 and cans 2,400 x $0.168 = $403.20, together $715.20. Freight is $145.00 on $1,965.00 of goods, so 7.4% is added, which brings the batch to $767.97 landed, or $0.32 a can before yeast, labor, carriers and excise.
On the next delivery the malt sack goes from $38.50 to $41.25. The unit cost moves from $0.70 to $0.75 per lb and the malt in that batch rises by $15.00, which shows in the next costing and not in the quarter close. The same arithmetic for a bakery batch is on the recipe costing page, and the bar inventory software page covers the liquor side.
Both, for different jobs. A brewery system handles recipes, tanks, packaging runs and stock levels. Invoice reading fills the cost side, which many setups still expect you to key in, at $49 a month for all suppliers combined. If your system works, keep it and feed it better costs. Industry benchmarks from the Brewers Association are a useful check on your own cost per barrel once the inputs are current.
Owners, brewmasters and operations managers at craft breweries, cideries and brewpubs, plus the bookkeepers who close their month.
You pay for pages processed, not per invoice or supplier. 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 every plan, or bulk invoice processing for large batches.
It depends on whether you need tank and batch tracking or only stock counts. Most systems still expect unit costs typed from invoices. InvoiceExtraction fills that gap by turning supplier invoices into rows with quantity and unit cost, at $49 a month, next to the system you already use.
Upload the invoice PDFs or photos and export XLSX or CSV. Each line has item, pack, quantity, price and extended price, so you can match items to your ingredient list and import the new costs instead of keying them.
Freight comes out as its own row, so you can divide it across the goods on the same invoice in your sheet and get a landed unit cost. The spreading itself is done in your spreadsheet, not by the extraction.
They come out as their own rows, with credits as negative amounts, so the invoice total ties to what you owe.
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 suppliers, with no per-supplier 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.
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.
Recipe costing software only works with current ingredient prices. Read supplier invoices into Excel, CSV or QuickBooks and feed every recipe cost from what you paid.
Food service inventory software that keeps cost per meal current. Turn Sysco, US Foods and PFG invoices into rows with pack, unit cost and extended price for your kitchen.
Line item extraction software that reads every invoice table row: description, quantity, unit price, tax and total, checked against the invoice total. From $49 a month.
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.
Bulk invoice processing for high volumes: uploading hundreds of documents at once, queue behavior, parallelism, partial failure handling, splitting multi-invoice PDFs and surviving month-end spikes.
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.