1. what is the total % of revenue collections?

2. Of uncollected, what % are due to missing insurance payments?

3. Of uncollected, what % are due to lower-than-expected insurance payments?

4. Of uncollected, what % are due to missing patient payments?

5. What % of insurance payments were overpayments?

6. How would you approach improving these revenue collections going forward?

Session Date Visit ID Expected Insurance Payment Allowed Collected from Insurance Collected from Patient EOB- Coins. EOB- Copay EOB- Deduct. Note 66 66 66 0 99 0 99 99 99 68 99 68 0 0 99 99 99 99 99 99 0 0 0 Awaiting EOB 1 14 2/9/2020 21051 15 2/9/2020 21273 16 2/9/2020 21073 17 2/9/2020 18289 18 2/9/2020 16502 19 2/9/2020 21907 20 2/9/2020 21275 21 2/9/2020 21102 22 2/9/2020 19493 23 2/9/2020 15130 24 2/9/2020 21642 25 2/9/2020 20658 26 2/9/2020 21034 27 2/9/2020 21101 28 2/9/2020 19515 29 2/9/2020 22537 102 99 99 19.8 79.2 53 20 99 10.95 99 0 19.8 20 10.95 73 60 40 25 73 99 73 73 73 102 99 99 80 67 104.68 102 62.05 0 42 59 74 64 22 104.68 99 60 40 25 99 80 16 16 45 45 66 102 0 Session Date Visit ID Expected Insurance Payment Allowed Collected from Insurance Collected from Patient EOB- Coins. EOB- Copay EOB- Deduct. Note 66 66 66 0 99 0 99 99 99 68 99 68 0 0 99 99 99 99 99 99 0 0 0 Awaiting EOB 1 14 2/9/2020 21051 15 2/9/2020 21273 16 2/9/2020 21073 17 2/9/2020 18289 18 2/9/2020 16502 19 2/9/2020 21907 20 2/9/2020 21275 21 2/9/2020 21102 22 2/9/2020 19493 23 2/9/2020 15130 24 2/9/2020 21642 25 2/9/2020 20658 26 2/9/2020 21034 27 2/9/2020 21101 28 2/9/2020 19515 29 2/9/2020 22537 102 99 99 19.8 79.2 53 20 99 10.95 99 0 19.8 20 10.95 73 60 40 25 73 99 73 73 73 102 99 99 80 67 104.68 102 62.05 0 42 59 74 64 22 104.68 99 60 40 25 99 80 16 16 45 45 66 102 0