Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions



Reply
 
Thread Tools Search this Thread Display Modes
  #351  
Old 04-09-2018, 04:33 PM
dunnigan dunnigan is offline
Member
SOA AAA
 
Join Date: Apr 2007
Posts: 133
Default

Regarding naming conventions, I just love things named "New" this or that.

NewUL.xlsx
NewProcess.xlsx

Sometimes those names hang around for 15 years.
Reply With Quote
  #352  
Old 04-16-2018, 09:45 AM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 81,656
Blog Entries: 6
Default

https://www.businessinsider.co.za/si...igation-2018-4

Quote:
BUSINESS INSIDER | BUSINESS
Two KPMG partners with a combined 26-year history at the firm have quit amid the growing VBS Mutual Bank scandal
Spoiler:
KPMG South Africa on Saturday announced the resignations of long-standing partner Sipho Malaba as well as long-time employee (and more recently a partner) Dumi Tshuma.
Both had left before they could face disciplinary proceedings "connected to VBS Bank".
VBS Mutual Bank was placed into curatorship after what the Reserve Bank has described as chaotic financial management.
Two of its partners, Sipho Malaba and Dumi Tshuma, had resigned, KPMG announced on Friday afternoon.

Between them, the two had been at KPMG for more than a quarter of a century.

Malaba had been a partner at KPMG for more than 11 years according to his LinkedIn profile. Tshuma had been with KPMG for 15 years in various positions, the last three years as a partner.

KPMG said disciplinary cases against both had included "failure by the partners to comply with the firm’s policies and procedures regarding the disclosure of relevant financial interests" related to VBS Mutual Bank.

Since VBS was placed into curatorship and its books effectively opened it has emerged that some R900 million of its supposed deposits could not be traced.

There have also been allegations that insiders benefitted, and that some were extended loans despite conflicts of interest.

There has been no evidence that such benefits or loans flowed to the bank's auditors, either KPMG or (since dismissed) internal auditors PwC.

But there has been extensive evidence that the VBS books – signed off by its auditors – were in a terrible state.

In mid 2017, legal papers filed by the Reserve Bank show, VBS had a shortfall of R250 million. It turned out that VBS had accidentally paid that money out "due to internal control failures in a branch".

There had "inept risk management functions and practices" the Reserve Bank said.

And sometimes VBS had managed hundreds of millions of rands using consumer-grade desktop software.

Before it was placed in curatorship, regulators pointed out the VBS relied on one specific area of its business to drive profits: its fuel-guarantee and contract-finance business.


Once the books were opened to its new curator, the details of how those business lines were managed came to light.

"Excel spreadsheets are used to manage the contract finance and fuel guarantee books of the bank," the Reserve Bank told the high court in a filing. "In addition to these being susceptible to manipulation, it is highly unusual for a bank to manage these contracts by means of an Excel spreadsheet."

900 million rand's worth of deposits are missing -- that's about $75 million
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
Reply

Tags
machine learning, predictive analytics, speadsheet error, spreadsheets

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 08:34 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.12525 seconds with 10 queries