{{ pageTitle }}
{{ k.label }}
{{ k.source }}
{{ k.value }}
{{ k.arrow }} {{ k.sub }}
Net revenue — trailing 21 days
{{ chartScope }} · {{ periodLabel }}
Toast
{{ g.label }}
{{ revTipText }}
{{ x }}
Prime cost by location
COGS + labor as % of net revenue, vs 60% target
COGS Labor MarginEdge + Toast + Paylocity
60% target
{{ b.tip }}
{{ b.prime }}
{{ b.labor }}
{{ b.cogs }}
{{ b.name }}
Alerts
{{ alertCount }}
{{ al.title }}
{{ al.detail }}
{{ al.source }}
Locations at a glance
Toast + MarginEdge + Paylocity
Location Revenue (MTD) COGS % Labor % Prime % 21-day trend
{{ r.name }}
{{ r.type }}
 {{ r.revenue }} {{ r.cogs }} {{ r.labor }} {{ r.prime }}
Company total
 {{ totalRow.revenue }} {{ totalRow.cogs }} {{ totalRow.labor }} {{ totalRow.prime }}
{{ locName }}
{{ locSub }}
{{ k.label }}
{{ k.source }}
{{ k.value }}
{{ k.arrow }} {{ k.sub }}
Sales by daypart
Toast
{{ d.label }}
{{ d.revenue }} · {{ d.pct }}
Menu / product mix
Top 8 items by net sales, MTD
Toast
Item Category Units Net sales Mix %
{{ m.item }} {{ m.cat }} {{ m.units }} {{ m.sales }}
{{ m.mix }}
Sales vs labor — trailing 21 days
{{ locShort }} · {{ periodLabel }}
Net sales Labor % of sales Toast + Sling + Paylocity
{{ g.label }}
Labor target {{ laborTargetLabel }}
{{ comboTipText }}
{{ x }}
Cost of goods detail
Top invoice categories, MTD
MarginEdge
Category Spend (MTD) % of sales vs prior period
{{ c.cat }} {{ c.spend }} {{ c.pct }} {{ c.delta }}
Greg · Period summary
{{ locBrief }}
Compiled 4:12 AM · Toast, QuickBooks, MarginEdge, Sling, Paylocity, Ekos
Greg flagged
{{ locAlertCount }}
{{ al.title }}
{{ al.detail }}
{{ al.source }}
{{ opsTabHint }}
{{ k.label }}
{{ k.source }}
{{ k.value }}
{{ k.arrow }} {{ k.sub }}
Scheduled vs actual hours
By location, MTD · variance = actual − scheduled
Scheduled Actual Sling + Paylocity
{{ g.tip }}
{{ g.varLabel }}
{{ g.name }}
{{ g.hrsLabel }}
Labor % of sales — trailing 21 days
{{ laborTrendScope }} · Jul 1–21, 2026
Toast + Paylocity
{{ g.label }}
Target {{ laborTrendTargetLabel }}
{{ ltTipText }}
{{ x }}
Overtime watch
Shifts trending into OT, week of Jul 14–20
Sling + Paylocity
Employee Location Role Sched hrs Actual hrs OT hrs Status
{{ o.name }} {{ o.loc }} {{ o.role }} {{ o.sched }} {{ o.actual }} {{ o.ot }} {{ o.badge }}
How to read this: scheduled hours come from Sling; actual hours and cost come from Paylocity's processed payroll. Variance compares the two after the nightly sync — a positive number means the floor ran more hours than the schedule called for.
SlingPaylocity
{{ k.label }}
{{ k.source }}
{{ k.value }}
{{ k.arrow }} {{ k.sub }}
Production by beer
BBL produced MTD · all brewed at Escondido
Ekos
{{ b.name }}
{{ b.bbl }}
Finished goods vs par
Half-barrel kegs on hand · marker = par level
Ekos
{{ f.name }}
{{ f.onHand }} · par {{ f.par }}
Batches in progress
8 active batches · Escondido brewhouse
Ekos
Batch Beer Stage Tank Started Ready (proj.) Progress
{{ b.id }} {{ b.beer }} {{ b.stage }} {{ b.tank }} {{ b.start }} {{ b.ready }}
{{ b.pct }}
Production → taproom: draft depletion across the four taprooms averaged 318 kegs/week MTD (Toast), drawing against finished goods brewed at Escondido (Ekos). Stonecrest IPA depletes fastest at 41% of company draft volume — which is why its par sits at 300 kegs.
ToastEkos
Cross-source analyses over your Stonecrest stack.
Featured Coming soon
{{ c.title }}
{{ c.desc }}
{{ c.cta }}
{{ soonTitle }}
{{ soonDesc }}
Coming soon — Greg is still plumbing the data for this one.
Prime Cost Command Center
Toast MarginEdge Sling + Paylocity QuickBooks Online
Data current — last synced 4:12 AM
{{ k.label }}
{{ k.source }}
{{ k.value }}
{{ k.sub }}
Prime cost trend — COGS and labor stacked to prime
{{ rpScopeName }} · % of net sales · rose shading = over the 60% target
COGS % Labor % Prime %
20%
40%
Target 60%
COGS
LABOR
{{ rpTipTitle }}
{{ rpTipBody }}
{{ x }}
Cost-mix map — what's driving prime cost
Right of the line = food cost problem · above = labor problem · bubble size = net sales
{{ lg.label }}
Labor % of sales
{{ g.label }}
{{ g.label }}
COGS + Labor = 60% target
UNDER TARGET
OVER TARGET
{{ b.name }}
{{ b.tip }}
COGS % of sales
Prime cost by location
Sorted worst first · dashed line = 60% target
MarginEdge + Paylocity
{{ d.name }} {{ d.prime }}
{{ d.cogs }}
{{ d.labor }}
COGS Labor 60% target
Prime cost detail by location
Click a column to sort · click a row to expand its drivers
Toast + MarginEdge + Sling + Paylocity
{{ c.label }}{{ c.arrow }}
{{ r.chev }}
{{ r.loc }}
{{ r.type }}
 {{ r.sales }} {{ r.cogsD }} {{ r.cogs }} {{ r.laborD }} {{ r.labor }} {{ r.primeD }} {{ r.prime }} {{ r.delta }}
Daily prime % · Jul 1–21
Toast + MarginEdge
60%
Top COGS categories · MTD
MarginEdge
{{ cc.cat }}{{ cc.spend }} · {{ cc.pct }}
Labor by daypart · MTD
Sling + Paylocity
{{ dp.label }}{{ dp.hrs }} hrs · labor {{ dp.pct }}
Prime cost = (COGS + Labor) ÷ Net Sales. Target ≤60%. COGS from MarginEdge invoices; Labor from Sling scheduled + Paylocity actual; Sales from Toast; reconciled to the QuickBooks P&L.
True Pint Profitability
What each beer actually earns on tap — production cost against pour price and pours across the four taprooms. Draft only; packaged & distribution tracked separately.
Ekos MarginEdge Toast
Data current — last synced 4:12 AM
{{ k.label }}
{{ k.source }}
{{ k.value }}
{{ k.sub }}
Margin per pour — price split into cost and margin
Sorted by margin per pour · navy = cost, orange = margin
Ekos + MarginEdge + Toast
{{ b.beer }} cost {{ b.cost }} · margin {{ b.margin }} · {{ b.marginPct }}
{{ b.cost }}
{{ b.price }}
{{ t.label }}
Pour price ($ per 16oz)
Volume vs margin — which taps to push
Bubble size = total gross profit · dashed lines = medians
{{ lg.label }}
Pours sold (volume)
median margin
{{ g.label }}
{{ g.label }}
Pour Stars ★
high margin + volume
Volume, thin margin
revisit price / cost
Hidden gems
feature / upsell
Review
candidates to rotate
{{ b.tip }}
Margin per pour ($)
Draft profitability by beer
Ranked by total gross profit · click a column to sort · click a row for the cost build-up
Ekos + MarginEdge + Toast
{{ c.label }}{{ c.arrow }}
{{ r.chev }}{{ r.beer }}low inventory
 {{ r.style }} {{ r.abv }} {{ r.cost }} {{ r.price }} {{ r.margin }} {{ r.marginPct }} {{ r.pours }} {{ r.gp }}
Price & pours by taproom
Toast
{{ tp.loc }}{{ tp.price }} · {{ tp.pours }} pours
Cost build-up / pour
MarginEdge + Ekos
{{ cr.k }}{{ cr.v }}
Production & inventory
Ekos
Kegs on hand vs par{{ r.kegs }} · par {{ r.par }}
{{ r.kegNote }} · {{ r.batches }} batch(es) in progress
Gross margin per pour = taproom pour price − (production cost/BBL ÷ 248 + packaging). Production cost from Ekos; ingredient & packaging cost from MarginEdge; pour price and pours from Toast. Draft/taproom only; packaged & distribution tracked separately.
All configured sources synced — completed 4:12 AM in 12m 38s
Run #412 · Paylocity was rate-limited, retried, and completed · Ekos is not yet configured. Morning digest sent via Resend.
{{ k.label }}
{{ k.value }}
{{ k.sub }}
Source status
Independent ingestion workers → Postgres warehouse (Railway) · orchestrated by nightly cron
Run #412 · Jul 22
Source Domain Status Rows loaded Duration Last success Sync method
{{ sr.name }} {{ sr.domain }} {{ sr.status }} {{ sr.rows }} {{ sr.duration }} {{ sr.lastSuccess }} {{ sr.method }}
Paylocity: rate-limited at 4:03 AM, backed off and retried — completed on attempt 2.
Run history — last 7 nights
Bar length = total run duration
{{ r.date }}
{{ r.status }}
{{ r.duration }}
Jul 20 failure: Toast S3 export was missing at 4:00 AM — the 6:30 AM rerun succeeded. Paylocity has warned on 2 of the last 5 runs.
Recent events · Run #412
Today · 4:00–4:12 AM PT
{{ lg.t }} {{ lg.src }} {{ lg.msg }}
Sync settings
Schedule
Nightly 4:00 AM · America/Los_Angeles
All locations report in Pacific Time; daily closes are normalized in the warehouse.
Notifications
ops@stonecrestbrewing.com via Resend
Morning digest after every run · immediate alert on failure
Sources
{{ st.name }}
{{ st.method }}
{{ st.note }}