AI Matrx Logo

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 1, 2026—15—
BB-2629Cedar Haze IPAFV4Sep 24, 2026—7—
BB-2615Porch SaisonFV2Sep 16, 2026—15—
BB-2607Wheat SeasonFV1Sep 15, 2026Sep 29, 20261514
BB-2622Night Shift StoutFV3Sep 11, 2026Oct 2, 20261513.5
BB-2628Lakeshore PaleFV4Sep 8, 2026Sep 22, 202676.3
BB-2621Ore Dock AmberFV3Aug 24, 2026Sep 9, 20261514.3
BB-2627Ore Dock AmberFV4Aug 21, 2026Sep 6, 202676.7
BB-2606Porch SaisonFV1Aug 20, 2026Sep 13, 20261513.8
BB-2614Spindle PilsnerFV2Aug 17, 2026Sep 14, 20261514.1
BB-2620Cedar Haze IPAFV3Aug 7, 2026Aug 22, 20261514.1
BB-2626Night Shift StoutFV4Jul 29, 2026Aug 19, 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

Views

Tank time

Brew log
May 8, 2026Jul 27, 2026
BB-2601
BB-2609
BB-2602
BB-2616
BB-2610
BB-2623
BB-2603
BB-2617
BB-2611
BB-2624
BB-2604
BB-2618
BB-2612
BB-2625

Forms and booking

Log a brew day

Form
Log a brew dayWhat the head brewer fills in on brew day once the wort is in the tank.
Which batch number is it? *BB- and four digits.
Which beer is going in? *
Which tank is it going into? *
What day did you brew? *
How many barrels went into the tank? *
Who ran brew day?
What did the ingredients come to?Grain, hops, yeast and cleaning, from the brew sheet.
Log the batch

Dashboards

Brewhouse

Brew log
Barrels packaged by month
  • May 17, 202614
  • May 31, 202614.3
  • Jun 7, 202627.6
  • Jun 14, 202613.5
  • Jun 21, 202620.7
  • Jun 28, 202613.7
  • Jul 5, 202620.1
  • Jul 19, 202627.3
Barrels packaged by beer302.8
Barrels owed excise82.7

Also included

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

Related templates