{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","Internal","GSTR-2A Invoice Reconciliation","GSTR2A - Amendment vs. Original","GSTR-2A By Vendor"],"not_rendered":{"charts":0,"images":0,"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":"Overview","index":0,"n_rows":40,"n_cols":19,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Books vs GSTR-2A Reconciliation Overview"]
[null,"As per Books",null,null,null,null,null,"As per GSTR-2A",null,null,null,null,null,"Difference (Books - GSTR-2A)"]
["Description","Number of Invoices","Taxable Amount","IGST Amount","CGST Amount","SGST Amount","Cess Amount","Number of Invoices","Taxable Amount","IGST Amount","CGST Amount","SGST Amount","Cess Amount","Number of Invoices","Taxable Amount","IGST Amount","CGST Amount","SGST Amount","Cess Amount"]
["Summary based on Matching Status"]
["Unmatched Invoices (Only in Books)",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":11},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":2224014.38},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":378000},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":11161.29},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":11161.29},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Books\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"B5-H5","v":11},2224014.38,378000,11161.29,11161.29,0]
["Unmatched Invoices (Only in Portal)",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":29},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":795975.72},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":15574.09},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":62595.7},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":62595.7},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},-29,-795975.72,-15574.09,-62595.7,-62595.7,0]
["Matched Invoices (Books & Portal)",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":24},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":8292790},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":20865},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":733208},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":733208},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":24},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":8326850.9399999995},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":30491.72},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":731984.01},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":731984.01},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},0,-34060.939999999478,-9626.7200000000012,1223.9899999999907,1223.9899999999907,0]
["Total",{"$f":"SUM(B5:B7)","v":35},10516804.379999999,398865,744369.29,744369.29,0,53,9122826.6600000001,46065.81,794579.71,794579.71,0,-18,1393977.7200000004,352799.18999999994,-50210.420000000006,-50210.420000000006,0]
[]
["Based on Invoice Number Match Type (among matched invoices)"]
["Exact Match",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":3},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":5850806},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":526107},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":526107},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":3},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":5845632.0099999998},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":526106.88},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":526106.88},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Exact Match\"))","v":0},{"$f":"B11-H11","v":0},5173.9900000002235,0,0.11999999999534339,0.11999999999534339,0]
["Very Strong Match",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":3},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":2245164},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":199880},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":199880},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":3},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":2223255.2399999998},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":198681},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":198681},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Very Strong Match\"))","v":0},0,21908.760000000242,0,1199,1199,0]
["Strong Match",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Strong Match\"))","v":0},0,0,0,0,0,0]
["Weak Match",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":18},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":196820},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":20865},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":7221},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":7221},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":18},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":257963.69},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":30491.72},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":7196.13},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":7196.13},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AX:AX, \"Weak Match\"))","v":0},0,-61143.69,-9626.7200000000012,24.869999999999891,24.869999999999891,0]
[]
["Based on Invoice Date Gap (among matched invoices)"]
["0 days",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":7},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":8041673},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":723111},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":723111},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":7},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":8059349.8199999994},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":2973.32},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":723111.58},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":723111.58},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \"0\"))","v":0},{"$f":"B17-H17","v":0},-17676.819999999367,-2973.32,-0.57999999995809048,-0.57999999995809048,0]
["1-3 days",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":8},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":45902},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":907},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":3619},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":3619},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":8},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":45310.32},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":907.2},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":3592.83},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":3592.83},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&1, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&3))","v":0},0,591.68000000000029,-0.20000000000004547,26.170000000000073,26.170000000000073,0]
["4-7 days",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":3},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":16486},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":1483},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":1483},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":3},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":16485},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":1483.65},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":1483.65},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&4, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&7))","v":0},0,1,0,-0.65000000000009095,-0.65000000000009095,0]
["8-14 days",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":3},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":26142},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":1785},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":1785},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":3},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":14550},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":1089},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":1089},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&8, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&14))","v":0},0,11592,0,696,696,0]
["15-30 days",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":1},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":3600},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":324},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":324},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":1},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":3600},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":324},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":324},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">=\"&15, 'GSTR-2A Invoice Reconciliation'!AY:AY, \"<=\"&30))","v":0},0,0,0,0,0,0]
[">30 days",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":2},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":158987},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":19958},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":2886},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":2886},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":2},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":187555.8},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":26611.200000000001},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":2382.9499999999998},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":2382.9499999999998},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AY:AY, \">\"&30))","v":0},0,-28568.799999999988,-6653.2000000000007,503.05000000000018,503.05000000000018,0]
[]
["Based on POS Match Type (among matched invoices)"]
["Match",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":24},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":8292790},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":20865},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":733208},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":733208},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":24},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":8326850.9399999995},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":30491.72},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":731984.01},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":731984.01},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Match\"))","v":0},{"$f":"B25-H25","v":0},-34060.939999999478,-9626.7200000000012,1223.9899999999907,1223.9899999999907,0]
["Mismatch",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!E:E, \"N\", 'GSTR-2A Invoice Reconciliation'!AZ:AZ, \"Mismatch\"))","v":0},0,0,0,0,0,0]
[]
["Based on Supplier Filing Status (among GSTR-2A Invoices)"]
["Only in Portal (Y)",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":39},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":2998788.7199999997},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":15574.09},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":254980.70000000004},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":254980.70000000004},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":1892},{"$f":"B29-H29","v":-39},-2998788.7199999997,-15574.09,-254980.70000000004,-254980.70000000004,-1892]
["Only in Portal (N)",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Only in Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},0,0,0,0,0,0]
["Books & Portal (Y)",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":24},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":8292790},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":20865},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":733208},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":733208},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":24},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":8326850.9399999995},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":30491.72},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":731984.01},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":731984.01},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"Y\"))","v":0},0,-34060.939999999478,-9626.7200000000012,1223.9899999999907,1223.9899999999907,0]
["Books & Portal (N)",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AM:AM, {\"Books & Portal\"}, 'GSTR-2A Invoice Reconciliation'!F:F, \"N\"))","v":0},0,0,0,0,0,0]
[]
["Based on Reco Match Type (GSTR-2A all invoices)"]
["Review Later",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Review Later\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"B35-H35","v":0},0,0,0,0,0]
["Wrong Invoice by Supplier",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Wrong Invoice by Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},0,0,0,0,0,0]
["Lost ITC",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lost ITC\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},0,0,0,0,0,0]
["E-Mail Supplier",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail Supplier\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},0,0,0,0,0,0]
["E-Mail to Supplier sent",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"E-Mail to Supplier sent\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},0,0,0,0,0,0]
["Lock Match",{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!O:O, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AC:AC, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AD:AD, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AE:AE, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AF:AF, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AG:AG, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(COUNTIFS('GSTR-2A Invoice Reconciliation'!Q:Q, \"<>\", 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AH:AH, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AI:AI, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AJ:AJ, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AK:AK, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},{"$f":"SUM(SUMIFS('GSTR-2A Invoice Reconciliation'!AL:AL, 'GSTR-2A Invoice Reconciliation'!AN:AN, \"Lock Match\", 'GSTR-2A Invoice Reconciliation'!E:E, \"N\"))","v":0},0,0,0,0,0,0]

{"sheet":"Internal","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["post_url","https://my.gstzen.in/~gstzen/a/reconciliation-match-post-xml/v2/2a/"]
["gstin_or_pan_uuid","80a372a4-9afd-4437-88ef-9fd30905ecb0"]

{"sheet":"GSTR-2A Invoice Reconciliation","index":2,"n_rows":75,"n_cols":58,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
["Invoice UUID","Portal Invoice UUID","Invoice Match UUID","Doc. Type","Amended / Cancelled","Supplier Filing Status","Supplier GSTIN (Books)","Supplier GSTIN (Portal)","Supplier Name","GSTR-2A Filing Period","3B Vendor Filing Status","GSTR-1 Filing Date","GSTR-1 Filing Period","Invoice Number (Books)","Invoice Date (Books)","Invoice Number (Portal)","Invoice Date (Portal)","Customer GSTIN","Place of Supply (Books)","Place of Supply (Portal)","Reverse Charge (Books)","Reverse Charge (Portal)","ITC Availability (Books)","ITC Availability (Portal)","Department","Record Date/Booking Date","Document Identifier","GL Account ID","Taxable Amount (Books)","IGST Amount (Books)","CGST Amount (Books)","SGST Amount (Books)","Cess Amount (Books)","Taxable Amount (Portal)","IGST Amount (Portal)","CGST Amount (Portal)","SGST Amount (Portal)","Cess Amount (Portal)","Match Type","Reco. Action","ITC Eligibility","ITC Claim Status","Claim Date","Reco. Notes","Force Match Portal Invoice Row Number","Customer GSTIN (Books)","Customer GSTIN (Portal)","Buyer GstIn Match Type","Seller GstIn Match Type","Invoice Number Match Type","Invoice Date Gap","POS Match Type","Tax+Cess Amounts (Abs. Diff.)","Tax (without Cess) Amounts (Abs.  Diff.)","Tax+Cess Amounts (Diff.)","Tax (without Cess) Amounts (Diff.)","Matching Message","Suggested ITC Position"]
[null,"97a1a9f7-304d-4002-92fb-5776283c7198",null,"CRNA","N","Y",null,"06AAMFB6196I1ZV","Bawa Polymers","2020-09-01","Y","2020-10-11","2020-09-01",null,null,"SR/002/19-20","2019-06-27","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,-1,-0.18,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["f1c96e6d-4955-4ee5-93ec-7b5067a94ec9",null,null,"INV","N",null,"06BELPS0778H1Z2",null,"PREMIER SALES CORPORATION",null,null,null,null,"RNS/268/2020-21","2020-09-01",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,2100000,378000,null,null,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["24e55696-2718-4a2f-bf73-6132e9bcb446","a65c5367-984c-4602-8103-83d183f1d7d0",null,"INV","N","Y","27AAACV1559Q2ZP","07AAACV1556Q2ZR","V TRANS, V XPRESS & V LOGIS","2020-06-01","Y","2020-07-16","2020-06-01","46","2020-06-16","07-20-06-T000442","2020-06-16","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Freight & Coolie - GST Paid",null,null,null,null,null,24777.68,2973.32,null,null,null,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980M1ZR","29AAFCC9980MZZT","Buyer GstIn mismatch","Seller GstIn mismatch","Weak Match",0,"Match",null,null,null,null,"Multiple mismatches","To Check"]
[null,"418c2edc-30cf-4f38-9f15-2b0bad563d4c",null,"INV","N","Y",null,"24AAACW0946O1ZY","WALSON WOODBURN WIRE DIE PRIVATE LIMITED","2020-07-01","Y","2020-08-13","2020-07-01",null,null,"S-24/2020-2021","2020-07-20","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,13500,2430,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"18968331-d3eb-4c52-bd08-9bba6d1a09e8",null,"INV","N","Y",null,"24AAGCK9649B2ZI","KABA EXPRESS PRIVATE LIMITED","2020-06-01","Y","2020-08-07","2020-06-01",null,null,"VPI20B00244","2020-06-01","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,2130,106.5,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"5126dcae-f558-4f65-9823-f7d16870d18f",null,"INV","N","Y",null,"24AAGCK9649B2ZI","KABA EXPRESS PRIVATE LIMITED","2020-08-01","Y","2020-10-04","2020-08-01",null,null,"VPI20B01691","2020-08-24","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,3570,178.5,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"b16f1028-d08f-47c6-84ee-cfc9d63e7501",null,"INV","N","Y",null,"24AAGCK9649B2ZI","KABA EXPRESS PRIVATE LIMITED","2021-02-01","Y","2021-03-11","2021-02-01",null,null,"VPI20B05072","2021-02-20","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,4920,246,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"b1889428-aa58-48a5-8826-a01c6742c747",null,"INV","N","Y",null,"24AAGCK9649B2ZI","KABA EXPRESS PRIVATE LIMITED","2021-03-01","Y","2021-05-19","2021-03-01",null,null,"VPI20B05733","2021-03-29","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,7150,357.5,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["8874f0ce-f760-4bb2-8dec-b3dcbc320d81","bd9dfc58-56e6-42ed-8a5d-524f29e30f79",null,"INV","N","Y","24CRJPK8584K1Z3","24CRJPK8584S1Z3","MAJESTIC MARINE AND ENGINEERING SERVICES","2021-02-01","Y","2021-03-13","2021-02-01","290","2021-02-22","MMAES/20-21/158","2021-02-19","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",5290,907,0,0,0,5040,907.2,0,0,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",3,"Match",0.2,0.2,-0.2,-0.2,"Multiple mismatches","To Check"]
["24d0ae17-5490-4e62-a497-519943180a86","74e7fd8b-e664-4568-9889-dcf69270036c",null,"INV","N","Y","26AAACH0693R1Z3","26AAACH0793R1Z3","BAWA POLYMERS (PROP HARMAN BAWA PVT LTD)","2020-07-01","Y","2020-08-12","2020-07-01","HB-S/0335/20-21","2021-01-25","HB-S/0066/20-21","2020-07-21","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"IGST Purchase @ 18%",110880,19958,0,0,0,147840,26611.200000000001,0,0,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",188,"Match",6653.2,6653.2,-6653.2,-6653.2,"Multiple mismatches","To Check"]
[null,"8a1815a5-70ea-4b12-9c6b-1245e0535fba",null,"INV","N","Y",null,"27AADFD2913K1ZL","DIVYAN EMULSICHEM","2021-03-01","Y","2021-04-13","2021-03-01",null,null,"MH-0217/2020-21","2021-03-25","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,8750,1575,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"7aede705-e7e3-48da-aa07-ee61110aaa19",null,"INV","N","Y",null,"27AAYFS8197D1ZB","SUDHIR ENTERPRISE","2021-03-01","Y","2021-04-09","2021-03-01",null,null,"1787","2021-03-27","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,59337.599999999999,10680.77,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"705feb6f-32ce-4bc6-b92c-7581976aa405",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-06-01","Y","2020-07-10","2020-06-01",null,null,"DSK/21000059","2020-06-18","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,142274.56,null,12804.71,12804.71,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"7d0760cb-d76b-41d2-8484-4f7ae7db5946",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-06-01","Y","2020-07-10","2020-06-01",null,null,"DSK/21000075","2020-06-27","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,40230.11,null,3620.71,3620.71,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"4333dbed-2864-4b35-a84a-d5ed9369d992",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-06-01","Y","2020-07-10","2020-06-01",null,null,"DSK/21000091","2020-06-30","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,65337.22,null,5880.35,5880.35,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"9740a804-5e2c-4cee-8e5c-a191fc6db08f",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-07-01","Y","2020-08-10","2020-07-01",null,null,"KADN/21000262","2020-07-07","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,31,null,2.79,2.79,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"dc6f62ad-dffe-4b78-9c73-ea815e69e4a4",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-07-01","Y","2020-08-10","2020-07-01",null,null,"KADN/21000263","2020-07-07","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,190,null,17.100000000000001,17.100000000000001,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"c647ec2f-58bf-4be2-8be2-606903509609",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-07-01","Y","2020-08-10","2020-07-01",null,null,"DSK/21000117","2020-07-10","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,12191.56,null,1097.24,1097.24,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"a2905842-9648-4fc0-ace2-d7edb31a6201",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-08-01","Y","2020-09-10","2020-08-01",null,null,"DSK/21000221","2020-08-20","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,25126.33,null,2261.37,2261.37,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"7252dd76-3db8-4932-b0ac-be1c7a7084fe",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-08-01","Y","2020-09-10","2020-08-01",null,null,"DSK/21000224","2020-08-20","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,6924.11,null,623.16999999999996,623.16999999999996,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"92da7977-eea7-45fd-985a-7f3eb17f7f56",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-08-01","Y","2020-09-10","2020-08-01",null,null,"DSK/21000236","2020-08-26","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,37651,null,3388.59,3388.59,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"6f813d41-34bf-4d11-aaff-1ebeca2cd20d",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-08-01","Y","2020-09-10","2020-08-01",null,null,"DSK/21000237","2020-08-28","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,24484.560000000001,null,2203.61,2203.61,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["f682f778-792d-4e77-934a-1b0d636ae600","d5f1c259-e05a-4791-96e1-3ed5ec76e40d",null,"INV","N","Y","29AAACH1501R1ZJ","29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-10-01","Y","2020-11-10","2020-10-01","DCK/21001491","2020-10-05","DCK/21001491","2020-10-05","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"SGST Purchase @ 18%",2144032,0,192792,192792,0,2142135.67,0,192792.21,192792.21,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Exact Match",0,"Match",0.42,0.42,-0.42,-0.42,"Multiple mismatches","To Check"]
["a5703e70-2af5-4699-83da-d1de5be2be3e","895563e7-030e-44d5-b595-cab2ded83854",null,"INV","N","Y","29AAACH1501R1ZJ","29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-10-01","Y","2020-11-10","2020-10-01","DCK/21001660","2020-10-17","DCK/21001660","2020-10-17","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"SGST Purchase @ 18%",1605218,0,144342,144342,0,1603798.78,0,144341.89000000001,144341.89000000001,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Exact Match",0,"Match",0.22,0.22,0.22,0.22,"Multiple mismatches","To Check"]
["6429180f-0186-4853-b0c6-8f523dcaff82","f483e60f-cb30-4745-8d69-5b2ba28c0632",null,"INV","N","Y","29AAACH1501R1ZJ","29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-10-01","Y","2020-11-10","2020-10-01","DCK/21001682","2020-10-20","DCK/21001682","2020-10-20","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"SGST Purchase @ 18%",2101556,0,188973,188973,0,2099697.56,0,188972.78,188972.78,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Exact Match",0,"Match",0.44,0.44,0.44,0.44,"Multiple mismatches","To Check"]
["d80800b5-581a-4a2e-98e7-b39dfe6291c3","8a047ad2-fc6d-4c11-993f-1ba72c55a89b",null,"INV","N","Y","29AAACH1501R1ZJ","29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-10-01","Y","2020-11-10","2020-10-01","DCK21001718","2020-10-22","DCK/21001718","2020-10-22","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"SGST Purchase @ 18%",2178115,0,195857,195857,0,2176189.4399999999,0,195857.05,195857.05,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Very Strong Match",0,"Match",0.1,0.1,-0.1,-0.1,"Multiple mismatches","To Check"]
[null,"f3c8c074-ba3a-4eca-8326-76ff5d76d65a",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-10-01","Y","2020-11-10","2020-10-01",null,null,"DSK/21000488","2020-10-22","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,52132.11,null,4691.8900000000003,4691.8900000000003,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"22417542-64a5-4ca5-9316-48d7a771ff14",null,"DBN","N","Y",null,"29AAACH1601R1ZJ","HINDALBIRLA COPPER","2020-11-01","Y","2020-12-10","2020-11-01",null,null,"DSK/21000554","2020-11-03","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,61300.56,null,5517.05,5517.05,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["787bead7-8222-4407-8cb4-6666f0197ce5","a81b6bce-d96a-4a87-aaa6-5a35e0069521",null,"INV","N","Y","29AAAFI5725Q1ZT","29AAAFI5825Q1ZT","INDUSTRIAL EQUIPMENT MARKETING CO","2020-08-01","Y","2020-09-11","2020-08-01","101","2020-08-13","929/2020-2021","2020-08-08","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",3735,0,336,336,0,3735,0,336.15,336.15,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",5,"Match",0.3,0.3,-0.3,-0.3,"Multiple mismatches","To Check"]
["72efc5a6-20cd-4eea-b472-cd1a52b1918b","4e305c95-2831-492d-93b3-37bfa9391c04",null,"INV","N","Y","29AABFA3705H1ZR","29AABFA3605H1ZR","ASHOK INC","2020-05-01","Y","2020-06-09","2020-05-01","30","2020-05-16","007","2020-05-13","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",7600,0,684,684,0,7600,0,684,684,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",3,"Match",0,0,0,0,"Multiple mismatches","To Check"]
["78c58eb4-5ebc-4f35-9033-a1658e824711","2243d2f4-964a-4fd0-9791-1159ada5606d",null,"INV","N","Y","29AABFA3705H1ZR","29AABFA3605H1ZR","ASHOK INC","2020-08-01","Y","2020-09-09","2020-08-01","94","2020-08-13","099","2020-08-12","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",13100,0,1179,1179,0,13100,0,1179,1179,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",1,"Match",0,0,0,0,"Multiple mismatches","To Check"]
["830edd02-b385-4fee-a125-950be4cc01d2","01ba904a-98ad-4bad-92a7-19462eceb927",null,"INV","N","Y","29AABFA3705H1ZR","29AABFA3605H1ZR","ASHOK INC","2020-11-01","Y","2020-12-07","2020-11-01","204","2020-11-19","284","2020-11-13","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",4100,0,369,369,0,4100,0,369,369,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",6,"Match",0,0,0,0,"Multiple mismatches","To Check"]
["3afb38e5-e1ef-40cc-8ed7-b8656a01fb99","71abe48e-bf0a-4b7d-9416-72d96e9921a1",null,"INV","N","Y","29AABFA3705H1ZR","29AABFA3605H1ZR","ASHOK INC","2021-03-01","Y","2021-04-10","2021-03-01","310","2021-03-20","534","2021-03-19","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",6500,0,585,585,0,6500,0,585,585,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",1,"Match",0,0,0,0,"Multiple mismatches","To Check"]
["d05a54a6-cea4-4605-ac5f-0c4383cf7078","a5e3473e-5e82-445e-bbd6-d4eb5b8bfd68",null,"INV","N","Y","29AABFA3705H1ZR","29AABFA3605H1ZR","ASHOK INC","2021-03-01","Y","2021-04-10","2021-03-01","313","2021-03-24","540","2021-03-22","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",5170,0,465,465,0,5170,0,465.3,465.3,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",2,"Match",0.6,0.6,-0.6,-0.6,"Multiple mismatches","To Check"]
["340d1f11-a008-499c-8200-8d3ffb055566","142cd922-2574-4bb0-940b-b963f383360d",null,"INV","N","Y","29AABFA3705H1ZR","29AABFA3605H1ZR","ASHOK INC","2021-03-01","Y","2021-04-10","2021-03-01","317","2021-03-27","549","2021-03-26","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",1200,0,108,108,0,1200,0,108,108,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",1,"Match",0,0,0,0,"Multiple mismatches","To Check"]
[null,"8b4b71eb-5d60-4eb5-ba88-4d0cb9d15d4d",null,"INV","Y","Y",null,"29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","2020-06-01","Y","2020-07-31","2020-06-01",null,null,"405703","2020-06-20","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,7200,null,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"0a4a5969-e6f6-4dc7-b1cd-791ef7269437",null,"INV","Y","Y",null,"29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","2020-08-01","Y","2020-10-16","2020-08-01",null,null,"405889","2020-08-25","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,6780,null,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"7e449a73-f2d7-4958-8554-9e8a4984cbe9",null,"INV","Y","Y",null,"29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","2020-10-01","Y","2020-11-11","2020-10-01",null,null,"406144","2020-10-14","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,9550,null,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"5fed898b-68fd-4879-8267-fdabf361238f",null,"INV","Y","Y",null,"29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","2020-12-01","Y","2021-01-18","2020-12-01",null,null,"406374","2020-12-03","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,8670,null,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"91a64a82-a135-4d0c-98fe-ae2a5eaeaf48",null,"INV","Y","Y",null,"29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","2020-12-01","Y","2021-01-18","2020-12-01",null,null,"406420","2020-12-10","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,7830,null,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"1fab6b9a-8cae-46f3-84b8-e39109d08507",null,"INV","Y","Y",null,"29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","2020-12-01","Y","2021-01-18","2020-12-01",null,null,"406510","2020-12-29","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,8460,null,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"b760809f-b58f-4549-8af0-d331cf86dd9b",null,"INV","Y","Y",null,"29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","2021-01-01","Y","2021-02-11","2021-01-01",null,null,"406557","2021-01-06","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,8040,null,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"b3bdc4c2-f26d-4ebf-8959-cae9a6f40c7e",null,"INV","Y","Y",null,"29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","2021-02-01","Y","2021-06-19","2021-02-01",null,null,"406738","2021-02-13","29AAFCC9980MZZT",null,"29 - KA",null,"Y",null,null,null,null,null,null,null,null,null,null,null,8670,null,null,null,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["a574d204-15e6-45cf-abe7-ae95c5a159ff","94aadfda-9790-46e3-9f1a-2d5941044fa6",null,"INV","N","Y","29AADCS9958B1ZY","29AADCS9958B1ZY","STOVE KRAFT LIMITED","2020-12-01","Y","2021-01-11","2020-12-01","234","2020-12-07","907600199","2020-12-04","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,"GSTZen Demo",null,null,"SGST Purchase @ 18%",5992,0,535,535,0,5500.32,0,495.03,495.03,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",3,"Match",79.94,79.94,79.94,79.94,"Multiple mismatches","To Check"]
[null,"12e78532-4ed1-4e08-8955-f6062819fa80",null,"INV","N","Y",null,"29AADFV7589C1ZO","VENU & VINAY","2021-03-01","Y","2021-04-12","2021-03-01",null,null,"2020-21/1110","2021-03-31","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,4000,null,360,360,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["87791b95-9e6d-42ff-8eec-17cbb223bdf1","5c9f4420-9f05-4ae8-ba62-5561d2c25125",null,"INV","N","Y","29AAECB6725G1ZL","29AAECB6725G1ZL","BBW BRUSHES PRIVATE LIMITED","2021-02-01","Y","2021-03-10","2021-02-01","320","2021-02-25","1198/20-21","2021-02-23","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,"GSTZen Demo",null,null,"SGST Purchase @ 12%",1050,0,63,63,0,1200,0,76.5,76.5,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",2,"Match",27,27,-27,-27,"Multiple mismatches","To Check"]
[null,"20bbdf05-8599-4cdf-ab9e-9a4dc43c8be3",null,"INV","N","Y",null,"29AAKPJ8117D1ZO","SRI PARSHWANATH INDUSTRIES","2020-09-01","Y","2020-10-10","2020-09-01",null,null,"SPI-2019-20-3148","2019-04-25","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,13750,null,1237.5,1237.5,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"1d71627f-821c-45ac-82f3-5539b6e358cb",null,"DBN","N","Y",null,"29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","2020-07-01","Y","2020-08-11","2020-07-01",null,null,"STI76","2020-07-31","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,109252,null,9833,9833,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"067aab06-c4e7-4f60-8fe0-dfb33d430438",null,"DBN","N","Y",null,"29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","2020-09-01","Y","2020-10-10","2020-09-01",null,null,"STI103","2020-09-16","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,6735,null,606,606,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"73422699-4463-460d-84f8-c064781dd6f7",null,"INV","Y","Y",null,"29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","2020-10-01","Y","2020-11-12","2020-10-01",null,null,"0477","2020-10-30","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,2089366,null,188043,188043,1849,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"4cce64b9-a448-45c9-b554-71360d42eaae",null,"DBN","Y","Y",null,"29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","2020-10-01","Y","2020-11-12","2020-10-01",null,null,"STI173","2020-10-31","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,48247,null,4342,4342,43,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"3a50e542-7a59-4aa9-918c-5f1bde33fe1d",null,"DBNA","N","Y",null,"29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","2020-11-01","Y","2020-12-11","2020-11-01",null,null,"STI173","2020-10-31","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,48247,null,4342,4342,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["e94426ba-03bc-4b0c-93a0-cedcc5da83af","df922c7d-6c9c-4626-aaa4-dc8fa9d64ef6",null,"INV","N","Y","29AARPR8772K1ZH","29AARPR8772K1ZH","PREMIER PACKS","2020-06-01","Y","2020-07-24","2020-06-01","46","2020-06-23","0046","2020-06-11","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,"GSTZen Demo",null,null,"SGST Purchase @ 12%",18942,0,1137,1137,0,7350,0,441,441,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Very Strong Match",12,"Match",1392,1392,1392,1392,"Multiple mismatches","To Check"]
["d7dd09f4-ca5f-4024-9569-50ac6bc8a14d","2a5ceb6a-e441-4523-834b-c308ecab83c2",null,"INV","N","Y","29AARPR8772K1ZH","29AARPR8772K1ZH","PREMIER PACKS","2020-07-01","Y","2020-08-10","2020-07-01","144","2020-09-21","0144","2020-07-31","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,"GSTZen Demo",null,null,"SGST Purchase @ 12%",48107,0,2886,2886,0,39715.800000000003,0,2382.9499999999998,2382.9499999999998,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Very Strong Match",52,"Match",1006.1,1006.1,1006.1,1006.1,"Multiple mismatches","To Check"]
["67bb61ab-e45f-4c87-bb7d-0480724d4851","9ee602da-8161-4e1b-8325-46a45bc06b09",null,"INV","N","Y","29AAZPL1767E1Z3","29AAZPL1767E1Z3","BALAJI ELECTRONICS","2020-08-01","Y","2020-09-09","2020-08-01","96","2020-08-13","7109","2020-08-08","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",8651,0,778,778,0,8650,0,778.5,778.5,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",5,"Match",1,1,-1,-1,"Multiple mismatches","To Check"]
["8b93853b-1a86-4505-8d9d-99828225d303","39eeef62-0e1f-4e6c-a6a2-011cd50ca2cd",null,"INV","N","Y","29ABTPD0493L1Z3","29ABTPD0493L1Z3","Metro Berry Industrial Suppliers","2020-06-01","Y","2020-12-19","2020-06-01","50","2020-06-22","92","2020-06-22","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Staff Welfare @ 18%",3650,0,328,328,0,3649,0,328.5,328.5,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",0,"Match",1,1,-1,-1,"Multiple mismatches","To Check"]
["e7d0954b-8632-41e6-b80e-a3301f9c892d","9fa620c8-0a96-463d-87bd-f0ed1a2cf3b9",null,"INV","N","Y","29ACFPP7443K1Z1","29ACFPP7543K1Z1","ASHREERA ENTERPRISES","2020-06-01","Y","2020-07-11","2020-06-01","38","2020-06-16","RNR-176","2020-06-16","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"SGST Purchase @ 18%",9102,0,819,819,0,9101.69,0,819.15,819.15,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",0,"Match",0.3,0.3,-0.3,-0.3,"Multiple mismatches","To Check"]
["ed3c8580-89d1-4229-a5f4-603ae9f9448a","07eb59a9-f9e7-48d1-9d86-7e891c976ef4",null,"INV","N","Y","29ACNPR9957Q1Z0","29ACNPR9657Q1Z0","INNOVATIVE ENGINEERS","2021-01-01","N","2021-02-11","2021-01-01","230","2020-12-09","IE/2020-2021/830","2021-01-08","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Repairs and Maintenance@18%",3600,0,324,324,0,3600,0,324,324,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",30,"Match",0,0,0,0,"Multiple mismatches","To Check"]
[null,"89cff1b2-1936-41e3-a696-35342b3a8f6e",null,"INV","N","Y",null,"29ACWPG8054C1Z9","S J MARKETING COMPANY","2020-12-01","Y","2021-01-12","2020-12-01",null,null,"0156","2020-12-23","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,25200,null,2268,2268,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["68ef024c-907a-4d80-9088-dfacb729cc9e",null,null,"INV","N",null,"29AECPK7239P1ZT",null,"NIRMALA TRAVELS",null,null,null,null,"907600170","2020-11-05",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,10999.65,null,989.97,989.97,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["15090741-04d2-42ca-a16d-f175e3d8a003",null,null,"INV","N",null,"29AECPK7239P1ZT",null,"NIRMALA TRAVELS",null,null,null,null,"907600200","2020-11-28",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,11219.67,null,1009.77,1009.77,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["15b1060b-ebf9-4e83-ace3-b803dc710392",null,null,"INV","N",null,"29AECPK7239P1ZT",null,"NIRMALA TRAVELS",null,null,null,null,"907600199","2020-12-05",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,5501.12,null,495.1,495.1,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["8283f37e-1431-4d80-bf28-05cba2a753de",null,null,"INV","N",null,"29AECPK7239P1ZT",null,"NIRMALA TRAVELS",null,null,null,null,"907600204","2020-12-07",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,5940.23,null,534.62,534.62,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["2d0239c2-1588-4cff-908b-dbe9af8ef07e",null,null,"INV","N",null,"29AEUPH1958J1ZS",null,"SHREE DURGAMBA  ENTERPRISES",null,null,null,null,"92","2020-06-24",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,3649,null,328.41,328.41,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["c3ecfdd2-8f09-4405-927d-bb055e6761f7",null,null,"INV","N",null,"29AKCPN9128N1ZH",null,"NANDITHA CIVIL CONTRACTORS",null,null,null,null,"CDT2102102840279","2021-01-31",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,0.65,null,0.06,0.06,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["6aa6f870-060b-43e1-afd8-2d2a206be98d",null,null,"INV","N",null,"29AKCPN9128N1ZH",null,"NANDITHA CIVIL CONTRACTORS",null,null,null,null,"FCU2108558456785","2021-03-26",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,52000.480000000003,null,4680.04,4680.04,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["06111e3b-bf36-44e2-9519-96f920d210a8",null,null,"INV","N",null,"29AKCPN9128N1ZH",null,"NANDITHA CIVIL CONTRACTORS",null,null,null,null,"SAW2108861489566","2021-03-31",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,22499.47,null,2024.95,2024.95,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["5d7bd19d-0087-4b66-a141-15e0fac7968b",null,null,"INV","N",null,"29ALTPP2275Q1ZW",null,"POOJA TRADERS",null,null,null,null,"FIN0912201782042","2020-11-30",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,122.35,null,11.01,11.01,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["312df5f8-e1b0-4ab7-8ca7-ce4b877c2848",null,null,"INV","N",null,"29ALTPP2275Q1ZW",null,"POOJA TRADERS",null,null,null,null,"FIN0212207176787","2020-12-02",null,null,"29AAFCC9980MZZT","29 - KA",null,"N",null,"IS",null,null,null,null,null,12081.76,null,1087.3599999999999,1087.3599999999999,null,null,null,null,null,null,"Only in Books","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"e9d05267-6e3b-43bf-89f0-024fa8579d47",null,"INV","N","Y",null,"29ATOPS1286R1ZF","ESSAR DIESEL SERVICE","2020-09-01","Y","2020-11-19","2020-09-01",null,null,"696","2020-09-12","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,13850,null,1246.5,1246.5,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
[null,"c4551fac-ce2f-4bdb-9898-c3a46b3308a3",null,"INV","N","Y",null,"29ATOPS1286R1ZF","ESSAR DIESEL SERVICE","2021-02-01","Y","2021-04-08","2021-02-01",null,null,"774","2021-02-26","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,4380,null,394.2,394.2,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]
["dda4070a-99da-4efc-82cf-2877f2081a34","b399ddd1-a375-4200-890d-48023709f174",null,"INV","N","Y","29AVXPP1476B1Z2","29AVXPP1478B1Z2","KARLE SOLUTIONS","2020-12-01","Y","2021-01-12","2020-12-01","260","2021-01-12","KS/417/GST20-21","2020-12-30","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Professional Fee & Service Charges@18%",3600,0,324,324,0,3600,0,324,324,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",13,"Match",0,0,0,0,"Multiple mismatches","To Check"]
["90b41cf3-1c79-455e-b9f1-828ad0c1dad2","b7c82e03-3b78-4eae-84df-7078d7b7c45a",null,"INV","N","Y","29AVXPP1476B1Z2","29AVXPP1478B1Z2","KARLE SOLUTIONS","2021-01-01","Y","2021-02-11","2021-01-01","277","2021-02-06","KS/454/GST20-21","2021-01-28","29AAFCC9980MZZT","29 - KA","29 - KA","N","N","IS",null,null,null,null,"Professional Fee & Service Charges@18%",3600,0,324,324,0,3600,0,324,324,0,"Books & Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)",null,null,null,"29AAFCC9980MZZT","29AAFCC9980MZZT","Exact Match","Exact Match","Weak Match",9,"Match",0,0,0,0,"Multiple mismatches","To Check"]
[null,"d3e2a05d-296b-49ae-a3d6-1ff1342a8d77",null,"INV","N","Y",null,"29BJEPB5348B1ZI","PRAMOD ENTERPRISES","2020-08-01","Y","2020-11-01","2020-08-01",null,null,"1692","2020-08-19","29AAFCC9980MZZT",null,"29 - KA",null,"N",null,null,null,null,null,null,null,null,null,null,null,3332,null,199.92,199.92,null,"Only in Portal","(Choose an Action)","(Choose an Action)","(Choose an Action)"]

{"sheet":"GSTR2A - Amendment vs. Original","index":3,"n_rows":2,"n_cols":27,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Taxpayer GSTIN","Section","Original Found?","Filing Period (Amd.)","Supplier GSTIN (Amd.)","Supplier Name (Amd.)","Invoice Number (Amd.)","Invoice Date (Amd.)","Place of Supply (Amd.)","Reverse Charge (Amd.)","Supplier Filing Status (Amd.)","Filing Period (Orig.)","Invoice Number (Orig.)","Invoice Date (Orig.)","Place of Supply (Orig.)","Reverse Charge (Orig.)","Supplier Filing Status (Orig.)","Taxable Amount (Amd.)","IGST Amount (Amd.)","CGST Amount (Amd.)","SGST Amount (Amd.)","Cess Amount (Amd.)","Taxable Amount (Orig.)","IGST Amount (Orig.)","CGST Amount (Orig.)","SGST Amount (Orig.)","Cess Amount (Orig.)"]
["29AAFCC9980MZZT","B2BA","Y","2021-09-01","29AADCJ3920H2ZT","J K TRANSPORT & LOGISTICS PRIVATE LIMITED","405889","2020-08-25","29 - KA","Y","Y","2020-08-01","405889","2020-08-25","29 - KA","Y","Y",6780,0,169.5,169.5,0,6780,0,0,0,0]

{"sheet":"GSTR-2A By Vendor","index":4,"n_rows":64,"n_cols":28,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Doc. Type","Invoice Month","Filing Period","Invoice Type","Supplier GSTIN","Supplier Name","POS State","Reverse Charge","Tax Rate","Supplier Filing Status","Taxable Amount (Books)","IGST Amount (Books)","CGST Amount (Books)","SGST Amount (Books)","Cess Amount (Books)","Taxable Amount (Portal)","IGST Amount (Portal)","CGST Amount (Portal)","SGST Amount (Portal)","Cess Amount (Portal)","Taxable Amount (Diff.)","IGST Amount (Diff.)","CGST Amount (Diff.)","SGST Amount (Diff.)","Cess Amount (Diff.)","GSTR-2A Table","Amended / Cancelled","ITC Eligibility (ISD)"]
["CRNA","2020-09-01","2020-09-01","R","06AAMFB6196I1ZV","Bawa Polymers","29 - KA","N",18,"Y",null,null,null,null,null,-1,-0.18,null,null,null,{"$f":"+K2-P2","v":1},{"$f":"+L2-Q2","v":0.18},0,0,0,5,"N","Y"]
["INV","2020-06-01","2020-06-01","R","07AAACV1556Q2ZR","V TRANS, V XPRESS & V LOGIS","29 - KA","N",18,"Y",null,null,null,null,null,24777.68,2973.32,null,null,null,{"$f":"+K3-P3","v":-24777.68},{"$f":"+L3-Q3","v":-2973.32},{"$f":"+M3-R3","v":0},{"$f":"+N3-S3","v":0},{"$f":"+O3-T3","v":0},3,"N","Y"]
["INV","2020-07-01","2020-07-01","R","24AAACW0946O1ZY","WALSON WOODBURN WIRE DIE PRIVATE LIMITED","29 - KA","N",18,"Y",null,null,null,null,null,13500,2430,null,null,null,-13500,-2430,0,0,0,3,"N","Y"]
["INV","2020-06-01","2020-06-01","R","24AAGCK9649B2ZI","KABA EXPRESS PRIVATE LIMITED","29 - KA","Y",18,"Y",null,null,null,null,null,2130,106.5,null,null,null,-2130,-106.5,0,0,0,3,"N","Y"]
["INV","2020-08-01","2020-08-01","R","24AAGCK9649B2ZI","KABA EXPRESS PRIVATE LIMITED","29 - KA","Y",18,"Y",null,null,null,null,null,3570,178.5,null,null,null,-3570,-178.5,0,0,0,3,"N","Y"]
["INV","2021-02-01","2021-02-01","R","24AAGCK9649B2ZI","KABA EXPRESS PRIVATE LIMITED","29 - KA","Y",18,"Y",null,null,null,null,null,4920,246,null,null,null,-4920,-246,0,0,0,3,"N","Y"]
["INV","2021-03-01","2021-03-01","R","24AAGCK9649B2ZI","KABA EXPRESS PRIVATE LIMITED","29 - KA","Y",18,"Y",null,null,null,null,null,7150,357.5,null,null,null,-7150,-357.5,0,0,0,3,"N","Y"]
["INV","2021-02-01","2021-02-01","R","24CRJPK8584S1Z3","MAJESTIC MARINE AND ENGINEERING SERVICES","29 - KA","N",18,"Y",5290,907,0,0,0,5040,907.2,0,0,0,250,-0.20000000000004547,0,0,0,3,"N","Y"]
["INV","2020-07-01","2020-07-01","R","26AAACH0793R1Z3","BAWA POLYMERS (PROP HARMAN BAWA PVT LTD)","29 - KA","N",18,"Y",110880,19958,0,0,0,147840,26611.200000000001,0,0,0,-36960,-6653.2000000000007,0,0,0,3,"N","Y"]
["INV","2021-03-01","2021-03-01","R","27AADFD2913K1ZL","DIVYAN EMULSICHEM","29 - KA","N",18,"Y",null,null,null,null,null,8750,1575,null,null,null,-8750,-1575,0,0,0,3,"N","Y"]
["INV","2021-03-01","2021-03-01","R","27AAYFS8197D1ZB","SUDHIR ENTERPRISE","29 - KA","N",18,"Y",null,null,null,null,null,59337.599999999999,10680.77,null,null,null,-59337.599999999999,-10680.77,0,0,0,3,"N","Y"]
["DBN","2020-06-01","2020-06-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,142274.56,null,12804.71,12804.71,null,-142274.56,0,-12804.71,-12804.71,0,5,"N","Y"]
["DBN","2020-06-01","2020-06-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,40230.11,null,3620.71,3620.71,null,-40230.11,0,-3620.71,-3620.71,0,5,"N","Y"]
["DBN","2020-06-01","2020-06-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,65337.22,null,5880.35,5880.35,null,-65337.22,0,-5880.35,-5880.35,0,5,"N","Y"]
["DBN","2020-07-01","2020-07-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,31,null,2.79,2.79,null,-31,0,-2.79,-2.79,0,5,"N","Y"]
["DBN","2020-07-01","2020-07-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,190,null,17.100000000000001,17.100000000000001,null,-190,0,-17.100000000000001,-17.100000000000001,0,5,"N","Y"]
["DBN","2020-07-01","2020-07-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,12191.56,null,1097.24,1097.24,null,-12191.56,0,-1097.24,-1097.24,0,5,"N","Y"]
["DBN","2020-08-01","2020-08-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,25126.33,null,2261.37,2261.37,null,-25126.33,0,-2261.37,-2261.37,0,5,"N","Y"]
["DBN","2020-08-01","2020-08-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,6924.11,null,623.16999999999996,623.16999999999996,null,-6924.11,0,-623.16999999999996,-623.16999999999996,0,5,"N","Y"]
["DBN","2020-08-01","2020-08-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,37651,null,3388.59,3388.59,null,-37651,0,-3388.59,-3388.59,0,5,"N","Y"]
["DBN","2020-08-01","2020-08-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,24484.560000000001,null,2203.61,2203.61,null,-24484.560000000001,0,-2203.61,-2203.61,0,5,"N","Y"]
["INV","2020-10-01","2020-10-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",2144032,0,192792,192792,0,2142135.67,0,192792.21,192792.21,0,1896.3300000000745,0,-0.20999999999185093,-0.20999999999185093,0,3,"N","Y"]
["INV","2020-10-01","2020-10-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",1605218,0,144342,144342,0,1603798.78,0,144341.89000000001,144341.89000000001,0,1419.2199999999721,0,0.10999999998603016,0.10999999998603016,0,3,"N","Y"]
["INV","2020-10-01","2020-10-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",2101556,0,188973,188973,0,2099697.56,0,188972.78,188972.78,0,1858.4399999999441,0,0.22000000000116415,0.22000000000116415,0,3,"N","Y"]
["INV","2020-10-01","2020-10-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",2178115,0,195857,195857,0,2176189.4399999999,0,195857.05,195857.05,0,1925.5600000000559,0,-4.9999999988358468E-2,-4.9999999988358468E-2,0,3,"N","Y"]
["DBN","2020-10-01","2020-10-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,52132.11,null,4691.8900000000003,4691.8900000000003,null,-52132.11,0,-4691.8900000000003,-4691.8900000000003,0,5,"N","Y"]
["DBN","2020-11-01","2020-11-01","R","29AAACH1601R1ZJ","HINDALBIRLA COPPER","29 - KA","N",18,"Y",null,null,null,null,null,61300.56,null,5517.05,5517.05,null,-61300.56,0,-5517.05,-5517.05,0,5,"N","Y"]
["INV","2020-08-01","2020-08-01","R","29AAAFI5825Q1ZT","INDUSTRIAL EQUIPMENT MARKETING CO","29 - KA","N",18,"Y",3735,0,336,336,0,3735,0,336.15,336.15,0,0,0,-0.14999999999997726,-0.14999999999997726,0,3,"N","Y"]
["INV","2020-05-01","2020-05-01","R","29AABFA3605H1ZR","ASHOK INC","29 - KA","N",18,"Y",7600,0,684,684,0,7600,0,684,684,0,0,0,0,0,0,3,"N","Y"]
["INV","2020-08-01","2020-08-01","R","29AABFA3605H1ZR","ASHOK INC","29 - KA","N",18,"Y",13100,0,1179,1179,0,13100,0,1179,1179,0,0,0,0,0,0,3,"N","Y"]
["INV","2020-11-01","2020-11-01","R","29AABFA3605H1ZR","ASHOK INC","29 - KA","N",18,"Y",4100,0,369,369,0,4100,0,369,369,0,0,0,0,0,0,3,"N","Y"]
["INV","2021-03-01","2021-03-01","R","29AABFA3605H1ZR","ASHOK INC","29 - KA","N",18,"Y",6500,0,585,585,0,6500,0,585,585,0,0,0,0,0,0,3,"N","Y"]
["INV","2021-03-01","2021-03-01","R","29AABFA3605H1ZR","ASHOK INC","29 - KA","N",18,"Y",5170,0,465,465,0,5170,0,465.3,465.3,0,0,0,-0.30000000000001137,-0.30000000000001137,0,3,"N","Y"]
["INV","2021-03-01","2021-03-01","R","29AABFA3605H1ZR","ASHOK INC","29 - KA","N",18,"Y",1200,0,108,108,0,1200,0,108,108,0,0,0,0,0,0,3,"N","Y"]
["INV","2020-06-01","2020-06-01","R","29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","29 - KA","N",18,"Y",null,null,null,null,null,7200,null,null,null,null,-7200,0,0,0,0,3,"Y","Y"]
["INV","2020-08-01","2020-08-01","R","29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","29 - KA","Y",18,"Y",null,null,null,null,null,6780,null,null,null,null,-6780,0,0,0,0,3,"Y","Y"]
["INV","2020-10-01","2020-10-01","R","29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","29 - KA","Y",18,"Y",null,null,null,null,null,9550,null,null,null,null,-9550,0,0,0,0,3,"Y","Y"]
["INV","2020-12-01","2020-12-01","R","29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","29 - KA","Y",18,"Y",null,null,null,null,null,8670,null,null,null,null,-8670,0,0,0,0,3,"Y","Y"]
["INV","2020-12-01","2020-12-01","R","29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","29 - KA","Y",18,"Y",null,null,null,null,null,7830,null,null,null,null,-7830,0,0,0,0,3,"Y","Y"]
["INV","2020-12-01","2020-12-01","R","29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","29 - KA","Y",18,"Y",null,null,null,null,null,8460,null,null,null,null,-8460,0,0,0,0,3,"Y","Y"]
["INV","2021-01-01","2021-01-01","R","29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","29 - KA","Y",18,"Y",null,null,null,null,null,8040,null,null,null,null,-8040,0,0,0,0,3,"Y","Y"]
["INV","2021-02-01","2021-02-01","R","29AADCJ3920H2ZT","TRANSPORT & LOGISTICS pvt ltd","29 - KA","Y",18,"Y",null,null,null,null,null,8670,null,null,null,null,-8670,0,0,0,0,3,"Y","Y"]
["INV","2020-12-01","2020-12-01","R","29AADCS9958B1ZY","STOVE KRAFT LIMITED","29 - KA","N",18,"Y",5992,0,535,535,0,5500.32,0,495.03,495.03,0,491.68000000000029,0,39.970000000000027,39.970000000000027,0,3,"N","Y"]
["INV","2021-03-01","2021-03-01","R","29AADFV7589C1ZO","VENU & VINAY","29 - KA","N",18,"Y",null,null,null,null,null,4000,null,360,360,null,-4000,0,-360,-360,0,3,"N","Y"]
["INV","2021-02-01","2021-02-01","R","29AAECB6725G1ZL","BBW BRUSHES PRIVATE LIMITED","29 - KA","N",18,"Y",1050,0,63,63,0,1200,0,76.5,76.5,0,-150,0,-13.5,-13.5,0,3,"N","Y"]
["INV","2020-09-01","2020-09-01","R","29AAKPJ8117D1ZO","SRI PARSHWANATH INDUSTRIES","29 - KA","N",18,"Y",null,null,null,null,null,13750,null,1237.5,1237.5,null,-13750,0,-1237.5,-1237.5,0,3,"N","Y"]
["DBN","2020-07-01","2020-07-01","R","29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","29 - KA","N",18,"Y",null,null,null,null,null,109252,null,9833,9833,null,-109252,0,-9833,-9833,0,5,"N","Y"]
["DBN","2020-09-01","2020-09-01","R","29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","29 - KA","N",18,"Y",null,null,null,null,null,6735,null,606,606,null,-6735,0,-606,-606,0,5,"N","Y"]
["INV","2020-10-01","2020-10-01","R","29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","29 - KA","N",18,"Y",null,null,null,null,null,2089366,null,188043,188043,1849,-2089366,0,-188043,-188043,-1849,3,"Y","Y"]
["DBN","2020-10-01","2020-10-01","R","29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","29 - KA","N",18,"Y",null,null,null,null,null,48247,null,4342,4342,43,-48247,0,-4342,-4342,-43,5,"Y","Y"]
["DBNA","2020-11-01","2020-11-01","R","29AALCS3938B1Z6","SWARNAGIRI INSULATING COMPANY (P) LTD.","29 - KA","N",18,"Y",null,null,null,null,null,48247,null,4342,4342,null,-48247,0,-4342,-4342,0,5,"N","Y"]
["INV","2020-06-01","2020-06-01","R","29AARPR8772K1ZH","PREMIER PACKS","29 - KA","N",18,"Y",18942,0,1137,1137,0,7350,0,441,441,0,11592,0,696,696,0,3,"N","Y"]
["INV","2020-07-01","2020-07-01","R","29AARPR8772K1ZH","PREMIER PACKS","29 - KA","N",18,"Y",48107,0,2886,2886,0,39715.800000000003,0,2382.9499999999998,2382.9499999999998,0,8391.1999999999971,0,503.05000000000018,503.05000000000018,0,3,"N","Y"]
["INV","2020-08-01","2020-08-01","R","29AAZPL1767E1Z3","BALAJI ELECTRONICS","29 - KA","N",18,"Y",8651,0,778,778,0,8650,0,778.5,778.5,0,1,0,-0.5,-0.5,0,3,"N","Y"]
["INV","2020-06-01","2020-06-01","R","29ABTPD0493L1Z3","Metro Berry Industrial Suppliers","29 - KA","N",18,"Y",3650,0,328,328,0,3649,0,328.5,328.5,0,1,0,-0.5,-0.5,0,3,"N","Y"]
["INV","2020-06-01","2020-06-01","R","29ACFPP7543K1Z1","ASHREERA ENTERPRISES","29 - KA","N",18,"Y",9102,0,819,819,0,9101.69,0,819.15,819.15,0,0.30999999999949068,0,-0.14999999999997726,-0.14999999999997726,0,3,"N","Y"]
["INV","2021-01-01","2021-01-01","R","29ACNPR9657Q1Z0","INNOVATIVE ENGINEERS","29 - KA","N",18,"Y",3600,0,324,324,0,3600,0,324,324,0,0,0,0,0,0,3,"N","Y"]
["INV","2020-12-01","2020-12-01","R","29ACWPG8054C1Z9","S J MARKETING COMPANY","29 - KA","N",18,"Y",null,null,null,null,null,25200,null,2268,2268,null,-25200,0,-2268,-2268,0,3,"N","Y"]
["INV","2020-09-01","2020-09-01","R","29ATOPS1286R1ZF","ESSAR DIESEL SERVICE","29 - KA","N",18,"Y",null,null,null,null,null,13850,null,1246.5,1246.5,null,-13850,0,-1246.5,-1246.5,0,3,"N","Y"]
["INV","2021-02-01","2021-02-01","R","29ATOPS1286R1ZF","ESSAR DIESEL SERVICE","29 - KA","N",18,"Y",null,null,null,null,null,4380,null,394.2,394.2,null,-4380,0,-394.2,-394.2,0,3,"N","Y"]
["INV","2020-12-01","2020-12-01","R","29AVXPP1478B1Z2","KARLE SOLUTIONS","29 - KA","N",18,"Y",3600,0,324,324,0,3600,0,324,324,0,0,0,0,0,0,3,"N","Y"]
["INV","2021-01-01","2021-01-01","R","29AVXPP1478B1Z2","KARLE SOLUTIONS","29 - KA","N",18,"Y",3600,0,324,324,0,3600,0,324,324,0,0,0,0,0,0,3,"N","Y"]
["INV","2020-08-01","2020-08-01","R","29BJEPB5348B1ZI","PRAMOD ENTERPRISES","29 - KA","N",18,"Y",null,null,null,null,null,3332,null,199.92,199.92,null,-3332,0,-199.92,-199.92,0,3,"N","Y"]