Financial reports - P&L, balance sheet, trial balance, trust reconciliation, and more

Reports Overview

Overview

VRPlatform provides financial reports to help you:

Track business performance
Monitor account balances
Reconcile trust accounts
Meet accounting and tax requirements
Analyze property-level profitability

All reports can be filtered by date range, listing, and other relevant criteria.

Available Reports

Profit & Loss (Income Statement)

Shows revenue and expenses over a time period.

Metric	Description
Revenue	Income by category (rent, fees, etc.)
Expenses	Costs by category (repairs, utilities, etc.)
Net Income	Revenue minus expenses

Filters:

Date range (required)
Listing(s)
Account categories

Use for: Monthly/yearly performance analysis, property profitability comparison

Balance Sheet

Snapshot of financial position at a specific date.

Section	Description
Assets	What you own or are owed
Liabilities	What you owe
Equity	Net worth (assets minus liabilities)

Filters:

As-of date (required)
Listing(s)

Use for: Financial health assessment, investor reporting

Trial Balance

Verification report showing all account balances.

Column	Description
Account	Account name
Debit	Debit balance
Credit	Credit balance

Key rule: Total debits must equal total credits. An imbalance indicates an accounting error.

Use for: Month-end close verification, troubleshooting discrepancies

Guest Balances (Accounts Receivable)

Track money owed by guests or channels.

Metric	Description
Expected	Amount billed to guest
Received	Amount paid
Balance	Outstanding amount

Filters:

Date range
Listing(s)
Payment status (paid, unpaid, underpaid)

Aging categories:

Current (0-30 days)
31-60 days
61-90 days
90+ days

Use for: Collections management, cash flow forecasting

Trust Reconciliation

Reconcile trust account balances against expected owner funds.

Metric	Description
Expected Balance	What should be in trust based on owner statements
Actual Balance	What's actually in the bank account
Variance	Difference (should be zero)

Breakdowns:

By owner
By listing
By ownership period

Use for: Regulatory compliance, trust account audits, identifying discrepancies

Sales Tax Liability

Track tax obligations by jurisdiction.

Metric	Description
Tax Collected	Taxes received from guests
Tax Remitted	Taxes paid to authorities
Tax Owed	Outstanding tax liability

Filters:

Date range
Jurisdiction/tax authority
Listing(s)

Use for: Tax filing, compliance, quarterly estimates

Manager Statement

Operational reporting for property managers.

Metric	Description
Gross Revenue	Total revenue managed
Management Fees	Commission earned
Properties	Count of active properties
Reservations	Booking activity

Use for: Internal performance tracking, compensation calculations

Owner Performance

Compare performance across owners and properties.

Metric	Description
Revenue	Total income
Expenses	Total costs
Net Income	Profitability
Occupancy	Booking rate

Use for: Portfolio analysis, owner reporting, benchmarking

Common Scenarios

Monthly Close Process

Run Trial Balance - Verify debits equal credits
Run Trust Reconciliation - Confirm trust account balances
Generate P&L - Review monthly performance
Create Owner Statements - Prepare owner reports

Quarterly Tax Filing

Run Sales Tax Liability - Get tax collected by jurisdiction
Export report - Download for filing
Record tax payment - Create expense transaction

Annual Owner Reporting

Run P&L by listing - Full year summary
Run Balance Sheet - Year-end position
Generate annual owner statements - Comprehensive owner report

API Endpoints

Method	Endpoint	Description
`GET`	`/reports/profit-loss`	Generate P&L report
`GET`	`/reports/balance-sheet`	Generate balance sheet
`GET`	`/reports/trial-balance`	Generate trial balance
`GET`	`/reports/guest-balances`	Generate AR aging report
`GET`	`/reports/trust-reconciliation`	Generate trust reconciliation
`GET`	`/reports/sales-tax`	Generate tax liability report
`GET`	`/reports/manager-statement`	Generate manager statement

Common Parameters

Parameter	Description
`startDate`	Period start (YYYY-MM-DD)
`endDate`	Period end (YYYY-MM-DD)
`asOfDate`	Point-in-time date (balance sheet)
`listingId`	Filter to specific listing
`listingIds`	Filter to multiple listings
`format`	Response format (json, csv, pdf)

Response Structure

P&L Report

{
  "reportType": "profit-loss",
  "period": {
    "start": "2024-01-01",
    "end": "2024-12-31"
  },
  "currency": "USD",
  "revenue": {
    "total": 5000000,
    "categories": [
      {"name": "Rental Income", "accountId": "account-rent", "amount": 4500000},
      {"name": "Cleaning Fees", "accountId": "account-cleaning", "amount": 500000}
    ]
  },
  "expenses": {
    "total": 750000,
    "categories": [
      {"name": "Repairs", "accountId": "account-repairs", "amount": 250000},
      {"name": "Utilities", "accountId": "account-utilities", "amount": 500000}
    ]
  },
  "netIncome": 4250000
}

Trust Reconciliation Report

{
  "reportType": "trust-reconciliation",
  "asOfDate": "2024-06-30",
  "currency": "USD",
  "summary": {
    "expectedBalance": 15000000,
    "actualBalance": 15000000,
    "variance": 0
  },
  "byOwner": [
    {
      "contactId": "owner-123",
      "contactName": "John Smith",
      "expectedBalance": 5000000,
      "listings": [
        {
          "listingId": "listing-abc",
          "listingName": "Beach House",
          "balance": 5000000
        }
      ]
    }
  ]
}

Export Formats

Format	Description
`json`	API response (default)
`csv`	Spreadsheet-compatible
`pdf`	Printable document

Owner Statements - Owner-specific financial reports
Accounts - Account structure for reports
Transactions - Underlying financial data
Locking - Books closed affects report periods

Reports Overview

On this page