AI Matrx Logo

Coffee shop

Silverbirch Valley Coffee · Coffee shop · Bellingham, WA

Viggo Garroway owns Silverbirch Valley Coffee, an independent coffee shop in Bellingham, and he uses this to know what is on every shelf and in the cooler, so an order goes in before the espresso beans or the oat milk are gone.

Food and hospitalityInventoryImports4 tables · 6 views · 1 form · 3 dimension sets · 1 dashboard · 1 digest · 1 document · 1 notification · 1 agent
Use this template

Stock board

Stock
In stock14
House blend whole beanSBV-1101Beans
Single-origin Ethiopia whole beanSBV-1103Beans
Cold brew coarse grindSBV-1105Beans
Almond milkSBV-1108Milk and dairy
Vanilla syrupSBV-1111Syrups and sauces
9 more
Low6
Whole milkSBV-1106Milk and dairy
Caramel sauceSBV-1112Syrups and sauces
Hot cups, 16 ozSBV-1117Cups and lids
Hot cup lids, fits 12 and 16 ozSBV-1119Cups and lids
Butter croissants, par-bakedSBV-1121Bakery
1 more
Reorder now4
Espresso roast whole beanSBV-1104Beans
Oat milk barista blendSBV-1107Milk and dairy
Half and halfSBV-1109Milk and dairy
Heavy whipping creamSBV-1110Milk and dairy
On order6
Decaf Swiss water whole beanSBV-1102Beans
Mocha sauceSBV-1113Syrups and sauces
Iced cups, 16 ozSBV-1118Cups and lids
Blueberry muffins, par-bakedSBV-1122Bakery
Trash liners, 33 galSBV-1127Cleaning and paper
1 more
Retired0

Tables

Stock

30 sample rows · 17 columns

Everything on the shelves and in the cooler, with how many are on hand, where the reorder point sits and when it is next counted.

ProductSKUCategoryComes asKept inOn handReorder point
Almond milkSBV-1108Milk and dairycase of 12 quartsWalk-in cooler73
Blueberry muffins, par-bakedSBV-1122Bakerytray of 24Walk-in cooler23
Butter croissants, par-bakedSBV-1121Bakerytray of 24Walk-in cooler43
Caramel sauceSBV-1112Syrups and sauces64 oz jugBar shelf43
Chai concentrateSBV-1115Syrups and sauces32 oz cartonWalk-in cooler106
Cinnamon sconesSBV-1123Bakerytray of 12Walk-in cooler32
Cold brew coarse grindSBV-1105Beans5 lb bagBack stockroom116
Compostable stir sticksSBV-1130Cups and lidsbox of 1000Dry storage63
Cup sleevesSBV-1120Cups and lidspack of 500Dry storage52
Decaf Swiss water whole beanSBV-1102Beans5 lb bagBack stockroom56
Disposable gloves, mediumSBV-1129Cleaning and paperbox of 100Dry storage94
Espresso roast whole beanSBV-1104Beans5 lb bagBar shelf78

18 more rows

Suppliers

6 sample rows · 14 columns

The roaster, dairy and other vendors the shop buys from, with a rep, payment terms and how many days a delivery takes.

SupplierAccount repRep phoneRep emailAccount numberPayment termsLead time
Brindlewick Janitorial SupplySunniva Rask(360) 555-0116sunniva.rask@brindlewickjanitorialsupply.comSBV-60222Net 304
Corrigan Paper and PackagingBriar Eskelund(360) 555-0114briar.eskelund@corriganpaperandpackaging.comSBV-60148Net 304
Fenwick Ridge RoastersCalloway Imrie(360) 555-0111calloway.imrie@fenwickridgeroasters.orgSBV-60037Net 153
Halloran Mill BakehouseTeodor Quill(360) 555-0115teodor.quill@hallaranmillbakehouse.netSBV-60185Prepaid1
Larkmoor CreameryHanneke Obuya(360) 555-0112hanneke.obuya@larkmoorcreamerydairy.comSBV-60074Net 152
Pennywhistle Syrup CompanyOsgood Varga(360) 555-0113osgood.varga@pennywhistlesyrupcompany.netSBV-60111Net 305

Deliveries

16 sample rows · 9 columns

Each delivery from a supplier: what was on it, when it was ordered and when it arrived.

DeliverySupplierStatusOrderedExpectedArrivedItems
DL-5114Corrigan Paper and PackagingExpectedOct 4, 2026Oct 9, 2026—Iced cups, 16 oz
DL-5113Pennywhistle Syrup CompanyExpectedOct 3, 2026Oct 8, 2026—Mocha sauce
DL-5112Fenwick Ridge RoastersExpectedOct 2, 2026Oct 7, 2026—Decaf Swiss water whole bean
DL-5116Brindlewick Janitorial SupplyExpectedOct 4, 2026Oct 7, 2026—Portafilter cleaner, Trash liners, 33 gal
DL-5115Halloran Mill BakehouseExpectedOct 5, 2026Oct 6, 2026—Blueberry muffins, par-baked
DL-5111Larkmoor CreameryDeliveredSep 26, 2026Sep 28, 2026Sep 28, 2026Whole milk, Oat milk barista blend, Half and half, Heavy whipping cream
DL-5110Fenwick Ridge RoastersDeliveredSep 23, 2026Sep 26, 2026Sep 26, 2026Espresso roast whole bean, Decaf Swiss water whole bean, Cold brew coarse grind
DL-5109Corrigan Paper and PackagingCreditedSep 16, 2026Sep 20, 2026Sep 20, 2026Hot cups, 16 oz, Iced cups, 16 oz, Cup sleeves
DL-5108Halloran Mill BakehouseDeliveredSep 14, 2026Sep 15, 2026Sep 15, 2026Butter croissants, par-baked, Blueberry muffins, par-baked, Cinnamon scones
DL-5107Brindlewick Janitorial SupplyShort-shippedSep 5, 2026Sep 9, 2026Sep 10, 2026Paper towels, hand, Sanitizer tablets, Disposable gloves, medium
DL-5106Larkmoor CreameryDeliveredSep 2, 2026Sep 4, 2026Sep 4, 2026Whole milk, Almond milk, Heavy whipping cream
DL-5105Fenwick Ridge RoastersDeliveredAug 26, 2026Aug 29, 2026Aug 29, 2026House blend whole bean, Single-origin Ethiopia whole bean, Cold brew coarse grind

4 more rows

Views

Count calendar

Stock
October 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8Butter croissants, par-bakedBlueberry muffins, par-baked+2
9
10
11Whole milkOat milk barista blend+3
12
13
14
15
16
17House blend whole beanDecaf Swiss water whole bean+3
18
19Vanilla syrupCaramel sauce+3
20
21
22
23
24
25Hot cups, 12 ozHot cups, 16 oz+4
26
27
28
29
30
31

Forms and booking

Add a stock item

Form
Add a stock itemFilled in when a new product arrives, so it has a place and a count day from the start.
What is the item called? *
What SKU does it carry? *SBV- and four digits.
Which group does it belong to? *BeansMilk and dairySyrups and saucesCups and lidsBakeryCleaning and paper
How does it come packed?
Where will it be kept?Bar shelfWalk-in coolerBack stockroomDry storage
How many are on hand today?
Add to the list

Dashboards

Shelf health

Stock
Stock by status
  • In stock14
  • On order6
  • Reorder now4
  • Low6
Stock by group
  • Beans5
  • Milk and dairy5
  • Syrups and sauces5
  • Cups and lids6
  • Bakery4
  • Cleaning and paper5
Counts due by week
  • Oct 4, 20264
  • Oct 11, 202610
  • Oct 18, 20265
  • Oct 25, 20266
  • Nov 1, 20265

Also included

  • Monday reorder listDigest
  • Use-by date closeNotificationWarns the shift lead two days before dairy or bakery stock passes its use-by date.
  • Delivery note to a supplierDocumentThe short note that goes with an order, naming the day the shop needs it.

Related templates