Condotel Booking & Income Manager v11.0

Bookings, unit availability, parking availability, commissions and monthly income

Local mode

Business Dashboard

Customize this layout anytime from Settings.

Dashboard Filters

Filter by unit, date range, unit status, or combine them.
Showing all units for the selected calendar month.
Live system status
--:--
Occupancy Pulse
0%
Monthly Profit Movement
₱0
Vacant Unit-Days
0
Counts every vacant calendar cell
Occupied Unit-Days
0
Counts every booked calendar cell
Occupancy Percentage
0%
Occupied cells ÷ all available cells
Extra Service Income
₱0
Standalone services in selected range
Gross Income + Services
₱0
Parking Income
₱0
Total Expenses & Bills
₱0
Final Net Profit
₱0

Unit Performance

Parking Performance

Expense Summary

Operations Schedule

Upcoming Unit Check-ins

Collections Due

Extra Income Monitoring

Add Booking / Income

1. Booking Type & Guest
Enter the total number of guests staying, including adults and children.
2. Dates & Charges
Standard check-out time: 12:00 noon
3. Source, Commission & Owner Share
Uses the selected unit's default owner-share setting.
4. Payment Collection
This status appears as a marker on every booked calendar cell.
The dashboard calculates the remaining balance from room and parking charges. Extra services are recorded separately below.
5. Parking & Remarks
Enter the charge for one parking day.
Defaults to the booking stay but can be adjusted.
Calculated automatically: daily rate × parking days.
No commission will be deducted from parking income.
Computed amounts: Room Commission: ₱0.00 Parking Commission: ₱0.00 Owner Share: ₱0.00 Net Income: ₱0.00
Gross Income
₱0
Commission
₱0
Net Income
₱0
Bookings
0

Bookings for Selected Month

Extra Service Income

Record water delivery, laundry and cleaning separately. Charge it to a recorded unit, manually enter a unit, or assign it directly to Condotel Sherwood Management.
Standalone Income
Choose the actual date the service was delivered or paid.
Choose Management when the income is not associated with a specific unit.
Extra Service Total: ₱0.00

Recent Extra Service Transactions

0 records

Condo Unit Availability

Green = available, yellow = occupied/booked
Drag a unit heading left or right to change its sequence.
AvailableBookedSelectedPParking assignedMManually blocked
Select the first date, then select the last date under the same unit. Double-click a cell to add or edit its note.

Parking Availability

Parking is blocked automatically for the same stay dates.
Drag a parking heading left or right to change its sequence.
AvailableBookedSelectedMManually blocked
Select the first date, then select the last date under the same parking space. Double-click a cell to add or edit its note.

Booking Records Filters

Filter by dates, unit, parking, source, payment status, or any combination.
Showing all booking records.
Bookings
0
Gross Income
₱0
Net Income
₱0
Parking Income
₱0
Commission
₱0
Average Daily Rate
₱0
Occupied Unit Nights
0

Filtered Booking Records

Endorsement Monitoring

Track instructions and access documents by check-in date or selected period.
Showing upcoming bookings for all units and all check-in dates.
Upcoming
0
Fully Endorsed
0
Pending
0
Check-in Today
0

Record Expense or Bill

Monthly Expenses
₱0
Paid
₱0
Unpaid
₱0
Entries
0

Expense & Bill Records

Monthly Report Filters

Select any start and end date for the report.
Showing the selected calendar month.
Gross
₱0
Agent/Platform Fees
₱0
Parking Income
₱0
Net Total
₱0

Income by Unit

Booked Days by Unit & Parking

Counts occupied nights within the selected report period.
Selected Days0
Unit Booked Nights0
Parking Booked Nights0
Average Unit Occupancy0%

Owner Share Calculator

Calculation Base
₱0.00
Owner Share
₱0.00
Management Share
₱0.00
Management Share (%)
20%

Expenses Report

Tracks expenses by unit, category, payment status, and selected report dates.
Expense Records
0
Total Expenses
₱0.00
Paid
₱0.00
Unpaid
₱0.00
Average Expense
₱0.00

Expenses by Unit

Expenses by Category

Expense Details

Owner Share by Unit and Parking

Tracks the owner share of every unit and parking space for the selected owner-ledger dates.
Unit owner share follows each unit's saved rule. Parking owner share follows each parking space's saved owner and sharing rule. Management share is the parking net income remaining after owner share.

Owner Share Daily Ledger

Daily owner-share statement by unit for an independently selected date range.
Using the Monthly Report date range.
Positive amounts are daily booking income. Expenses are shown in parentheses. The final line applies the selected owner-share percentage.

Daily Booking Status Table

Shows whether each unit and parking space is booked or available for every selected date.
AvailableBooked

Check-in Instructions & Invoice Generator

Automatically uses the latest saved booking. You can still edit all fields inside the generator.
Waiting for booking data…

User Access

Create accounts and assign what each person can access.
Access levels: Administrator can view and configure everything. Finance can view financial tabs and records but cannot open Settings. Operations/End User can only access Dashboard, Unit Calendar, Parking Calendar, and Endorsement Monitoring; financial cards are hidden.

Manage Condo Units

Drag the unit names to rearrange their calendar sequence.

Manage Parking Spaces

Drag the parking names to rearrange their calendar sequence.

Calendar Freeze Panes

Keep resource names visible while scrolling vertically. Unit and Parking calendars can be controlled separately.

When enabled, the Date column also stays visible during horizontal scrolling.

App Theme & Graphics

Choose a visual theme. Changes apply instantly and are saved automatically.

Parking Owner Share Settings

Set the parking owner and owner-share rule for each parking space. The remaining parking net income is recorded as management share.

ParkingOwner NameActiveMethodValue

Unit Type Settings

Tag each unit as a 2BR or Studio. The type appears in the booking form, calendar headings, dashboard, and reports.

UnitUnit TypeStatus
Unit types save automatically when changed.

Owner Share Settings by Unit

Set the default owner-share rule for each unit. Changes apply immediately to new bookings that use “Use Unit Default.” Existing bookings keep the owner share already registered when they were saved.

Changes are saved automatically.

Tab Names & Order

Rename navigation tabs and drag them to rearrange their order.

Dashboard View

Business Logo & Header

This single logo is used on the login page, main header, tab branding, previews and exports. Select a file, check the preview, then press Save Header Settings.
Logo preview
Live main-page logo preview
The selected logo and display size will update the same logo throughout the app after saving.

Shared Cloud Database

Connect this app to Supabase so every phone and computer sees changes immediately. The URL and publishable key are stored only in this browser.

Not connected. The app is using this browser's local storage.
One-time Supabase setup SQL

Open Supabase → SQL Editor, run this once, then enable Realtime for app_state.

create table if not exists public.app_state ( id text primary key, payload jsonb not null default '{}'::jsonb, updated_at timestamptz not null default now() ); alter table public.app_state enable row level security; create policy "public read app state" on public.app_state for select to anon using (true); create policy "public insert app state" on public.app_state for insert to anon with check (true); create policy "public update app state" on public.app_state for update to anon using (true) with check (true); insert into public.app_state (id, payload) values ('main', '{}'::jsonb) on conflict (id) do nothing;

Backup / Restore

Data is backed up locally and, when connected, synchronized to the shared Supabase database.

How Commission Works

Direct / No Agent: no commission deduction.

With Agent: choose percentage of gross, fixed amount per booked day, or a manual total commission.

Airbnb / Other Platform: choose percentage of gross, fixed amount per booked day, or a manual total platform/agent commission.

Custom / Manual Source: type any source such as Agoda, Facebook, Walk-in, Referral, or another channel, then choose the appropriate commission method.
Calendar Cell