Analytics Dashboard

Overview

VillaTax Analytics provides revenue analytics, P&L breakdowns, platform performance comparisons, and ROI calculations, all derived from your actual double-entry journal entries, not from raw booking sums. This distinction matters: a booking at Rp 10M gross is not Rp 10M in net revenue once PBJT, OTA commissions, and PPh are accounted for. The analytics module shows you what you actually earned.

Access the analytics dashboard at Analytics module.

Revenue Analytics

Gross and Net Revenue

The revenue view shows:

• Gross revenue: total booking income before any deductions, across all properties and platforms
• Net revenue: gross minus PBJT collected, OTA commissions, and applicable PPh

Net revenue is the figure that matters for P&L reporting. VillaTax calculates it from the journal: booking revenue entries minus the corresponding tax expense and commission entries. Gross revenue minus tax is not the same as gross revenue minus charges, the analytics engine uses the journal-based net (see the accounting design note below).

Period Views

Every analytics view supports period filtering:

• MTD: month-to-date: current month up to today
• QTD: quarter-to-date: current quarter up to today
• YTD: year-to-date: current fiscal year up to today
• Custom: any date range you define

Charts adjust to show only the months or weeks that fall within the selected period. A QTD view in March shows January, February, and the current month, not all 12 months with the others blank.

Year-over-Year Comparison

YoY comparison overlays the prior year's equivalent period on the current period's chart. This requires at least 13 months of data in VillaTax. If prior year data is missing, the YoY overlay is not shown.

Platform Breakdown

The platform analytics tab shows revenue attributed to each connected OTA:

• Revenue per platform (Airbnb, Booking.com, Agoda, Traveloka, direct bookings, etc.)
• Percentage share of total revenue per platform
• Guest count and average booking value per platform
• Platform trend over the selected period

This helps you identify which channels are most valuable and which are underperforming, without leaving the dashboard.

P&L Statement

The P&L tab generates an automated Profit & Loss report from your double-entry journal data. It is not a booking sum with expenses subtracted; it uses the full accounting ledger.

Structure of the P&L:

• Revenue: net booking income (gross minus PBJT collected, per the journal)
• Cost of revenue: OTA commissions, cleaning fees
• Gross profit: revenue minus cost of revenue
• Operating expenses: maintenance, utilities, staff salaries and benefits, Banjar contributions
• Tax expenses: PPh 4(2), PPh 21, PPh 23, BPJS employer contributions
• Net profit: gross profit minus operating and tax expenses
• Net margin: net profit as a percentage of gross revenue

The P&L is available by month, quarter, and year. Comparative period columns are supported when the prior period has data.

Accounting Note

Revenue in the P&L is calculated as gross booking income minus charges (OTA commissions, cleaning fees). PBJT is shown as a separate line item in operating expenses, not subtracted from gross revenue. This follows standard P&L presentation, PBJT is a tax collected on behalf of the regency, not a reduction in your service revenue.

ROI Per Property

For investment-minded owners, the ROI section calculates return on investment per property:

• Gross yield: annual gross revenue divided by acquisition cost (from fixed asset records)
• Net yield: annual net revenue after all taxes and expenses, divided by acquisition cost
• Payback period: estimated years to recover the acquisition cost at current net yield
• Book value impact: how annual depreciation reduces the net asset value and affects yield calculations over time

ROI requires acquisition cost data from the fixed assets module. If no fixed asset record exists for a property, ROI is not calculated.

Charts and Visualizations

All analytics views use charts built for clarity:

• Bar charts: monthly revenue bars with optional YoY overlay
• Sparklines: compact trend lines for quick period-over-period comparison
• Gauge charts: compliance score and other ratio-based indicators
• Platform donut: revenue share by platform in the breakdown tab

Charts use pixel-based heights calculated from your actual data, not percentage-based heights that can render invisibly on some browsers.

Property-Level Drill-Down

All analytics views can be filtered to a single property using the scope filter. This shows the P&L, revenue breakdown, and ROI for one villa in isolation, useful when you are evaluating property-level performance or presenting data to a co-owner.

The consolidated view (all properties combined) is the default when no property filter is active.

Data Freshness

Analytics data is live; it reflects the journal state at the time you open the dashboard. There is no scheduled cache refresh. If you import a CSV or post a new expense, the analytics update immediately on the next page load.

Limits

• YoY comparison requires 13+ months of data
• Platform breakdown is based on the source field on booking records. Manually entered bookings with no platform source appear as "direct"
• ROI calculations require acquisition cost data in the fixed assets module; they are not estimated if that data is missing
• The P&L does not yet include depreciation as a line item in the operating expenses chart (depreciation is in the journal but the chart grouping does not currently surface it separately)