-
Paul Linkchorst wrote a new post on the site MIS5208 Spring 2017 7 years, 8 months ago
In today’s audit world, much of the substantiated evidence that we acquire during an IT audit is generated by computers. Such evidence can be include scheduled reports run at various times or can be evidence p […]
-
Paul Linkchorst wrote a new post on the site MIS5208 Spring 2017 7 years, 8 months ago
It seemed that another successful businessman, Mark Cuban, just joined the likes of Bill Gates, Elon Musk, and Stephen Hawkings in that they all believe that in the future, a notable chunk of the workforce will be […]
-
Paul Linkchorst posted a new activity comment 7 years, 9 months ago
Hey Mustafa,
Thanks for adding to the conversation/blog post. I can see how Benford’s law would not be applicable to those data sets. Also it is interesting that Benford might not apply to data sets under 500 records. If you were to perform a Benford analysis in Trans_April table in Lab 05/06, you will see that the arch does not fall within…[Read more]
-
Paul Linkchorst commented on the post, Week 03 – Discussion Question 2, on the site 7 years, 9 months ago
Hey Said,
I took the question’s “impact” on an organization moreso to be like how the organization can utilize the technology and improve itself with not so much the “impact” being how much it costs financially. For example, utilizing an email application can “impact” the organization by offering a quicker and more reliable form of communicat…[Read more]
-
Paul Linkchorst commented on the post, Progress Report for Week Ending, March 15, on the site 7 years, 9 months ago
Hey Mustafa,
You bring a different perspective to the question. You state that if you were an auditee the worst thing that you can get would be “more findings”. What happens in a situation where the audit is performed on a newly designed process or department and that this is the first audit? If I am an auditee, I would like the auditor to…[Read more]
-
Paul Linkchorst wrote a new post on the site MIS5208 Spring 2017 7 years, 9 months ago
Last week I posted a tip on how to turn GUI actions into a script in ACL. I have been playing with ACL to familiarize myself with the software some more and found another trick that I thought I would share with […]
-
Paul Linkchorst commented on the post, Happy Birthday SNL // the typists from the Carol Burnett show, on the site 7 years, 9 months ago
Hey Blake,
This was a good article that you posted about. As others have stated, I would be a little wary giving up data to a third party but I guess it depends on what information and what organization I belong too. For example, if metadata pertaining to the actions of a web user needed to be analyzed for marketing purposes then I suppose I…[Read more]
-
Paul Linkchorst posted a new activity comment 7 years, 9 months ago
Which one of these do you consider the worst type from the standpoint of the auditee? Why? The auditee is the person or group responsible for the subject matter being audited.
In my opinion, the worst type of auditor from the auditee standpoint would be that of “The Cookbook Auditor”. This type of auditor is one who generally uses a che…[Read more]
-
Paul Linkchorst posted a new activity comment 7 years, 9 months ago
Technology changes at mind-boggling speeds, and it greatly affects businesses and enterprises. What do you consider to be more important, depth of knowledge in technology, or its impact on the enterprise?
I think the answer to this question should be determined on how you want your role to be within an organization. I say this because having a…[Read more]
-
Paul Linkchorst wrote a new post on the site MIS5208 Spring 2017 7 years, 9 months ago
During our class this past week, we discussed some of the various ways to perform data analysis utilizing ACL. One of those options discussed was that of utilizing scripts. A script is a series of commands […]
-
Paul Linkchorst commented on the post, Segregation of Duties and Collusion:, on the site 7 years, 9 months ago
Hi Priya,
The EY matrix suggestion sounds like the matrix we used in our ERP class. During that exercise, we had to assign roles and responsibilities to different job titles which did not always naturally fit into one employee’s job title. This required looking at the overall matrix to determine which tasks should be performed by which…[Read more]
-
Paul Linkchorst commented on the post, Segregation of Duties and Collusion:, on the site 7 years, 9 months ago
Shawn,
You brought up a really good point. When I think of fraud, my mind seems to always go to the big cases like Enron, where C-Suite executives were the ones behind the fraud which isn’t always the case. I can see now how this type of control might be more effective than I gave it credit for.
-
Paul Linkchorst commented on the post, Segregation of Duties and Collusion:, on the site 7 years, 9 months ago
Hey Shawn,
You bring up a good point about how geography can help strengthen segregation of duties.
From the fraudsters perspective, geographical distances might mean that communication has to be on a logged/monitored channel (i.e. email, instant messenger, phone calls) and therefore this might deter fraud. I also have heard of mandated…[Read more] -
Paul Linkchorst posted a new activity comment 7 years, 9 months ago
Hi Blake,
You are right. In my experiences working as an Internal Audit intern and an External Audit intern, it seemed that those who have not been an auditee seem to have this misperception. This, as a result seemed to lead to a delay in receiving documentation from inexperienced auditees as they would go through the documentation with a…[Read more]
-
Paul Linkchorst wrote a new post on the site MIS5208 Spring 2017 7 years, 9 months ago
Since the establishment of the Sarbanes-Oxley Act, one of the most utilized internal controls for an organization to utilize is that of segregation of duties. Segregation of duties is the practice of splitting […]
-
I can think of two ways businesses can implement complementary controls to reinforce Segregation of Duties controls; geography and mandated leave.
Most of the “teeth” in SOX apply strictly to publicly traded companies, and those types of companies are typically quite large and spread over a large area of the country or even the planet. In that type of situation the business could spread the SOD’s across a large geographical area which would definitely prevent Tom, Dick, and Jane from getting together in the lunch room and hatching a plan to commit fraud through collusion. Although this doesn’t fully prevent personnel from developing relationships outside of work whereupon that type of collusion can be discussed, separating key personnel from each other by mileage can significantly help prevent collusion.
Many businesses force employees in key positions within the business to take vacation within a specific time period for a minimum length of time. During this time another employee carries out the duties and responsibilities of the vacationing employee in the hopes of discovering any intentional or unintentional errors committed by the employee. The mandated vacation policy acts as a deterrence to employees who might feel inclined to commit fraud since they will not be able to constantly hide the fraud from other employees as they will have to turn over their role(s) to other personnel each required time period. -
Good point Paul. It is true that segregation of duties does not prevent collusion. I like that to mentioned complementary controls. But, what about simply rotation of duties? In fact, an employee is less likely to collude with someone to “steal” if the assignment is a temporary one. This goes with mandatory vacation Sean mentioned. The idea being that it would not only be easier to detect fraud when the perpetrator is away , but also complacence because when employees get complacent and have low morale, they are more predisposed to commit fraud.
-
I agree with you, Paul. Separation of duties restricts the amount of power or influence held by any individual. It also aids to avoid conflicting in responsibilities for people and ensures that they are not responsible for reporting on themselves or their superiors. in my point of view, the issue of SoD is that many organizations have a lack of clear and coherence list of responsibilities that assigned for the high-level managers (e.g CEO-CFO). They usually have high authority with low observation or checking from another part which may cause high impact if the fraud happens from their side.
-
Hey Shawn,
You bring up a good point about how geography can help strengthen segregation of duties.
From the fraudsters perspective, geographical distances might mean that communication has to be on a logged/monitored channel (i.e. email, instant messenger, phone calls) and therefore this might deter fraud. I also have heard of mandated forced vacations as well, but I guess I supposed this was a control that looked good on paper but the effect is not as strong as those wished. Maybe it is my lack of experience, but do senior managers in an organization have their work performed by other members of the organization? I suppose forcing a mandated vacation might prevent a manager from being able to hide a fraud from occurring. With that being said, I would agree that these two types of controls can complement segregation of duties.-
Well if I remember correctly from Ed’s slides, 42% of from comes from line employees and 36% from managers. Since the majority of instances of fraud happen in those two groups it would be prudent for the business’s mandated vacation policy to affect those two groups to help mitigate the opportunity to hide any fraud being conducted. Like you stated, I imagine senior management, and I am implying C-Suite level, may not have personnel step in to their position to handle all duties and responsibilities when they are on vacation, but then I am not sure the kind of fraud a mandated vacation policy is intended to deter and/or detect is the type of fraud likely committed by senior management.
-
Shawn,
You brought up a really good point. When I think of fraud, my mind seems to always go to the big cases like Enron, where C-Suite executives were the ones behind the fraud which isn’t always the case. I can see now how this type of control might be more effective than I gave it credit for.
-
-
-
Paul, this is a well defined issue. In continuation to your article I read a post by EY which spoke about strengthening the SOD control. They suggest to take a risk based methodology for SOD. What companies should figure out is the conflict with the. A task based SOD is costly and this division does not effectively handle SOD control. Companies should build a landscape of conflicts and control each conflict if not remove it completely by SOD. This way management is definitely aware of conflict areas, they know where to focus and places where SOD can be improved. Management must study the conflict matrix to reduce the risk or accept where necessary.
EY defines steps for successful SOD
1. Study the company, roles, map them to business objective and determine conflict matrix.
2. Use the matrix as a tool to resolve SOD concerns. Management must also explore numerous ways of doing one task to explore all possible fraud areas. Determine not only the access and roles but various menus that are available for roles to perform tasks.
3. Testing: Testing of SOD must analyse the result of matrix. Try permutation and combination of business processes and tools, technical and business definitions to test SOD effectiveness.
– Test for entire application life cycle
– Test for intra vs cross application
Determine the risk rating based on level of conflict.
4. Mitigation: In this case, the risk cannot be removed completely but only can be minimized. Problem still exists in the system but control is establish to minimize risk,
Conflict by conflict analysis is to document key controls to mitigate a risk. Thus the aim would be to bring risk of conflict of tolerable level.
5. Remediation:
-Tactical role clean up – Are both sides of rights required to an employee to perform his job? Example: Write and execute and modify
-Strategic role clean up – Is the same person responsible for performing a role and monitoring it?
Cleaning of conflict matrix will result in a regulated SOD environment that would be efficient in practice and considers cost only where required.
Source [EY – A risk based approach to segregation of duties] -
Hi Priya,
The EY matrix suggestion sounds like the matrix we used in our ERP class. During that exercise, we had to assign roles and responsibilities to different job titles which did not always naturally fit into one employee’s job title. This required looking at the overall matrix to determine which tasks should be performed by which individuals. Sometimes, you had an individual that performed two tasks that might have crossed into the gray area for SOD. Therefore, complimentary controls such as reviews or authorizations can be implemented/performed to help mitigate the risk of fraud in these gray areas of which, should be tested for design and effectiveness.
-
-
Paul Linkchorst wrote a new post on the site MIS5208 Spring 2017 7 years, 9 months ago
Hello everyone,
My name is Paul Linkchorst and I am a 23-year-old student from the suburbs Northeast of Philadelphia. Growing up I always had a strong interest in technology and business. With this interest, […]
-
Paul Linkchorst posted a new activity comment 7 years, 11 months ago
Hi Yulun,
Interesting answer to this question with the “do your job” mentality. I think one of the key takeaways from this moto is that employees are tasked with performing certain actions or providing certain knowledge. While it is important to create efficiencies, it is not part of one’s job to take shortcuts or circumvent controls. There…[Read more]
-
Paul Linkchorst posted a new activity comment 7 years, 11 months ago
Hi Alex,
If you have the opportunity there is a great book called “The Smartest Guys in the Room” which outlines the various characters involved in the Enron scandal as well as goes into some detail on how the company fell. It is quite long but worth the read and shows how culture and organizational leaders can steer a company toward col…[Read more]
-
Paul Linkchorst posted a new activity comment 7 years, 11 months ago
Sean,
I think many of the c-suite executives do certain actions because their value is directly correlated with the business’s success since most of an executive’s payment comes in stock options. But you do bring a good question. For example, what if a business is losing money due to economic conditions and to make sure the company stays afl…[Read more]
-
Paul Linkchorst posted a new activity comment 7 years, 11 months ago
Hi Said,
To answer your question, there are some guidelines of how to go about reporting a fraud if someone is asking you to hide it. The IMA’s guidelines (Institute of Management Accountants) states that if you are asked to hide a fraud, talk to your supervisor. If the supervisor is involved, move up the chain of command which ultimately e…[Read more]
- Load More