Brewery Taproom Desk
Craft breweries, cideries and taproom operators
For brewers and taproom managers: batches, tanks, kegs, tap list, distributor orders.
Use this templateBrewery Taproom Desk
Dashboard
Start here
Brew day log
Keg handling and tracking
Draft line cleaning
Wholesale orders and deliveries
Batches
Every brew from planned to packaged, with the date it will be ready.
| Batch | Stage | Style | Brewed | Ready | Packaged on | Volume (barrels) |
|---|---|---|---|---|---|---|
| Harbor Fog hazy IPA, batch 31 | Fermenting | Nov 12, 2026 | Nov 24, 2026 | — | 7 | |
| Pale Rider pale ale, batch 28 | Conditioning | Nov 2, 2026 | Nov 17, 2026 | — | 7 | |
| Switchback lager, batch 12 | Conditioning | Oct 19, 2026 | Nov 19, 2026 | — | 7 | |
| Midnight Ledger stout, batch 9 | Packaged | Oct 15, 2026 | Oct 29, 2026 | Oct 29, 2026 | 7 | |
| Orchard Gate saison, batch 6 | Packaged | Oct 4, 2026 | Oct 21, 2026 | Oct 21, 2026 | 3.5 | |
| Pumpkin Hollow seasonal, batch 3 | Planned | Nov 26, 2026 | Dec 16, 2026 | — | 3.5 | |
| Mountain Lemon sour, batch 4 | Fermenting | Nov 9, 2026 | Nov 30, 2026 | — | 3.5 | |
| Harbor Fog hazy IPA, batch 30 | Packaged | Oct 21, 2026 | Nov 4, 2026 | Nov 4, 2026 | 7 |
Kegs
Every keg and where it is: cooler, tap, empty or out with a customer.
| Keg | Where | Size | Filled | Location | Keg deposit (USD) | Due back |
|---|---|---|---|---|---|---|
| Midnight Ledger sixth, blue tag | On tap | Nov 4, 2026 | Bar rail, left | — | — | |
| Midnight Ledger half, red tag | In cooler | Nov 4, 2026 | Cooler row A | — | — | |
| Orchard Gate sixth, green tag | On tap | Oct 23, 2026 | Window tap | — | — | |
| Orchard Gate sixth, yellow tag | In cooler | Oct 23, 2026 | Cooler row B | — | — | |
| Harbor Fog sixth, white tag | Empty | Oct 9, 2026 | Back dock | — | — | |
| Harbor Fog half, black tag | On tap | Nov 6, 2026 | Bar rail, center | — | — | |
| Harbor Fog half, orange tag | At customer | Nov 6, 2026 | Cask & Cleaver pub | $100 | Dec 6, 2026 | |
| Orchard Gate sixth, purple tag | At customer | Oct 23, 2026 | Birch Street Tavern | $50 | Nov 16, 2026 |
Tap list
What is pouring on each tap, its price and when the line was cleaned.
| Tap | Status | Pint price (USD) | Line cleaned | Next line clean | Keg | Looks after |
|---|---|---|---|---|---|---|
| Bar rail, left | Pouring | $7 | Nov 12, 2026 | Nov 26, 2026 | Midnight Ledger sixth, blue tag | Lucinda Castellanos |
| Bar rail, center | Pouring | $7 | Nov 12, 2026 | Nov 26, 2026 | Harbor Fog half, black tag | Lucinda Castellanos |
| Bar rail, right | Kicked | $7 | Nov 5, 2026 | Nov 19, 2026 | — | Lucinda Castellanos |
| Window tap | Pouring | $8 | Nov 5, 2026 | Nov 19, 2026 | Orchard Gate sixth, green tag | Lucinda Castellanos |
| Patio tap | Cleaning | $6.50 | Nov 4, 2026 | Nov 17, 2026 | — | Lucinda Castellanos |
Wholesale orders
Keg orders for bars and shops, from request to delivery.
| Order | Status | Account | Channel | Delivery date | Delivered on | Kegs ordered |
|---|---|---|---|---|---|---|
| Cask & Cleaver, weekly | Delivered | Cask & Cleaver pub | Nov 15, 2026 | Nov 15, 2026 | 2 | |
| Birch Street Tavern, monthly | Delivered | Birch Street Tavern | Nov 8, 2026 | Nov 8, 2026 | 3 | |
| Hollow Oak Grill, new account | Confirmed | Hollow Oak Grill | Nov 19, 2026 | — | 4 | |
| Cask & Cleaver, next week | Requested | Cask & Cleaver pub | Nov 27, 2026 | — | 2 | |
| Riverbend Bottle Shop, cans | Requested | Tri-County Beverage, for Riverbend Bottle Shop | Dec 2, 2026 | — | 0 | |
| Summit Ski Lodge, winter menu | Confirmed | Tri-County Beverage, for Summit Ski Lodge | Nov 22, 2026 | — | 6 | |
| Birch Street Tavern, missed drop | Confirmed | Birch Street Tavern | Nov 17, 2026 | — | 1 |
Taproom events
Trivia nights, live music and releases that fill the room.
| Event | Status | Kind | Date | Closed on | Expected guests | Guests who came |
|---|---|---|---|---|---|---|
| Tuesday trivia night | Confirmed | Nov 17, 2026 | — | 60 | — | |
| Pumpkin Hollow release party | Planned | Dec 16, 2026 | — | 120 | — | |
| Friday acoustic duo | Confirmed | Nov 20, 2026 | — | 90 | — | |
| Saturday run club | Confirmed | Nov 21, 2026 | — | 40 | — | |
| Last Tuesday trivia | Held | Nov 12, 2026 | Nov 12, 2026 | 60 | 72 | |
| Midnight Ledger release night | Held | Oct 28, 2026 | Oct 28, 2026 | 110 | 138 | |
| Retirement party for a regular | Planned | Dec 7, 2026 | — | 35 | — | |
| Next Tuesday trivia | Planned | Nov 24, 2026 | — | 60 | — |
Tanks
Every fermenter and brite tank, what is in it and when it was last cleaned.
| Tank | State | Kind | Size (barrels) | Last cleaned and sanitized | Set temperature (F) | Batch in it |
|---|---|---|---|---|---|---|
| Fermenter 1, 7 bbl | Fermenting | 7 | Oct 29, 2026 | 66 | Harbor Fog hazy IPA, batch 31 | |
| Fermenter 2, 7 bbl | Cleaning | 7 | Nov 17, 2026 | — | — | |
| Fermenter 3, 3.5 bbl | Fermenting | 3.5 | Oct 19, 2026 | 68 | Mountain Lemon sour, batch 4 | |
| Brite tank 1, 7 bbl | Carbonating | 7 | Oct 18, 2026 | 33 | Switchback lager, batch 12 | |
| Brite tank 2, 7 bbl | Conditioning | 7 | Nov 1, 2026 | 34 | Pale Rider pale ale, batch 28 | |
| Barrel rack, oak | Empty | 1 | Sep 19, 2026 | — | — |
Production, kegs and the taproom at a glance.
| Batch | Stage | Style | Brewed | Ready | Packaged on | Volume (barrels) |
|---|---|---|---|---|---|---|
| Harbor Fog hazy IPA, batch 31 | Fermenting | Nov 12, 2026 | Nov 24, 2026 | — | 7 | |
| Pale Rider pale ale, batch 28 | Conditioning | Nov 2, 2026 | Nov 17, 2026 | — | 7 | |
| Switchback lager, batch 12 | Conditioning | Oct 19, 2026 | Nov 19, 2026 | — | 7 |
| Keg | Where | Size | Filled | Location | Keg deposit (USD) | Due back |
|---|---|---|---|---|---|---|
| Midnight Ledger sixth, blue tag | On tap | Nov 4, 2026 | Bar rail, left | — | — | |
| Midnight Ledger half, red tag | In cooler | Nov 4, 2026 | Cooler row A | — | — | |
| Orchard Gate sixth, green tag | On tap | Oct 23, 2026 | Window tap | — | — |
| Order | Status | Account | Channel | Delivery date | Delivered on | Kegs ordered |
|---|---|---|---|---|---|---|
| Cask & Cleaver, weekly | Delivered | Cask & Cleaver pub | Nov 15, 2026 | Nov 15, 2026 | 2 | |
| Birch Street Tavern, monthly | Delivered | Birch Street Tavern | Nov 8, 2026 | Nov 8, 2026 | 3 | |
| Hollow Oak Grill, new account | Confirmed | Hollow Oak Grill | Nov 19, 2026 | — | 4 |
| Event | Status | Kind | Date | Closed on | Expected guests | Guests who came |
|---|---|---|---|---|---|---|
| Tuesday trivia night | Confirmed | Nov 17, 2026 | — | 60 | — | |
| Pumpkin Hollow release party | Planned | Dec 16, 2026 | — | 120 | — | |
| Friday acoustic duo | Confirmed | Nov 20, 2026 | — | 90 | — |
Ready in the next 7 days
| Batch | Stage | Style | Brewed | Ready | Packaged on | Volume (barrels) |
|---|---|---|---|---|---|---|
| Harbor Fog hazy IPA, batch 31 | Fermenting | Nov 12, 2026 | Nov 24, 2026 | — | 7 | |
| Pale Rider pale ale, batch 28 | Conditioning | Nov 2, 2026 | Nov 17, 2026 | — | 7 | |
| Switchback lager, batch 12 | Conditioning | Oct 19, 2026 | Nov 19, 2026 | — | 7 |
Line cleaning due
| Tap | Status | Pint price (USD) | Line cleaned | Next line clean | Keg | Looks after |
|---|---|---|---|---|---|---|
| Bar rail, left | Pouring | $7 | Nov 12, 2026 | Nov 26, 2026 | Midnight Ledger sixth, blue tag | Lucinda Castellanos |
| Bar rail, center | Pouring | $7 | Nov 12, 2026 | Nov 26, 2026 | Harbor Fog half, black tag | Lucinda Castellanos |
| Bar rail, right | Kicked | $7 | Nov 5, 2026 | Nov 19, 2026 | — | Lucinda Castellanos |
Deliveries in the next 7 days
| Order | Status | Account | Channel | Delivery date | Delivered on | Kegs ordered |
|---|---|---|---|---|---|---|
| Cask & Cleaver, weekly | Delivered | Cask & Cleaver pub | Nov 15, 2026 | Nov 15, 2026 | 2 | |
| Birch Street Tavern, monthly | Delivered | Birch Street Tavern | Nov 8, 2026 | Nov 8, 2026 | 3 | |
| Hollow Oak Grill, new account | Confirmed | Hollow Oak Grill | Nov 19, 2026 | — | 4 |
How to read the numbers
Tanks
| Tank | State | Kind | Size (barrels) | Last cleaned and sanitized | Set temperature (F) | Batch in it |
|---|---|---|---|---|---|---|
| Fermenter 1, 7 bbl | Fermenting | 7 | Oct 29, 2026 | 66 | Harbor Fog hazy IPA, batch 31 | |
| Fermenter 2, 7 bbl | Cleaning | 7 | Nov 17, 2026 | — | — | |
| Fermenter 3, 3.5 bbl | Fermenting | 3.5 | Oct 19, 2026 | 68 | Mountain Lemon sour, batch 4 |
Kegs out past their return date
| Keg | Where | Size | Filled | Location | Keg deposit (USD) | Due back |
|---|---|---|---|---|---|---|
| Midnight Ledger sixth, blue tag | On tap | Nov 4, 2026 | Bar rail, left | — | — | |
| Midnight Ledger half, red tag | In cooler | Nov 4, 2026 | Cooler row A | — | — | |
| Orchard Gate sixth, green tag | On tap | Oct 23, 2026 | Window tap | — | — |
Before brewing
On the day
During fermentation
Final gravity and ABV
When gravity is steady, enter final gravity and the ABV. A batch that stops high may have tired yeast or too cold a tank.
Packaging
Tank cleaning
Clean and sanitize every tank after it empties, and write the date. A tank sitting dirty for days is a contamination risk.
Tasting panel
Taste every batch at transfer and at packaging with at least two people. Note off-flavors on the batch: diacetyl (buttery), acetaldehyde (green apple), oxidation (cardboard).
Example
The Midnight Ledger stout packaged 6.4 of 7 barrels, a cellar loss near 9 percent. The brewer notes that the dry-hop and the transfer hose length both cost beer, and shortens the hose for the next batch.
Tag every keg
Give each keg a colored tag or number that does not come off. Enter it with its size. Half barrels and sixth barrels are tracked the same way.
Where a keg can be
Filling
Delivering
Getting kegs back
Freshness
Hazy and hoppy beers are best within six to eight weeks of filling. Stouts and lagers keep longer cold. Sell oldest first: check filled on before choosing which keg to tap or deliver.
Counting
Once a month, count every keg in the building and compare with the list. Kegs that are nowhere get a call to the last account that had them.
Cleaning returned kegs
Example
The Orchard Gate sixth with the purple tag has been at Birch Street Tavern past its return date. The rep picks it up with Thursday's delivery and records one empty collected.
The schedule
How to clean a line
Signs a line needs cleaning sooner
Pouring well
Kicked kegs
When a keg kicks, set the tap to Kicked, change the keg, and pour off foam. Use the changeover to wipe the coupler.
Glycol and cooler
Check the cooler at 34 to 38 degrees and the glycol chiller every week. Warm beer in the line pours foam, whatever the pressure.
Safety
Wear gloves and eye protection with line cleaner. Never mix caustic and acid. Label the cleaning bucket.
Example
The window tap and the right rail tap are due for cleaning next. The patio tap is a day past its date and is being cleaned now, so it is out of service until the evening, and the next clean is booked two weeks out.
Two ways to sell
Rules on self-distribution differ by state; check yours.
Taking an order
Delivery day
Invoicing
Keeping accounts
Missed deliveries
A confirmed order whose delivery date has passed shows under Overdue. Call the account that morning with a new time; a bar that runs out of your beer puts someone else's on the tap.
Distributor orders
Distributors order on a schedule. Plan their volume four to six weeks ahead so the tanks are free in time, and agree how they report sales by account.
Example
Hollow Oak Grill is a new account taking four kegs this week. The rep sets payment on delivery for the first three orders and books a visit two weeks later to taste the beer on their lines.
The lists
How the numbers work
Your first week
The weekly rhythm
Example
The Switchback lager is carbonating in brite tank 1 and ready this week, so the right-hand tap, which kicked, will pour it next. Fermenter 2 is being cleaned for the seasonal brew in eight days.
What's inside
7 tables · 29 views · 1 form · 4 row actions · 1 agent7 pages
- Brewery Taproom Desk
- Dashboard
- Brew day log
- Keg handling and tracking
- Draft line cleaning
- Wholesale orders and deliveries
- Start here
6 tables
- Batches6 views · 8 sample rows
- Kegs3 views · 10 sample rows
- Tap list6 views · 5 sample rows
- Wholesale orders6 views · 7 sample rows
- Taproom events6 views · 9 sample rows
- Tanks2 views · 6 sample rows
Questions
- What is included in the Brewery Taproom Desk template?
- 7 pages (Brewery Taproom Desk, Dashboard, Brew day log, Keg handling and tracking, Draft line cleaning and 2 more) and 6 tables (Batches, Kegs, Tap list, Wholesale orders, Taproom events and 1 more), filled with 45 sample rows so every view opens with realistic data.
- Who is the Brewery Taproom Desk template for?
- Craft breweries, cideries and taproom operators.
- Is the Brewery Taproom Desk template free?
- Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
- Can I change the template after I use it?
- Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.
Related workspaces
Boutique Hotel DeskFor innkeepers: rooms, reservations, housekeeping status, repairs, occupancy and ADR.
Catering Business DeskFor caterers: proposals, event orders, prep and pack lists, food and labor cost per event.
Coffee Shop OperationsFor cafe owners and baristas: drink margins, dial-ins, pars, waste, orders, machine care.
Food Truck OperationsFor food truck owners: stops, sales, menu food cost, permits, commissary prep, bookings.
Restaurant Operations HubFor chefs and restaurant owners: recipe costs, food cost, pars, prep lists, inspections.
Small Bakery DeskBake to par and pre-orders, cost recipes, take cake orders and run wholesale accounts.