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 […]
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
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 […]
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) 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, […]
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 […]
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 […]
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 […]
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 […]
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 […]