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 first is the tasting room and direct-to-consumer retail: someone buys a bottle or a flight, and your point of sale settles a batch. The second is the wine or spirits club, a subscription where members are charged on a schedule and product ships later. The third is the three-tier system, where you sell wholesale to a licensed distributor on terms. Each behaves differently on the statement and needs to be recorded a different way. Treating all three as generic deposits is the fastest way to 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 is not one thing. It 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 the right way to book a daily batch is to split it: 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. Sales tax and tips are money you hold for someone else, not revenue you earned. That split is far easier when the whole deposit is already imported, which is what the PDF to QBO converter gives you to work from.

Club billing looks like income the moment it hits the bank, but timing is the whole point. When you charge members before a club release ships, you have been paid for product you have not delivered yet. 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. This keeps revenue tied to the quarter the product left the door, not the quarter the card was charged. For a seasonal club with a spring and fall release, that timing can shift meaningful revenue between periods, so set it up cleanly with your accountant.

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. Weeks later, when the distributor payment lands on your statement, it clears that open invoice in accounts receivable. It is not new income. Booking that deposit as fresh revenue double counts a sale you already recorded.

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, so the liability exists 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 on the day it clears. State excise and state sales taxes are separate liabilities that vary by state, and the CBMA small-producer credit reduces the effective federal rate, so your accrual should reflect the credited amount you owe. Rates and eligibility change, so confirm current figures on ttb.gov and with a CPA before filing. The parallel with beer is close: our breweries and taprooms page walks through the same accrue-then-settle pattern.

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. The costs of getting it there, fruit or grain, barrels, cellar labor, and utilities, are capitalized into inventory, not expensed when the invoice is paid. When the finished product sells, that accumulated cost follows it out as cost of goods sold.

This is where a lot of producers go wrong, because the cash goes out in one year and the sale happens in another. Expensing a barrel program the moment you pay for it understates inventory and distorts margin for years. This is a CPA-guided area, so build the inventory and COGS structure with your accountant rather than improvising it from the bank feed.

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, each monthly loan payment on your statement is two things: 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 understates the debt you owe.

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 and how you can ship. Compliance software such as ShipCompliant is an operating expense too. Harvest crews and event help are often paid as contractors. 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 current 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 with a CPA.

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 account rather than to sales, because you have been paid for product you have not delivered. When the club release actually 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, this is a CPA-guided area worth setting 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. Systems like 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?