Dashboard
Grape & Grain — Live data
Monthly Summary
—
—
Total Net Sales
—
—
Total Purchase
—
—
Tax Collected
From Square
—
Profit Margin
(Net − Purchase) ÷ Net
—
Avg Daily Sale
—
—
Customers
Transactions from Square
—
Avg Ticket
Net ÷ Transactions
—
Est. Monthly Sale
Avg daily sale × days in month
—
Est. Monthly Purchase
Avg daily purchase × days in month
—
Days Reported
—
—
Discounts
—
Returns
—
Fees
—
Scratch Lotto
Top 5 categories this month
Loading...
Pending Payments
Loading...
Category Tracker
Top 5 from Square — actual vs estimated this month
Loading...
Daily Net Sales — This Week
Loading...
Low Inventory
Loading...
Daily Reports
All staff submitted reports
| Date | Status | Net Sales | Scratch Sold | Lottery Net | Payouts | Safe Drop | Bank Deposit | By |
|---|---|---|---|---|---|---|---|---|
Loading... | ||||||||
Item Manager
Loading...
Add New Item
Add a new product from the county catalog
County information
Store information (Square POS)
Price History
Auto-logged when items are edited
| Date | Item | ABS Code | Field | Old value | New value | Change % |
|---|---|---|---|---|---|---|
Loading... | ||||||
Order Builder
Run Sync Inventory in Item Manager first, then pull sales below
Order History
All submitted orders
| Order | Type | Date | Delivery | Status | Items | Est. Cost |
|---|---|---|---|---|---|---|
Loading... | ||||||
Financial
Cash balance, checks, bills, expenses & P&L
Invoices
Track and manage all invoices
Vendors
Manage your vendor list
Category Sales
Monthly category breakdown from Square
Loading...
Settings
Store configuration
Store info
Square integration
Import CSV from Square
Export Category Sales or Item Sales from Square dashboard → upload here. Any date range works — re-importing same dates overwrites.
Category Sales CSV
Item Sales CSV
Catalog sync
Pull all categories and items from Square — run monthly or after catalog changes
Sync refunds
Update returns & tax for a date range — run after syncing a previous month
Order sync (daily totals)
Pull daily net sales — nightly sync runs at 2am EST automatically
ABS Newsletter Import
Upload the monthly ABS newsletter PDF to import discounts and price changes
—
Active Value
—
Active Tickets
—
Low Stock
All games from MD Lottery. Used to auto-fill face value and pack size when assigning a game to a box.