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

{"sheet":"Invoices","index":1,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
["Invoice ID","Vendor","Invoice Date","Due Date","Amount","Paid Total","Balance","Status","Days Overdue","Category","Notes"]
["INV-1001","Amazon Supplier Ltd","2026-04-04","2026-05-04",150,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":150},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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},"Office"]
["INV-1002","Fresh Foods Co","2026-03-25","2026-04-24",200,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":200},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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},"Office"]
["INV-1003","Office Depot","2026-03-15","2026-04-14",250,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":100},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":150},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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":1},"Office"]
["INV-1004","Tech Components Inc","2026-03-05","2026-04-04",300,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":100},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":200},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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":11},"Office"]
["INV-1005","Global Packaging","2026-02-23","2026-03-25",350,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":100},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":250},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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":21},"Office"]
["INV-1006","Global Packaging","2026-02-13","2026-03-15",400,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":400},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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},"Office"]
["INV-1007","Global Packaging","2026-02-03","2026-02-05",450,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":450},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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":69},"Office"]
["INV-1008","Global Packaging","2026-01-24","2026-02-23",500,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":500},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":0},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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},"Office"]
["INV-1009","Global Packaging","2026-01-14","2025-02-13",550,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":550},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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":426},"Food"]
["INV-1010","Office Depot","2026-04-12","2026-06-20",475,{"$f":"SUMIFS(tblPayments[Amount],tblPayments[Invoice ID],tblInvoices[[#This Row],[Invoice ID]])","v":0},{"$f":"tblInvoices[[#This Row],[Amount]]-tblInvoices[[#This Row],[Paid Total]]","v":475},{"$f":"_xlfn.IFS(\n    tblInvoices[[#This Row],[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},"Food"]

{"sheet":"Payments","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
["Payment ID","Invoice ID","Payment Date","Amount","Payment Method","Notes"]
["PAY-2005","INV-1001","2026-04-04",100,"Bank Transfer","Partial payment"]
["PAY-2006","INV-1003","2026-04-04",50,"Credit Card","Partial"]
["PAY-2007","INV-1002","2026-04-04",200,"Bank Transfer","Fully paid"]
["PAY-2008","INV-1006","2026-03-20",400,"Bank Transfer","Fully paid"]
["PAY-2009","INV-1003","2026-04-10",50,"Credit Card","Additional payment"]
["PAY-2010","INV-1001","2026-04-10",50,"Bank Transfer","Completed"]
["PAY-2011","INV-1008","2026-03-01",200,"Bank Transfer","Partial"]
["PAY-2012","INV-1008","2026-03-15",300,"Credit Card","Completed"]
["PAY-2013","INV-1004","2026-04-01",100,"Bank Transfer","Partial"]
["PAY-2014","INV-1005","2026-04-05",100,"Credit Card","Partial"]

{"sheet":"Vendors","index":3,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["Vendor Name"]
["Amazon Supplier Ltd"]
["Fresh Foods Co"]
["Office Depot"]
["Tech Components Inc"]
["Global Packaging"]

{"sheet":"Lists","index":4,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Category",null,"Payment Method"]
["Office",null,"Bank Transfer"]
["Food",null,"Credit Card"]

{"sheet":"Setup","index":5,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Key","Value",null,"Home",null,null,"Aging Analysis",null,null,null,null,"Cash Flow (Last 6 Months)"]
["Version","Free",null,"KPI",null,null,"Bucket","Amount","From","To",null,"Month","Payments","Invoices"]
["MaxInvoices",10,null,"Total Outstanding",{"$f":"SUM(tblInvoices[Balance])","v":2075},null,"0–30",{"$f":"SUMIFS(tblInvoices[Balance],\n        tblInvoices[Days Overdue],\">=\"&I3,\n        tblInvoices[Days Overdue],\"<=\"&J3)","v":1075},0,30,null,{"$f":"EOMONTH(TODAY(),-5)","v":"2025-11-30"},{"$f":"SUMIFS(\n    tblPayments[Amount],\n    tblPayments[Payment Date], \">=\"&EOMONTH(L3,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH(L3,0)\n)","v":0},{"$f":"SUMIFS(\n    tblInvoices[Amount],\n    tblInvoices[Invoice Date], \">=\"&EOMONTH(L3,-1)+1,\n    tblInvoices[Invoice Date], \"<=\"&EOMONTH(L3,0)\n)","v":0}]
["MaxPayments",20,null,"Overdue Amount",{"$f":"SUMIFS(\n    tblInvoices[Balance],\n    tblInvoices[Due Date], \"<\"&TODAY(),\n    tblInvoices[Balance], \">0\"\n)","v":1600},null,"31–60",{"$f":"SUMIFS(tblInvoices[Balance],\n        tblInvoices[Days Overdue],\">=\"&I4,\n        tblInvoices[Days Overdue],\"<=\"&J4)","v":0},{"$f":"J3+1","v":31},60,null,{"$f":"EOMONTH(L3,1)","v":"2025-12-31"},{"$f":"SUMIFS(\n    tblPayments[Amount],\n    tblPayments[Payment Date], \">=\"&EOMONTH(L4,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH(L4,0)\n)","v":0},{"$f":"SUMIFS(\n    tblInvoices[Amount],\n    tblInvoices[Invoice Date], \">=\"&EOMONTH(L4,-1)+1,\n    tblInvoices[Invoice Date], \"<=\"&EOMONTH(L4,0)\n)","v":0}]
[null,null,null,"Paid This Month",{"$f":"SUMIFS(\n    tblPayments[Amount],\n    tblPayments[Payment Date], \">=\"&EOMONTH(TODAY(),-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH(TODAY(),0)\n)","v":650},null,"61–90",{"$f":"SUMIFS(tblInvoices[Balance],\n        tblInvoices[Days Overdue],\">=\"&I5,\n        tblInvoices[Days Overdue],\"<=\"&J5)","v":450},{"$f":"J4+1","v":61},90,null,{"$f":"EOMONTH(L4,1)","v":"2026-01-31"},{"$f":"SUMIFS(\n    tblPayments[Amount],\n    tblPayments[Payment Date], \">=\"&EOMONTH(L5,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH(L5,0)\n)","v":0},{"$f":"SUMIFS(\n    tblInvoices[Amount],\n    tblInvoices[Invoice Date], \">=\"&EOMONTH(L5,-1)+1,\n    tblInvoices[Invoice Date], \"<=\"&EOMONTH(L5,0)\n)","v":1050}]
[null,null,null,"Open Invoices",{"$f":"COUNTIFS(\n    tblInvoices[Balance], \">0\"\n)","v":6},null,"90+",{"$f":"SUMIFS(tblInvoices[Balance],\n        tblInvoices[Days Overdue],\">=\"&I6)","v":550},91,null,null,"2026-02-28",{"$f":"SUMIFS(\n    tblPayments[Amount],\n    tblPayments[Payment Date], \">=\"&EOMONTH(L6,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH(L6,0)\n)","v":0},{"$f":"SUMIFS(\n    tblInvoices[Amount],\n    tblInvoices[Invoice Date], \">=\"&EOMONTH(L6,-1)+1,\n    tblInvoices[Invoice Date], \"<=\"&EOMONTH(L6,0)\n)","v":1200}]
[null,null,null,"Late Invoices",{"$f":"COUNTIFS(\n    tblInvoices[Due Date], \"<\"&TODAY(),\n    tblInvoices[Balance], \">0\"\n)","v":5},null,null,null,null,null,null,"2026-03-31",{"$f":"SUMIFS(\n    tblPayments[Amount],\n    tblPayments[Payment Date], \">=\"&EOMONTH(L7,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH(L7,0)\n)","v":900},{"$f":"SUMIFS(\n    tblInvoices[Amount],\n    tblInvoices[Invoice Date], \">=\"&EOMONTH(L7,-1)+1,\n    tblInvoices[Invoice Date], \"<=\"&EOMONTH(L7,0)\n)","v":750}]
[null,null,null,null,null,null,null,null,null,null,null,"2026-04-30",{"$f":"SUMIFS(\n    tblPayments[Amount],\n    tblPayments[Payment Date], \">=\"&EOMONTH(L8,-1)+1,\n    tblPayments[Payment Date], \"<=\"&EOMONTH(L8,0)\n)","v":650},{"$f":"SUMIFS(\n    tblInvoices[Amount],\n    tblInvoices[Invoice Date], \">=\"&EOMONTH(L8,-1)+1,\n    tblInvoices[Invoice Date], \"<=\"&EOMONTH(L8,0)\n)","v":625}]