{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Master","Party Master","Tally","Tally Inv","2A Inv","Reco","Reco Inv Level","Pivot","Summary","Instructions","Sheet4"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Master","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Party Master","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tally","index":2,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["GSTIN of supplier","Trade/Legal name of the Supplier","Supplier Invoice number & Date","Invoice Date","Invoice Value (₹)","Taxable Value (₹)","Integrated Tax  (₹)","Central Tax (₹)","State/UT tax (₹)","Cess  (₹)"]

{"sheet":"Tally Inv","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2A Inv","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Reco","index":5,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,2,0,5],[0,6,0,9],[0,10,0,13]]}
["GSTIN of supplier","Trade/Legal name of the Supplier","As per GSTR 2A",null,null,null,"As per Books",null,null,null,"Difference"]
["GSTIN of supplier","Trade/Legal name of the Supplier","Taxable Value","IGST","CGST","SGST","Taxable Value","IGST","CGST","SGST","Taxable Value","IGST","CGST","SGST","Remarks","Tax as per GSTR-2A","Tax as per Book"]

{"sheet":"Reco Inv Level","index":6,"n_rows":2,"n_cols":20,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,3,0,7],[0,8,0,12],[0,13,0,16]]}
["GSTIN of supplier","GSTIN of supplier","Trade/Legal name of the Supplier","As per GSTR 2A",null,null,null,null,"As per Books",null,null,null,null,"Difference",null,null,null,null,"Tax as per GSTR-2A","Tax as per Book"]
["GSTIN of supplier","GSTIN of supplier","Trade/Legal name of the Supplier","Inv No (2A)","Taxable Value (2A)","IGST (2A)","CGST (2A)","SGST (2A)","Inv No","Taxable Value","IGST","CGST","SGST","Taxable Value (Diff)","IGST (Diff)","CGST (Diff)","SGST (Diff)","Remarks","Tax as per GSTR-2A","Tax as per Book"]

{"sheet":"Pivot","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":9,"n_rows":57,"n_cols":41,"rows_kept":57,"cut":false,"hidden":false,"merged":[[16,3,16,15],[20,2,20,15],[19,2,19,15],[18,3,18,15],[2,2,2,18],[4,2,4,15],[6,3,6,15],[7,3,7,15],[8,3,8,15],[53,7,53,9],[54,7,54,9],[55,7,55,9],[56,7,56,9],[17,3,17,15],[22,2,22,18],[24,2,28,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GSTIN of supplier","Trade/Legal name of the Supplier","Invoice number","Invoice type","Invoice Date","Invoice Value (₹)","Place of supply","Supply Attract Reverse Charge","Rate (%)","Taxable Value (₹)","Integrated Tax  (₹)","Central Tax (₹)","State/UT tax (₹)","Cess  (₹)","Counter Party Return status"]
[]
[null,null,"GSTR-2  RECONCILIATION  UTILITY"]
[]
[null,null,"STEPS TO USE THE UTILITY"]
[]
[null,null,1,"Click on Clear All Button. To clear the Previous Data."]
[null,null,{"$f":"+C7+1","v":2},"Download the GSTR-2A files in Excel Format from GST Portal and paste in a folder.  (Note : The folder should not contain any other files other than GSTR 2A files)\nThen click on Get Data Button. This will import all the B2B files. (For more information- Refer Row 32 of this Sheet)"]
[null,null,3,"Click on Combine Data Button. This combines all the data from the given sheets to the Master Sheet and provides the summary of GSTR-2A Data."]
[null,null,4,"Paste Purchase Register to the Tally Sheet in the following format:"]
[]
[null,null,null,null,"A","B","C","D","E","F","G","H","I","J"]
[null,null,null,1,"GSTIN of supplier","Trade name of the Supplier","Supplier Invoice no. & Date","Invoice Date","Invoice Value (₹)","Taxable Value (₹)","Integrated Tax  (₹)","Central Tax (₹)","State/UT tax (₹)","Cess  (₹)"]
[null,null,null,2,"29XXXXXXXXXXXXX","AXXXXX & Co.","123/01-04-2018","01-04-2018",1100,1000,0,50,50,0]
[null,null,null,3,"27XXXXXXXXXXXXX","BXXXXX & Co.","456/18-19/01-01-2019","01-01-2019",5900,5000,900,0,0,0]
[null,null,null,"For more information- Refer Row 39 of this sheet."]
[null,null,5,"Click on Party wise Reconciliation Button to reconcile the data as per Portal and as per Books. This will reconcile the data - party wise. Check the Reconciled Data in Reco Sheet."]
[null,null,6,"Click on Invoice Wise Reconciliation Button to reconcile the data as per Portal and as per Books.. This will reconcile the data - Invoice wise for easy reference. Check the Reconciled Data in Reco Inv Level Sheet. (Note: Invoice Number in Books and Portal should match, for Invoice wise Reconciliation to work.)"]
[null,null,7,"Click on Summary to get the Summary"]
[null,null,"To view the detailed instructions click here"]
[null,null,"To receive updated versions of this utility fill the form given in the link (Click Here)"]
[]
[null,null,"To comply with regulations stipulated by the Code of Ethics prescribed by Institute of Chartered Accountants (ICAI) of India that does not permit solicitation in any form or manner, by accessing this utility you acknowledge that you are seeking information of your own accord and volition and that no form of solicitation has taken place by Kiran K Jain & Co. or its members. This utility should not be construed as an attempt to create a CA-client relationship of any manner. This utility is meant to provide information to those who specifically request this information and does not purport to be exhaustive in relation to the information contained herein."]
[]
[null,null,"THANK YOU\nTEAM KIRAN K JAIN & Co.,\nwww.kkjainandco.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Step: 2"]
[null,null,1,"Click on Get Data Button."]
[null,null,2,"A Dialog Box will be opened."]
[null,null,3,"Select your GSTR-2A Folder - in which excel files are downloaded. (Note: Do Not Open the Folder)"]
[null,null,4,"Click on Ok to import the excel files."]
[null,null,5,"This will import all B2B sheets."]
[]
[null,null,null,"Step: 3"]
[null,null,1,"Export Columnar Purchase Register from Tally and convert it into Given Format."]
[null,null,2,"Paste Purchase Register and any other Expenses or Fixed Assets on which input is claimed from Tally in \"Tally\" Sheet."]
[null,null,3,"The data should be pasted from Cell A2."]
[null,null,null,null,"A","B","C","D","E","F","G","H","I","J"]
[null,null,null,1,"GSTIN of supplier","Trade name of the Supplier","Supplier Invoice no. & Date","Invoice Date","Invoice Value (₹)","Taxable Value (₹)","Integrated Tax  (₹)","Central Tax (₹)","State/UT tax (₹)","Cess  (₹)"]
[null,null,null,2,"29XXXXXXXXXXXXX","AXXXXX & Co.","123/01-04-2018","01-04-2018",1100,1000,0,50,50,0]
[null,null,null,3,"27XXXXXXXXXXXXX","BXXXXX & Co.","456/18-19/01-01-2019","01-01-2019",5900,5000,900,0,0,0]
[]
[]
[null,null,null,"In case Data is taken from 2A of Tally then Supplier Invoice Number & Date Data will be in 2 different columns"]
[null,null,1,"To get the data in above format, merge the Supplier Invoice Number and Date Column by using the given formula."]
[null,null,2,null,"A","B","C","D"]
[null,null,null,null,"Supplier Invoice No","Invoice Date","Supplier Invoice no. & Date","Formula"]
[null,null,null,null,123,"01-04-2018",{"$f":"E56&\" / \"&TEXT(F56,\"dd,mm,yyy\")","v":"123 / 01,04,2018"},"=E56&\" / \"&TEXT(F56,\"dd,mm,yyy\")"]
[null,null,null,null,"456/18-19","01-01-2019",{"$f":"E57&\" / \"&TEXT(F57,\"dd,mm,yyy\")","v":"456/18-19 / 01,01,2019"},"=E57&\" / \"&TEXT(F57,\"dd,mm,yyy\")"]

{"sheet":"Sheet4","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}