[GST] supplier reconsiliation with GSTR 2A

vorasmit commented 6 years ago

Overview: As we file GSTR1 with outward supplies, in a similar manner our supplier also files GSTR1. Returns filled by them are reflected in our GSTR2A Report. It can be used to reconcile with our purchases.

Matching of Invoices is crucial to claiming GST credit. So Supplier compliance becomes necessary. And hence it's essential to track non-compliance to avoid financial loss.

Proposed Feature:

Separate doctype to Import GSTR 2A in ERP Next.
Automatic matching of invoices based on supplier GSTIN + Supplier invoice no / supplier tax in invoice / transaction value.
Find an Exact match, Approximate match, and not matching of invoices.
Manually match invoices not matched, and accept values where there is an approximate match.
Update supplier invoice status as return filled or return submitted but not filled, from data in GSTR2A
Get the report for Purchase recorded in books but not in GSTR 2A --> to identify supplier non-compliance
Also Get the report for Purchase not recorded in books but there in GSTR 2A --> to identify missing purchase invoice.
Communicate non-compliance to suppliers --> block payments unless complied.

Sample screenshots from Cleartax reconciliation tool.

Import of GSTR 2A import of gstr2a

Reconciliation

Link to Video: https://youtu.be/ivbMD3LlPFA

decentrajan commented 6 years ago

Hi i have a issue with gstr2a api. please correct the api, where is mistake for cdnr.. if i use this api for b2b it works perfect.. but in cdnr it shows error

https://return.gst.gov.in/returns/auth/api/gstr2a/ctin?rtn_prd=042018&section_name=CDNR

pharsharao commented 5 years ago

Hi i have a issue with gstr2a api. please correct the api, where is mistake for cdnr.. if i use this api for b2b it works perfect.. but in cdnr it shows error

https://return.gst.gov.in/returns/auth/api/gstr2a/ctin?rtn_prd=042018&section_name=CDNR

https://return.gst.gov.in/returns/auth/api/gstr2a/ctin?rtn_prd=042018&section_name=CDNR -where did you get this API ? its not available on developer portal . Thanks in advance.

karthikeyan5 commented 3 years ago

@vorasmit, this app has a few of the proposed features you mention...

Do take a look, if it might be useful for you...

https://github.com/aerele/reconciler

Also, what is the number of transactions you handle per month?

frappe / erpnext

[GST] supplier reconsiliation with GSTR 2A #13547