TTB Form 5120.17 without the spreadsheet: a small winery’s guide

For a US bonded winery, TTB Form 5120.17 — the Report of Wine Premises Operations — is the recurring paperwork that trips up small producers most. It is not hard; it is just unforgiving of a cellar whose numbers do not reconcile. This is a plain-language guide to what it wants and how to keep the data so filing is a summary, not a reconstruction.

What the report covers

The 5120.17 is a bulk-wine balance for the reporting period. For each tax class of wine it accounts for what you had, what you made or received, what you removed, and what you have left — so that opening balance plus additions minus removals equals the closing balance, for every category.

• On-hand at start of the period, by tax class (table wine, over 14%, sparkling, etc.).
• Produced by fermentation, plus wine received in bond from other premises.
• Additions and changes — sweetening, spirits, amelioration, and reclassifications between tax classes.
• Removals — taxpaid to market, transferred in bond, used, or lost.
• Bottled vs bulk, and losses, with the closing on-hand.

Monthly, quarterly or annual?

How often you file depends on your expected excise-tax liability. Broadly, wineries with a small liability may qualify to file quarterly, and the very smallest annually, while larger operations file monthly. The thresholds are set by TTB and change over time, so confirm your current filing frequency with TTB rather than assuming last year’s applies.

The report is due by the reporting-period deadline set by TTB (commonly the 15th of the month following the period). A "no-activity" period usually still requires a report — silence is not a filing.

Why cellars fail to reconcile

• Losses not recorded — evaporation, lees, filtration and racking losses that make the physical volume drift from the books.
• Bottling not reflected as a bulk-to-bottled move in the right period.
• Blends and additions that change tax class without being reclassified.
• Transfers in bond logged on one side only.

Keep the data so the form is a summary

The winning move is the same as with any regulator: record each volume-changing operation when it happens, tagged to the lot and the tax class. Then the monthly or quarterly 5120.17 is just the period’s totals. GrapeFlow logs production, additions, bottling and losses as atomic movements against the lot, so the numbers that feed the report are a running balance rather than a spreadsheet rebuilt under deadline.

This is a practical overview, not tax or legal advice. Always confirm current forms, thresholds and deadlines with the TTB.