TSH
Executive Hospitality Intelligence • Property: TSH (8 Suites)

The Sun House — Galle

BigQuery Live (sunhouse_dw) | Synced: 15 Nov 2026, 15:50:44 IST
FX: 1 USD = LKR
Dynamic USD / LKR Conversion Adjusts Room Revenue, ADR, RevPAR, OTB Forward Pace, Channel Mix, and Cashflow Runway in real time (live rate rounded to nearest LKR: 333).
Room Currency
Occupancy & RevPAR (Nov 26) + 40.6% MoM

73.3%

176 / 240 RNs (8 suites)

RevPAR

$134

ADR: $182

Inspect Breakdown →
Net Op. Profit (Sep 26 Closed) 14.1% GOP

LKR 815K

Oct 26: LKR 2.18M Provisional — COGS Pending

Nov 26: LKR 4.64M Provisional — COGS Pending

IC Elim: -LKR 822K Intercompany management fees, cross-charges & F&B transfers between The Sun House (918795352) and SHG Leisure (919449166) eliminated on consolidation. Inspect Breakdown →
The Gallean F&B (Nov 26) 62.0% Est. GP

LKR 1.10M

Fudo Sales: LKR 1,096,934

Capture / Occ. Suite: LKR 6,233

Fudo POS · Through Latest Synced Day Inspect Breakdown →
Next 90d OTB Room Revenue 79.0% OTB Occ

$140,081

Confirmed forward room bookings (90d)

Proj. F&B Capture: +LKR 5.54M Projection Formula Confirmed Forward Room Nights × Trailing 90-Day Historical F&B Revenue per Occupied Suite Night.

PMS Reservations Inspect Breakdown →
Section 01 · Financial Performance | v_consolidated_pl_monthly

Consolidated P&L & Operating Margin Trend (12 Months)

Intercompany management fees, cross-charges & F&B transfers between The Sun House (918795352) and SHG Leisure (919449166) are eliminated in Consolidated view.

Net Revenue (LKR) COGS (LKR) OpEx (LKR) Net Operating Profit (LKR)
Viewing: Consolidated (Post-Elimination)
Period Room Rev (LKR) F&B Rev (LKR) Net Revenue (LKR) COGS (LKR) Gross Margin OpEx (LKR) Net Op. Profit (LKR) GOP % IC Eliminated Intercompany transfers, management fees & shared expenses between The Sun House (918795352) and SHG Leisure (919449166) eliminated on consolidation.
Apr 26 (2026-04)
LKR 6,271,448 LKR 2,114,354 LKR 8,863,087 LKR 3,280,186 63.0% LKR 4,740,586 LKR 842,314 9.5% LKR 794,500
May 26 (2026-05)
LKR 2,496,095 LKR 1,254,691 LKR 4,281,474 LKR 2,500,414 41.6% LKR 2,859,046 -LKR 1,077,986 -25.2% LKR 794,500
Jun 26 (2026-06)
LKR 1,314,063 LKR 759,720 LKR 2,249,903 LKR 2,457,532 -9.2% LKR 3,206,673 -LKR 3,414,302 -151.8% LKR 835,000
Jul 26 (2026-07)
LKR 3,053,196 LKR 1,472,840 LKR 4,766,211 LKR 2,907,975 39.0% LKR 2,633,080 -LKR 774,844 -16.3% LKR 842,600
Aug 26 (2026-08)
LKR 6,766,585 LKR 2,270,795 LKR 10,966,095 LKR 2,891,662 73.6% LKR 3,728,387 LKR 4,346,047 39.6% LKR 840,625
Sep 26 (2026-09)
LKR 3,448,229 LKR 898,597 LKR 5,785,828 LKR 2,286,383 60.5% LKR 2,684,685 LKR 814,760 14.1% LKR 821,500
Oct 26 (2026-10) PROVISIONAL · COGS PENDING
LKR 2,869,427 LKR 862,495 LKR 5,108,094 LKR 726,980 85.8% LKR 2,198,128 LKR 2,182,985 42.7% LKR 0
Nov 26 (2026-11) PROVISIONAL · COGS PENDING
LKR 4,352,144 LKR 752,064 LKR 5,708,303 LKR 313,908 94.5% LKR 753,698 LKR 4,640,697 81.3% LKR 0
TTM Total / Avg LKR 30,571,187 LKR 10,385,557 LKR 47,728,996 LKR 17,365,041 63.6% LKR 22,804,284 LKR 7,559,672 15.8% LKR 4,928,725
Section 02 · Commercial Pace & Distribution | v_forward_90d_forecast · pms_daily_room_nights

90-Day Forward Pace & Confirmed Channel Mix

On-the-books (OTB) room nights across 8 suites (575 / 728 RNs, 1177 expected guests), confirmed room revenue, and projected Gallean F&B capture.

Direct Share: 29.0%
Next 30 Days 154 / 240 RNs

OTB Occupancy

64.2%

OTB Room Rev (USD)

$30,946

ADR / RevPAR (USD) $201 / $129
Proj. F&B Capture LKR 1.48M Formula: Confirmed Forward Room Nights × Historical F&B Revenue per Occupied Suite Night.
Next 60 Days 354 / 480 RNs

OTB Occupancy

73.8%

OTB Room Rev (USD)

$87,683

ADR / RevPAR (USD) $248 / $183
Proj. F&B Capture LKR 3.41M Formula: Confirmed Forward Room Nights × Historical F&B Revenue per Occupied Suite Night.
Next 90 Days 575 / 728 RNs

OTB Occupancy

79.0%

OTB Room Rev (USD)

$140,081

ADR / RevPAR (USD) $244 / $192
Proj. F&B Capture LKR 5.54M Formula: Confirmed Forward Room Nights × Historical F&B Revenue per Occupied Suite Night.

Full-Month Forward Pace Breakdown (by Stay Month)

Full calendar month denominators (days in month × 8 suites) from pms_daily_room_nights.

Stay Month Booked / Avail RNs OTB Occupancy % Expected Guests OTB Room Rev (USD) OTB Room Rev (LKR) Projected F&B (LKR)
Nov 26 (2026-11) 176 / 240 73.3% 345 $32,116 LKR 10,598,330 LKR 1,712,077
Dec 26 (2026-12) 174 / 248 70.2% 358 $44,984 LKR 14,844,773 LKR 1,692,621
Jan 27 (2027-01) 211 / 248 85.1% 436 $54,823 LKR 18,091,428 LKR 2,052,546
Feb 27 (2027-02) 206 / 224 92.0% 417 $48,745 LKR 16,085,748 LKR 2,003,908
Channel Revenue Explorer

Showing distribution & top DMC agencies for Next 90 Days (Forward OTB)

Confirmed Revenue by Channel

Confirmed Booking Channel Mix (Next 90 Days)

4-Segment Classification
OTAs 289 RNs (50.3%)
Direct 167 RNs (29.0%)
Offline Agents / DMCs 116 RNs (20.2%)
House Use 3 RNs (0.5%)
Channel Segment Room Nights Share % ADR (USD) Revenue (USD)
Booking.com OTA 221 38.4% $255 $56,406
Direct Website / Walk-in DIRECT 167 29.0% $241 $40,266
Expedia OTA 68 11.8% $236 $16,024
Tikalanka Tours (Pvt) Ltd AGENT / DMC 12 2.1% $260 $3,114
Jetwing+ AGENT / DMC 13 2.3% $225 $2,924
Hummingbird AGENT / DMC 11 1.9% $257 $2,832
AUTHENTICITIES (PVT) LTD AGENT / DMC 9 1.6% $238 $2,146
FAR OUT (PVT) LTD AGENT / DMC 8 1.4% $208 $1,660
PERFECT LIVING BVBA AGENT / DMC 3 0.5% $507 $1,520
Wayfarers (Pvt) Ltd AGENT / DMC 6 1.0% $234 $1,404
Ceylon Tours Ltd AGENT / DMC 7 1.2% $194 $1,361
Blue Lanka Tours AGENT / DMC 5 0.9% $264 $1,320
Columbus Tours (Pvt) Ltd AGENT / DMC 8 1.4% $153 $1,224
Lanka Sportreizen LSR AGENT / DMC 4 0.7% $262 $1,046
Ceylon Expeditions Travels AGENT / DMC 6 1.0% $173 $1,038
Off 2 Sri Lanka (Pvt.) Ltd AGENT / DMC 4 0.7% $231 $924
Boutique Sri Lanka AGENT / DMC 3 0.5% $276 $829
BAYLEA AGENT / DMC 2 0.3% $290 $580
Jet Wings Lanka Tours (Pvt) Ltd AGENT / DMC 2 0.3% $283 $566
Ceylon Escapes (Pvt) Ltd AGENT / DMC 2 0.3% $276 $552
Travelorphic (Private) Limited AGENT / DMC 2 0.3% $247 $494
TRIPFUSION (PVT) LTD AGENT / DMC 2 0.3% $245 $489
Travel Ease Tours Private Limited AGENT / DMC 2 0.3% $213 $426
Blue Dot Tours (Pvt) Ltd., AGENT / DMC 2 0.3% $213 $426
Tourslanka Vacations (Pvt) Ltd AGENT / DMC 2 0.3% $179 $358
Pan Lanka Tour and Travels (Pvt) Ltd AGENT / DMC 1 0.2% $153 $153
House / Friends & Family HOUSE USE 3 0.5% $0 $0
Implied Forward F&B Capture per Booked Suite LKR 9,641 / Occupied Room Night
Agency & DMC Production Leaderboard

Top Performing Travel Agents & DMCs — Next 90 Days (Forward OTB)

Top 15 Agencies · Excludes Direct, OTAs & Internal/House Use
Rank Agency / DMC Name Room Nights Revenue (USD) ADR (USD) Avg Stay (Nts) % of Agent Segment
#1 Tikalanka Tours (Pvt) Ltd 12 $3,114 $260 2.0 11.4%
#2 Jetwing+ 13 $2,924 $225 2.2 10.7%
#3 Hummingbird 11 $2,832 $257 1.8 10.3%
#4 AUTHENTICITIES (PVT) LTD 9 $2,146 $238 3.0 7.8%
#5 FAR OUT (PVT) LTD 8 $1,660 $208 2.7 6.1%
#6 PERFECT LIVING BVBA 3 $1,520 $507 2.0 5.6%
#7 Wayfarers (Pvt) Ltd 6 $1,404 $234 2.0 5.1%
#8 Ceylon Tours Ltd 7 $1,361 $194 2.3 5.0%
#9 Blue Lanka Tours 5 $1,320 $264 5.0 4.8%
#10 Columbus Tours (Pvt) Ltd 8 $1,224 $153 4.0 4.5%
#11 Lanka Sportreizen LSR 4 $1,046 $262 1.0 3.8%
#12 Ceylon Expeditions Travels 6 $1,038 $173 1.5 3.8%
#13 Off 2 Sri Lanka (Pvt.) Ltd 4 $924 $231 1.0 3.4%
#14 Boutique Sri Lanka 3 $829 $276 1.0 3.0%
#15 BAYLEA 2 $580 $290 1.0 2.1%
Section 03 · Culinary & Beverage Intelligence | v_hotel_fb_performance_monthly · fudo_item_sales_monthly

The Gallean F&B Capture & Menu Engineering

12-month F&B spend per occupied room night alongside Fudo POS dish/cocktail contribution and Zoho Inventory COGS Pool margin allocation.

12m Avg F&B / Occ. Suite: LKR 13,200

F&B Spend per Occupied Room vs. Occupancy % (12 Months)

F&B / Occupied Suite (LKR) Occupancy %

Hotel & F&B Monthly Yield

Last 6 Months
Month Occ RNs Occ % ADR / RevPAR Fudo F&B F&B / RN
Jun 26 90 / 240 37.5% $64 / $24 LKR 1.00M LKR 11K
Jul 26 100 / 248 40.3% $164 / $66 LKR 1.46M LKR 15K
Aug 26 160 / 248 64.5% $195 / $126 LKR 985K LKR 6K
Sep 26 125 / 240 52.1% $147 / $76 LKR 1.12M LKR 9K
Oct 26 81 / 248 32.7% $181 / $59 LKR 1.42M LKR 18K
Nov 26 176 / 240 73.3% $182 / $134 LKR 1.10M LKR 6K

The Gallean Menu Engineering Matrix (Fudo POS)

Est. via Zoho COGS Pool (39.5% Base)

Dish-level GP% weighted by protein/category cost tiers against Zoho Books inventory COGS. Fudo POS daily sync runs incrementally; partial-day gaps may occur if upstream API rate limits are hit.

Category Filter:
Section 04 · Liquidity & Treasury Planning | zoho_cash_snapshot · pms_daily_room_nights · v_consolidated_pl_monthly

6-Month Cashflow Runway & Liquidity Forecast (LKR — Excl. Wise)

Auto-derived from BigQuery: confirmed OTB + prior-year actual seasonal revenue, proportional F&B capture, closed Zoho OpEx + COGS (LKR 4,853,115/mo avg), and -15% OTA commission on 49% OTA share.

FX: 1 USD = 333 LKR
Synced Local Cash & Bank (Excl. Wise) Synced from zoho_cash_snapshot · Nov 15, 2026, 10:02 AM
LKR 11,176,260 Zoho Live
Auto-Derived Minimum Safety Buffer 1.5 × Avg Monthly Total Cash Outflow (OpEx + COGS: LKR 4,853,115/mo)
LKR 7,279,673 1.5× OpEx + COGS Reserve
Projected Peak Cash

—

Highest closing cash across 6-month window

Projected Cash Trough & Burn

—

Minimum closing balance & negative cashflow months

Available Free Cash Above Safety Buffer Calculating

—

Cash Trough − 1.5× (OpEx + COGS) Safety Buffer

6-Month Cash Balance Trajectory & Monthly Net Cashflow

Bars: Net Monthly Cashflow · Line: Closing Cash Balance · Dashed: 1.5× (OpEx + COGS) Safety Buffer
Month Season / Occ % Opening Cash Room + F&B Inflow OpEx + COGS + OTA Net Cashflow Closing Cash