Hello
Welcome
Clock Out closes the shift and computes hours automatically.
Today's Tasks
My summary
Your hours, your pay, your pay period.
Upload CSV
Drag a CSV file here or
Add manual record
Records
| Date | Employee | Hours | Sales | Gross profit | Pay |
|---|
No records yet.
POS Import
Upload your POS files. The system auto-computes hours from invoice timestamps, profit per day, and assigns each day to the person from Schedule. Run end-of-day for live remote visibility.
📈 Invoice Detail
Per-invoice file with cashier & timestamps. Yields hours + sales per day.
Drag .xlsx or
💰 Profit Analysis
Daily summary with profit per date.
Drag .xlsx or
Pay period summary
☁️ Backup & Restore
Right now all your data lives in this browser. Backup regularly to OneDrive/Dropbox/Drive so you don't lose anything. Best long-term: migrate to Supabase (cloud sync) — send me your credentials and I'll connect it.
📥 Backup (Download)
Download a single .json file with EVERYTHING: users, records, schedule, expenses, ledger, inventory, notes, tasks. Save it to OneDrive after.
📤 Restore (Upload)
Lost data? Switched browser/PC? Drop a backup file here to restore.
Drag a backup .json file here or
☁️ Supabase migration (recommended)
When you're ready, paste your Supabase Project URL and anon key here and we'll wire it up.
After saving credentials, use the sync buttons below.
Push = uploads your local data to Supabase (do this the first time and every time you change something).
Pull = downloads data from Supabase and replaces your local copy (use it when you open the app from another computer or phone).
Test = checks that your credentials and table are set up correctly.
📍 Store location (for Clock In verification)
Employees can only clock in within 150m of the store. Admins are always allowed.
When disabled, ALL employees on ANY device can clock in/out without GPS check. Use temporarily when GPS isn't working.
If this is the store computer (or a device with bad GPS), mark it as "trusted" so employees can clock in here without location check. Only affects THIS device.
Team & access
Create PINs for your team. Only admins can see this section.
| Name | Role | Created |
|---|
Pay & Recognition
Pick a date range and an employee — generate their pay card with hours, profit, best day and total pay.
Monthly Close
Full P&L card for the month — sales, expenses by category, payroll, net profit.
Report something
Pick one, tell us what it is, done. It goes straight to the right list.
Open signals
Team notes
What's running low, what customers are asking for — everything worth keeping in view.
Store Performance
What is driving sales, profit and stock. Every number below comes from the POS reports — nothing is estimated.
Weekly analysis
How the week looks — which days sell the most, which employee is busiest.
Today's Tasks
Configure tasks (admin)
Click day chips on each task to toggle which days it runs. Use ↑↓ to reorder. Click the text to edit it.
🧾 Submit a work expense
Did you pay for something for the store? Add it here so admin can reimburse you or log it.
Recent submissions
| Date | Submitted by | Paid by | Description | Amount |
|---|
💵 Cash Ledger & Debt Tracker
Manual entries for cash given, cash taken from register, payments to vendors not on bank. Running balance shown live.
| Date | Type | Description | In | Out | Running balance |
|---|
No entries yet.
Expense analysis — Chase
Upload the bank CSV (Chase). Every transaction is categorized automatically.
Drag the Chase CSV here or
Schedule
Assign who works each day. When you import the POS file, the system uses this to credit hours and profit to the right person (instead of the shared "Josh" POS account).
Ver calendario completo del mes
Owner Pay — Josh 1 / Josh 2 / Josh 3
Totals come from two places: (1) bank transactions you tag to each Josh in Expenses (the Owner column — go month by month), and (2) manual entries below (for cash or anything not on the statement). Everything syncs to all devices.
Pay — Venmo
💳 Scan to pay with Venmo
Show this to the customer at checkout — they scan and pay Grand Wine & Spirits.
📲 Join the Club
Después de cobrar, muéstrale este QR al cliente para que se una a la lista — se entera primero de ofertas, botellas nuevas y tastings.
Club
📲 QR for customers
Show or print this QR at the register. The customer scans it and joins your list — to hear first about offers, new bottles & tastings. No paper.
👥 Club members
✉️ Messages from the website
Tastings & DJs
📅 Calendar — upcoming tastings & DJ nights
Add a tasting or a DJ night and see what's coming up.
📇 Contacts — DJs & Suppliers
Your little black book for booking tastings and DJs.
📊 Finances
Built from the bank statement and the POS sales report. Nothing is entered by hand.
📦 Paid & Waiting
Already paid & stored at FDL. Request these cases before purchasing more.
Older inventory tool — dashboard, purchase orders, exports
Inventory Intelligence
Upload your inventory files. The more you upload, the smarter the insights.
🍷 Full Inventory History
Stock + period sales per SKU
Drag or
📊 Sales by Items
Item-level sales (unlocks profit per item)
Drag or
💰 Price Adjustments
Cost & price change history
Drag or
🧩 Quick look — what to do
The 3 things that matter, in plain words.
📊 Quick read
⭐ Your stars this period
Best-selling items — the ones to NEVER let go out of stock.
💡 Smart insights
🚨 Order this NOW
Items selling fast and running low (≤ 14 days of stock at current rate).
📊 Sales by category
How sales split by Wine, RTD, etc.
🏪 Top vendors
Vendors that move the most units. Useful for reorder calls.
📞 Reorder by vendor
Grouped reorder alerts — one call/email per vendor with all their items needing reorder.
🏆 Top movers
Top 20 by sales velocity this period.
🐢 Slow movers
High stock, low sales — capital tied up here.
⚰️ Dead stock
Items in stock with zero sales this period.
🔎 Search all items
📇 Suppliers
Base de datos de proveedores para poder ordenar. Se pre-carga con los vendors de tu inventario — llena email, teléfono y rep de cada uno.
🍷 Wine Recommender
A customer asks for a wine? Use this. Type what they want — the app filters your live inventory.
📚 Wine Knowledge
Quick-study cards for the team. Read one a day — gets better at recommending.
Cashflow & Alerts
🚧 Coming soon: bank balance projection and alerts before overdrafts ($34 each in fees).
Events & Customers
🚧 Coming soon: tasting schedule, RSVPs, and a CRM with your regulars' preferences.
💬 Feedback Inbox
Suggestions, bugs, compliments — everything from the team. Click to acknowledge.
Team Performance
Sales performance is based on single-staff days; shared shifts are excluded.
Content Coach
Daily IG plan for @grandstwine · curated