Casa Mundo Rental Income Tracker
Loading…
Loading…
Key Performance Metrics
Current Scenario Snapshot
12-Month Cash Flow Summary
| Month | Forecast Net CF | Tracked Actual CF | Cumulative Forecast |
|---|
Tracked actuals are cash-based: only Paid bookings and Paid expenses are included. Forecast values continue to use your assumptions, so actuals are never double-counted against forecasted fixed/variable costs.
CalendarAirbnb Booking.com Checkout / cleaning
Upcoming Reservations future check-ins only · active stay excluded
Guest & payment details: iCal does not reliably provide names or prices. Casa Mundo first uses a matching entry from your Booking Log (same channel and dates); otherwise use Edit to save the guest name and amount paid locally. These details are preserved when the calendar is refreshed.
Channel
Stay
Nights
Guest
Paid
Property & Currency
Revenue & Occupancy Assumptions
Monthly Fixed Costs
Setup Cost Recovery
Click Edit on a row to make changes, then Save to keep them or Cancel to discard. Rows are read-only until you choose to edit them.
Use Gross Override and Platform Fee Override when you know the actual booking amounts. Otherwise the app estimates them from nightly rates and the default platform fee. Cleaning cost is applied once per reservation.
Historical Cost Averages
This breakdown is built from what you've actually logged in the Expense Log and Booking Log. Log expenses under Electricity, Water, Internet, Cleaning Supplies, or Maintenance / Repairs and the historical average is automatically applied to your Monthly Fixed Costs — no manual step needed. (Auto-apply pauses only while you have an unsaved manual edit sitting in the Assumptions form, so it never overwrites something you're mid-typing.)
Loan Setup
Choose the interest calculation method that matches your bank's actual amortization schedule below — some banks charge interest daily (balance × rate ÷ day-count basis × days elapsed), others charge a flat balance × rate ÷ 12 every period regardless of the calendar. Your Monthly Payment stays fixed at every due date either way; the split between interest and principal shifts automatically as the balance changes.
Additional Recurring Charges
Charges that ride alongside the loan payment but aren't principal or interest — mortgage redemption insurance (GFSP/MRI), fire insurance, and similar. These show up as their own column in the schedule below and don't reduce the balance. Pick Monthly for something billed every period, or Annual for something billed once a year in a specific month (like fire insurance).
Advance / Extra Principal Payments
Log payments you've actually made directly to principal, or add Planned entries to simulate future what-if payments. Both are included in the projection below; toggle a row's status to move it between "already happened" and "hypothetical."
Generate a recurring planned extra payment (what-if)
Click Edit on a row to change it, then Save or Cancel.
Payoff Projection
Projected Schedule (Actual + Planned payments applied)
| Period | Due Date | Days | Interest | Scheduled Principal | Advance Principal | Other Charges | Total Due | Ending Balance |
|---|
24-Month Forecast & Tracked Actuals
Tracked actual cash flow uses only paid booking revenue (gross less platform fee) and paid logged expenses. Future months are left blank instead of showing assumed costs as if they had already happened.
| Month | Cal. Days | Wkday Nights | Wkend Nights | Occ. Wkday | Occ. Wkend | Forecast Gross | Platform Fees | Variable/Clean | Fixed Costs | Setup Spend | Paid Booking Rev. | Paid Opex | Forecast Net CF | Tracked Actual CF | Cum. Forecast | Cum. Actual |
|---|
Calendar Connections
Private calendar links: paste each property's Airbnb and Booking.com iCal export URLs here. Casa Mundo stores them only in this browser for now. They are not embedded in the HTML file.
AirbnbNot configured
Airbnb → Calendar → Availability → Connect calendars → Export calendar.
Booking.comNot configured
Booking.com Extranet → Rates & Availability / Calendar → Sync calendars → Export.
Sync Method
Current standalone mode: Casa Mundo will first try to fetch the iCal URL directly. Some booking platforms block browser-to-browser calendar downloads because of CORS.
When you deploy to Hostinger, Casa Mundo is already prepared to use a same-site ical-proxy.php endpoint automatically. That keeps the private iCal URLs out of browser network requests to third-party proxy services and makes Refresh reliable.
Your Rental Locations
Add a new location
Give the new property a name and review the starter configuration below — every field is pre-filled with a sensible default so you can adjust just what's different, then save. You can fine-tune everything later from the Assumptions tab once it's selected.
Local Data & Backups