Fluent Essays

Are you able to assist with a KPI dashboard for medical billing  that includes benchmarks. Also attached is a dashboard but it doesn’t include measurements to show on or below target. The KPIs and benchmarks will include Net Collection Rate (Internal Benchmark >97\%-Industry Benchmark >95\%) (Payments-Credits)/(Charges-contractual adjustments)X100 Days in AR (Internal Benchmark < 40 days-Industry Benchmark < 45 Days) Divide Total AR by Average Daily Charges AR \% over 120 days (Internal Benchmark <20\% of Total AR-Industry Benchmark <25\% of Total AR) Divide Total AR by AR over 120 days Net AR ( Internal Benchmark <10\% of annual charges-Industry Benchmark <10\% of annual charges) 6 Month Avg Charges-Payments-Adjustments=Net AR Clean Claim Rate (Internal Benchmark Under 2\%-Industry Benchmark 5\%) 2021.06 Medical Five Rivers Medical Billing Assessment Avg Billed past 6 months June, 2021 1,045,091.97 Charges Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Medicaid 743,470.60 632,477.60 737,930.43 716,028.65 662,926.98 703,977.30 699,468.59 41,050.32 Medicare 100,441.04 130,273.97 127,476.47 110,298.79 107,622.14 101,678.62 112,965.17 (5,943.52) Private 156,213.25 141,347.78 168,185.65 149,554.34 134,823.10 147,462.55 149,597.78 12,639.45 Subtotal 1,000,124.89 904,099.35 1,033,592.55 975,881.78 905,372.22 953,118.47 962,031.54 47,746.25 Self Pay 85,382.16 69,685.15 76,459.28 94,581.33 83,334.74 88,919.92 83,060.43 5,585.18 Total 1,085,507.05 973,784.50 1,110,051.83 1,070,463.11 988,706.96 1,042,038.39 1,045,091.97 53,331.43 8\% 7\% 7\% 9\% 8\% 9\% Payments Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Medicaid 782,848.79 615,075.54 725,877.87 798,132.75 662,926.98 731,233.81 719,349.29 68,306.83 Medicare 58,067.22 51,375.60 80,977.48 95,866.88 107,622.14 59,155.91 75,510.87 (48,466.23) Private 72,733.26 51,555.15 69,263.97 57,668.54 134,823.10 52,381.00 73,070.84 (82,442.10) Subtotal 913,649.27 718,006.29 876,119.32 951,668.17 905,372.22 842,770.72 867,931.00 (62,601.50) Self Pay 22,147.62 18,983.06 26,714.93 28,575.47 83,334.74 26,243.30 34,333.19 (57,091.44) Total 935,796.89 736,989.35 902,834.25 980,243.64 988,706.96 869,014.02 902,264.19 (182,294.44) 0 A/R by Financial Class Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months \% Medicaid 863,926.74 869,302.61 784,098.49 794,352.08 717,331.86 698,598.47 787,935.04 48\% Medicare 357,569.65 376,118.97 376,365.68 361,989.15 367,719.82 377,785.29 369,591.43 26\% Private 282,409.02 277,983.86 285,440.11 315,541.89 315,161.49 326,958.69 300,582.51 22\% Subtotal 1,503,905.41 1,523,405.44 1,445,904.28 1,471,883.12 1,400,213.17 1,403,342.45 1,458,108.98 96\% Self Pay 107,668.90 117,656.92 98,939.13 66,745.34 49,417.44 61,945.31 83,728.84 4\% Total 1,611,574.31 1,641,062.36 1,544,843.41 1,538,628.46 1,449,630.61 1,465,287.76 1,541,837.82 96\% Aging by Financial Class 0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits Medicaid 632,625.74 115,584.93 64,340.96 44,777.77 -55,899.88 801,429.52 698,598.47 (102,831.05) Medicare 82,046.36 42,533.62 32,454.73 34,081.35 200,335.33 391,451.39 377,785.29 (13,666.10) Private 102,875.14 35,234.60 23,729.95 28,439.41 177,722.17 368,001.27 326,958.69 (41,042.58) Subtotal 817,547.24 193,353.15 120,525.64 107,298.53 322,157.62 1,560,882.18 1,403,342.45 (157,539.73) Self Pay 61,537.24 46,635.79 35,734.24 17,778.26 104,537.50 266,223.03 61,945.31 (204,277.72) Total 879,084.48 239,988.94 156,259.88 125,076.79 426,695.12 1,827,105.21 1,465,287.76 (361,817.45) Pct of avg charges CLC targets A/R Distribution Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 \% Change 0-30 Days 995,530.93 967,578.49 943,094.43 992,435.66 958,392.09 879,084.48 48\% (79,307.61) 31-60 Days 399,898.18 452,595.36 322,844.09 275,801.57 231,035.52 239,988.94 13\% 8,953.42 61-90 Days 190,494.23 163,837.74 202,677.51 170,590.23 149,784.45 156,259.88 9\% 6,475.43 91-120 Days 147,005.89 145,088.56 126,096.21 145,105.88 126,387.14 125,076.79 7\% (1,310.35) >120 Days 293,273.62 323,369.44 336,635.62 321,770.70 345,865.91 426,695.12 23\% 80,829.21 Total 2,026,202.85 2,052,469.59 1,931,347.86 1,905,704.04 1,811,465.11 1,827,105.21 100\% 0 0 Days in A/R without Self Pay Dec-99 Dec-99 Medicaid 24 27 23 24 21 21 ERROR:#REF! Medicare 75 68 66 62 67 74 ERROR:#REF! Private 38 39 39 43 44 48 ERROR:#REF! Self Pay ERROR:#REF! Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF! Days in A/R Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Goal Change Medicaid 24 27 23 24 21 21 30 (0) Medicare 75 68 66 62 67 74 45 7 Private 38 39 39 43 44 48 45 4 Self Pay 26 32 27 17 12 15 20 2 Total 31 33 31 31 29 30 35 1 0 Encounters by Financial Class Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Medicaid 4393 4223 4789 5142 4762 4915 4,704 68\% Medicare 702 1716 1352 1055 907 842 1,096 12\% Private 801 879 1199 1291 926 932 1,005 13\% Self Pay 500 444 464 580 525 552 511 8\% Total 6,396 7,262 7,804 8,068 6,598 7,241 7,228 100\% 8\% 6\% 6\% 7\% 8\% 8\% 7\% 0\% Collections per Encounter Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Change Medicaid 178.20 145.65 151.57 155.22 139.21 148.78 153.11 9.56 Medicare 82.72 29.94 59.89 90.87 118.66 70.26 75.39 (48.40) Private 90.80 58.65 57.77 44.67 145.60 56.20 75.62 (89.39) Subtotal 154.96 105.31 119.36 127.09 137.28 125.99 128.33 (11.29) Self Pay 44.30 42.75 57.58 49.27 158.73 47.54 66.69 (111.19) Total 146.31 101.49 115.69 121.50 149.85 120.01 (29.84) - 0 Charges per Encounter Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Medicaid 169.24 149.77 154.09 139.25 139.21 143.23 149.13 4.02 Medicare 143.08 75.92 94.29 104.55 118.66 120.76 109.54 2.10 Private 195.02 160.81 140.27 115.84 145.60 158.22 152.63 12.62 Self Pay 170.76 156.95 164.78 163.07 158.73 161.09 162.56 2.35 Total 169.72 134.09 142.24 132.68 149.85 143.91 145.41 (5.94) Collection Rate Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 869,014.02 768,750.96 121,685.80 Payments + Adjustments 989,094.18 1,137,092.96 1,187,526.55 896,935.68 1,006,198.77 1,038,841.70 1,042,614.97 32,642.93 Collection Rate 63\% 72\% 74\% 75\% 74\% 84\% 74\% 9\% Adjustments 365,507.94 320,514.69 304,243.46 224,219.79 258,870.55 169,827.68 273,864.02 Charges and Payments Charges 44217 44248 44286 44307 44337 44368 1085507.05 973784.5 1110051.83 1070463.1100000001 988706.96 1042038.39 Payments 44217 44248 44286 44307 44337 44368 935796.89 736989.35000000009 902834.25 980243.64 988706.96 869014.02000000014 Days in A/R 44217 44248 44286 44307 44337 44368 31.177190889732131 33.470063585702562 30.708296060365658 30.730624921266198 28.816766800077957 29.76682479448673 Encounter Mix Medicaid 44217 44248 44286 44307 44337 44368 4393 4223 4789 5142 4762 4915 Medicare 44217 44248 44286 44307 44337 44368 702 1716 1352 1055 907 842 Private 44217 44248 44286 44307 44337 44368 801 879 1199 1291 926 932 Self Pay 44217 44248 44286 44307 44337 44368 500 444 464 580 525 552 A/R balances Medicaid 44217 44248 44286 44307 44337 44368 863926.74 869302.61 784098.49 794352.08 717331.86 698598.47 Medicare 44217 44248 44286 44307 44337 44368 357569.65 376118.97 376365.68 361989.15 367719.82 377785.29 Private 44217 44248 44286 44307 44337 44368 282409.02 277983.86 285440.11 315541.89 315161.49 326958.69 Self Pay 44217 44248 44286 44307 44337 44368 107668.9 117656.92 98939.13 66745.34 49417.440000000002 61945.31 2021.06 Dental Five Rivers Dental Billing Assessment Avg Billed past 6 months June, 2021 250,923.82 Charges Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Medicaid 171,274.60 169,305.48 204,571.13 203,789.80 180,214.30 207,455.70 189,435.17 27,241.40 Medicare 16,066.00 12,762.06 20,100.53 19,858.00 34,570.00 32,603.30 22,659.98 (1,966.70) Private 19,140.00 17,649.00 36,454.00 28,353.00 29,784.00 38,714.00 28,349.00 8,930.00 Subtotal 206,480.60 199,716.54 261,125.66 252,000.80 244,568.30 278,773.00 240,444.15 34,204.70 Self Pay 8,765.00 2,726.00 4,728.00 3,665.00 14,697.00 28,297.00 250,923.82 13,600.00 Total 215,245.60 202,442.54 265,853.66 255,665.80 259,265.30 307,070.00 250,923.82 47,804.70 4\% 1\% 2\% 1\% 6\% 9\% 3\% 4\% Payments Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Medicaid 61,521.70 90,435.38 77,005.40 82,268.94 72,030.24 109,511.07 82,128.79 37,480.83 Medicare 7,117.11 8,422.61 8,252.78 9,170.13 11,278.13 9,880.60 9,020.23 (1,397.53) Private 7,616.37 8,682.61 12,162.02 8,487.01 9,538.27 8,003.95 9,081.71 (1,534.32) Subtotal 76,255.18 107,540.60 97,420.20 99,926.08 92,846.64 127,395.62 100,230.72 34,548.98 Self Pay 1,343.93 407.28 933.31 937.00 4,038.82 7,082.95 2,457.22 3,044.13 Total 77,599.11 107,947.88 98,353.51 100,863.08 96,885.46 134,478.57 102,687.94 37,593.11 0 A/R by Financial Class Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Medicaid ERROR:#DIV/0! ERROR:#DIV/0! Private ERROR:#DIV/0! ERROR:#DIV/0! Subtotal - 0 - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0! Self Pay ERROR:#DIV/0! ERROR:#DIV/0! Total 321,275.39 328,328.24 270,891.96 304,336.88 310,746.04 307,115.70 ERROR:#DIV/0! Aging by Financial Class 0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Medicaid - 0 Private - 0 Subtotal - 0 - 0 - 0 - 0 - 0 - 0 Self Pay - 0 Total - 0 - 0 - 0 - 0 A/R Distribution Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 \% Change 0-30 Days 201,551.55 159,926.56 216,202.12 220,828.20 203,379.83 231,870.22 67\% 28,490.39 31-60 Days 79,421.54 85,940.37 70,830.78 68,594.91 65,015.11 39,610.73 11\% (25,404.38) 61-90 Days 20,280.66 14,556.09 27,562.77 14,020.61 18,789.57 31,145.29 9\% 12,355.72 91-120 Days 14,862.54 9,219.67 6,376.31 11,453.60 10,612.74 20,078.24 6\% 9,465.50 >120 Days 36,742.49 25,503.12 23,762.79 16,046.25 19,753.29 24,005.14 7\% 4,251.85 Total 352,858.78 295,145.81 344,734.77 330,943.57 317,550.54 346,709.62 29,159.08 ERROR:#DIV/0! 0 Days in A/R without Self Pay ERROR:#DIV/0! Dec-99 Medicaid - 0 - 0 - 0 - 0 - 0 - 0 346,990 - 0 Medicare ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! Private - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF! Self Pay ERROR:#REF! Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF! Days in A/R Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Goal Change Medicaid - 0 - 0 - 0 - 0 - 0 - 0 30 - 0 Private - 0 - 0 - 0 - 0 - 0 - 0 45 - 0 Self Pay - 0 - 0 - 0 - 0 - 0 - 0 20 - 0 Total 31 33 25 27 27 - 0 (27) 0 Encounters Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Medicaid ERROR:#DIV/0! 0 Private ERROR:#DIV/0! 0 Self Pay ERROR:#DIV/0! 0 Total 638 614 806 774 793 860 748 67.00 0\% 0\% 0\% 0\% 0\% 0\% Collections per Encounter Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Average Change Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Private - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Subtotal - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Self Pay ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! Total 121.63 175.81 122.03 130.31 122.18 156.37 138.05 34.19 Charges per Encounter Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Private - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Self Pay ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! Total 337.38 329.71 329.84 330.32 326.94 357.06 335.21 30.12 Collection Rate Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Avg - 6 months Change Payments 77,599.11 107,947.88 98,353.51 100,863.08 96,885.46 134,478.57 102,687.94 37,593.11 Payments + Adjustments 215,953.35 250,578.88 213,676.81 244,807.77 254,515.27 261,888.34 240,236.74 7,373.07 Collection Rate 36\% 43\% 46\% 41\% 38\% 51\% 43\% 13\% adjustments 138,354.24 142,631.00 115,323.30 143,944.69 157,629.81 127,409.77 137,548.80 Charges and Payments Charges 44217 44248 44286 44307 44337 44368 215245.6 202442.54 265853.66000000003 255665.8 259265.3 307070 Payments 44217 44248 44286 44307 44337 44368 77599.109999999986 107947.88 98353.51 100863.08 96885.460000000021 134478.57 Days in A/R 44217 44248 44286 44307 44337 44368 31.344581213274513 33.014550233578575 24.967300434296774 27.219006660508281 26.547948129593227 0 Encounter Mix Medicaid 43891 43922 43971 44002 44032 44063 Private 43891 43922 43971 44002 44032 44063 43891 43922 43971 44002 44032 44063 A/R balances 44217 44248 44286 44307 44337 44368 352858.77999999991 295145.81 344734.77 330943.56999999995 317550.53999999998 346709.62 2021.05 Medical Five Rivers Medical Billing Assessment Avg Billed past 6 months May, 2021 1,051,532.66 Charges Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Medicaid 741,521.02 743,470.60 632,477.60 737,930.43 716,028.65 662,926.98 705,725.88 (53,101.67) Medicare 99,997.04 100,441.04 130,273.97 127,476.47 110,298.79 107,622.14 112,684.91 (2,676.65) Private 156,079.25 156,213.25 141,347.78 168,185.65 149,554.34 134,823.10 151,033.90 (14,731.24) Subtotal 997,597.31 1,000,124.89 904,099.35 1,033,592.55 975,881.78 905,372.22 969,444.68 (70,509.56) Self Pay 83,085.17 85,382.16 69,685.15 76,459.28 94,581.33 83,334.74 82,087.97 (11,246.59) Total 1,080,682.48 1,085,507.05 973,784.50 1,110,051.83 1,070,463.11 988,706.96 1,051,532.66 (81,756.15) 8\% 8\% 7\% 7\% 9\% 8\% Payments Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Medicaid 676,352.11 782,848.79 615,075.54 725,877.87 798,132.75 662,926.98 710,202.34 (135,205.77) Medicare 50,524.29 58,067.22 51,375.60 80,977.48 95,866.88 107,622.14 74,072.27 11,755.26 Private 69,054.10 72,733.26 51,555.15 69,263.97 57,668.54 134,823.10 75,849.69 77,154.56 Subtotal 795,930.50 913,649.27 718,006.29 876,119.32 951,668.17 905,372.22 860,124.29 (46,295.95) Self Pay 21,834.20 22,147.62 18,983.06 26,714.93 28,575.47 83,334.74 33,598.34 54,759.27 Total 817,764.70 935,796.89 736,989.35 902,834.25 980,243.64 988,706.96 893,722.63 (37,832.63) 0 A/R by Financial Class Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months \% Medicaid 758,547.90 863,926.74 869,302.61 784,098.49 794,352.08 717,331.86 797,926.61 49\% Medicare 317,098.10 357,569.65 376,118.97 376,365.68 361,989.15 367,719.82 359,476.89 25\% Private 284,577.00 282,409.02 277,983.86 285,440.11 315,541.89 315,161.49 293,518.89 22\% Subtotal 1,360,223.00 1,503,905.41 1,523,405.44 1,445,904.28 1,471,883.12 1,400,213.17 1,450,922.40 97\% Self Pay 129,603.80 107,668.90 117,656.92 98,939.13 66,745.34 49,417.44 95,005.26 3\% Total 1,489,826.80 1,611,574.31 1,641,062.36 1,544,843.41 1,538,628.46 1,449,630.61 1,545,927.66 97\% Aging by Financial Class 0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits Medicaid 686,700.38 117,253.51 50,033.39 51,398.90 -81,353.96 824,032.22 717,331.86 (106,700.36) Medicare 100,046.71 40,543.54 34,654.31 33,168.55 172,862.28 381,275.39 367,719.82 (13,555.57) Private 106,789.24 33,902.43 30,781.16 26,575.57 158,689.54 356,737.94 315,161.49 (41,576.45) Subtotal 893,536.33 191,699.48 115,468.86 111,143.02 250,197.86 1,562,045.55 1,400,213.17 (161,832.38) Self Pay 64,855.76 39,336.04 34,315.59 15,244.12 95,668.05 249,419.56 49,417.44 (200,002.12) Total 958,392.09 231,035.52 149,784.45 126,387.14 345,865.91 1,811,465.11 1,449,630.61 (361,834.50) Pct of avg charges CLC targets A/R Distribution Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 \% Change 0-30 Days 924,329.07 995,530.93 967,578.49 943,094.43 992,435.66 958,392.09 53\% (34,043.57) 31-60 Days 354,643.56 399,898.18 452,595.36 322,844.09 275,801.57 231,035.52 13\% (44,766.05) 61-90 Days 165,459.22 190,494.23 163,837.74 202,677.51 170,590.23 149,784.45 8\% (20,805.78) 91-120 Days 117,807.69 147,005.89 145,088.56 126,096.21 145,105.88 126,387.14 7\% (18,718.74) >120 Days 334,755.62 293,273.62 323,369.44 336,635.62 321,770.70 345,865.91 19\% 24,095.21 Total 1,896,995.16 2,026,202.85 2,052,469.59 1,931,347.86 1,905,704.04 1,811,465.11 100\% 0 0 Days in A/R without Self Pay Dec-99 Dec-99 Medicaid 21 24 26 23 24 21 ERROR:#REF! Medicare 67 75 72 66 62 67 ERROR:#REF! Private 38 38 39 39 43 44 ERROR:#REF! Self Pay ERROR:#REF! Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF! Days in A/R Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Goal Change Medicaid 21 24 26 23 24 21 30 (3) Medicare 67 75 72 66 62 67 45 5 Private 38 38 39 39 43 44 45 1 Self Pay 33 27 31 27 17 12 20 (5) Total 29 31 33 31 31 29 35 (2) 0 Encounters by Financial Class Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Medicaid 4742 4393 4223 4789 5142 4762 4,675 67\% Medicare 749 702 1716 1352 1055 907 1,080 13\% Private 843 801 879 1199 1291 926 990 13\% Self Pay 527 500 444 464 580 525 507 7\% Total 6,861 6,396 7,262 7,804 6,598 7,120 7,007 100\% 8\% 8\% 6\% 6\% 9\% 7\% 7\% 0\% Collections per Encounter Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Change Medicaid 142.63 178.20 145.65 151.57 155.22 139.21 152.08 (16.01) Medicare 67.46 82.72 29.94 59.89 90.87 118.66 74.92 27.79 Private 81.91 90.80 58.65 57.77 44.67 145.60 79.90 100.93 Subtotal 125.66 154.96 105.31 119.36 127.09 137.28 128.28 10.19 Self Pay 41.43 44.30 42.75 57.58 49.27 158.73 65.68 109.46 Total 119.19 146.31 101.49 115.69 148.57 138.86 (9.70) - 0 Charges per Encounter Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Medicaid 156.37 169.24 149.77 154.09 139.25 139.21 151.32 (0.04) Medicare 133.51 143.08 75.92 94.29 104.55 118.66 111.67 14.11 Private 185.15 195.02 160.81 140.27 115.84 145.60 157.11 29.75 Self Pay 157.66 170.76 156.95 164.78 163.07 158.73 161.99 (4.34) Total 157.51 169.72 134.09 142.24 162.24 138.86 150.78 (23.38) Collection Rate Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 988,706.96 788,699.78 241,378.74 Payments + Adjustments 933,615.60 1,182,086.21 1,203,797.78 976,959.35 971,548.01 1,247,577.51 1,085,930.74 276,029.50 Collection Rate 67\% 69\% 73\% 69\% 77\% 79\% 72\% 2\% Adjustments 310,029.36 365,507.94 320,514.69 304,243.46 224,219.79 258,870.55 297,230.97 Charges and Payments Charges 44185 44217 44248 44286 44307 44337 1080682.48 1085507.05 973784.5 1110051.83 1070463.1100000001 988706.96 Payments 44185 44217 44248 44286 44307 44337 817764.7 935796.89 736989.35000000009 902834.25 980243.64 988706.96 Days in A/R 44185 44217 44248 44286 44307 44337 28.950559835114564 31.246629199615786 32.926045786436006 30.708296060365658 30.730624921266198 28.816766800077957 Encounter Mix Medicaid 44185 44217 44248 44286 44307 44337 4742 4393 4223 4789 5142 4762 Medicare 44185 44217 44248 44286 44307 44337 749 702 1716 1352 1055 907 Private 44185 44217 44248 44286 44307 44337 843 801 879 1199 1291 926 Self Pay 44185 44217 44248 44286 44307 44337 527 500 444 464 580 525 A/R balances Medicaid 44185 44217 44248 44286 44307 44337 758547.9 863926.74 869302.61 784098.49 794352.08 717331.86 Medicare 44185 44217 44248 44286 44307 44337 317098.09999999998 357569.65 376118.97 376365.68 361989.15 367719.82 Private 44185 44217 44248 44286 44307 44337 284577 282409.02 277983.86 285440.11 315541.89 315161.49 Self Pay 44185 44217 44248 44286 44307 44337 129603.8 107668.9 117656.92 98939.13 66745.34 49417.440000000002 2021.05 Dental Five Rivers Dental Billing Assessment Avg Billed past 6 months May, 2021 229,259.87 Charges Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Medicaid 146,135.19 171,274.60 169,305.48 204,571.13 203,789.80 180,214.30 179,215.08 (23,575.50) Medicare 16,194.12 16,066.00 12,762.06 20,100.53 19,858.00 34,570.00 19,925.12 14,712.00 Private 11,573.00 19,140.00 17,649.00 36,454.00 28,353.00 29,784.00 23,825.50 1,431.00 Subtotal 173,902.31 206,480.60 199,716.54 261,125.66 252,000.80 244,568.30 222,965.70 (7,432.50) Self Pay 3,184.00 8,765.00 2,726.00 4,728.00 3,665.00 14,697.00 229,259.87 11,032.00 Total 177,086.31 215,245.60 202,442.54 265,853.66 255,665.80 259,265.30 229,259.87 3,599.50 2\% 4\% 1\% 2\% 1\% 6\% 2\% -0\% Payments Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Medicaid 100,666.25 61,521.70 90,435.38 77,005.40 82,268.94 72,030.24 80,654.65 (10,238.70) Medicare 10,637.65 7,117.11 8,422.61 8,252.78 9,170.13 11,278.13 9,146.40 2,108.00 Private 6,579.99 7,616.37 8,682.61 12,162.02 8,487.01 9,538.27 8,844.38 1,051.26 Subtotal 117,883.89 76,255.18 107,540.60 97,420.20 99,926.08 92,846.64 98,645.43 (7,079.44) Self Pay 624.74 1,343.93 407.28 933.31 937.00 4,038.82 1,380.85 3,101.82 Total 118,508.63 77,599.11 107,947.88 98,353.51 100,863.08 96,885.46 100,026.28 (3,977.62) 0 A/R by Financial Class Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Medicaid ERROR:#DIV/0! 0\% Private ERROR:#DIV/0! 0\% Subtotal - 0 - 0 - 0 - 0 - 0 - 0 - 0 0\% Self Pay ERROR:#DIV/0! 0\% Total 436,727.79 321,275.39 328,328.24 270,891.96 304,336.88 310,746.04 328,717.72 100\% Aging by Financial Class 0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Medicaid - 0 Private - 0 Subtotal - 0 - 0 - 0 - 0 - 0 - 0 Self Pay - 0 Total - 0 - 0 - 0 - 0 A/R Distribution Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 \% Change 0-30 Days 160,604.70 201,551.55 159,926.56 216,202.12 220,828.20 203,379.83 64\% (17,448.37) 31-60 Days 87,877.52 79,421.54 85,940.37 70,830.78 68,594.91 65,015.11 20\% (3,579.80) 61-90 Days 35,870.23 20,280.66 14,556.09 27,562.77 14,020.61 18,789.57 6\% 4,768.96 91-120 Days 19,872.93 14,862.54 9,219.67 6,376.31 11,453.60 10,612.74 3\% (840.86) >120 Days 50,205.27 36,742.49 25,503.12 23,762.79 16,046.25 19,753.29 6\% 3,707.04 Total 354,430.65 352,858.78 295,145.81 344,734.77 330,943.57 317,550.54 (13,393.03) ERROR:#DIV/0! 0 Days in A/R without Self Pay ERROR:#DIV/0! Dec-99 Medicaid - 0 - 0 - 0 - 0 - 0 - 0 368,498 - 0 Medicare ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! Private - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF! Self Pay ERROR:#REF! Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF! Days in A/R Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Goal Change Medicaid - 0 - 0 - 0 - 0 - 0 - 0 30 - 0 Private - 0 - 0 - 0 - 0 - 0 - 0 45 - 0 Self Pay - 0 - 0 - 0 - 0 - 0 - 0 20 - 0 Total 52 34 35 26 27 27 (1) 0 Encounters Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Medicaid ERROR:#DIV/0! 0 Private ERROR:#DIV/0! 0 Self Pay ERROR:#DIV/0! 0 Total 565 638 614 806 774 793 698 19.00 0\% 0\% 0\% 0\% 0\% 0\% Collections per Encounter Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Average Change Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Private - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Subtotal - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Self Pay ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! Total 209.75 121.63 175.81 122.03 130.31 122.18 146.95 (8.14) Charges per Encounter Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Private - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 Self Pay ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! Total 313.43 337.38 329.71 329.84 330.32 326.94 327.94 (3.38) Collection Rate Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Avg - 6 months Change Payments 118,508.63 77,599.11 107,947.88 98,353.51 100,863.08 96,885.46 100,026.28 (3,977.62) Payments + Adjustments 272,115.42 215,953.35 250,578.88 213,676.81 244,807.77 254,515.27 241,941.25 9,707.50 Collection Rate 44\% 36\% 43\% 46\% 41\% 38\% 41\% -3\% adjustments 153,606.79 138,354.24 142,631.00 115,323.30 143,944.69 157,629.81 141,914.97 Charges and Payments Charges 44185 44217 44248 44286 44307 44337 177086.31 215245.6 202442.54 265853.66000000003 255665.8 259265.3 Payments 44185 44217 44248 44286 44307 44337 118508.63 77599.109999999986 107947.88 98353.51 100863.08 96885.460000000021 Days in A/R 44185 44217 44248 44286 44307 44337 51.789907362121895 34.393242140309205 34.77734983404212 26.439904037064277 27.219006660508281 26.547948129593227 Encounter Mix Medicaid 43891 43922 43971 44002 44032 44063 Private 43891 43922 43971 44002 44032 44063 43891 43922 43971 44002 44032 44063 A/R balances 44185 44217 44248 44286 44307 44337 354430.65 352858.77999999991 295145.81 344734.77 330943.56999999995 317550.53999999998 2021.04 Medical Five Rivers Medical Billing Assessment Avg Billed past 6 months April, 2021 1,053,531.01 Charges Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Change Medicaid 665,527.68 741,521.02 743,470.60 632,477.60 737,930.43 716,028.65 706,159.33 (21,901.78) Medicare 107,110.34 99,997.04 100,441.04 130,273.97 127,476.47 110,298.79 112,599.61 (17,177.68) Private 140,829.43 156,079.25 156,213.25 141,347.78 168,185.65 149,554.34 152,034.95 (18,631.31) Subtotal 913,467.45 997,597.31 1,000,124.89 904,099.35 1,033,592.55 975,881.78 970,793.89 (57,710.77) Self Pay 87,229.61 83,085.17 85,382.16 69,685.15 76,459.28 94,581.33 82,737.12 18,122.05 Total 1,000,697.06 1,080,682.48 1,085,507.05 973,784.50 1,110,051.83 1,070,463.11 1,053,531.01 (39,588.72) 9\% 8\% 8\% 7\% 7\% 9\% Payments Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Change Medicaid 670,942.32 676,352.11 782,848.79 615,075.54 725,877.87 798,132.75 711,538.23 72,254.88 Medicare 59,057.64 50,524.29 58,067.22 51,375.60 80,977.48 95,866.88 65,978.19 14,889.40 Private 52,894.39 69,054.10 72,733.26 51,555.15 69,263.97 57,668.54 62,194.90 (11,595.43) Subtotal 782,894.35 795,930.50 913,649.27 718,006.29 876,119.32 951,668.17 839,711.32 75,548.85 Self Pay 18,839.73 21,834.20 22,147.62 18,983.06 26,714.93 28,575.47 22,849.17 1,860.54 Total 801,734.08 817,764.70 935,796.89 736,989.35 902,834.25 980,243.64 862,560.48 152,958.24 0 A/R by Financial Class Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months \% Medicaid 692,523.43 758,547.90 863,926.74 869,302.61 784,098.49 794,352.08 793,791.88 52\% Medicare 358,504.93 317,098.10 357,569.65 376,118.97 376,365.68 361,989.15 357,941.08 24\% Private 301,481.50 284,577.00 282,409.02 277,983.86 285,440.11 315,541.89 291,238.90 21\% Subtotal 1,352,509.86 1,360,223.00 1,503,905.41 1,523,405.44 1,445,904.28 1,471,883.12 1,442,971.85 96\% Self Pay 146,233.82 129,603.80 107,668.90 117,656.92 98,939.13 66,745.34 111,141.32 4\% Total 1,498,743.68 1,489,826.80 1,611,574.31 1,641,062.36 1,544,843.41 1,538,628.46 1,554,113.17 96\% Aging by Financial Class 0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits Medicaid 716,623.17 160,918.92 72,019.60 58,463.11 -102,782.20 905,242.60 794,352.08 (110,890.52) Medicare 97,553.69 37,361.58 33,796.44 26,568.74 180,324.19 375,604.64 361,989.15 (13,615.49) Private 116,399.40 38,149.89 29,234.70 38,577.15 136,163.95 358,525.09 315,541.89 (42,983.20) Subtotal 930,576.26 236,430.39 135,050.74 123,609.00 213,705.94 1,639,372.33 1,471,883.12 (167,489.21) Self Pay 61,859.40 39,371.18 35,539.49 21,496.88 108,064.76 266,331.71 66,745.34 (199,586.37) Total 992,435.66 275,801.57 170,590.23 145,105.88 321,770.70 1,905,704.04 1,538,628.46 (367,075.58) Pct of avg charges CLC targets A/R Distribution Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 \% Change 0-30 Days 912,337.31 924,329.07 995,530.93 967,578.49 943,094.43 992,435.66 52\% 49,341.23 31-60 Days 370,410.44 354,643.56 399,898.18 452,595.36 322,844.09 275,801.57 14\% (47,042.52) 61-90 Days 148,279.99 165,459.22 190,494.23 163,837.74 202,677.51 170,590.23 9\% (32,087.28) 91-120 Days 106,957.70 117,807.69 147,005.89 145,088.56 126,096.21 145,105.88 8\% 19,009.67 >120 Days 367,326.76 334,755.62 293,273.62 323,369.44 336,635.62 321,770.70 17\% (14,864.92) Total 1,905,312.20 1,896,995.16 2,026,202.85 2,052,469.59 1,931,347.86 1,905,704.04 0 0 Days in A/R without Self Pay Dec-99 Dec-99 Medicaid 22 23 25 26 23 24 ERROR:#REF! Medicare 70 64 73 72 66 62 ERROR:#REF! Private 45 40 39 39 39 43 ERROR:#REF! Self Pay ERROR:#REF! Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF! Days in A/R Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Goal Change Medicaid 22 23 25 26 23 24 30 1 Medicare 70 64 73 72 66 62 45 (4) Private 45 40 39 39 39 43 45 5 Self Pay 35 32 27 31 27 17 20 (9) Total 31 30 32 33 31 31 35 0 0 Encounters by Financial Class Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Medicaid 4030 4742 4393 4223 4789 5142 4,553 64\% Medicare 734 749 702 1716 1352 1055 1,051 13\% Private 731 843 801 879 1199 1291 957 16\% Self Pay 475 527 500 444 464 580 498 7\% Total 5,970 6,861 6,396 7,262 6,598 8,068 6,859 100\% 8\% 8\% 8\% 6\% 7\% 7\% 7\% 0\% Collections per Encounter Nov-20 Dec-20 Jan-21 Feb-21