Stage 1 Errors Summary and Submissions Analysis

status stage 1 errors n.w
1 / 36
Embed
Share

Explore the Stage 1 errors presented by the National Treasury as of January 30, 2018. The financial data reveals 34 different types of errors with 46 municipalities having Stage 1 errors. Additionally, non-financial data shows that 56 municipalities are facing errors, while 176 submissions remain outstanding. Dive into detailed breakdowns of submissions, errors per vendor, outstanding submissions per vendor, and the various types of errors encountered during Stage 1.

  • Errors
  • Municipalities
  • Financial Data
  • Submissions Analysis
  • National Treasury
rayaanacharya
horstman_j Follow

Uploaded on | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

Download Presentation

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

E N D

Presentation Transcript

  1. Status Stage 1 Errors Presented by National Treasury 30 January 2018 1

  2. Stage 1 Errors Financial Data 34 Different type of Stage 1 Errors 46 Municipalities have Stage 1 Errors 97 Municipal Submissions are Outstanding Non - Financial Data 56 Municipalities have Stage 1 Errors 176 Municipal Submissions are Outstanding 2 2

  3. Stage 1 Summary of Submissions (Financial Data) Data submission Submitted /Successfull Submitted / with Errors Outstanding Total M01 233 23 1 257 M02 232 24 1 257 M03 221 33 3 257 M04 210 36 11 257 M05 156 46 55 257 M06 120 40 97 257 3 3

  4. Stage 1 Summary of Submissions (Financial Data) Submitted With Errors - PER VENDOR Submitted / with Errors M01 M02 M03 M04 M05 M06 Vendor V1 1 1 1 2 4 3 V2 1 1 3 3 3 2 V3 0 0 1 1 4 3 V4 0 0 0 0 1 0 V5 0 0 0 0 0 0 V6 20 16 21 17 18 17 V7 0 0 0 0 0 0 V8 0 0 0 0 0 0 V9 0 1 1 1 3 7 V10 0 1 1 4 7 4 V11 1 4 5 8 6 2 V12 0 0 0 0 0 2 Total 23 24 33 36 46 40 4 4

  5. Stage 1 Summary of Submissions (Financial Data) Outstanding Submissions - PER VENDOR Outstanding M01 M02 M03 M04 M05 M06 Vendor V1 0 0 0 0 7 15 V2 0 0 0 0 1 4 V3 0 0 0 1 8 12 V4 0 0 0 0 0 0 V5 0 0 0 0 0 0 V6 0 0 1 2 8 12 V7 0 0 1 2 3 4 V8 0 0 0 0 0 3 V9 0 0 0 0 0 1 V10 0 0 0 2 16 27 V11 0 0 0 3 11 17 V12 1 1 1 1 1 2 Total 1 1 3 11 55 97 5 5

  6. Stage 1 Summary of Submissions (Financial Data) Type of Errors Type of Errors (Stage 1) Number of Records Amount with cents. 1212 Invalid ProjectCode. Invalid FunctionCode. Invalid ItemCode. Invalid FundCode. Invalid CostingCode. Invalid RegionCode. 810 Breakdown required for ProjectCode. 251 Invalid FunctionCode. 70 Posting/Breakdown config error for ItemCode. 63 Invalid FunctionCode. Invalid ItemCode. 40 Posting/Breakdown config error for FundCode. 35 Invalid FunctionCode. Invalid ItemCode. Invalid FundCode. 18 ProjectCode is missing. Invalid FunctionCode. Invalid ItemCode. Invalid FundCode. Invalid CostingCode. Invalid RegionCode. 17 Breakdown required for ProjectCode. Posting/Breakdown config error for ItemCode. 15 Invalid FunctionCode. Posting/Breakdown config error for ItemCode. 14 ItemCode is missing. 12 Invalid FundCode. 11 Invalid ProjectCode. Invalid FunctionCode. Invalid ItemCode. 11 Amount with cents. Invalid FunctionCode. 8 6 6

  7. Stage 1 Summary of Submissions (Financial Data) Type of Errors Type of Errors (Stage 1) Number of Records Invalid ProjectCode. Invalid FunctionCode. Invalid ItemCode. Invalid FundCode. 6 Posting not allowed for ProjectCode. Invalid FunctionCode. Invalid ItemCode. 5 Invalid FunctionCode. Invalid FundCode. 4 Invalid FunctionCode. Invalid ItemCode. Posting/Breakdown config error for FundCode. 4 Invalid ItemCode. 3 Posting/Breakdown config error for RegionCode. 3 Invalid RegionCode. 2 Year mismatch between filename and data / data contains Year 2017 2 Amount with cents. Invalid FunctionCode. Invalid ItemCode. 1 Amount with cents. Invalid ItemCode. 1 Amount with cents. Posting/Breakdown config error for ItemCode. 1 Invalid FunctionCode. Posting/Breakdown config error for ItemCode. Invalid FundCode. 1 Invalid ProjectCode. Invalid FunctionCode. 1 ProjectCode is missing. FunctionCode is missing. FundCode is missing. CostingCode is missing. RegionCode is missing. 1 ProjectCode is missing. FunctionCode is missing. ItemCode is missing. FundCode is missing. CostingCode is missing. RegionCode is missing. 1 7 7

  8. Stage 1 Summary of Submissions (Non - Financial Data) Data submission Submitted /Successfull Submitted / with Errors Outstanding Total BMQ1 106 50 101 257 IMQ1 95 56 106 257 DR06 43 38 176 257 CR06 80 15 162 257 8 8

  9. Stage 1 Summary of Submissions (Non - Financial Data) Submitted With Errors - PER VENDOR Submitted / with Errors BMQ1 IMQ1 DR06 CR06 Vendor V1 10 8 8 3 V2 4 5 6 0 V3 10 14 8 7 V4 0 1 0 0 V5 0 0 0 0 V6 5 10 0 1 V7 1 1 1 0 V8 2 2 1 0 V9 1 1 9 1 V10 0 2 1 1 V11 16 12 2 2 V12 1 0 2 0 Total 50 56 38 15 9 9

  10. Status Stage 2 Errors Presented by National Treasury 30 January 2018 10 10

  11. Stage 2 Segment Errors Sum of Charges and Recoveries(CO001 + CO002) 42 Municipalities do not balance Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) M01 - 11 Municipalities M02 26 Municipalities M03 32 Municipalities M04 37 Municipalities M05 32 Municipalities M06 29 Municipalities Operation projects not valid against acquisitions or additions (PO not valid against IA002 level acquisitions or additions) 47 Errors from M01 to M06 11 11

  12. Stage 2 Segment Errors Oper Proj: Cost of Free Basic Services and Revenue Cost of Free Services and Property Rebates can only have Item Revenue or certain Item Assets 189 Errors from M01 to M06 Default projects may NOT have Item Expenditure and Assets except for current assets and default items 205 Errors from M01 to M06 Remuneration of Councillors not against Mayor and Council 26 Errors from M01 to M06 Bulk purchase electricity not against Electricity 42 Errors from M01 to M06 Inventory consumed : Water not against Water No Errors 12 12

  13. Stage 2 Segment Errors Trial Balance 102 Municipalities not Balancing Default Region 60 Municipalities have Errors Other 9 Municipalities have Default Costing and default Expenditure not valid 14 Municipalities have Default Costing and default Revenue not valid 13 13

  14. Sum of Charges and Recoveries Presented by National Treasury 30 January 2018 14 14

  15. Stage 2 Segment Errors (Financial Data) Sum of Charges and Recoveries(CO001 + CO002) All Months Actuals Municipalities Don t Balance Demarcation Description Demarc Code Sum of Charges and Recoveries(CO001 + CO002) All Province EC EC EC EC EC EC FS FS FS FS GT GT GT KZN KZN LMP LMP LMP LMP MP MP MP Months Actuals Amathole DC12 -37 397 211 Buffalo City BUF 408 127 Dr Beyers Naude EC101 -15 000 Intsika Yethu EC135 293 901 Nelson Mandela Bay NMA -13 833 800 Ntabankulu EC444 1 509 287 Dihlabeng FS192 -6 271 Mangaung MAN -2 812 984 Matjhabeng FS184 2 434 Metsimaholo FS204 12 244 548 Ekurhuleni Metro EKU -120 923 303 Emfuleni GT421 2 890 Lesedi GT423 -1 633 422 KwaDukuza KZN292 2 473 967 uMhlathuze KZN282 60 193 Lepelle-Nkumpi LIM355 -1 250 Mogalakwena LIM367 -24 403 Molemole LIM353 210 676 Polokwane LIM354 1 725 366 City of Mbombela MP326 1 715 480 Msukaligwa MP302 -144 683 Steve Tshwete MP313 9 021 15 15

  16. Stage 2 Segment Errors (Financial Data) Sum of Charges and Recoveries(CO001 + CO002) All Months Actuals Municipalities Don t Balance Demarcation Description Demarc Code Sum of Charges and Recoveries(CO001 + CO002) All Province NC NC NC NC NC NW NW NW NW WC WC WC WC WC WC WC WC WC WC WC Months Actuals Frances Baard DC9 15 199 Hantam NC065 233 175 Nama Khoi NC062 553 081 Phokwane NC094 -1 086 565 Richtersveld NC061 28 298 Madibeng NW372 -461 258 Maquassi Hills NW404 -296 063 Moses Kotane NW375 45 998 Tswaing NW382 -1 006 Bergrivier WC013 -595 047 Breede Valley WC025 300 993 Cape Town CPT 6 585 467 Drakenstein WC023 149 594 George WC044 -100 372 384 Hessequa WC042 1 997 268 Kannaland WC041 476 056 Knysna WC048 -1 656 265 Laingsburg WC051 -1 351 056 Mossel Bay WC043 12 388 629 Swellendam WC034 -219 000 16 16

  17. Capital projects can only have Item Assets or Payables and Accruals Presented by National Treasury 30 January 2018 17 17

  18. Stage 2 Segment Errors (Financial Data) Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Outstanding M01 Errors Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Demarcation Description Buffalo City Nketoana KwaDukuza uMuziwabantu Umzinyathi Bela Bela Sekhukhune Emakhazeni Thembisile Hani Joe Morolong Saldanha Bay Demarc Code BUF FS193 KZN292 KZN214 DC24 LIM366 DC47 MP314 MP315 NC451 WC014 Province EC FS KZN KZN KZN LMP LMP MP MP NC WC CAP H M H L L M H L L L H FINANCIALYEAR 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Period M01 M01 M01 M01 M01 M01 M01 M01 M01 M01 M01 3 1 1 1 1 5 5 1 1 3 1 18 18

  19. Stage 2 Segment Errors (Financial Data) Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Outstanding M02 Errors Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Demarcation Description Amathole Elundini Mbizana Ndlambe Umzimvubu Mangaung Nketoana Thabo Mofutsanyana Tswelopele Alfred Duma iLembe Inkosi Langalibalele Umzinyathi uThungulu Bela Bela Sekhukhune Thulamela Vhembe Dipaleseng Lekwa Thembisile Hani Emthanjeni Sol Plaatje Hessequa Knysna Saldanha Bay Demarc Code DC12 EC141 EC443 EC105 EC442 MAN FS193 DC19 FS183 KZN238 DC29 KZN237 DC24 DC28 LIM366 DC47 LIM343 DC34 MP306 MP305 MP315 NC073 NC091 WC042 WC048 WC014 Province EC EC EC EC EC FS FS FS FS KZN KZN KZN KZN KZN LMP LMP LMP LMP MP MP MP NC NC WC WC WC CAP H L M L M H M L M M L M L H M H M L L L L M H M M H FINANCIALYEAR 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Period M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 M02 4 5 4 1 3 3 1 1 1 2 1 1 8 3 5 5 3 1 2 2 9 4 5 2 1 9 19 19

  20. Stage 2 Segment Errors (Financial Data) Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Outstanding M03 Errors Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Demarcation Description Demarc Code Province EC EC EC EC EC EC EC FS FS GT KZN KZN KZN KZN KZN LMP LMP LMP LMP LMP MP MP MP MP MP NC NC NC WC WC WC CAP FINANCIALYEAR Period Amathole DC12 H 2018 M03 25 Buffalo City BUF H 2018 M03 9 Elundini EC141 L 2018 M03 5 Matatiele EC441 M 2018 M03 1 Mbizana EC443 M 2018 M03 5 Ndlambe EC105 L 2018 M03 1 Umzimvubu EC442 M 2018 M03 1 Mangaung MAN H 2018 M03 3 Tswelopele FS183 M 2018 M03 1 Emfuleni GT421 H 2018 M03 3 Alfred Duma KZN238 M 2018 M03 2 iLembe DC29 L 2018 M03 6 Inkosi Langalibalele KZN237 M 2018 M03 3 KwaDukuza KZN292 H 2018 M03 1 Umzinyathi DC24 L 2018 M03 7 Bela Bela LIM366 M 2018 M03 5 Makhado-Thulamela LIM345 M 2018 M03 1 Sekhukhune DC47 H 2018 M03 11 Thulamela LIM343 M 2018 M03 2 Vhembe DC34 L 2018 M03 4 City of Mbombela MP326 M 2018 M03 4 Dipaleseng MP306 L 2018 M03 1 Emakhazeni MP314 L 2018 M03 2 Lekwa MP305 L 2018 M03 1 Thembisile Hani MP315 L 2018 M03 2 Khai-Ma NC067 L 2018 M03 1 Richtersveld NC061 M 2018 M03 1 Sol Plaatje NC091 H 2018 M03 5 Hessequa WC042 M 2018 M03 3 Mossel Bay WC043 H 2018 M03 1 Saldanha Bay WC014 H 2018 M03 7 20 20

  21. Stage 2 Segment Errors (Financial Data) Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Outstanding M04 Errors EC Amathole DC12 EC Buffalo City BUF EC Elundini EC141 EC Matatiele EC441 EC Mbizana EC443 EC Ndlambe EC105 EC Umzimvubu EC442 FS Mangaung MAN GT Ekurhuleni Metro EKU GT Emfuleni GT421 GT Midvaal GT422 GT Mogale City GT481 GT Rand West City GT485 KZN Alfred Duma KZN238 KZN Greater Kokstad KZN433 KZN iLembe DC29 KZN Inkosi Langalibalele KZN237 KZN KwaDukuza KZN292 KZN Richmond KZN227 KZN uThungulu DC28 LMP Bela Bela LIM366 LMP Makhado-Thulamela LIM345 LMP Mogalakwena LIM367 LMP Polokwane LIM354 LMP Sekhukhune DC47 LMP Vhembe DC34 MP City of Mbombela MP326 MP Dipaleseng MP306 MP Emakhazeni MP314 MP Lekwa MP305 MP Thembisile Hani MP315 NC Emthanjeni NC073 NC Ga-Segonyana NC452 NC Khai-Ma NC067 NC Sol Plaatje NC091 WC Saldanha Bay WC014 WC Swellendam WC034 H 2018 M04 21 H 2018 M04 1 L 2018 M04 7 M 2018 M04 3 M 2018 M04 5 L 2018 M04 1 M 2018 M04 2 H 2018 M04 17 H 2018 M04 104 H 2018 M04 3 M 2018 M04 1 H 2018 M04 1 M 2018 M04 5 M 2018 M04 2 L 2018 M04 1 L 2018 M04 15 M 2018 M04 4 H 2018 M04 1 L 2018 M04 3 H 2018 M04 6 M 2018 M04 1 M 2018 M04 1 L 2018 M04 17 H 2018 M04 7 H 2018 M04 1 L 2018 M04 4 M 2018 M04 12 L 2018 M04 1 L 2018 M04 3 L 2018 M04 2 L 2018 M04 11 M 2018 M04 1 M 2018 M04 5 L 2018 M04 1 H 2018 M04 7 H 2018 M04 7 L 2018 M04 3 21 21

  22. Stage 2 Segment Errors (Financial Data) Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Outstanding M05 Errors Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Demarcation Description Demarc Code Province EC EC EC EC EC EC FS GT GT GT GT KZN KZN KZN KZN KZN KZN KZN KZN LMP MP MP MP MP MP NC NC NC WC WC WC WC CAP FINANCIALYEAR Period Amathole DC12 H 2018 M05 33 Blue Crane Route EC102 L 2018 M05 1 Buffalo City BUF H 2018 M05 1 Elundini EC141 L 2018 M05 6 Matatiele EC441 M 2018 M05 3 Umzimvubu EC442 M 2018 M05 3 Mangaung MAN H 2018 M05 3 Ekurhuleni Metro EKU H 2018 M05 79 Midvaal GT422 M 2018 M05 1 Mogale City GT481 H 2018 M05 1 Rand West City GT485 M 2018 M05 4 Alfred Duma KZN238 M 2018 M05 2 Greater Kokstad KZN433 L 2018 M05 1 iLembe DC29 L 2018 M05 11 Inkosi Langalibalele KZN237 M 2018 M05 2 KwaDukuza KZN292 H 2018 M05 1 Richmond KZN227 L 2018 M05 2 Umzinyathi DC24 L 2018 M05 4 uThungulu DC28 H 2018 M05 5 Vhembe DC34 L 2018 M05 7 City of Mbombela MP326 M 2018 M05 17 Dipaleseng MP306 L 2018 M05 1 Lekwa MP305 L 2018 M05 2 Steve Tshwete MP313 H 2018 M05 1 Thembisile Hani MP315 L 2018 M05 10 Ga-Segonyana NC452 M 2018 M05 7 Khai-Ma NC067 L 2018 M05 1 Sol Plaatje NC091 H 2018 M05 7 Cape Town CPT H 2018 M05 821 Drakenstein WC023 H 2018 M05 7 Hessequa WC042 M 2018 M05 4 Saldanha Bay WC014 H 2018 M05 5 22 22

  23. Stage 2 Segment Errors (Financial Data) Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Outstanding M06 Errors Capital projects can only have Item Assets or Payables and Accruals (PC only against IA and IL001006011 is valid) Demarcation Description Blue Crane Route Chris Hani Elundini Ngquza Hills Sarah Baartman Mangaung Ekurhuleni Metro Midvaal Rand West City Alfred Duma iLembe Inkosi Langalibalele KwaDukuza Ray Nkonyeni Richmond uThungulu Makhado-Thulamela City of Mbombela Lekwa Steve Tshwete Thembisile Hani Ga-Segonyana Sol Plaatje Ramotshere Moiloa Cape Town Drakenstein Hessequa Saldanha Bay Stellenbosch Demarc Code EC102 DC13 EC141 EC153 DC10 MAN EKU GT422 GT485 KZN238 DC29 KZN237 KZN292 KZN216 KZN227 DC28 LIM345 MP326 MP305 MP313 MP315 NC452 NC091 NW385 CPT WC023 WC042 WC014 WC024 Province EC EC EC EC EC FS GT GT GT KZN KZN KZN KZN KZN KZN KZN LMP MP MP MP MP NC NC NW WC WC WC WC WC CAP L M L L M H H M M M L M H H L H M M L H L M H L H H M H H FINANCIALYEAR 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Period M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 M06 1 1 9 5 1 3 132 1 5 1 14 2 4 1 3 8 1 12 3 12 6 6 7 1 793 1 3 4 2 23 23

  24. Operation projects not valid against acquisitons or additions Presented by National Treasury 30 January 2018 24 24

  25. Stage 2 Segment Errors (Financial Data) Operation projects not valid against acquisitons or additions (PO not valid against IA002 level acquisitons or additions) Operation projects not valid against acquisitons or additions (PO not valid against IA002 level acquisitons or additions) Demarcation Description Bergrivier Joe Morolong uMhlathuze uMuziwabantu Mhlontlo Knysna Inxuba Yethemba Port St Johns Dawid Kruiper Victor Khanye Theewaterskloof Bergrivier Knysna Dawid Kruiper Dipaleseng Musina Thabo Mofutsanyana Dikgatlong Inxuba Yethemba Dawid Kruiper Dipaleseng Polokwane Nelson Mandela Bay Lepelle-Nkumpi Demarc Code WC013 NC451 KZN282 KZN214 EC156 WC048 EC131 EC154 NC087 MP311 WC031 WC013 WC048 NC087 MP306 LIM341 DC19 NC092 EC131 NC087 MP306 LIM354 NMA LIM355 Province WC NC KZN KZN EC WC EC EC NC MP WC WC WC NC MP LMP FS NC EC NC MP LMP EC LMP CAP M L H L L M L M M M M M M M L L L L L M L H H L FINANCIALYEAR 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 2018 Period M01 M01 M01 M01 M01 M01 M01 M01 M01 M01 M01 M02 M02 M02 M02 M02 M02 M02 M02 M03 M03 M03 M03 M03 1 1 1 1 1 2 2 2 3 3 5 1 1 1 1 1 1 2 3 1 1 1 1 2 25 25

  26. Stage 2 Segment Errors (Financial Data) Operation projects not valid against acquisitons or additions (PO not valid against IA002 level acquisitons or additions) Operation projects not valid against acquisitons or additions (PO not valid against IA002 level acquisitons or additions) Demarcation Description Demarc Code Province LMP EC EC EC WC NC GT EC NW EC EC WC WC NC MP EC EC LMP EC EC NC MP GT EC CAP FINANCIALYEAR Period Lepelle-Nkumpi LIM355 L 2018 M03 2 Amathole DC12 H 2018 M03 3 Inxuba Yethemba EC131 L 2018 M03 3 Chris Hani DC13 M 2018 M03 4 Knysna WC048 M 2018 M03 9 Dawid Kruiper NC087 M 2018 M04 1 Ekurhuleni Metro EKU H 2018 M04 1 Amathole DC12 H 2018 M04 1 Kagisano-Molopo NW397 L 2018 M04 2 Inxuba Yethemba EC131 L 2018 M04 2 Walter Sisulu EC145 M 2018 M04 5 Knysna WC048 M 2018 M04 9 Knysna WC048 M 2018 M05 1 Dawid Kruiper NC087 M 2018 M05 1 Dipaleseng MP306 L 2018 M05 1 Elundini EC141 L 2018 M05 1 Port St Johns EC154 M 2018 M05 1 Ba-Phalaborwa LIM334 M 2018 M05 2 Amathole DC12 H 2018 M05 5 Chris Hani DC13 M 2018 M05 14 Dawid Kruiper NC087 M 2018 M06 1 Dipaleseng MP306 L 2018 M06 1 City Of Johannesburg JHB H 2018 M06 2 Chris Hani DC13 M 2018 M06 3 26 26

  27. Inventory consumed:Water not against Water Presented by National Treasury 30 January 2018 27 27

  28. Stage 2 Segment Errors (Financial Data) Inventory consumed : Water not against Water (IE007004 not against FX016001002 or FX016002002) No Errors 28 28

  29. Trial Balance Presented by National Treasury 30 January 2018 29 29

  30. Stage 2 Segment Errors (Financial Data) Trial Balance (sum of all items - IE018 and IR004) 102 Municipalities have Trial Balance Issues Bergrivier Kgetlengrivier Richtersveld Mogalakwena uThungulu Engcobo Breede Valley Lekwa-Teemane Sol Plaatje Molemole Zululand Enoch Mgijima Cape Agulhas Madibeng Z F Mgcawu Polokwane City Of Tshwane Intsika Yethu Cape Town Maquassi Hills Bushbuckridge Alfred Duma Ekurhuleni Metro Inxuba Yethemba Cape Winelands DM Moses Kotane City of Mbombela Dr Nkosazana Dlamini Zuma Emfuleni Nelson Mandela Bay Cederberg Naledi (Nw) Ehlanzeni eDumbe Lesedi Ntabankulu Drakenstein Tlokwe-Ventersdorp Lekwa eMadlangeni Merafong City O .R. Tambo George Tswaing Msukaligwa iLembe Midvaal Hessequa Frances Baard Nkomazi KwaDukuza Mogale City Knysna Ga-Segonyana Pixley Ka Seme (MP) Msinga West Rand Laingsburg Hantam Steve Tshwete Newcastle Dihlabeng Mossel Bay Kamiesberg Thembisile Hani Okhahlamba Mangaung Saldanha Bay Kgatelopele Blouberg Ray Nkonyeni Matjhabeng Swellendam Magareng Capricorn Ubuhlebezwe Metsimaholo Theewaterskloof Nama Khoi Ephraim Mogale uMhlathuze Moqhaka West Coast Namakwa Fetakgomo-Greater Tubatse uMngeni Ngwathe Bojanala Platinum Phokwane Greater Giyani Umvoti Buffalo City City Of Matlosana Pixley Ka Seme (Nc) Lepelle-Nkumpi Umzimkhulu Chris Hani Dr Kenneth Kaunda Renosterberg Modimolle-Mookgopong Uthukela Elundini 30 30

  31. Default not valid (RX001 not valid) Presented by National Treasury 30 January 2018 31 31

  32. Stage 2 Segment Errors (Financial Data) Default not valid (RX001 not valid) 60 Municipalities have Default Region Errors Mossel Bay Ndlambe Lekwa Bergrivier Elundini Amathole Uthukela Witzenberg Nama Khoi iLembe Dr Ruth Segomotsi Mompati Ratlou Knysna Gert Sibande Dipaleseng Dr Beyers Naude KwaDukuza Msinga Umzimkhulu Nketoana Mantsopa Swellendam Richmond Matatiele Bela Bela Umzinyathi Breede Valley Ubuhlebezwe Mbizana Polokwane Thabazimbi Steve Tshwete Tswelopele Kouga uMuziwabantu Pixley Ka Seme (MP) Rand West City Makana Thulamela Alfred Duma Vhembe Dr Nkosazana Dlamini Zuma Ga-Segonyana Modimolle-Mookgopong Lejweleputswa uMngeni Ephraim Mogale Saldanha Bay Naledi (Nw) Makhado-Thulamela !Kheis Ray Nkonyeni Emakhazeni Kgatelopele Cape Winelands DM Z F Mgcawu Thembisile Hani Greater Kokstad Blue Crane Route Umzimvubu 32 32

  33. Other Errors Presented by National Treasury 30 January 2018 33 33

  34. Stage 2 Segment Errors (Financial Data) Other Errors 9 Municipalities have Default Costing and default Expenditure not valid 14 Municipalities have Default Costing and default Revenue not valid 34 34

  35. How are we going to fix these repeating Errors?? Presented by National Treasury 30 January 2018 35 35

  36. THANK YOU

Related


Errors in Pharmaceutical Analysis

Errors in Pharmaceutical Analysis

thais
Exceptions in Computer Science

Exceptions in Computer Science

attila
Numerical Methods and Errors in Computation

Numerical Methods and Errors in Computation

maura
Period Control Guidelines in mSCOA Reporting Workshops 2020

Period Control Guidelines in mSCOA Reporting Workshops 2020

zenon
Medication Errors in Healthcare

Medication Errors in Healthcare

mahnoor
Guidelines for Transacting Periods and Posting Levels in mSCOA Vendor Reporting

Guidelines for Transacting Periods and Posting Levels in mSCOA Vendor Reporting

braelynn
Debugging in Programming

Debugging in Programming

moira
mSCOA: Demystifying the Standard Chart of Accounts for Municipalities

mSCOA: Demystifying the Standard Chart of Accounts for Municipalities

torres_s
Grammar Errors Correction Exercises for English Language Learners

Grammar Errors Correction Exercises for English Language Learners

rein_371
mSCOA TABB File Upload Status Analysis

mSCOA TABB File Upload Status Analysis

lansford_c
Municipalities mSCOA Readiness Assessment for Budget Data Upload

Municipalities mSCOA Readiness Assessment for Budget Data Upload

asch_lli
Insights into Speech Production: Models, Errors, and Implications

Insights into Speech Production: Models, Errors, and Implications

arizmendi_m
Proposed Changes and Additions in mSCOA Version 6.3

Proposed Changes and Additions in mSCOA Version 6.3

glassburn_a
Challenges and Benefits of mSCOA Compliance in Financial Statement Preparation

Challenges and Benefits of mSCOA Compliance in Financial Statement Preparation

easen
Exception Handling in Java: Understanding Errors and Exceptions

Exception Handling in Java: Understanding Errors and Exceptions

jesch
MSCOA : Position Papers

MSCOA : Position Papers

syns206
mSCOA Version 5.4 and Changes to Classification Framework

mSCOA Version 5.4 and Changes to Classification Framework

feld_tim
EARTH RESOURCES REGULATION MINERALS DASHBOARD: Applications Overview Jan 2020 vs Jan 2021

EARTH RESOURCES REGULATION MINERALS DASHBOARD: Applications Overview Jan 2020 vs Jan 2021

nicodemus_b
mSCOA Project Phase 4: Change Management and Transition Strategy

mSCOA Project Phase 4: Change Management and Transition Strategy

selo
Insights on mSCOA Stress Test and Data Formatting Issues

Insights on mSCOA Stress Test and Data Formatting Issues

rizwanst
Vendor Session Errors Overview

Vendor Session Errors Overview

gazh
Practical Guide to Construction Work in Progress in mSCOA

Practical Guide to Construction Work in Progress in mSCOA

kdury

More Related Content