Bank Statement to QuickBooks for Wineries and Distilleries: Convert PDF Statements to QBO

A winery or distillery runs three very different sales engines through the same account, and the statement blends them together: the tasting room and direct-to-consumer retail, the wine or spirits club (a subscription billed on a schedule with product shipping later), and the three-tier system, where you sell wholesale to a licensed distributor on terms. Each behaves differently on the statement, and treating all three as generic deposits leaves books that will not reconcile.

Your tasting room point of sale (Commerce7, WineDirect, or Square are common) settles a daily batch that deposits net of merchant processing fees. That single net number bundles the gross retail sales, the sales tax you collected for the state, any tips guests left, and the processor's cut skimmed off the top. Only the gross sales are income.

So split each daily batch: gross retail sales to income, the processing fee added back as a merchant fee expense, sales tax collected to a sales tax payable liability, and tips to a tips payable liability. That split is far easier when the whole deposit is already imported, which is what the PDF to QBO converter gives you.

When you charge members before a release ships, you have been paid for product you have not delivered, so that money is deferred revenue, a liability, not a sale.

Record the recurring club charge to a deferred revenue liability when it clears the bank. When the release actually ships, move that amount out of deferred revenue and recognize it as sales income, tied to the quarter the product left the door rather than the quarter the card was charged. For a seasonal club with spring and fall releases, that timing can shift meaningful revenue between periods.

When you sell to a licensed distributor, you sell at wholesale and get paid on terms, often 30 or 60 days out. Recognize the revenue when the sale is made and the product ships, and record a receivable for what the distributor owes you. When the distributor payment lands weeks later, it clears that open invoice in accounts receivable. It is not new income; booking it as fresh revenue double counts the sale.

Alcohol carries federal excise tax collected by the Alcohol and Tobacco Tax and Trade Bureau. For still wine not over 16% ABV, the tax is $1.07 per wine gallon. Under the Craft Beverage Modernization Act (CBMA), a small-producer credit of $1.00 per wine gallon applies to the first 30,000 wine gallons removed in a calendar year, which brings the effective rate down to about $0.07 per gallon for small wineries. The credit is $0.90 on the next 100,000 gallons and $0.535 on the next 620,000 gallons, applying to the first 750,000 wine gallons produced and removed in the year. The CBMA rates were made permanent by the Consolidated Appropriations Act of 2021.

Distilled spirits are taxed on a proof gallon basis. A proof gallon is one liquid gallon of spirits at 100 proof (50% ABV), with volume adjusted for proof. The standard rate is $13.50 per proof gallon. Under the CBMA, a reduced rate of $2.70 per proof gallon applies to the first 100,000 proof gallons removed or imported in a year, and $13.34 per proof gallon on the next 22.13 million proof gallons. Since 2022, only distilled spirits plants that perform a processing activity other than bottling can take the reduced rate on spirits they process, so confirm eligibility with a CPA or your plant's TTB guidance.

The accounting matters as much as the rate. Model excise as an excise tax expense paired with an excise tax payable liability that accrues when product is removed from bond, before any money moves. When the TTB payment leaves your bank on the periodic return, it settles that payable rather than creating a new expense. State excise and state sales taxes are separate liabilities that vary by state, and the CBMA small-producer credit reduces the effective federal rate. Rates and eligibility change, so confirm current figures on ttb.gov and with a CPA before filing. Our breweries and taprooms page walks through the same accrue-then-settle pattern for beer.

A winery or distillery is a manufacturer with an unusually long clock. Grapes, grain, and bulk spirits are work in process that ages in barrels and tanks for months or years before it becomes finished, bottled goods. Those production costs, fruit or grain, barrels, cellar labor, and utilities, are capitalized into inventory, not expensed when paid, and they follow the finished product out as cost of goods sold when it sells.

The cash goes out in one year and the sale lands in another, so expensing a barrel program the moment you pay for it understates inventory and distorts margin for years. This is a CPA-guided area.

Production equipment (tanks, stills, barrels, and bottling lines) is a fixed asset you capitalize and depreciate, not a supply you expense. When the gear is financed, split each monthly loan payment: the principal portion reduces the loan liability on your balance sheet, and only the interest portion is an expense. Booking the whole payment to one expense account overstates costs and hides real debt.

Compliance and shipping have their own lines. Direct-to-consumer shipping carrier charges are an operating expense, and alcohol shipping is bound by state-by-state rules on where you can ship. Compliance software such as ShipCompliant is an operating expense too. Harvest crews and event help are often paid as contractors, and the 1099 reporting threshold is $2,000 for payments made on or after January 1, 2026, indexed for inflation after that. Confirm current requirements with a CPA before you file.

How do I record federal excise tax for a winery in QuickBooks?

Accrue the federal excise tax as a liability when wine is removed from bond, using an excise tax payable account, then apply the TTB payment against that payable when it clears your bank. Still wine not over 16% ABV is taxed at $1.07 per wine gallon, and the CBMA small-producer credit of $1.00 per gallon on the first 30,000 gallons drops the effective rate to about $0.07. Confirm figures on ttb.gov and with a CPA.

What is the federal excise tax rate on distilled spirits?

The standard federal rate is $13.50 per proof gallon. Under the CBMA, a reduced rate of $2.70 per proof gallon applies to the first 100,000 proof gallons removed or imported in a year, and $13.34 on the next 22.13 million. A proof gallon is one liquid gallon at 100 proof (50% ABV), adjusted for proof. Since 2022, only plants doing a processing activity beyond bottling can use the reduced rate, so confirm eligibility.

How do I account for a wine club in QuickBooks?

Treat club billing as deferred revenue. When a member is charged before the release ships, record the amount to a deferred revenue liability rather than to sales, because you have been paid for product you have not delivered. When the release ships, move that amount out of deferred revenue and recognize it as sales income for that period.

How should a winery track inventory and COGS in QuickBooks?

Capitalize production costs into inventory instead of expensing them when paid. Grapes, grain, and bulk spirits are work in process that ages in barrels and tanks before it becomes finished goods, and the accumulated cost only hits COGS when the bottle sells. Because the cash and the sale fall in different years, set this up carefully with your accountant.

How do I record tasting room sales in QuickBooks?

Split the net POS batch rather than booking it as one number. Post gross retail sales to income, add the processing fee back as a merchant fee expense, route sales tax collected to a sales tax payable liability, and send tips to a tips payable liability. Commerce7, WineDirect, and Square all settle net of fees, so importing the full deposit first makes the split easy to reconcile.

How do I import a bank statement into QuickBooks?