PDF Bank Statement to QuickBooks for Breweries and Wineries: Convert Taproom and Distributor Statements to QBO

A brewery or winery sells the same beer three different ways, and the bank statement flattens all of it into one column. A taproom pint arrives as a Square or Toast payout net of fees, a distributor pays a wholesale invoice weeks later, and the TTB debits excise tax straight from the operating account. PDFQBO converts each PDF statement into a QuickBooks QBO file so every payout, distributor check, and tax debit reaches your books with its exact date and amount.

Quick answer

To get a brewery's bank statement into QuickBooks, convert the PDF to a QBO file first. Upload the operating account, merchant payout, or brewery credit card statement to PDFQBO, review the taproom batches, distributor deposits, and excise tax debits it reads, and download a QBO (Web Connect) file. Then import that file into QuickBooks Online or Desktop and code each line to the right revenue channel. The same works for a processor statement that batches taproom sales and never feeds QuickBooks with channel-level detail.

Taproom, distributor, self-distribution Payouts net of fees QuickBooks Online and Desktop

Last updated July 2026

Convert a brewery statement to QBO

Upload an operating, merchant, or card PDF and download a QBO file for QuickBooks.

No credit card required to try your first statement.

Any account

Operating, merchant, card

QBO + IIF

Online and Desktop

Net-of-fee

Reconcile taproom batches

Auto delete

Files removed after use

How to convert a brewery or winery statement to QuickBooks

Four steps take you from a PDF statement to a QBO file QuickBooks accepts, whether the money came from the taproom, a distributor, or a tasting-room card batch.

Gather the PDFs

Download the monthly statement from your operating account, the payout statement from Square, Toast, Arryved, or whatever runs the taproom, and any brewery credit card. Distributor payments and excise debits rarely land in a QuickBooks bank feed with enough detail to reconcile.

Upload to the converter

Drag the statements into the tool above. A packed festival month with hundreds of taproom batches converts as easily as a quiet January, and you can upload several months at once to catch up a file that got away from you during peak season.

Review the transactions

PDFQBO reads the date, description, and amount on each line and keeps deposits and payments on the correct side. Check the table, confirm the payouts, distributor checks, and tax debits, then export a QBO or IIF file.

Import and categorize

Upload the QBO file from the Banking screen in QuickBooks Online, or import the Web Connect or IIF file in Desktop. Then split each taproom batch into gross sales and the processing fee, and code distributor deposits to their own wholesale revenue account.

Why a brewery's books are hard to get into QuickBooks

The same beer earns three different margins

A pint poured in the taproom, a keg sold to a bar you self-distribute to, and a pallet sold through a wholesaler are three separate revenue channels with wildly different margins. Most states run a three-tier system where distribution goes through a wholesaler who takes a real cut, so wholesale dollars per barrel look nothing like taproom dollars per barrel. If every deposit lands in one generic Sales account, you cannot tell which channel is carrying the brewery. Converting the statement gets each deposit in with its exact date and amount so you can split taproom, self-distribution, and wholesale into their own income accounts and hold cost of goods sold against each.

A keg deposit is a liability, not a sale

You charge a refundable deposit on every keg and hand it back when the keg comes home. That money is not revenue; it sits on the balance sheet as a liability until the keg returns or the deposit is forfeited. Book it as income and you overstate sales in a busy month and understate them in a slow one, and the cash never ties out. Getting the deposits and refunds into QuickBooks as separate dated lines from the converted statement is what lets you park them in a keg deposit liability account and actually watch that balance shrink as kegs come back.

TTB excise tax comes straight out of the bank

Federal beer excise tax is paid on the beer you remove from the brewery for sale or consumption, net of beer returned during the period, and the payment lands on the bank statement as its own debit. Alongside it sit state excise, container deposit obligations, and the sales tax on taproom pours. These are not operating expenses in the ordinary sense and they need to reconcile back to the volume you reported to the TTB on the Brewer's Report of Operations. Converting the statement gets every tax debit in QuickBooks with its exact date, so the amount you actually paid can be tied to the return that generated it.

Ingredients, packaging, and equipment are not the same thing

Malt, hops, yeast, cans, labels, and CO2 are cost of goods sold that belong against the batches they went into. A new fermenter or canning line is a depreciable asset, not an expense, even though both leave the bank account the same way. Grape and barrel purchases work the same way on the winery side, where a vintage may sit for a year or more before it earns a dollar. Getting every supplier payment into QuickBooks as its own line from the converted statement is what lets you separate the cost of the beer in the tank from the equipment that made it.

Built for brewery and winery books

One tool for every account a producer deals with, so a whole season or a whole year goes into QuickBooks in minutes.

Taproom batches, one pass

A busy taproom deposits a card batch nearly every day, and each one is net of the processor's cut. PDFQBO captures every batch so you can split gross pours from fees instead of typing a month of deposits by hand.

Distributor and wholesale deposits

Wholesale checks and ACH payments arrive on their own schedule, often long after the beer shipped. Converting the statement gets each one in so you can apply it against the right invoice and see wholesale revenue on its own line.

Excise and tax debits captured

Federal and state excise payments, sales tax remittances, and container deposit obligations all leave the bank as ordinary-looking debits. Getting them into QuickBooks dated and separate is what makes them reconcile to the returns you filed.

Multiple accounts, one workflow

Operating account, merchant payouts, and a brewery credit card each format a statement their own way. One converter reads all of them, so the whole business reconciles from a single, repeatable process.

Catch up after peak season

Behind after a summer of festivals, a harvest, or a release weekend? Upload a quarter or a year of statements from every account together and convert them in one session. Each file is tracked on its own so you can see what converted cleanly.

Reads any bank's layout

A national bank, a community bank that knows your taproom, a credit union, or a card processor each format a statement their own way. PDFQBO finds the transaction rows on each and leaves out the summary boxes that are not transactions.

Who uses it in beverage production

Anyone keeping a brewery, winery, cidery, or distillery's books in QuickBooks from PDF statements.

Taproom-first craft breweries

Most of the revenue is pints and to-go cans, deposited as daily card batches net of fees. Converting the statements each month gets every batch into QuickBooks so gross sales, fees, and sales tax reconcile against what the POS reported.

Breweries that self-distribute

Kegs go out to bars and restaurants and the checks come back on their own timeline, with deposits owed on every keg. Converting the statement gets each payment in so you can apply it to the invoice and keep the keg deposit liability honest.

Wineries and tasting rooms

Wine club charges, tasting-room sales, and direct-to-consumer shipping each settle differently, and a vintage costs money long before it earns any. Converting every account's statement puts the cash flow in QuickBooks where the production cycle can be seen against it.

Bookkeepers with beverage clients

Clients hand you PDFs, a POS payout report that never connects, and a stack of excise returns. One converter for every account gives you a repeatable way to bring any producer's month into QuickBooks with channels, fees, and deposits handled correctly.

Common brewery categories once the transactions are in

Once the statements are converted and imported, you code each transaction to an account. These are the categories a brewery or winery leans on most, and getting every transaction into QuickBooks is what makes your profit and loss and your excise reconciliation trustworthy.

• Taproom revenue for pints, flights, and to-go cans sold on premise, kept separate from wholesale so you can see margin by channel.
• Wholesale and distributor revenue for kegs and packaged beer sold through a distributor or self-distributed to accounts.
• Keg deposits payable for refundable deposits held as a liability until the keg comes back or the deposit is forfeited.
• Excise tax expense for federal and state alcohol excise paid on beer removed for sale, reconciled to what you reported to the TTB.
• Raw materials and packaging (COGS) for malt, hops, yeast, grapes, barrels, cans, labels, and CO2 tied to the batches they went into.
• Brewing equipment (fixed assets) for tanks, a canning line, and a glycol system, capitalized and depreciated rather than expensed.

For a step-by-step on coding the imported lines, see the guide on categorizing bank transactions in QuickBooks. For the equipment side, see recording depreciation, and for ingredient purchases, recording inventory purchases and COGS.

Frequently asked questions

How do I get a brewery bank statement into QuickBooks?

Convert the PDF statement to a QBO file, then import it. Upload the operating account, merchant payout, or brewery card statement to PDFQBO, review the taproom batches, distributor deposits, and excise debits it reads, and download a QBO (Web Connect) file. In QuickBooks Online you upload it from the Banking screen; in Desktop you import the Web Connect or IIF file. Then categorize each line by revenue channel.

How do I record keg deposits in QuickBooks?

Record a refundable keg deposit as a liability, not as revenue, because you owe the money back when the keg returns. Set up a keg deposits payable account, post the deposit collected there, and clear it when you refund the deposit or the keg is never returned and the deposit is forfeited to income. Converting the statement gets each deposit and refund in as its own dated line so the liability balance stays honest.

How do I record TTB excise tax in QuickBooks?

Record the excise payment as its own expense account, dated to the day it left the bank, so it reconciles to the return that generated it. Federal beer excise is owed on beer removed from the brewery for sale or consumption, net of beer returned during the period, and it hits the bank as a discrete debit. Converting the statement gets that debit into QuickBooks with the exact amount you paid.

How do I record taproom POS payouts in QuickBooks?

Record the gross taproom sale as revenue and the processing fee as an expense, so the two net to the payout that hit your bank. Square, Toast, Arryved, and other POS platforms deposit sales minus their cut, so the bank line is smaller than what customers actually paid at the bar. Converting the payout statement gets each batch in with its exact amount so the split reconciles against the POS sales report.

How do I track cost of goods sold for a brewery?

Post malt, hops, yeast, cans, labels, and CO2 to cost of goods sold and keep tanks, kegs, and a canning line as depreciable fixed assets. The bank statement holds every supplier payment, but it does not tell you which is which. Converting it puts each purchase into QuickBooks as a dated line you can code correctly, so your gross margin per barrel reflects the beer and not the brewhouse.

Is QuickBooks good for a brewery?

QuickBooks works well for a brewery when each revenue channel has its own income account, keg deposits sit as a liability, excise tax reconciles to the returns, and raw materials are separated from equipment. It gives you a clean profit and loss and margin by channel. Many breweries pair it with production software for barrel tracking. Converting your operating, merchant, and card PDFs to QBO files is what keeps the accounting side complete and reconcilable.

Get your brewery statements into QuickBooks

Upload an operating, merchant, or card PDF, review the taproom batches and distributor deposits, and download a QBO file QuickBooks accepts. No install, and your first conversion is on us.

Convert a statement View pricing