Select Page

Adarsh Madrecha

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)

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...

read more

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...

read more

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....

read more

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...

read more

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...

read more

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...

read more

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 -...

read more

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...

read more

Complete List of MS Excel Shortcut Key

Ctrl+A - Select All Ctrl+B - Bold Ctrl+C - Copy Ctrl+D - Fill Down Ctrl+F - Find Ctrl+G - Goto Ctrl+H - Replace Ctrl+I - Italic Ctrl+K - Insert Hyperlink Ctrl+N - New Workbook Ctrl+O - Open Ctrl+P - Print Ctrl+R - Fill Right Ctrl+S - Save Ctrl+U - Underline Ctrl+V -...

read more

I am eager to hear from you.

6 + 7 =

Pin It on Pinterest

Share This