Overview
Monthly Revenue
By Brand
By Division
Top Customers
Sales Dashboard
Daily Revenue
By Source
By Brand
By Location
Transactions
| Date | Customer | Item | Source | Brand | Amount |
|---|
Locations from Square + joshuagamilla.com. Tag each to a division.
My Inner Thoughts
Gamilla Entertainment - Podcast
Spotify
For Podcasters
Apple Podcasts
Connect
Apple Podcasts Connect API is invite-only. Update manually or connect via RSS.
Episodes
To connect live stats:
1. Spotify: Add
2. Apple: Update stats manually using the button above (Apple's API is invite-only)
3. All podcast revenue counts under Gamilla Entertainment division
1. Spotify: Add
SPOTIFY_CLIENT_ID and SPOTIFY_CLIENT_SECRET + SPOTIFY_SHOW_ID to Railway Variables, then visit /auth/spotify2. Apple: Update stats manually using the button above (Apple's API is invite-only)
3. All podcast revenue counts under Gamilla Entertainment division
Costs & Expenses
Operating expenses, vendor invoices & P&L overview
By Category
Outstanding Vendor Invoices
Operating Expenses
Vendor Invoices
Recipes & Food Cost
Menu development - Batch scaling - Food cost % - Ingredient costing
| Ingredient | Unit | Cost/Unit | Purchase | Category | Supplier |
|---|
Nutrition Label Builder
Link USDA data to ingredients, then create labels from recipes.
Food Cost % by Brand
Profit per Item
Full Menu Cost Breakdown
| Recipe | Brand | Category | Ingredient Cost | Selling Price | Gross Profit | FC% | Status |
|---|
Consumer Products
Non-food product cost breakdown & profit margin calculator
Use Product Type to keep recipe/food items separate from mugs, merch, kits, and other sellable products.
Josh's Book Nook
Book club hub - synced with your Wix website
Book Picks
Quarterly OKRs
Objectives & Key Results - your 90-day sprints toward the big vision
Business Plan
Living document - your vision, brand strategy & roadmap
Location Pipeline
Track every potential location for Dopamine Coffee & beyond
Brand Scorecards
Weekly health check for every brand in the Gamilla family
Budget Planner
Monthly budgets per brand & category - actual vs plan
Budget Lines
Actual vs Budget This Month
Idea Vault
Capture every idea - flavors, collabs, products, events, business moves
Decision Log
Record every key decision, who was involved, why, and what happened
AI Studio
Your Gamilla-powered creative team - each assistant knows your business
Launch Tracker
Track every product, event, and campaign from idea to live
Social Analytics
Track followers, engagement & growth across all brands and platforms
Loyalty Program
Reward your regulars - the Gamilla inner circle
| Name | Tier | Points | Visits | Total Spend | Last Visit |
|---|
Time Tracker
See where your hours actually go - by brand, by project
Hours by Brand (This Month)
Hours by Project (This Month)
Recent Entries
| Date | Brand | Project | Task | Time | Billable |
|---|
Wholesale & Consignment
Track every store, cafe, or retailer carrying your products
Customer Leads
Potential partnerships, wholesale accounts, consignment, and vendor relationships
Projects
Your built-in ClickUp-style workspace for projects, tasks, owners, dates, and status
Tax & Bookkeeping
Annual summary, quarterly breakdown & expense categories - ready for your accountant
Quarterly Breakdown
Expenses by Category
HST Estimate (Ontario 13%)
Flow Planner
This week
Task Inbox
Real-time activity - Square + Wix + notifications
Admin
Team access, brand management, location tagging, and backups.
Brands appear in recipe filters, expense forms, and consumer products across Central Command.
Tag each location to a division. Affects how revenue is categorized across dashboards.
Source Files
Download the actual application files. Replace these on Railway to deploy updates - your data files in
/data/ are never touched.server.js
Node.js backend - all API routes, auth, Square & Wix sync logic
index.html
Full frontend - all pages, UI, and JavaScript in one file
Full Data Backup
Everything in one JSON file - customers, recipes, ingredients, expenses, invoices, products, brands, and more. Use this before making any edits so you never lose a thing.
Individual Data Files
Download any single dataset as JSON. Useful for editing a specific section and re-uploading, or importing into a spreadsheet.
${[
['customers',' Customers','CRM customer records'],
['recipes',' Recipes','All recipe data'],
['ingredients',' Ingredients','Ingredient master list + costs'],
['expenses',' Expenses','Operating expenses'],
['vendor_invoices',' Vendor Invoices','Supplier invoices'],
['products',' Products','Consumer products'],
['divisions',' Divisions','Location & division tags'],
['brands',' Brands','Brand list config'],
].map(([f,label,desc])=>`
`).join('')}
${label}
${desc}
Good morning, Joshua
Calendar
View selected Google and Outlook calendars
Events
View Wix and manual event dates, then plan what you need for each event
Inventory
Ingredients, packaging materials, products, supplies & finished recipe batches
Quick Scan Mode
Camera ready - point at a barcode
| Ingredient | Type | Stock | Par | Unit | Value | Status |
|---|
| Material | Type | Stock | Par | Unit | Value | Status |
|---|
| Product | SKU / Barcode | Stock | Par | Unit | Status |
|---|
| Recipe / Item | Batches Made | Units Available | Made On | Expires |
|---|
| Item | Type | Stock | Par | Unit | Value | Status |
|---|
Supplier Directory
Contacts, lead times & ordering info
Staff & Shifts
Scheduling for markets, events & pop-ups
| Staff | Role | Event | Date | Time | Hours | Pay | Status |
|---|
Client Invoices
Create & track outgoing invoices for Gamilla Experiences and events
| Invoice # | Client | Brand | Issue Date | Due | Total | Status |
|---|
Cash Flow Forecast
Fixed costs, projections & 90-day outlook
Fixed Monthly Costs
30/60/90 Day Outlook
Content Calendar
Plan posts, reels, episodes & campaigns across all brands
Novel Tracker
Your fantasy romance - track progress, chapters & writing sessions
Goals & Milestones
Your vision, tracked - business, personal, and community
Community Impact
Fundraising, donors, volunteers & nonprofit tracking
| Name | Amount | Date | Recurring |
|---|