{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions to Use","Reco","As per Our Records","From Govt Portal"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Instructions to Use","index":0,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,10,0,16],[1,0,1,9],[9,1,9,9],[10,1,10,9],[11,1,11,9],[3,1,3,9],[4,1,4,9],[5,1,5,9],[6,1,6,9],[7,1,7,9],[8,1,8,9],[16,1,16,9],[15,1,15,9],[13,1,13,9],[12,1,12,9],[14,1,14,9]]}
[null,null,null,null,null,null,null,null,null,null,"Please read instructions before clicking on below button"]
["Instructions "]
[]
[1,"Do not change the Name of any Tab"]
[2,"Do not change any Heading of any table in any Table"]
[3,"There should be only below 4 Sheets in this File when you will start the Reconciliation"]
[null,"i.   Instructions to Use"]
[null,"ii.  Reco"]
[null,"iii. As per Our Records"]
[null,"iv. From Govt Portal"]
[4,"Heading of Column A to O in Sheet \"From Govt Portal\" is same as GSTR 2A from Government Portal. You can add your data from raw 7 onwards for your one client or multiple clients. In Column P, one heading has been added where you have to write the name of Client for which you are preparing this reconciliation.Recomend to leave my client name blank",null,null,null,null,null,null,null,null,null,"Round off",1]
[5,"Data can be pasted for multiple clients to prepare reco for multiple clients in one go. But you need to write name of Client properly in both sheets in respective columns"]
[6,"This utility will work for maximun 49,000 line times in each tab.",null,null,null,null,null,null,null,null,null,"Updates"]
[7,"Please don't click anywhere when process is running, else it might misbehave and will give wrong results",null,null,null,null,null,null,null,null,1,"Made the sheet faster by using some dynamic formula"]
[8,"Please enable Macro before starting the Reconciliation Process. Sometime when you will open this file, it will give message as per screen shot below. Please click on Enable Content",null,null,null,null,null,null,null,null,2,"added rounding off to show as Matched even if having immaterial diffrences"]
[null,null,null,null,null,null,null,null,null,null,3,"Added Invoice date to track and create opening and closing reconsiliation"]
[9,"Add Round off amount in Instruction to use before sharting reconciliation",null,null,null,null,null,null,null,null,4,"Added a Autofilter to fliter the reconciliation"]

{"sheet":"Reco","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,1,6,5],[8,1,8,5],[9,1,9,5]]}
[]
[]
[]
[]
[]
[]
[null,"Your Reconciliation is ready in Next Tab"]
[]
[null,"If you like this Utility, Please Share my Youtube Video with Your Friends"]
[null,"So that they can get benefit out of it."]

{"sheet":"As per Our Records","index":2,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["My Client Name","GSTIN of supplier","Name of Supplier","Invoice number","Taxable Value (₹)","Integrated Tax  (₹)","Central Tax (₹)","State/UT tax (₹)","Cess (₹)","Invoice Date"]

{"sheet":"From Govt Portal","index":3,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,2,14],[3,0,3,14],[4,2,4,5],[4,10,4,13]]}
["                                           Goods and Services Tax  - GSTR 2A"]
[]
[]
["                                                                                                   Taxable inward supplies received from registered persons\n\n                                                                                  "]
[null,"Trade/Legal name of ","Invoice details",null,null,null,null,"Supply Attract",null,null,"Tax Amount",null,null,null,"Counter Party"]
["GSTIN of supplier","the Supplier","Invoice number","Invoice type","Invoice Date","Invoice Value (₹)","Place of supply","Reverse Charge","Rate (%)","Taxable Value (₹)","Integrated Tax  (₹)","Central Tax (₹)","State/UT tax (₹)","Cess  (₹)","Return status","My Client Name"]