@sjpadgett
When this was first brought to my attention by the EU and I started investigating. It is not the same user every time. I figured out a couple of scripts to find the missing payments. That is what got their attention is that the staff knew they were recording the pre-payment and the system was not showing those pre-payments on the patient ledger.
The accountant had singled out a patient for me to find her pre-payment. I did find the pre-payment in the payment table and with that information, I looked for others. Below is the first list that I scraped out of the payment table. This should give you a glimpse into the payments being recorded. As you can see the third piece of information is the person recording the transaction. And the time of day is all over the place. Let me know if I can share any other information with you. BTW, the first number is the patient ID.
11154 - 2016-10-08 10:48:33 - Bertha39 - debit_card - 660.00
2760 - 2016-10-12 08:24:26 - DARCY42 - debit_card - 779.77
1876 - 2016-10-12 08:28:43 - DARCY42 - debit_card - 422.66
22725 - 2016-10-12 15:54:39 - DARCY42 - cash - 318.59
10381 - 2016-10-12 16:43:10 - Avril47 - debit_card - 240.07
2550 - 2016-10-18 08:35:17 - Avril47 - debit_card - 98.65
11414 - 2016-10-21 14:34:31 - Bertha39 - credit_card - 126.56
17185 - 2016-11-01 14:19:04 - Avril47 - debit_card - 4767.00
15672 - 2016-11-01 15:47:54 - Avril47 - debit_card - 346.00
22905 - 2016-11-01 17:30:29 - Mark43 - debit_card - 468.42
2639 - 2016-11-01 21:47:44 - DARCY42 - cash - 527.33
14407 - 2016-11-03 14:00:13 - Avril47 - check_payment - 545.52
14407 - 2016-11-03 19:09:02 - Mark43 - check_payment - 545.52
13213 - 2016-11-12 14:55:37 - Avril47 - debit_card - 560.00
21469 - 2016-11-27 01:27:07 - Sue-AnnM57 - debit_card - 496.88
21765 - 2016-12-30 17:50:07 - Avril47 - cash - 210.00
23389 - 2017-01-03 18:13:51 - Avril47 - debit_card - 793.18
18041 - 2017-01-19 16:04:21 - Avril47 - debit_card - 285.71
21604 - 2017-01-21 11:44:36 - MMaylor64 - debit_card - 181.25
23942 - 2017-01-24 12:44:11 - Avril47 - debit_card - 299.09
23885 - 2017-01-24 16:56:37 - DARCY42 - debit_card - 77.25
17014 - 2017-02-02 16:12:29 - Avril47 - debit_card - 811.40
17014 - 2017-02-02 16:22:03 - DARCY42 - credit_card - 275.75
17014 - 2017-02-02 16:26:00 - DARCY42 - credit_card - 220.60
23810 - 2017-02-06 11:42:09 - Mark43 - cash - 805.78
23667 - 2017-02-09 15:47:55 - DARCY42 - debit_card - 105.08
5898 - 2017-02-09 16:28:49 - Gloria23 - debit_card - 660.00
23152 - 2017-02-13 17:04:59 - DARCY42 - check_payment - 92.04
24289 - 2017-02-20 12:26:31 - Bertha39 - debit_card - 175.58
16333 - 2017-02-20 15:44:41 - DARCY42 - debit_card - 1215.76
24289 - 2017-02-21 09:20:42 - Bertha39 - debit_card - 175.58
14626 - 2017-02-21 10:32:07 - Avril47 - debit_card - 17.26
14626 - 2017-02-21 10:32:07 - Avril47 - debit_card - 17.45
14626 - 2017-02-21 10:32:07 - Avril47 - debit_card - 14.95
14626 - 2017-02-21 10:32:07 - Avril47 - debit_card - 39.37
19940 - 2017-02-25 12:25:11 - Bertha39 - debit_card - 114.55
23794 - 2017-03-02 12:41:20 - Gloria23 - debit_card - 660.00
11737 - 2017-03-10 17:47:10 - Mark43 - credit_card - 581.18
23857 - 2017-03-15 13:24:15 - Mark43 - debit_card - 534.62
14232 - 2017-03-27 15:51:26 - Avril47 - check_payment - 667.02
23993 - 2017-03-27 16:13:33 - Avril47 - credit_card - 165.77
23993 - 2017-03-27 16:14:48 - Avril47 - cash - 480.00
10682 - 2017-03-29 14:46:59 - MMaylor64 - debit_card - 660.00
19770 - 2017-03-29 15:44:34 - MMaylor64 - cash - 327.63
14232 - 2017-03-31 17:44:51 - Mark43 - credit_card - 578.25
24258 - 2017-03-31 18:23:40 - DARCY42 - check_payment - 141.45
24258 - 2017-03-31 18:23:40 - DARCY42 - check_payment - 15.82
24040 - 2017-04-12 12:39:35 - Mark43 - debit_card - 289.08
24294 - 2017-04-12 12:46:17 - Mark43 - debit_card - 121.56
24738 - 2017-04-13 10:59:50 - Avril47 - debit_card - 545.18
23694 - 2017-04-25 15:36:26 - MMaylor64 - check_payment - 869.64
18391 - 2017-04-26 13:58:35 - Mark43 - debit_card - 468.22
24709 - 2017-05-01 17:57:45 - Mark43 - check_payment - 468.36
24709 - 2017-05-02 10:36:44 - MMaylor64 - check_payment - 71.32
1759 - 2017-05-04 19:18:23 - Mark43 - debit_card - 526.67
19806 - 2017-05-09 11:08:14 - Jenzen65 - cash - -500.00
10114 - 2017-05-10 18:53:15 - DARCY42 - cash - 2341.12
13962 - 2017-05-12 12:25:25 - Avril47 - cash - 545.18
8924 - 2017-05-13 12:32:05 - Avril47 - debit_card - 238.04
8924 - 2017-05-13 12:33:23 - Avril47 - debit_card - 261.96
23152 - 2017-05-17 12:10:10 - DARCY42 - check_payment - 5973.32
15321 - 2017-05-18 17:28:33 - DARCY42 - debit_card - 411.78
25222 - 2017-05-19 16:40:48 - Gloria23 - credit_card - 310.20
24294 - 2017-05-19 18:39:47 - Jenzen65 - debit_card - -121.56
20015 - 2017-05-22 19:41:27 - Jenzen65 - debit_card - -121.56
24294 - 2017-05-22 19:43:09 - Jenzen65 - debit_card - -121.56
24294 - 2017-05-22 19:48:05 - Jenzen65 - debit_card - -121.56
15026 - 2017-05-23 11:30:08 - Jenzen65 - debit_card - -700.00
1073 - 2017-05-25 13:08:39 - Avril47 - cash - 29.34
12685 - 2017-05-29 12:17:35 - Avril47 - cash - 1675.51
18823 - 2017-05-29 13:26:20 - BConnor62 - debit_card - 1600.00
24738 - 2017-05-30 15:00:41 - Jenzen65 - debit_card - -545.18
23857 - 2017-05-30 15:04:22 - Jenzen65 - debit_card - -534.62
3691 - 2017-05-30 17:05:32 - Avril47 - cash - 685.00
12685 - 2017-06-01 17:48:21 - Avril47 - check_payment - 1024.49
23334 - 2017-06-06 13:31:44 - Avril47 - debit_card - 1033.33
17727 - 2017-06-06 13:57:14 - Avril47 - debit_card - 1033.33
24286 - 2017-06-08 17:00:41 - Gloria23 - credit_card - 264.00
11910 - 2017-06-13 13:26:41 - MMaylor64 - debit_card - 971.80
24788 - 2017-06-14 15:40:25 - Avril47 - debit_card - 878.00
21642 - 2017-06-17 12:41:49 - ErikaSB48 - debit_card - 660.00
21950 - 2017-06-20 13:20:00 - Sue-AnnM57 - debit_card - 254.47
16804 - 2017-06-28 10:21:32 - Gloria23 - debit_card - 941.00
16613 - 2017-06-29 14:09:50 - Sue-AnnM57 - debit_card - 128.66
16613 - 2017-06-29 14:09:50 - Sue-AnnM57 - debit_card - -1.98
16613 - 2017-06-29 14:09:50 - Sue-AnnM57 - debit_card - 22.50
16613 - 2017-06-29 14:09:50 - Sue-AnnM57 - debit_card - 301.87
20868 - 2017-07-06 13:16:47 - ErikaSB48 - credit_card - 205.51
25572 - 2017-07-11 13:04:45 - Avril47 - cash - 245.00