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

IMPREST APPLICATION 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 | DATE OF DEPARTURE | DATE APPLICATION RECEIVED BY ACCOUNTS | AMOUNT OF IMPREST (PULA) | DATE OF PREPARATION OF T116 | DATE T117 PREPARED | DATE T38A PREPARED | DATE TO FINANCE/ REVENUE | DATE OF PAYMENT | NUMBER OF DAYS TAKEN | COMMENTS
1 | [NAME] | 2021-10-05 00:00:00 | 2021-10-05 00:00:00 | 4815 | 2021-10-05 00:00:00 | 2021-10-05 00:00:00 | 2021-10-05 00:00:00 | 2021-10-05 00:00:00 | 2021-10-06 00:00:00 | 2 | PWT
2 | A. TOBEDZA | 2021-10-05 00:00:00 | 2021-10-05 00:00:00 | 4815 | 2021-10-05 00:00:00 | 2021-10-05 00:00:00 | 2021-10-05 00:00:00 | 2021-10-05 00:00:00 | 2021-10-06 00:00:00 | 2 | PWT
3 | M. SEONYANA | 2021-10-18 00:00:00 | 2021-10-13 00:00:00 | 7560 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 3 | PWT
4 | [NAME] | 2021-10-14 00:00:00 | 2021-10-13 00:00:00 | 2935 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 3 | PWT
5 | O. DIPHEGETO | 2021-10-18 00:00:00 | 2021-10-13 00:00:00 | 7560 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 3 | PWT
6 | K. MOTSUMI | 2021-10-18 00:00:00 | 2021-10-13 00:00:00 | 7560 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 3 | PWT
7 | [NAME] | 2021-10-17 00:00:00 | 2021-10-13 00:00:00 | 4250 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 3 | PWT
8 | [NAME] | 2021-10-17 00:00:00 | 2021-10-13 00:00:00 | 4250 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 3 | PWT
9 | M. LOETO | 2021-10-14 00:00:00 | 2021-10-13 00:00:00 | 2935 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 3 | PWT
10 | N.TEMA | 2021-10-25 00:00:00 | 2021-10-18 00:00:00 | 6571 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 2021-10-19 00:00:00 | 2021-10-19 00:00:00 | 2021-10-20 00:00:00 | 3 | PWT
11 | [NAME] | 2021-10-25 00:00:00 | 2021-10-18 00:00:00 | 6571 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 2021-10-19 00:00:00 | 2021-10-19 00:00:00 | 2021-10-19 00:00:00 | 2 | PWT
12 | K. ONTUETSE | 2021-10-24 00:00:00 | 2021-10-18 00:00:00 | 2145 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 2021-10-19 00:00:00 | 2021-10-19 00:00:00 | 2021-10-20 00:00:00 | 3 | PWT
13 | [NAME] | 2021-10-24 00:00:00 | 2021-10-19 00:00:00 | 5757 | 2021-10-18 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 3 | PWT
14 | P. TEKANYO | 2021-10-24 00:00:00 | 2021-10-19 00:00:00 | 5757 | 2021-10-18 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 3 | PWT
15 | [NAME] | 2021-10-24 00:00:00 | 2021-10-19 00:00:00 | 5757 | 2021-10-18 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 3 | PWT
16 | K. RANTUNG | 2021-10-24 00:00:00 | 2021-10-19 00:00:00 | 5757 | 2021-10-18 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 3 | PWT
17 | A. GONDO | 2021-10-24 00:00:00 | 2021-10-19 00:00:00 | 5757 | 2021-10-18 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 3 | PWT
18 | K. KAYAMA | 2021-10-24 00:00:00 | 2021-10-19 00:00:00 | 5757 | 2021-10-18 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 3 | PWT
19 | [NAME] | 2021-10-25 00:00:00 | 2021-10-20 00:00:00 | 5565 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 1 | PWT
20 | [NAME] | 2021-10-25 00:00:00 | 2021-10-20 00:00:00 | 5565 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 2021-10-21 00:00:00 | 2 | PWT
21 | [NAME] | 2021-10-24 00:00:00 | 2021-10-22 00:00:00 | 5757 | 2021-10-22 00:00:00 | 2021-10-22 00:00:00 | 2021-10-22 00:00:00 | 2021-10-22 00:00:00 | 2021-10-22 00:00:00 | 1 | PWT
22 | [NAME] |  | 2021-10-29 00:00:00 | 4715 |  |  |  |  |  |  | NPWT
23 | M. SEONYANA |  | 2021-10-29 00:00:00 | 4715 |  |  |  |  |  |  | NPWT