Follow Us:

Rajat Solanki

Latest Posts by Rajat Solanki

GSTR-3B & GSTR-1 Reconciliation in Excel: An Automated Toolkit

September 18, 2025 14673 Views 1 comment Print

Learn how to use an automated Excel toolkit to reconcile GSTR-3B, GSTR-1, and your books. Streamline GST compliance with a simple, four-step process.

Section 43B – Most Important or dangerous provision of Finance bill 2023

February 4, 2023 9189 Views 0 comment Print

An amendment made to Section 43B of the Income Tax Act, 1961, has amended that payments made to Micro, Small and Medium Enterprises (MSMEs) that are not made within the due date i.e 45 days, will not be eligible for a deduction.

Unnecessary complication in MCA V3 Portal

January 24, 2023 5052 Views 0 comment Print

Today new V3 portal has been implemented by Infosys with many changes on process of forms 1. Now every time to login in V3 requires an OTP creating a lot of inconvenience. 2. Now every DIN holder has update DSC in v3 again even if that was registered in V2 already. 3. To update the […]

Excel utility for GSTR 2A reconciliation

March 26, 2019 204435 Views 27 comments Print

Excel utility for GSTR-2A Reconciliation and Reconciliation’s importance in GST. Today reconciliation has become the most Important task to file accurate returns and later to compile GSTR 9 and GSTR 9C There are Five types of reconciliation expected of us for the most accurate filing of GSTR 9 and 9C 1. GSTR 3B with books […]

GSTR 3B Payment and Offset liability, Old Rule or New Rule?

March 17, 2019 20706 Views 8 comments Print

Now as per CGST Amendment act 2018 Prescribed the New rule for Utilization of ITC as Given in Sec 49A 49A. Notwithstanding anything contained in section 49, the input tax credit on account of central tax, State tax or Union territory tax shall be utilised towards payment of integrated tax, central tax, State tax or […]

GSTR 3B Payment and Offset liability as per 49A W.e.f 1.2.2019 ,Effect working capital?

March 3, 2019 9012 Views 2 comments Print

Section 49A of the CGST Act as inseted vide Central Goods and Services Tax (Amendment) Act, 2018 is regarding the utilization of the input tax credit (ITC). The section 49A is inserted with the amendment of the CGST Act. In this Act, it is prescribed to utilize all the credit of the Integrated Tax first. […]

Database & Authenciation issues & its dilemma to professionals

October 20, 2018 3153 Views 0 comment Print

This article is about the problems in authentication and processing of many forms in GST ,MCA, Income tax due to a small errors made by the assessee and hindering his compliance’s

Analysis of CGST Amendment Act 2018 with Auto Set Off Calculation Sheet

September 3, 2018 13077 Views 0 comment Print

Articles discusses Amendment in Central Goods and Services Tax Act, 2017 vide Central Goods and Services Tax (Amendment) Act, 2018 Amendment of section 7 of Central Goods and Services Tax Act, 2017 All forms of Supply of goods or services or both will be for consideration AND Furtherance of Business “(1A) where certain activities or transactions […]

GSTR 2A To Excel For Reconciliation

August 12, 2018 121872 Views 21 comments Print

GSTN Portal have enabled Direct Downloading of Excel sheet for easy reconciliation with books and return but Have not Formatted Correctly SO This article will provide you how to download and Correctly format for row wise entries of Invoices without Any Blanks

ITC form Errors in DATE format, How to Rectify?

August 2, 2018 23418 Views 1 comment Print

As there are many error in ITC forms due to wrong Formatting for Date as text and not as Date Format due to which the excel file will throw errors as when you convert 01/01/2018 to text it’ll show 43101 and not 01-01-2018 to Convert the date format  01/01/2018 to 01-01-2018 automatically using excel formula […]

Search Post by Date
May 2026
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031