Follow Us :

Mani Deepak Gadamsetty

Latest Posts by Mani Deepak Gadamsetty

26AS text to Excel Converter Tool

March 25, 2024 7284 Views 0 comment Print

Instructions for Using 26AS text to Excel Conversion 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. Copy the text file location as path (Ctrl+Shift+C) , paste it in yellow cell and finally Click on “26AS” button. 3. TDS […]

GSTR 9 and 9C pdf to Excel Conversion tool

August 30, 2023 6405 Views 0 comment 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

GSTR-2B Consolidation Tool

July 28, 2023 18291 Views 3 comments Print

This tool is created to help the professionals and article trainees in consolidating GSTR-2B (Excel files) at one click. Please follow the short procedure mentioned below Download GSTR-2B Excel files from GST Portal. Save all the downloaded GSTR-2B excel files at one location. (In one single folder) It can open multiple files (even with different […]

Tally Ledgers Consolidation Tool

March 8, 2023 3507 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 […]

Rank Order Clustering Algorithm (ROCA) Tool

March 5, 2023 10599 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, […]

GSTR-1 Vs GSTR-3B Reconciliation Tool

January 27, 2023 12036 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 […]

GSTR-1 PDF to EXCEL Extraction Tool

January 22, 2023 7329 Views 4 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 […]

GSTR-1 Json to Excel Conversion Tool

January 16, 2023 79956 Views 3 comments Print

Instructions to use GSTR-1 JSON TO EXCEL Converter & Consolidation Tool 1. You can use this tool by using Microsoft Excel version 2016,2019,2021 or Office 365. 2. Save only GSTR-1 Json files after Extracting From the Zip file into One Folder (only in Desktop not in One drive or Google drive e.t.c.,) 3. Kindly  don’t […]

GSTR-2A Consolidation Tool

January 16, 2023 9834 Views 4 comments Print

Instructions to consolidate GSTR-2A 1. You can use this tool by using Microsoft Excel version 2016, 2019, 2021 or Office 365 2. Save only GSTR-2A Excel workbooks without changing Name i.e.,(GSTIN_MMYYYY_R2A.Xlsx) on your computer but not on google drive,one drive, etc. 3. Copy that folder location (alt+d)(ctrl+c) then paste this on yellow cell then click […]

GSTR-3B PDF to EXCEL Extraction Tool

January 14, 2023 6480 Views 1 comment Print

Instructions for Using GSTR-3B Pdf to Excel Extraction 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-3B Final Pdfs in respective folders. 3. Copy the respective folder location(Alt+D) , paste them in respective yellow cells and finally […]

Search Post by Date
June 2024
M T W T F S S
 12
3456789
10111213141516
17181920212223
24252627282930