Migrating To Cloud Based ERP Solutions Project
Migrating To Cloud Based ERP Solutions Project
Migrating To Cloud Based ERP Solutions Project
ISA 2.0
Migrating to
Cloud based ERP
solution
TABLE OF CONTENTS
Certificate 3
Auditee Environment 6
Background 8
Situation 9
Documents Reviewed 22
References 23
Deliverables 24
Summary/Conclusion 28
ii
Project Report ISA 2.0
Migrating to Cloud based ERP solution
CERTIFICATE
This is to certify that we have successfully completed the ISA 2.0 course training conducted at:
Hotel Pride Plaza, Bodakdev Cross Road, Ahmedabad from 1st Feb 2020 to 29th April 2020
and we have the required attendance. We are submitting the Project titled: Migrating to Cloud
based ERP solution
We hereby confirm that we have adhered to the guidelines issued by CIT, ICAI for the project.
We also certify that this project report is the original work of our group and each one of us have
actively participated and contributed in preparing this project. We have not shared the project
details or taken help in preparing project report from anyone except members of our group.
Place : Ahmedabad
Date : 30-04-2020
3
Project Report ISA 2.0
Migrating to Cloud based ERP solution
ABC Infrastructure Ltd. (Auditee) provides Gas Pipeline Services and distribution, EPC Projects,
Cross Country Pipeline Layering, Horizontal Directional Drilling across India. It is Well Equipped
with total infrastructure and has kept in pace with the changing technology and construction team
focused on Safety, Quality and Efficiency with cost effective project executed within time and
budget. They are currently using stand-alone accounting and inventory package which has
limited functionality. They have an aggressive business growth plans and found that the current
software solution cannot meet their future requirements.
ABC Infrastructure Ltd have decided to migrate to ‘Wilson’s On Cloud Solution (WOCS)-
Standard Version’ a robust full suite of ERP Developed using Wilson Virtual works, a state-of-
the-art software engineering and delivery platform. WOCS is expected to enable ABC to reap
the benefits of the solutions with “Built in Best Practices” together with a highly “Flexible
Framework” to ensure solution alignment to “dynamic business requirements” of ABC.
The WOCS solution has standard product features which cannot be modify except based on the
methodology followed by Wilson and the customer has to use the existing product without any
changes. As a part of the software as service (SAS)development model, WOCS will not make
any changes in the data entry screens/ Processes as per individual customers need.
4
Project Report ISA 2.0
Migrating to Cloud based ERP solution
ABC Infrastructure Ltd is provider of Gas Pipeline Services and distribution, EPC Projects across
India, having adequate infrastructure of technology with respect to changing environment.
Company is having four branch office and more than 300 employees including at branches. Out
of 300 employees, more than 40 employees are engaged in finance and accounts departments.
At present company is maintaining a non-integrated and stand-alone accounting software, which
require maintaining huge documentation.
Now with the changing environment and future business growth company board decided to
migrate ‘Wilson’s On Cloud Solution (WOCS) an ERP software from existing non-integrated
software. The new ERP software will provide all business process function start from Project
execution, marketing, purchase management to payroll and inventory management, financial
and management accounting etc. to know the real time business information.
ABC Infrastructure Ltd (auditee) appointed M/s MAD & Associates (Chartered Accountants
known as auditor) to conduct the Cloud ERP System Audit of auditee. Auditor firm is having 3
years’ experience in conducting IS Audit. Firm is having 3 partner (CAs), 2 system auditor (ISA)
and 3 other technical staff all having good knowledge and experience in their respective domain.
TEAM MEMBER
S.NO QUALIFICATION DESIGNATION
NAME
1 Mr. Dhaval Limbani FCA, ISA Team Leader
2 Mr. Manoj Jajodia FCA Co-Team Leader
3 Mr. Ashish Mehta FCA Co-Team Leader
4 Mr. Pranav Pandya FCA, ISA Team Member
5 Mr. Mihir Pandya M.Tech, Phd (IT), BE (Software) Software Engineer
6 Mr. Dhaval Chikani M.Tech, BE (Software) Software Engineer
7 Mr. Darshan Panchal Phd (IT-Hardware Engineer) Hardware Engineer
5
Project Report ISA 2.0
Migrating to Cloud based ERP solution
2. AUDITEE ENVIRONMENT
ABC Infrastructure Ltd is provider of Gas Pipeline Services and distribution, EPC Projects across
India. Since company is engaged in business of heavy infrastructure projects for Governments
and big infrastructure companies.
Company board consists of 7 directors, one Managing Director (CEO), one Finance Director
(CFO), Sales & Marketing Director, Chief Operational Director (COO), Chief Information Office
(CIO), 2 Executive directors. Board sets policy and procedure and laid down the strategy to
complete business task, which will be executed and implemented by managerial and operational
staff, which consists of each individual department head to operational level staff member.
At present company is following a non – integrated accounting software which will no longer
useful looking to changing business technology and growing changes in technology
environment. At present company infrastructure is well equipped. But company is not following
any ERP Software to integrate its all business function via one single platform. But MD is
confident of the view that by providing adequate training we can train finance and accounts
departments to cloud based ERP acquaintance. This will eliminate the need to purchase the
necessary server and hardware storage, i.e. reduction in OPEX.
Except respective tax laws, corporate law, labour law etc., IT Act 2000 company is not bound by
any other legal compliance like RBI, SEBI, Banking Regulation, IRDA etc. The company has a
compliance department which looks into matter relating to compliance the same is reviewed by
internal auditor function. For effective operation of compliance department company have
standard policies, procedure and guidance that defines regulatory standard requirement that
apply to company.
6
Project Report ISA 2.0
Migrating to Cloud based ERP solution
7
Project Report ISA 2.0
Migrating to Cloud based ERP solution
3. BACKGROUND
Since Company decided to change its accounting tool from traditional to cloud based ERP
(WOCS) in that, the most important thing for company is to migrate data first on ERP system.
This can be done via batch processing under which data will upload first and then another person
will approve these transactions. Once these data processed the next critical operation to
reconcile these data with traditional data to check whether all data have been compiled and in
proper way in which they require. In Cloud ERP system, system is hosted on cloud and ERP
service provider takes care hosting of ERP system. This is based on Software as a Service
(SaaS) module, wherein company will access the software, whereas service provider will
manage software including operating system and execution environment.
Now to check all these critical operation company wants an independent auditor function to
check all these critical operation task. Auditor (MAD & Associates) will audit these function starts
from beginning mapping of codes, ledgers, groups, data uploading, reconciliation, report
spooling, trade checking to know functioning of all ERP Module whether or not data of vendor,
inventory management, financial accounting, sales and purchase, payroll system etc. are
working effectively and efficiently on cloud site as provided by cloud service provider. Auditor
will also look system effect of one data entry on another ERP utility is proper and correct.
For this purpose, auditor will thoroughly check the system configuration and settings are
manipulated or modified. Further auditor will check IT Infrastructure configuration like operating
system, servers, networking devices tool and security control thereof to check whether CIA
(confidentially, integrity or availability) via unauthorized access, data manipulation etc., which
may be big threat to organization as well. In addition to this, auditor will check whether vendor
is responsible for maintaining hardware & software such as patches, upgrades, refreshes.
8
Project Report ISA 2.0
Migrating to Cloud based ERP solution
4. SITUATION
The Auditee is currently using an ERP system which provides stand-alone accounting and
inventory packages which has limited functionalities. The company has aggressive growth plans
for which the current software solution is not enough. The company’s finance and accounts
department has more than 40 employees and current software packages are stand-alone and
non-integrated and extensive documentation is maintained. So, it has been decided by the
management to migrate to cloud based ERP.
The proposed Wilson’s solution provides a single version of the product at any point of time. All
product feature upgrades and updates shall be made available as a part of the standard offering.
Basically, the requirements are market driven and will prioritized based various criteria like
Statutory needs, Best business practice, key business process etc. There are 14 modules
included in the scope such as sales & shipping management, accounts receivable, purchase,
HR & Payroll, etc.
Moreover, the current staff is not computer savvy and have limited knowledge of using
computers but the young MD has taken charge of training employees and the cost consideration
based on model implementation of 10 user license shows cost benefit analysis and justification
for the investment. So, seeing these current problems and the benefits of the cloud-based
solution it has been decided by the management to migrate to cloud based ERP. The proposed
solution also provides complete applications which are sold on a subscription model for a specific
period. This model provides the capability to use the provider’s applications running on cloud
infrastructure. The applications are accessible from various client devices through a thin client
interface such as a web browser. This brings in saving to ABC Infrastructure Ltd as there is no
need to buy licenses for running programs on their own computers. The software solution is
accessible using existing computers.
9
Project Report ISA 2.0
Migrating to Cloud based ERP solution
S.
AREA OF RISK RISK FOCUSED AREA
NO
Is there appropriate ingress or egress filtering?
1 Access Control Are there ACLs that segment the environment from other
resources?
Is there a protected environment?
How are host systems secured?
2 Virtualization
Are resources utilized and released as expected?
How are virtual resource interconnected?
Cloud provider may not be able to match in-house IT
service availability, recovery time objectives (RTO), and
recovery point objectives (RPO).
Data Management and Cloud providers may drastically change business model
3
Data Storage or discontinue cloud services.
Due to technical architecture complexity and potential
restrictions by the cloud provider, replicating data back to
the enterprise or to another provider may be difficult.
What communication protocols are used to communicate
with other data centers?
Are there any clear text administration protocols used?
Communication
4 Can you monitor communication in and out of the cloud
Channels
as well as within the cloud?
Are there any end user devices that can download data
from the cloud?
Utilize ISO2700 and SOC2 / SOC3 (Assurance Reports
Cloud on Controls at a Third-Party Service Organization)
5 Supporting Trust Principles – Security, Availability, Processing
Infrastructure Integrity, Confidentiality, Privacy
Will administrators have “access” to the virtual data?
Examine tools used for usage tracking and licensing
Examine accuracy of reporting
Software as a Service
6 Separation from other applications
(SaaS)
New risks may exist as cloud computing can expand and
shorten the SDLC cycle.
10
Project Report ISA 2.0
Migrating to Cloud based ERP solution
Identify internal control and regulatory deficiencies that would affect the organization.
Identify information security control concerns that could affect the reliability, accuracy and
security of enterprises data due to weaknesses in the package solutions offered by the
vendor.
Review contractual compliance between cloud service provider and customer i.e.
auditee.
What is impact on auditor when client has used “Cloud ERP System” and how data will
be audited on cloud service provider.
11
Project Report ISA 2.0
Migrating to Cloud based ERP solution
Auditor requires following Hardware, Software (application and system), Information, and
System Configuration documentation.
S. NO POINTS DESCRIPTION
Auditor (MAD & Associates) need 7 laptop, 3 desktop,
networking cables, data cable, power backup equipments
1 Hardware for execution of the assignment. All hardware must be
configured in such a manner to be compatible with
software.
In order to obtain assurance that the data processed by the system is complete, valid and
accurate and is giving the desired results, computer assisted audit techniques (CAAT)
shall be used. Computer Assisted Audit Technique (CAATs) are computer-based tools,
which help us in carrying out various automated tools to evaluate an IT system or data.
These are very useful, where a significant volume of auditee data is available in electronic
format. CAATs provide greater level of assurance as compared to other techniques,
especially manual testing methods.1
12
Project Report ISA 2.0
Migrating to Cloud based ERP solution
Use of CAAT Tools (Computer Aided Audit Techniques):- The use of CAAT tools
improves the audit process and help in data extraction and analyzing software. Following
are the techniques:-
S. NO POINTS DESCRIPTION
This tool is effective & efficient for IS audit. In this
method Access Control List (ACL) is table under
which data is lock down as read only to prevent
Generalized Audit
1 inadvertently changing data. In this method organization
Software
define access right to each system users. Every user
has different right such as read only, read and
modification, approval etc.
These programs are used to perform common data
processing function such as sorting, creating and
2 Utility Program
printing files. This utility doesn’t contain feature such as
automatic record counts or control totals.
Test data involve the auditors using a sample set of data
to assess whether logic errors exist in a program and
3 Test Data program meets organization objectives. It provides
information about internal control and weakness if any
exist.
In this technique, auditor perform tests details of
Audit Expert transaction and balance, analytical review procedure,
4
System compliance test IS general control, compliance test IS
application control and vulnerability testing.
13
Project Report ISA 2.0
Migrating to Cloud based ERP solution
14
Project Report ISA 2.0
Migrating to Cloud based ERP solution
15
Project Report ISA 2.0
Migrating to Cloud based ERP solution
16
Project Report ISA 2.0
Migrating to Cloud based ERP solution
17
Project Report ISA 2.0
Migrating to Cloud based ERP solution
18
Project Report ISA 2.0
Migrating to Cloud based ERP solution
19
Project Report ISA 2.0
Migrating to Cloud based ERP solution
20
Project Report ISA 2.0
Migrating to Cloud based ERP solution
21
Project Report ISA 2.0
Migrating to Cloud based ERP solution
8. DOCUMENTS REVIEWED
User Manuals and Technical Manuals relating to System Software and ERP.
Any other documentation as identified by us as required for the assignment Security policy
document relating to system.
Auditor has read and understand all the terms and conditions of SLA. Any terms which is
harmful for the company, the same has been discussed with management in order to
secure stakeholder interest.
22
Project Report ISA 2.0
Migrating to Cloud based ERP solution
9. REFERENCES
Best practices relating to international accepted standard for IS Audit — COBIT (Control
Objectives for Information and Related Technology, issued by the Information Systems
Audit and Control Association, USA, COSO framework etc.
Information Systems Audit 2.0 Course – Volume I- Module 1- Chapter-3 Part-1- Cloud and
Mobile Computing.
Deloitte (2010); Heiser (2015); Lehigh (2016); O’Hanley & Tiller (2013).
23
Project Report ISA 2.0
Migrating to Cloud based ERP solution
10. DELIVERABLES
The following table summarizes the review area and relevant finding, auditor suggestion
and risk rating.
24
Project Report ISA 2.0
Migrating to Cloud based ERP solution
25
Project Report ISA 2.0
Migrating to Cloud based ERP solution
High:- The issue representing a finding that organization exposed to significant risk and
require immediate resolution.
Medium:- The issue representing a finding that organization exposed to risk that require
resolution in near future.
Low:- The issue represents a finding, which don’t require action from organization.
26
Project Report ISA 2.0
Migrating to Cloud based ERP solution
27
Project Report ISA 2.0
Migrating to Cloud based ERP solution
12. SUMMARY/CONCLUSION
Cloud computing is increasingly assuming a prominent and leading role in businesses for the
purpose of operational efficiency and cost reduction. In spite of the numerous benefits, users
remain anxious about data protection and dependency on CSP for business continuity. As per
the discussion held with the management, the BOD of the company has initiated corrective steps
to overcome the “high implication findings” in observed in the audit and those, which have
medium implication; BOD would take corrective action as soon as possible. Since the company
has migrated to “Cloud based ERP System”, so initially it will be difficult to adopt the newer
technological environment perfectly by organization as a whole. However, the management is
optimistic about future guidance with respect to adoption of technological changes and impact
thereof on the organization.
28