The Catering Group
The Catering Group
Clubs Catering Pty Ltd · XCLUBS · vCFO Dashboard
Aug 25 – Mar 26 · 8 Months
BYN Accounting · Prepared by AI Advisory
Performance Overview · All Venues
Gather — Nett Revenue
$1,253,339
42.6% of group revenue · 7 months
Mazi — Nett Revenue
$1,047,674
35.6% of group revenue · 7 months
Theos — Nett Revenue
$638,669
21.7% of group revenue · 7 months
Group Total — Nett Revenue
$2,939,682
Ex GST · Aug 2025 – Feb 2026
Gather
42.6% share
Monthly avg nett revenue$179,048
Best monthDec 2025 · $210,142
Top menu itemSchnitzel · $180,875
Menu items tracked~92 items/month
Mazi
35.6% share
Monthly avg nett revenue$149,667
Best monthDec 2025 · $161,570
Top menu itemScotch Fillet · $74,061
Menu items tracked~98 items/month
Theos
21.7% share
Monthly avg nett revenue$91,238
Best monthDec 2025 · $87,320
Top menu itemSteak Fritters · $49,868
Menu items tracked~87 items/month
Monthly Nett Revenue — All Venues
Aug 2025 – Feb 2026 · Ex GST
Gather
Mazi
Theos
Revenue Trend · Month by Month
Gross vs Nett Revenue — All Venues Combined
Difference represents pricing variances, discounts & surcharges
Pricing Variance by Month
Member pricing, discounts & promotions — all venues
Venue Revenue Share by Month
Proportional contribution each month
Top Menu Items by Venue
Gather
Mazi
Theos
Gather — Top 10 Items by Revenue
7 months accumulated
Gather — Menu Rankings
Monthly P&L Waterfall · All Venues
Gross to Nett Revenue Bridge
How gross sales convert to nett sales ex-GST each month across all venues
Gather — Monthly Gross vs Nett
Mazi — Monthly Gross vs Nett
Theos — Monthly Gross vs Nett
Knowledge Graph · txt2kg Visualisation
XCLUBS + Delmel Entity Graph
1,436 nodes · 3,143 edges · Powered by ArangoDB + granite3.3:8b
Open full screen ↗
Graph Stats
Total nodes1,436
Total edges3,143
Documents ingested22 (21 XCLUBS + 1 Delmel)
Extraction modelgranite3.3:8b (local)
Graph databaseArangoDB · port 8529
Vector storeQdrant · port 6333
RAG Search
Query the knowledge graph via txt2kg

Use the RAG Search button in txt2kg to query across all ingested documents. Try searching for menu items, venues, or revenue figures.

Open txt2kg ↗
Recipe Costing · Coming Soon
🍽️
Recipe Costing Module
Once recipe ingredient costs are provided, this module will calculate food cost percentage, gross margin per dish, and identify your highest and lowest margin menu items across all three venues.
01
Provide ingredient costs
Upload a spreadsheet with ingredient costs per unit for each menu item
02
Auto-match to sales data
The system will match ingredient costs to the 2,005 sales rows already parsed
03
Dashboard activates
Food cost %, gross margin per dish, and margin rankings will appear here
Recipe Costing Table — Preview Format
This is how the table will look once ingredient costs are loaded
📈 Financial Dashboard

📋 XCLUBS Monthly Refresh Instructions

~5 min · 3 steps
1

Export P&L from Xero XERO

Log in to Xero → Accounting → Reports → Profit & Loss

Settings to apply before exporting:

  • Date range: [new month, e.g. 1 Apr – 30 Apr 2026]
  • Compare: None
  • Columns: Tracking — Group

Click Export → Excel (.xlsx), then open in LibreOffice → Save As → ODS format (recommended — Xero xlsx exports have broken subtotals)
Save to ~/clients/ClubsCatering/
Name the file: Clubs_Catering_Pty_Ltd_-_Profit_and_Loss Apr 2026.ods


2

Add month to FILE_MAP & rebuild TERMINAL

Open the builder script and uncomment/add the new month line:

nano ~/scripts/XCLUBS_Dashboard_Builder.py # In the FILE_MAP section, add: 'Clubs_Catering_Pty_Ltd_-_Profit_and_Loss Apr 2026.ods': ('Apr','2026','Apr 26'),

Then rebuild the dashboard:

python3 ~/scripts/XCLUBS_Dashboard_Builder.py

✅ Should print: "Dashboard updated … Period: Aug 25 – Apr 26 · 9 Months"


3

Push to live portal AUTO-DEPLOY

Push the updated dashboard to GitHub — Cloudflare deploys in ~60 seconds:

bash ~/scripts/push_xclubs_dashboard.sh

Then verify at: clients.bynaccounting.com.au/xclubs/

Check the period badge in the header updates to the new month range.


📁 P&L files live in: ~/clients/ClubsCatering/  |  🔧 Builder: ~/scripts/XCLUBS_Dashboard_Builder.py  |  🚀 Push: ~/scripts/push_xclubs_dashboard.sh