GSTR2A RECONCILIATION

[madhusudhana]

DEAR SIR,
HELP ME
WE NEED A FORMULA TO RECONCILE THE GSTR2A DATA WITH PORTAL. WE MATCH THE GSTIN AND BILL NO IF IT IS FAIL TO RECONCILE THEN AGAIN TO CHECK GSTIN AND INV AMOUNT APPROXIMATE MATCH

 

[Deepak]

Check cleartax they have the advanced software based for accuracy.

 

[madhusudhana]

provide a formula

 

[madhusudhana]

we need to reconcile purchase register using gstin and bill no if we fail to verify that way i need a formula to verify using gst no and bill amount

 

[Deepak]

Hi,

Put below in S2 and drag below.

=IFERROR("Error - "&INDEX($D$2:$J$2,1,INDEX(MATCH(FALSE,D3:J3=L3:R3,0),,)),"OK-Matched")

or

=IFERROR("Error - "&INDEX($D$2:$J$2,1,SUMPRODUCT(MATCH(FALSE,D4:J4=L4:R4,0))),"OK-Matched")

Both are the same formula just two different non CSE approach.

 

[madhusudhana]

Thank you sir

 

[madhusudhana]

suppose if we give nos as billno error is 1 and inv value error is 2 like that in the above given formula by you

 

[madhusudhana]

it is showing only one error only i.e. 1st error we need to extract all the errors finally we will give a formula as "reconciled with inv no mismatch" or reconciled with taxable amount mismatch" if all the parameters are failed to match then only "unreconciled"