Ca Mani Deepak Gadamsetty
"⮚ Developed multiple automation tools and authored professional articles across GST, Income Tax, and Customs domains, collectively exceeding 200,000+ views on TaxGuru contributing to knowledge-sharing and process efficiency within the CA community
⮚ Designed and implemented automation solutions tailored to client requirements across 12+ Indian states and an NRI, resulting in improved reporting efficiency and data accuracy
⮚ Created a Power Automate Desktop–based tutorial series on YouTube, collectively attracting 17,000+ views, showcasing innovative low-code automation techniques that enhance workplace efficiency
"
Education
Job Experience
● GST & Indirect Tax
⮚ Handled GST audits and filings (GSTR-9/9A, monthly/quarterly returns) for Turnover ₹300+ crore entities with full reconciliations
⮚ Created a semi-automated GST working tool for a multi-state entity (₹300+ crore turnover, 13+ state entity), enhancing speed, accuracy, and consistency of monthly compliance
⮚ Supported the principal in preparing responses to Income Tax assessment notices, GST notices, and other departmental communications, ensuring accuracy and compliance with statutory requirements
⮚ Led GST refund reconciliation processes for clients, working with the principal and seniors to ensure accurate and compliant filings
● Direct Tax
⮚ Executed tax audits and managed ITR filings for individuals, partnership firms, trusts, and private limited companies
⮚ Performed and managed statutory compliances related to PF, ESI, TDS, and TCS, ensuring accuracy and timely submissions
⮚ Assisted in the preparation of financial statements for various clients, ensuring adherence to statutory requirements
● Audit & Accounting
⮚ Prepared statutory financial statements (Balance Sheet, P&L, Cash Flow) for diverse clients in compliance with the Companies Act
⮚ Conducted stock audits for companies engaged in manufacturing and trading activities, verifying inventory accuracy and reporting variances
⮚ Presented an internal training session on CARO 2020 , Standards on Auditing (SA) and Indian Accounting Standards(Ind AS) contributing to team knowledge enhancement
● Automation
⮚ Automated bulk Duty Drawback verification (100+ cases in seconds) and UDIN generation, saving several hours of manual effort and improving compliance efficiency
⮚ Provided training on Advanced Excel and Power Query for improving efficiency in regular office tasks
Job Skills
GST Audit | Taxation | Financial Reporting | Statutory Audit | Ledger Scrutiny | TDS/TCS Compliance | PF & ESI Compliance | Data Analytics | Excel Automation | Power Query | Power Automate | Financial Modelling | Reconciliations | Financial Statements | Accounting
Latest Posts by Ca Mani Deepak Gadamsetty
December 9, 2025
57336 Views
5 comments
Print
Easily consolidate multiple GSTR-2B Excel files—including different GSTINs—into a single structured report with this automatic, one-click Excel-based tool. Fast, accurate, and ideal for professionals and article trainees.
September 9, 2024
5424 Views
0 comment
Print
Easily convert BOE EX-Bond PDFs to Excel (HSN wise) with this tool. Supports Excel 2019, 2021, and Office 365. Convert up to 5 PDFs in just two clicks for seamless data consolidation.
August 22, 2024
24534 Views
1 comment
Print
Learn how to use 26AS text to Excel conversion tool. Tested in Excel 2019, 2021, and Office 365. Follow simple steps to convert and manage TDS/TCS data efficiently.
August 20, 2024
39501 Views
2 comments
Print
Learn how to use the GSTR-2A/2B vs Books Reconciliation Tool effectively. Follow steps for updating data, reconciling, and reviewing results.
August 7, 2024
5382 Views
0 comment
Print
Convert and consolidate TDS payment challans from PDF to Excel quickly using our tool. Works with Excel 2019, 2021, and Office 365. Easy steps for fast results.
August 30, 2023
10467 Views
2 comments
Print
Pre requisite 1. Newer Versions of Excel (2019,2021 or Office 365) Instructions 1.Copy the Folder location and pdf name and paste in Yellow colour Cells and then Click on GSTR-9 or GSTR-9C Buttons 2. By Using this Tool you can able to Convert GSTR-9 pdf and GSTR-9C pdf into Excel Format
March 8, 2023
5838 Views
0 comment
Print
To prepare the Sales register, ITC register, fixed assets, etc. we need to consolidate multiple Ledgers exported in columnar format into a single sheet. To reduce this repetitive and boring task you can use this tool to consolidate all Ledgers exported in the columnar format from a tally into a single sheet with multiple ledgers […]
March 5, 2023
13755 Views
0 comment
Print
Rank Order Clustering Algorithm (ROCA) is an algorithm used in cellular manufacturing to group parts based on their similarity. It is a type of clustering algorithm that can be used to group parts into ‘families’ or ‘cells’ based on their similarity. This is done by assigning a higher rank to parts that are more similar, […]
January 27, 2023
18030 Views
9 comments
Print
Instructions for Using GSTR-1 Vs GSTR-3B Reconcilation Tool 1. This tool will not work in older versions of Excel but it tested in 2019 version, 2021 Version and in Office 365 Version. 2. Save GSTR-1 and GSTR-3B Final Pdfs in respective folders. 3. Copy the respective folder location(Alt+D) , paste them in respective yellow cells […]
January 22, 2023
12603 Views
5 comments
Print
Instructions to use GSTR-1 PDF to EXCEL Extraction Tool 1. Kindly check your EXCEL version before using this tool it shall be 2016,2019,2021 or office 365. 2. Save all GSTR-1 Final PDFs in a separate folder on your desktop, not in cloud storage (Eg. Google Drive, One Drive etc.) 3. Don’t save any other files […]