AI Matrx Logo

Brewery production

Larchmont Corners Brewworks · Brewery production · Minneapolis, MN

Jarrah Thibodeaux is the brewmaster at Larchmont Corners Brewworks, a production brewery, and bills each keg batch to the taprooms, bars and distributors that bought it, then chases what is still unpaid.

ManufacturingBillingDrill-down4 tables · 6 views · 1 form · 1 dimension set · 1 drill-down · 1 digest · 1 notification · 1 agent
Use this template

Invoice board

Invoices
Sent5
BW-4426Torrance Ridge DistributingHopyard Red
BW-4432Torrance Ridge DistributingKettle Yard Lager
BW-4448Sundial Pizza WorksBristlecone Barleywine
BW-4454Sundial Pizza WorksHopyard Red
BW-4476Calloway Bottle and BineBristlecone Barleywine
Paid19
BW-4412Greenfell Supper ClubDockside Kolsch
BW-4414Marlowe's Riverside GrilleLantern Row Hazy
BW-4416Hollin Cross Hotel BarCornerstone Pils
BW-4420Wickford Hall BrewpubBristlecone Barleywine
BW-4422Sundial Pizza WorksSwitchback IPA
14 more
Overdue8
BW-4410Birchmoor TaproomLarchmont Amber
BW-4418Calloway Bottle and BineTamarack Saison
BW-4424The Rusted Anchor AlehouseCinder Hill Porter
BW-4438Greenfell Supper ClubLarchmont Amber
BW-4446Wickford Hall BrewpubTamarack Saison
3 more
Disputed2
BW-4434Pennyfield Cooperative GrocersMaple Rail Brown
BW-4462Birchmoor TaproomMaple Rail Brown

Tables

Invoices

34 sample rows · 11 columns

Every invoice for kegs sold, tied to the beer batch it came from and the account it bills, with what is still owed.

InvoiceAccountBeer batchInvoicedDuePaid onKegs
BW-4432Torrance Ridge DistributingKettle Yard LagerOct 16, 2026Nov 30, 2026—8
BW-4460Pennyfield Cooperative GrocersKettle Yard LagerOct 16, 2026Nov 15, 2026Oct 17, 202616
BW-4454Sundial Pizza WorksHopyard RedOct 13, 2026Oct 28, 2026—10
BW-4448Sundial Pizza WorksBristlecone BarleywineOct 10, 2026Oct 25, 2026—19
BW-4476Calloway Bottle and BineBristlecone BarleywineOct 8, 2026Nov 7, 2026—12
BW-4470Greenfell Supper ClubLantern Row HazyOct 5, 2026Oct 20, 2026Oct 17, 20266
BW-4464Greenfell Supper ClubSunday Quarry WheatSep 22, 2026Oct 7, 2026Oct 7, 202615
BW-4426Torrance Ridge DistributingHopyard RedSep 21, 2026Nov 5, 2026—17
BW-4420Wickford Hall BrewpubBristlecone BarleywineSep 18, 2026Oct 18, 2026Oct 16, 202611
BW-4414Marlowe's Riverside GrilleLantern Row HazySep 15, 2026Sep 30, 2026Sep 30, 202620
BW-4442Hollin Cross Hotel BarLantern Row HazySep 13, 2026Sep 16, 2026Sep 15, 202613
BW-4436Birchmoor TaproomSunday Quarry WheatAug 31, 2026Oct 15, 2026Oct 16, 20267

22 more rows

Accounts

10 sample rows · 9 columns

The taprooms, bars, restaurants and distributors that buy kegs, with their payment terms.

AccountKind of accountBuyerBuyer emailBuyer lineTermsInvoices
Birchmoor TaproomTaproomTamsin Borostosttamsin.borostost@accountsdeskmail.com(612) 555-0130Net 45BW-4410, BW-4436, BW-4462
Calloway Bottle and BineBottle shopPerpetua Trebramdor-Kelmereperpetua.trebramdorkelmere@accountsdeskmail.com(612) 555-0132Net 30BW-4418, BW-4444, BW-4450, BW-4476
Greenfell Supper ClubRestaurantNiamh Halrooktonniamh.halrookton@ledgerhallmail.net(612) 555-0133Net 15BW-4412, BW-4438, BW-4464, BW-4470
Hollin Cross Hotel BarHotelLeontine Stavzelrook-Ostkessleontine.stavzelrookostkess@ledgerhallmail.net(612) 555-0139Due on deliveryBW-4416, BW-4442, BW-4468, BW-4474
Marlowe's Riverside GrilleRestaurantDelphine Varnpeddpell-Garrigdelphine.varnpeddpellgarrig@accountsdeskmail.com(612) 555-0136Net 15BW-4414, BW-4440, BW-4466, BW-4472
Pennyfield Cooperative GrocersGrocerGarrick Merezelwardgarrick.merezelward@ledgerhallmail.net(612) 555-0137Net 30BW-4428, BW-4434, BW-4460
Sundial Pizza WorksRestaurantSylvan Tredorsylvan.tredor@accountsdeskmail.com(612) 555-0138Net 15BW-4422, BW-4448, BW-4454
The Rusted Anchor AlehouseBarWystan Saxrigbram-Kesshalwystan.saxrigbramkesshal@ledgerhallmail.net(612) 555-0131Net 30BW-4424, BW-4430, BW-4456
Torrance Ridge DistributingDistributorHortense Tarostdorhortense.tarostdor@accountsdeskmail.com(612) 555-0134Net 45BW-4426, BW-4432, BW-4458
Wickford Hall BrewpubBarJarvis Peddcrofthorn-Varnwaldjarvis.peddcrofthornvarnwald@ledgerhallmail.net(612) 555-0135Net 30BW-4420, BW-4446, BW-4452

Beer batches

14 sample rows · 8 columns

Each brew that goes out in kegs, with when it was brewed, how many kegs it filled and the price per keg.

BeerBatchStyleBrewedKegs filledPrice per kegInvoices
Kettle Yard LagerBW-B-149LagerSep 15, 202653$145BW-4432, BW-4460
Hopyard RedBW-B-146Red aleSep 6, 202646$165BW-4426, BW-4454
Bristlecone BarleywineBW-B-143BarleywineAug 28, 202679$260BW-4420, BW-4448, BW-4476
Lantern Row HazyBW-B-140IPAAug 19, 202672$200BW-4414, BW-4442, BW-4470
Sunday Quarry WheatBW-B-137Wheat beerAug 10, 202665$150BW-4436, BW-4464
Blue Heron PaleBW-B-134Pale aleAug 1, 202658$170BW-4430, BW-4458
Cinder Hill PorterBW-B-131PorterJul 23, 202651$175BW-4424, BW-4452
Tamarack SaisonBW-B-128SaisonJul 14, 202644$190BW-4418, BW-4446, BW-4474
Dockside KolschBW-B-125KolschJul 5, 202677$155BW-4412, BW-4440, BW-4468
Maple Rail BrownBW-B-122Brown aleJun 26, 202670$160BW-4434, BW-4462
Foghorn StoutBW-B-119StoutJun 17, 202663$185BW-4428, BW-4456
Switchback IPABW-B-116IPAJun 8, 202656$195BW-4422, BW-4450

2 more rows

Also included

  • Billing by account and monthDrill-down
  • Overdue invoicesDigest
  • Invoice falling dueNotificationGives the office manager a three-day heads-up so the reminder call to the buyer goes out before the due date.

Related templates