Complete Feature Set

Everything You Need for Revenue Cycle Analytics

From ODBC database connectivity to AI-powered insights, Vanaa Analytics gives healthcare billing teams a unified platform to connect, analyze, and act on claims data.

Database Integration

ODBC Database Connectivity

Connect directly to your SQL Server or any ODBC-compatible database. Vanaa Analytics securely bridges your existing billing database with real-time analytics — no data migration required.

  • Secure DSN-based SQL Server connection with encrypted credentials
  • Background task queue (Celery + Redis) for non-blocking data pulls
  • Connection status tracking and error diagnostics dashboard
  • Configurable DB host, port, database name, and credentials per user
  • Automatic reconnect with retry logic for transient failures
  • Supports both Windows Authentication and SQL Server Auth modes
ODBC Connection Status
  • SQL Server — Connected & Synced
  • Background Worker — Active
  • Last Sync — 2 minutes ago
  • Records Fetched — 48,320
  • Next Scheduled Pull — 15 min
Revenue Analytics

GCR / NCR Analytics Engine

Automated Gross Collection Rate and Net Collection Rate calculations at monthly and yearly granularity. Benchmark your billing performance and identify payers with collection gaps instantly.

  • Monthly & yearly GCR and NCR calculations from raw claims data
  • Trend charts comparing performance over 12-month periods
  • Carrier-level breakdowns — see which payers are dragging rates down
  • Adjustments, write-offs, and denial impact analysis included
  • All summaries exportable to formatted Excel reports
  • Drill-down from summary to individual claim transactions
GCR
Gross Rate
NCR
Net Rate
12mo
Trend View
Monthly Collection Rates
  • Jan–Dec GCR Summary — Auto-calculated
  • NCR by Payer — 12 carriers analyzed
  • Variance Report — vs. Prior Year
  • Export to Excel — One Click
Payment Analytics

Deposit Date & Payment Analysis

Track every payment by deposit date with date-of-service reconciliation. Understand exactly when revenue was collected and how it aligns with service delivery timelines.

  • Per-deposit payment tracking with daily and monthly rollups
  • Date-of-service vs. deposit-date reconciliation tables
  • Working days and calendar days lag analysis
  • Identifies payment patterns by day-of-week and month
  • Aging buckets: 0–30, 31–60, 61–90, 90+ days
  • Deposit month summaries with carrier contribution breakdown
Deposit Tracking
  • Deposit Date: 2024-03-15 — $48,920
  • DOS Lag Average — 18 working days
  • Aging 0–30 days — 62% of balance
  • Monthly Deposit Summary — Auto-grouped
Payer & Provider Intelligence

Provider & Payer Summaries

Know which providers are generating the most revenue and which insurance carriers are paying slowly. Automated breakdowns with performance metrics and comparative trends.

  • Top providers ranked by charges, payments, and collection rate
  • Insurance payer leaderboards with denial rates and AR aging
  • Provider-level GCR & NCR trend over configurable date range
  • Carrier-specific adjustment and write-off summaries
  • Side-by-side payer comparison view
  • Drill-down from payer summary to individual claim lines
Top Payers — Current Month
  • Medicare — $124,500 — 94.2% NCR
  • Medicaid — $87,200 — 88.7% NCR
  • BCBS — $63,400 — 91.3% NCR
  • UnitedHealth — $41,600 — 86.9% NCR
AI-Powered

Vanaa AI Analyzer Assistant

Ask questions about your billing data in plain English. Powered by Google Gemini with RAG (Retrieval-Augmented Generation), the AI assistant has full context of your analytics — from totals to trend patterns.

  • Natural language Q&A over your processed analytics data
  • Generates Python Pandas code for custom analysis on demand
  • Creates charts and visualizations from your data in real-time
  • Maintains full session context across multi-turn conversations
  • Export AI-generated reports directly to Excel or PDF
  • Powered by Google Gemini — the latest generative AI model
Vanaa AI — Chat Session
  • "What was March NCR for Medicare?"
  • Answered in 1.2s with chart generated
  • Pandas code snippet exported
  • Excel report ready to download
Data Ingestion

File Upload & Smart Processing

Upload claims data directly from Excel or CSV files when ODBC connectivity isn't available. The platform auto-parses column formats, handles edge cases, and runs the full analytics pipeline automatically.

  • Supports Excel (.xlsx/.xls) and CSV file formats
  • Smart column detection and type inference for claim fields
  • Handles messy dates, mixed currency formats, and blank rows
  • Full analytics pipeline runs automatically post-upload
  • Upload history and version management per session
  • Validation errors reported with row-level detail
Upload Processing
  • claims_Q1_2024.xlsx — Parsed successfully
  • 12,840 rows validated — 0 errors
  • Analytics pipeline — Running…
  • GCR/NCR calculated — Ready

All Platform Capabilities

A complete toolkit for modern healthcare revenue cycle management.

Secure Authentication

OTP-based email login, session management, HIPAA-ready access controls

Analytics Dashboard

Unified view of all metrics, charts, and KPIs in a single screen

Excel Export

All analytics and AI outputs exportable to formatted Excel workbooks

Background Processing

Celery + Redis task queue ensures analytics run without blocking the UI

Trend Visualization

Interactive charts for monthly, quarterly, and yearly trend analysis

Carrier Analytics

Insurance carrier-specific performance graphs and denial pattern analysis

Ready to Transform Your Revenue Cycle?

See all these features live in a personalized demo with your own billing data.