Skip to main content

Financial Reports

Track revenue, discounts, and financial performance of your VIP program.

Overview​

Financial reports show the monetary impact of your VIP program:

  • Total revenue from VIP customers
  • Discounts given through perks and offers
  • Net revenue after discounts
  • ROI of VIP program
  • Average spend per customer

Available Reports​

1. Discount Summary Report​

Shows total discounts given across all perks and offers.

Metrics included:

  • Total discount dollars
  • Discount as percentage of gross revenue
  • Discounts by card tier
  • Discounts by location
  • Discount trends over time

Use this to:

  • Monitor discount costs
  • Ensure discounts are sustainable
  • Compare tier profitability
  • Justify VIP program ROI

2. Revenue Impact Report​

Compares VIP customer revenue to non-VIP customers.

Metrics included:

  • Average spend per visit (VIP vs. non-VIP)
  • Visit frequency (VIP vs. non-VIP)
  • Total lifetime value
  • Revenue per tier

Use this to:

  • Prove VIP program increases revenue
  • Calculate customer lifetime value
  • Identify most valuable tiers
  • Set tier upgrade thresholds

3. Offer Performance Report​

Financial results of specific offers and promotions.

Metrics included:

  • Offer redemption count
  • Total discount cost
  • Incremental revenue generated
  • ROI per offer
  • Cost per redemption

Use this to:

  • Evaluate which offers work
  • Calculate break-even points
  • Plan future promotions
  • Optimize discount percentages

Generating Financial Reports​

Step 1: Access Financial Reports​

  1. Log in to portal
  2. Navigate to Reports → Financial
  3. Select report type

Step 2: Configure Parameters​

Date Range:

  • Select start and end dates
  • Compare to previous period
  • Use fiscal year boundaries if applicable

Location Filter:

  • All locations (for Tenant Admins)
  • Specific locations
  • Location groups

Tier Filter:

  • All tiers combined
  • Specific tier (Silver/Gold/Platinum)
  • Tier comparison

Step 3: Generate & Review​

  1. Click "Generate Report"
  2. Review summary statistics
  3. Examine detailed data tables
  4. View trend charts

Step 4: Export​

Export options:

  • CSV for analysis
  • Excel with charts
  • PDF for presentations

Key Financial Metrics​

Discount Rate​

Formula:

Discount Rate = Total Discounts / Gross Revenue × 100

Target ranges:

  • Below 10%: Conservative, may not be competitive
  • 10-20%: Healthy range for most venues
  • 20-30%: Aggressive, monitor closely
  • Above 30%: Unsustainable, reevaluate structure

Customer Lifetime Value (CLV)​

Formula:

CLV = (Average Spend per Visit × Visit Frequency × Customer Lifespan) - Total Discounts

Example calculation:

Average spend: $75 per visit
Visit frequency: 3 visits/month
Lifespan: 18 months
Total visits: 54 visits
Gross revenue: $4,050

Total discounts (20%): $810
Net CLV: $3,240

Use CLV to:

  • Determine acceptable acquisition costs
  • Set tier benefits appropriately
  • Calculate program profitability

VIP Revenue Multiplier​

Formula:

Multiplier = VIP Average Spend / Non-VIP Average Spend

Target: 1.5x or higher

Example:

Non-VIP average spend: $50/visit
VIP average spend: $85/visit
Multiplier: 1.7x

Even with 20% discount, VIP nets more: $68 vs. $50

Program ROI​

Formula:

ROI = (VIP Net Revenue - Program Costs) / Program Costs × 100

Program costs include:

  • Platform subscription
  • Staff time for enrollment
  • Marketing costs
  • Discount costs

Target ROI: 200%+ (3x return)

Financial Analysis Examples​

Example 1: Tier Profitability​

Report parameters:

  • Date range: Last quarter
  • Group by: Card tier
  • Metrics: Revenue, discounts, visit frequency

Sample results:

TierAvg SpendDiscountNet RevenueVisits/MonthCLV
Silver$60$6 (10%)$541.5$972
Gold$85$17 (20%)$682.5$2,040
Platinum$120$36 (30%)$844.0$4,032

Insights:

  • Higher tiers have better net revenue despite higher discounts
  • Platinum tier is 4.1x more valuable than Silver
  • Consider moving more customers to Gold/Platinum

Example 2: Location Performance​

Report parameters:

  • Date range: Last month
  • Group by: Location
  • Compare: VIP revenue vs. non-VIP

Sample results:

LocationVIP RevenueNon-VIP RevenueVIP %Discount Cost
Main Club$125,000$180,00041%$25,000
Beach Club$85,000$95,00047%$18,000
Rooftop$42,000$58,00042%$9,500

Insights:

  • Beach Club has highest VIP adoption
  • VIP customers represent 41-47% of revenue
  • Discount costs are 16-20% of VIP revenue (healthy)

Example 3: Offer ROI​

Report parameters:

  • Select specific offer: "Thursday Ladies Night"
  • Date range: Last 8 weeks (8 Thursdays)

Sample results:

Offer: 50% off drinks for female VIPs, 9-11pm

Total redemptions: 240
Average discount per redemption: $15
Total discount cost: $3,600

Average spend per redeemed customer: $45
Gross revenue from offer: $10,800
Net revenue: $7,200

Non-offer Thursday average revenue: $4,500
Incremental revenue: $2,700

ROI: 75% ($2,700 / $3,600)

Insights:

  • Offer drives significant incremental revenue
  • Positive ROI even without accounting for long-term loyalty
  • Consider expanding to other nights

Budgeting & Forecasting​

Setting Discount Budgets​

Recommended approach:

  1. Calculate current discount rate
  2. Project revenue growth
  3. Set discount budget as percentage of revenue
  4. Monitor monthly and adjust offers as needed

Example budget:

Projected annual revenue: $2,000,000
Target discount rate: 15%
Annual discount budget: $300,000
Monthly budget: $25,000

Monitor actual vs. budget:
- Alert at 90% of monthly budget
- Pause new offers at 100%
- Review tier structure if consistently over budget

Revenue Forecasting​

Factors to model:

  • Expected enrollment growth
  • Tier distribution shifts
  • Seasonality patterns
  • New location openings
  • Competitive landscape changes

Basic forecast formula:

Projected Revenue =
  (Expected VIP Customers × Avg Visits/Year × Avg Spend) × (1 - Discount Rate)

Financial Compliance​

Audit Requirements​

What to track:

  • All discounts given
  • Manager overrides and reasons
  • Void/comp transactions
  • Revenue adjustments

Retention:

  • Financial data: 7 years minimum
  • Detailed transaction logs
  • Manager authorization records

Access:

  • Financial reports restricted to management
  • Location Admins see location data only
  • Auditors get read-only access

Tax Considerations​

Consult your accountant regarding:

  • Revenue recognition with discounts
  • Sales tax on discounted amounts
  • State-specific alcohol discount regulations
  • Loyalty program accounting standards

Troubleshooting Financial Reports​

Discrepancy Between Reports and POS​

Common causes:

  1. Timing differences (business date vs. calendar date)
  2. Manual discounts not logged in VIP system
  3. Voided transactions not reflected
  4. POS integration lag

Resolution:

  • Reconcile daily
  • Investigate large variances (>5%)
  • Ensure POS integration is working
  • Manual adjustments with manager approval

Negative ROI on Specific Offers​

If offer shows negative ROI:

  1. Verify discount percentage isn't too high
  2. Check if offer attracts low spenders
  3. Compare to non-offer nights (is it truly incremental?)
  4. Consider reducing offer frequency or depth

Adjust strategy:

  • Lower discount percentage
  • Add minimum spend requirement
  • Limit redemptions per customer
  • Target higher-tier customers only

Missing Revenue Data​

If revenue data incomplete:

  1. Check POS integration status
  2. Verify manual entry procedures followed
  3. Ensure all locations reporting
  4. Contact support if data loss suspected