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

 NEW ITC SET-OFF RULES FOR GSTR 3B 

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 payble in wrong head.

So we developed an utility for auto gst payble calculation. 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 7 areas are not protected where you punch your data.

(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) OPENING INPUT CREDIT LEDGER-  (PREVIOUS MONTH ITC C/F)

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

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

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

Total 4 parts in Gstr 3b excel utility.

2ND-SHEET-    REVERSE CHARGE ON INWARD SUPPLIES.

Only 6 areas are not protected where you punch your data.

(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- 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.3
   Rs. 199/-

           

            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