How to Generate GSTR3B in UNISOLVE/CROSS
For GSTR3B you need to update your software to US 16.2.20 or later version. Please take your data backup and update your version using any of the following two ways:
If you are using US 16.2.17 or later version, please run Help->Download Last Patch option from the software. Please exit from nodes if you are running on LAN.
Download US 16.2.20 Version file from ftp.bhiwal.com\_GST_UNISOLVE_CROSS\PATCH\LAST PATCH.ZIP Please unzip this file in your US162/CS162 (or in the folder from where US.exe/CS.exe is being run).
You have to follow following steps to generate GST tax details & submit GSTR3B:
STEP 1: Reports->GST Forms->Generate GST Tax Summary:-> This report generates all the required GST figures & provides you the summary. You can give this report to your CA/Accountant to prepare your GSTR3B and deposit tax
If you see difference in figures (DATA MISMATCH) for GST forms and from ledger, please read the notes provided in bottom of the report and follow the instructions to reconcile the differences. Still if you need our help, you ahve to provide us data and contact online support. Please note that multiple entries for GST forms may have been posted into one ledger account and you may need to total all entries for one account to reconcile them with ledger figures.
1. Make sure purchase bill calculation matches with bill amount.
2. Correct GST tax codes are entered for Interstate CG tax codes and within state PG tax codes
3. For sales figures, make sure you are matching total of multiple entries if all entries belong to same ledger account.
4. Please check if same tax code is not appearing multiple time or missing in Tax Master.
5. Please note if same station is not appearing multiple time or missing in station master.
6. Special case: If you entered entries in accounts from other software, or you are using common software for Unisolve/Cross or you are having multiple branches and importing transactions in accounts, In such cases, you will have to generate multiple GSTR 3B forms and total the entries manually to match with ledger accounts. For filing of GSTR 3B, you have to use totals from multiple GSTR 3B forms.
7. Difference in invoice calculation account exist in System Parameters and Purchase Methods. Now you should use GENERAL purchase method in invoice. If you rectify any posting account in system parameter or purchase method, you have to run posting of invoices again.
8. If you rectify invoices or run posting again, you have to Generate tax summary again.
9. Even if difference with accounts, GSTR3B figures stand better chance to be correct.
10. If there are small difference is purchase invoice less than 0.01% of invoice value, you can ignore the same as you will get a chance to handle purchase mismatch at the time of filing GSTR 2. Better approach is to rectify your purchase invoice, (enter rates upto 3 decimals if required) and try to match the figures.
STEP2: Reports->GST Forms->GSTR3B:-> You need to first run Generate GST Tax Summary option from Reports->GST Forms menu to generate GSTR3B report. You can give this report in excel/pdf format to your CA/Accountant to finalize your GSTR3B and deposit tax
Auto return filing System:-> If you are using UNISOLVE, CROSS, you can use auto filing options from software for file GST returns. As you need to interact with GSTN minimum 5 or six times in a month, taking data out on excel format and filing return using other options may not be suitable.
As you may be aware, Government has established GSTN for handling GST Returns and to connect with GSTN, GSPs are appointed by Government. Out of these GSPs, we have provided integration in our software with two GSPs namely 1. KARVY (https://www.karvygst.com) and 2. GST SURE (BODHTREE) (http://www.gstsure.com)
For registration with GSTSure please visit gsp.swindia.com (It will start working soon.)
For registration with karvygst.com please visit asp.swindia.com.
At the time of registration, you have to enter your mobile and email id for registration as Taxpayer. You will get OTP on mobile and email and will have to confirm the same. You have to select your business size based on no. of invoices and interstate purchase or sales. By uploading all your purchase and sales transactions, you will be able to generate GSTR 3B on GSP website.
You will have option to add user and role inside GSP website and provide login to your CA. CA will be able to see all data from his office, check the same and finally upload and/or file R1, R2, R3 to GSTN.
Please note that since no API is provided by GSTN to GSPs like KARVY and GSTSure to file GSTR 3B, you have to login to GSTN and file GSTR 3B there.
As there has been lot of confusion during July month, you can simply enter all sales return of goods sold before 30th June, in the date of 30th June only. As you have not filed STRTRAN1 yet, it can be included in STRTRAN1.
If any returns are for GST goods, you should enter it in August, so that July returns are filed easily.
There is no provision for revised return under GST Act. You cannot make any changes in transactions afterwards and you must use credit/debit notes if any changes are required afterwards. Correction in GSTR 3B is done by filing GSTR 1 and GSTR 2 in SepTember 2017.
We are providing following menu options to file GST Return in Reports->GST Forms Menu:-
Registration: You have to register with any one GSP using this option.
GSTR Login: You have to enter your registered username and password here to use in software.
Upload Sales Invoice for GSTR 1: Upload sales invoice/debit note/reverse charge transaction details to GSTN.
Upload Sales Credit Notes for GSTR 1: Upload sales credit note details to GSTN.
File GSTR 1: Review & Submit GSTR 1 using this option.
Upload Purchase Invoices: You can upload purchase transactions using this option. Reverse charge entries are also updated using this option. Please note that reverse charge is applicable for purchase from unregistered dealers beyond a daily limit of Rs. 5000/-
Upload Purchase Debit Notes for GSTR 1: Upload Purchase debit note details to GSTN.
View GSTR 2: You can view GSTR 2 after 10th of month, which is auto populated by GSTN.
Purchase Mismatch: See purchase mismatch in GSTR 2 and uploaded purchase transactions.
SUBMIT GSTR 2A: Finally submit GSTR 2A on GSP website, with all proposed corrections.
VIEW GSTR 1A: Submit GSTR 1A from GSP website after doing corrections.
PAY TAXES: Check due tax amount and pay using online payment gateway.
File GSTR 3: Check prepared return based on uploads and filing of GSTR 1, GSTR 2A & GSTR 1A.
STRTRAN 1 is to be filed before 30th Sep. This format will be provided soon. Right now there is a confusion that it requires 6 digit HSN code whereas all other GST returns require 4 digit HSN code. It will enable you to claim credit for CGST and SGST via STRTRAN 2 every month. STRTRAN 2 is to be filed for each month from July to December after filing STRTRAN 1 and it will enable you to claim credit for CGST and SGST on stocks lying with you on 30th June and sold within 6 months. This credit is provided by GSTN in GSTR 3 and you do not have to claim it in GSTR 3 B or GSTR 1 or GSTR 2.
For expiry, being pharmaceutical HSN code should be 3006 and tax rate should be 12%. Still we have no clarity on this issue.
Accounts->GST Transactions->GST Input option is to be used for all purchases other than goods. These entries will appear in R2 when you calculate GST (Yes). e.g. Stationery Purchase or AMC of software, where you can claim GST input credit. Please note that GST input credit is available only when your supplier uploads R1 and your GSTIN is mentioned in R1 uploaded by him.
For entering credit notes of discount received from companies if it includes GST then, please use Accounts->GST Transactions->GST Input Reverse (Purchase Return) option. Enter HSN Code 3004, Discount Amount, Tax Code, Debit Account - Supplier Account and Credit Account - Purchase or Discount recd. on Purchase Account.
GST for Composition Dealer
i. Registration: You can register by making online payment to GSP for filing GST Returns from this option.
ii. View GSTR 4A: You will be able to view GSTR 4A for all the transactions uploaded by your supplier.
iii. Upload GSTR 4A: You will be able to submit your GSTR 4 details using this option. You can again view GSTR
4A after uploading these details. You can make corrections as well. You have to enter reverse charge tax entries here.
iv. PAY TAXES: It will take you to GSP web site and you will be able to see due tax amount and pay the same to
Government using online payment gateway. It is required before filing GSTR 4.
v. File GSTR 4: It will take you to GSP web site and you will be able to see the return prepared based on all
uploads and filing of GSTR 4A. You have to accept it and submit the same.
GSTR1,R2, R3, R3B and STRTRAN1, STRTRAN2 are not required by composition dealer.