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