Adarsh Madrecha
Techno Savvy Chartered Accountant. Conultant @ EY
Welcome to my blog. I hope you will enjoy reading about various topics that I write about.
From my experience as a System Auditor at EY, I share my learning experience under the category “System Audit”. The articles under this section cover Application Controls Testing, Technical knowledge of SAP.
From my experience of being Faculty for Advance ITT at ICAI for teaching MS Excel, I share my Excel knowledge under the category “Excel”. The articles under this section cover – Excel User Defined Functions (UDF), Excel Tips and Tricks.
From my experience in managing the IT infrastructure and office automation at Madrecha & Co (Dad’s CA Firm in Thane), I share my tips on office automation, suggestions to improve System through post under the category “Office-Management”.
Qualification
After completing my BatchelorsDegree inAccounting and Finance (BCAF), I completed Chartered Accountancy Exams. Since I had inclination towards IT, studied system audit and completed ISA (Previously known as DISA)
Volunteer
Actively involved in various professional bodies. IT Committee Member at Chamber of Tax Consultants, WIRC, Thane Branch of ICAI. Delivered lectures on Excel, System Audit, Data Analytics at seminars conducted by Study Circle and Branches of ICAI.
Experience
Currently working at EY as system auditor. At EY, my primary work is Application Controls testing for various ERP including SAP, Oracle, Microsoft Dynamics, JDE, Keris, Sun System and other custom/homegrown ERPs. Previous to EY, my experience includes SOX Audit, ERP Implementation (Sun System), Business process re-engineering, Tally Customization.
My projects
GST Forum
A forum for GST Tax Consultants to share knowledge about Goods and Service Tax (GST)
Jamku Office Management
An Office Management software for CA, CS, Tax Consultants.
Counting Dues
An Andriod app to manage receivables (creditors) and payables (debtors)
Auditing and Understanding PO Release Strategy in SAP
How PO Release Strategy works. Which Tables to Extract. What configurations needs to be tested. How PO release strategy is set up. Auditing PO approval process. Introduction For any organization, it is imperative that all purchases (i.e. action which results in an...
SAP User Authorization Audit and Explanation
How user authorization works in SAP. How users are given access to TCode. What are authorization objects? How to audit user authorization? How to extract users having access to particular TCode? How authorization works in SAP? After a user is created, in order to...
Critical Tcode in SAP for ITGC and Sox Audit
While conducting IT General Controls (ITGC) review and SOX Audit, we need to check which users have access to SAP critical TCodes. In this article, we discuss which TCodes are critical, and why (i.e. risk for those TCodes) SE01, SE09, SE10 Use SE01 is the main screen...
SAP Learning Material
A single place for learning SAP and System Audit of SAP. Books on SAP, videos on SAP and learning Material on SAP. SAP Books If you have some background about SAP, then "100 Things You Should Know about" Series is the best to hone SAP skills....
GSTIN Offline Check – AdarshGSTINCheck
A simple and easy to use Excel Utility to identify whether GSTIN is correctAmidst all the buzz surrounding GST, here comes another offering from Madrecha Group - 'GSTIN Offline Check'.As on 29 Sept 2017Using the tool is super easy. It is just an Excel Formula. Copy...
SAP organization Assignment – Enterprise Structure
P2P - Purchase to Pay - MM Module Purchasing Organization Purchasing Org to Company Code One to Many. i.e one Purchasing Org can be assigned to Many Company Codes. Table - T024EPurchasing Org to Plant Many to Many. i.e Any Purchasing Org can be assigned to Any Plant...
SAP Procure to Pay (P2P) Accounting and How to Audit
In SAP Procure to Pay (P2P), we create 4 documents to complete the entire process of procuring the goods to payment to the vendor. Purchase Order (PO) Goods Receipt (GRN) Invoice (Invoicing) Payment In some cases, there can be Purchase Requisition, before Purchase...
Excel Learning Resources
Whenever I take seminars on Excel. I always get a question - What is the best place to learn Excel? Another Variation of the same question is - How can be an Excel Expert like you? On this page, I shall list down all the resources that I have come across -...
SAP ML Run System Audit
ML / Actual Costing run in SAP is a complicated process. Hence, in this Post, I am going to cover ML run from the perspective of Raw Material. Will cover from the perspective of Finished goods in another article. The Below article explains how to Test "ML Run" in SAP...