7/19/02 11:00:18 Page 7
Accounts Receivable Analysis
# Account Type #Patients% #Claims% Chg% Pay% Net% Gross%
Charges Payments Adjustments Refunds Undefined Balance
November 2001
1 MEDI-CAL 7 1% 14 2% 3% 2% 35% 100%
$2402.00 $848.96 $1553.04 $0.00
2 MEDICARE 14 3% 16 3% 2% 2% 53% 100%
$1934.00 $1026.95 $907.05 $0.00
3 MEDI-MEDI 19 4% 22 4% 5% 4% 45% 100%
$3880.00 $1773.13 $2106.87 $0.00
4 ASSIGNED INSURANCE 72 18% 85 16% 16% 18% 64% 99%
$11143.00 $7166.29 $3972.35 $69.24 $73.60
5 MEDICARE W/2ND INS 77 19% 107 21% 20% 19% 53% 97%
$14197.00 $7622.05 $6265.29 $309.66
6 PRIVATE PAY 16 4% 20 3% 2% 2% 53% 100%
$1614.00 $868.63 $745.37 $0.00
8 IPA (SAN BENITO) 62 15% 75 14% 13% 13% 55% 100%
$9466.00 $5271.87 $4254.13 ($60.00)
9 PROF COURTESY 2 0% 3 0% 0% 0% 73% 100%
$298.00 $218.20 $79.80 $0.00
11 LIFEGUARD 21 5% 23 4% 3% 4% 61% 100%
$2623.00 $1619.20 $1018.80 ($15.00)
12 BLUE CROSS 69 17% 95 18% 17% 16% 55% 98%
$11874.00 $6550.25 $5166.67 $30.00 $187.08
13 BLUE SHIELD 29 7% 41 8% 14% 15% 63% 100%
$9782.00 $6242.86 $3565.08 ($25.94)
------------------------------------------------------------------------------
November 2001 Totals 388 501 56% 99%
$69213.00 $39208.39 $29634.45 $99.24 $469.40
December 2001
1 MEDI-CAL 7 2% 8 1% 5% 2% 30% 87%
$3251.00 $985.80 $1868.20 $397.00
2 MEDICARE 9 2% 12 2% 3% 3% 58% 99%
$2325.00 $1352.14 $962.60 $10.26
3 MEDI-MEDI 7 2% 9 2% 1% 1% 41% 100%
$979.00 $410.37 $568.63 $0.00
4 ASSIGNED INSURANCE 61 18% 74 17% 17% 18% 61% 94%
$10412.00 $6365.57 $3484.82 $19.05 $580.66
5 MEDICARE W/2ND INS 71 21% 99 23% 23% 22% 54% 94%
$14137.00 $7723.65 $5926.45 $249.62 $736.52
6 PRIVATE PAY 10 3% 12 2% 2% 2% 43% 80%
$1668.00 $723.19 $620.81 $324.00
8 IPA (SAN BENITO) 38 11% 50 11% 9% 9% 54% 99%
$5983.00 $3267.08 $2710.92 $5.00
9 PROF COURTESY 3 0% 3 0% 0% 0% 12% 100%
$456.00 $56.00 $400.00 $0.00
11 LIFEGUARD 24 7% 29 6% 6% 6% 55% 100%
$3724.00 $2075.25 $1653.98 ($5.23)
12 BLUE CROSS 67 20% 86 20% 20% 21% 57% 98%
$12488.00 $7192.76 $5361.25 $263.52 $197.51
13 BLUE SHIELD 29 8% 48 11% 9% 11% 68% 106%
$5734.00 $3933.39 $2159.61 ($359.00)
------------------------------------------------------------------------------
December 2001 Totals 326 430 55% 96%
$61157.00 $34085.20 $25717.27 $532.19 $1886.72
(Continued on next page)
7/19/02 11:00:18 Page 8
Accounts Receivable Analysis
# Account Type #Patients% #Claims% Chg% Pay% Net% Gross%
Charges Payments Adjustments Refunds Undefined Balance
Recap
1 MEDI-CAL 76 1% 90 1% 3% 1% 29% 98%
$28173.00 $8448.12 $19327.88 $397.00
2 MEDICARE 161 3% 204 3% 4% 4% 57% 100%
$32554.00 $18606.79 $14034.51 $16.01 ($71.29)
3 MEDI-MEDI 238 5% 288 4% 4% 3% 42% 100%
$38349.00 $16136.17 $22212.83 $0.00
4 ASSIGNED INSURANCE 843 18% 1049 17% 18% 20% 65% 99%
$147007.00 $96290.80 $51445.17 $1014.56 $285.59
5 MEDICARE W/2ND INS 949 20% 1381 23% 22% 22% 57% 99%
$182270.50 $104577.45 $76907.39 $342.02 $1127.68
6 PRIVATE PAY 194 4% 241 4% 2% 3% 66% 98%
$22546.00 $14990.66 $7140.34 $5.00 $420.00
7 WORK COMP 5 0% 7 0% 0% 0% 85% 100%
$1571.00 $1344.45 $400.55 $174.00 $0.00
8 IPA (SAN BENITO) 679 14% 831 14% 13% 13% 55% 100%
$110257.00 $61002.03 $49597.40 ($342.43)
9 PROF COURTESY 20 0% 24 0% 0% 0% 51% 100%
$2796.00 $1447.96 $1348.04 $0.00
11 LIFEGUARD 238 5% 277 4% 4% 5% 61% 99%
$38637.00 $23895.52 $14544.71 $196.77
12 BLUE CROSS 800 17% 1021 17% 16% 16% 56% 99%
$136755.00 $77021.14 $59761.58 $894.26 $866.54
13 BLUE SHIELD 378 8% 504 8% 8% 8% 59% 100%
$69515.00 $41059.73 $28897.49 $130.40 ($311.82)
------------------------------------------------------------------------------
Recap Totals 4581 5917 57% 99%
$810430.50 $464820.82 $345617.89 $2576.25 $2568.04
Close Window