{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Vendor List","Invoice Type","Data Enter","Collection Types","Collections ","Data Entry - Post sheet","Collection Post Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Vendor List","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Vendor name","Vendor Id"]
["Al safa","A0008"]
["Egyptian Maintenance Company(EMC)","E0011"]
["Petroleum Arrows","P0058"]
["Pico"]

{"sheet":"Invoice Type","index":1,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Custom Clearance"]
["Material Sold"]
["Penality"]
["Rental Heavy Equipment"]
["Used oil"]
["Waste Water"]
["Network Tower"]
["Cancel Order"]
["Other"]

{"sheet":"Data Enter","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Vendor Name"]
["Vendor Id",{"$f":"IFERROR(VLOOKUP($B$2,'Vendor List'!$A$2:$B$500,2,0),\"\")","v":""}]
["Vendor Type"]
["Invoice Type"]
["Year"]
["Referance"]
["Currencey"]
["Invoice Status"]
["Debit Note No.#"]
["Amount"]
["Overhead"]
["Net Amount"]
["Description"]

{"sheet":"Collection Types","index":3,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Types"]
["Transfer"]
["Check"]
["Deduct From Dues"]

{"sheet":"Collections ","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Date"]
["Types"]
["Reference"]
["Vendor Name"]
["Vendor Id",{"$f":"IFERROR(VLOOKUP($B$4,'Vendor List'!$A$2:$B$500,2,0),\"\")","v":""}]
["Debit Note Number"]
["Currency"]
["Original Amount"]
["Collected"]
["Net balance"]

{"sheet":"Data Entry - Post sheet","index":5,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Date","Vendor Name","Vendor Id","Vendor Type","Invoice Type","Year","Referance","Currencey","Invoice Status","Debit Note NO#","Amount","Overhead","Net Amount","Description"]
["2019-10-10","Egyptian Maintenance Company(EMC)","E0011","ggggggg","Rental Heavy Equipment",null,null,null,null,null,null,null,null,"dddddd"]

{"sheet":"Collection Post Sheet","index":6,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Date","Types","Reference","Vendor Name","Vendor Id","Debit Note Number","Currency","Original Amount","Collected","Net balance"]
["2019-10-10","Check",null,"Egyptian Maintenance Company(EMC)","E0011"]