Spreadsheet: 774704d1648627090-help-to-automate-the-comment-row-help
Sheet: CLAIMS

CLAIMS MONITORING TOOL OF OCTOBER 2021
DEPARTMENT-TT&TE/FCTVE
ANALYSIS |  |  |  |  |  |  |  | TARGET 5 WORKING DAYS
ABBREVIATION
Paid within target(PWT) {5- Days} |  |  |  | PREPARED BY OBAKENG J. KHALI |  |  |  | SUPERVISOR'S SIGNATURE____________
Not Paid but within target (NPWT) |  |  |  | DATE: _______________________ |  |  |  | DATE:____________________
Paid Off Target (POT) {6+ Days} |  |  |  | SIGNATURE: ____________________
Not Paid & Off Target (NPOT)
TOTAL
NO | NAME OF THE APPLICANT | TYPE OF CLAIM | DATE CLAIM RECEIVED BY ACCOUNTS | AMOUNT OF CLAIM | DATE ONLINE CLAIM PREPARED | DATE CLAIM VALIDATED BY AUTHORISING OFFICER | DATE CLAIM SUBMITTED AT REVENUE | Date of payment by Revenue  (EFT) | NO of Days taken | Comments
1 | G.T. MAKOLONG | LEAVE CONCESSION | 2021-10-12 00:00:00 | 1593.3 | 2021-10-12 00:00:00 | 2021-10-13 00:00:00 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 3 | PWT
2 | [NAME] | LEAVE CONCESSION | 2021-10-13 00:00:00 | 1327.75 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-16 00:00:00 | 4 | PWT
3 | M. SEONYANA | SUBSISTANCE CLAIM | 2021-10-13 00:00:00 | 6392.05 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 2021-10-18 00:00:00 | 7 | POT
4 | P. TEKANYO | EXAM MARKING | 2021-10-15 00:00:00 | 2670 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
5 | E. MONYAKU | EXAM MARKING | 2021-10-15 00:00:00 | 6440 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
6 | K. RANTUNG | EXAM MARKING | 2021-10-15 00:00:00 | 4750 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
7 | T. KASHA | EXAM MARKING | 2021-10-15 00:00:00 | 4010 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
8 | R. MOLEFE | EXAM MARKING | 2021-10-15 00:00:00 | 900 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
9 | [NAME] | EXAM MARKING | 2021-10-15 00:00:00 | 2880 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
10 | K. KAYAMA | EXAM MARKING | 2021-10-15 00:00:00 | 945 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
11 | M. MAEDZA | EXAM MARKING | 2021-10-15 00:00:00 | 5510 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
12 | G. BAINGOTLI | EXAM MARKING | 2021-10-15 00:00:00 | 5540 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
13 | [NAME] | EXAM MARKING | 2021-10-15 00:00:00 | 1800 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
14 | T. MAKOPOLA | EXAM MARKING | 2021-10-15 00:00:00 | 900 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
15 | A. GONDO | EXAM MARKING | 2021-10-15 00:00:00 | 3020 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
16 | [NAME] | EXAM MARKING | 2021-10-15 00:00:00 | 2605 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
17 | [NAME] | EXAM MARKING | 2021-10-15 00:00:00 | 2850 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 5 | PWT
18 | [NAME] | MARKING & MODERATION | 2021-10-29 00:00:00 | 1410 |  |  |  |  |  | NPWT
19 | [NAME] | MARKING & MODERATION | 2021-10-29 00:00:00 | 2130 |  |  |  |  |  | NPWT
20 | [NAME] | MARKING & MODERATION | 2021-10-29 00:00:00 | 2820 |  |  |  |  |  | NPWT
21 | M. KHATA | MARKING & MODERATION | 2021-10-29 00:00:00 | 2240 |  |  |  |  |  | NPWT
22 | M. GANETSANG | MARKING & MODERATION | 2021-10-29 00:00:00 | 700 |  |  |  |  |  | NPWT
23 | M. MOSHANGWANE | MARKING & MODERATION | 2021-10-29 00:00:00 | 2075 |  |  |  |  |  | NPWT
24 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 325 |  |  |  |  |  | NPWT
25 | M. RAPHAKA | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 550 |  |  |  |  |  | NPWT
26 | M. SERETSE | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 600 |  |  |  |  |  | NPWT
27 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 750 |  |  |  |  |  | NPWT
28 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 1600 |  |  |  |  |  | NPWT
29 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 750 |  |  |  |  |  | NPWT
30 | E. MOHLOMI | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 750 |  |  |  |  |  | NPWT
31 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 400 |  |  |  |  |  | NPWT
32 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 400 |  |  |  |  |  | NPWT
33 | K. NTHULE | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 400 |  |  |  |  |  | NPWT
34 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 400 |  |  |  |  |  | NPWT
35 | K. SELALEDI | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 400 |  |  |  |  |  | NPWT
36 | W. MOSALAGAE | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 600 |  |  |  |  |  | NPWT
37 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 400 |  |  |  |  |  | NPWT
38 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 400 |  |  |  |  |  | NPWT
39 | [NAME] | INVIGILATION CLAIM | 2021-10-29 00:00:00 | 600 |  |  |  |  |  | NPWT