UPDATED GST Reconciliation.Copy your data from the GSTR-3B/1-PDF file and paste the same in the sheet given in the file. Provide details as per tally. Enter GST payment details in Cash ledger. Enter Transitional Credit/Refund Claimed in Credit Ledger.
Kindly Refer to
Privacy Policy &
Complete Terms of Use and Disclaimer.
Access Denied! Only Regstered Users Can Download The File "GST Reconciliation -Cash-Credit Ledger-GSTR-1-GSTR-3B-Tally". Register Here or Login
Author Bio
2018-18 gst period there is amount unutilised in our electronic ledger,can we transfer the above period arrears to our tax arrears of the above period.please clarify.
please provided password so open protected excel fiel
IN GSTR-3B SHEET C6
28389770.47 0 425846.58 425846.58 0
28389770.47 0 425846.58 425846.58 0
28389770.47 0 425846.58 425846.58 0
28389770.47 0 425846.58 425846.58 0
Please do this step in another sheet and then paste it back to ‘paste GSTR-3B’ sheet. “Select D2:T2 then select up to the end of last GSTR-3B>Ctrl+h>Replace “-” (Dash) with “0” (ignore inverted comma)>replace all”
Kindly replace GSTR03B with GSTR-3B and 2017018 with 2017-18 also else you won;’t get GSTR-3B data