<?xml version='1.0' encoding='UTF-8'?><rss xmlns:atom="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearchrss/1.0/" xmlns:blogger="http://schemas.google.com/blogger/2008" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" version="2.0"><channel><atom:id>tag:blogger.com,1999:blog-7849439406954320626</atom:id><lastBuildDate>Thu, 19 Dec 2024 03:25:15 +0000</lastBuildDate><category>Internal Audit</category><category>Data</category><category>Data Analytics</category><category>Business Process Improvement</category><category>ERP</category><category>Fraud Detection</category><category>GRC</category><category>HRERA</category><category>Internal Audit Report</category><category>MS-Excel</category><category>Machine Learning</category><category>MahaRERA</category><category>Procurement</category><category>Purchase</category><category>RERA</category><category>RERDA</category><category>Real Estate</category><category>Risk</category><category>SOPs</category><category>Spend Management</category><category>Standard Operating Procedures</category><category>UPRERA</category><title>Internal Controls Hubspot</title><description></description><link>https://internalcontrolshubspot.blogspot.com/</link><managingEditor>noreply@blogger.com (Sagar Gupta)</managingEditor><generator>Blogger</generator><openSearch:totalResults>8</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><item><guid isPermaLink="false">tag:blogger.com,1999:blog-7849439406954320626.post-5475177184101734417</guid><pubDate>Wed, 20 Jun 2018 18:16:00 +0000</pubDate><atom:updated>2018-06-20T11:38:04.226-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">SOPs</category><category domain="http://www.blogger.com/atom/ns#">Standard Operating Procedures</category><title>Why is it important for businesses to have SOPs?</title><description>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;Hey Folks,&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;I know many of you would have been waiting for a post update very eagerly and now I should add patiently. Sorry folks for such an undue delay in publishing this post &lt;/span&gt;😊.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;Coming to the post finally, as title defines, the topic of this post is “What is SOP and why every organization should have formally documented SOPs.”&lt;/span&gt;&lt;/div&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSj-X9niy67Z768Rt7smMD6ubCW4Y4PbCyQlSx5Mx38sLxvGWBMseU5gFKhxqNdN7hsqOSLEQchFBmDK5eu0fsmF3rD35MlkuRLBUmIyeq1wZGE3ns8m6mBu723-9NYaz9vd_RFfiYPsJl/s1600/arrows-box-business-533189.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1200&quot; data-original-width=&quot;1600&quot; height=&quot;480&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSj-X9niy67Z768Rt7smMD6ubCW4Y4PbCyQlSx5Mx38sLxvGWBMseU5gFKhxqNdN7hsqOSLEQchFBmDK5eu0fsmF3rD35MlkuRLBUmIyeq1wZGE3ns8m6mBu723-9NYaz9vd_RFfiYPsJl/s640/arrows-box-business-533189.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;Source:&lt;a href=&quot;https://www.pexels.com/photo/arrows-box-business-chalk-533189/&quot; target=&quot;_blank&quot;&gt;www.pexels.com&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;An important way to ensure consistent quality is to be able to standardize processes and laying them down expressively in a formal Standard Operating Procedures (SOPs) document. By ensuring that company’s staff is working in sync with the formally laid SOP, will not only increase its efficiency but will also significantly reduce the possibility of an error. While each person in the organization wants to do things, which are right for the company, there might be a case where they may have a slight variation in their thought to process w.r.t right things. Which in turn means that how things are done is likely to vary from person to person. If a company expects everyone to follow the same set of practices, then it must expressively communicate these practices to everyone through a formal written document.&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;For those who have not experienced working in line with formal SOPs, I’ve put together an article to explain what Standard Operating Procedure is and why an organization should have them.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;
&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;A standard operating procedure, or SOP, can be described as a step-by-step instruction drafted by the management to assist staff in performing the day to day tasks. SOPs are made to attain competency, to maintain quality standards and to ensure a degree of consistency in practice.&lt;/span&gt;&lt;/div&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;
&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;SOP is a very specific document whose content may not only vary from company to company but may also depend upon the process for which it is being drafted, the level of the company, the involvement of management, the regulatory framework etc.&lt;/span&gt;&lt;/div&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;
&lt;/span&gt;&lt;/span&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;color: #0070c0;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;Why Should Organization have SOPs?&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;SOPs is a great tool to ensure that an organization has a proper quality system in place, to keep a check on the efficiency of staff and to manage the costs. SOPs can be regarded as the bible for the employees which they can refer to, in case of any confusion or lack of clarity in any task or process. Following are some of the benefits which organizations can get by introducing SOPs-&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;b&gt;&lt;span style=&quot;color: #0070c0;&quot;&gt;&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;Establishes a control system.&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;When a business wants to maintain a standardized quality of its product or service to meet its customer’s expectation, standardized procedures can play a key role in ensuring the same. SOPs ensure that the staff adheres to the defined flow to reduce the possibility of skipping any key step impacting the product’s quality. Religiously followed SOPs helps in ensuring that the product or service is of set quality standard and helps in maintaining the integrity of the product.&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;b&gt;&lt;span style=&quot;color: #0070c0;&quot;&gt;&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;Simplifies Performance Management&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;SOPs can assist managers to assess an individual’s performance as SOPs can be used to develop the performance parameters. Staff who has performed in compliance with the SOPs knows what is expected of him/her and indicates towards their efficiency.&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;Thus, SOPs help manager to set up a benchmark for employees and those employees who surpass these benchmarks can be appraised.&lt;/span&gt;&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;b&gt;&lt;span style=&quot;color: #0070c0;&quot;&gt;&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;Ensures Continuity of process with least interruption&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;SOPs also plays a pivot role in transforming an organization from a people driven organization to process driven organization. Imagine a scenario wherein all data pertaining to a process was stored in an employee’s system. When he leaves the organization, the data goes with him/her and even if data is there, no other employee is aware of the data or what he/she needs to do with it. Thus, in the absence of any formal SOP documents, such scenarios can be avoided. &lt;/span&gt;&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;If there has been a proper SOP of roles performed by terminated employees and what all data will be generated in the process, even if an employee leaves without proper handover, the incoming employee can always refer to the SOP document to know what he is required to do &amp;amp; how to perform a task.&lt;/span&gt;&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;b&gt;&lt;span style=&quot;color: #0070c0;&quot;&gt;&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;Introduces uniformity across branches&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;If the company is conducting its business from several branches based at different geographical locations, then ready-made SOPs can prove to be a handy tool in ensuring uniformity in how a task will be conducted across different branches.&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;This will also reduce the learning curve period of an employee who is getting transferred from one location to another location, within the same profile.&lt;/span&gt;&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;b&gt;&lt;span style=&quot;color: #0070c0;&quot;&gt;&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;Acts as a training module for staff&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;Companies can use SOPs to provide standardized training to staff who are new to the organization, to explain what they are supposed to do and how are they supposed to perform a task.&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;Hope with this article, one can understand the importance of SOPs in an organization and how you can use it to standardize practices across different geographical locations and to increase &lt;/span&gt;the &lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;efficiency of staff in your business.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;&lt;br style=&quot;background-attachment: inherit !important; background-clip: inherit !important; background-image: inherit !important; background-origin: inherit !important; background-position: inherit !important; background-repeat: inherit !important; background-size: inherit !important; text-align: start; white-space: pre-wrap;&quot; /&gt;
&lt;b&gt;&lt;span style=&quot;color: #0070c0;&quot;&gt;&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;&lt;i&gt;Happy Learning!!!&lt;/i&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;&lt;b&gt;&lt;span style=&quot;color: #0070c0;&quot;&gt;&lt;span style=&quot;text-align: start; white-space: pre-wrap;&quot;&gt;&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</description><link>https://internalcontrolshubspot.blogspot.com/2018/06/why-is-it-important-for-businesses-to-have-SOPs.html</link><author>noreply@blogger.com (Sagar Gupta)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjSj-X9niy67Z768Rt7smMD6ubCW4Y4PbCyQlSx5Mx38sLxvGWBMseU5gFKhxqNdN7hsqOSLEQchFBmDK5eu0fsmF3rD35MlkuRLBUmIyeq1wZGE3ns8m6mBu723-9NYaz9vd_RFfiYPsJl/s72-c/arrows-box-business-533189.jpg" height="72" width="72"/><thr:total>8</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-7849439406954320626.post-6462337186175174313</guid><pubDate>Fri, 08 Jun 2018 09:01:00 +0000</pubDate><atom:updated>2019-10-06T03:14:08.538-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Internal Audit</category><title>How Internal Audit can Add Value to your Business</title><description>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;There is no doubt that businesses are seeing new heights in India right now.&amp;nbsp;India has emerged as the fastest-growing major economy in the world as per the Central Statistics Organization (CSO) and International Monetary Fund (IMF). India’s GDP is estimated to have increased 6.6 percent in 2017-18 and is expected to grow 7.3 percent in 2018-19*.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;While several factors contribute towards the success of businesses ranging from favorable government policies to right people being part of organizations to standardized business practices, one such practice that is highly recommended is getting an internal audit on a regular basis. Over the years, several organizations have used it as an instrument to maintain and enhance the quality of their goods or services to meet customer expectation. If your organization does not have an internal audit function, then it is a worthwhile option to think about.&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt; &lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: 11.25pt; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;Why should you consider internal audit for your business?&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;Well, an internal audit function forces you to have a deeper look into your business processes and finances to ensure that they are in proper order and also are there any emerging risks that business should address or not.&amp;nbsp; While it is very normal for the management to be complacent and think that everything is running smoothly and is in proper order but there might be a case where, by the time you realize that it was not true, it’s too late.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: normal; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;background-color: white;&quot;&gt;In today’s volatile business environment, where businesses are facing a new challenge every day than whether it be in form of change in government regulation or new operational regulations like GDPR or change in labour related compliances or change in consumer expectation etc.&amp;nbsp;An internal audit function always ensures that businesses are &lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;meeting their responsibilities and that the organization’s staff is also working towards organization’s goal.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;b&gt;&lt;span style=&quot;border: 1pt none; padding: 0in;&quot;&gt;How can an internal audit help business?&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: #002060;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: 11.25pt; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;Whether you have a BPO or Manufacturing Facility, an internal audit can help as follow:&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;b&gt;&lt;span style=&quot;border: 1pt none; padding: 0in;&quot;&gt;Help identify any financial discrepancies&amp;nbsp;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: #002060;&quot;&gt;– All of us will unanimously agree to the fact that the main objective to undertake an internal audit is to look deeply into financial transactions and records of the company, to rule out the possibility of any malpractice by any person or group of individuals. An internal audit may help you spot duplicate posting of same purchase invoice or identify any dummy vendor or employee in the system, among many other malpractices which might be prevalent right under your nose.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: normal; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;b style=&quot;background-color: white;&quot;&gt;&lt;span style=&quot;border: 1pt none; padding: 0in;&quot;&gt;Ensuring adherence to standard operating procedures&amp;nbsp;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;background-color: white;&quot;&gt;– Well there is no doubt on the fact that management of any organization lays high emphasis on the adherence of Standard Operating Procedures by its staff, and would like to identify instances where such policies or procedures are being by-passed by its employees. An internal audit function can not only help you to ensure compliance of such policies &amp;amp;&lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;&amp;nbsp;procedures,&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;remind the staff of its importance if they are not &lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;but can also assist in updating the procedure or benchmarking them with industrial practices.&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: normal; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;b style=&quot;background-color: white;&quot;&gt;&lt;span style=&quot;border: 1pt none; padding: 0in;&quot;&gt;Help attain Economies&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;background-color: white;&quot;&gt;&amp;nbsp;– Another great output which business can generate by using internal audit function is to attain economy of scale in every business process. A good internal audit function will show you where you need to invest more in resources &lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;and&amp;nbsp;&lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;where resources are lying idle or are being under-utilized. It will also help in identifying any redundant exercise which is being performed in any process, which is adversely impacting the working capital of the company&lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;.&lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: normal; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;b style=&quot;background-color: white;&quot;&gt;&lt;span style=&quot;border: 1pt none; padding: 0in;&quot;&gt;Ensuring business is fully compliant &lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;background-color: white;&quot;&gt;– Another grave area for the management of any company is to be sure that they are fully compliant with all the legal and&lt;/span&gt;&lt;span style=&quot;background-color: white;&quot;&gt;&amp;nbsp;regulatory requirements of the land where they are operating. With so many laws ranging from company structure to tax compliances to labor welfare to industrial requirements, it is very difficult for any company to be sure that at any point of time that they are fully compliant to all these requirements. This is where an internal audit function can help you to be certain that your company is adhering to all the laws applicable.&lt;/span&gt;&lt;b style=&quot;background-color: white;&quot;&gt;&lt;span style=&quot;border: none windowtext 1.0pt; mso-border-alt: none windowtext 0in; padding: 0in;&quot;&gt;&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraph&quot;&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;b&gt;&lt;span style=&quot;border: 1pt none; padding: 0in;&quot;&gt;Greater Coverage&amp;nbsp;&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: #002060;&quot;&gt;– Many times, you come across the remark from business owners that “why should we have an internal audit, while we already have a statutory audit in the company”. Well, I have always told them that the scope of the statutory audit is restricted to financial statements of the organization, while through internal audit, you can get those areas audited where you have concerns over and use it in a way you want to. &amp;nbsp;Thus, you are always in command and can amend the scope of the audit as per the changing the environment of business&lt;b&gt;&lt;span style=&quot;border: none windowtext 1.0pt; mso-border-alt: none windowtext 0in; padding: 0in;&quot;&gt;.&lt;/span&gt;&lt;/b&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; line-height: normal; margin-bottom: 0.0001pt; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;b&gt;&lt;span style=&quot;border: 1pt none; padding: 0in;&quot;&gt;How to Effectively Deploy Internal Audit&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: #002060;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: 11.25pt; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;In certain cases, we have also seen while businesses see internal audit as a great tool but don’t exactly know how to use it. Well, I totally understand the situation if you have never got it done in the past. In such a situation, I generally advise companies to outsource it to an external professional firm or to hire some expert who has experience of performing it. &lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;background: white; line-height: normal; margin-bottom: 11.25pt; text-align: justify; vertical-align: baseline;&quot;&gt;
&lt;span style=&quot;color: #002060;&quot;&gt;&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;To conclude I would like to say that an internal audit is a fantastic tool to not only help business prosper but can also help in identifying new opportunities. Not only will it ensure that you are working in a best possible manner, but will also help you grow in future by identifying emerging risks and opportunities.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;color: #0b5394; font-family: &amp;quot;helvetica neue&amp;quot; , &amp;quot;arial&amp;quot; , &amp;quot;helvetica&amp;quot; , sans-serif;&quot;&gt;&lt;i&gt;&lt;b&gt;Happy Auditing!!!&lt;/b&gt;&lt;/i&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #002060; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif; font-size: x-small;&quot;&gt;*Source: &lt;a href=&quot;https://www.ibef.org/economy/indian-economy-overview&quot;&gt;https://www.ibef.org/economy/indian-economy-overview&lt;/a&gt; (Last accessed on 07th June 2018)&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;hgmarugothicmpro&amp;quot; , sans-serif; font-size: 7pt;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>https://internalcontrolshubspot.blogspot.com/2018/06/how-internal-audit-can-add-value-to-business.html</link><author>noreply@blogger.com (Sagar Gupta)</author><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-7849439406954320626.post-3093013066321652857</guid><pubDate>Thu, 31 May 2018 16:57:00 +0000</pubDate><atom:updated>2018-05-31T11:03:21.085-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Data</category><category domain="http://www.blogger.com/atom/ns#">Data Analytics</category><category domain="http://www.blogger.com/atom/ns#">MS-Excel</category><title>How to Sanitize Data in Excel...</title><description>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;span style=&quot;background-color: white; color: #343434; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Data is the mainstay of any sort of analysis that needs performance in Excel. And when it comes to data, there are loads of challenges that one can face – be it Spelling Errors, tenacious irregular spaces, unsolicited precedes, in appropriate cases, unrequired characters &amp;amp; irregular cell merge, all these in an excel spreadsheet give us all a lot of stress at times. On top of this, there are more such issues which one can face while performing analysis on any data.&lt;/span&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOqSH08GTrfrkPO5Z-MupiMIo2e1yKq8tZxlsXHPC-CEjh4yTMf_JsoVlbn711WC1fyMjTcS9IUx_8K5Hw2z5Tsy8vxHFUd7kpkDcMVv7w-E3NtlnF5VFYhyphenhyphenDnFZJWOq7b447mzRS8kt77/s1600/desk-glasses-laptop-3061.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1067&quot; data-original-width=&quot;1600&quot; height=&quot;424&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOqSH08GTrfrkPO5Z-MupiMIo2e1yKq8tZxlsXHPC-CEjh4yTMf_JsoVlbn711WC1fyMjTcS9IUx_8K5Hw2z5Tsy8vxHFUd7kpkDcMVv7w-E3NtlnF5VFYhyphenhyphenDnFZJWOq7b447mzRS8kt77/s640/desk-glasses-laptop-3061.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;/div&gt;
&lt;span style=&quot;background-color: white; color: #343434; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;background: white; color: #343434; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;In this post, I will be sharing few very simple ways, which one may use to sanitize data in excel-&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;background: white; color: #343434; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;#1. Getting Rid of Extra Spaces&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; imageanchor=&quot;1&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;It is highly difficult for anyone to identify extra spaces in excel spreadsheet. While some of you might be able to identify extra spaces in between text or number but it is most difficult to identify extra spaces after text or number. Thankfully, there is a simple &amp;amp; clean way to get rid of this issue in excel. Just Apply TRIM Function on the data where you see extra spaces and it will remove all such spaces.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Function - =TRIM(Text)&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;#2. Converting Number stored as Text back to Number&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;This is another very common issue that one faces, especially when data is imported from a database or any application, where number gets converted into text format due to which user can not perform any numeric calculation or analysis. The simplest way to convert the number from text format to number format is-&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin-left: 45.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;a.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Select the data which is to be converted to Number Format&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 45.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;b.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Press Ctrl +1&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 45.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;c.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;A “Format Cell” Dialogue box will pop up.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 45.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;d.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Go to “Number” option in Number Tab&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;mso-list: l1 level1 lfo2; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-left: 45.0pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;e.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Press “OK”&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;#3. Removing unnecessary blanks&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Blank Cells can really cause a lot of confusion if they are not handled at the very beginning. I am sure even you have faced problem caused by blank cells in data. Here is a smart way to identify all blank cells at one go and replace them with any character or value.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin-left: 49.5pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;a.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Select the data to be analyzed.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 49.5pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;b.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Press Ctrl + G&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-left: 49.5pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;c.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Click on Special Button at left bottom.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-left: 49.5pt; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;d.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Select “Blank” option in Go To Special &amp;amp; Press “OK”.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;This will highlight all blank cells in data. Then it is up to you to replace them with any value like “Not Applicable” or “Nil”. Then, press &lt;b&gt;Ctrl + Enter.&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;#4. Merging Columns&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;background: white; color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 10.5pt; line-height: 107%;&quot;&gt;Another very common task that I perform after extracting data from an external database is to merge content in two or more columns into one. Imagine a scenario where you have downloaded an employee master, wherein employee first name &amp;amp; the last name is coming in two different column &amp;amp; now you want to identify cases where two employees have the same name. For this, you will be required to merge both these columns to generate a new column containing employee first &amp;amp; Last Name. Following are most used ways to merge cells or columns-&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraph&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l3 level1 lfo3; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;a.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Use CONCATENATE Function to perform this task.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraph&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l3 level1 lfo3; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Function - =CONCATENATE(First Name, “ “, Last Name)&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l3 level1 lfo3; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;b.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Use &amp;amp; for merging two cells&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Function - =First Name&amp;amp;” “&amp;amp;Last Name&lt;/span&gt;&lt;/i&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraph&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .25in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l3 level1 lfo3; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;c.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Use CONCAT Function to perform this task.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Function - =CONCAT(First Name, “ “, Last Name)&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;#5. Splitting text into Columns&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;background: white; color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 10.5pt; line-height: 107%;&quot;&gt;Just like merging text of two or more columns into one, at times I am also required to split text of one column into two or more columns. Imagine a situation where you have downloaded an employee master, wherein employee last &amp;amp; the first name is coming in one column separated by a blank or comma &amp;amp; you want it to be in order where employee first name is followed by his/her last name. For this, you will be required to split text of one column to two columns using text to column function &amp;amp; then merge the two columns in desired order by using above-stated functions as stated in point 4. &lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Use &lt;b&gt;Text to Column Function&lt;/b&gt; to split text. This is one of my favorite function in excel and is very handy at times. So, without wasting time, let us understand its use-&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .75in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.5in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;i.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Select the cell or column whose content you want to split&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .75in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.5in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;ii.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Go to Data &amp;gt;&amp;gt; Text to Columns&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .75in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.5in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;iii.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;A Text to Columns Wizard will open. Click &lt;b&gt;Delimited&lt;/b&gt; option &amp;amp; press &lt;b&gt;Next&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .75in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.5in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;iv.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;background: white; color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;&quot;&gt;Check&amp;nbsp;&lt;b&gt;Comma&lt;/b&gt;, and clear the rest of the boxes, or check&amp;nbsp;&lt;b&gt;Comma&lt;/b&gt;&amp;nbsp;and&amp;nbsp;&lt;b&gt;Space&lt;/b&gt;&amp;nbsp;if that is how your text is split (&lt;b&gt;Woods, Alan&lt;/b&gt;, with a comma and space between the names). You can see a preview of your data in the&amp;nbsp;&lt;b&gt;Data preview&lt;/b&gt;&amp;nbsp;window. Click &lt;b&gt;Next&lt;/b&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .75in; margin-right: 0in; margin-top: 0in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.5in;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;v.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;background: white; color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif;&quot;&gt;In this step, select the format for your new columns. Press &lt;b&gt;Finish.&lt;/b&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .25in; margin-right: 0in; margin-top: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;#6. Changing the Case of Text&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;background: white; color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 10.5pt; line-height: 107%;&quot;&gt;How often we come across data where text cases are improper &amp;amp; irregular. Using excel case function, one can quickly convert text to any of these case formats.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;background: white; color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 10.5pt; line-height: 107%;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;LOWER Function -&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;background: white; color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 10.5pt; line-height: 107%;&quot;&gt;Converts all uppercase letters in a text string to lowercase letters&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Function – =LOWER(Text)&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/b&gt; &lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;UPPER Function -&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;background: white; color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 10.5pt; line-height: 107%;&quot;&gt;Converts all lowercase letters in a text string to uppercase letters&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Function – =UPPER(Text)&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/b&gt; &lt;a href=&quot;https://www.blogger.com/blogger.g?blogID=7849439406954320626&quot; style=&quot;clear: right; float: right; margin-bottom: 1em; margin-left: 1em;&quot;&gt;&lt;/a&gt;&lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;PROPER Function -&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;color: #2f2f2f; font-family: &amp;quot;segoe ui&amp;quot; , sans-serif; font-size: 10.5pt; line-height: 107%;&quot;&gt; Capitalizes the first letter in a text string and any other letters in the text that follows any character other than a letter. Converts all other letters to lowercase letters.&lt;span style=&quot;background: white;&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;color: #0070c0; font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif;&quot;&gt;Function – =PROPER(Text)&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;background: white; color: #343434; font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt; &lt;span style=&quot;background: white; color: #343434; font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;There are many other techniques to clean data in Excel, Which I will be sharing in my future posts. &lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;background: white; color: #343434; font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt; &lt;span style=&quot;background: white; color: #343434; font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Keeping Watching this space for more interesting tips &amp;amp; techniques…&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;background: white; color: #343434; font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Happy Learning Folks!!!&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;background: white; color: #343434; font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Also Read: &lt;/span&gt;&lt;/i&gt;&lt;b&gt;&lt;i&gt;&lt;span style=&quot;background: white; color: #4c4c4c; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 107%;&quot;&gt;Excel Formulas that Every Excel User Should Know (&lt;a href=&quot;https://casagargupta.blogspot.com/p/resources.html&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;)&amp;nbsp;...&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;b&gt;&lt;i&gt;&lt;span style=&quot;background: white; color: #4c4c4c; font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 107%;&quot;&gt;&lt;/span&gt;&lt;/i&gt;&lt;/b&gt;&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
</description><link>https://internalcontrolshubspot.blogspot.com/2018/05/how-to-sanitize-data-in-excel.html</link><author>noreply@blogger.com (Sagar Gupta)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOqSH08GTrfrkPO5Z-MupiMIo2e1yKq8tZxlsXHPC-CEjh4yTMf_JsoVlbn711WC1fyMjTcS9IUx_8K5Hw2z5Tsy8vxHFUd7kpkDcMVv7w-E3NtlnF5VFYhyphenhyphenDnFZJWOq7b447mzRS8kt77/s72-c/desk-glasses-laptop-3061.jpg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-7849439406954320626.post-4560456081685723432</guid><pubDate>Sun, 27 May 2018 05:43:00 +0000</pubDate><atom:updated>2018-05-26T22:44:29.221-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Procurement</category><category domain="http://www.blogger.com/atom/ns#">Purchase</category><category domain="http://www.blogger.com/atom/ns#">Spend Management</category><title>Tail End Spend Management - Unlock the Value</title><description>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;While Tail end spend Management has become one of the priorities for all big organizations across the world, in India, it is yet to be recognized as a tool for a cost-saving opportunity in procurement. Traditionally, Organizations Procurement division has been focusing on identification of cost saving opportunities &amp;amp; management of all A-class spend i.e. Top 80% of spend representing only 20% of the supplier base. In the process of managing A-class Suppliers, the companies have left the horde of C-class Suppliers forming the tail end of the spend unmanaged.&lt;/span&gt;&lt;/div&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjliS0Rd_8hTr_N0aQlj910qZh5327t6mOqluPiNnPeRf3187udemoGgEDqMfVfUFb8RA_Gdpe1giufC_sP56mLpczOgSPhyuRNuDgGjgbMKzw1lQ7Dv3XUkbAHt8nYsZn02S1h14tSewxu/s1600/Spend+Management.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;879&quot; data-original-width=&quot;1600&quot; height=&quot;348&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjliS0Rd_8hTr_N0aQlj910qZh5327t6mOqluPiNnPeRf3187udemoGgEDqMfVfUFb8RA_Gdpe1giufC_sP56mLpczOgSPhyuRNuDgGjgbMKzw1lQ7Dv3XUkbAHt8nYsZn02S1h14tSewxu/s640/Spend+Management.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;span style=&quot;font-size: xx-small;&quot;&gt;Source: www.pexels.com&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;It is difficult to find any company managing their full spend properly &amp;amp; strategically. Probably in last decade or so, due to increasing transparency &amp;amp; recognition of procurement as a hardcore strategic activity, the Companies have been able to manage their A-class procurement forming 70 to 80% of their total spend. Now, these companies have started planning to shift efforts on managing the remaining spend which is forming 20-30% of the total Spend, with the following objectives:&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;a.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Increasing visibility/ Transparency of low value spend.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;b.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Elimination of transaction cost by reduction in many transactions.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;c.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Reduction of procurement team’s cost.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;d.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Process improvement &amp;amp; data quality improvement.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;e.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Safeguarding against business risk by increasing contract coverage.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l1 level1 lfo1; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;f.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Managing eccentric spends &amp;amp; preventing frauds.&lt;/span&gt;&lt;br /&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Convolution of Tail End Spend Management&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;However, as companies are trying to manage the tail spend, they have realized that they can’t use the same traditional tactics as they were using for A-class spend.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Another complexity of tail spend is that there are much more suppliers involved than the suppliers involved in A-class spend. The spend is very diversified &amp;amp; there is a lot of individual buying happening involving end users from Accounts, HR and so on, who are not professional buyers. Until the total cost is less than the defined upper limit then these individual buyers can place orders with whom so ever &amp;amp; however they want.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Apart from the above-mentioned challenges, another challenge involved in managing tail spend is weak data quality, wherein either the name of suppliers is incorrect or item description is incorrect/incomplete or weak data capturing resulting in duplication of data, the presence of junk characters etc. &lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;The risk involved in Tail End Spend&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;With unorganized tail end spend, nobody generally considers aspects like - who the supplier is, what price is he charging, the credentials of suppliers etc. exposing them to many risks. The following can be some of the risks of unplanned tail end spend:&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;a.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;u&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Negative Impact on Company’s Reputation&lt;/span&gt;&lt;/u&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Unorganized Spend might result in companies doing business with the suppliers that violate legal provisions and are not complying with CSR principles which will bring a negative impact on the company’s reputation.&lt;u&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;b.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;u&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Procurement of items at the higher rate.&lt;/span&gt;&lt;/u&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Since most of the tail end spend is done by the end users, who are not professional buyers, there is a risk of them paying more for a material as usually they do not go into the details of pricing and are only concerned to ensure that the purchase price is less than the threshold price, as approved.&lt;u&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; mso-list: l0 level1 lfo2; text-align: justify; text-indent: -.25in; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;c.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;u&gt;&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Best Practice Risk&lt;/span&gt;&lt;/u&gt;&lt;/div&gt;
&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;line-height: 150%; margin-left: .25in; mso-add-space: auto; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;When companies allow end users from distinct functions of the business to buy from whomever they want, there is a possibility that they will just buy from a personal connection, or from a supplier with whom they have a historic relationship. This might result in the company paying more for an item or breaching of fair practice regulations.&lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; text-align: justify; text-justify: inter-ideograph;&quot;&gt;
&lt;span style=&quot;color: #855309; font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 150%;&quot;&gt;Companies who are failing to address these convolutions and risks involved are leaving a lot more on the table than they think.&lt;u&gt;&lt;/u&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>https://internalcontrolshubspot.blogspot.com/2018/05/tail-end-spend-management-unlock-value.html</link><author>noreply@blogger.com (Sagar Gupta)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjliS0Rd_8hTr_N0aQlj910qZh5327t6mOqluPiNnPeRf3187udemoGgEDqMfVfUFb8RA_Gdpe1giufC_sP56mLpczOgSPhyuRNuDgGjgbMKzw1lQ7Dv3XUkbAHt8nYsZn02S1h14tSewxu/s72-c/Spend+Management.jpg" height="72" width="72"/><thr:total>1</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-7849439406954320626.post-4687608311507849957</guid><pubDate>Tue, 22 May 2018 15:14:00 +0000</pubDate><atom:updated>2019-10-06T03:03:58.634-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Internal Audit</category><category domain="http://www.blogger.com/atom/ns#">Internal Audit Report</category><title>Steps Involved in Internal Audit</title><description>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;Hi,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;This is the first post in the series of posts where I will be sharing my experience on &lt;/span&gt;&lt;b&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;“Different Aspects of Internal Audit Assignment”&lt;/span&gt;&lt;/b&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;. In this series of posts, I will be discussing various aspects like steps of internal audit, reporting etc. and how businesses can utilize internal audit as a strategic tool to add more value to the business rather than restricting its utility to the identification of any financial mis-reporting. So, I request you all kindly subscribe to this blog to get notified as &amp;amp; when I post more articles for sharing knowledge and experiences with you.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;While some companies have an in-house team of professionals who conduct the internal audit for the company, many other companies believe in outsourcing internal audit function. Thereby maintaining the independence of the auditors &amp;amp; also reducing the possibility of any biases or influence by or over internal audit function. Internal audit has grown over the years to not only be seen as a function to ensure fulfillment of regulatory compliances and/or accuracy of financial records but to a more strategic function to evaluate the performance of the business &amp;amp; manage risks.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfbPmwohrfj6H45jhGoQduCVliMm-qzZnVG6wfSkOKmS0Pc9PfWqLLRU8u2iidUU0TLuxx4IfzfWl3fx4VHmYxxgixyjGxsC6tjm900hjq0Fp1Fmppld7srioaQEF2Jo4fwg1Mf9nAnLyA/s1600/apple-class-conference-7102.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1067&quot; data-original-width=&quot;1600&quot; height=&quot;426&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfbPmwohrfj6H45jhGoQduCVliMm-qzZnVG6wfSkOKmS0Pc9PfWqLLRU8u2iidUU0TLuxx4IfzfWl3fx4VHmYxxgixyjGxsC6tjm900hjq0Fp1Fmppld7srioaQEF2Jo4fwg1Mf9nAnLyA/s640/apple-class-conference-7102.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;span style=&quot;font-size: xx-small;&quot;&gt;www.pexels.com&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif; font-size: 12pt;&quot;&gt;Over the years, often I have come across people who ask me, “How should they perform an internal audit- to add value to the business by enhancing performance and/ or managing risks”. And I have always told them that it is difficult to generalize steps in internal audit function as it depends on several factors like scope of work, industry type, how big is the organization, periodicity of audit, what all internal controls have been defined, what all documents are made available during audit etc. Having said that, following are some of the key steps involved in internal audit-&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;1.&amp;nbsp;&amp;nbsp;&amp;nbsp; Initial briefing Meeting&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;This is the preliminary step of any internal audit, where the company and management lay down the broad scope of work and expectations from internal audit function. The scope does not need to be limited to providing the management with assurance over the controls implemented by management and can head towards a ‘consultancy’ role, providing strategic support to the management and company.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;2.&amp;nbsp;&amp;nbsp;&amp;nbsp; Planning an internal audit&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;Any internal audit function which aims to add value to the organization shall commence the internal audit by preparing a proper strategy, considering controls deployed by the management and the risk environment of the organization. Audit plan so prepared should be flexible enough to identify any new emerging risk. If any internal audit function wants to be a strategic advisor to the management, then it should be aware of the risk appetite, capacity &amp;amp; tolerance and same shall be covered in the internal audit plan.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;3.&amp;nbsp;&amp;nbsp;&amp;nbsp; Conducting Fieldwork&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;While commencing any internal audit review, the internal audit function should be aware of “How a Process to be reviewed Works” and “What all controls have been deployed by the Management”. Post answering such questions, an internal audit program should be developed stating what all checks will be reviewed by the auditor. While conducting an on-site review, the auditor can use techniques like an interview for gaining information and/or evidence to form an opinion. There are several sub-steps involved in this step, some of which are highlighted below-&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Audit Program Preparation&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Scheduling Audit Testing&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Analytical Reviews&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Document Handling&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Interviewing Personnel&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;The internal audit function must analyze and assess the facts drawn from the internal audit evidence, obtained during the review, to decide upon the efficiency and effectiveness of structures, processes, and controls. The internal audit function should also consider the efficacy of the structures, processes, and controls that are in place.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;4.&amp;nbsp;&amp;nbsp;&amp;nbsp; Document Findings and Evidence&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;As the name suggests, in this step one shall document the findings noted during their review exercise and shall highlight any policy violation or financial misrepresentation. This shall also include any scope of process improvement or lack of control in any of the process or activity.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;5.&amp;nbsp;&amp;nbsp;&amp;nbsp; Preparation of Audit Report&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;If you ask me, this is the most crucial step of any internal audit assignment as the report is the document basis which is decided whether an audit was conducted properly, and did it cover all major risks as identified by the management and the audit committee. A good report should very clearly state the following-&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Title Page&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Index (Recommendatory)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Report Distribution List&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Background &lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Executive Summary&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Scope of Work&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Audit Limitations&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Audit Methodology (Recommendatory)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;•&amp;nbsp;&amp;nbsp;&amp;nbsp; Detailed Audit Findings&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;An internal audit report writing is the skill that needs to be discussed in a more detailed manner and I will be doing this in my future posts. So Please keep following this space as I will be explaining the content of each &amp;amp; every bullet point as stated above.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;6.&amp;nbsp; &amp;nbsp;&amp;nbsp;Closure Meeting&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;
&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;Internal audit report which was prepared &amp;amp; presented to the Management &amp;amp; the concerned stakeholders is discussed in this meeting to assess whether findings, as highlighted in the report, are correct and if they are then future action plan is defined. Basically, how the organization will implement the recommendations made by the auditor in his report is decided and a timeline within which action will be taken is decided.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;Auditor while doing any follow-up audit will have to check the implementation of Future Action Plan.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-size: 12pt; line-height: 107%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;trebuchet ms&amp;quot; , sans-serif;&quot;&gt;Ultimately, any organization can be successful only if it is able to deliver the product or services to its clients in a smooth, seamless manner. Internal SOPs &amp;amp; management directives are how an organization tries to establish a uniform practice across processes and domain to ensure smooth delivery of quality product or service. Internal audit is one such tool that organizations should use to ensure their business achieves its ultimate objective by identifying all risks and recommending measures to mitigate such risks.&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif; font-size: 12.0pt; line-height: 107%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>https://internalcontrolshubspot.blogspot.com/2018/05/steps-involved-in-internal-audit-process.html</link><author>noreply@blogger.com (Sagar Gupta)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfbPmwohrfj6H45jhGoQduCVliMm-qzZnVG6wfSkOKmS0Pc9PfWqLLRU8u2iidUU0TLuxx4IfzfWl3fx4VHmYxxgixyjGxsC6tjm900hjq0Fp1Fmppld7srioaQEF2Jo4fwg1Mf9nAnLyA/s72-c/apple-class-conference-7102.jpg" height="72" width="72"/><thr:total>2</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-7849439406954320626.post-4055100955605676550</guid><pubDate>Fri, 11 May 2018 18:12:00 +0000</pubDate><atom:updated>2018-05-14T10:01:25.846-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">Business Process Improvement</category><category domain="http://www.blogger.com/atom/ns#">Data</category><category domain="http://www.blogger.com/atom/ns#">Data Analytics</category><category domain="http://www.blogger.com/atom/ns#">ERP</category><category domain="http://www.blogger.com/atom/ns#">Fraud Detection</category><category domain="http://www.blogger.com/atom/ns#">GRC</category><category domain="http://www.blogger.com/atom/ns#">Internal Audit</category><category domain="http://www.blogger.com/atom/ns#">Machine Learning</category><category domain="http://www.blogger.com/atom/ns#">Risk</category><title>How Data Analytics is revolutionising internal audit... </title><description>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div style=&quot;margin-top: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Hi Everyone!&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;margin-top: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Welcome, the topic of this post is “How Data Analytics is Proving to be a Game-changer for Internal Audit”. All of us, who have been performing internal audits or are getting it done, would vouch for the fact that it has evolved enormously over the years. Internal audit, which was perceived as a process to review financial records in a more detailed manner, when compared with statutory audit, has now evolved with times, to play a more strategic role by laying down a cohesive approach towards risk management. With the evolution, there has been a clear shift from a document-based audit to a data-based audit, whereby internal audit function is deploying modern technologies and techniques like data analytics to create more value for businesses.&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;float: left; margin-right: 1em; text-align: left;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNNqz-nVaSKLx0ZUD5yhDdV98Oob-9Pk_rzHv-w8UgMXLIZbgwSASQjogyJCV2UolPPGO_WQ-z_iLYIZ3VtSf0K5s6dDdWxujucFpjSTyz4jMs5otZ8UqtrN7mDOV_i8ed5cRhz_KZArcn/s1600/charts-computer-data-669615.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;1060&quot; data-original-width=&quot;1600&quot; height=&quot;420&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNNqz-nVaSKLx0ZUD5yhDdV98Oob-9Pk_rzHv-w8UgMXLIZbgwSASQjogyJCV2UolPPGO_WQ-z_iLYIZ3VtSf0K5s6dDdWxujucFpjSTyz4jMs5otZ8UqtrN7mDOV_i8ed5cRhz_KZArcn/s640/charts-computer-data-669615.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;span style=&quot;font-size: xx-small;&quot;&gt;Source:&amp;nbsp;www.pexels.com&lt;/span&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;When we talk about data, it is something which is everywhere, from a mouse click to a tap on the mobile app, to a phone call, to a punch-in at office gate. The reason for the availability of such huge volume of data can be attributed to the change in the mindset of the consumers &amp;amp; easy accessibility of technology to them. Consumers, where some years ago, were not willing to share their personal details, are now with a change in their aspirations &amp;amp; needs not worried about sharing them. Thus, giving birth to the huge volume of data, which businesses are using to understand the customer need and the changes in their needs. Taking advantage of the availability of such huge volume of data &amp;amp; applying data analytics, internal audit function can create more value for businesses than ever before by providing valuable business insights, a greater degree of assurance and predicting emerging risks. Given below are some of the advantages that internal audit function can reap by using data analytics-&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Increase in Effectiveness of Internal Audit.&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;By using data analytics, internal auditors can audit the entire population instead of auditing a sample of transactions to form a judgment. Data analytics also empowers auditor to conduct several audit checks just by applying a program to generate exceptions which auditor needs to check in detail.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt; Enhancing the Efficiency of Audit Function.&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Data Analytics also help in increasing efficiency of an audit function, as an internal auditor can always re-use the same data analytics script for periodical reviews, saving a lot of time &amp;amp; effort on the part of the auditor. Auditor can deploy the same in some other areas, resulting in higher effectiveness as well.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt; Mitigation of Risk &amp;amp; Fraud Detection.&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Data Analytics also enables internal audit function to identify trends, that are appearing in datasets over a period of time indicating a potential threat to the organization. Data analytics also enables auditors to identify &amp;amp; uncover any fraudulent activities that are happening in the organization. Thus, audit function can create a greater value for the organization, by using data analytics, whereby they can ensure the organization is prepared for emerging risks and is secure against any type of fraud.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Greater Assurance.&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Data Analytics also helps in delivering a higher sense of assurance to all stakeholders in relation to operations of the organization and ensuring that company does have proper controls in place to mitigate emerging risks in the organization. The higher assurance is achieved by the fact that internal audit can virtually review entire population to identify risks and frauds, by using data analytics.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;b style=&quot;text-indent: -0.25in;&quot;&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Greater Focus on Strategic Risk&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;By deploying Data Analytics &amp;amp; combining it with machine learning, internal audit function can automate the routine audit checks of similar transactions and can shift their focus towards the strategic risks that might challenge organizations in future.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;h2 style=&quot;line-height: 115%; margin-top: 0in; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;color: #6fa8dc; font-size: small;&quot;&gt;CASE- STUDY&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/b&gt;&lt;/h2&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Given below is the case study where internal audit function deployed Data Analytics to identify potential risk, which otherwise would have been a real daunting task for the auditors-&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;h3 style=&quot;line-height: 115%; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: small;&quot;&gt;Background&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/h3&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;ABC Private Limited was a big FMCG company having headquarters in New Delhi &amp;amp; 5 plants across India employing more than 3000 people.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Majority of staff strength comprised of workers &amp;amp; supervisors. The hiring was done by each Factory Department respectively.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;The company had biometric devices installed across all locations to monitor daily in &amp;amp; out time of each personnel.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;At each month end, HR Department generated the attendance report from biometric software and basis such attendance report, payroll was prepared.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;h3 style=&quot;line-height: 115%; text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;&lt;span style=&quot;font-size: small;&quot;&gt;Scope&lt;/span&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/h3&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Internal audit function was required to conduct payroll audit to ensure that –&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%;&quot;&gt;
&lt;/div&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Employees are getting paid for the actual number of days worked by them.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;There are no ghost employees in the system.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul style=&quot;text-align: left;&quot;&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;All statutory dues pertaining to employees are duly deducted &amp;amp; deposited.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: small;&quot;&gt;Approach&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Internal audit team deployed Data Analytics to -&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Ensure all employees were paid in accordance with the biometric record by plotting paid days as per biometric record and comparing it with paid days as per salary sheet.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Review employee master to highlight missing key data points in it like PAN Number, Bank Account Number, Aadhar Number, Date of Birth etc.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Identify any duplicate employees being created in the system and to check for duplicate payments being made to a single person.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Review of employee records to check for any incorrect data being recorded in the system.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: small;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;&lt;u&gt;&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif; font-size: small;&quot;&gt;Results&lt;/span&gt;&lt;/span&gt;&lt;/u&gt;&lt;/b&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Following observations were noted –&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;In case of 17 employees, joining date was a Sunday (weekly off in the company), which was wrongly entered in the system resulting in the excess pay of Rs. 113,000.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;78 employees were noted who were not recording attendance in Biometric System on a regular basis. Out of the same, 50 employee records were not properly filed in ERP &amp;amp; out of this, 23 employees were found to be fake.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;Excess overtime amounting to Rs. 337,000 was paid to the employees due to wrong calculation of overtime hours in case of 327 employees.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;The scope of process improvement in human resource management was identified to reduce fraudulent records and transactions.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; text-align: justify;&quot;&gt;
&lt;span style=&quot;line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;verdana&amp;quot; , sans-serif;&quot;&gt;While
Data Analytics offer abundant possibilities in internal audit function, one
should first understand the scope of using it. Further, like any other business
function, internal audit’s forte lies in the adoption of new techniques &amp;amp; the
use of Data Analytics is no different. The scope of using Data Analytics in
internal audit is further widened when it is combined with Machine Learning to
automate routine procedures.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;arial unicode ms&amp;quot; , sans-serif; font-size: 10pt;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>https://internalcontrolshubspot.blogspot.com/2018/05/data-analytics-internal-audit.html</link><author>noreply@blogger.com (Sagar Gupta)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhNNqz-nVaSKLx0ZUD5yhDdV98Oob-9Pk_rzHv-w8UgMXLIZbgwSASQjogyJCV2UolPPGO_WQ-z_iLYIZ3VtSf0K5s6dDdWxujucFpjSTyz4jMs5otZ8UqtrN7mDOV_i8ed5cRhz_KZArcn/s72-c/charts-computer-data-669615.jpg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-7849439406954320626.post-8850753385007148819</guid><pubDate>Sun, 06 May 2018 06:22:00 +0000</pubDate><atom:updated>2018-05-11T02:16:15.514-07:00</atom:updated><category domain="http://www.blogger.com/atom/ns#">HRERA</category><category domain="http://www.blogger.com/atom/ns#">MahaRERA</category><category domain="http://www.blogger.com/atom/ns#">Real Estate</category><category domain="http://www.blogger.com/atom/ns#">RERA</category><category domain="http://www.blogger.com/atom/ns#">RERDA</category><category domain="http://www.blogger.com/atom/ns#">UPRERA</category><title>Why RERA has not achieved its objective yet...</title><description>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;In Rakesh Roshan’s 1995 release, “Karan Arjun”, there were several moments where you see Durga Singh (played by Rakhee), a widowed mother of two young boys Karan &amp;amp; Arjun (played by Salman Khan &amp;amp; Shah Rukh Khan), who were killed by Thakur Durjan Singh (Played by Amrish Puri) saying “Mere Karan Arjun Aayenge (My Sons Karan Arjun will come back)”.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;The movie was based around reincarnation and the hope that Karan Arjun will come and take revenge from Thakur Durjan Singh. Karan Arjun do take birth and return to the village as Ajay- Vijay &amp;amp; like all good Hindi films, Ajay -Vijay take the revenge from Thakur Durjan Singh, and everybody lives happily thereafter.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;Now you might be wondering why I am talking about a Bollywood movie while I am supposed to be talking about RERA &amp;amp; why it hasn’t achieved the objectives for which it was introduced.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;When RERA was about to be introduced, everyone saw it as Karan-Arjun of real state for home-buyers, which would streamline everything and put to a stop to all mal-practices followed by different builders across the country.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;To give a backdrop, RERA which stands for Real Estate (Regulation &amp;amp; Development) Act, of 2016 was introduced by the Central Government in May 2016. However, the land is a state subject under the constitution of India, thus the state governments were empowered to form operational rules for real estate projects operating in their state or union territory. The state governments were supposed to notify the rules up to 30th June 2017 when the Act became fully operational. RERA was introduced to safeguard the interests of buyers on various points. The major objectives, for which RERA was introduced, are summarized below-&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;table align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; class=&quot;tr-caption-container&quot; style=&quot;margin-left: auto; margin-right: auto; text-align: center;&quot;&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style=&quot;text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGhcNOx6PpPDnaDsazqYv8yj8MFdFEbdeGyYgwhTmQln6_F3at8M18aDTY-sVet4oHL2q1inqhQuxI6-WfpXQczmffczLNC2G66QEpHbUQOJ-8tqRbFdL88Z3rm-r6bKZ0xJFykWyWrmjt/s1600/Objectives+of+RERA.jpg&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: auto; margin-right: auto;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;746&quot; data-original-width=&quot;1600&quot; height=&quot;298&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGhcNOx6PpPDnaDsazqYv8yj8MFdFEbdeGyYgwhTmQln6_F3at8M18aDTY-sVet4oHL2q1inqhQuxI6-WfpXQczmffczLNC2G66QEpHbUQOJ-8tqRbFdL88Z3rm-r6bKZ0xJFykWyWrmjt/s640/Objectives+of+RERA.jpg&quot; width=&quot;640&quot; /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;tr-caption&quot; style=&quot;text-align: center;&quot;&gt;&lt;i&gt;Fig.1&lt;/i&gt; Main Objectives of RERA&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&amp;nbsp;The major provisions which ensured fulfillment of the above-stated objectives are-&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;&lt;u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;70% of funds received from buyers by a developer are to be kept in a separate bank account.&lt;/span&gt;&lt;/u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;Further, the collected amount can only be used for development of respective project &amp;amp; withdrawals should be in proportion to the value of work completed. The provision aims to restrict developers from the diversion of funds for procuring more land or expending it on other projects of the same developer.&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;Hefty Penalty Imposable;&lt;/span&gt;&lt;/u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;a penalty of 10% of the total project cost and/or prison up to 3 years is included in RERA, which shall be imposable on any builder who contravenes any provision of the Act. The provision was introduced to establish a fear factor amongst the developers &amp;amp; timely completion of projects.&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;Buyers Approval for Structural Changes.&amp;nbsp;&lt;/span&gt;&lt;/u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10pt; line-height: 115%;&quot;&gt;All of us are aware how builders make structural changes at the time of possession &amp;amp; charge buyers for an additional area without any prior intimation. Post RERA, the builder is supposed to obtain prior approval of at least 2/3 of buyers before making any structural changes in Project.&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;RERA is also applicable on projects which were launched before the introduction of RERA&lt;/span&gt;&lt;/u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;&amp;amp; definition of On-Going Projects is given to include all the projects under development phase to whom completion certificate was not issued. The Provision is introduced to ensure timely completion of projects within prescribed timeline &amp;amp; to end the buyers waiting period of endless years to have their own home.&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;Defect Liability Period of 5 Years&lt;/span&gt;&lt;/u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10pt; line-height: 115%;&quot;&gt;. All developers are to be accountable for a period of 5 years in case of any structural defect in the building &amp;amp; that too free of cost. The provision was introduced to ensure that quality of construction is not of the sub-standard level.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;However, as we stand today here, one year after the implementation of RERA, many of the myths which all stakeholders had, stands busted. Some of such myths are-&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;&lt;u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;RERA will ensure completion of delayed projects.&lt;/span&gt;&lt;/u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;While RERA was supposed to be applicable on all on-going projects for which completion certificate has been obtained by developers, most of the RERA rules as formulated by different state governments have diluted the definition of the on-going project to leave out a large chunk of on-going projects out of the net of RERA.&lt;/span&gt;&lt;/li&gt;
&lt;li&gt;&lt;u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;RERA will bring an end to arbitrary practices of builders.&lt;/span&gt;&lt;/u&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10pt; line-height: 115%;&quot;&gt;&amp;nbsp;RERA was introduced to end arbitrary practices followed by builders across the nation, but still, there are 8 states out of 28 states in which RERA was implemented, who have not notified RERA rules.&lt;/span&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;Further, most of the states while formulating the RERA Rules, have diluted several key provisions, which would have otherwise ensured fulfillment of the objectives for which RERA was introduced.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;Given below are some of the interesting facts in relation to the implementation of RERA-&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;Out of 28 states (excluding Jammu &amp;amp; Kashmir), 8 states are yet to notify RERA rules.&lt;/li&gt;
&lt;li&gt;14 states are yet to set up functional web portal.&lt;/li&gt;
&lt;li&gt;Out of 25,000 odd projects being registered all-across India, 62 percent are based in Maharashtra only.&lt;/li&gt;
&lt;li&gt;Only 3 states have appointed permanent regulators under RERA.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt; &lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div align=&quot;center&quot; class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;“A half-hearted spirit has no power. Tentative efforts lead to tentative outcomes. Average people enter into their endeavors headlong &amp;amp; without care”.&amp;nbsp; – Epictetus&lt;/span&gt;&lt;/i&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;The above quote summarizes the situation in a very precise manner. RERA, which was introduced to end the arbitrary practices followed by the developers, got diluted because of the half-hearted efforts of the State Governments thereby strengthening the fact of the existence of a link between the legislators &amp;amp; the developers. Nevertheless, one should not stop hoping, in the times to come, the legislation will achieve the purpose for which it was introduced.&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 10.0pt; line-height: 115%;&quot;&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>https://internalcontrolshubspot.blogspot.com/2018/05/why-rera-has-not-achieved-its-objective.html</link><author>noreply@blogger.com (Sagar Gupta)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGhcNOx6PpPDnaDsazqYv8yj8MFdFEbdeGyYgwhTmQln6_F3at8M18aDTY-sVet4oHL2q1inqhQuxI6-WfpXQczmffczLNC2G66QEpHbUQOJ-8tqRbFdL88Z3rm-r6bKZ0xJFykWyWrmjt/s72-c/Objectives+of+RERA.jpg" height="72" width="72"/><thr:total>0</thr:total></item><item><guid isPermaLink="false">tag:blogger.com,1999:blog-7849439406954320626.post-1954430403304633853</guid><pubDate>Wed, 02 May 2018 15:57:00 +0000</pubDate><atom:updated>2018-05-08T18:41:29.562-07:00</atom:updated><title>Internal Controls Hubspot’s First Blog Post - Welcome 😊</title><description>&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Hi All,&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Welcome to Internal Control Hubspot. This blog is started by me with a vision to share knowledge &amp;amp; awareness about risks that every business face in its day to day operations &amp;amp; the controls to mitigate such risks. All the posts which I will be publishing in future will be based on the experiences which I have gathered over the years. Since you have come here, I feel you should know something about me also.&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Hi, I am Sagar Gupta, Chartered Accountant by Qualification &amp;amp; a business management consultant by profession, advising organizations across domains to plug gaps in business processes, resulting in increased business profits.&amp;nbsp;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0Q2y1-ApKUw2rARKlfP9jKeJ0m6PQMoHltcpJZr8wFKAiZepke380pmebvAvPxt5mwtFbX2I8JMn5JAvmChb-k7kHetii7RJ3Xjbq_luSDge5GSMTrotlL8yXmJuum7K45Pi4IAYyls8z/s1600/IMG_2019.JPG&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;800&quot; data-original-width=&quot;600&quot; height=&quot;640&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0Q2y1-ApKUw2rARKlfP9jKeJ0m6PQMoHltcpJZr8wFKAiZepke380pmebvAvPxt5mwtFbX2I8JMn5JAvmChb-k7kHetii7RJ3Xjbq_luSDge5GSMTrotlL8yXmJuum7K45Pi4IAYyls8z/s640/IMG_2019.JPG&quot; width=&quot;480&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;I have started this blog to share knowledge &amp;amp; this is an open community to interact with like-minded folks on the topic related to-&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;a.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Business Processes&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;b.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Risk Management&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;c.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Internal Controls&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;d.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Standard Operating Procedures&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;e.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Labour Laws&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;f.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Enterprise Resource Planning (ERP)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;g.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Real Estate Regulation &amp;amp; Development Act (RERDA)&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: .5in; margin-right: 0in; margin-top: 0in; mso-list: l0 level1 lfo1; text-align: justify; text-indent: -.25in;&quot;&gt;
&lt;!--[if !supportLists]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;h.&lt;span style=&quot;font-family: &amp;quot;times new roman&amp;quot;; font-size: 7pt; font-stretch: normal; line-height: normal;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;!--[endif]--&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Fraud Detection &amp;amp; Prevention&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;I will be more than happy to receive a feedback and you can send me your opinion about this blog anytime @ &lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11.0pt; line-height: 150%;&quot;&gt;&lt;a href=&quot;mailto:sagarg.ca@gmail.com&quot;&gt;sagarg.ca@gmail.com&lt;/a&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Happy Learning Guys !!&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;/div&gt;
&lt;div style=&quot;line-height: 150%; margin-bottom: .0001pt; margin: 0in; text-align: justify;&quot;&gt;
&lt;i&gt;&lt;span style=&quot;font-family: &amp;quot;century gothic&amp;quot; , sans-serif; font-size: 11pt; line-height: 150%;&quot;&gt;Sagar Gupta😊😊&lt;o:p&gt;&lt;/o:p&gt;&lt;/span&gt;&lt;/i&gt;&lt;/div&gt;
&lt;/div&gt;
</description><link>https://internalcontrolshubspot.blogspot.com/2018/05/internalcontrolshubspot-first-blog-post-welcome.html</link><author>noreply@blogger.com (Sagar Gupta)</author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0Q2y1-ApKUw2rARKlfP9jKeJ0m6PQMoHltcpJZr8wFKAiZepke380pmebvAvPxt5mwtFbX2I8JMn5JAvmChb-k7kHetii7RJ3Xjbq_luSDge5GSMTrotlL8yXmJuum7K45Pi4IAYyls8z/s72-c/IMG_2019.JPG" height="72" width="72"/><thr:total>2</thr:total></item></channel></rss>