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
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 -...
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,...
Invoice Tolerance in Oracle ERP
In Oracle ERP, Invoice tolerance is set at Organization Unit (OU) level. The below screenshot shows the tolerance set up screen.
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...
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...
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....
7 Excel tricks to impress your boss
This blog is owned by CA Adarsh Madrecha. All rights reserved.
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...
Questions for Becoming a Data and Analytics Driven Organization
Here are five questions you can ask at your next meeting to get your clients thinking about data and analytics: Where do data and analytics sit within your business strategy? Embed analytics into day-to-day decisions. Allow them to be the value-driver at the...