Report A — Full Machine 311 Activity (All Transactions)
All sales: coupon + credit card + cash. Amounts are NAYAX-recorded prices. Source: TRANSACTIONS sheet.
PeriodSort within period
Period
BIN
Product
Contract $
Qty
Recorded Rev
Ing. Cost
Gross Profit
Margin
Loading…
Report B — Dealer Billing (Ford Vista · Coupon Only · Contract Prices)
Coupon/prepaid transactions only, billed at agreed contract prices from COFFEE_MASTER. Use for monthly invoicing to the dealership.
Period
Period
BIN
Product
Contract $
Qty
Billed $
Ing. Cost
Profit
Margin
Loading…
Full Inventory Status
StatusGroupSort
Product
Group
BINS
PAR
Purchased
Sold
Stock
vs PAR
Wk Rate
Wks Stock
Status
Loading…
Weekly NAYAX Reimbursements
Year
Week
Date
Gross
Fees
Net
Fee %
Status
Loading…
Costs by Site — All Time
Site
Visits
Total Cost
Avg/Visit
Revenue vs Cost by Site
Site / Machine(s)
Revenue
Costs
Net
Visits Log
SiteType
No visits logged yet. Use admin.snacksolutionsllc.com → Visits & Costs to log visits.
Date
Site
Type
Cost
Notes
Command Triggers
Paste your Apps Script Web App URL below, then use the buttons to trigger functions remotely.
Results appear in the Upload Log below after a few seconds — refresh the page to see them.
① Daily / Sales
Pull sales from NAYAX. Runs hourly on a trigger — buttons here are for on-demand refresh.
② Purchases & Costs
SAMS/Amazon → review in AMZ_MAPPING → Commit → PURCHASE_LOG. Then Cost Preview → review COST_REVIEW → Apply.
③ Reimbursements
Weekly NAYAX dealer reimbursement — automatic from Gmail, or manual from the Excel file.
④ Data Pipeline & Maintenance
Landing-layer rebuild and full recomputes. Use after corrections or bulk imports.