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 |
|---|
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
📚 Josh's Book Nook
Book club hub — external site connection coming soon
🔗
External Site Not Yet Connected
Josh's Book Nook runs on a separate website. Once you're ready to connect it, we'll pull in live data — members, current reads, meeting schedules, and more. For now, manage your Book Nook info manually below.
Book Picks
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
Event Calendar
Markets, pop-ups, events & Gamilla Experiences
🛒 Market Prep Planner
Select an upcoming event and set batch counts to get your shopping list
📦 Inventory
Stock levels, par alerts & barcode scanning
| Ingredient | In Stock | Par Level | 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 |
|---|