Reconciliation under GST is a crucial step that you, as a taxpayer, need to undertake to avail input tax credit. For every month’s GST filing, you need to reconcile your purchase data with all your suppliers’ sales data that they have uploaded on GSTN. Upon reconciliation under GST, if the data on both ends match, claiming ITC can be a walk in the park. However, an account of mismatch can put you on an arduous journey, exploring through huge piles of invoices for one simple error.
So what can you do?
Well, to put it simply, GST reconciliation can be attained in three 3 simple steps: Identify Mismatches, Review the same and Communicate with your vendors for rectification!!
1. Identify
Let us assume, a consignment was procured under the invoice number ‘AST-1202’ with a billing amount of Rs. 110.86. The consignment was recorded by the supplier in his GSTR 1 i.e. Sales Return in Feb 2018. The goods were delivered at your warehouse in Maharashtra (which is the place of supply) in Mar 2018 and you claimed ITC in Mar 2018. However as the dispatch of goods was from Karnataka, he mentioned the place of supply as Karnataka with Invoice Value of 111 in GSTR1.
To begin your venture into the world of a hassle-free reconciliation under GST, the very first step is to identify the discrepancies occurring in your records and your suppliers’ sales data. Let’s analyse the above-mentioned scenario to identify possible discrepancies.
A. Mismatching Invoice No.
A discrepancy can occur if the invoice number in the data filed by your supplier to GSTN does not match with your records. This can happen if:
- An error is made while preparing the GSTR1 by the supplier and there is a wrong invoice number submitted: Accidentally filing invoice number as AST-1220 instead of AST-1202.
- The data is filed in a mismatching format such as skipping hyphen i.e. AST 1220 instead of AST-1202.
B. Mismatching Invoice Data
If your invoice numbers match, the next step is to evaluate your invoice data for any mismatching data. Commonly found mismatches in invoice data are:
- Total Invoice Value (Rounding up the amount to 111 instead of 110.86)
- Tax Amount (Calculating tax under the wrong slab)
- Taxable Amount (Rounding up the amount to 100 instead of 100.06)
- Place of Supply (Supplier puts his state code instead of the correct state which is your state)
C. Cross Period Invoices
The month of booking of an invoice by the supplier can be different than the booking of the same purchase invoice by you. For example, the supplier could have filed the invoice in Jan 2018 month’s GSTR 1 whereas you could have booked the same and claimed your ITC in March 2018 month.
D. Missing Invoice
Finally, when all your data match, the last step is to ensure that the total number of inward invoices at your end match with the total number of invoices by the supplier. For instance, your record tallies to 134 invoices, however, the data reflected on form GSTR 2A shows 150 invoices.
2. Review
Once you have identified the nature of discrepancy, the next step is to review and accept/rectify the mismatches. Some of the common mismatches that can be rectified on the purchaser’s end are:
A. Invoice data
Ensure no data was omitted, duplicated, or erred while recording the same in your accounts books. If you find any error, you can rectify the same while filing the subsequent GSTR 3B.
The discrepancies occurring due to mismatching ‘Place of supply’ can not be modified, thus leaving the taxpayer with two option:
- To reject the invoice and ask for a amendment of invoice from the supplier.
- To accept the invoice reflected in GSTR 2A
B. Credit Note Error
Make sure all the credit notes made against the return of goods were also recorded in your ledger.
C. Missing Invoice
Make sure there was no duplication or skipped invoice in your records.
D. ITC Claim
You are susceptible to discrepancy even if your ITC claim is higher than the amount reflected through form GSTR 2A. Nevertheless, you can file for reversal of ITC in GSTR 3B, in your subsequent filing.
3. Communicate
The final stage in reconciliation is to communicate with your suppliers for all the discrepancies and ask for edits/changes if any. And as per the communication, you can accept the changes reflected in GSTR 2A (if the mismatch has been identified on your end) or reject the changes and let your supplier rectify the given mismatch.
However, going by the organizational structures and number of inward supplies, manually tracing the discrepancy across multiple invoices and further rectifying it with your vendors (probably spread across the country) can be a tedious task. So is there any better way to process your reconciliation without any hassle?
GST Reconciliation with IRIS GST Software
Yes, courtesy to IRIS GST Software, the preferred GST solution of top organizations across the country, reconciliation can be easier than you think. Built-in with advanced algorithm and fuzzy logic, IRIS Sapphire helps you reconcile all your data, with no-hassles guaranteed. It swiftly scans through your purchase and the suppliers’ sales data and points out the discrepancies. Furthermore, its smart assistance can help you to rectify the discrepancies (if any), on the go.
IRIS Reconciliation has been built considering the requirements of various industries such as manufacturing, pharmaceuticals, automobiles etc. and has market tested logics to reconcile the buyer-supplier data across various parameters to reduce manual intervention.
Invoice Number Books – RE/20/2019-20 Invoice Date Books – 19-July -2019
Invoice Number Books RE/21/2019-20 Invoice Date Books – 19-July -2019
Invoice Number Portal – 20 Invoice Date Portal – 17-July -2019
Invoice Number Portal – 21 Invoice Date Portal – 17-July -2019
So if This mismatch reported by Clint.
Is it possible to correct Now in GSTR 9
Because client is asking to Impose Penalty for the same.How to fix it if possible
Your client must have received invoice in GSTR 2A with number 20 and 21. Ask him to accept the invoice on the Portal….No need to correct in GSTR9 …You may issue him backdated invoice of this series – This practical solution and not the legal one since time limit for 2019-20 is surpassed in Sept 20