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)

Complete List of MS Excel Shortcut Key

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
Testing Standard Reports in SAP

Testing Standard Reports in SAP

SAP provides tonnes of reports out of the box examples include FB5LN which is used to view the balance of a customer. If a need arises to customise reports, businesses instead of customising standard reports will create custom reports. These are created by BASIS Team,...

read more
Tcodes Required to Test Configuration in SAP

Tcodes Required to Test Configuration in SAP

When we start Application Controls Tetsing or System Audit for a client using SAP, we nned to provide client with list of Tcodes which we shall be need to Check Configuration and Extract Data. General SE16N SPRO SQVI SUIM P2P Process OBYC O2C Process OVA8 FSCP...

read more
Thousand Separator in Excel

Thousand Separator in Excel

Sometimes we come accross a situation, where we want to change thousand seperator for a particular excel file. In this post, I shall discuss all about thousnd selerator in excel and how to configure it permanetly as well as for a single situation. Introduction to...

read more

Able to Extract – Product Review

There are a bunch of different reasons why we need to edit our PDF content. However, that is impossible to accomplish without some sort of help from third party software. Fortunately, there are some tools that let you edit any PDF with just a couple of mouse clicks....

read more
SAP Substantive testing for 3 Way Match

SAP Substantive testing for 3 Way Match

SAP substantive analytical procedures from start to end from the 3-way match perspective.About SAP Substantive Testing / Analytical ProcedureDefinitionFor application controls perspective, Substantive Testing is an audit procedure that examines the financial...

read more

I am eager to hear from you.

7 + 7 =