Overview
Onvelas billing reports give you a complete view of your revenue cycle. This guide explains the key reports and how to act on what they tell you.
Accessing Reports
- Go to Billing → Reports in the left sidebar.
- Select the report type from the tabs at the top of the page.
- Set the date range and any filters (payer, provider, location).
- Click Run Report or export to CSV.
Key Reports Explained
Collection Rate
Shows the percentage of billed charges that were actually collected. Calculated as: Total Payments ÷ Total Charges (adjusted for contractual write-offs). A healthy ABA practice typically achieves 85–95% net collection rate. If yours is below 80%, investigate denial rates and write-off patterns.
AR Aging
Breaks down outstanding balances by age bucket: 0–30, 31–60, 61–90, 91–120, and 120+ days. Best practice is to have less than 15% of AR in the 90+ bucket. Claims in the 120+ column are at high risk of timely filing expiration — prioritize these immediately.
Denial Rate by Payer
Shows which payers deny the most claims and the most common denial reasons (CARC codes). A denial rate above 5–7% for any payer warrants investigation. Common causes: authorization mismatches, credentialing gaps, or incorrect modifier usage.
Revenue Cycle Wheel (RCW)
The RCW is your real-time dashboard. It shows claims moving through each stage — Draft, Scrubbed, Submitted, Accepted, Adjudicated, Paid — and flags anything stuck at a stage. Aim to have no claims sitting in "Submitted" for more than 30 days without an ERA response.
ERA Reconciliation Report
Lists all ERA batches received, the claims they contain, and whether each claim was auto-posted or requires manual review. Use this to spot ERA lines that didn't match a claim (often due to a claim number discrepancy) and manually post them.
Taking Action on Reports
- High AR aging: Work the 90+ bucket first. Call payer provider relations for status on individual claims.
- High denial rate from one payer: Review CARC patterns. If it's consistently CO-97 (no authorization), check your auth tracking workflow.
- Low collection rate: Check if contractual adjustments are being properly applied or if patient balances are being written off without collection attempts.