How to rectify data mismatch in tax summary ?
You always want to check your data generated for GST forms if it is correct or not, and you want to match the same with your accounting ledgers. For this purpose, we have provided GST Tax summary report which shows you both figures, generated for the purpose of GST forms (which are directly calculated from invoices again) and the ledger account figures, which have been posted post transaction during the period. You can provide GST Tax summary to your CA for filing GSTR 3B. It will serve purpose for him.
If you see difference in figures (DATA MISMATCH) for GST forms and ledger amount, 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 have 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. You can check wrong calculation purchase bills using GST forms menu or daily report in Reports menu.
2. Correct GST tax codes are entered for Interstate CG tax codes and within state PG tax codes. If your station or state in station is wrong in customer or supplier master, wrong tax codes may be entered.
Correct tax codes for GST invoices are: (For all GST Tax codes, second character is G)
SG for sales invoice within state (intra state)
IG for sales invoice outside of state (inter state)
PG for purchase invoice within state (intra state)
CG for purchase invoice outside of state (inter state)
If you see any wrong tax code or old tax codes in invoices like STP, ST, SR, SM or SV etc for sales and PTP, PR, PT,PM, PV etc for purchase, please modify the invoices and rectify the same. If tax code is not editable, please set edit tax type YES in system Parameters.
3. For sales figures, make sure you are matching total of multiple entries if all entries belong to same ledger account. Such entries have repeat word in front of them. In Ledger amount, there is one more value displayed in brackets (Debit amount-Credit Amount). It displays returns during tax period.
4. Please check if same tax code is appearing multiple time or missing in Tax Master. Remove duplicates.
5. Please check if same station is appearing multiple time or missing in station master. Remove duplicates.
6. Please check if same ACISNO is appearing multiples times in ACCOUNT or ACADDRESS. Remove duplicates.
7. 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.
8. 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.
9. If you rectify invoices or run posting again, you have to Generate tax summary again.
10. Even if difference with ledger amounts, GST forms figures stand better chance to be correct, provided only GST tax codes are there in tax summary. There should not be any tax code without second character 'G' in it.
11. 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. You can set Purchase rates for 3 decimals in System Parameters - Edit tab,.
Note: If you have interstate sales to unregistered dealer with invoice value more than Rs. 2.5 lac, you can make a list of such invoices manually using interstate sales register (GST) and export it to excel.
|
|
Related Articles
How to rectify your data for GST Returns in Cross ?
In retail shop, it is always difficult to update tax codes for all products and in some cases, they are not updated from day one. As we get purchase invoice, we are able to know actual tax rate for particular item. Using 16.2.20 you can run following ...How to rectify wrong tax code being charged in invoice
Pl download attached file: How to Use GST Tax Type for Within State (Intra State) and Out of State - (Inter-State) Working If you see that tax code or tax calculation is wrong, please check following: 1. The tax code window is opening and tax is not ...How to reconcile and file GSTR 2 with purchase data ?
YouTube Video Link for GSTR2 Upload How to Download new patch for Unisolve-Cross Please download last patch (Release 31 or later) for Unisolve/Cross version 16.2 We have provided offline reconciliation option for GSTR 2 in this release. This is ...Zero Data Entry in Unisolve Software to Scan Product Batch Details
How to Scan Product Batch Details with Zero Data Entry Process A new feature has added in Unisolve software to scan products' batch details without doing any data entry. With this option, you have to scan the product via AllScan mobile application, ...How to export HSN wise sales invoice data to excel for GSTR 1/GSTR 2 ?
GST Data is generated by Generating Tax Summary. You can provide this GST summary data to a tax consultant, using this data your accountant/tax consultant or CA will be able to prepare R1/R2 using his software or excel offline tool provided by ...