Dashboard by lRD56Jli

VIEWS: 36 PAGES: 8

									      Provider Reporting Statistics
      Billing Area: (300) HOSPITALIST PROGRAM 300

                                              Total                 Budget      Variance
      Description                         Fiscal YTD 07      %      YTD 07                 Feb-07           Mar-07             Apr-07

      Key Billing Measures

      Gross Charges                            $3,187,238          $2,839,917       12%    $442,652         $527,679          $465,293
      Average Charge Lag Days                        6.41                                      5.89             5.81              5.42
      Charge Work RVU's                            20,080                                     2,701            3,255             3,444
      Gross Self Pay Receivable                   $84,029                                   $96,041          $87,641           $84,029
      Gross Receivable                           $508,722                                  $584,442         $612,870          $508,722
      Gross Days Receivable (3 MO)                     32                                        39               37                32
      Cash Receipts                            $1,056,614           $860,526        23%    $181,030         $175,966          $186,305
      Co-payments @ TOS                                $5                                        $5               $0                $0
      Contractual Adjustments                  $1,968,077          $1,770,662        11%   $344,062         $305,779          $337,979
      Adjusted Denied Claims                      $43,709             $76,637       -43%     $2,405           $8,852            $8,020
      Bad Debt Write-Offs                         $53,902             $20,040       169%     $1,673           $4,529           $19,416
      Bad Debt Recoveries                            $825                                      $131               $0              $128
      Credit Balances                            -$11,846                                  -$10,836         -$11,505          -$11,846
      Credit Balance Refunds                        -$364                                     -$191             -$80              -$49

      Hospital Care

      Level 1 INI                                      45     2%                                 8     2%         8     2%           3     1%
      Level 2 INI                                   1,257    53%                               202    60%       216    56%         207    57%
      Level 3 INI                                   1,079    45%                               127    38%       162    42%         155    42%

      Level 1 SUB                                   3,561    39%                               544    39%       564    36%         571    42%
      Level 1 SUB                                   4,774    52%                               743    54%       850    55%         685    51%
      Level 1 SUB                                     835     9%                                95     7%       134     9%          97     7%

      Hospital Discharge Services

      99238                                         1,614    75%                               193    67%       261    73%         238    78%
      99239                                           532    25%                                96    33%        98    27%          67    22%

      Denial Categories

      Registration Related                        $52,902                                    $9,292           $7,608            $5,541
      Non Covered Services                        $38,305                                    $5,097           $6,998            $6,075
      Procedure Code Related                      $10,022                                      $892           $3,292            $1,080
      Incomplete Claim/Info Needed               $164,017                                   $17,048           $4,234            $4,238
      Duplicate Claim                             $57,158                                   $30,557           $4,605            $5,932
      Authorization/Referral Related              $48,559                                    $5,410           $4,948           $11,383
      Modifier Code Related                        $1,587                                      $621               $0              $207
      Filing Limit Exceeded                        $8,008                                    $1,763             $886            $2,733
      Maximum Benefits Reached                     $2,371                                      $656               $0                $0
      Global to Surgery                              $172                                        $0               $0                $0
      Provider Facility Related                   $10,532                                      $222           $5,223              $206
      Diagnosis Code Related                       $2,880                                      $976             $347              $484
      Documentation Related                        $3,709                                        $0             $989                $0
      Procedure Code Age Related                       $0                                        $0               $0                $0

      Total Denials                              $400,222                                   $72,534          $39,130           $37,879

      Practice Expense

      Actual Expenses (YTD)                  $1,164,506.00         $3,720,053       -69%   $817,056         $981,866         $1,164,506

      Appointment Scheduling Statistics

      Arrived Appointments                              0                                        0                0                  0
      Cancelled Appointments                            0                                        0                0                  0
      Bumped Appointments                               0                                        0                0                  0
      No Show Appointments                              0                                        0                0                  0
      New Patient Viisits                               0                                        0                0                  0

      Payer Mix

      Auto Accident                                $3,557     0%                                 $0    0%       $347    0%      $2,634     1%
      AETNA USHC CAP                               $1,395     0%                                 $0    0%       $347    0%        $485     0%
      AETNA Plans                                  $7,657     0%                               $519    0%       $747    0%      $3,300     1%
      BLUE Shield Plans                          $388,663    13%                            $60,362   14%    $69,707   14%     $58,858    13%
      CIGNA Health Plans                          $10,234     0%                             $1,089    0%     $1,403    0%      $1,603     0%
      Commercial Non-Contracted                   $87,858     3%                            $13,353    3%    $15,028    3%      $9,832     2%
      Evercare                                    $31,483     1%                               $107    0%     $5,883    1%      $4,145     1%
      HARVARD Plans                              $104,951     3%                            $17,877    4%    $12,576    3%     $20,505     5%
      Health Care Value                            $2,928     0%                               $566    0%         $0    0%          $0     0%
      MassHealth                                 $274,302     9%                            $38,980    9%    $35,955    7%     $38,375     9%
      Medicare                                 $1,978,568    64%                           $270,520   63%   $325,296   67%    $277,359    63%
      Neighborhood Health                         $12,551     0%                                 $0    0%         $0    0%          $0     0%
      Private Health Care                          $3,224     0%                                 $0    0%         $0    0%      $3,005     1%
      Secure Horizons                             $56,636     2%                            $13,646    3%    $14,443    3%     $12,267     3%
      TUFTS PPO Plans                             $36,698     1%                             $3,809    1%     $5,234    1%      $5,337     1%
      TUFTS HMO Plans                             $35,596     1%                             $3,461    1%     $5,871    1%      $7,292     2%
      United Health Plans                         $12,733     0%                               $104    0%     $2,034    0%        $637     0%
      Workers Comp                                 $4,599     0%                                 $0    0%       $671    0%          $0     0%
      SelfPay                                     $22,130     1%                             $1,774    0%    -$9,202   -2%     -$3,527    -1%

Prepared by S.Toth
Billing Area: (300) HOSPITALIST PROGRAM 300

                                                            Key Billing Measures: Gross                                                              Key Billing Measures: Charge Days                                                               Key Billing Measures: Results


                        $800                                                                                                         140                                                                Oct-06   $10,000
        Thousands



                                                                                                                  Oct-06                                                                                                                                                                                                Oct-06
                                                                                                                                                                                                        Nov-06
                                                                                                                  Nov-06                                                                                                                                                                                                Nov-06
                                                                                                                                                                                                        Dec-06
                                                                                                                  Dec-06                                                                                                                                                                                                Dec-06
                                                                                                                                                                                                        Jan-07
                                                                                                                  Jan-07                                                                                                                                                                                                Jan-07
                                                                                                                  Feb-07                                                                                Feb-07
                        $700                                                                                                                                                                                                                                                                                            Feb-07
                                                                                                                  Mar-07                                                                                Mar-07
                                                                                                                                     120                                                                                                                                                                                Mar-07
                                                                                                                  Apr-07                                                                                Apr-07
                                                                                                                                                                                                                                                                                                                        Apr-07
                                                                                                                  May-07                                                                                May-07

                                                                                                                  Jun-07                                                                                Jun-07     $5,000                                                                                               May-07
                                                                                                                                                                                                                                                                                                                        Jun-07
                                                                                                                  Jul-07                                                                                Jul-07
                        $600                                                                                                                                                                                                                                                                                            Jul-07
                                                                                                                  Aug-07                                                                                Aug-07
                                                                                                                                                                                                                                                                                                                        Aug-07
                                                                                                                                     100                                                                Sep-07
                                                                                                                  Sep-07                                                                                                                                                                                                Sep-07



                        $500
                                                                                                                                                                                                                       $0
                                                                                                                                     80                                                                                          Charge Work RVU's   Co-payments @ TOS   Adjusted Denied Claims   Credit Balances



                        $400


                                                                                                                                     60


                        $300
                                                                                                                                                                                                                  -$5,000


                                                                                                                                     40

                        $200

                                                                                                                                                                                                                 -$10,000
                                                                                                                                     20
                        $100




                         $0                                                                                                           0
                                         Gross Charges                       Gross Receivable   Cash Receipts                              Average Charge Lag Days       Gross Days Receivable (3 MO)            -$15,000


                                                           Initial Hospital Care
                                                                                                                                                                                                                 Denial Categories
        250
                                                                                                         Oct-06
                                                                                                         Nov-06
                                                                                                                               $80
                                                                                                                   Thousands




                                                                                                         Dec-06
                                                                                                         Jan-07
        200
                                                                                                         Feb-07                                                                                                                                                                                                     Oct-06
                                                                                                         Mar-07                                                                                                                                                                                                     Nov-06
                                                                                                         Apr-07                                                                                                                                                                                                     Dec-06
                                                                                                                               $70                                                                                                                                                                                  Jan-07
                                                                                                         May-07
        150
                                                                                                         Jun-07                                                                                                                                                                                                     Feb-07
                                                                                                         Jul-07                                                                                                                                                                                                     Mar-07
                                                                                                         Aug-07                                                                                                                                                                                                     Apr-07

        100                                                                                              Sep-07                $60                                                                                                                                                                                  May-07
                                                                                                                                                                                                                                                                                                                    Jun-07
                                                                                                                                                                                                                                                                                                                    Jul-07
                                                                                                                                                                                                                                                                                                                    Aug-07
                                                                                                                                                                                                                                                                                                                    Sep-07
             50
                                                                                                                               $50


                    0
                           Level 1 INI       Level 2 INI       Level 3 INI
                                                                                                                               $40

                                                 Hospital Discharge Services
                                                                                                                               $30
        300
                                                                                                        Oct-06
                                                                                                        Nov-06
                                                                                                        Dec-06
        250                                                                                             Jan-07
                                                                                                                               $20
                                                                                                        Feb-07
                                                                                                        Mar-07
        200                                                                                             Apr-07
                                                                                                        May-07
                                                                                                        Jun-07                 $10
        150                                                                                             Jul-07
                                                                                                        Aug-07
                                                                                                        Sep-07
        100
                                                                                                                                $0

             50


                    0
                                    99238                        99239
                                   Oct-06      Nov-06       Dec-06        Jan-07       Feb-07       Mar-07
Gross Charges                    $427,009     $404,959     $405,886     $513,760     $442,652     $527,679
Average Charge Lag Days              5.80         8.95         4.26         8.71         5.89         5.81
Charge Work RVU's                  $2,620       $2,469       $2,466       $3,126       $2,701       $3,255
Gross Self Pay Receivable        $122,325     $118,193      $93,877      $96,436      $96,041      $87,641
Gross Receivable                 $578,056     $621,673     $668,605     $679,724     $584,442     $612,870
Gross Days Receivable (3 MO)       124.54        68.00        49.69        47.21        38.61        37.17
Cash Receipts                    $137,929     $115,367     $107,060     $152,957     $181,030     $175,966
Co-payments @ TOS                        $0           $0           $0           $0           $5           $0
Contractual Adjustments          $249,496     $217,513     $207,427     $305,821     $344,062     $305,779
                #REF!            #REF!        #REF!        #REF!        #REF!        #REF!        #REF!
Adjusted Denied Claims             $2,097       $8,544       $7,206       $6,584       $2,405       $8,852
                #REF!            #REF!        #REF!        #REF!        #REF!        #REF!        #REF!
Bad Debt Write-Offs                $6,265       $7,315      $12,549       $2,155       $1,673       $4,529
Bad Debt Recoveries                      $0      $230              $0      $336         $131              $0
Credit Balances                   -$9,048      -$9,101      -$9,493     -$10,089     -$10,836     -$11,505
Credit Balance Refunds                   $0           $0       -$44             $0      -$191         -$80


Hospital Care

Level 1 INI                              15            7           4            0            8            8
Level 2 INI                          152          117          145          218          202          216
Level 3 INI                          152          154          152          177          127          162
                                         0             0           0            0            0            0
                                         0             0           0            0            0            0


Hospital Discharge Services

99238                                236          233          204          249          193          261
99239                                    57           57           75           82           96           98
                                         0             0           0            0            0            0


Denial Categories

Registration Related               $9,662       $7,885       $8,345       $4,569       $9,292       $7,608
Non Covered Services               $1,551       $7,868       $2,255       $8,461       $5,097       $6,998
Procedure Code Related              $463        $1,071       $1,583       $1,641        $892        $3,292
Incomplete Claim/Info Needed       $6,382      $66,824      $28,664      $36,627      $17,048       $4,234
Duplicate Claim                    $1,829       $3,881       $4,770       $5,584      $30,557       $4,605
Authorization/Referral Related     $7,499       $6,664       $4,873       $7,782       $5,410       $4,948
Modifier Code Related                    $0      $345              $0      $414         $621              $0
Filing Limit Exceeded                    $0           $0     $1,549       $1,077       $1,763        $886
Maximum Benefits Reached                 $0      $557              $0     $1,158        $656              $0
Global to Surgery                        $0           $0      $172              $0           $0           $0
Provider Facility Related    $2,041   $1,465   $391   $984   $222   $5,223
Diagnosis Code Related        $577       $0    $172   $324   $976    $347
Documentation Related        $1,549    $894    $277    $0     $0     $989
Procedure Code Age Related      $0       $0     $0     $0     $0       $0
  Apr-07      May-07        Jun-07       Jul-07      Aug-07       Sep-07
$465,293             $0           $0           $0           $0           $0
    5.42         0.00         0.00         0.00         0.00         0.00
  $3,444             $0           $0           $0           $0           $0
 $84,029             $0           $0           $0           $0           $0
$508,722             $0           $0           $0           $0           $0
   31.54         0.00         0.00         0.00         0.00         0.00
$186,305             $0           $0           $0           $0           $0
        $0           $0           $0           $0           $0           $0
$337,979             $0           $0           $0           $0           $0
#REF!        #REF!        #REF!        #REF!        #REF!        #REF!
  $8,020             $0           $0           $0           $0           $0
#REF!        #REF!        #REF!        #REF!        #REF!        #REF!
 $19,416             $0           $0           $0           $0           $0
   $128              $0           $0           $0           $0           $0
-$11,846             $0           $0           $0           $0           $0
    -$49             $0           $0           $0           $0           $0




        3            0            0            0            0            0
    207              0            0            0            0            0
    155              0            0            0            0            0
        0            0            0            0            0            0
        0            0            0            0            0            0




    238              0            0            0            0            0
        67           0            0            0            0            0
        0            0            0            0            0            0




  $5,541             $0           $0           $0           $0           $0
  $6,075             $0           $0           $0           $0           $0
  $1,080             $0           $0           $0           $0           $0
  $4,238             $0           $0           $0           $0           $0
  $5,932             $0           $0           $0           $0           $0
 $11,383             $0           $0           $0           $0           $0
   $207              $0           $0           $0           $0           $0
  $2,733             $0           $0           $0           $0           $0
        $0           $0           $0           $0           $0           $0
        $0           $0           $0           $0           $0           $0
$206   $0   $0   $0   $0   $0
$484   $0   $0   $0   $0   $0
 $0    $0   $0   $0   $0   $0
 $0    $0   $0   $0   $0   $0

								
To top