Analytics & Reports

Analytics & Reports
Also See other essentials from the links below.
Medical Billing Office
Billing Solutions
Workflow Solutions

Analytics & Reports

We work with various data extraction and presentation tools to present data for interpretation and port them to “Spreadsheets” that are commonly used by Physician Administrators and decision makers. Sample of our analytics dashboards include

  • Operational Performance Improvement
  • Pay-For-Performance Monitoring
  • Compliance Analytics and Reporting
  • Provider Productivity and Coding Monitoring
  • Revenue Enhancement
  • Personalized Daily Actionable Dashboard

Net Collections

Month Charges by DOS
(in $)
Contract Adjustments
(in $)
Adjustment Net Charges
(in $)
Payments by DOS
(in $)
Payment % Net Collection Rate
Nov-14 $ 65,764.00 $ 21,372.23 32.5% $ 44,391.77 $ 41,448.05 63.0% 93.37%
Dec-14 $ 51,559.00 $ 16,323.06 31.7% $ 35,235.94 $ 31,661.58 61.4% 89.86%
Jan-15 $ 75,718.00 $ 24,554.79 32.4% $ 51,163.21 $ 46,017.52 60.8% 89.94%
Feb-15 $ 67,250.00 $ 21,932.46 32.6% $ 45,317.54 $ 39,113.14 58.2% 86.31%
Mar-15 $ 72,811.00 $ 18,670.08 25.6% $ 54,140.92 $ 32,345.13 44.4% 59.74%
Apr-15 $ 65,253.00 $ 4,957.29 7.6% $ 60,295.71 $ 13,124.69 20.1% 21.77%
  • ADJUSTMENT (%)
  • PAYMENT (%)
  • NET COLLECTION RATE (%)

Top Payers

Current Month Charges Current Month Receipts
Carrier Current Month Charges % of Monthly Charges Current Month Receipts % of Monthly Receipts
MEDICARE $ 24,600.00 21.38% $ 16,903.11 23.34%
BCBS $ 19,620.00 17.05% $ 12,770.84 17.64%
AETNA $ 12,475.00 10.84% $ 10,501.02 14.50%
CIGNA $ 41,286.00 35.88% $ 21,805.38 30.11%
UNICARE $ 3,215.00 2.79% $ 909.73 1.26%
UHC $ 2,300.00 2.00% $ 867.32 1.20%
MEDICAID $ 6,465.00 5.62% $ 4,664.60 6.44%
COMMERCIAL $ 5,120.00 4.45% $ 3,987.35 5.51%
Total $ 115,081.00 100.00% $ 72,409.35 100.00%
  • % OF MONTHLY RECEIPTS
  • % OF MONTHLY CHARGES

Service Analysis

For the period June 1, 2014 – June 31, 2014
Doctor Code Units Distribution Total Charges Total Receipts Avg $ per code Avg $ per range Avg $ per POS
Smith, MD 99222 7 0.80% $ 1,281.00 $ 684.89 $ 97.84
99223 864 99.20% $ 222,604.00 $ 95,743.01 $ 110.81 $ 110.71
99231 66 1.76 $ 3,755.00 $ 1,772.63 $ 26.86
99232 2813 75.17 $ 256,980.00 $ 107,364.36 $ 38.17
99233 863 23.06 $ 112,098.00 $ 50,575.79 $ 58.60 $ 42.68
99238 23 2.56 $ 2,631.00 $ 1,143.79 $ 49.73
99239 875 97.44 $ 136,526.00 $ 55,918.54 $ 63.91 $ 63.54
99302 3 100 $ 411.00 $ 219.28 $ 73.09 $ 24.36 $ 56.84