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 […]
Handbook, a ready reckoner, would certainly help the officers of all Ranks, within an Executive CGST Commissionerates, to get a clear idea of their functions, as mandated in the CGST Act, 2017 and the Rules
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, […]
Tally XML is a markup language used by Tally, a popular accounting software, for importing and exporting data. Tally XML files have a specific structure and syntax, which can be understood by referring to the Tally XML schema and the Tally XML tags. To understand Tally XML, it is helpful to have a basic understanding […]
Budget 2023: New Tax Regime vs Old Tax Regime – Tax Computation for Salaried in Excel Current Budget 2023 proposed certain amendments in New tax regime for Individuals by amending the tax Slab and extending certain deductions to New tax regime to make it more attractive and successful. Also as mentioned by Hon’ble Finance Minister […]
Old Tax Regime Vs. New Tax Regime Updated Calculator for Financial Year 2023-24 i.e. Assessment Year 2024-25 after considering new tax slabs proposed by Union Budget 2023. Various slabs and Tax Rates created chaos and raised multiple questions among Salaried employees. In order to bring simplicity I have created a Excel based utility which will […]
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 […]
