GSTR 3B - Auto Tax Calculation Excel Utility Ver- 1.4

GSTR 3B -OFFLINE UTILITY (NEW ITC SET-OFF)

We know that goverment was changed itc set- off rule as per the provisions of Section 49 of the CGST Act, credit of integrated tax has to be utilised first for payment of integrated tax, then Central tax and then State tax, in that order mandatorily. In this term, it is not easy way to calculate how much gst payble in which ledger. It is a very complex calculation before GSTR 3b itc set-off.

Mostly people have calculate wrong tax amount before itc set-off and paid gst in wrong head.

So we developed an offline utility for GSTR 3B, it calculates gst payble automatically. In this sheet you can easily find out how much gst paid through challan and which head. 

You can easily maintain your monthly data and keep records every month of returns.

So lets know we learn..  

How to works this rules in this sheet?

Gstr 3B format 1st  Sheet- GROSS OUTPUT AND INPUT DETAILS

Sheet is fully protected due to given formulas.

Only 11 areas are not protected, punch your data in white fileds.

(1) INTRA STATE OUTWARD SUPPILES - (GROSS AMOUNT OF LOCAL SALES/SERVICES RATE WISE)

(2) INTER STATE OUTWARD SUPPLIES-  (GROSS AMOUNT OF CENTRAL SALES/SERVICES RATE WISE)

(3)INTRA STATE INWARD SUPPILES - (GROSS AMOUNT OF LOCAL PURCHASE RATE WISE)

(4)INTER STATE INWARD SUPPILES - (GROSS AMOUNT OF CENTRAL PURCHASE RATE WISE)

(5) NON GST SUPPLY-  (OUTWARD AND INWARD)

(6) ITC REVERSED OTHER-  (IF WRONGLY TAKEN ITC IN PREVIOUS RETURN)

(7) INPUT AS PER 2A -  (IF YOU WANT TO TAKE INPUT AS PER GSTR 2A)

(8) INELIGIBLE ITC -  (IF YOU TAKEN INELIGIBLE ITC  WHICH ARE SHOWN IN 2A)

(9) OPENING INPUT CREDIT LEDGER-  (PREVIOUS MONTH ITC C/F)

(10) OPENING CASH LEDGER BALANCE-  ( IF ANY)

(11) TAX PAID-  (NET CHALLAN AMOUNT OF GST PAYBLE)

If you punch data properly then sheet automaticaly generates net GST payble and ITC credit.



2ND-SHEET-    REVERSE CHARGE ON INWARD SUPPLIES.

Only 6 areas are not protected, punch your data in white feilds.

(1) INTRA STATE INWARD SUPPILES -(GROSS AMOUNT OF REVERSE CHARGE COMMON CREDIT RATE WISE)

(2) INTER STATE INWARD SUPPILES -(GROSS AMOUNT OF REVERSE CHARGE COMMON CREDIT RATE WISE)

(3) INTRA STATE INWARD SUPPILES -(GROSS AMOUNT OF REVERSE CHARGE  T4 RATE WISE)

(4) INTER STATE INWARD SUPPILES -(GROSS AMOUNT OF REVERSE CHARGE  T4 RATE WISE)

3RD- SHEET-    ITC ELIGIBILITY

Sheet is fully protected due to given formulas. ( Adjust if credit available in T1, T2, T3)

4TH SHEET- Challan

Sheet is fully protected due to given formulas. ( only mention late fees and other as per gst portal)

5TH SHEET-  Auto GSTR-3B

Sheet is fully protected due to given formulas. ( only yellow fields are not protected)

Enter data in sheet 1 and sheet 2 and it automaticaly generate 3B Return. Only click validate and generate json. Before validate you must enter your Legal Name and GST No in sheet 1- Summary, Select year and month in Auto GSTR-3B.

You can upload Generated json file in GST portal and file your return.

6TH SHEET- HELP & USER MANUAL

YOU CAN EASILY FILE YOUR 3B REURN WITH THIS UTILITY (NEW ITC SET OFF) .

GSTR 3B - AUTOMATIC TAX CALCULATION EXCEL UTILITY VER 1.4
   Rs. 249/-

           
 Contact us - justinfozsite@gmail.com
                       +91 7488457683



           FOR MORE INFORMATION ABOUT GST - SUBSCRIBE OUR OFFICIAL 
           YOUTUBE CHANNEL-  -  JUST INFOZ 


Please leave a reply.

Name:
E-mail: *
Query/Suggestions: *

https://www.justinfoz.com