Skip to content

Financial Reporting

Kiket includes comprehensive financial reporting tools for SaaS businesses to track revenue metrics, analyze churn, manage commissions, and forecast growth.

Overview

The financial reporting suite provides:

  • Revenue Dashboards: Real-time MRR, ARR, and subscription metrics
  • Churn Analysis: Track and understand customer attrition
  • Cohort Reports: Analyze retention by customer cohort
  • Commission Tracking: Manage sales team compensation
  • Payment Analytics: Monitor payment success and dunning
  • Revenue Forecasting: Project future revenue with confidence intervals

Revenue Metrics Dashboard

Access the main financial dashboard at Admin > Finance > Financial Reports.

Key Metrics

Metric Description
MRR Monthly Recurring Revenue from active subscriptions
ARR Annual Recurring Revenue (MRR × 12)
ARPU Average Revenue Per User
NRR Net Revenue Retention percentage
Churn Rate Percentage of MRR lost to cancellations

MRR Movements

Track how your MRR changes over time:

  • New MRR: Revenue from new subscriptions
  • Expansion MRR: Upgrades and add-ons from existing customers
  • Contraction MRR: Downgrades from existing customers
  • Churned MRR: Revenue lost from cancellations
  • Net New MRR: Sum of all movements

Churn Analysis

Navigate to Admin > Finance > Financial Reports > Churn for detailed churn insights.

Churn Metrics

The churn dashboard displays:

  • Total churned subscriptions in the selected period
  • Churned MRR (revenue impact)
  • Churn rate as percentage of starting MRR
  • Average customer lifetime before churn

At-Risk Subscriptions

Proactively identify customers at risk of churning:

  • Past Due: Subscriptions with failed payments
  • Canceling: Subscriptions set to cancel at period end

Churn by Plan

Analyze which pricing tiers experience the most churn to identify product-market fit issues or pricing concerns.

Cohort Analysis

View customer retention by signup month at Admin > Finance > Financial Reports > Cohorts.

Cohort analysis helps answer:

  • How long do customers typically stay?
  • Which months had the best retention?
  • Is retention improving over time?

The cohort table shows retention percentages at each month interval, color-coded for quick identification of problem areas.

Commission Tracking

Manage sales commissions at Admin > Finance > Commissions.

Commission Workflow

  1. Pending: Commission created when a deal closes
  2. Approved: Manager approves the commission
  3. Paid: Finance marks the commission as paid
  4. Clawed Back: (If applicable) Commission reversed due to churn

Commission Configuration

Set up commission rates per sales rep or tier:

# Example commission structure
commissions:
  default_rate: 0.10  # 10% default
  tiers:
    - name: Standard
      rate: 0.10
    - name: Enterprise
      rate: 0.08
    - name: Strategic
      rate: 0.05

Bulk Operations

Process multiple commissions efficiently:

  • Bulk Approve: Approve all pending commissions for a period
  • Bulk Pay: Mark approved commissions as paid
  • Export: Download commission reports for payroll

Payment Analytics

Monitor payment health at Admin > Finance > Payment Analytics.

Success Rate Tracking

Track payment success rates over time:

  • Overall success rate
  • Success rate by card brand
  • Success rate by country
  • Retry success rate

Failure Analysis

Understand why payments fail:

Failure Code Description Suggested Action
card_declined Card was declined Request updated payment method
insufficient_funds Not enough funds Retry in a few days
expired_card Card has expired Request new card
processing_error Bank processing issue Automatic retry

Dunning Management

The dunning dashboard shows:

  • Overdue Buckets: Accounts grouped by days overdue (1-7, 8-14, 15-30, 30+)
  • At-Risk MRR: Total revenue at risk from past-due accounts
  • Failed Payment History: Organizations with repeated failures

Geographic Analysis

Break down revenue by region at Admin > Finance > Payment Analytics > Geography.

View metrics segmented by:

  • Country
  • Region/Continent
  • Timezone

Useful for identifying expansion opportunities and regional pricing considerations.

Revenue Forecasting

Generate revenue projections at Admin > Finance > Forecasts.

Forecast Models

Kiket uses exponential smoothing to project future revenue:

  • 12-Month Projections: Forward-looking MRR estimates
  • Confidence Intervals: Upper and lower bounds (default: 90% confidence)
  • Trend Analysis: Growth rate and momentum indicators

Generating Forecasts

  1. Navigate to Admin > Finance > Forecasts
  2. Click Generate Forecast
  3. Review projections and confidence intervals
  4. Compare forecast vs. actual as time progresses

Forecast Accuracy

Track how well past forecasts predicted actual results:

Period Forecasted Actual Variance
Oct 2025 $52,000 $51,200 -1.5%
Nov 2025 $54,000 $55,100 +2.0%

Scheduled Reports

Automate report delivery at Admin > Finance > Scheduled Reports.

Creating a Schedule

  1. Click New Schedule
  2. Configure:
  3. Name: Descriptive name for the schedule
  4. Report Type: Executive summary, MRR movements, or churn detail
  5. Format: PDF, Excel, or CSV
  6. Schedule: Cron expression (e.g., 0 8 * * 1 for Mondays at 8am)
  7. Recipients: Comma-separated email addresses

Common Schedules

Schedule Cron Expression Use Case
Weekly Monday 8am 0 8 * * 1 Weekly executive summary
Daily 9am 0 9 * * * Daily operations review
Monthly 1st at 6am 0 6 1 * * Monthly board reports
Bi-weekly 0 8 1,15 * * Bi-weekly finance review

Exporting Reports

Export financial data in multiple formats:

CSV Export

Best for data analysis in spreadsheets or importing into other systems.

# API example
curl -X POST "https://api.kiket.dev/admin/financial_reports/export.csv" \
  -H "Authorization: Bearer $TOKEN" \
  -d "report_type=executive_summary&start_date=2025-01-01&end_date=2025-12-31"

Excel Export

Formatted spreadsheets with multiple tabs for different metrics.

PDF Export

Print-ready reports with charts and formatting for executive presentations.

Data Snapshots

Kiket captures daily snapshots of key metrics for historical analysis. Snapshots include:

  • MRR and ARR
  • Active and trial subscriptions
  • Churn rate
  • ARPU
  • MRR movements (new, churned, expansion, contraction)

Snapshots are stored for at least 2 years and power historical trend analysis.

API Access

Access financial data programmatically:

# Get current metrics
curl "https://api.kiket.dev/admin/financial/metrics" \
  -H "Authorization: Bearer $TOKEN"

# Get MRR trend
curl "https://api.kiket.dev/admin/financial/mrr?months=12" \
  -H "Authorization: Bearer $TOKEN"

# Get churn data
curl "https://api.kiket.dev/admin/financial/churn?start_date=2025-01-01&end_date=2025-03-31" \
  -H "Authorization: Bearer $TOKEN"

Required Permissions

Financial reporting requires the following permissions:

Feature Required Permission
View dashboards financial.view
Export reports financial.export
Manage commissions financial.manage_commissions
Configure schedules financial.admin

See Roles and Permissions for details on assigning these permissions.

Best Practices

  • Daily monitoring: Check the main dashboard daily for anomalies
  • Weekly reviews: Review churn and at-risk accounts weekly
  • Monthly cohorts: Analyze cohort retention monthly
  • Automate delivery: Set up scheduled reports for stakeholders
  • Act on dunning: Follow up on past-due accounts promptly
  • Validate forecasts: Compare forecast vs. actual to improve accuracy

Integrations

Financial data integrates with:

  • Stripe: Automatic payment attempt tracking via webhooks
  • Slack: Alert notifications for significant metric changes
  • Accounting software: Export data for reconciliation

Troubleshooting

Missing Snapshot Data

If historical data is missing:

  1. Check that the snapshot job is running (rake metrics:snapshot)
  2. Verify the job schedule in Sidekiq
  3. Run a manual snapshot: rake metrics:snapshot:backfill

Incorrect MRR Calculations

MRR is calculated from active subscriptions:

  1. Verify subscription status is active or trial
  2. Check that price field is set correctly
  3. Ensure canceled subscriptions have canceled_at populated

Forecast Generation Fails

If forecast generation fails:

  1. Ensure at least 3 months of snapshot data exists
  2. Check for data anomalies (sudden large changes)
  3. Review logs for specific error messages

For additional help, contact support or check the troubleshooting guide.