Spreadsheet: 787838d1658082336-cbbox-that-will-dynamically-show-current-year-month-and-year-2022-07-17-oeldere-pb21uk-payments_to_qi-copy
Sheet: QryPaymentstoQi

Payment Date | Student_FK | English_Name | InvoiceNo | Amount Paid Yuan | MonthYear | Month | Year | YearMonth
2021-08-11 00:00:00 | 15 | [NAME] | 38 | 500
2021-08-11 00:00:00 | 43 | [NAME] | 15 | 500
2021-08-13 00:00:00 | 42 | Yulia | 16 | 1575
2021-08-13 00:00:00 | 81 | [NAME] | 4 | 600
2021-08-15 00:00:00 | 83 | [NAME] | 5 | 300
2021-08-15 00:00:00 | 52 | [NAME] | 14 | 500
2021-08-15 00:00:00 | 77 | [NAME] | 9 | 500
2021-08-17 00:00:00 | 89 | Ella | 1 | 300
2021-08-17 00:00:00 | 3 | Fay | 52 | 500
2021-08-18 00:00:00 | 76 | Moody | 6 | 1500
2021-08-18 00:00:00 | 13 | [NAME] | 22 | 1000
2021-08-20 00:00:00 | 41 | [NAME] | 24 | 750
2021-08-21 00:00:00 | 86 | [NAME] | 2 | 500
2021-08-21 00:00:00 | 85 | [NAME] | 2 | 500
2021-08-21 00:00:00 | 84 | Mark | 2 | 500
2021-08-21 00:00:00 | 83 | [NAME] | 6 | 300
2021-08-22 00:00:00 | 37 | [NAME] | 17 | 600
2021-08-25 00:00:00 | 89 | Ella | 2 | 1500
2021-08-26 00:00:00 | 82 | [NAME] | 8 | 600
2021-09-01 00:00:00 | 7 | Ray | 37 | 500
2021-09-04 00:00:00 | 83 | [NAME] | 7 | 300
2021-09-04 00:00:00 | 81 | [NAME] | 5 | 600
2021-09-04 00:00:00 | 72 | Anna | 6 | 1500
2021-09-06 00:00:00 | 75 | Jake | 10 | 500
2021-09-08 00:00:00 | 91 | Eva | 1 | 450
2021-09-09 00:00:00 | 4 | Flower | 38 | 500
2021-09-13 00:00:00 | 14 | [NAME] | 37 | 500
2021-09-15 00:00:00 | 15 | [NAME] | 39 | 500
2021-09-16 00:00:00 | 79 | Seven Nine | 5 | 1500
2021-09-17 00:00:00 | 77 | [NAME] | 10 | 500
2021-09-19 00:00:00 | 83 | [NAME] | 8 | 300
2021-09-19 00:00:00 | 82 | [NAME] | 9 | 600
2021-09-19 00:00:00 | 8 | [NAME] | 31 | 1500
2021-09-25 00:00:00 | 86 | [NAME] | 3 | 500
2021-09-25 00:00:00 | 84 | Mark | 3 | 500
2021-09-25 00:00:00 | 85 | [NAME] | 3 | 500
2021-09-28 00:00:00 | 41 | [NAME] | 25 | 750
2021-09-28 00:00:00 | 91 | Eva | 2 | 750
2021-10-02 00:00:00 | 66 | [NAME] | 11 | 1500
2021-10-04 00:00:00 | 3 | Fay | 53 | 500
2021-10-04 00:00:00 | 7 | Ray | 38 | 500
2021-10-06 00:00:00 | 68 | [NAME] | 8 | 1500
2021-10-10 00:00:00 | 44 | [NAME] | 15 | 750
2021-10-12 00:00:00 | 75 | Jake | 11 | 500
2021-10-13 00:00:00 | 14 | [NAME] | 38 | 500
2021-10-16 00:00:00 | 83 | [NAME] | 9 | 300
2021-10-17 00:00:00 | 4 | Flower | 39 | 500
2021-10-20 00:00:00 | 15 | [NAME] | 40 | 500
2021-10-21 00:00:00 | 82 | [NAME] | 10 | 600
2021-10-22 00:00:00 | 42 | Yulia | 17 | 1500
2021-10-23 00:00:00 | 92 | Pink | 1 | 1000
2021-10-23 00:00:00 | 81 | [NAME] | 6 | 600
2021-10-26 00:00:00 | 76 | Moody | 7 | 1500
2021-10-29 00:00:00 | 88 | Leo | 2 | 750
2021-10-29 00:00:00 | 87 | [NAME] | 2 | 750
2021-10-30 00:00:00 | 86 | [NAME] | 4 | 500
2021-10-30 00:00:00 | 85 | [NAME] | 4 | 500
2021-10-30 00:00:00 | 84 | Mark | 4 | 500
2021-10-31 00:00:00 | 77 | [NAME] | 11 | 500
2021-10-31 00:00:00 | 43 | [NAME] | 16 | 500
2021-11-03 00:00:00 | 56 | Little Bear | 10 | 750
2021-11-03 00:00:00 | 51 | Panda | 17 | 750
2021-11-04 00:00:00 | 3 | Fay | 54 | 500
2021-11-07 00:00:00 | 60 | [NAME] | 11 | 500
2021-11-07 00:00:00 | 83 | [NAME] | 10 | 300
2021-11-12 00:00:00 | 37 | [NAME] | 18 | 600
2021-11-12 00:00:00 | 41 | [NAME] | 26 | 750
2021-11-12 00:00:00 | 91 | Eva | 3 | 750
2021-11-14 00:00:00 | 52 | [NAME] | 15 | 500
2021-11-14 00:00:00 | 83 | [NAME] | 11 | 300
2021-11-15 00:00:00 | 7 | Ray | 39 | 500
2021-11-16 00:00:00 | 92 | Pink | 2 | 1000
2021-11-16 00:00:00 | 94 | [NAME] | 1 | 1500
2021-11-21 00:00:00 | 73 | [NAME] | 6 | 1500
2021-11-21 00:00:00 | 82 | [NAME] | 11 | 600
2021-11-22 00:00:00 | 14 | [NAME] | 39 | 500
2021-11-25 00:00:00 | 75 | Jake | 12 | 500
2021-11-25 00:00:00 | 79 | Seven Nine | 6 | 1500
2021-11-27 00:00:00 | 81 | [NAME] | 7 | 600
2021-12-01 00:00:00 | 15 | [NAME] | 41 | 500
2021-12-02 00:00:00 | 13 | [NAME] | 23 | 1000
2021-12-04 00:00:00 | 86 | [NAME] | 5 | 500
2021-12-04 00:00:00 | 84 | Mark | 5 | 500
2021-12-04 00:00:00 | 85 | [NAME] | 5 | 500
2021-12-04 00:00:00 | 72 | Anna | 7 | 1500
2021-12-05 00:00:00 | 4 | Flower | 40 | 500
2021-12-05 00:00:00 | 83 | [NAME] | 12 | 300
2021-12-12 00:00:00 | 44 | [NAME] | 16 | 750
2021-12-12 00:00:00 | 8 | [NAME] | 32 | 1500
2021-12-14 00:00:00 | 92 | Pink | 3 | 1000
2021-12-17 00:00:00 | 89 | Ella | 3 | 50
2021-12-19 00:00:00 | 82 | [NAME] | 12 | 600
2021-12-20 00:00:00 | 41 | [NAME] | 27 | 150
2021-12-21 00:00:00 | 66 | [NAME] | 11 | -150
2021-12-23 00:00:00 | 3 | Fay | 55 | 500
2021-12-30 00:00:00 | 7 | Ray | 40 | 500
2021-12-31 00:00:00 | 42 | Yulia | 18 | 1500
2022-01-01 00:00:00 | 41 | [NAME] | 28 | 1500
2022-01-01 00:00:00 | 81 | [NAME] | 8 | 600
2022-01-05 00:00:00 | 14 | [NAME] | 40 | 500
2022-01-07 00:00:00 | 75 | Jake | 13 | 500
2022-01-07 00:00:00 | 87 | [NAME] | 3 | 750
2022-01-07 00:00:00 | 88 | Leo | 3 | 750
2022-01-09 00:00:00 | 83 | [NAME] | 13 | 300
2022-01-12 00:00:00 | 68 | [NAME] | 9 | 1500
2022-01-13 00:00:00 | 93 | [NAME] | 2 | 1500
2022-01-16 00:00:00 | 82 | [NAME] | 13 | 600
2022-01-18 00:00:00 | 84 | Mark | 6 | 500
2022-01-18 00:00:00 | 85 | [NAME] | 6 | 500
2022-01-18 00:00:00 | 86 | [NAME] | 6 | 500
2022-01-19 00:00:00 | 15 | [NAME] | 42 | 500
2022-01-22 00:00:00 | 77 | [NAME] | 12 | 500
2022-01-23 00:00:00 | 43 | [NAME] | 17 | 500
2022-01-23 00:00:00 | 52 | [NAME] | 16 | 500
2022-01-23 00:00:00 | 83 | [NAME] | 14 | 300
2022-02-07 00:00:00 | 4 | Flower | 41 | 500
2022-02-08 00:00:00 | 76 | Moody | 8 | 1500
2022-02-09 00:00:00 | 92 | Pink | 4 | -400
2022-02-12 00:00:00 | 60 | [NAME] | 12 | 500
2022-02-12 00:00:00 | 81 | [NAME] | 9 | 600
2022-02-15 00:00:00 | 56 | Little Bear | 11 | 750
2022-02-15 00:00:00 | 51 | Panda | 18 | 750
2022-02-17 00:00:00 | 72 | Anna | 8 | 1500
2022-02-20 00:00:00 | 83 | [NAME] | 15 | 300
2022-02-20 00:00:00 | 95 | [NAME] | 1 | 1500
2022-02-23 00:00:00 | 75 | Jake | 14 | 500
2022-02-24 00:00:00 | 3 | Fay | 56 | 500
2022-02-24 00:00:00 | 79 | Seven Nine | 7 | 1500
2022-02-25 00:00:00 | 89 | Ella | 4 | -100
2022-02-26 00:00:00 | 84 | Mark | 7 | 500
2022-02-26 00:00:00 | 85 | [NAME] | 7 | 500
2022-02-26 00:00:00 | 86 | [NAME] | 7 | 500
2022-02-27 00:00:00 | 73 | [NAME] | 7 | 1500
2022-02-27 00:00:00 | 83 | [NAME] | 16 | 300
2022-03-02 00:00:00 | 14 | [NAME] | 41 | 500
2022-03-06 00:00:00 | 82 | [NAME] | 14 | 600
2022-03-06 00:00:00 | 8 | [NAME] | 33 | 1500
2022-03-09 00:00:00 | 77 | [NAME] | 13 | 500
2022-03-09 00:00:00 | 15 | [NAME] | 43 | 500
2022-03-11 00:00:00 | 41 | [NAME] | 29 | 1500
2022-03-11 00:00:00 | 42 | Yulia | 19 | 1500
2022-03-12 00:00:00 | 81 | [NAME] | 10 | 600
2022-03-12 00:00:00 | 94 | [NAME] | 2 | 2000
2022-03-13 00:00:00 | 83 | [NAME] | 17 | 300
2022-03-14 00:00:00 | 7 | Ray | 41 | 500
2022-03-17 00:00:00 | 93 | [NAME] | 3 | 1500
2022-03-20 00:00:00 | 44 | [NAME] | 17 | 750
2022-03-24 00:00:00 | 4 | Flower | 42 | 500
2022-03-27 00:00:00 | 83 | [NAME] | 18 | 300
2022-04-02 00:00:00 | 85 | [NAME] | 8 | 500
2022-04-02 00:00:00 | 86 | [NAME] | 8 | 500
2022-04-02 00:00:00 | 84 | Mark | 8 | 500
2022-04-10 00:00:00 | 82 | [NAME] | 15 | 600
2022-04-10 00:00:00 | 83 | [NAME] | 19 | 300
2022-04-10 00:00:00 | 68 | [NAME] | 10 | 1500
2022-04-11 00:00:00 | 75 | Jake | 15 | 500
2022-04-18 00:00:00 | 14 | [NAME] | 42 | 500
2022-04-18 00:00:00 | 52 | [NAME] | 17 | 500
2022-04-19 00:00:00 | 76 | Moody | 9 | 1500
2022-04-20 00:00:00 | 15 | [NAME] | 44 | 500
2022-04-24 00:00:00 | 83 | [NAME] | 20 | 300
2022-04-27 00:00:00 | 13 | [NAME] | 24 | 1000
2022-04-27 00:00:00 | 77 | [NAME] | 14 | 500
2022-04-30 00:00:00 | 81 | [NAME] | 11 | 600
2022-05-01 00:00:00 | 43 | [NAME] | 18 | 500
2022-05-02 00:00:00 | 60 | [NAME] | 13 | 500
2022-05-04 00:00:00 | 95 | [NAME] | 2 | 1500
2022-05-05 00:00:00 | 79 | Seven Nine | 8 | 1500
2022-05-08 00:00:00 | 82 | [NAME] | 16 | 600
2022-05-08 00:00:00 | 83 | [NAME] | 21 | 300
2022-05-08 00:00:00 | 56 | Little Bear | 12 | 750
2022-05-08 00:00:00 | 51 | Panda | 19 | 750
2022-05-09 00:00:00 | 3 | Fay | 57 | 500
2022-05-14 00:00:00 | 86 | [NAME] | 9 | 500
2022-05-14 00:00:00 | 85 | [NAME] | 9 | 500
2022-05-15 00:00:00 | 8 | [NAME] | 34 | 1500
2022-05-17 00:00:00 | 84 | Mark | 9 | 500
2022-05-19 00:00:00 | 7 | Ray | 42 | 500
2022-05-20 00:00:00 | 42 | Yulia | 20 | 1500
2022-05-20 00:00:00 | 41 | [NAME] | 30 | 1500
2022-05-21 00:00:00 | 72 | Anna | 9 | 1500
2022-05-23 00:00:00 | 4 | Flower | 43 | 500
2022-05-28 00:00:00 | 75 | Jake | 16 | 500
2022-06-01 00:00:00 | 14 | [NAME] | 43 | 500
2022-06-02 00:00:00 | 78 | Mason | 4 | 1500
2022-06-04 00:00:00 | 81 | [NAME] | 12 | 600
2022-06-05 00:00:00 | 82 | [NAME] | 17 | 600
2022-06-08 00:00:00 | 77 | [NAME] | 15 | 500
2022-06-08 00:00:00 | 15 | [NAME] | 45 | 500
2022-06-12 00:00:00 | 93 | [NAME] | 4 | 1500
2022-06-20 00:00:00 | 3 | Fay | 58 | 500
2022-06-21 00:00:00 | 85 | [NAME] | 10 | 500
2022-06-21 00:00:00 | 86 | [NAME] | 10 | 500
2022-06-25 00:00:00 | 84 | Mark | 10 | 500
2022-06-27 00:00:00 | 7 | Ray | 43 | 500
2022-06-30 00:00:00 | 4 | Flower | 44 | 500
2022-07-01 00:00:00 | 82 | [NAME] | 18 | 600
2022-07-03 00:00:00 | 68 | [NAME] | 11 | 1500
2022-07-10 00:00:00 | 44 | [NAME] | 18 | 1500
2022-07-13 00:00:00 | 95 | [NAME] | 3 | 1500