Craft brewery

Grayling Mill Brewing · Craft brewery · Marquette, MI

Kat Lindholm runs the taproom at Grayling Mill Brewing in Marquette, Michigan, and she uses this to log every batch, see how long each tank is tied up and read off the barrels packaged each month for the federal excise return.

Food and hospitalityComplianceDrill-down4 tables · 6 views · 1 form · 1 dimension set · 1 dashboard · 1 drill-down · 1 digest · 1 agent
Use this template

Batch board

Brew log
Fermenting1
BB-2608Tart Cherry GoseFV1
Conditioning2
BB-2615Porch SaisonFV2
BB-2629Cedar Haze IPAFV4
Packaged25
BB-2601Lakeshore PaleFV1
BB-2602Cedar Haze IPAFV1
BB-2603Ore Dock AmberFV1
BB-2604Night Shift StoutFV1
BB-2605Spindle PilsnerFV1
20 more
Dumped1
BB-2612Ore Dock AmberFV2

Tables

Brew log

29 sample rows · 12 columns

Every batch from brew day to the keg line: which beer, which tank, how many barrels went in and came out, and whether the excise is counted.

BatchBeerTankBrewedPackagedBarrels brewedBarrels packaged
BB-2608Tart Cherry GoseFV1Oct 14, 2026—15—
BB-2629Cedar Haze IPAFV4Oct 7, 2026—7—
BB-2615Porch SaisonFV2Sep 29, 2026—15—
BB-2607Wheat SeasonFV1Sep 28, 2026Oct 12, 20261514
BB-2622Night Shift StoutFV3Sep 24, 2026Oct 15, 20261513.5
BB-2628Lakeshore PaleFV4Sep 21, 2026Oct 5, 202676.3
BB-2621Ore Dock AmberFV3Sep 6, 2026Sep 22, 20261514.3
BB-2627Ore Dock AmberFV4Sep 3, 2026Sep 19, 202676.7
BB-2606Porch SaisonFV1Sep 2, 2026Sep 26, 20261513.8
BB-2614Spindle PilsnerFV2Aug 30, 2026Sep 27, 20261514.1
BB-2620Cedar Haze IPAFV3Aug 20, 2026Sep 4, 20261514.1
BB-2626Night Shift StoutFV4Aug 11, 2026Sep 1, 202676.6

17 more rows

Beers

8 sample rows · 6 columns

The recipes on the board: style, strength and how long each takes to be ready.

BeerStyleABVDays to packageBatches
Cedar Haze IPAIPA6.815BB-2602, BB-2611, BB-2620, BB-2624, BB-2629
Lakeshore PalePale ale5.614BB-2601, BB-2610, BB-2616, BB-2619, BB-2625, BB-2628
Night Shift StoutStout6.221BB-2604, BB-2613, BB-2617, BB-2622, BB-2626
Ore Dock AmberAmber5.416BB-2603, BB-2609, BB-2612, BB-2618, BB-2621, BB-2627
Porch SaisonSaison624BB-2606, BB-2615
Spindle PilsnerPilsner4.928BB-2605, BB-2614
Tart Cherry GoseSour4.420BB-2608, BB-2623
Wheat SeasonWheat514BB-2607

Tanks

4 sample rows · 5 columns

The fermenters on the floor and what each can hold.

TankCapacityKindBatches
FV115FermenterBB-2601, BB-2602, BB-2603, BB-2604, BB-2605, BB-2606, BB-2607, BB-2608
FV215FermenterBB-2609, BB-2610, BB-2611, BB-2612, BB-2613, BB-2614, BB-2615
FV315FermenterBB-2616, BB-2617, BB-2618, BB-2619, BB-2620, BB-2621, BB-2622
FV47FermenterBB-2623, BB-2624, BB-2625, BB-2626, BB-2627, BB-2628, BB-2629

Also included

  • Barrels packaged by month and beerDrill-down
  • Excise still owedDigest