{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","Invoices","Payments","Entities","Lists","Setup"],"not_rendered":{"charts":3,"images":4,"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":"Home","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Invoices","index":1,"n_rows":18,"n_cols":20,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
["Invoice ID","Entity","Details","Category","Entity Type","Payment Terms","Invoice Date","Manual Due Date","Due Date","Original Amount","Manual Currency","Currency","Paid","Balance","Status","Days Overdue","FX Rate From","FX Rate To","Paid FX Rate","Balance FX Rate"]
["INV-1001","Amazon Supplier Ltd","Monthly Retainer","Office",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":7},"2026-04-04",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-04-11"},150,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"USD"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":150},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Paid"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":150},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0}]
["INV-1002","Fresh Foods Co","Invoice #FF-1023","Office",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":14},"2026-03-25",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-04-08"},200,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"EUR"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":200},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Paid"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":236},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0}]
["INV-1003","Office Depot","Office Supplies Mar","Office",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":30},"2026-03-15",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-04-14"},250,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"GBP"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":100},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":150},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Late"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":2},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.25},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":125},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":187.5}]
["INV-1004","Tech Components Inc","Hardware Batch #TC-88","Office",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":0},"2026-03-05",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-03-05"},300,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"USD"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":100},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":200},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Late"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":42},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":100},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":200}]
["INV-1005","Global Packaging","Packaging Order #GP-1","Office",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":7},"2026-02-23","2026-05-15",{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-05-15"},350,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"EUR"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":100},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":250},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Open"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":118},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":295}]
["INV-1006","Global Packaging","Packaging Order #GP-2","Office",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":7},"2026-02-13",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-02-20"},400,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"EUR"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":400},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Paid"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":472},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0}]
["INV-1007","Global Packaging","Packaging Adjustment","Office",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":7},"2026-02-03",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-02-10"},450,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"EUR"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":450},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Late"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":65},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":531}]
["INV-1008","Global Packaging","Bulk Packaging Order","Office",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":7},"2026-01-24",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-01-31"},500,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"EUR"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":500},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Paid"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":590},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0}]
["INV-1009","Global Packaging","Food Packaging Lot","Food",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":7},"2026-01-14",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-01-21"},550,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"EUR"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":550},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Late"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":85},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":649}]
["INV-1010","Office Depot","Pantry Supplies","Food",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":30},"2026-04-12",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-05-12"},475,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"GBP"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":475},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Open"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.25},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":593.75}]
["INV-1011","AJ Hardware","Equipment Purchase","Product",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":14},"2026-03-31","2026-06-15",{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-06-15"},1500,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"GBP"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":1500},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Open"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.25},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":1875}]
["INV-1012","NextGen Tech","Consulting Phase 1","Consulting",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":30},"2026-03-08",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-04-07"},2500,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"USD"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":2000},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":500},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Late"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":9},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":2000},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":500}]
["INV-1013","NextGen Tech","Product Integration","Product",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":30},"2026-03-12",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-04-11"},3250,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"USD"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":3250},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Paid"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":3250},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0}]
["INV-1014","NextGen Tech","Consulting Phase 2","Consulting",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":30},"2026-02-18","2026-08-20",{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-08-20"},500,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"USD"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":500},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Open"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":0},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":500}]
["INV-1015","NextGen Tech","Support Retainer","Consulting",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":30},"2026-02-25",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-03-27"},1250,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"USD"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":1250},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Late"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":20},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":0},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":1250}]
["INV-1016","NextGen Tech","Final Delivery","Consulting",{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Type],\"\",0)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Payment Terms],\"\",0)","v":30},"2026-02-03",null,{"$f":"IF(tblInvoices[[#This Row],[Manual Due Date]]>0,tblInvoices[[#This Row],[Manual Due Date]],tblInvoices[[#This Row],[Payment Terms]]+tblInvoices[[#This Row],[Invoice Date]])","v":"2026-03-05"},4000,null,{"$f":"IF(tblInvoices[[#This Row],[Manual Currency]]>0,tblInvoices[[#This Row],[Manual Currency]],_xlfn.XLOOKUP(tblInvoices[[#This Row],[Entity]],tblEntities[Entity Name],tblEntities[Currency],\"\",0))","v":"USD"},{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":2000},{"$f":"tblInvoices[[#This Row],[Original Amount]]-tblInvoices[[#This Row],[Paid]]","v":2000},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[Original Amount]]=\"\",\"\",\n    tblInvoices[[#This Row],[Balance]]=0,\"Paid\",\n    TODAY()>tblInvoices[[#This Row],[Due Date]],\"Late\",\n    TRUE,\"Open\"\n)","v":"Late"},{"$f":"IF(tblInvoices[[#This Row],[Status]]=\"Late\",TODAY()-tblInvoices[[#This Row],[Due Date]],0)","v":42},{"$f":"_xlfn.XLOOKUP(tblInvoices[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblInvoices[[#This Row],[Paid]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":2000},{"$f":"tblInvoices[[#This Row],[Balance]]*tblInvoices[[#This Row],[FX Rate From]]/tblInvoices[[#This Row],[FX Rate To]]","v":2000}]

{"sheet":"Payments","index":2,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
["Payment ID","Invoice ID","Details","Entity","Invoice Type","Invoice Details","Open Amount","Currency","Payment Date","Amount","Payment Method","FX Rate From","FX Rate To","Amount FX Rate"]
["PAY-2005","INV-1001",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Monthly Retainer"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Amazon Supplier Ltd"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Monthly Retainer"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":0},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"USD"},"2026-04-04",100,"Bank Transfer",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":100}]
["PAY-2006","INV-1003",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Office Supplies Mar"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Office Depot"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Office Supplies Mar"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":150},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"GBP"},"2026-04-04",50,"Credit Card",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.25},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":62.5}]
["PAY-2007","INV-1002",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Invoice #FF-1023"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Fresh Foods Co"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Invoice #FF-1023"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":0},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"EUR"},"2026-04-04",200,"Bank Transfer",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":236}]
["PAY-2008","INV-1006",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Packaging Order #GP-2"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Global Packaging"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Packaging Order #GP-2"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":0},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"EUR"},"2026-03-20",400,"Bank Transfer",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":472}]
["PAY-2009","INV-1003",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Office Supplies Mar"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Office Depot"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Office Supplies Mar"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":150},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"GBP"},"2026-04-10",50,"Credit Card",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.25},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":62.5}]
["PAY-2010","INV-1001",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Monthly Retainer"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Amazon Supplier Ltd"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Monthly Retainer"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":0},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"USD"},"2026-04-10",50,"Bank Transfer",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":50}]
["PAY-2011","INV-1008",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Bulk Packaging Order"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Global Packaging"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Bulk Packaging Order"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":0},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"EUR"},"2026-03-01",200,"Bank Transfer",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":236}]
["PAY-2012","INV-1008",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Bulk Packaging Order"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Global Packaging"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Bulk Packaging Order"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":0},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"EUR"},"2026-03-15",300,"Credit Card",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":354}]
["PAY-2013","INV-1004",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Hardware Batch #TC-88"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Tech Components Inc"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Hardware Batch #TC-88"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":200},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"USD"},"2026-02-01",100,"Bank Transfer",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":100}]
["PAY-2014","INV-1005",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Packaging Order #GP-1"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"Global Packaging"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Vendor"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Packaging Order #GP-1"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":250},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"EUR"},"2026-03-05",100,"Credit Card",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1.18},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":118}]
["PAY-2015","INV-1016",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Final Delivery"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"NextGen Tech"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Final Delivery"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":2000},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"USD"},"2026-01-16",2000,"Credit Card",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":2000}]
["PAY-2016","INV-1013",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Product Integration"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"NextGen Tech"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Product Integration"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":0},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"USD"},"2026-04-06",1600,"Bank Transfer",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":1600}]
["PAY-2017","INV-1013",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Product Integration"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"NextGen Tech"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Product Integration"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":0},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"USD"},"2026-04-14",1650,"Bank Transfer",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":1650}]
["PAY-2018","INV-1012",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],\"\",0)","v":"Consulting Phase 1"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity],\"\",0)","v":"NextGen Tech"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Entity Type],\"\",0,)","v":"Customer"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Details],0,0,)","v":"Consulting Phase 1"},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Balance],0,0,)","v":500},{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Invoice ID]],tblInvoices[Invoice ID],tblInvoices[Currency],0,0,)","v":"USD"},"2026-02-05",2000,"Credit Card",{"$f":"_xlfn.XLOOKUP(tblPayments[[#This Row],[Currency]],tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"_xlfn.XLOOKUP(Setup!$A$11,tblCurrency[Currency],tblCurrency[FX Rate to USD],\"\",0)","v":1},{"$f":"tblPayments[[#This Row],[Amount]]*tblPayments[[#This Row],[FX Rate From]]/tblPayments[[#This Row],[FX Rate To]]","v":2000}]

{"sheet":"Entities","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Entity Name","Type","Payment Terms","Currency"]
["Amazon Supplier Ltd","Vendor",7,"USD"]
["Fresh Foods Co","Vendor",14,"EUR"]
["Office Depot","Vendor",30,"GBP"]
["Tech Components Inc","Vendor",0,"USD"]
["Global Packaging","Vendor",7,"EUR"]
["AJ Hardware","Customer",14,"GBP"]
["Blue Retail","Customer",30,"USD"]
["Green Market","Customer",7,"USD"]
["Urban Stores","Customer",14,"USD"]
["NextGen Tech","Customer",30,"USD"]

{"sheet":"Lists","index":4,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Category",null,"Payment Method",null,"Currency","FX Rate to USD","Symbol",null,"Payment Terms",null,"Selected Currency"]
["Office",null,"Bank Transfer",null,"USD",1,"$",null,7,null,"USD"]
["Food",null,"Credit Card",null,"EUR",1.18,"€",null,14]
["Travel",null,"PayPal",null,"GBP",1.25,"£",null,30]
["Product",null,null,null,null,null,null,null,0]
["Consulting"]

{"sheet":"Setup","index":5,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,14,0,15],[0,16,0,17]]}
["Key","Value",null,"Home",null,null,null,"Cash Flow  Trend",null,null,null,null,null,"Aging Analysis",null,null,"With Icons"]
["Version","Free",null,"KPI","Format","Values",null,"Month","Inflow","Outflow","Net","Cumulative Cash Position",null,"Bucket","Receivables","Payables","Receivables","Payables","From","To"]
["MaxInvoices",10,null,"Expected Inflow",{"$f":"$A$9 & TEXT(F3,\"#,##0\")","v":"$6,125"},{"$f":"SUMIFS(tblInvoices[Balance FX Rate],tblInvoices[Entity Type],\"Customer\")","v":6125},null,{"$f":"EOMONTH(TODAY(),-5)","v":"2025-11-30"},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Customer\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H3,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H3,0)\n)","v":0},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Vendor\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H3,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H3,0)\n)","v":0},{"$f":"I3-J3","v":0},{"$f":"SUM($K$3:K3)","v":0},null,"Current",{"$f":"SUMIFS(tblInvoices[Balance FX Rate],\n        tblInvoices[Days Overdue],\">=\"&$S3,\n        tblInvoices[Days Overdue],\"<=\"&$T3,\n        tblInvoices[Entity Type],\"Customer\")","v":2375},{"$f":"SUMIFS(tblInvoices[Balance FX Rate],\n        tblInvoices[Days Overdue],\">=\"&$S3,\n        tblInvoices[Days Overdue],\"<=\"&$T3,\n        tblInvoices[Entity Type],\"Vendor\")","v":888.75},{"$f":"$A$9 & TEXT(O3,\"#,##0\")","v":"$2,375"},{"$f":"$A$9 & TEXT(P3,\"#,##0\")","v":"$889"},0,0]
["MaxPayments",20,null,"Expected Outflow",{"$f":"$A$9 & TEXT(F4,\"#,##0\")","v":"$2,456"},{"$f":"SUMIFS(tblInvoices[Balance FX Rate],tblInvoices[Entity Type],\"Vendor\")","v":2456.25},null,{"$f":"EOMONTH(H3,1)","v":"2025-12-31"},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Customer\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H4,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H4,0)\n)","v":0},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Vendor\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H4,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H4,0)\n)","v":0},{"$f":"I4-J4","v":0},{"$f":"SUM($K$3:K4)","v":0},null,"1–30 Late",{"$f":"SUMIFS(tblInvoices[Balance FX Rate],\n        tblInvoices[Days Overdue],\">=\"&$S4,\n        tblInvoices[Days Overdue],\"<=\"&$T4,\n        tblInvoices[Entity Type],\"Customer\")","v":1750},{"$f":"SUMIFS(tblInvoices[Balance FX Rate],\n        tblInvoices[Days Overdue],\">=\"&$S4,\n        tblInvoices[Days Overdue],\"<=\"&$T4,\n        tblInvoices[Entity Type],\"Vendor\")","v":187.5},{"$f":"$A$9 & TEXT(O4,\"#,##0\")","v":"$1,750"},{"$f":"$A$9 & TEXT(P4,\"#,##0\")","v":"$188"},1,30]
[null,null,null,"Net Position","$3,669",{"$f":"F3-F4","v":3668.75},null,{"$f":"EOMONTH(H4,1)","v":"2026-01-31"},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Customer\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H5,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H5,0)\n)","v":2000},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Vendor\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H5,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H5,0)\n)","v":0},2000,{"$f":"SUM($K$3:K5)","v":2000},null,"31–60 Late",{"$f":"SUMIFS(tblInvoices[Balance FX Rate],\n        tblInvoices[Days Overdue],\">=\"&$S5,\n        tblInvoices[Days Overdue],\"<=\"&$T5,\n        tblInvoices[Entity Type],\"Customer\")","v":2000},{"$f":"SUMIFS(tblInvoices[Balance FX Rate],\n        tblInvoices[Days Overdue],\">=\"&$S5,\n        tblInvoices[Days Overdue],\"<=\"&$T5,\n        tblInvoices[Entity Type],\"Vendor\")","v":200},"$2,000","$200",{"$f":"T4+1","v":31},60]
[{"$f":"\"All values shown in \"&Table8[Selected Currency]","v":"All values shown in USD"},null,null,"Overdue Receivables","$3,750",{"$f":"SUMIFS(tblInvoices[Balance FX Rate],tblInvoices[Entity Type],\"Customer\",tblInvoices[Status],\"Late\")","v":3750},null,"2026-02-28",{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Customer\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H6,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H6,0)\n)","v":2000},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Vendor\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H6,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H6,0)\n)","v":100},1900,{"$f":"SUM($K$3:K6)","v":3900},null,"60+ Late",{"$f":"SUMIFS(tblInvoices[Balance FX Rate],\n        tblInvoices[Days Overdue],\">=\"&$S6,\n        tblInvoices[Days Overdue],\"<=\"&$T6,\n        tblInvoices[Entity Type],\"Customer\")","v":0},{"$f":"SUMIFS(tblInvoices[Balance FX Rate],\n        tblInvoices[Days Overdue],\">=\"&$S6,\n        tblInvoices[Days Overdue],\"<=\"&$T6,\n        tblInvoices[Entity Type],\"Vendor\")","v":1180},"$0","$1,180",{"$f":"T5+1","v":61},999999]
[null,null,null,"Overdue Payables","$1,568",{"$f":"SUMIFS(tblInvoices[Balance FX Rate],tblInvoices[Entity Type],\"Vendor\",tblInvoices[Status],\"Late\")","v":1567.5},null,"2026-03-31",{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Customer\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H7,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H7,0)\n)","v":0},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Vendor\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H7,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H7,0)\n)","v":1180},-1180,{"$f":"SUM($K$3:K7)","v":2720}]
["Currency",null,null,"Customer Paid This Month","$3,250",{"$f":"SUMIFS(tblPayments[Amount FX Rate],tblPayments[Invoice Type],\"Customer\",tblPayments[Payment Date],\">=\"&$D$15,tblPayments[Payment Date],\"<=\"&$E$15)","v":3250},null,"2026-04-30",{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Customer\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H8,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H8,0)\n)","v":3250},{"$f":"SUMIFS(\n    tblPayments[Amount FX Rate],\n    tblPayments[Invoice Type],\"Vendor\",\n    tblPayments[Payment Date], \">=\"&EOMONTH($H8,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH($H8,0)\n)","v":511},2739,{"$f":"SUM($K$3:K8)","v":5459}]
[{"$f":"_xlfn.XLOOKUP(Table8[Selected Currency],tblCurrency[Currency],tblCurrency[Symbol],\"\",0,)","v":"$"},null,null,"Vendor Paid This Month","$511",{"$f":"SUMIFS(tblPayments[Amount FX Rate],tblPayments[Invoice Type],\"Vendor\",tblPayments[Payment Date],\">=\"&$D$15,tblPayments[Payment Date],\"<=\"&$E$15)","v":511}]
["Selected Currency",null,null,"Paid This Month","$2,739",{"$f":"F8-F9","v":2739},null,"Month",{"$f":"I2&\"With Icons\"","v":"InflowWith Icons"},"OutflowWith Icons","NetWith Icons",{"$f":"L2&\"With Icons\"","v":"Cumulative Cash PositionWith Icons"}]
[{"$f":"Table8[Selected Currency]","v":"USD"},null,null,"Open Receivables",{"$f":"F11","v":5},{"$f":"COUNTIFS(tblInvoices[Entity Type],\"Customer\",tblInvoices[Balance FX Rate],\">0\")","v":5},null,{"$f":"H3","v":"2025-11-30"},{"$f":"$A$9 & TEXT(I3,\"#,##0\")","v":"$0"},"$0","$0",{"$f":"$A$9 & TEXT(L3,\"#,##0\")","v":"$0"}]
[null,null,null,"Open Payables",6,{"$f":"COUNTIFS(tblInvoices[Entity Type],\"Vendor\",tblInvoices[Balance FX Rate],\">0\")","v":6},null,{"$f":"H4","v":"2025-12-31"},{"$f":"$A$9 & TEXT(I4,\"#,##0\")","v":"$0"},"$0","$0","$0"]
[null,null,null,null,null,null,null,"2026-01-31",{"$f":"$A$9 & TEXT(I5,\"#,##0\")","v":"$2,000"},"$0","$2,000","$2,000"]
[null,null,null,"This Month",null,null,null,"2026-02-28",{"$f":"$A$9 & TEXT(I6,\"#,##0\")","v":"$2,000"},"$100","$1,900","$3,900"]
[null,null,null,{"$f":"EOMONTH(TODAY(),-1)+1","v":"2026-04-01"},{"$f":"EDATE(D15,1)-1","v":"2026-04-30"},null,null,"2026-03-31",{"$f":"$A$9 & TEXT(I7,\"#,##0\")","v":"$0"},"$1,180","$-1,180","$2,720"]
[null,null,null,null,null,null,null,"2026-04-30",{"$f":"$A$9 & TEXT(I8,\"#,##0\")","v":"$3,250"},"$511","$2,739","$5,459"]