TTB Form 5120.17

Your TTB 5120.17, built from the cellar records you already keep

TTB 5120.17 software builds the Report of Wine Premises Operations from your production records instead of a spreadsheet you rebuild every period. GrapeFlow generates it from the lots, fermentations, blends, additions, bottlings and removals you already log: Sections A and B in gallons across the six tax-class columns, plus Parts IV, VI and VII, with every cell traced to the records behind it. It checks that each column balances and that the book matches your lots, flags what doesn’t reconcile, and gives you the form laid out line by line and as a PDF. You still file it — on Pay.gov or on paper.

  • 30-day free trial
  • No credit card
  • No per-seat pricing
A monthly draft: Section A in gallons per tax class, the discrepancies to clear before you file, and the PDF. Demo data — Ridgeline Cellars is a fictional winery.

What GrapeFlow fills in on the 5120.17

Laid out as TTB F 5120.17 (09/2025) prints it, in gallons at two decimals and pounds for grapes. Each line comes from records you already keep:

Parts of TTB Form 5120.17 that GrapeFlow fills in, and where each figure comes from
Part of the formWhat GrapeFlow fills inFrom which records
Section A — bulk winesLines 1–32 in the six columns (a)–(f): on hand, produced by fermentation, sweetening, wine spirits, blending across classes, amelioration, received in bond, gains; bottled, removed taxpaid, in bond, for distilling, vinegar, testing, export, destroyed, losses; on hand at the endFermentations, blends, additions by nature, bottlings, bulk sales by removal kind, losses, in-bond receipts
Section B — bottled winesLines 1–21: bottled, received in bond, returned to bond, removed taxpaid, transferred in bond, tasting, export, family use, testing, breakage, destroyed, inventory shortageBottlings and finished-goods movements with their reason
Tax class columnsEach lot’s class at the date of each event — not over 16%, 16–21%, 21–24%, artificially carbonated, sparkling, hard ciderThe lot’s latest alcohol analysis, its wine type and carbonation method
Part IV — materialsGrapes on hand, received and used, in poundsHarvest receptions and pressings
Part VI — distilling materialLees produced and removedLees lots
Part VII — in fermentersEstimated liquid still fermenting at the end of the periodLots still in fermentation
Part X — remarksThe remarks the period needs, such as the quarterly or annual filing statementYour filing frequency and the period

Lines with no source in GrapeFlow — bottled wine dumped to bulk (A8/B10), bulk-process sparkling wine and Parts III, VIII and IX — are left empty and marked on screen for you to complete.

Checks before you file

A draft is never forced to balance. GrapeFlow writes it with its discrepancies, and an error blocks marking it as submitted until you clear it:

  • Columns that balance

    Line 12 equals line 32 in Section A and line 7 equals line 21 in Section B, in every column, with totals re-added from the rounded cells so the paper closes.

  • The book against your lots

    The closing per tax class is checked against what your lots hold at the end of the period, and a lot that appears without an entry is flagged.

  • Bond documents against operations

    An in-bond removal without its document, a document without its operation, or volumes that differ — each one listed with the lot.

  • Opening = last closing

    The opening comes from your last filed report; a gap between periods or a different opening is flagged.

  • Every cell, traced

    Open any figure to see the records behind it — table, lot, litres and gallons — so a question from TTB is answered from the source.

  • A lot with no tax class stops the report

    It is never pushed into the cheapest column: the report lists the lots that need an alcohol analysis or a class.

Each period, in four steps

  1. Pick the period. Monthly, quarterly or annual — the frequency set for your winery — with its due date: the 15th of the month after the period ends (January 15 for annual filers).

  2. Preview or generate the draft. Read the discrepancies and fix the records behind them, not the report.

  3. Transcribe it. Copy each value from the line-by-line list into the 5120.17 on Pay.gov, or print the PDF for a paper filing.

  4. Mark it as submitted in GrapeFlow. Once you have filed it, GrapeFlow freezes the snapshot, archives the PDF, and carries the closing into the next period. A correction is an amended report, never an edit.

What the 5120.17 asks for, line by line: the guide →

One price, everything included

$99/month, or $990/year. Vineyard and winery records, and the US compliance set, are all included. No per-seat pricing. 30-day free trial, no credit card.

Start your 30-day free trial

See pricing and the app →

Frequently asked questions

Does GrapeFlow file my 5120.17 with the TTB?

No. GrapeFlow builds the report and gives you a line-by-line list and a PDF; you file it yourself on Pay.gov or on paper. Marking a report as submitted in GrapeFlow only records that you filed it, freezes it and carries its closing into the next period.

Where do the numbers on the report come from?

From the records you already keep in GrapeFlow: fermentations, blends, additions, bottlings, bulk sales and finished-goods movements, each tagged to a lot. Every cell opens to the records behind it.

What if the report doesn’t balance?

GrapeFlow does not force it. It saves the draft with its discrepancies — for example a closing that differs from your lots, or an in-bond removal with no document — and an error blocks marking it as submitted until the records are fixed.

Does it work for quarterly and annual filers?

Yes. The period follows the filing frequency set for your winery. TTB allows quarterly reports when bulk and bottled wine is not expected to exceed 60,000 gallons in any quarter, and annual reports when it is not expected to exceed 20,000 gallons in any month (27 CFR 24.300(g)); GrapeFlow warns when a period goes over.

Which tax classes does it handle?

All six columns on the current form: still wine not over 16% alcohol, over 16 to 21%, over 21 to 24%, artificially carbonated, sparkling and hard cider. Each lot’s class is taken from its alcohol analysis at the date of each event.

How much does GrapeFlow cost?

$99/month or $990/year, with every module included and no per-seat pricing. There is a 30-day free trial and no credit card is required.