KPI dashboard for medical billing

profilePearlbeauty
FiveRiversDashboard.xlsx
Home>Business & Finance homework help>Accounting homework help>KPI dashboard for medical billing

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 Mar-21 Apr-21 Change
Medicaid 166.49 142.63 178.20 145.65 151.57 155.22 156.63 3.65
Medicare 80.46 67.46 82.72 29.94 59.89 90.87 68.56 30.97
Private 72.36 81.91 90.80 58.65 57.77 44.67 67.69 (13.10)
Subtotal 142.47 125.66 154.96 105.31 119.36 127.09 129.14 7.73
Self Pay 39.66 41.43 44.30 42.75 57.58 49.27 45.83 (8.31)
Total 134.29 119.19 146.31 101.49 136.83 121.50 (15.34)
- 0
Charges per Encounter
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Change
Medicaid 165.14 156.37 169.24 149.77 154.09 139.25 155.64 (14.84)
Medicare 145.93 133.51 143.08 75.92 94.29 104.55 116.21 10.26
Private 192.65 185.15 195.02 160.81 140.27 115.84 164.96 (24.43)
Self Pay 183.64 157.66 170.76 156.95 164.78 163.07 166.14 (1.71)
Total 167.62 157.51 169.72 134.09 168.24 132.68 154.98 (35.56)
Collection Rate
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Change
Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 980,243.64 787,289.23 232,915.42
Payments + Adjustments 840,144.91 1,126,607.63 1,248,791.03 993,230.58 1,051,571.68 1,204,463.43 1,077,468.21 152,891.75
Collection Rate 74% 72% 71% 68% 71% 81% 73% 10%
Adjustments 216,558.67 310,029.36 365,507.94 320,514.69 304,243.46 224,219.79 290,178.99

Charges and Payments

Charges 44155 44185 44217 44248 44286 44307 1000697.0599999999 1080682.48 1085507.05 973784.5 1110051.83 1070463.1100000001 Payments 44155 44185 44217 44248 44286 44307 801734.08 817764.7 935796.89 736989.35000000009 902834.25 980243.64

Days in A/R

44155 44185 44217 44248 44286 44307 31.451693562485342 30.063102090452951 32.059620275192742 32.926045786436006 30.708296060365658 30.730624921266198

Encounter Mix

Medicaid 44155 44185 44217 44248 44286 44307 4030 4742 4393 4223 4789 5142 Medicare 44155 44185 44217 44248 44286 44307 734 749 702 1716 1352 1055 Private 44155 44185 44217 44248 44286 44307 731 843 801 879 1199 1291 Self Pay 44155 44185 44217 44248 44286 44307 475 527 500 444 464 580

A/R balances

Medicaid 44155 44185 44217 44248 44286 44307 692523.43 758547.9 863926.74 869302.61 784098.49 794352.08 Medicare 44155 44185 44217 44248 44286 44307 358504.93 317098.09999999998 357569.65 376118.97 376365.68 361989.15 Private 44155 44185 44217 44248 44286 44307 301481.5 284577 282409.02 277983.86 285440.11 315541.89 Self Pay 44155 44185 44217 44248 44286 44307 146233.82 129603.8 107668.9 117656.92 98939.13 66745.34

2021.04 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
April, 2021 216,179.20
Charges
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Change
Medicaid 136,402.77 146,135.19 171,274.60 169,305.48 204,571.13 203,789.80 171,913.16 (781.33)
Medicare 25,883.53 16,194.12 16,066.00 12,762.06 20,100.53 19,858.00 18,477.37 (242.53)
Private 14,164.00 11,573.00 19,140.00 17,649.00 36,454.00 28,353.00 21,222.17 (8,101.00)
Subtotal 176,450.30 173,902.31 206,480.60 199,716.54 261,125.66 252,000.80 211,612.70 (9,124.86)
Self Pay 4,331.00 3,184.00 8,765.00 2,726.00 4,728.00 3,665.00 216,179.20 (1,063.00)
Total 180,781.30 177,086.31 215,245.60 202,442.54 265,853.66 255,665.80 216,179.20 (10,187.86)
2% 2% 4% 1% 2% 1% 2% 0%
Payments
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Change
Medicaid 66,658.83 100,666.25 61,521.70 90,435.38 77,005.40 82,268.94 79,759.42 5,263.54
Medicare 19,779.68 10,637.65 7,117.11 8,422.61 8,252.78 9,170.13 10,563.33 917.35
Private 16,641.63 6,579.99 7,616.37 8,682.61 12,162.02 8,487.01 10,028.27 (3,675.01)
Subtotal 103,080.14 117,883.89 76,255.18 107,540.60 97,420.20 99,926.08 100,351.02 2,505.88
Self Pay 594.15 624.74 1,343.93 407.28 933.31 937.00 806.74 3.69
Total 103,674.29 118,508.63 77,599.11 107,947.88 98,353.51 100,863.08 101,157.75 2,509.57
0
A/R by Financial Class
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-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
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 % Change
0-30 Days 175,603.85 160,604.70 201,551.55 159,926.56 216,202.12 220,828.20 67% 4,626.08
31-60 Days 117,717.12 87,877.52 79,421.54 85,940.37 70,830.78 68,594.91 21% (2,235.87)
61-90 Days 68,835.04 35,870.23 20,280.66 14,556.09 27,562.77 14,020.61 4% (13,542.16)
91-120 Days 53,130.44 19,872.93 14,862.54 9,219.67 6,376.31 11,453.60 3% 5,077.29
>120 Days 41,660.35 50,205.27 36,742.49 25,503.12 23,762.79 16,046.25 5% (7,716.54)
Total 456,946.80 354,430.65 352,858.78 295,145.81 344,734.77 330,943.57 (13,791.20)
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 320,649 - 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
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-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 51 38 36 29 30 28 (2)
0
Encounters
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total 589 565 638 614 806 774 664 (32.00)
0% 0% 0% 0% 0% 0%
Collections per Encounter
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-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 176.02 209.75 121.63 175.81 122.03 130.31 155.92 8.29
Charges per Encounter
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-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 306.93 313.43 337.38 329.71 329.84 330.32 324.60 0.47
Collection Rate
Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 Avg - 6 months Change
Payments 103,674.29 118,508.63 77,599.11 107,947.88 98,353.51 100,863.08 101,157.75 2,509.57
Payments + Adjustments 222,199.99 272,115.42 215,953.35 250,578.88 213,676.81 244,807.77 236,555.37 31,130.96
Collection Rate 47% 44% 36% 43% 46% 41% 43% -5%
adjustments 118,525.70 153,606.79 138,354.24 142,631.00 115,323.30 143,944.69 135,397.62

Charges and Payments

Charges 44155 44185 44217 44248 44286 44307 180781.3 177086.31 215245.6 202442.54 265853.66000000003 255665.8 Payments 44155 44185 44217 44248 44286 44307 103674.29000000001 118508.63 77599.109999999986 107947.88 98353.51 100863.08

Days in A/R

44155 44185 44217 44248 44286 44307 50.731373156405006 37.705469852384802 36.091785635162729 29.340153354546082 29.704233016511623 27.792223316761913

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

44155 44185 44217 44248 44286 44307 456946.79999999993 354430.65 352858.77999999991 295145.81 344734.77 330943.56999999995

2021.03 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
March, 2021 1,035,328.64
Charges
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months Change
Medicaid 669,391.69 665,527.68 741,521.02 743,470.60 632,477.60 737,930.43 698,386.50 105,452.83
Medicare 91,451.34 107,110.34 99,997.04 100,441.04 130,273.97 127,476.47 109,458.37 (2,797.50)
Private 124,075.32 140,829.43 156,079.25 156,213.25 141,347.78 168,185.65 147,788.45 26,837.87
Subtotal 884,918.35 913,467.45 997,597.31 1,000,124.89 904,099.35 1,033,592.55 955,633.32 129,493.20
Self Pay 76,330.55 87,229.61 83,085.17 85,382.16 69,685.15 76,459.28 79,695.32 6,774.13
Total 961,248.90 1,000,697.06 1,080,682.48 1,085,507.05 973,784.50 1,110,051.83 1,035,328.64 136,267.33
8% 9% 8% 8% 7% 7%
Payments
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months Change
Medicaid 744,067.76 670,942.32 676,352.11 782,848.79 615,075.54 725,877.87 702,527.40 110,802.33
Medicare 54,518.06 59,057.64 50,524.29 58,067.22 51,375.60 80,977.48 59,086.72 29,601.88
Private 76,366.62 52,894.39 69,054.10 72,733.26 51,555.15 69,263.97 65,311.25 17,708.82
Subtotal 874,952.44 782,894.35 795,930.50 913,649.27 718,006.29 876,119.32 826,925.36 158,113.03
Self Pay 19,226.22 18,839.73 21,834.20 22,147.62 18,983.06 26,714.93 21,290.96 7,731.87
Total 894,178.66 801,734.08 817,764.70 935,796.89 736,989.35 902,834.25 848,216.32 323,957.93
0
A/R by Financial Class
Sep-20 Oct-20 Nov-20 Jan-21 Feb-21 Mar-21 Avg - 6 months %
Medicaid 704,338.98 692,523.43 758,547.90 863,926.74 869,302.61 784,098.49 778,789.69 51%
Medicare 344,587.87 358,504.93 317,098.10 357,569.65 376,118.97 376,365.68 355,040.87 24%
Private 291,241.16 301,481.50 284,577.00 282,409.02 277,983.86 285,440.11 287,188.77 18%
Subtotal 1,340,168.01 1,352,509.86 1,360,223.00 1,503,905.41 1,523,405.44 1,445,904.28 1,421,019.33 94%
Self Pay 136,010.62 146,233.82 129,603.80 107,668.90 117,656.92 98,939.13 122,685.53 6%
Total 1,476,178.63 1,498,743.68 1,489,826.80 1,611,574.31 1,641,062.36 1,544,843.41 1,543,704.87 94%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 683,875.64 205,350.53 100,000.00 52,236.77 -133,732.65 907,730.29 784,098.49 (123,631.80)
Medicare 88,113.52 40,691.70 34,749.35 24,621.08 201,658.62 389,834.27 376,365.68 (13,468.59)
Private 113,445.09 35,236.59 41,161.34 25,863.63 113,178.29 328,884.94 285,440.11 (43,444.83)
Subtotal 885,434.25 281,278.82 175,910.69 102,721.48 181,104.26 1,626,449.50 1,445,904.28 (180,545.22)
Self Pay 57,660.18 41,565.27 26,766.82 23,374.73 155,531.36 304,898.36 98,939.13 (205,959.23)
Total 943,094.43 322,844.09 202,677.51 126,096.21 336,635.62 1,931,347.86 1,544,843.41 (386,504.45)
Pct of avg charges
CLC targets
A/R Distribution
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 % Change
0-30 Days 1,043,049.07 912,337.31 924,329.07 995,530.93 967,578.49 943,094.43 49% (24,484.06)
31-60 Days 310,271.15 370,410.44 354,643.56 399,898.18 452,595.36 322,844.09 17% (129,751.27)
61-90 Days 120,581.42 148,279.99 165,459.22 190,494.23 163,837.74 202,677.51 10% 38,839.77
91-120 Days 76,397.64 106,957.70 117,807.69 147,005.89 145,088.56 126,096.21 7% (18,992.35)
>120 Days 332,613.72 367,326.76 334,755.62 293,273.62 323,369.44 336,635.62 17% 13,266.18
Total 1,882,913.00 1,905,312.20 1,896,995.16 2,026,202.85 2,052,469.59 1,931,347.86
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 22 22 23 25 26 23 ERROR:#REF!
Medicare 79 76 67 73 72 66 ERROR:#REF!
Private 49 48 43 39 39 39 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Goal Change
Medicaid 22 22 23 25 26 23 30 (2)
Medicare 79 76 67 73 72 66 45 (5)
Private 49 48 43 39 39 39 45 0
Self Pay 37 38 33 27 31 27 20 (4)
Total 32 32 31 32 33 31 35 (2)
0
Encounters by Financial Class
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months
Medicaid 4030 4742 4393 4223 4789 61%
Medicare 734 749 702 1716 1352 17%
Private 731 843 801 879 1199 15%
Self Pay 475 527 500 444 464 6%
Total - 0 5,970 6,861 6,396 6,598 7,804 5,605 100%
ERROR:#DIV/0! 8% 8% 8% 7% 6% ERROR:#DIV/0! 0%
Collections per Encounter
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Change
Medicaid - 0 166.49 142.63 178.20 145.65 151.57 130.76 5.92
Medicare - 0 80.46 67.46 82.72 29.94 59.89 53.41 29.96
Private - 0 72.36 81.91 90.80 58.65 57.77 60.25 (0.88)
Subtotal - 0 142.47 125.66 154.96 105.31 119.36 107.96 14.05
Self Pay - 0 39.66 41.43 44.30 42.75 57.58 37.62 14.82
Total - 0 134.29 119.19 146.31 111.70 115.69 3.99
- 0
Charges per Encounter
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months Change
Medicaid - 0 165.14 156.37 169.24 149.77 154.09 132.44 4.32
Medicare - 0 145.93 133.51 143.08 75.92 94.29 98.79 18.37
Private - 0 192.65 185.15 195.02 160.81 140.27 145.65 (20.53)
Self Pay ERROR:#DIV/0! 183.64 157.66 170.76 156.95 164.78 ERROR:#DIV/0! 7.83
Total - 0 167.62 157.51 169.72 147.59 142.24 130.78 (5.35)
Collection Rate
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months Change
Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 902,834.25 774,387.66 155,506.03
Payments + Adjustments 972,097.91 1,033,136.94 1,193,312.45 1,038,223.83 1,067,842.91 1,207,077.71 1,085,281.96 139,234.80
Collection Rate 64% 79% 74% 65% 70% 75% 71% 5%
Adjustments 348,511.67 216,558.67 310,029.36 365,507.94 320,514.69 304,243.46 310,894.30

Charges and Payments

Charges 44124 44155 44185 44217 44248 44286 961248.89999999991 1000697.0599999999 1080682.48 1085507.05 973784.5 1110051.83 Payments 44124 44155 44185 44217 44248 44286 894178.66 801734.08 817764.7 935796.89 736989.35000000009 902834.25

Days in A/R

44124 44155 44185 44217 44248 44286 32.249453008476785 32.084081745044607 30.848028358007461 32.059620275192742 32.926045786436006 30.708296060365658

Encounter Mix

Medicaid 44124 44155 44185 44217 44248 44286 4030 4742 4393 4223 4789 Medicare 44124 44155 44185 44217 44248 44286 734 749 702 1716 1352 Private 44124 44155 44185 44217 44248 44286 731 843 801 879 1199 Self Pay 44124 44155 44185 44217 44248 44286 475 527 500 444 464

A/R balances

Medicaid 44094 44124 44155 44217 44248 44286 704338.98 692523.43 758547.9 863926.74 869302.61 784098.49 Medicare 44094 44124 44155 44217 44248 44286 344587.87 358504.93 317098.09999999998 357569.65 376118.97 376365.68 Private 44094 44124 44155 44217 44248 44286 291241.15999999997 301481.5 284577 282409.02 277983.86 285440.11 Self Pay 44094 44124 44155 44217 44248 44286 136010.62 146233.82 129603.8 107668.9 117656.92 98939.13

2021.03 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
March, 2021 211,313.81
Charges
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months Change
Medicaid 171,147.42 136,402.77 146,135.19 171,274.60 169,305.48 204,571.13 166,472.76 35,265.65
Medicare 21,214.00 25,883.53 16,194.12 16,066.00 12,762.06 20,100.53 18,703.37 7,338.47
Private 24,707.00 14,164.00 11,573.00 19,140.00 17,649.00 36,454.00 20,614.50 18,805.00
Subtotal 217,068.42 176,450.30 173,902.31 206,480.60 199,716.54 261,125.66 205,790.64 61,409.12
Self Pay 9,405.00 4,331.00 3,184.00 8,765.00 2,726.00 4,728.00 211,313.81 2,002.00
Total 226,473.42 180,781.30 177,086.31 215,245.60 202,442.54 265,853.66 211,313.81 63,411.12
4% 2% 2% 4% 1% 2% 3% -3%
Payments
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months Change
Medicaid 65,873.68 66,658.83 100,666.25 61,521.70 90,435.38 77,005.40 77,026.87 (13,429.98)
Medicare 8,232.49 19,779.68 10,637.65 7,117.11 8,422.61 8,252.78 10,407.05 (169.83)
Private 11,393.99 16,641.63 6,579.99 7,616.37 8,682.61 12,162.02 10,512.77 3,479.41
Subtotal 85,500.16 103,080.14 117,883.89 76,255.18 107,540.60 97,420.20 97,946.70 (10,120.40)
Self Pay 2,268.26 594.15 624.74 1,343.93 407.28 933.31 1,028.61 526.03
Total 87,768.42 103,674.29 118,508.63 77,599.11 107,947.88 98,353.51 98,975.31 (9,594.37)
0
A/R by Financial Class
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-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 496,130.79 436,727.79 321,275.39 328,328.24 270,891.96 304,336.88 359,615.18 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
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 % Change
0-30 Days 211,580.29 175,603.85 160,604.70 201,551.55 159,926.56 216,202.12 63% 56,275.56
31-60 Days 121,284.97 117,717.12 87,877.52 79,421.54 85,940.37 70,830.78 21% (15,109.59)
61-90 Days 79,289.58 68,835.04 35,870.23 20,280.66 14,556.09 27,562.77 8% 13,006.68
91-120 Days 22,236.72 53,130.44 19,872.93 14,862.54 9,219.67 6,376.31 2% (2,843.36)
>120 Days 76,575.43 41,660.35 50,205.27 36,742.49 25,503.12 23,762.79 7% (1,740.33)
Total 510,966.99 456,946.80 354,430.65 352,858.78 295,145.81 344,734.77 49,588.96
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 389,601 - 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
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-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 46 45 35 34 29 30 0
0
Encounters by Financial Class
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 589 565 638 614 806 535 192.00
ERROR:#DIV/0! 0% 0% 0% 0% 0%
Collections per Encounter
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-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 - 0 176.02 209.75 121.63 175.81 122.03 134.21 (53.78)
Charges per Encounter
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-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 - 0 306.93 313.43 337.38 329.71 329.84 269.55 0.13
Collection Rate
Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Avg - 6 months Change
Payments 87,768.42 103,674.29 118,508.63 77,599.11 107,947.88 98,353.51 98,975.31 (9,594.37)
Payments + Adjustments 197,196.47 222,199.99 272,115.42 215,953.35 250,578.88 213,676.81 228,620.15 (36,902.07)
Collection Rate 45% 47% 44% 36% 43% 46% 43% 3%
adjustments 109,428.05 118,525.70 153,606.79 138,354.24 142,631.00 115,323.30 129,644.85

Charges and Payments

Charges 44124 44155 44185 44217 44248 44286 226473.42 180781.3 177086.31 215245.6 202442.54 265853.66000000003 Payments 44124 44155 44185 44217 44248 44286 87768.42 103674.29000000001 118508.63 77599.109999999986 107947.88 98353.51

Days in A/R

44124 44155 44185 44217 44248 44286 46.00427983999181 45.039544735049354 34.63790583043604 34.492287796257926 29.340153354546082 29.704233016511623

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

44124 44155 44185 44217 44248 44286 510966.99000000005 456946.79999999993 354430.65 352858.77999999991 295145.81 344734.77

2021.02 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
February, 2021 1,031,523.79
Charges
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months Change
Medicaid 712,466.37 669,391.69 665,527.68 741,521.02 743,470.60 632,477.60 694,142.49 (110,993.00)
Medicare 111,623.00 91,451.34 107,110.34 99,997.04 100,441.04 130,273.97 106,816.12 29,832.93
Private 185,016.90 124,075.32 140,829.43 156,079.25 156,213.25 141,347.78 150,593.66 (14,865.47)
Subtotal 1,009,106.27 884,918.35 913,467.45 997,597.31 1,000,124.89 904,099.35 951,552.27 (96,025.54)
Self Pay 78,116.46 76,330.55 87,229.61 83,085.17 85,382.16 69,685.15 79,971.52 (15,697.01)
Total 1,087,222.73 961,248.90 1,000,697.06 1,080,682.48 1,085,507.05 973,784.50 1,031,523.79 (111,722.55)
7% 8% 9% 8% 8% 7%
Payments
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months Change
Medicaid 627,298.22 744,067.76 670,942.32 676,352.11 782,848.79 615,075.54 686,097.46 (167,773.25)
Medicare 47,202.44 54,518.06 59,057.64 50,524.29 58,067.22 51,375.60 53,457.54 (6,691.62)
Private 53,975.53 76,366.62 52,894.39 69,054.10 72,733.26 51,555.15 62,763.17 (21,178.11)
Subtotal 728,476.19 874,952.44 782,894.35 795,930.50 913,649.27 718,006.29 802,318.17 (195,642.98)
Self Pay 18,852.03 19,226.22 18,839.73 21,834.20 22,147.62 18,983.06 19,980.48 (3,164.56)
Total 747,328.22 894,178.66 801,734.08 817,764.70 935,796.89 736,989.35 822,298.65 (394,450.52)
0
A/R by Financial Class
Aug-20 Sep-20 Oct-20 Nov-20 Jan-21 Feb-21 Avg - 6 months %
Medicaid 683,460.02 704,338.98 692,523.43 758,547.90 863,926.74 869,302.61 762,016.61 53%
Medicare 398,939.98 344,587.87 358,504.93 317,098.10 357,569.65 376,118.97 358,803.25 23%
Private 327,389.91 291,241.16 301,481.50 284,577.00 282,409.02 277,983.86 294,180.41 17%
Subtotal 1,409,789.91 1,340,168.01 1,352,509.86 1,360,223.00 1,503,905.41 1,523,405.44 1,415,000.27 93%
Self Pay 128,851.53 136,010.62 146,233.82 129,603.80 107,668.90 117,656.92 127,670.93 7%
Total 1,538,641.44 1,476,178.63 1,498,743.68 1,489,826.80 1,611,574.31 1,641,062.36 1,542,671.20 93%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 690,748.70 329,795.14 82,058.71 60,636.68 -147,535.08 1,015,704.15 869,302.61 (146,401.54)
Medicare 96,320.08 41,533.38 28,456.17 26,101.46 200,474.37 392,885.46 376,118.97 (16,766.49)
Private 117,727.17 49,871.71 26,480.89 25,333.55 103,189.71 322,603.03 277,983.86 (44,619.17)
Subtotal 904,795.95 421,200.23 136,995.77 112,071.69 156,129.00 1,731,192.64 1,523,405.44 (207,787.20)
Self Pay 62,782.54 31,395.13 26,841.97 33,016.87 167,240.44 321,276.95 117,656.92 (203,620.03)
Total 967,578.49 452,595.36 163,837.74 145,088.56 323,369.44 2,052,469.59 1,641,062.36 (411,407.23)
Pct of avg charges
CLC targets
A/R Distribution
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 % Change
0-30 Days 1,090,128.95 1,043,049.07 912,337.31 924,329.07 995,530.93 967,578.49 47% (27,952.44)
31-60 Days 282,477.43 310,271.15 370,410.44 354,643.56 399,898.18 452,595.36 22% 52,697.18
61-90 Days 98,558.85 120,581.42 148,279.99 165,459.22 190,494.23 163,837.74 8% (26,656.49)
91-120 Days 93,619.99 76,397.64 106,957.70 117,807.69 147,005.89 145,088.56 7% (1,917.33)
>120 Days 395,169.39 332,613.72 367,326.76 334,755.62 293,273.62 323,369.44 16% 30,095.82
Total 1,959,954.61 1,882,913.00 1,905,312.20 1,896,995.16 2,026,202.85 2,052,469.59
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 20 21 21 23 25 26 ERROR:#REF!
Medicare 75 71 73 67 73 72 ERROR:#REF!
Private 37 40 42 43 39 39 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Goal Change
Medicaid 20 21 21 23 25 26 30 1
Medicare 75 71 73 67 73 72 45 (2)
Private 37 40 42 43 39 39 45 (1)
Self Pay 35 37 38 33 27 31 20 5
Total 30 30 31 31 32 33 35 1
0
Encounters by Financial Class
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months
Medicaid 4030 4742 4393 4223 64%
Medicare 734 749 702 1716 26%
Private 731 843 801 879 13%
Self Pay 475 527 500 444 7%
Total - 0 - 0 5,970 6,861 6,396 6,598 4,304 100%
ERROR:#DIV/0! ERROR:#DIV/0! 8% 8% 8% 7% ERROR:#DIV/0! 0%
Collections per Encounter
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Change
Medicaid - 0 - 0 166.49 142.63 178.20 145.65 105.49 (32.55)
Medicare - 0 - 0 80.46 67.46 82.72 29.94 43.43 (52.78)
Private - 0 - 0 72.36 81.91 90.80 58.65 50.62 (32.15)
Subtotal - 0 - 0 142.47 125.66 154.96 105.31 88.07 (49.65)
Self Pay - 0 - 0 39.66 41.43 44.30 42.75 28.02 (1.54)
Total - 0 - 0 134.29 119.19 146.31 111.70 (34.61)
- 0
Charges per Encounter
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months Change
Medicaid - 0 - 0 165.14 156.37 169.24 149.77 106.75 (19.47)
Medicare - 0 - 0 145.93 133.51 143.08 75.92 83.07 (67.16)
Private - 0 - 0 192.65 185.15 195.02 160.81 122.27 (34.22)
Self Pay ERROR:#DIV/0! ERROR:#DIV/0! 183.64 157.66 170.76 156.95 ERROR:#DIV/0! (13.82)
Total - 0 - 0 167.62 157.51 169.72 147.59 107.07 (22.13)
Collection Rate
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months Change
Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 736,989.35 746,746.84 (10,338.87)
Payments + Adjustments 918,759.53 1,165,089.94 1,099,841.76 982,745.25 1,112,836.16 1,057,504.04 1,056,129.45 (55,332.12)
Collection Rate 68% 70% 80% 68% 67% 70% 71% 3%
Adjustments 295,173.29 348,511.67 216,558.67 310,029.36 365,507.94 320,514.69 309,382.60

Charges and Payments

Charges 44094 44124 44155 44185 44217 44248 1087222.73 961248.89999999991 1000697.0599999999 1080682.48 1085507.05 973784.5 Payments 44094 44124 44155 44185 44217 44248 747328.22 894178.66 801734.08 817764.7 935796.89 736989.35000000009

Days in A/R

44094 44124 44155 44185 44217 44248 29.71927402584749 30.266224609612973 30.966096480545986 30.848028358007461 32.059620275192742 32.926045786436006

Encounter Mix

Medicaid 44094 44124 44155 44185 44217 44248 4030 4742 4393 4223 Medicare 44094 44124 44155 44185 44217 44248 734 749 702 1716 Private 44094 44124 44155 44185 44217 44248 731 843 801 879 Self Pay 44094 44124 44155 44185 44217 44248 475 527 500 444

A/R balances

Medicaid 44063 44094 44124 44155 44217 44248 683460.02 704338.98 692523.43 758547.9 863926.74 869302.61 Medicare 44063 44094 44124 44155 44217 44248 398939.98 344587.87 358504.93 317098.09999999998 357569.65 376118.97 Private 44063 44094 44124 44155 44217 44248 327389.90999999997 291241.15999999997 301481.5 284577 282409.02 277983.86 Self Pay 44063 44094 44124 44155 44217 44248 128851.53 136010.62 146233.82 129603.8 107668.9 117656.92

2021.02 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
February, 2021 200,213.87
Charges
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months Change
Medicaid 156,864.07 171,147.42 136,402.77 146,135.19 171,274.60 169,305.48 158,521.59 (1,969.12)
Medicare 6,457.00 21,214.00 25,883.53 16,194.12 16,066.00 12,762.06 16,429.45 (3,303.94)
Private 29,850.00 24,707.00 14,164.00 11,573.00 19,140.00 17,649.00 19,513.83 (1,491.00)
Subtotal 193,171.07 217,068.42 176,450.30 173,902.31 206,480.60 199,716.54 194,464.87 (6,764.06)
Self Pay 6,083.00 9,405.00 4,331.00 3,184.00 8,765.00 2,726.00 200,213.87 (6,039.00)
Total 199,254.07 226,473.42 180,781.30 177,086.31 215,245.60 202,442.54 200,213.87 (12,803.06)
3% 4% 2% 2% 4% 1% 3% 2%
Payments
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months Change
Medicaid 45,373.32 65,873.68 66,658.83 100,666.25 61,521.70 90,435.38 71,754.86 28,913.68
Medicare 2,423.45 8,232.49 19,779.68 10,637.65 7,117.11 8,422.61 9,435.50 1,305.50
Private 12,092.20 11,393.99 16,641.63 6,579.99 7,616.37 8,682.61 10,501.13 1,066.24
Subtotal 59,888.97 85,500.16 103,080.14 117,883.89 76,255.18 107,540.60 91,691.49 31,285.42
Self Pay 2,107.06 2,268.26 594.15 624.74 1,343.93 407.28 1,224.24 (936.65)
Total 61,996.03 87,768.42 103,674.29 118,508.63 77,599.11 107,947.88 92,915.73 30,348.77
0
A/R by Financial Class
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-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 496,867.80 496,130.79 436,727.79 321,275.39 328,328.24 270,891.96 391,703.66 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
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 % Change
0-30 Days 197,769.08 211,580.29 175,603.85 160,604.70 201,551.55 159,926.56 54% (41,624.99)
31-60 Days 150,409.22 121,284.97 117,717.12 87,877.52 79,421.54 85,940.37 29% 6,518.83
61-90 Days 29,271.79 79,289.58 68,835.04 35,870.23 20,280.66 14,556.09 5% (5,724.57)
91-120 Days 50,360.09 22,236.72 53,130.44 19,872.93 14,862.54 9,219.67 3% (5,642.87)
>120 Days 83,208.93 76,575.43 41,660.35 50,205.27 36,742.49 25,503.12 9% (11,239.37)
Total 511,019.11 510,966.99 456,946.80 354,430.65 352,858.78 295,145.81 (57,712.97)
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 404,636 - 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
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-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 49 45 34 34 29 (5)
0
Encounters by Financial Class
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 589 565 638 614 401 (24.00)
ERROR:#DIV/0! ERROR:#DIV/0! 0% 0% 0% 0%
Collections per Encounter
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-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 - 0 - 0 176.02 209.75 121.63 175.81 113.87 54.18
Charges per Encounter
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-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 - 0 - 0 306.93 313.43 337.38 329.71 214.57 (7.66)
Collection Rate
Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Avg - 6 months Change
Payments 61,996.03 87,768.42 103,674.29 118,508.63 77,599.11 107,947.88 92,915.73 30,348.77
Payments + Adjustments 189,218.72 197,196.47 222,199.99 272,115.42 215,953.35 250,578.88 224,543.81 34,625.53
Collection Rate 33% 45% 47% 44% 36% 43% 41% 7%
adjustments 127,222.69 109,428.05 118,525.70 153,606.79 138,354.24 142,631.00 131,628.08

Charges and Payments

Charges 44094 44124 44155 44185 44217 44248 199254.07 226473.42 180781.3 177086.31 215245.6 202442.54 Payments 44094 44124 44155 44185 44217 44248 61996.03 87768.42 103674.29000000001 118508.63 77599.109999999986 107947.88

Days in A/R

44094 44124 44155 44185 44217 44248 52.366427446124433 48.945613495618993 45.364306706915158 34.440149970309918 34.492287796257926 29.340153354546082

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

44094 44124 44155 44185 44217 44248 511019.10999999993 510966.99000000005 456946.79999999993 354430.65 352858.77999999991 295145.81

2021.01 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
January, 2021 993,689.33
Charges
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months Change
Medicaid 496,279.19 712,466.37 669,391.69 665,527.68 741,521.02 743,470.60 671,442.76 1,949.58
Medicare 70,397.04 111,623.00 91,451.34 107,110.34 99,997.04 100,441.04 96,836.63 444.00
Private 112,149.32 185,016.90 124,075.32 140,829.43 156,079.25 156,213.25 145,727.25 134.00
Subtotal 678,825.55 1,009,106.27 884,918.35 913,467.45 997,597.31 1,000,124.89 914,006.64 2,527.58
Self Pay 67,952.23 78,116.46 76,330.55 87,229.61 83,085.17 85,382.16 79,682.70 2,296.99
Total 746,777.78 1,087,222.73 961,248.90 1,000,697.06 1,080,682.48 1,085,507.05 993,689.33 4,824.57
9% 7% 8% 9% 8% 8%
Payments
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months Change
Medicaid 544,729.40 627,298.22 744,067.76 670,942.32 676,352.11 782,848.79 674,373.10 106,496.68
Medicare 43,359.18 47,202.44 54,518.06 59,057.64 50,524.29 58,067.22 52,121.47 7,542.93
Private 61,865.87 53,975.53 76,366.62 52,894.39 69,054.10 72,733.26 64,481.63 3,679.16
Subtotal 649,954.45 728,476.19 874,952.44 782,894.35 795,930.50 913,649.27 790,976.20 117,718.77
Self Pay 22,761.44 18,852.03 19,226.22 18,839.73 21,834.20 22,147.62 20,610.21 313.42
Total 672,715.89 747,328.22 894,178.66 801,734.08 817,764.70 935,796.89 811,586.41 235,750.96
0
A/R by Financial Class
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Jan-21 Avg - 6 months %
Medicaid 593,553.96 683,460.02 704,338.98 692,523.43 758,547.90 863,926.74 716,058.51 54%
Medicare 371,840.26 398,939.98 344,587.87 358,504.93 317,098.10 357,569.65 358,090.13 22%
Private 328,027.26 327,389.91 291,241.16 301,481.50 284,577.00 282,409.02 302,520.98 18%
Subtotal 1,293,421.48 1,409,789.91 1,340,168.01 1,352,509.86 1,360,223.00 1,503,905.41 1,376,669.61 93%
Self Pay 126,496.28 128,851.53 136,010.62 146,233.82 129,603.80 107,668.90 129,144.16 7%
Total 1,419,917.76 1,538,641.44 1,476,178.63 1,498,743.68 1,489,826.80 1,611,574.31 1,505,813.77 93%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 713,289.14 309,931.72 97,808.45 63,534.48 -168,265.37 1,016,298.42 863,926.74 152,371.68
Medicare 103,733.52 28,562.78 28,017.79 26,125.89 187,841.05 374,281.03 357,569.65 16,711.38
Private 131,684.40 36,420.26 28,712.09 15,030.45 114,248.92 326,096.12 282,409.02 43,687.10
Subtotal 948,707.06 374,914.76 154,538.33 104,690.82 133,824.60 1,716,675.57 1,503,905.41 212,770.16
Self Pay 46,823.87 24,983.42 35,955.90 42,315.07 159,449.02 309,527.28 107,668.90 201,858.38
Total 995,530.93 399,898.18 190,494.23 147,005.89 293,273.62 2,026,202.85 1,611,574.31 414,628.54
Pct of avg charges
CLC targets
A/R Distribution
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 % Change
0-30 Days 841,001.78 1,090,128.95 1,043,049.07 912,337.31 924,329.07 995,530.93 49% 71,201.86
31-60 Days 334,534.28 282,477.43 310,271.15 370,410.44 354,643.56 399,898.18 20% 45,254.62
61-90 Days 118,690.38 98,558.85 120,581.42 148,279.99 165,459.22 190,494.23 9% 25,035.01
91-120 Days 96,828.51 93,619.99 76,397.64 106,957.70 117,807.69 147,005.89 7% 29,198.20
>120 Days 449,000.66 395,169.39 332,613.72 367,326.76 334,755.62 293,273.62 14% (41,482.00)
Total 1,840,055.61 1,959,954.61 1,882,913.00 1,905,312.20 1,896,995.16 2,026,202.85
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 25 24 24 21 23 25 ERROR:#REF!
Medicare 111 92 79 73 67 73 ERROR:#REF!
Private 61 46 44 42 43 39 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Goal Change
Medicaid 25 24 24 21 23 25 30 2
Medicare 111 92 79 73 67 73 45 6
Private 61 46 44 42 43 39 45 (3)
Self Pay 39 37 39 38 33 27 20 (7)
Total 40 35 33 31 31 32 35 1
0
Encounters by Financial Class
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months
Medicaid 4030 4742 4393 69%
Medicare 734 749 702 11%
Private 731 843 801 13%
Self Pay 475 527 500 8%
Total - 0 - 0 - 0 5,970 6,861 6,396 3,205 100%
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 8% 8% 8% ERROR:#DIV/0! 0%
Collections per Encounter
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Change
Medicaid - 0 - 0 - 0 166.49 142.63 178.20 81.22 35.57
Medicare - 0 - 0 - 0 80.46 67.46 82.72 38.44 15.26
Private - 0 - 0 - 0 72.36 81.91 90.80 40.85 8.89
Subtotal - 0 - 0 - 0 142.47 125.66 154.96 70.52 29.30
Self Pay - 0 - 0 - 0 39.66 41.43 44.30 20.90 2.86
Total - 0 - 0 - 0 134.29 119.19 146.31 27.12
- 0
Charges per Encounter
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months Change
Medicaid - 0 - 0 - 0 165.14 156.37 169.24 81.79 12.87
Medicare - 0 - 0 - 0 145.93 133.51 143.08 70.42 9.57
Private - 0 - 0 - 0 192.65 185.15 195.02 95.47 9.88
Self Pay ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 183.64 157.66 170.76 ERROR:#DIV/0! 13.11
Total - 0 - 0 - 0 167.62 157.51 169.72 82.47 12.21
Collection Rate
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months Change
Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 935,796.89 779,881.43 188,468.67
Payments + Adjustments 871,612.03 1,111,751.56 1,231,794.76 889,274.56 1,057,357.58 1,301,304.83 1,077,182.55 243,947.25
Collection Rate 72% 73% 72% 76% 71% 72% 72% 1%
Adjustments 248,025.79 295,173.29 348,511.67 216,558.67 310,029.36 365,507.94 297,301.12

Charges and Payments

Charges 44063 44094 44124 44155 44185 44217 746777.78 1087222.73 961248.89999999991 1000697.0599999999 1080682.48 1085507.05 Payments 44063 44094 44124 44155 44185 44217 672715.89 747328.22 894178.66 801734.08 817764.7 935796.89

Days in A/R

44063 44094 44124 44155 44185 44217 39.929245029224091 35.236053712983974 33.270467156632009 30.966096480545986 30.848028358007461 32.059620275192742

Encounter Mix

Medicaid 44063 44094 44124 44155 44185 44217 4030 4742 4393 Medicare 44063 44094 44124 44155 44185 44217 734 749 702 Private 44063 44094 44124 44155 44185 44217 731 843 801 Self Pay 44063 44094 44124 44155 44185 44217 475 527 500

A/R balances

Medicaid 44032 44063 44094 44124 44155 44217 593553.96000000008 683460.02 704338.98 692523.43 758547.9 863926.74 Medicare 44032 44063 44094 44124 44155 44217 371840.26 398939.98 344587.87 358504.93 317098.09999999998 357569.65 Private 44032 44063 44094 44124 44155 44217 328027.26 327389.90999999997 291241.15999999997 301481.5 284577 282409.02 Self Pay 44032 44063 44094 44124 44155 44217 126496.28 128851.53 136010.62 146233.82 129603.8 107668.9

2021.01 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
January, 2021 206,670.95
Charges
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months Change
Medicaid 155,863.00 156,864.07 171,147.42 136,402.77 146,135.19 171,274.60 156,281.18 25,139.41
Medicare 23,973.00 6,457.00 21,214.00 25,883.53 16,194.12 16,066.00 18,297.94 (128.12)
Private 40,048.00 29,850.00 24,707.00 14,164.00 11,573.00 19,140.00 23,247.00 7,567.00
Subtotal 219,884.00 193,171.07 217,068.42 176,450.30 173,902.31 206,480.60 197,826.12 32,578.29
Self Pay 21,301.00 6,083.00 9,405.00 4,331.00 3,184.00 8,765.00 206,670.95 5,581.00
Total 241,185.00 199,254.07 226,473.42 180,781.30 177,086.31 215,245.60 206,670.95 38,159.29
9% 3% 4% 2% 2% 4% 4% -1%
Payments
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months Change
Medicaid 90,758.45 45,373.32 65,873.68 66,658.83 100,666.25 61,521.70 71,808.71 (39,144.55)
Medicare 1,727.03 2,423.45 8,232.49 19,779.68 10,637.65 7,117.11 8,319.57 (3,520.54)
Private 7,463.27 12,092.20 11,393.99 16,641.63 6,579.99 7,616.37 10,297.91 1,036.38
Subtotal 99,948.75 59,888.97 85,500.16 103,080.14 117,883.89 76,255.18 90,426.18 (41,628.71)
Self Pay 2,282.24 2,107.06 2,268.26 594.15 624.74 1,343.93 1,536.73 719.19
Total 102,230.99 61,996.03 87,768.42 103,674.29 118,508.63 77,599.11 91,962.91 (40,909.52)
0
A/R by Financial Class
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-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 461,051.22 496,867.80 496,130.79 436,727.79 321,275.39 328,328.24 423,396.87 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
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 % Change
0-30 Days 211,772.95 197,769.08 211,580.29 175,603.85 160,604.70 201,551.55 57% 40,946.85
31-60 Days 89,857.78 150,409.22 121,284.97 117,717.12 87,877.52 79,421.54 23% (8,455.98)
61-90 Days 74,592.25 29,271.79 79,289.58 68,835.04 35,870.23 20,280.66 6% (15,589.57)
91-120 Days 25,255.63 50,360.09 22,236.72 53,130.44 19,872.93 14,862.54 4% (5,010.39)
>120 Days 71,572.41 83,208.93 76,575.43 41,660.35 50,205.27 36,742.49 10% (13,462.78)
Total 473,051.02 511,019.11 510,966.99 456,946.80 354,430.65 352,858.78 (1,571.87)
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 498,607 - 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
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-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 40 47 47 43 34 34 0
0
Encounters by Financial Class
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 - 0 589 565 638 299 73.00
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0% 0% 0%
Collections per Encounter
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-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 - 0 - 0 - 0 176.02 209.75 121.63 84.57 (88.12)
Charges per Encounter
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-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 - 0 - 0 - 0 306.93 313.43 337.38 159.62 23.95
Collection Rate
Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Avg - 6 months Change
Payments 102,230.99 61,996.03 87,768.42 103,674.29 118,508.63 77,599.11 91,962.91 (40,909.52)
Payments + Adjustments 246,507.72 189,218.72 197,196.47 222,199.99 272,115.42 215,953.35 223,865.28 (56,162.07)
Collection Rate 41% 33% 45% 47% 44% 36% 41% -8%
adjustments 144,276.73 127,222.69 109,428.05 118,525.70 153,606.79 138,354.24 131,902.37

Charges and Payments

Charges 44063 44094 44124 44155 44185 44217 241185 199254.07 226473.42 180781.3 177086.31 215245.6 Payments 44063 44094 44124 44155 44185 44217 102230.99 61996.03 87768.42 103674.29000000001 118508.63 77599.109999999986

Days in A/R

44063 44094 44124 44155 44185 44217 40.143771876360468 47.381009137086771 46.867078122948328 43.276398615589713 34.440149970309918 34.492287796257926

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

44063 44094 44124 44155 44185 44217 473051.02 511019.10999999993 510966.99000000005 456946.79999999993 354430.65 352858.77999999991

2020.12 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
December, 2020 975,944.85
Charges
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months Change
Medicaid 624,625.88 496,279.19 712,466.37 669,391.69 665,527.68 741,521.02 651,635.31 75,993.34
Medicare 91,924.18 70,397.04 111,623.00 91,451.34 107,110.34 99,997.04 95,417.16 (7,113.30)
Private 167,994.92 112,149.32 185,016.90 124,075.32 140,829.43 156,079.25 147,690.86 15,249.82
Subtotal 884,544.98 678,825.55 1,009,106.27 884,918.35 913,467.45 997,597.31 894,743.32 84,129.86
Self Pay 94,495.20 67,952.23 78,116.46 76,330.55 87,229.61 83,085.17 81,201.54 (4,144.44)
Total 979,040.18 746,777.78 1,087,222.73 961,248.90 1,000,697.06 1,080,682.48 975,944.85 79,985.42
10% 9% 7% 8% 9% 8%
Payments
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months Change
Medicaid 768,264.13 544,729.40 627,298.22 744,067.76 670,942.32 676,352.11 671,942.32 5,409.79
Medicare 39,324.18 43,359.18 47,202.44 54,518.06 59,057.64 50,524.29 48,997.63 (8,533.35)
Private 55,938.55 61,865.87 53,975.53 76,366.62 52,894.39 69,054.10 61,682.51 16,159.71
Subtotal 863,526.86 649,954.45 728,476.19 874,952.44 782,894.35 795,930.50 782,622.47 13,036.15
Self Pay 19,756.23 22,761.44 18,852.03 19,226.22 18,839.73 21,834.20 20,211.64 2,994.47
Total 883,283.09 672,715.89 747,328.22 894,178.66 801,734.08 817,764.70 802,834.11 29,066.77
0
A/R by Financial Class
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months %
Medicaid 533,902.15 593,553.96 683,460.02 704,338.98 692,523.43 758,547.90 661,054.41 51%
Medicare 375,406.98 371,840.26 398,939.98 344,587.87 358,504.93 317,098.10 361,063.02 21%
Private 345,641.38 328,027.26 327,389.91 291,241.16 301,481.50 284,577.00 313,059.70 19%
Subtotal 1,254,950.51 1,293,421.48 1,409,789.91 1,340,168.01 1,352,509.86 1,360,223.00 1,335,177.13 91%
Self Pay 141,777.38 126,496.28 128,851.53 136,010.62 146,233.82 129,603.80 134,828.91 9%
Total 1,396,727.89 1,419,917.76 1,538,641.44 1,476,178.63 1,498,743.68 1,489,826.80 1,470,006.03 91%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 635,519.10 255,314.08 61,410.83 31,679.45 -146,166.86 837,756.60 692,523.43 145,233.17
Medicare 92,624.21 37,086.98 25,630.94 20,291.89 200,708.24 376,342.26 358,504.93 17,837.33
Private 125,252.00 26,839.28 28,744.17 20,451.69 143,619.58 344,906.72 301,481.50 43,425.22
Subtotal 853,395.31 319,240.34 115,785.94 72,423.03 198,160.96 1,559,005.58 1,352,509.86 206,495.72
Self Pay 58,942.00 51,170.10 32,494.05 34,534.67 169,165.80 346,306.62 146,233.82 200,072.80
Total 912,337.31 370,410.44 148,279.99 106,957.70 367,326.76 1,905,312.20 1,498,743.68 406,568.52
Pct of avg charges
CLC targets
A/R Distribution
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 % Change
0-30 Days 807,808.93 841,001.78 1,090,128.95 1,043,049.07 912,337.31 924,329.07 49% 11,991.76
31-60 Days 247,232.58 334,534.28 282,477.43 310,271.15 370,410.44 354,643.56 19% (15,766.88)
61-90 Days 94,442.21 118,690.38 98,558.85 120,581.42 148,279.99 165,459.22 9% 17,179.23
91-120 Days 117,547.17 96,828.51 93,619.99 76,397.64 106,957.70 117,807.69 6% 10,849.99
>120 Days 611,162.18 449,000.66 395,169.39 332,613.72 367,326.76 334,755.62 18% (32,571.14)
Total 1,878,193.07 1,840,055.61 1,959,954.61 1,882,913.00 1,905,312.20 1,896,995.16
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 18 22 23 24 21 23 ERROR:#REF!
Medicare 86 96 92 79 73 67 ERROR:#REF!
Private 43 49 44 44 42 43 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Goal Change
Medicaid 18 22 23 24 21 23 30 2
Medicare 86 96 92 79 73 67 45 (6)
Private 43 49 44 44 42 43 45 0
Self Pay 32 33 34 39 38 33 20 (5)
Total 30 35 34 33 31 31 35 (0)
0
Encounters by Financial Class
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months
Medicaid 4030 4742 69%
Medicare 734 749 11%
Private 731 843 12%
Self Pay 475 527 8%
Total - 0 - 0 - 0 - 0 5,970 6,861 2,139 100%
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 8% 8% ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Change
Medicaid - 0 - 0 - 0 - 0 166.49 142.63 51.52 (23.86)
Medicare - 0 - 0 - 0 - 0 80.46 67.46 24.65 (13.00)
Private - 0 - 0 - 0 - 0 72.36 81.91 25.71 9.56
Subtotal - 0 - 0 - 0 - 0 142.47 125.66 44.69 (16.81)
Self Pay - 0 - 0 - 0 - 0 39.66 41.43 13.52 1.77
Total - 0 - 0 - 0 - 0 134.29 119.19 (15.10)
- 0
Charges per Encounter
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months Change
Medicaid - 0 - 0 - 0 - 0 165.14 156.37 53.59 (8.77)
Medicare - 0 - 0 - 0 - 0 145.93 133.51 46.57 (12.42)
Private - 0 - 0 - 0 - 0 192.65 185.15 62.97 (7.51)
Self Pay ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 183.64 157.66 ERROR:#DIV/0! (25.98)
Total - 0 - 0 - 0 - 0 167.62 157.51 54.19 (10.11)
Collection Rate
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months Change
Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 817,764.70 760,209.40 70,436.48
Payments + Adjustments 901,121.24 1,064,604.06 1,178,456.38 1,021,227.56 963,886.89 1,127,794.06 1,042,848.36 163,907.17
Collection Rate 69% 77% 75% 66% 78% 73% 73% -5%
Adjustments 277,535.00 248,025.79 295,173.29 348,511.67 216,558.67 310,029.36

Charges and Payments

Charges 44032 44063 44094 44124 44155 44185 979040.18 746777.78 1087222.73 961248.89999999991 1000697.0599999999 1080682.48 Payments 44032 44063 44094 44124 44155 44185 883283.09000000008 672715.89 747328.22 894178.66 801734.08 817764.7

Days in A/R

44032 44063 44094 44124 44155 44185 29.959225667326546 34.555525149361642 34.458943684884986 33.270467156632009 30.966096480545986 30.848028358007461

Encounter Mix

Medicaid 44032 44063 44094 44124 44155 44185 4030 4742 Medicare 44032 44063 44094 44124 44155 44185 734 749 Private 44032 44063 44094 44124 44155 44185 731 843 Self Pay 44032 44063 44094 44124 44155 44185 475 527

A/R balances

Medicaid 44032 44063 44094 44124 44155 44185 533902.15 593553.96000000008 683460.02 704338.98 692523.43 758547.9 Medicare 44032 44063 44094 44124 44155 44185 375406.98 371840.26 398939.98 344587.87 358504.93 317098.09999999998 Private 44032 44063 44094 44124 44155 44185 345641.38 328027.26 327389.90999999997 291241.15999999997 301481.5 284577 Self Pay 44032 44063 44094 44124 44155 44185 141777.38 126496.28 128851.53 136010.62 146233.82 129603.8

2020.12 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
December, 2020 198,700.02
Charges
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months Change
Medicaid 126,124.29 155,863.00 156,864.07 171,147.42 136,402.77 146,135.19 148,756.12 9,732.42
Medicare 5,648.53 23,973.00 6,457.00 21,214.00 25,883.53 16,194.12 16,561.70 (9,689.41)
Private 20,038.20 40,048.00 29,850.00 24,707.00 14,164.00 11,573.00 23,396.70 (2,591.00)
Subtotal 151,811.02 219,884.00 193,171.07 217,068.42 176,450.30 173,902.31 188,714.52 (2,547.99)
Self Pay 15,609.00 21,301.00 6,083.00 9,405.00 4,331.00 3,184.00 198,700.02 (1,147.00)
Total 167,420.02 241,185.00 199,254.07 226,473.42 180,781.30 177,086.31 198,700.02 (3,694.99)
9% 9% 3% 4% 2% 2% 6% -2%
Payments
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months Change
Medicaid 76,676.79 90,758.45 45,373.32 65,873.68 66,658.83 100,666.25 74,334.55 34,007.42
Medicare 4,013.30 1,727.03 2,423.45 8,232.49 19,779.68 10,637.65 7,802.27 (9,142.03)
Private 13,512.33 7,463.27 12,092.20 11,393.99 16,641.63 6,579.99 11,280.57 (10,061.64)
Subtotal 94,202.42 99,948.75 59,888.97 85,500.16 103,080.14 117,883.89 93,417.39 14,803.75
Self Pay 940.17 2,282.24 2,107.06 2,268.26 594.15 624.74 1,469.44 30.59
Total 95,142.59 102,230.99 61,996.03 87,768.42 103,674.29 118,508.63 94,886.83 14,834.34
0
A/R by Financial Class
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 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 457,671.54 461,051.22 496,867.80 496,130.79 436,727.79 321,275.39 444,954.09 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
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 % Change
0-30 Days 157,536.97 211,772.95 197,769.08 211,580.29 175,603.85 160,604.70 45% (14,999.15)
31-60 Days 137,940.92 89,857.78 150,409.22 121,284.97 117,717.12 87,877.52 25% (29,839.60)
61-90 Days 59,362.34 74,592.25 29,271.79 79,289.58 68,835.04 35,870.23 10% (32,964.81)
91-120 Days 32,173.82 25,255.63 50,360.09 22,236.72 53,130.44 19,872.93 6% (33,257.51)
>120 Days 86,803.53 71,572.41 83,208.93 76,575.43 41,660.35 50,205.27 14% 8,544.92
Total 473,817.58 473,051.02 511,019.11 510,966.99 456,946.80 354,430.65 (102,516.15)
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 587,542 - 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
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 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 57 47 51 50 43 34 (9)
0
Encounters by Financial Class
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 - 0 - 0 589 565 192 (24.00)
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0% 0%
Collections per Encounter
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 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 - 0 - 0 - 0 - 0 176.02 209.75 64.29 33.73
Charges per Encounter
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 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 - 0 - 0 - 0 - 0 306.93 313.43 103.39 6.50
Collection Rate
Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Avg - 6 months Change
Payments 95,142.59 102,230.99 61,996.03 87,768.42 103,674.29 118,508.63 94,886.83 14,834.34
Payments + Adjustments 239,049.99 246,507.72 189,218.72 197,196.47 222,199.99 272,115.42 227,714.72 49,915.43
Collection Rate 40% 41% 33% 45% 47% 44% 41% -3%
adjustments 143,907.40 144,276.73 127,222.69 109,428.05 118,525.70 153,606.79 132,827.89

Charges and Payments

Charges 44032 44063 44094 44124 44155 44185 167420.02000000002 241185 199254.07 226473.42 180781.3 177086.31 Payments 44032 44063 44094 44124 44155 44185 95142.59 102230.99 61996.03 87768.42 103674.29000000001 118508.63

Days in A/R

44032 44063 44094 44124 44155 44185 57.407126937387766 47.390879436576661 51.496591751223129 49.950092871246248 43.276398615589713 34.440149970309918

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

44032 44063 44094 44124 44155 44185 473817.57999999996 473051.02 511019.10999999993 510966.99000000005 456946.79999999993 354430.65

2020.11 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
November, 2020 952,025.78
Charges
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months Change
Medicaid 637,579.67 624,625.88 496,279.19 712,466.37 669,391.69 665,527.68 634,311.75 (3,864.01)
Medicare 82,990.52 91,924.18 70,397.04 111,623.00 91,451.34 107,110.34 92,582.74 15,659.00
Private 140,487.01 167,994.92 112,149.32 185,016.90 124,075.32 140,829.43 145,092.15 16,754.11
Subtotal 861,057.20 884,544.98 678,825.55 1,009,106.27 884,918.35 913,467.45 871,986.63 28,549.10
Self Pay 76,110.84 94,495.20 67,952.23 78,116.46 76,330.55 87,229.61 80,039.15 10,899.06
Total 937,168.04 979,040.18 746,777.78 1,087,222.73 961,248.90 1,000,697.06 952,025.78 39,448.16
8% 10% 9% 7% 8% 9%
Payments
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months Change
Medicaid 703,955.63 768,264.13 544,729.40 627,298.22 744,067.76 670,942.32 676,542.91 (73,125.44)
Medicare 40,667.17 39,324.18 43,359.18 47,202.44 54,518.06 59,057.64 47,354.78 4,539.58
Private 52,331.98 55,938.55 61,865.87 53,975.53 76,366.62 52,894.39 58,895.49 (23,472.23)
Subtotal 796,954.78 863,526.86 649,954.45 728,476.19 874,952.44 782,894.35 782,793.18 (92,058.09)
Self Pay 19,623.49 19,756.23 22,761.44 18,852.03 19,226.22 18,839.73 19,843.19 (386.49)
Total 816,578.27 883,283.09 672,715.89 747,328.22 894,178.66 801,734.08 802,636.37 (184,502.67)
0
A/R by Financial Class
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months %
Medicaid 612,391.56 533,902.15 593,553.96 683,460.02 704,338.98 692,523.43 636,695.02 46%
Medicare 355,180.26 375,406.98 371,840.26 398,939.98 344,587.87 358,504.93 367,410.05 24%
Private 301,821.67 345,641.38 328,027.26 327,389.91 291,241.16 301,481.50 315,933.81 20%
Subtotal 1,269,393.49 1,254,950.51 1,293,421.48 1,409,789.91 1,340,168.01 1,352,509.86 1,320,038.88 90%
Self Pay 187,335.93 141,777.38 126,496.28 128,851.53 136,010.62 146,233.82 144,450.93 10%
Total 1,456,729.42 1,396,727.89 1,419,917.76 1,538,641.44 1,476,178.63 1,498,743.68 1,464,489.80 90%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 635,519.10 255,314.08 61,410.83 31,679.45 -146,166.86 837,756.60 692,523.43 145,233.17
Medicare 92,624.21 37,086.98 25,630.94 20,291.89 200,708.24 376,342.26 358,504.93 17,837.33
Private 125,252.00 26,839.28 28,744.17 20,451.69 143,619.58 344,906.72 301,481.50 43,425.22
Subtotal 853,395.31 319,240.34 115,785.94 72,423.03 198,160.96 1,559,005.58 1,352,509.86 206,495.72
Self Pay 58,942.00 51,170.10 32,494.05 34,534.67 169,165.80 346,306.62 146,233.82 200,072.80
Total 912,337.31 370,410.44 148,279.99 106,957.70 367,326.76 1,905,312.20 1,498,743.68 406,568.52
Pct of avg charges
CLC targets
A/R Distribution
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 % Change
0-30 Days 220,997.80 807,808.93 841,001.78 1,090,128.95 1,043,049.07 912,337.31 48% (130,711.76)
31-60 Days 325,038.76 247,232.58 334,534.28 282,477.43 310,271.15 370,410.44 19% 60,139.29
61-90 Days 150,223.38 94,442.21 118,690.38 98,558.85 120,581.42 148,279.99 8% 27,698.57
91-120 Days 157,700.70 117,547.17 96,828.51 93,619.99 76,397.64 106,957.70 6% 30,560.06
>120 Days 665,822.25 611,162.18 449,000.66 395,169.39 332,613.72 367,326.76 19% 34,713.04
Total 1,519,782.89 1,878,193.07 1,840,055.61 1,959,954.61 1,882,913.00 1,905,312.20
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 20 18 21 23 24 21 ERROR:#REF!
Medicare 90 90 95 92 79 73 ERROR:#REF!
Private 45 47 49 44 44 42 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Goal Change
Medicaid 20 18 21 23 24 21 30 (2)
Medicare 90 90 95 92 79 73 45 (7)
Private 45 47 49 44 44 42 45 (1)
Self Pay 52 35 33 34 39 38 20 (0)
Total 33 31 34 34 33 31 35 (2)
0
Encounters by Financial Class
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months
Medicaid 4030 68%
Medicare 734 12%
Private 731 12%
Self Pay 475 8%
Total - 0 - 0 - 0 - 0 - 0 5,970 995 100%
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 8% ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Change
Medicaid - 0 - 0 - 0 - 0 - 0 166.49 27.75 166.49
Medicare - 0 - 0 - 0 - 0 - 0 80.46 13.41 80.46
Private - 0 - 0 - 0 - 0 - 0 72.36 12.06 72.36
Subtotal - 0 - 0 - 0 - 0 - 0 142.47 23.75 142.47
Self Pay - 0 - 0 - 0 - 0 - 0 39.66 6.61 39.66
Total - 0 - 0 - 0 - 0 - 0 134.29 134.29
- 0
Charges per Encounter
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months Change
Medicaid - 0 - 0 - 0 - 0 - 0 165.14 27.52 165.14
Medicare - 0 - 0 - 0 - 0 - 0 145.93 24.32 145.93
Private - 0 - 0 - 0 - 0 - 0 192.65 32.11 192.65
Self Pay ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 183.64 ERROR:#DIV/0! ERROR:#DIV/0!
Total - 0 - 0 - 0 - 0 - 0 167.62 27.94 167.62
Collection Rate
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months Change
Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 801,734.08 757,537.63 54,405.86
Payments + Adjustments 872,865.24 1,094,113.27 1,131,308.88 967,889.18 1,095,839.89 1,018,292.75 1,030,051.53 (77,547.14)
Collection Rate 71% 75% 78% 70% 68% 79% 73% 11%
Adjustments 249,279.00 277,535.00 248,025.79 295,173.29 348,511.67 216,558.67

Charges and Payments

Charges 44002 44032 44063 44094 44124 44155 937168.04 979040.18 746777.78 1087222.73 961248.89999999991 1000697.0599999999 Payments 44002 44032 44063 44094 44124 44155 816578.27 883283.09000000008 672715.89 747328.22 894178.66 801734.08

Days in A/R

44002 44032 44063 44094 44124 44155 32.642297340826943 30.613881501875618 33.591922330797082 34.458943684884986 33.270467156632009 30.966096480545986

Encounter Mix

Medicaid 44002 44032 44063 44094 44124 44155 4030 Medicare 44002 44032 44063 44094 44124 44155 734 Private 44002 44032 44063 44094 44124 44155 731 Self Pay 44002 44032 44063 44094 44124 44155 475

A/R balances

Medicaid 44002 44032 44063 44094 44124 44155 612391.56000000006 533902.15 593553.96000000008 683460.02 704338.98 692523.43 Medicare 44002 44032 44063 44094 44124 44155 355180.26 375406.98 371840.26 398939.98 344587.87 358504.93 Private 44002 44032 44063 44094 44124 44155 301821.67 345641.38 328027.26 327389.90999999997 291241.15999999997 301481.5 Self Pay 44002 44032 44063 44094 44124 44155 187335.93 141777.38 126496.28 128851.53 136010.62 146233.82

2020.11 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
November, 2020 210,713.23
Charges
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months Change
Medicaid 162,939.22 126,124.29 155,863.00 156,864.07 171,147.42 136,402.77 151,556.80 (34,744.65)
Medicare 9,196.58 5,648.53 23,973.00 6,457.00 21,214.00 25,883.53 15,395.44 4,669.53
Private 54,089.79 20,038.20 40,048.00 29,850.00 24,707.00 14,164.00 30,482.83 (10,543.00)
Subtotal 226,225.59 151,811.02 219,884.00 193,171.07 217,068.42 176,450.30 197,435.07 (40,618.12)
Self Pay 22,940.00 15,609.00 21,301.00 6,083.00 9,405.00 4,331.00 210,713.23 (5,074.00)
Total 249,165.59 167,420.02 241,185.00 199,254.07 226,473.42 180,781.30 210,713.23 (45,692.12)
9% 9% 9% 3% 4% 2% 7% 1%
Payments
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months Change
Medicaid 108,854.86 76,676.79 90,758.45 45,373.32 65,873.68 66,658.83 75,699.32 785.15
Medicare 1,164.67 4,013.30 1,727.03 2,423.45 8,232.49 19,779.68 6,223.44 11,547.19
Private 8,621.17 13,512.33 7,463.27 12,092.20 11,393.99 16,641.63 11,620.77 5,247.64
Subtotal 118,640.70 94,202.42 99,948.75 59,888.97 85,500.16 103,080.14 93,543.52 17,579.98
Self Pay 2,212.17 940.17 2,282.24 2,107.06 2,268.26 594.15 1,734.01 (1,674.11)
Total 120,852.87 95,142.59 102,230.99 61,996.03 87,768.42 103,674.29 95,277.53 15,905.87
0
A/R by Financial Class
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 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 514,404.45 457,671.54 461,051.22 496,867.80 496,130.79 436,727.79 477,142.26 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
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 % Change
0-30 Days 233,696.44 157,536.97 211,772.95 197,769.08 211,580.29 175,603.85 38% (35,976.44)
31-60 Days 68,509.91 137,940.92 89,857.78 150,409.22 121,284.97 117,717.12 26% (3,567.85)
61-90 Days 50,162.89 59,362.34 74,592.25 29,271.79 79,289.58 68,835.04 15% (10,454.54)
91-120 Days 45,493.81 32,173.82 25,255.63 50,360.09 22,236.72 53,130.44 12% 30,893.72
>120 Days 135,217.27 86,803.53 71,572.41 83,208.93 76,575.43 41,660.35 9% (34,915.08)
Total 533,080.32 473,817.58 473,051.02 511,019.11 510,966.99 456,946.80 (54,020.19)
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 594,228 - 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
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 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 43 46 44 49 50 43 (7)
0
Encounters by Financial Class
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 - 0 - 0 - 0 589 98 589.00
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0%
Collections per Encounter
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 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 - 0 - 0 - 0 - 0 - 0 176.02 29.34 176.02
Charges per Encounter
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 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 - 0 - 0 - 0 - 0 - 0 306.93 51.15 306.93
Collection Rate
Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Avg - 6 months Change
Payments 120,852.87 95,142.59 102,230.99 61,996.03 87,768.42 103,674.29 95,277.53 15,905.87
Payments + Adjustments 307,230.89 239,049.99 246,507.72 189,218.72 197,196.47 222,199.99 233,567.30 25,003.52
Collection Rate 39% 40% 41% 33% 45% 47% 41% 2%
adjustments 186,378.02 143,907.40 144,276.73 127,222.69 109,428.05 118,525.70 138,289.77

Charges and Payments

Charges 44002 44032 44063 44094 44124 44155 249165.59 167420.02000000002 241185 199254.07 226473.42 180781.3 Payments 44002 44032 44063 44094 44124 44155 50426.959999999992 120852.87 95142.59 102230.99 61996.03 87768.42

Days in A/R

44002 44032 44063 44094 44124 44155 43.354676101142218 46.142267564162857 44.15859635321803 48.699758798078022 49.950092871246248 43.276398615589713

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

44002 44032 44063 44094 44124 44155 533080.31999999995 473817.57999999996 473051.02 511019.10999999993 510966.99000000005 456946.79999999993

2020.10 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
October, 2020 898,938.02
Charges
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months Change
Medicaid 466,798.64 637,579.67 624,625.88 496,279.19 712,466.37 669,391.69 601,190.24 (43,074.68)
Medicare 70,625.22 82,990.52 91,924.18 70,397.04 111,623.00 91,451.34 86,501.88 (20,171.66)
Private 84,569.77 140,487.01 167,994.92 112,149.32 185,016.90 124,075.32 135,715.54 (60,941.58)
Subtotal 621,993.63 861,057.20 884,544.98 678,825.55 1,009,106.27 884,918.35 823,407.66 (124,187.92)
Self Pay 60,176.85 76,110.84 94,495.20 67,952.23 78,116.46 76,330.55 75,530.36 (1,785.91)
Total 682,170.48 937,168.04 979,040.18 746,777.78 1,087,222.73 961,248.90 898,938.02 (125,973.83)
9% 8% 10% 9% 7% 8%
Payments
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months Change
Medicaid 528,492.10 703,955.63 768,264.13 544,729.40 627,298.22 744,067.76 652,801.21 116,769.54
Medicare 32,604.26 40,667.17 39,324.18 43,359.18 47,202.44 54,518.06 42,945.88 7,315.62
Private 46,309.36 52,331.98 55,938.55 61,865.87 53,975.53 76,366.62 57,797.99 22,391.09
Subtotal 607,405.72 796,954.78 863,526.86 649,954.45 728,476.19 874,952.44 753,545.07 146,476.25
Self Pay 16,180.52 19,623.49 19,756.23 22,761.44 18,852.03 19,226.22 19,399.99 374.19
Total 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 894,178.66 772,945.06 293,326.69
0
A/R by Financial Class
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months %
Medicaid 634,427.62 612,391.56 533,902.15 593,553.96 683,460.02 704,338.98 627,012.38 48%
Medicare 367,829.25 355,180.26 375,406.98 371,840.26 398,939.98 344,587.87 368,964.10 23%
Private 290,094.69 301,821.67 345,641.38 328,027.26 327,389.91 291,241.16 314,036.01 20%
Subtotal 1,292,351.56 1,269,393.49 1,254,950.51 1,293,421.48 1,409,789.91 1,340,168.01 1,310,012.49 91%
Self Pay 227,431.33 187,335.93 141,777.38 126,496.28 128,851.53 136,010.62 157,983.85 9%
Total 1,519,782.89 1,456,729.42 1,396,727.89 1,419,917.76 1,538,641.44 1,476,178.63 1,467,996.34 91%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 760,919.56 190,751.64 38,573.86 18,907.27 -157,624.83 851,527.50 704,338.98 147,188.52
Medicare 99,515.70 32,554.96 22,898.41 15,081.62 192,128.16 362,178.85 344,587.87 17,590.98
Private 113,918.66 50,347.97 21,594.02 13,894.51 134,797.71 334,552.87 291,241.16 43,311.71
Subtotal 974,353.92 273,654.57 83,066.29 47,883.40 169,301.04 1,548,259.22 1,340,168.01 208,091.21
Self Pay 68,695.15 36,616.58 37,515.13 28,514.24 163,312.68 334,653.78 136,010.62 198,643.16
Total 1,043,049.07 310,271.15 120,581.42 76,397.64 332,613.72 1,882,913.00 1,476,178.63 406,734.37
Pct of avg charges
CLC targets
A/R Distribution
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 % Change
0-30 Days 261,422.61 220,997.80 807,808.93 841,001.78 1,090,128.95 1,043,049.07 55% (47,079.88)
31-60 Days 320,387.69 325,038.76 247,232.58 334,534.28 282,477.43 310,271.15 16% 27,793.72
61-90 Days 234,748.17 150,223.38 94,442.21 118,690.38 98,558.85 120,581.42 6% 22,022.57
91-120 Days 162,440.58 157,700.70 117,547.17 96,828.51 93,619.99 76,397.64 4% (17,222.35)
>120 Days 998,281.52 665,822.25 611,162.18 449,000.66 395,169.39 332,613.72 18% (62,555.67)
Total 1,977,280.57 1,519,782.89 1,878,193.07 1,840,055.61 1,959,954.61 1,882,913.00
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 29 23 19 21 23 24 ERROR:#REF!
Medicare 109 97 96 95 92 79 ERROR:#REF!
Private 72 56 55 49 44 44 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Goal Change
Medicaid 29 23 19 21 23 24 30 0
Medicare 109 97 96 95 92 79 45 (12)
Private 72 56 55 49 44 44 45 (1)
Self Pay 79 58 39 33 34 39 20 5
Total 47 38 34 34 34 33 (1)
0
Encounters by Financial Class
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months
Medicaid ERROR:#DIV/0!
Medicare ERROR:#DIV/0!
Private ERROR:#DIV/0!
Self Pay ERROR:#DIV/0!
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0!
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0
- 0
Charges per Encounter
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months Change
Payments 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 894,178.66 772,945.06 146,850.44
Payments + Adjustments 1,098,604.13 1,065,857.27 1,160,818.09 920,741.68 1,042,501.51 1,242,690.33 1,088,535.50 200,188.82
Collection Rate 57% 77% 76% 73% 72% 72% 71% 0%
Adjustments 475,017.89 249,279.00 277,535.00 248,025.79 295,173.29 348,511.67

Charges and Payments

Charges 43971 44002 44032 44063 44094 44124 682170.47999999078 937168.04 979040.18 746777.78 1087222.73 961248.89999999991 Payments 43971 44002 44032 44063 44094 44124 623586.23999999976 816578.27 883283.09000000008 672715.89 747328.22 894178.66

Days in A/R

43971 44002 44032 44063 44094 44124 46.785138943567937 37.782486419207977 33.864908556247137 33.591922330797082 34.458943684884986 33.270467156632009

Encounter Mix

Medicaid 43922 43971 44002 44032 44063 44094 Medicare 43922 43971 44002 44032 44063 44094 Private 43922 43971 44002 44032 44063 44094 Self Pay 43922 43971 44002 44032 44063 44094

A/R balances

Medicaid 43971 44002 44032 44063 44094 44124 634427.62 612391.56000000006 533902.15 593553.96000000008 683460.02 704338.98 Medicare 43971 44002 44032 44063 44094 44124 367829.25 355180.26 375406.98 371840.26 398939.98 344587.87 Private 43971 44002 44032 44063 44094 44124 290094.69 301821.67 345641.38 328027.26 327389.90999999997 291241.15999999997 Self Pay 43971 44002 44032 44063 44094 44124 227431.33 187335.93 141777.38 126496.28 128851.53 136010.62

2020.10 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
October, 2020 201,417.15
Charges
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months Change
Medicaid 83,968.24 162,939.22 126,124.29 155,863.00 156,864.07 171,147.42 142,817.71 14,283.35
Medicare 3,000.00 9,196.58 5,648.53 23,973.00 6,457.00 21,214.00 11,581.52 14,757.00
Private 17,477.58 54,089.79 20,038.20 40,048.00 29,850.00 24,707.00 31,035.10 (5,143.00)
Subtotal 104,445.82 226,225.59 151,811.02 219,884.00 193,171.07 217,068.42 185,434.32 23,897.35
Self Pay 20,559.00 22,940.00 15,609.00 21,301.00 6,083.00 9,405.00 201,417.15 3,322.00
Total 125,004.82 249,165.59 167,420.02 241,185.00 199,254.07 226,473.42 201,417.15 27,219.35
16% 9% 9% 9% 3% 4% 9% -6%
Payments
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months Change
Medicaid 38,666.45 108,854.86 76,676.79 90,758.45 45,373.32 65,873.68 71,033.93 20,500.36
Medicare 1,917.67 1,164.67 4,013.30 1,727.03 2,423.45 8,232.49 3,246.44 5,809.04
Private 9,248.84 8,621.17 13,512.33 7,463.27 12,092.20 11,393.99 10,388.63 (698.21)
Subtotal 49,832.96 118,640.70 94,202.42 99,948.75 59,888.97 85,500.16 84,668.99 25,611.19
Self Pay 594.00 2,212.17 940.17 2,282.24 2,107.06 2,268.26 1,733.98 161.20
Total 50,426.96 120,852.87 95,142.59 102,230.99 61,996.03 87,768.42 86,402.98 25,772.39
0
A/R by Financial Class
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 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 606,796.95 514,404.45 457,671.54 461,051.22 496,867.80 496,130.79 505,487.13 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
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 % Change
0-30 Days 84,340.89 233,696.44 157,536.97 211,772.95 197,769.08 211,580.29 41% 13,811.21
31-60 Days 79,064.19 68,509.91 137,940.92 89,857.78 150,409.22 121,284.97 24% (29,124.25)
61-90 Days 133,604.27 50,162.89 59,362.34 74,592.25 29,271.79 79,289.58 16% 50,017.79
91-120 Days 82,759.16 45,493.81 32,173.82 25,255.63 50,360.09 22,236.72 4% (28,123.37)
>120 Days 250,069.01 135,217.27 86,803.53 71,572.41 83,208.93 76,575.43 15% (6,633.50)
Total 629,837.52 533,080.32 473,817.58 473,051.02 511,019.11 510,966.99 (52.12)
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 544,623 - 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
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 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 102 58 53 49 49 50 1
0
Encounters by Financial Class
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Charges per Encounter
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Avg - 6 months Change
Payments 50,426.96 120,852.87 95,142.59 102,230.99 61,996.03 87,768.42 86,402.98 25,772.39
Payments + Adjustments 165,066.25 307,230.89 239,049.99 246,507.72 189,218.72 197,196.47 224,045.01 7,977.75
Collection Rate 31% 39% 40% 41% 33% 45% 38% 12%
adjustments 114,639.29 186,378.02 143,907.40 144,276.73 127,222.69 109,428.05 137,642.03

Charges and Payments

Charges 43971 44002 44032 44063 44094 44124 125004.82 249165.59 167420.02000000002 241185 199254.07 226473.42 Payments 43971 44002 44032 44063 44094 44124 50426.959999999992 120852.87 95142.59 102230.99 61996.03 87768.42

Days in A/R

43971 44002 44032 44063 44094 44124 101.937956872383 57.741035428215717 53.238213644210809 49.475623525894264 48.699758798078022 49.950092871246248

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

43971 44002 44032 44063 44094 44124 629837.52 533080.31999999995 473817.57999999996 473051.02 511019.10999999993 510966.99000000005

2020.09 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
September, 2020 844,205.32
Charges
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months Change
Medicaid 421,382.33 466,798.64 637,579.67 624,625.88 496,279.19 712,466.37 559,855.35 216,187.18
Medicare 70,995.86 70,625.22 82,990.52 91,924.18 70,397.04 111,623.00 83,092.64 41,225.96
Private 86,492.87 84,569.77 140,487.01 167,994.92 112,149.32 185,016.90 129,451.80 72,867.58
Subtotal 578,871.06 621,993.63 861,057.20 884,544.98 678,825.55 1,009,106.27 772,399.78 330,280.72
Self Pay 53,981.64 60,176.85 76,110.84 94,495.20 67,952.23 78,116.46 71,805.54 10,164.23
Total 632,852.70 682,170.48 937,168.04 979,040.18 746,777.78 1,087,222.73 844,205.32 340,444.95
9% 9% 8% 10% 9% 7%
Payments
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months Change
Medicaid 864,813.92 528,492.10 703,955.63 768,264.13 544,729.40 627,298.22 672,925.57 82,568.82
Medicare 22,962.17 32,604.26 40,667.17 39,324.18 43,359.18 47,202.44 37,686.57 3,843.26
Private 26,862.69 46,309.36 52,331.98 55,938.55 61,865.87 53,975.53 49,547.33 (7,890.34)
Subtotal 914,638.78 607,405.72 796,954.78 863,526.86 649,954.45 728,476.19 760,159.46 78,521.74
Self Pay 12,021.40 16,180.52 19,623.49 19,756.23 22,761.44 18,852.03 18,199.19 (3,909.41)
Total 926,660.18 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 778,358.65
0
A/R by Financial Class
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months %
Medicaid 849,880.96 634,427.62 612,391.56 533,902.15 593,553.96 683,460.02 651,269.38 44%
Medicare 419,990.07 367,829.25 355,180.26 375,406.98 371,840.26 398,939.98 381,531.13 26%
Private 360,139.36 290,094.69 301,821.67 345,641.38 328,027.26 327,389.91 325,519.05 21%
Subtotal 1,630,010.39 1,292,351.56 1,269,393.49 1,254,950.51 1,293,421.48 1,409,789.91 1,358,319.56 92%
Self Pay 347,270.18 227,431.33 187,335.93 141,777.38 126,496.28 128,851.53 193,193.77 8%
Total 1,977,280.57 1,519,782.89 1,456,729.42 1,396,727.89 1,419,917.76 1,538,641.44 1,551,513.33 92%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 762,057.85 174,376.23 29,097.32 28,253.18 -147,122.98 846,661.60 683,460.02 163,201.58
Medicare 112,859.35 30,889.99 17,635.43 29,774.14 210,050.63 401,209.54 383,600.30 17,609.24
Private 160,877.99 36,429.32 16,718.87 11,343.84 160,963.22 386,333.24 342,729.59 43,603.65
Subtotal 1,035,795.19 241,695.54 63,451.62 69,371.16 223,890.87 1,634,204.38 1,409,789.91 224,414.47
Self Pay 54,333.76 40,781.89 35,107.23 24,248.83 171,278.52 325,750.23 128,851.53 196,898.70
Total 1,090,128.95 282,477.43 98,558.85 93,619.99 395,169.39 1,959,954.61 1,538,641.44 421,313.17
Pct of avg charges
CLC targets
A/R Distribution
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 % Change
0-30 Days 546,059.16 261,422.61 220,997.80 807,808.93 841,001.78 1,090,128.95 56% 249,127.17
31-60 Days 438,443.51 320,387.69 325,038.76 247,232.58 334,534.28 282,477.43 14% (52,056.85)
61-90 Days 189,841.14 234,748.17 150,223.38 94,442.21 118,690.38 98,558.85 5% (20,131.53)
91-120 Days 187,837.98 162,440.58 157,700.70 117,547.17 96,828.51 93,619.99 5% (3,208.52)
>120 Days 993,959.94 998,281.52 665,822.25 611,162.18 449,000.66 395,169.39 20% (53,831.27)
Total 2,356,141.73 1,977,280.57 1,519,782.89 1,878,193.07 1,840,055.61 1,959,954.61
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 42 30 25 19 21 23 ERROR:#REF!
Medicare 124 109 100 96 95 92 ERROR:#REF!
Private 87 71 61 55 49 44 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Goal Change
Medicaid 42 30 25 19 21 23 30 2
Medicare 124 109 100 96 95 92 45 (4)
Private 87 71 61 55 49 44 45 (5)
Self Pay 135 84 62 39 33 34 20 0
Total 66 49 41 34 34 34 1
0
Encounters by Financial Class
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months
Medicaid ERROR:#DIV/0!
Medicare ERROR:#DIV/0!
Private ERROR:#DIV/0!
Self Pay ERROR:#DIV/0!
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0!
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0
- 0
Charges per Encounter
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months Change
Payments 926,660.18 623,586.24 816,578.27 883,283.09 672,715.89 747,328.22 778,358.65 74,612.33
Payments + Adjustments 1,172,153.19 1,098,604.13 1,065,857.27 1,160,818.09 920,741.68 1,042,501.51 1,076,779.31 121,759.83
Collection Rate 79% 57% 77% 76% 73% 72% 72% -1%
Adjustments 245,493.01 475,017.89 249,279.00 277,535.00 248,025.79 295,173.29

Charges and Payments

Charges 43922 43971 44002 44032 44063 44094 632852.69999999157 682170.47999999078 937168.04 979040.18 746777.78 1087222.73 Payments 43922 43971 44002 44032 44063 44094 926660.18000001565 623586.23999999976 816578.27 883283.09000000008 672715.89 747328.22

Days in A/R

43922 43971 44002 44032 44063 44094 65.6122537993447 48.539738577080335 40.748739558624472 33.864908556247137 33.591922330797082 34.458943684884986

Encounter Mix

Medicaid 43922 43971 44002 44032 44063 44094 Medicare 43922 43971 44002 44032 44063 44094 Private 43922 43971 44002 44032 44063 44094 Self Pay 43922 43971 44002 44032 44063 44094

A/R balances

Medicaid 43922 43971 44002 44032 44063 44094 849880.96 634427.62 612391.56000000006 533902.15 593553.96000000008 683460.02 Medicare 43922 43971 44002 44032 44063 44094 419990.07 367829.25 355180.26 375406.98 371840.26 398939.98 Private 43922 43971 44002 44032 44063 44094 360139.36000000004 290094.69 301821.67 345641.38 328027.26 327389.90999999997 Self Pay 43922 43971 44002 44032 44063 44094 347270.18 227431.33 187335.93 141777.38 126496.28 128851.53

2020.09 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
September, 2020 181,611.52
Charges
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months Change
Medicaid 61,237.44 83,968.24 162,939.22 126,124.29 155,863.00 156,864.07 124,499.38 1,001.07
Medicare 2,369.00 3,000.00 9,196.58 5,648.53 23,973.00 6,457.00 8,440.69 (17,516.00)
Private 11,101.00 17,477.58 54,089.79 20,038.20 40,048.00 29,850.00 28,767.43 (10,198.00)
Subtotal 74,707.44 104,445.82 226,225.59 151,811.02 219,884.00 193,171.07 161,707.49 (26,712.93)
Self Pay 19,671.00 20,559.00 22,940.00 15,609.00 21,301.00 6,083.00 181,611.52 (15,218.00)
Total 94,378.44 125,004.82 249,165.59 167,420.02 241,185.00 212,515.23 181,611.52 (28,669.77)
21% 16% 9% 9% 9% 3% 13% -0%
Payments
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months Change
Medicaid 103,163.53 38,666.45 108,854.86 76,676.79 90,758.45 45,373.32
Medicare 1,967.74 1,917.67 1,164.67 4,013.30 1,727.03 2,423.45
Private 5,249.17 9,248.84 8,621.17 13,512.33 7,463.27 12,092.20
Subtotal 110,380.44 49,832.96 118,640.70 94,202.42 99,948.75 59,888.97
Self Pay 260.20 594.00 2,212.17 940.17 2,282.24 2,107.06
Total 110,640.64 50,426.96 120,852.87 95,142.59 102,230.99 61,996.03 90,215.01 (40,234.96)
0
A/R by Financial Class
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 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 783,611.14 606,796.95 514,404.45 457,671.54 461,051.22 496,867.80 553,400.52 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
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 % Change
0-30 Days 125,374.74 84,340.89 233,696.44 157,536.97 211,772.95 197,769.08 39% (14,003.87)
31-60 Days 164,817.51 79,064.19 68,509.91 137,940.92 89,857.78 150,409.22 29% 60,551.44
61-90 Days 140,272.59 133,604.27 50,162.89 59,362.34 74,592.25 29,271.79 6% (45,320.46)
91-120 Days 84,548.70 82,759.16 45,493.81 32,173.82 25,255.63 50,360.09 10% 25,104.46
>120 Days 312,192.94 250,069.01 135,217.27 86,803.53 71,572.41 83,208.93 16% 11,636.52
Total 827,206.48 629,837.52 533,080.32 473,817.58 473,051.02 511,019.11
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 560,621 - 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
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 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 174 116 69 60 49 48 (2)
0
Encounters by Financial Class
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Charges per Encounter
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Avg - 6 months Change
Payments 110,640.64 50,426.96 120,852.87 95,142.59 102,230.99 61,996.03 90,215.01 (40,234.96)
Payments + Adjustments 281,507.45 165,066.25 307,230.89 239,049.99 246,507.72 189,218.72 238,096.84 (57,289.00)
Collection Rate 39% 31% 39% 40% 41% 33% 37% -9%
adjustments 170,866.81 114,639.29 186,378.02 143,907.40 144,276.73 127,222.69 147,881.82

Charges and Payments

Charges 43922 43971 44002 44032 44063 44094 94378.44 125004.82 249165.59 167420.02000000002 241185 212515.23 Payments 43922 43971 44002 44032 44063 44094 110640.64 50426.959999999992 120852.87 95142.59 102230.99 61996.03

Days in A/R

43891 43922 43971 44002 44032 44063 118.8248210310018 124.97024609613077 98.434762026089899 67.777540018575536 60.450143353714779 49.475623525894264

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

827206.48 629837.52 533080.31999999995 473817.57999999996 473051.02 511019.10999999993

2020.08 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
August, 2020 810,695.70
Charges
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months Change
Medicaid 582,756.71 421,382.33 466,798.64 637,579.67 624,625.88 496,279.19 538,237.07 (128,346.69)
Medicare 88,902.09 70,995.86 70,625.22 82,990.52 91,924.18 70,397.04 79,305.82 (21,527.14)
Private 134,895.56 86,492.87 84,569.77 140,487.01 167,994.92 112,149.32 121,098.24 (55,845.60)
Subtotal 806,554.36 578,871.06 621,993.63 861,057.20 884,544.98 678,825.55 738,641.13 (205,719.43)
Self Pay 79,610.64 53,981.64 60,176.85 76,110.84 94,495.20 67,952.23 72,054.57 (26,542.97)
Total 886,165.00 632,852.70 682,170.48 937,168.04 979,040.18 746,777.78 810,695.70 (232,262.40)
9% 9% 9% 8% 10% 9%
Payments
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months Change
Medicaid 653,787.21 864,813.92 528,492.10 703,955.63 768,264.13 544,729.40 677,340.40 (223,534.73)
Medicare 64,535.01 22,962.17 32,604.26 40,667.17 39,324.18 43,359.18 40,575.33 4,035.00
Private 52,342.38 26,862.69 46,309.36 52,331.98 55,938.55 61,865.87 49,275.14 5,927.32
Subtotal 770,664.60 914,638.78 607,405.72 796,954.78 863,526.86 649,954.45 767,190.87 (213,572.41)
Self Pay 25,442.83 12,021.40 16,180.52 19,623.49 19,756.23 22,761.44 19,297.65 3,005.21
Total 796,107.43 926,660.18 623,586.24 816,578.27 883,283.09 672,715.89 786,488.52
0
A/R by Financial Class
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months %
Medicaid 1,177,258.30 849,880.96 634,427.62 612,391.56 533,902.15 593,553.96 733,569.09 42%
Medicare 432,628.94 419,990.07 367,829.25 355,180.26 375,406.98 371,840.26 387,145.96 26%
Private 388,342.25 360,139.36 290,094.69 301,821.67 345,641.38 328,027.26 335,677.77 23%
Subtotal 1,998,229.49 1,630,010.39 1,292,351.56 1,269,393.49 1,254,950.51 1,293,421.48 1,456,392.82 91%
Self Pay 357,912.24 347,270.18 227,431.33 187,335.93 141,777.38 126,496.28 231,370.56 9%
Total 2,356,141.73 1,977,280.57 1,519,782.89 1,456,729.42 1,396,727.89 1,419,917.76 1,687,763.38 91%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 591,282.13 233,161.28 43,317.05 24,895.83 (135,701.73) 756,954.56 593,553.96 163,400.60
Medicare 78,575.93 32,186.40 31,043.59 40,440.87 207,284.30 389,531.09 371,840.26 17,690.83
Private 120,831.62 26,930.99 16,185.34 7,945.17 200,446.13 372,339.25 328,027.26 44,311.99
Subtotal 790,689.68 292,278.67 90,545.98 73,281.87 272,028.70 1,518,824.90 1,293,421.48 225,403.42
Self Pay 50,312.10 42,255.61 28,144.40 23,546.64 176,971.96 321,230.71 126,496.28 194,734.43
Total 841,001.78 334,534.28 118,690.38 96,828.51 449,000.66 1,840,055.61 1,419,917.76 420,137.85
Pct of avg charges
CLC targets
A/R Distribution
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 % Change
0-30 Days 699,702.26 546,059.16 261,422.61 220,997.80 807,808.93 841,001.78 46% 33,192.85
31-60 Days 371,441.17 438,443.51 320,387.69 325,038.76 247,232.58 334,534.28 18% 87,301.70
61-90 Days 207,624.78 189,841.14 234,748.17 150,223.38 94,442.21 118,690.38 6% 24,248.17
91-120 Days 212,800.95 187,837.98 162,440.58 157,700.70 117,547.17 145,828.51 8% 28,281.34
>120 Days 1,332,600.51 993,959.94 998,281.52 665,822.25 611,162.18 400,000.66 22% (211,161.52)
Total 2,824,169.67 2,356,141.73 1,977,280.57 1,519,782.89 1,878,193.07 1,840,055.61
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 42 36 27 25 19 21 ERROR:#REF!
Medicare 102 110 101 100 96 95 ERROR:#REF!
Private 60 68 60 61 55 49 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Goal Change
Medicaid 42 36 27 25 19 21 30 2
Medicare 102 110 101 100 96 95 45 (1)
Private 60 68 60 61 55 49 45 (6)
Self Pay 94 109 74 62 39 33 20 (5)
Total 56 55 43 41 34 34 (0)
0
Encounters by Financial Class
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months
Medicaid ERROR:#DIV/0!
Medicare ERROR:#DIV/0!
Private ERROR:#DIV/0!
Self Pay ERROR:#DIV/0!
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0!
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0
- 0
Charges per Encounter
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months Change
Payments 796,107.43 926,660.18 623,586.24 816,578.27 883,283.09 672,715.89 786,488.52 (210,567.20)
Payments + Adjustments 1,585,229.68 1,172,153.19 1,098,604.13 1,065,857.27 1,160,818.09 920,741.68 1,167,234.01 (240,076.41)
Collection Rate 50% 79% 57% 77% 76% 73% 69% -3%
adjustments 789,122.25 245,493.01 475,017.89 249,279.00 277,535.00 248,025.79

Charges and Payments

Charges 43891 43922 43971 44002 44032 44063 886164.99999999453 632852.69999999157 682170.47999999078 937168.04 979040.18 746777.78 Payments 43891 43922 43971 44002 44032 44063 796107.43000000285 926660.18000001565 623586.23999999976 816578.27 883283.09000000008 672715.89

Days in A/R

43891 43922 43971 44002 44032 44063 55.834947588767669 54.670715120699874 43.49756324332116 40.748739558624472 33.864908556247137 33.591922330797082

Encounter Mix

Medicaid 43862 43891 43922 43971 44002 44032 Medicare 43862 43891 43922 43971 44002 44032 Private 43862 43891 43922 43971 44002 44032 Self Pay 43862 43891 43922 43971 44002 44032

A/R balances

Medicaid 43891 43922 43971 44002 44032 44063 1177258.3 849880.96 634427.62 612391.56000000006 533902.15 593553.96000000008 Medicare 43891 43922 43971 44002 44032 44063 432628.94 419990.07 367829.25 355180.26 375406.98 371840.26 Private 43891 43922 43971 44002 44032 44063 388342.25 360139.36000000004 290094.69 301821.67 345641.38 328027.26 Self Pay 43891 43922 43971 44002 44032 44063 357912.24 347270.18 227431.33 187335.93 141777.38 126496.28

2020.08 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
August, 2020 174,355.24
Charges
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months Change
Medicaid 113,885.59 61,237.44 83,968.24 162,939.22 126,124.29 155,863.00 117,336.30 29,738.71
Medicare 1,759.00 2,369.00 3,000.00 9,196.58 5,648.53 23,973.00 7,657.69 18,324.47
Private 25,641.00 11,101.00 17,477.58 54,089.79 20,038.20 40,048.00 28,065.93 20,009.80
Subtotal 141,285.59 74,707.44 104,445.82 226,225.59 151,811.02 219,884.00 153,059.91 68,072.98
Self Pay 27,692.00 19,671.00 20,559.00 22,940.00 15,609.00 21,301.00 174,355.24 5,692.00
Total 168,977.59 94,378.44 125,004.82 249,165.59 167,420.02 241,185.00 174,355.24 73,764.98
16% 21% 16% 9% 9% 9% 14% 0%
Payments
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months Change
Medicaid
Private
Subtotal
Self Pay
Total 123,492.66 112,384.86 52,305.94 124,511.47 93,259.50 91,518.46 99,578.82 (1,741.04)
0
A/R by Financial Class
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 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 956,130.09 783,611.14 606,796.95 514,404.45 457,671.54 461,051.22 629,944.23 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
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 % Change
0-30 Days 267,384.42 125,374.74 84,340.89 233,696.44 157,536.97 211,772.95 45% 54,235.98
31-60 Days 156,781.53 164,817.51 79,064.19 68,509.91 137,940.92 89,857.78 19% (48,083.14)
61-90 Days 115,455.19 140,272.59 133,604.27 50,162.89 59,362.34 74,592.25 16% 15,229.91
91-120 Days 135,789.79 84,548.70 82,759.16 45,493.81 32,173.82 25,255.63 5% (6,918.19)
>120 Days 338,291.04 312,192.94 250,069.01 135,217.27 86,803.53 71,572.41 15% (15,231.12)
Total 1,013,701.97 827,206.48 629,837.52 533,080.32 473,817.58 473,051.02
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 668,298 - 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
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 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 119 125 98 68 60 49 (11)
0
Encounters by Financial Class
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Charges per Encounter
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Avg - 6 months Change
Payments 123,492.66 112,384.86 52,305.94 124,511.47 93,259.50 91,518.46 99,578.82 (1,741.04)
Payments + Adjustments 324,078.80 283,251.67 166,945.23 310,889.49 237,166.90 235,795.19 259,687.88 (1,371.71)
Collection Rate 38% 40% 31% 40% 39% 39% 38% -1%
adjustments 200,586.14 170,866.81 114,639.29 186,378.02 143,907.40 144,276.73

Charges and Payments

Charges 43891 43922 43971 44002 44032 44063 168977.59 94378.44 125004.82 249165.59 167420.02000000002 241185 Payments 43891 43922 43971 44002 44032 44063 123492.66 112384.86 52305.94 124511.47 93259.5 91518.46

Days in A/R

43891 43922 43971 44002 44032 44063 118.8248210310018 124.97024609613077 98.434762026089899 67.777540018575536 60.450143353714779 49.475623525894264

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

Medicaid 43891 43922 43971 44002 44032 44063 Private 43891 43922 43971 44002 44032 44063 43891 43922 43971 44002 44032 44063

2020.07 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
July, 2020 883,506.16
Charges
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months Change
Medicaid 785,635.41 582,756.71 421,382.33 466,798.64 637,579.67 624,625.88 586,463.11 (12,953.79)
Medicare 126,091.63 88,902.09 70,995.86 70,625.22 82,990.52 91,924.18 88,588.25 8,933.66
Private 170,184.31 134,895.56 86,492.87 84,569.77 140,487.01 167,994.92 130,770.74 27,507.91
Subtotal 1,081,911.35 806,554.36 578,871.06 621,993.63 861,057.20 884,544.98 805,822.10 23,487.78
Self Pay 101,729.22 79,610.64 53,981.64 60,176.85 76,110.84 94,495.20 77,684.07 18,384.36
Total 1,183,640.57 886,165.00 632,852.70 682,170.48 937,168.04 979,040.18 883,506.16 41,872.14
9% 9% 9% 9% 8% 10%
Payments
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months Change
Medicaid 740,957.92 653,787.21 864,813.92 528,492.10 703,955.63 768,264.13 710,045.15 64,308.50
Medicare 48,503.19 64,535.01 22,962.17 32,604.26 40,667.17 39,324.18 41,432.66 (1,342.99)
Private 45,427.03 52,342.38 26,862.69 46,309.36 52,331.98 55,938.55 46,535.33 3,606.57
Subtotal 834,888.14 770,664.60 914,638.78 607,405.72 796,954.78 863,526.86 798,013.15 66,572.08
Self Pay 30,229.50 25,442.83 12,021.40 16,180.52 19,623.49 19,756.23 20,542.33 132.74
Total 865,117.64 796,107.43 926,660.18 623,586.24 816,578.27 883,283.09 818,555.48
0
A/R by Financial Class
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months %
Medicaid 1,354,612.78 1,177,258.30 849,880.96 634,427.62 612,391.56 533,902.15 860,412.23 38%
Medicare 540,052.98 432,628.94 419,990.07 367,829.25 355,180.26 375,406.98 415,181.41 27%
Private 445,010.99 388,342.25 360,139.36 290,094.69 301,821.67 345,641.38 355,175.06 25%
Subtotal 2,339,676.75 1,998,229.49 1,630,010.39 1,292,351.56 1,269,393.49 1,254,950.51 1,630,768.70 90%
Self Pay 484,492.92 357,912.24 347,270.18 227,431.33 187,335.93 141,777.38 291,036.66 10%
Total 2,824,169.67 2,356,141.73 1,977,280.57 1,519,782.89 1,456,729.42 1,396,727.89 1,921,805.36 90%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total Debits Total AR Credits
Medicaid 617,593.62 136,869.70 34,237.46 17,986.71 (104,379.06) 702,308.43 533,902.15 168,406.28
Medicare 82,063.78 43,595.51 43,748.43 12,049.69 211,692.17 393,149.58 375,406.98 17,742.60
Private 139,990.53 25,441.41 9,842.66 12,363.15 201,825.45 389,463.20 345,641.38 43,821.82
Subtotal 839,647.93 205,906.62 87,828.55 42,399.55 309,138.56 1,484,921.21 1,254,950.51 229,970.70
Self Pay 56,586.04 36,347.58 26,322.02 27,529.98 186,422.90 333,208.52 141,777.38 191,431.14
Total 896,233.97 242,254.20 114,150.57 69,929.53 495,561.46 1,818,129.73 1,396,727.89 421,401.84
Pct of avg charges
CLC targets
A/R Distribution
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 % Change
0-30 Days 699,702.26 546,059.16 261,422.61 220,997.80 807,808.93 896,233.97 49% 88,425.04
31-60 Days 371,441.17 438,443.51 320,387.69 325,038.76 247,232.58 242,254.20 13% (4,978.38)
61-90 Days 207,624.78 189,841.14 234,748.17 150,223.38 94,442.21 114,150.57 6% 19,708.36
91-120 Days 212,800.95 187,837.98 162,440.58 157,700.70 117,547.17 69,929.53 4% (47,617.64)
>120 Days 1,332,600.51 993,959.94 998,281.52 665,822.25 611,162.18 495,561.46 27% (115,600.72)
Total 2,824,169.67 2,356,141.73 1,977,280.57 1,519,782.89 1,878,193.07 1,818,129.73
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 36 36 30 27 25 19 ERROR:#REF!
Medicare 90 85 93 101 100 96 ERROR:#REF!
Private 55 53 58 60 61 55 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Goal Change
Medicaid 36 36 30 27 25 19 30 (6)
Medicare 90 85 93 101 100 96 45 (3)
Private 55 53 58 60 61 55 45 (6)
Self Pay 100 83 93 74 62 39 20 (23)
Total 50 48 46 43 41 34 (7)
0
Encounters by Financial Class
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months
Medicaid ERROR:#DIV/0!
Medicare ERROR:#DIV/0!
Private ERROR:#DIV/0!
Self Pay ERROR:#DIV/0!
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0!
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0
- 0
Charges per Encounter
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months Change
Payments 865,117.64 796,107.43 926,660.18 623,586.24 816,578.27 883,283.09 818,555.48 66,704.82
Payments + Adjustments 1,403,455.63 1,585,229.68 1,172,153.19 1,098,604.13 1,065,857.27 1,160,818.09 1,247,686.33 94,960.82
Collection Rate 62% 50% 79% 57% 77% 76% 67% -1%
adjustments 538,337.99 789,122.25 245,493.01 475,017.89 249,279.00 277,535.00

Charges and Payments

Charges 43862 43891 43922 43971 44002 44032 1183640.5699999947 886164.99999999453 632852.69999999157 682170.47999999078 937168.04 979040.18 Payments 43862 43891 43922 43971 44002 44032 865117.63999999815 796107.43000000285 926660.18000001565 623586.23999999976 816578.27 883283.09000000008

Days in A/R

43862 43891 43922 43971 44002 44032 50.106058015568244 47.810264932275985 46.091167830108567 43.49756324332116 40.748739558624472 33.864908556247137

Encounter Mix

Medicaid 43862 43891 43922 43971 44002 44032 Medicare 43862 43891 43922 43971 44002 44032 Private 43862 43891 43922 43971 44002 44032 Self Pay 43862 43891 43922 43971 44002 44032

A/R balances

Medicaid 43862 43891 43922 43971 44002 44032 1354612.78 1177258.3 849880.96 634427.62 612391.56000000006 533902.15 Medicare 43862 43891 43922 43971 44002 44032 540052.98 432628.94 419990.07 367829.25 355180.26 375406.98 Private 43862 43891 43922 43971 44002 44032 445010.99 388342.25 360139.36000000004 290094.69 301821.67 345641.38 Self Pay 43862 43891 43922 43971 44002 44032 484492.92000000004 357912.24 347270.18 227431.33 187335.93 141777.38

2020.07 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
July, 2020 187,597.69
Charges
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months Change
Medicaid 241,158.69 113,885.59 61,237.44 83,968.24 162,939.22 126,124.29 131,552.25 (36,814.93)
Medicare 7,291.00 1,759.00 2,369.00 3,000.00 9,196.58 5,648.53 4,877.35 (3,548.05)
Private 35,398.00 25,641.00 11,101.00 17,477.58 54,089.79 20,038.20 27,290.93 (34,051.59)
Subtotal 283,847.69 141,285.59 74,707.44 104,445.82 226,225.59 151,811.02 163,720.53 (74,414.57)
Self Pay 36,792.00 27,692.00 19,671.00 20,559.00 22,940.00 15,609.00 187,597.69 (7,331.00)
Total 320,639.69 168,977.59 94,378.44 125,004.82 249,165.59 167,420.02 187,597.69 (81,745.57)
11% 16% 21% 16% 9% 9% 15% -7%
Payments
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months Change
Medicaid
Private
Subtotal
Self Pay
Total 90,216.19 123,492.66 112,384.86 52,305.94 124,511.47 93,259.50 99,361.77 (31,251.97)
0
A/R by Financial Class
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 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 929,807.48 956,130.09 783,611.14 606,796.95 514,404.45 457,671.54 708,070.28 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
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 % Change
0-30 Days 284,215.27 267,384.42 125,374.74 84,340.89 233,696.44 157,536.97 33% (76,159.47)
31-60 Days 128,170.15 156,781.53 164,817.51 79,064.19 68,509.91 137,940.92 29% 69,431.01
61-90 Days 153,417.50 115,455.19 140,272.59 133,604.27 50,162.89 59,362.34 13% 9,199.45
91-120 Days 148,686.95 135,789.79 84,548.70 82,759.16 45,493.81 32,173.82 7% (13,319.99)
>120 Days 280,393.85 338,291.04 312,192.94 250,069.01 135,217.27 86,803.53 18% (48,413.74)
Total 994,883.72 1,013,701.97 827,206.48 629,837.52 533,080.32 473,817.58
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 879,907 - 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
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 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 61 82 85 72 68 60 (7)
0
Encounters by Financial Class
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Charges per Encounter
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Avg - 6 months Change
Payments 90,216.19 123,492.66 112,384.86 52,305.94 124,511.47 93,259.50 99,361.77 (31,251.97)
Payments + Adjustments 294,628.89 324,078.80 283,251.67 166,945.23 310,889.49 237,166.90 269,493.50 (73,722.59)
Collection Rate 31% 38% 40% 31% 40% 39% 37% -1%
adjustments 204,412.70 200,586.14 170,866.81 114,639.29 186,378.02 143,907.40

Charges and Payments

Charges 43862 43891 43922 43971 44002 44032 320639.69 168977.59 94378.44 125004.82 249165.59 167420.02000000002 Payments 43862 43891 43922 43971 44002 44032 90216.19 123492.66 112384.86 52305.94 124511.47 93259.5

Days in A/R

43862 43891 43922 43971 44002 44032 60.896881106640286 82.018068847570078 84.53401305749297 71.891262311309376 67.777540018575536 60.450143353714779

Encounter Mix

Medicaid 43862 43891 43922 43971 44002 44032 Private 43862 43891 43922 43971 44002 44032 43862 43891 43922 43971 44002 44032

A/R balances

Medicaid 43862 43891 43922 43971 44002 44032 Private 43862 43891 43922 43971 44002 44032 43862 43891 43922 43971 44002 44032

2020.05 Medical

Five Rivers
Medical Billing Assessment Avg Billed past 6 months
May, 2020 920,692.98
Charges
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months Change
Medicaid 759,796.10 931,891.26 785,635.41 582,756.71 421,382.33 466,798.64 658,043.41 45,416.31
Medicare 138,980.89 166,257.97 126,091.63 88,902.09 70,995.86 70,625.22 110,308.94 (370.64)
Private 156,085.36 188,520.60 170,184.31 134,895.56 86,492.87 84,569.77 136,791.41 (1,923.10)
Subtotal 1,054,862.35 1,286,669.83 1,081,911.35 806,554.36 578,871.06 621,993.63 905,143.76 43,122.57
Self Pay 93,295.32 110,113.42 101,729.22 79,610.64 53,981.64 60,176.85 83,151.18 6,195.21
Total 1,148,157.67 1,286,669.83 1,081,911.35 806,554.36 578,871.06 621,993.63 920,692.98 43,122.57
8% 9% 9% 10% 9% 10%
Payments
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months Change
Medicaid 775,968.33 805,909.21 740,957.92 653,787.21 864,813.92 528,492.10 744,155.67 (336,321.82)
Medicare 61,193.38 60,047.14 48,503.19 64,535.01 22,962.17 32,604.26 48,307.53 9,642.09
Private 58,380.82 59,738.20 45,427.03 52,342.38 26,862.69 46,309.36 48,176.75 19,446.67
Subtotal 895,542.53 925,694.55 834,888.14 770,664.60 914,638.78 607,405.72 824,805.72 (307,233.06)
Self Pay 29,875.69 28,981.31 30,229.50 25,442.83 12,021.40 16,180.52 28,632.33 4,159.12
Total 925,418.22 925,694.55 834,888.14 770,664.60 914,638.78 607,405.72 829,785.00
0
A/R by Financial Class
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months %
Medicaid 1,632,667.49 1,543,265.38 1,354,612.78 1,177,258.30 849,880.96 634,427.62 1,198,685.42 42%
Medicare 611,341.16 566,628.38 540,052.98 432,628.94 419,990.07 367,829.25 489,745.13 24%
Private 488,159.22 449,980.84 445,010.99 388,342.25 360,139.36 290,094.69 403,621.23 19%
Subtotal 2,732,167.87 2,559,874.60 2,339,676.75 1,998,229.49 1,630,010.39 1,292,351.56 2,092,051.78 85%
Self Pay 536,424.46 538,467.20 484,492.92 357,912.24 347,270.18 227,431.33 415,333.06 15%
Total 3,268,592.33 3,098,341.80 2,824,169.67 2,356,141.73 1,977,280.57 1,519,782.89 2,507,384.83 85%
Aging by Financial Class
0 to 30 31 to 60 61 to 90 91 to 120 Over 120 Total
Medicaid 277,236.05 237,959.08 46,570.46 64,746.94 7,915.09 634,427.62
Medicare 62,069.38 22,243.97 28,962.73 25,050.32 229,502.85 367,829.25
Private 23,906.26 25,969.34 28,232.40 24,370.26 187,616.43 290,094.69
Subtotal 363,211.69 286,172.39 103,765.59 114,167.52 425,034.37 1,292,351.56
Self Pay (142,213.89) 38,866.37 46,457.79 43,533.18 240,787.88 227,431.33
Total 220,997.80 325,038.76 150,223.38 157,700.70 665,822.25 1,519,782.89
Pct of avg charges
CLC targets
A/R Distribution
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 % Change
0-30 Days 624,513.00 792,410.65 699,702.26 546,059.16 261,422.61 220,997.80 15% (40,424.81)
31-60 Days 484,669.86 340,441.24 371,441.17 438,443.51 320,387.69 325,038.76 21% 4,651.07
61-90 Days 307,136.95 249,409.17 207,624.78 189,841.14 234,748.17 150,223.38 10% (84,524.79)
91-120 Days 256,478.24 227,762.88 212,800.95 187,837.98 162,440.58 157,700.70 10% (4,739.88)
>120 Days 1,595,794.28 1,488,317.86 1,332,600.51 993,959.94 998,281.52 665,822.25 44% (332,459.27)
Total 3,268,592.33 3,098,341.80 2,824,169.67 2,356,141.73 1,977,280.57 1,519,782.89
0 0
Days in A/R without Self Pay
Dec-99 Dec-99
Medicaid 45 38 34 32 30 27 ERROR:#REF!
Medicare 92 78 79 71 93 101 ERROR:#REF!
Private 66 55 54 50 58 60 ERROR:#REF!
Self Pay ERROR:#REF!
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#REF!
Days in A/R
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Goal Change
Medicaid 45 38 34 32 30 27 30 (3)
Medicare 92 78 79 71 93 101 45 8
Private 66 55 54 50 58 60 45 2
Self Pay 121 111 100 77 93 74 20 (19)
Total 60 53 51 47 50 48 (3)
0
Encounters by Financial Class
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months
Medicaid ERROR:#DIV/0!
Medicare ERROR:#DIV/0!
Private ERROR:#DIV/0!
Self Pay ERROR:#DIV/0!
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0!
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0
- 0
Charges per Encounter
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months Change
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Medicare - 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months Change
Payments 925,418.22 925,694.55 834,888.14 770,664.60 914,638.78 607,405.72 829,785.00 (307,233.06)
Payments + Adjustments 1,251,213.21 1,470,722.50 1,373,226.13 1,559,786.85 1,160,131.79 1,082,423.61 1,316,250.68 (77,708.18)
Collection Rate 74% 63% 61% 49% 79% 56% 64% -23%
adjustments 325,794.99 545,027.95 538,337.99 789,122.25 245,493.01 475,017.89

Charges and Payments

Charges 43800 43831 43862 43891 43922 43952 1148157.6699999957 1286669.829999995 1081911.3499999947 806554.35999999451 578871.05999999156 621993.62999999081 Payments 43800 43831 43862 43891 43922 43952 925418.21999999462 925694.55000000435 834888.13999999815 770664.60000000289 914638.78000001563 607405.71999999974

Days in A/R

43800 43831 43862 43891 43922 43952 59.783112305473047 53.445410650241335 50.593091156029601 46.749792920651423 50.487099055392008 47.696230674906232

Encounter Mix

Medicaid 43800 43831 43862 43891 43922 43952 Medicare 43800 43831 43862 43891 43922 43952 Private 43800 43831 43862 43891 43922 43952 Self Pay 43800 43831 43862 43891 43922 43952

A/R balances

Medicaid 43800 43831 43862 43891 43922 43952 1632667.4900000002 1543265.3800000001 1354612.78 1177258.3 849880.96 634427.62 Medicare 43800 43831 43862 43891 43922 43952 611341.15999999992 566628.38 540052.98 432628.94 419990.07 367829.25 Private 43800 43831 43862 43891 43922 43952 488159.22 449980.84 445010.99 388342.25 360139.36000000004 290094.69 Self Pay 43800 43831 43862 43891 43922 43952 536424.46 538467.19999999995 484492.92000000004 357912.24 347270.18 227431.33

2020.05 Dental

Five Rivers
Dental Billing Assessment Avg Billed past 6 months
May, 2020 - 0
Charges
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months Change
Medicaid ERROR:#DIV/0! - 0
Private ERROR:#DIV/0! - 0
Subtotal - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0! - 0
Self Pay - 0 - 0
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0! - 0
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Payments
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months Change
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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
0
A/R by Financial Class
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 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 - 0 - 0
A/R Distribution
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 % Change
0-30 Days ERROR:#DIV/0! - 0
31-60 Days ERROR:#DIV/0! - 0
61-90 Days ERROR:#DIV/0! - 0
91-120 Days ERROR:#DIV/0! - 0
>120 Days ERROR:#DIV/0! - 0
Total - 0 - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0! - 0
ERROR:#DIV/0! 0
Days in A/R without Self Pay
ERROR:#DIV/0! Dec-99
Medicaid - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 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-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0
0
Encounters by Financial Class
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months Change
Medicaid ERROR:#DIV/0! 0
Private ERROR:#DIV/0! 0
Self Pay ERROR:#DIV/0! 0
Total - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Collections per Encounter
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Charges per Encounter
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 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 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate
Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Avg - 6 months Change
Payments - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Payments + Adjustments - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0
Collection Rate 0% 0% 0% 0% 0% 0% 0% 0%
adjustments

Charges and Payments

Charges 43800 43831 43862 43891 43922 43952 0 0 0 0 0 0 Payments 43800 43831 43862 43891 43922 43952 0 0 0 0 0 0

Days in A/R

43800 43831 43862 43891 43922 43952 0 0 0 0 0 0

Encounter Mix

Medicaid 43800 43831 43862 43891 43922 43952 Private 43800 43831 43862 43891 43922 43952 43800 43831 43862 43891 43922 43952

A/R balances

Medicaid 43800 43831 43862 43891 43922 43952 Private 43800 43831 43862 43891 43922 43952 43800 43831 43862 43891 43922 43952

Data Sources

Medical- Run
My Reports>Five Rivers Aged AR- Month
Gen Trans> 2020 AR analysis- Month Pymnts
Gen Trans> 2020 AR analysis- Month Chrgs
Gen Trans> 2020 AR analysis- Month Adjstmnts
Dentrix-Run
Ledger>Aging/Credit Balance- Month
UDS patient related revenue

Incentive Markers

AR >120 Days Medical Quarter 1 Dental Quarter 1 Combined Quarter 1 1st Qtr
Jan-21 Feb-21 Mar-21 Jan-21 Feb-21 Mar-21 Jan-21 Feb-21 Mar-21
0-30 Days 995530.93 49% 967578.49 47% 943,094.43 49% 201,551.55 57% 159,926.56 54% 216,202.12 63% 1,197,082.48 50% 1,127,505.05 48% 1,159,296.55 51%
31-60 Days 399898.18 20% 452595.36 22% 322,844.09 17% 79,421.54 23% 85,940.37 29% 70,830.78 21% 479,319.72 20% 538,535.73 23% 393,674.87 17%
61-90 Days 190494.23 9% 163837.74 8% 202,677.51 10% 20,280.66 6% 14,556.09 5% 27,562.77 8% 210,774.89 9% 178,393.83 8% 230,240.28 10%
91-120 Days 147005.89 7% 145088.56 7% 126,096.21 7% 14,862.54 4% 9,219.67 3% 6,376.31 2% 161,868.43 7% 154,308.23 7% 132,472.52 6%
>120 Days 293273.62 14% 323369.44 16% 336,635.62 17% 36,742.49 10% 25,503.12 9% 23,762.79 7% 330,016.11 14% 348,872.56 15% 360,398.41 16% 15%
Total 2026202.85 100% 2052469.59 100% 1931347.86 100% 352858.78 100% 295145.81 100% 344734.77 100% 2379061.63 100% 2347615.4 100% 2276082.63 100%
Medical Quarter 2 Dental Quarter 2 Combined Quarter 2 2nd Qtr
Apr-21 May-21 Jun-21 Apr-21 May-21 Jun-21 Jan-21 Feb-21 Mar-21
0-30 Days 992,435.66 52% 958,392.09 53% 841001.78 46% 220,828.20 67% 203,379.83 64% 231,870.22 67% 1,213,263.86 54% 1,161,771.92 55% 1,072,872.00 49%
31-60 Days 275,801.57 14% 231,035.52 13% 334534.28 18% 68,594.91 21% 65,015.11 20% 39,610.73 11% 344,396.48 15% 296,050.63 14% 374,145.01 17%
61-90 Days 170,590.23 9% 149,784.45 8% 118690.38 6% 14,020.61 4% 18,789.57 6% 31,145.29 9% 184,610.84 8% 168,574.02 8% 149,835.67 7%
91-120 Days 145,105.88 8% 126,387.14 7% 145828.51 8% 11,453.60 3% 10,612.74 3% 20,078.24 6% 156,559.48 7% 136,999.88 6% 165,906.75 8%
>120 Days 321,770.70 17% 345,865.91 19% 400000.66 22% 16,046.25 5% 19,753.29 6% 24,005.14 7% 337,816.95 15% 365,619.20 17% 424,005.80 19% 17%
Total 1905704.04 100% 1811465.11 100% 1840055.61 100% 330943.57 100% 317550.54 100% 346709.62 100% 2236647.61 100% 2129015.65 100% 2186765.23 100%
Medical Quarter 3 Dental Quarter 3 Combined Quarter 3 3rd Qtr
Jul-21 Aug-21 Sep-21 Jul-21 Aug-21 Sep-21 Jul-21 Aug-21 Sep-21
0-30 Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0!
31-60 Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0!
61-90 Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0!
91-120 Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0!
>120 Days ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0! 0.00 ERROR:#DIV/0! ERROR:#DIV/0!
Total 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0! 0 ERROR:#DIV/0!
Billing Errors Jan-21 Feb-21 Mar-21 1st Qtr
2.86% 2.48% 2.18% 2.51%
Apr-21 May-21 Jun-21 2nd Qtr
2.15% 2.06% 1.87% 2.03%
Jul-21 Aug-21 Sep-21 3rd Qtr
ERROR:#DIV/0!
Oct-21 Nov-21 Dec-21 4th Qtr
ERROR:#DIV/0!