Tds Tax India

Excel Income Tax Calculator for F.Y. 2024-25 (Assessment Year 2025-26 )

2025-02-05T12:36:00.005+05:30

Friends,

Income Tax Calculator for F.Y. 2024-25 has been updated and given below for your use.

Major updation in the attached Excel files are as under :-

1. Standard Deduction of Rs. 75000.00 in both regime.

2. Income Tax Slab according to F.Y. 2024-25.

Download

GST RECON RELEASE 4.4

2023-08-31T15:55:00.008+05:30

Friends,

Now more automisation has been done, Import of B2B portal file downloaded from portal is able to upload through button. Duplicate or Double file can not be uploaded. In case any amendment in B2B or CDNR is avaiable, utility will inform that the amendment data is available for manual action.

In master sheet, GSTNo option is also available to protect wrong file upload.

Download

GST GSTR2B RECON RELEASE 4.2

2023-07-24T11:57:00.006+05:30

Friends, GSTR2A / GSTR2B Recon has been updated with new rules. Now a single menu has been generated for all Excel Sheets. Specifically, GSTR3B sheet has been updated with Automatic Creation. Now there is no need to remember data of Reclaim which was reversed in earlier month.

Main features of this Utility is given below :-

To define Month of Portal ITC Data, user have to Enter manully number of month in the last column of Portal Data in B2B (Portal Data) sheet named GSTR2B (Portal Data) of Menu.
Sales Data Invoice wise will be entered and outward liablity will be captured in GSTR3B automatically.
RCM data invoice wise will be entered and outward liablity will be captured in GSTR3B automatically.
Exempted Sales data invoice wise will be entered and outward liablity will be captured in GSTR3B automatically.
Nil rated data invoice wise will be entered and outward liablity will be captured in GSTR3B automatically.
Carried forward or Reclaim ITC will be auto captured in GSTR3B on the basis of Portal Data and Books ITC.

Download

Contact at uniquesolutionrtk@gmail.com through email for any query or its futher improvment.

GSTR2B RECON RELEASE 4.1

2023-02-17T14:15:00.012+05:30

Friends, As everyone knows that the GST Department has updated GSTR3b for the Month Jan 2023. Now amount of Debit or Credit Notes will be reflected in All Other ITC Column. Earlier it was shown in Others Column of ITC Reversed.

Keeping in view of the above, Excel Recon Release 4.1 in excel has been updated accordingly. Now data will be automatically shown in All Other ITC Column. Screen shot of the screen as also given below :-

Download

GSTR2B RECON RELEASE 4

2023-01-21T14:03:00.003+05:30

Friends, New GSTR3B format has been added in the new Release 4. Lot of data will be auto captured in GSTR3B. Two actions required manually for this.

1. In last column of B2B (Portal) sheet , Number of Month will have to enter for the data related to the month.

2. In the top of GSTR3B sheet , number of month will have to enter manually.

Download Latest GSTR2B Recon Release 4 (Click Here) 24.01.2023

GSTR2B Recon Release 3 THROUGH EXCEL ,

2022-05-23T14:01:00.004+05:30

Friends, GSTR2b Recon Release 3 has been updated with major issues. Now no need to press "Data Refresh All " etc with following updates.

1. File size has been reduced to 86 Kb from 2398 Kb.

2. VBA codes have been applied in Excel Utility.

3. Just copy and paste data of GSTR2b alongwith Books Data Sheet.

Download Excel Based GSTR2b Recon Release 3

Income Tax :- Excel Based Income Tax Calculator for F.Y. 2020-21

2021-06-16T11:00:00.000+05:30

Friends,

Income Tax Calculator Excel Based is ready with New Regime or Old Regime. This is in continuation with the earlier Excel based Calculators. We have tried to meet all requirements in it. However in case any problem you seems to appear, please convey through email so that the same may be corrected accordingly.

This Calculator is also helpful in submission of 24Q TDS Return with the help NSDL RPU or Others.

Download

GST :- Waiver of Interst and Late Fee in GSTR3B Returns for the month March and April 2021 in certain cases

2021-05-11T06:00:00.001+05:30

Friends, GST department has waived of late filing fee and announced reducer Rate of Interest for GSTR3b returns. Details for Normal taxpayers or Quarterly taxpayers are given below :-

(in my view , it is half harted relief which should be zero rate of interest with Nil late filing fee as there is confusion in manage or remember the due dates etc in differenet return filter cases. Therefore taxpayers should file their returns in due dates already defined (if possible ) to avoid in interest charges in futher etc.)

Waiver of interest and late fee to normal taxpayers (filing return on monthly or quarterly basis) and composition taxpayers, for the tax periods of March and April, 2021

04/05/2021

Government has granted waiver from payment of interest and/or late fee to normal (Monthly / Quarterly) & composition taxpayers for the tax periods of March and April, 2021, through Central Tax Notification Nos. 08/2021 and 09/2021, both dated 1st May, 2021. The details are summarized below:

Relaxation to normal taxpayers in filing of monthly return in Form GSTR-3B

Sl. No.	Tax Period	Class of taxpayer (Based on AATO)	Due date of filing	Reduced Rate of Interest			Waiver of late fee till
Sl. No.	Tax Period	Class of taxpayer (Based on AATO)	Due date of filing	First 15 days from due date	Next 15 days	From 31st day onwards	Waiver of late fee till
1	March, 2021	> Rs. 5 Cr.	20th April	9%	18%	18%	5th May, 2021
1	March, 2021	Up to Rs. 5 Cr	20th April	Nil	9%	18%	20th May, 2021
2	April, 2021	> Rs. 5 Cr.	20th May	9%	18%	18%	4th June, 2021
2	April, 2021	Up to Rs. 5 Cr	20th May	Nil	9%	18%	19th June, 2021

Relaxation in filing of Form GSTR-3B (Quarterly) by Taxpayers under QRMP Scheme

Sl. No.	Tax Period	Class of taxpayer (Based on AATO)	Due date of filing	Reduced Rate of Interest			Waiver of late fee till
Sl. No.	Tax Period	Class of taxpayer (Based on AATO)	Due date of filing	First 15 days from due date	Next 15 days	From 31st day onwards	Waiver of late fee till
1	March, 2021	Form GSTR-3B (Quarterly)	22/24th April, 2021, (Group A/B)	Nil	9%	18%	22/ 24th May, 2021, (Group A/B)
2	April, 2021	Form GST PMT-06	25th May, 2021	Nil	9%	18%	NA

Relaxations in filing Form CMP-08 for Composition Taxpayers : For Quarter of Jan-March, 2021, instead of 18th April, 2021, Composition Taxpayers can now file their quarterly return in Form CMP-08, without interest up to 3rd May, 2021, with 9% reduced interest between 4th May to 18th May, 2021, and with 18% interest from 19th May, 2021 onwards.

Thanking You,

Team GSTN

GST : - Extenstion of Due Dates of GST returns for the month April 2021

2021-05-10T10:09:00.007+05:30

Friends, Keeping in view the Covid-19 pendamic position , GST department has extended GST due dates for 15 days or More , which are detailed given below for your information.

Extension in dates of various GST Compliances for GST Taxpayers

04/05/2021

Government has extended the dates of various compliances by Taxpayers under GST, through Central Tax Notification Nos. 10/2021, 11/2021, 12/20211, 13/2021, 14/2021, all dated 1st May, 2021. The details are summarized below:

D. Filing of Form GSTR-1/IFF by Normal Taxpayers:

Sl.No.	Return Type(Form)	To be filed by	Tax period	Due Date	Due Date Extended till
1	Form GSTR-1 (Monthly)	Normal Taxpayer filing Monthly returns	April, 2021	11.05.2021	26.05.2021
2	Form IFF	Normal Taxpayers under QRMP Scheme	April, 2021	13.05.2021	28.05.2021

E. Filing of Returns by Composition, NRTP, ISD, TDS & TCS Taxpayers:

Sl.No.	Return Type(Form)	To be filed by	Tax period	Due Date	Due Date Extended till
1	GSTR-4	Composition Taxpayers (Annual Return)	FY 2020-21	30th April, 2021	31st May, 2021
2	GSTR-5	Non Resident Taxpayers (NRTP)	March/ April, 2021	20th April/ May, 2021	31st May, 2021
3	GSTR-6	Input Service Distributors (ISD)	April, 2021	13th May, 2021	31st May, 2021
4	GSTR-7	Tax Deductors at Source (TDS deductors)	-do-	10th May, 2021	31st May, 2021
5	GSTR-8	Tax Collectors at Source (TCS collectors)	-do-	10th May, 2021	31st May, 2021

F. Filing of Form ITC-04: The due date for filing of Form GST ITC-04 (to be filed by Principal/Manufacturer for goods sent/received/supplied from Job Worker) for the quarter Jan-March, 2021, (due date 25th April, 2021) has been extended till 31st May, 2021

Thanking You,
Team GSTN

GST :- GSTR3b or GSTRa Recon Release 2.14

2021-03-04T20:56:00.004+05:30

Friends,

To submit GSTR9 , three reconciliations are required.

1. GSTR1 Sales Recon

2. GSTR3b ITC recon

3. GSTR2a ITC recon

Two recon out of above three , can be done with the help of below excel based utility. Users have to enter some data in white cell in GSTR3b recon after entry of books sheet and GSTR3b and GSTR2a recon will be automatically prepared. After that there is no need to prepare different reports for submission of GSTR9.

What is New in Release 2.14

1) Name of Gstr9 sheet has been changed to Gstr2A Recon

2) Gstr3B Recon sheet as per GSTR9 has been inserted. Only white cells are editable.

3) State Codes for GST have also been added

(in case any problem in use of the below utility, stakeholder can contact at 9896124627)

Download

GSTR2B Reconciliation Release 2.13 with Major Updates

2021-02-13T10:10:00.006+05:30

Friends , Every time man feels that there is no futher need for updates. But after use the same new ideas or requirments arise for better result.

As per requirements , some major changes has been done in Excel Based Utility which is available free of cost. Simply copy portal and books data and paste in respective Excel Sheets in utility. Books status and Portal Status will be automatically prepared alongwith 8 number Table of GSTR9.

What is New in Release 2.13

1) Monthwise Totals of Books are available in GSTR9 sheet

2) Auto Filter, Format Cells and Format Columns are enabled in Books and (B2B)Portal Sheet

3) Auto "B/f Last Year" option is enbled in B2B (Portal) sheet as the same entries are available in sytem 2B sheet.

4) In "GSTR9 Data" Sheet, RCM data has been removed from Data as per Portal GSTR9 for 8A Column

5) "ITC Reversed in Next Year " option is enbled in Books Sheet

What is New in Release 2.12

1) In case any reverse entry in Books, Vch Type in Books Sheet can be Changed as "Reversed Entry", after that no need to Delete Extra Entries in Books Sheet

2) Blank Invoice Date in Books Sheet will be treated as UNMATCHED, earliter it was in B/f Last Year

3) To Refresh All & Save Worksheet, Macro has been created at Portal Stauts and Books Status

4) Option to type Name of Firm has also been added in Master Sheet which is also available in Portal Status and Books Status

5) Only 15 digits can be entered in the field of GST Number in B2B Sheet as well as in Books Sheet.

What is New in Release 2.11

1) Gstr9 Data sheet has also been prepared which is requied while filing annual GSTR9 if Unmatched data is not available in B2B or Books Sheet

2) Utility will inform Wrong GST Number in Books Sheet.

Action to Run this Utility

1) Download GSTR2B Release 2.11 Excel Based Utility from www.TdsTaxIndia.blogspot.com

2) Set Financial Year in Master Sheet.

3) Paste GSTR2B data in B2B Sheet and CDNR data will also be pased in B2B sheet in Minus values after download from Gst.gov.in

4) Paste Books Data in Books Sheet. In case tally user data can be exported from All Other ITC of GSTR3B

5) Portal Status and Books Status sheets are Ready for users.

6) B2B Data :-

a) In case ITC Availability Yes or Y data will be MATCHED OR UNMATCHED

b) ITC Availability Column can be changed as INELIGIBLE or ITC NOT CLAIMED with the help of Pull Down Menu manually.

Precautions :-

1) Don't try to edit,delete or Move in B2B or Books Sheet. Yellow Columns are already protected .

2) Portal Status and Books Status are available as MATCHED, UNMATCHED , B/f Last Year, C/f Next Year

3) B2B entry will also be converted as RCM, if Supply Attract Reverse Charge is Yes

4) Command to copy Data from Excel is Ctrl+Shift+End

5) Number of Enteries in Portal as well as in Books can be Checked from Master Sheet.

6) In case Data is not Correct in Portal Status or Books Status , Please follow :- Data Tab >Refresh All

7) Maximum 6000 entries can be pasted in B2B or in Books Sheets

Download

GST : - GSTR2B Reconciliation Release 2.12

2021-02-01T19:22:00.007+05:30

What is New in Release 2.12

1) In case any reverse entry in Books, Vch Type in Books Sheet can be Changed as "Reversed Entry", after that no need to Delete Extra Entries in Books Sheet

2) Blank Invoice Date in Books Sheet will be treated as UNMATCHED, earliter it was in B/f Last Year

3) To Refresh All & Save Worksheet, Macro has been created at Portal Stauts and Books Status

4) Option to type Name of Firm has also been added in Master Sheet which is also available in Portal Status and Books Status

5) Only 15 digits can be entered in the field of GST Number in B2B Sheet as well as in Books Sheet.

Release 2.11 features

1) Gstr9 Data sheet has also been prepared which is requied while filing annual GSTR9 if Unmatched data is not available in B2B or Books Sheet

2) Utility will inform Wrong GST Number in Books Sheet.

Action to Run this Utility

1) Download GSTR2B Release 2.11 Excel Based Utility from www.TdsTaxIndia.blogspot.com

2) Set Financial Year in Master Sheet.

3) Paste GSTR2B data in B2B Sheet and CDNR data will also be pased in B2B sheet in Minus values after download from Gst.gov.in

4) Paste Books Data in Books Sheet. In case tally user data can be exported from All Other ITC of GSTR3B

5) Portal Status and Books Status sheets are Ready for users.

6) B2B Data :-

a) In case ITC Availability Yes or Y data will be MATCHED OR UNMATCHED

b) ITC Availability Column can be changed as INELIGIBLE or ITC NOT CLAIMED with the help of Pull Down Menu manually.

Precautions :-

1) Don't try to edit,delete or Move in B2B or Books Sheet. Yellow Columns are already protected .

2) Portal Status and Books Status are available as MATCHED, UNMATCHED , B/f Last Year, C/f Next Year

3) B2B entry will also be converted as RCM, if Supply Attract Reverse Charge is Yes

4) Command to copy Data from Excel is Ctrl+Shift+End

5) Number of Enteries in Portal as well as in Books can be Checked from Master Sheet.

6) In case Data is not Correct in Portal Status or Books Status , Please follow :- Data Tab >Refresh All

7) Maximum 6000 entries can be pasted in B2B or in Books Sheets

Download Excel Utility

GST : - GSTR2B Reconciliation Release 2.11

2021-01-27T12:08:00.002+05:30

GSTR2B Recon Release 2.11

1 What is New in Release 2.11

1) Gstr9 Data sheet has also been prepared which is requied while filing annual GSTR9 if Unmatched data is not available in B2B or Books Sheet

2) Utility will inform Wrong GST Number in Books Sheet.

2 Action to Run this Utility

1) Download GSTR2B Release 2.11 Excel Based Utility from www.TdsTaxIndia.blogspot.com

2) Set Financial Year in Master Sheet.

3) Paste GSTR2B data in B2B Sheet and CDNR data will also be pased in B2B sheet in Minus values after download from Gst.gov.in

4) Paste Books Data in Books Sheet. In case tally user data can be exported from All Other ITC of GSTR3B

5) Portal Status and Books Status sheets are Ready for users.

6) B2B Data :-

a) In case ITC Availability Yes or Y data will be MATCHED OR UNMATCHED

b) ITC Availability Column can be changed as INELIGIBLE or ITC NOT CLAIMED with the help of Pull Down Menu manually.

3 Precautions :-

1) Don't try to edit,delete or Move in B2B or Books Sheet. Yellow Columns are already protected .

2) Portal Status and Books Status are available as MATCHED, UNMATCHED , B/f Last Year, C/f Next Year

3) B2B entry will also be converted as RCM, if Supply Attract Reverse Charge is Yes

4) Command to copy Data from Excel is Ctrl+Shift+End

5) Number of Enteries in Portal as well as in Books can be Checked from Master Sheet.

6) In case Data is not Correct in Portal Status or Books Status , Please follow :- Data Tab >Refresh All

7) Maximum 6000 entries can be pasted in B2B or in Books Sheets

Download

GSTR2B RECON Release 2.1

2021-01-24T10:58:00.005+05:30

Friends, After getting response through emails some minor changes have been done in the Excel Utility which are shared as under :-

GSTR2B Recon Release 2.1

1 Download GSTR2B Release 2.1 Excel Based Utility after email request at jain_heena1987@yahoo.co.in

2 Download GSTR2B data in Excel from Gst.gov.in website and paste all fileds in B2B sheet of Release 2.1 utility

3 Columns in yellow color are protected .

4 Portal Status and Books Status are available as MATCHED, UNMATCHED or B/f Last Year

5 Portal Status is also available as RCM, if Supply Attract Reverse Charge field in B2B is Yes

6 B2B Data :-

In case ITC Availability Yes or Y data will be MATCHED OR UNMATCHED

User can change Data in ITC Availability as below:- INELIGIBLE, ITC NOT CLAIMED

7 Books Data can be pasted after Export Data in Excel from All Other ITC of GSTR3B from Tally.

8 Command to Select Data from Excel is Ctrl+Shift+End

9 Financial Year can be changed from Master Sheet

10 Number of Enteries of Portal as well as Books can be Checked from Master Sheet.

11 In case Data is not Correct in Portal Status or Books Status , Please follow :- Data Tab >Refresh All

Direct Download

GST :- GSTR2B Reconciliation through Excel

2021-01-19T22:01:00.001+05:30

Friends,

Now, GST (Goods and Service Tax) is great issue for everyone. Recently Govt. Department has restricted to registered dealer to claim ITC as per System Generated GSTR2B + 10% variation.

Registered dealer can claim ITC in the same month if his vendor submit his returns in time. Monthly returns can be submitted with in 11th of the next month or Quarterly returns can be submitted with in 13th of the next quarter.

Filing date of GST returns can be checked through below mentioned link.

Filing Dates of GST Returns

To view the filing dates , you have to press SHOW FILING TABLE in the bottom of the above screen.

Now , an Excel utility has been prepared to match books or portal data. In case you are using Tally Accounting Software, books data can be collected through All other ITC of GSTR3b in Excel and Portal Data is available at portal in GSTR2b.

Free Excel Utility will be sent through email after request at email jain_heena1987@yahoo.co.in.

TCS :- TCS on any other Sale

2020-11-01T20:25:00.003+05:30

Friends, TCS on sale of goods is applicable w.e.f. 01.10.2020 with some conditions as per Circular No 17/2020 dated 29th September 2020. The following conditions should be apply before charging TCS on Sale :-

1. Previous year sale should be 10 Crore.

2. Threshold limit is Rs. 50 Lakh in this Financial Year only those who have 10 Crore Sale in Previous Year.

Today, is 1st Nov, 2020 , it is time to deposit collected TCS on Sale. Now , a general question arise that in which collection code amount of tcs can be deposited.

It is clear while deposit on line TCS through challan no 281, Collection Code is 6CR- TCS on sale of Goods.

Income Tax :- Due Dates for the month June 2020

2020-05-28T08:56:00.003+05:30

Due Dates for the Month June 2020 are given below as per Income Tax website.

7 June 2020 -

Due date for deposit of Tax deducted/collected for the month of May, 2020. However, all sum deducted/collected by an office of the government shall be paid to the credit of the Central Government on the same day where tax is paid without production of an Income-tax Challan*

14 June 2020 -

Due date for issue of TDS Certificate for tax deducted under section 194-IA in the month of April, 2020*

14 June 2020 -

Due date for issue of TDS Certificate for tax deducted under section 194-IB in the month of April, 2020*

14 June 2020 -

Due date for issue of TDS Certificate for tax deducted under section 194M in the month of April, 2020*

15 June 2020 -

Due date for furnishing of Form 24G by an office of the Government where TDS/TCS for the month of May, 2020 has been paid without the production of a challan*

15 June 2020 -

Quarterly TDS certificates (in respect of tax deducted for payments other than salary) for the quarter ending March 31, 2020*

15 June 2020 -

First instalment of advance tax for the assessment year 2021-22*

15 June 2020 -

Certificate of tax deducted at source to employees in respect of salary paid and tax deducted during Financial Year 2019-20*

15 June 2020 -

Due date for furnishing statement in Form no. 3BB by a stock exchange in respect of transactions in which client codes been modified after registering in the system for the month of May, 2020*

29 June 2020 -

Due date for e-filing of a statement (in Form No. 3CEK) by an eligible investment fund under section 9A in respect of its activities in financial year 2019-20.*

30 June 2020 -

Due date for furnishing of challan-cum-statement in respect of tax deducted under section 194-IA in the month of May, 2020*

30 June 2020 -

Due date for furnishing of challan-cum-statement in respect of tax deducted under section 194-IB in the month of May, 2020*

30 June 2020 -

Due date for furnishing of challan-cum-statement in respect of tax deducted under section 194M in the month of May, 2020*

30 June 2020 -

Return in respect of securities transaction tax for the financial year 2019-20*

30 June 2020 -

Quarterly return of non-deduction of tax at source by a banking company from interest on time deposit in respect of the quarter ending March 31, 2020*

30 June 2020 -

Statement to be furnished (in Form No. 64C) by Alternative Investment Fund (AIF) to units holders in respect of income distributed during the previous year 2019-20*

30 June 2020 -

Report by an approved institution/public sector company under Section 35AC(4)/(5) for the year ending March 31, 2020*

30 June 2020 -

Due date for furnishing of statement of income distributed by business trust to its unit holders during the financial year 2019-20. This statement is required to be furnished to the unit holders in form No. 64B*

GST :- DIFFERENCE BETWEEN EXEMPT , NIL RATE OR ZERO RATE

2020-05-27T16:22:00.000+05:30

Friends, In Gst there are three words Exempt , Nil Rate or Zero Rate which needs clarity while making GST accounting or filing GST Returns etc. I want to share in few words regarding difference between Exempt, Nil Rate or Zero Rate.

To know the above difference , everyone should know two other words like ITC or Output Tax Liability.. ITC (Input Tax Credit) is used for Taxable Purchases and Output Tax Liability is used for GST on Sales.

1) Exempt :- GST Rates exempted through GST Notification.

2) Nil Rate :- ITC will be Nil and Output Tax Liability will be Nil.

3) Zero Rate :- ITC will be available but Output Tax Liability will be Zero. Means Sale of Taxable product in SEZ unit or Export etc.

Gst :- Extension in Due Dates for filing GST returns or waiver of Late Fee and Interest etc.-Part 3

2020-04-17T10:32:00.003+05:30

Filing Dates extended for providing relief to taxpayers in view of COVID-19 pandemic- Part 3

07/04/2020

7. Interest liability for filing Form GSTR-3B

a. Taxpayers having aggregate turnover > Rs. 5 Cr. in preceding FY

Tax period (a)	Interest not payable,if filed by (b)	Date from which interest is payable@ 9% till date of filing,if filed by 24th June, 2020 (c)	Date from which interest is payable@ 18% till date of filing,if not filed by 24th June, 2020 (d)
Feb, 2020	4th April, 2020	5th April, 2020	21st March, 2020
March, 2020	5th May, 2020	6th May, 2020	21st April, 2020
April, 2020	4th June, 2020	5th June, 2020	21st May, 2020

b. Taxpayers having aggregate turnover of > Rs. 1.5 crores and upto Rs. 5 crores in preceding FY

Tax period (a)	Interest not payable,if filed by (b)	Date from which interest is payable @18%, if not filed by dates in Column (b),for taxpayers falling in States/UT of Group 1 (c)	Date from which interest payable @18%, if not filed by dates in Column (b), for taxpayers falling in States/UT of Group 2 (d)
Feb, 2020	29th June, 2020	23rd March, 2020	25th March, 2020
March, 2020	29th June, 2020	23rd April, 2020	25th April, 2020
April, 2020	30th June, 2020	23rd May, 2020	25th May, 2020

c. Taxpayers having aggregate turnover of upto Rs. 1.5 crores in preceding FY

Tax period (a)	Interest not payable,if filed by (b)	Date from which interest is payable @18%, if not filed by dates in Column (b),for taxpayers falling in States/UT of Group 1 (c)	Date from which interest payable @18%, if not filed by dates in Column (b), for taxpayers falling in States/UT of Group 2 (d)
Feb, 2020	30th June, 2020	23rd March, 2020	25th March, 2020
March, 2020	03rd July, 2020	23rd April, 2020	25th April, 2020
April, 2020	06th July, 2020	23rd May, 2020	25th May, 2020

Note: To know in detail about States or UTs falling in Group 1 or 2, refer point no 1 (d) of the Part 1 of the advisory (click here

Click Here To View Part-1
Click Here To View Part-2

Gst :- Extension in Due Dates for filing GST returns or waiver of Late Fee and Interest etc.-Part 2

2020-04-17T10:31:00.000+05:30

Filing Dates extended for providing relief to taxpayers in view of COVID-19 pandemic- Part 2

07/04/2020

3.Opt in for Composition in FY 2020-21

Normal Taxpayers wanting to opt for Composition should not file GSTR3B and GSTR 1 for any tax period of FY 2020-21 from any of the GSTIN on the associated PAN.

Form	Tax period (FY)	Extended Date
GST CMP-02	2020-21	30.06.2020
GST ITC-03	2019-20 (As on 31-3-2020)	31.07.2020

4.Compliances for Composition taxpayers:

Form	Tax period	Extended Date
GST CMP-08	Jan to March 2020	07.07.2020
GSTR-4	FY 2019-20	15.07.2020

5.NRTP, ISD, TDS & TCS taxpayers:

Sl. No.	Return Type,Form	To be filed by	Tax Period	Due Date	Extended Date
1	GSTR-5	Non Resident Taxpayers	March, April & May, 2020	20th of succeeding month	30th June, 2020
2	GSTR-6	Input Service Distributors	-do-	13th of succeeding month	30th June, 2020
3	GSTR-7	Tax Deductors at Source (TDS deductors)	-do-	10th of succeeding month	30th June, 2020
4	GSTR-8	Tax Collectors at Source (TCS collectors)	-do-	10th of succeeding month	30th June, 2020

6.Extension of validity period of EWB:

E-way bills (EWB), whose expiry date lies between 20th March, 2020, and 15th April, 2020, would also be deemed to be valid till 30th April, 2020.

Click Here To View Part-1
Click Here To View Part-3

Gst :- Extension in Due Dates for filing GST returns or waiver of Late Fee and Interest etc.-Part 1

2020-04-17T10:17:00.001+05:30

Friends,

Filing Dates extended for providing relief to taxpayers in view of COVID-19 pandemic- Part 1

07/04/2020

Due to COVID-19 pandemic and challenges faced by taxpayers, Government has extended dates for GST filings. These are notified in Notifications 30/2020 to 36/2020 dated 03.04.2020. Circular No. 136/06/2020-GST dated 3rd April, 2020 has been issued.

1. Normal Taxpayers filing Form GSTR-3B

a.Taxpayers having aggregate turnover > Rs. 5 Cr. in preceding FY

Tax period	Late fees waived if return filed on or before
Feb, 2020	24th June, 2020
March, 2020	24th June, 2020
April, 2020	24th June, 2020
May, 2020	27th June, 2020 (extended due date for filing)

b.Taxpayers having aggregate turnover of > Rs. 1.5 crores and upto Rs. 5 crores in preceding FY

Tax period	Late fees waived if return filed on or before
Feb, 2020	29th June, 2020
March, 2020	29th June, 2020
April, 2020	30th June, 2020

c.Taxpayers having aggregate turnover of upto Rs. 1.5 crores in preceding FY

Return/Tax period	Late fees waived if return filed on or before
Feb, 2020	30th June, 2020
March, 2020	03rd July, 2020
April, 2020	6th July, 2020

d.Taxpayers having aggregate turnover of upto Rs. 5 Cr. in preceding FY

Tax period	Extended date and no late fees if return filed on or before	Principal place of business is in State/UT of
May, 2020 Group 1 States/UTs	12th July, 2020	Chhattisgarh, Madhya Pradesh, Gujarat, Maharashtra, Karnataka, Goa, Kerala, Tamil Nadu, Telangana, Andhra Pradesh, Daman & Diu and Dadra & Nagar Haveli, Puducherry, Andaman and Nicobar Islands, Lakshadweep
May, 2020 Group 2 States/UTs	14th July, 2020	Himachal Pradesh, Punjab, Uttarakhand, Haryana, Rajasthan, Uttar Pradesh, Bihar, Sikkim, Arunachal Pradesh, Nagaland, Manipur, Mizoram, Tripura, Meghalaya, Assam, West Bengal, Jharkhand, Odisha, Jammu and Kashmir, Ladakh, Chandigarh, Delhi

2.Normal Taxpayers filing Form GSTR-1

Tax period	Due Date	Waiver of late fee if return filed on or before
March 2020	11.04.2020	30.06.2020
April 2020	11.05.2020	30.06.2020
May 2020	11.06.2020	30.06.2020
Quarterly taxpayers Jan to March 2020	30.04.2020	30.06.2020

Click Here To View Part-2
Click Here To View Part-3

Income Tax :- Income Tax Rates for the Financial Year 2019-20

2020-03-24T11:24:00.001+05:30

Friends, No doubt Corona is great problem for everyone. As per orders of Prime Minister or to safe everyone , it is best to work from home. In case you want to plan your income tax for Financial Year 2019-20 or Assessment Year 2020-21 from your house,below mentioned tax slabs may be helpful for you.

Income Tax Slabs

Financial Year 2019-20

A. Tax Rates For Individuals (Men & Women), Hindu Undivided Families, Association of Persons and Body of Individuals
Total Income (Rs.)	Tax Rate (%)
Upto Rs. 250,000*	Nil
250,001 to 500,000	5
500,001 to 10,00,000	20
Above Rs. 10,00,000	30
In the case of a resident individual of sixty years or more but less than eighty years, the basic exemption limit is Rs. 3,00,000 Relief for Taxpayers in the first bracket of '250000' to '500000'. A Tax credit of 12500 to every person with total taxable income upto 5,00,000
* Deduction under section 16(ia) of Rs.50000.
The category of women below the age of 65 years has been removed

B. Tax Rates For Senior Citizens (80 Years Or Above)
Total Income (Rs.)	Tax Rate (%)
Upto Rs. 500,000*	Nil
500,001 to 10,00,000	20
Above Rs. 10,00,000	30
Surcharge is @ 15% if total taxable income is in excess of Rs. 10,000,000
Education cess is applicable @ 4% on income tax
Marginal relief may be available

C. Tax Rates For For Partnership Firms
Tax Rate (%)
Partnership Firms are taxable @ 30%
Surcharge is @ 12% if total taxable income is in excess of Rs. 10,000,000
Education cess is applicable @ 4% on income tax

D. Tax Rates For Domestic Companies
Tax Rate (%)
Domestic companies are taxable @ 25% where gross receipt in the previous year does not exceed fifty crore rupees
Domestic companies are taxable @ 30% where gross receipt in the previous year exceed fifty crore rupees
Surcharge is 7 % if total taxable income is in excess of Rs. 10,000,000 but not exceeding 100,000,000
Surcharge is 12 % if total taxable income is in excess of Rs. 100,000,000
Education cess is applicable @ 4% on income tax (inclusive of surcharge, if any)

E. Tax Rates For Foreign Companies
Tax Rate (%)
Foreign companies are taxable @ 40%
Surcharge is 2 % if total taxable income is in excess of Rs. 10,000,000 but not exceeding 100,000,000
Surcharge is 5 % if total taxable income is in excess of Rs. 100,000,000
Education cess is applicable @ 4% on income tax (inclusive of surcharge, if any)

F. In the case of every co-operative society	Tax Rate (%)
(1) where the total income does not exceed Rs. 10,000	10 per cent. of the total income
(2) where the total income exceeds Rs. 10,000 but does not exceed Rs. 20,000	Rs. 1,000 plus 20 per cent. of the amount by which the total income exceeds Rs. 10,000
(3) where the total income exceeds Rs. 20,000	Rs. 3,000 plus 30 per cent. of the amount by which the total income exceeds Rs. 20,000
Surcharge is 12 % if total taxable income is in excess of Rs. 10,000,000
Education cess is applicable @ 4% on income tax

Income Tax :- Excel Based Income Tax Calculation for the F.Y. 2019-20 or A.Y. 2020-21

2020-03-22T13:35:00.002+05:30

Friends, Individual Income Tax Calculation in excel has been updated according to Income Tax Rule for the F.Y. 2019-20 or Assessment Year 2020-21. The following changes have been done :-

1. Deduction u/s 16(1a) of Rs. 50,000.00

2. Relief for Taxpayers in the first bracket of '250000' to '500000'. A Tax credit of 12500 to every person with total taxable income upto 5,00,000.

Download Excel Based Income Tax Calculator (Download )

GSTR9 ANNUAL GST RETURN

2019-08-07T13:52:00.002+05:30

Friends, It is clear that Annual GST return for the Financial Year 2017-18 is to be submitted upto 31-08-2019. There are lot of questions regarding submission of Data in Annul Return.

1. What should be prepared for preparation of Return.

2. No-body is submitting GSTR-9 Return , only Data is collecting with fear to submit.

3. Numbers of columns are available in return.

4. Data already submitted in GSTR-1, GSTR-3B, GSTR-2A are auto populated, but do now know that place in which Books Data or Actual Data will be entered in GSTR-9.

5. How can we enter HSN Code with 4 digit in online.

6. ITC available in GSTR-2A in F.Y. 2017-18, but availed in F.Y. 2018-19 will be entered in which columns.

I have also faced some problems out of above and resolved after views below videos :-

You Tube Video https://www.youtube.com/watch?v=CBb-F8tYTKY

Income Tax :- Excel Based Income Tax Calculator the F.Y. 2018-19

2019-04-16T16:01:00.000+05:30

Friends, I am getting messages for providing Excel Based Income Tax Calculator for the F.Y. 2018-19 , Assessment Year 2019-20. It is helpful the submitting Fourth Quarter TDS Return in NSDL RPU.

There are two changes in this Calculator which are detailed given below :=

1. Standard Deduction of Rs. 40000 under section 16(a1)

2. Cess percentage @ 4% instead of 3%

To download the Excel Based Calculator for F.Y. 2018-19 (Click Here)