{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["STATEMENT","INVOICE DATA","CUSTOMER DATA"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"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":"STATEMENT","index":0,"n_rows":182,"n_cols":16,"rows_kept":182,"cut":false,"hidden":false,"merged":[[6,6,12,9],[5,6,5,9]]}
["Customer","Company D",null,null,null,null,null,null,null,null,null,-999999,"Current"]
[null,null,null,null,null,null,null,null,null,null,null,30,"30+",null,null,{"$f":"COUNTA('INVOICE DATA'!A:A)","v":5}]
[null,null,null,null,null,null,"Customer Email",null,null,"test@domain.com",null,60,"60+",null,null,{"$f":"SUM(IF(LEN(A1:A200)>1,1,0))","v":14}]
["Company Name",null,null,null,"STATEMENT",null,"Folder to Save Statements to",null,null,"C:\\",null,90,"90+"]
["Address",null,null,null,{"$f":"UPPER(TEXT(TODAY(),\"MMM DD YYYY\"))","v":"DEC 24 2019"}]
["Address 2",null,null,null,null,null,"Customer Message"]
[null,null,null,null,null,null,"Please see attached for your statement"]
[]
[{"$f":"B1","v":"Company D"}]
[{"$f":"VLOOKUP($B$1,'CUSTOMER DATA'!A:F,2,FALSE)","v":"Address Line 1"}]
[{"$f":"IF(VLOOKUP($B$1,'CUSTOMER DATA'!A:F,3,FALSE)=0,(VLOOKUP($B$1,'CUSTOMER DATA'!A:F,4,FALSE)&\", \"&VLOOKUP($B$1,'CUSTOMER DATA'!A:F,5,FALSE)&\" \"&VLOOKUP($B$1,'CUSTOMER DATA'!A:F,6,FALSE)),VLOOKUP($B$1,'CUSTOMER DATA'!A:F,3,FALSE))","v":"City, Province POSTAL CODE"}]
[{"$f":"IF(VLOOKUP($B$1,'CUSTOMER DATA'!A:F,3,FALSE)<>0,(VLOOKUP($B$1,'CUSTOMER DATA'!A:F,4,FALSE)&\", \"&VLOOKUP($B$1,'CUSTOMER DATA'!A:F,5,FALSE)&\" \"&VLOOKUP($B$1,'CUSTOMER DATA'!A:F,6,FALSE)),\"\")","v":""}]
[]
["Invoice #","Due Date","Days Past Due","Aging Category","Amount"]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A1)),1),\"\")","v":126},{"$f":"IF(A15=\"\",\"\",VLOOKUP($A15,'INVOICE DATA'!$A:$D,2,FALSE))","v":"2017-05-01"},{"$f":"IF(A15=\"\",\"\",TODAY()-B15)","v":967},{"$f":"IF(A15=\"\",\"\",VLOOKUP(C15,AgingTable,2))","v":"90+"},{"$f":"IF(A15=\"\",\"\",VLOOKUP($A15,'INVOICE DATA'!$A:$D,3,FALSE))","v":40}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A2)),1),\"\")","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP($A16,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A16=\"\",\"\",VLOOKUP($A16,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A3)),1),\"\")","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP($A17,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},{"$f":"IF(A17=\"\",\"\",TODAY()-B17)","v":""},"",{"$f":"IF(A17=\"\",\"\",VLOOKUP($A17,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A4)),1),\"\")","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP($A18,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A18=\"\",\"\",VLOOKUP($A18,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A5)),1),\"\")","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP($A19,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A19=\"\",\"\",VLOOKUP($A19,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A6)),1),\"\")","v":""},{"$f":"IF(A20=\"\",\"\",VLOOKUP($A20,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A20=\"\",\"\",VLOOKUP($A20,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A7)),1),\"\")","v":""},{"$f":"IF(A21=\"\",\"\",VLOOKUP($A21,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A21=\"\",\"\",VLOOKUP($A21,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A8)),1),\"\")","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP($A22,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A22=\"\",\"\",VLOOKUP($A22,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A9)),1),\"\")","v":""},{"$f":"IF(A23=\"\",\"\",VLOOKUP($A23,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A23=\"\",\"\",VLOOKUP($A23,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A10)),1),\"\")","v":""},{"$f":"IF(A24=\"\",\"\",VLOOKUP($A24,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A24=\"\",\"\",VLOOKUP($A24,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A11)),1),\"\")","v":""},{"$f":"IF(A25=\"\",\"\",VLOOKUP($A25,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A25=\"\",\"\",VLOOKUP($A25,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A12)),1),\"\")","v":""},{"$f":"IF(A26=\"\",\"\",VLOOKUP($A26,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A26=\"\",\"\",VLOOKUP($A26,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A13)),1),\"\")","v":""},{"$f":"IF(A27=\"\",\"\",VLOOKUP($A27,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A27=\"\",\"\",VLOOKUP($A27,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A14)),1),\"\")","v":""},{"$f":"IF(A28=\"\",\"\",VLOOKUP($A28,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A28=\"\",\"\",VLOOKUP($A28,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A15)),1),\"\")","v":""},{"$f":"IF(A29=\"\",\"\",VLOOKUP($A29,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},{"$f":"IF(A29=\"\",\"\",TODAY()-B29)","v":""},{"$f":"IF(A29=\"\",\"\",VLOOKUP(C29,AgingTable,2))","v":""},{"$f":"IF(A29=\"\",\"\",VLOOKUP($A29,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A16)),1),\"\")","v":""},{"$f":"IF(A30=\"\",\"\",VLOOKUP($A30,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A30=\"\",\"\",VLOOKUP($A30,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A17)),1),\"\")","v":""},{"$f":"IF(A31=\"\",\"\",VLOOKUP($A31,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A31=\"\",\"\",VLOOKUP($A31,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A18)),1),\"\")","v":""},{"$f":"IF(A32=\"\",\"\",VLOOKUP($A32,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A32=\"\",\"\",VLOOKUP($A32,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A19)),1),\"\")","v":""},{"$f":"IF(A33=\"\",\"\",VLOOKUP($A33,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A33=\"\",\"\",VLOOKUP($A33,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A20)),1),\"\")","v":""},{"$f":"IF(A34=\"\",\"\",VLOOKUP($A34,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A34=\"\",\"\",VLOOKUP($A34,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A21)),1),\"\")","v":""},{"$f":"IF(A35=\"\",\"\",VLOOKUP($A35,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A35=\"\",\"\",VLOOKUP($A35,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A22)),1),\"\")","v":""},{"$f":"IF(A36=\"\",\"\",VLOOKUP($A36,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A36=\"\",\"\",VLOOKUP($A36,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A23)),1),\"\")","v":""},{"$f":"IF(A37=\"\",\"\",VLOOKUP($A37,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A37=\"\",\"\",VLOOKUP($A37,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A24)),1),\"\")","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP($A38,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},{"$f":"IF(A38=\"\",\"\",TODAY()-B38)","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP(C38,AgingTable,2))","v":""},{"$f":"IF(A38=\"\",\"\",VLOOKUP($A38,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A25)),1),\"\")","v":""},{"$f":"IF(A39=\"\",\"\",VLOOKUP($A39,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A39=\"\",\"\",VLOOKUP($A39,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A26)),1),\"\")","v":""},{"$f":"IF(A40=\"\",\"\",VLOOKUP($A40,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A40=\"\",\"\",VLOOKUP($A40,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A27)),1),\"\")","v":""},{"$f":"IF(A41=\"\",\"\",VLOOKUP($A41,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A41=\"\",\"\",VLOOKUP($A41,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A28)),1),\"\")","v":""},{"$f":"IF(A42=\"\",\"\",VLOOKUP($A42,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A42=\"\",\"\",VLOOKUP($A42,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A29)),1),\"\")","v":""},{"$f":"IF(A43=\"\",\"\",VLOOKUP($A43,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A43=\"\",\"\",VLOOKUP($A43,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A30)),1),\"\")","v":""},{"$f":"IF(A44=\"\",\"\",VLOOKUP($A44,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A44=\"\",\"\",VLOOKUP($A44,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
["Current","30+","60+","90+","Total"]
[{"$f":"SUMIF($D15:$D44,A$45,$E15:$E44)+SUMIF($D49:$D78,A$45,$E49:$E78)+SUMIF($D83:$D112,A$45,$E83:$E112)+SUMIF($D117:$D146,A$45,$E117:$E146)+SUMIF($D151:$D180,A$45,$E151:$E180)","v":0},{"$f":"SUMIF($D15:$D44,B$45,$E15:$E44)+SUMIF($D49:$D78,B$45,$E49:$E78)+SUMIF($D83:$D112,B$45,$E83:$E112)+SUMIF($D117:$D146,B$45,$E117:$E146)+SUMIF($D151:$D180,B$45,$E151:$E180)","v":0},{"$f":"SUMIF($D15:$D44,C$45,$E15:$E44)+SUMIF($D49:$D78,C$45,$E49:$E78)+SUMIF($D83:$D112,C$45,$E83:$E112)+SUMIF($D117:$D146,C$45,$E117:$E146)+SUMIF($D151:$D180,C$45,$E151:$E180)","v":0},{"$f":"SUMIF($D15:$D44,D$45,$E15:$E44)+SUMIF($D49:$D78,D$45,$E49:$E78)+SUMIF($D83:$D112,D$45,$E83:$E112)+SUMIF($D117:$D146,D$45,$E117:$E146)+SUMIF($D151:$D180,D$45,$E151:$E180)","v":40},{"$f":"SUM(A46:D46)","v":40}]
[]
[]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A31)),1),\"\")","v":""},{"$f":"IF(A49=\"\",\"\",VLOOKUP($A49,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},{"$f":"IF(A49=\"\",\"\",TODAY()-B49)","v":""},{"$f":"IF(A49=\"\",\"\",VLOOKUP(C49,AgingTable,2))","v":""},{"$f":"IF(A49=\"\",\"\",VLOOKUP($A49,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A32)),1),\"\")","v":""},{"$f":"IF(A50=\"\",\"\",VLOOKUP($A50,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A50=\"\",\"\",VLOOKUP($A50,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A33)),1),\"\")","v":""},{"$f":"IF(A51=\"\",\"\",VLOOKUP($A51,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A51=\"\",\"\",VLOOKUP($A51,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A34)),1),\"\")","v":""},{"$f":"IF(A52=\"\",\"\",VLOOKUP($A52,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A52=\"\",\"\",VLOOKUP($A52,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A35)),1),\"\")","v":""},{"$f":"IF(A53=\"\",\"\",VLOOKUP($A53,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A53=\"\",\"\",VLOOKUP($A53,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A36)),1),\"\")","v":""},{"$f":"IF(A54=\"\",\"\",VLOOKUP($A54,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A54=\"\",\"\",VLOOKUP($A54,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A37)),1),\"\")","v":""},{"$f":"IF(A55=\"\",\"\",VLOOKUP($A55,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A55=\"\",\"\",VLOOKUP($A55,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A38)),1),\"\")","v":""},{"$f":"IF(A56=\"\",\"\",VLOOKUP($A56,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A56=\"\",\"\",VLOOKUP($A56,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A39)),1),\"\")","v":""},{"$f":"IF(A57=\"\",\"\",VLOOKUP($A57,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A57=\"\",\"\",VLOOKUP($A57,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A40)),1),\"\")","v":""},{"$f":"IF(A58=\"\",\"\",VLOOKUP($A58,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A58=\"\",\"\",VLOOKUP($A58,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A41)),1),\"\")","v":""},{"$f":"IF(A59=\"\",\"\",VLOOKUP($A59,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A59=\"\",\"\",VLOOKUP($A59,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A42)),1),\"\")","v":""},{"$f":"IF(A60=\"\",\"\",VLOOKUP($A60,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A60=\"\",\"\",VLOOKUP($A60,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A43)),1),\"\")","v":""},{"$f":"IF(A61=\"\",\"\",VLOOKUP($A61,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A61=\"\",\"\",VLOOKUP($A61,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A44)),1),\"\")","v":""},{"$f":"IF(A62=\"\",\"\",VLOOKUP($A62,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A62=\"\",\"\",VLOOKUP($A62,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A45)),1),\"\")","v":""},{"$f":"IF(A63=\"\",\"\",VLOOKUP($A63,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A63=\"\",\"\",VLOOKUP($A63,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A46)),1),\"\")","v":""},{"$f":"IF(A64=\"\",\"\",VLOOKUP($A64,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A64=\"\",\"\",VLOOKUP($A64,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A47)),1),\"\")","v":""},{"$f":"IF(A65=\"\",\"\",VLOOKUP($A65,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A65=\"\",\"\",VLOOKUP($A65,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A48)),1),\"\")","v":""},{"$f":"IF(A66=\"\",\"\",VLOOKUP($A66,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A66=\"\",\"\",VLOOKUP($A66,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A49)),1),\"\")","v":""},{"$f":"IF(A67=\"\",\"\",VLOOKUP($A67,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A67=\"\",\"\",VLOOKUP($A67,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A50)),1),\"\")","v":""},{"$f":"IF(A68=\"\",\"\",VLOOKUP($A68,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A68=\"\",\"\",VLOOKUP($A68,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A51)),1),\"\")","v":""},{"$f":"IF(A69=\"\",\"\",VLOOKUP($A69,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A69=\"\",\"\",VLOOKUP($A69,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A52)),1),\"\")","v":""},{"$f":"IF(A70=\"\",\"\",VLOOKUP($A70,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A70=\"\",\"\",VLOOKUP($A70,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A53)),1),\"\")","v":""},{"$f":"IF(A71=\"\",\"\",VLOOKUP($A71,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A71=\"\",\"\",VLOOKUP($A71,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A54)),1),\"\")","v":""},{"$f":"IF(A72=\"\",\"\",VLOOKUP($A72,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A72=\"\",\"\",VLOOKUP($A72,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A55)),1),\"\")","v":""},{"$f":"IF(A73=\"\",\"\",VLOOKUP($A73,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A73=\"\",\"\",VLOOKUP($A73,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A56)),1),\"\")","v":""},{"$f":"IF(A74=\"\",\"\",VLOOKUP($A74,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A74=\"\",\"\",VLOOKUP($A74,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A57)),1),\"\")","v":""},{"$f":"IF(A75=\"\",\"\",VLOOKUP($A75,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A75=\"\",\"\",VLOOKUP($A75,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A58)),1),\"\")","v":""},{"$f":"IF(A76=\"\",\"\",VLOOKUP($A76,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},{"$f":"IF(A76=\"\",\"\",TODAY()-B76)","v":""},{"$f":"IF(A76=\"\",\"\",VLOOKUP(C76,AgingTable,2))","v":""},{"$f":"IF(A76=\"\",\"\",VLOOKUP($A76,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A59)),1),\"\")","v":""},{"$f":"IF(A77=\"\",\"\",VLOOKUP($A77,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A77=\"\",\"\",VLOOKUP($A77,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A60)),1),\"\")","v":""},{"$f":"IF(A78=\"\",\"\",VLOOKUP($A78,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A78=\"\",\"\",VLOOKUP($A78,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
["Current","30+","60+","90+","Total"]
[{"$f":"SUMIF($D15:$D44,A$45,$E15:$E44)+SUMIF($D49:$D78,A$45,$E49:$E78)+SUMIF($D83:$D112,A$45,$E83:$E112)+SUMIF($D117:$D146,A$45,$E117:$E146)+SUMIF($D151:$D180,A$45,$E151:$E180)","v":0},0,0,40,{"$f":"SUM(A80:D80)","v":40}]
[]
[]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A61)),1),\"\")","v":""},{"$f":"IF(A83=\"\",\"\",VLOOKUP($A83,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},{"$f":"IF(A83=\"\",\"\",TODAY()-B83)","v":""},{"$f":"IF(A83=\"\",\"\",VLOOKUP(C83,AgingTable,2))","v":""},{"$f":"IF(A83=\"\",\"\",VLOOKUP($A83,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A62)),1),\"\")","v":""},{"$f":"IF(A84=\"\",\"\",VLOOKUP($A84,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A84=\"\",\"\",VLOOKUP($A84,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A63)),1),\"\")","v":""},{"$f":"IF(A85=\"\",\"\",VLOOKUP($A85,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A85=\"\",\"\",VLOOKUP($A85,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A64)),1),\"\")","v":""},{"$f":"IF(A86=\"\",\"\",VLOOKUP($A86,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A86=\"\",\"\",VLOOKUP($A86,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A65)),1),\"\")","v":""},{"$f":"IF(A87=\"\",\"\",VLOOKUP($A87,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A87=\"\",\"\",VLOOKUP($A87,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A66)),1),\"\")","v":""},{"$f":"IF(A88=\"\",\"\",VLOOKUP($A88,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A88=\"\",\"\",VLOOKUP($A88,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A67)),1),\"\")","v":""},{"$f":"IF(A89=\"\",\"\",VLOOKUP($A89,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A89=\"\",\"\",VLOOKUP($A89,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A68)),1),\"\")","v":""},{"$f":"IF(A90=\"\",\"\",VLOOKUP($A90,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A90=\"\",\"\",VLOOKUP($A90,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A69)),1),\"\")","v":""},{"$f":"IF(A91=\"\",\"\",VLOOKUP($A91,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A91=\"\",\"\",VLOOKUP($A91,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A70)),1),\"\")","v":""},{"$f":"IF(A92=\"\",\"\",VLOOKUP($A92,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A92=\"\",\"\",VLOOKUP($A92,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A71)),1),\"\")","v":""},{"$f":"IF(A93=\"\",\"\",VLOOKUP($A93,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A93=\"\",\"\",VLOOKUP($A93,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A72)),1),\"\")","v":""},{"$f":"IF(A94=\"\",\"\",VLOOKUP($A94,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A94=\"\",\"\",VLOOKUP($A94,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A73)),1),\"\")","v":""},{"$f":"IF(A95=\"\",\"\",VLOOKUP($A95,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A95=\"\",\"\",VLOOKUP($A95,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A74)),1),\"\")","v":""},{"$f":"IF(A96=\"\",\"\",VLOOKUP($A96,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A96=\"\",\"\",VLOOKUP($A96,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A75)),1),\"\")","v":""},{"$f":"IF(A97=\"\",\"\",VLOOKUP($A97,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A97=\"\",\"\",VLOOKUP($A97,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A76)),1),\"\")","v":""},{"$f":"IF(A98=\"\",\"\",VLOOKUP($A98,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A98=\"\",\"\",VLOOKUP($A98,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A77)),1),\"\")","v":""},{"$f":"IF(A99=\"\",\"\",VLOOKUP($A99,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A99=\"\",\"\",VLOOKUP($A99,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A78)),1),\"\")","v":""},{"$f":"IF(A100=\"\",\"\",VLOOKUP($A100,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A100=\"\",\"\",VLOOKUP($A100,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A79)),1),\"\")","v":""},{"$f":"IF(A101=\"\",\"\",VLOOKUP($A101,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A101=\"\",\"\",VLOOKUP($A101,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A80)),1),\"\")","v":""},{"$f":"IF(A102=\"\",\"\",VLOOKUP($A102,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A102=\"\",\"\",VLOOKUP($A102,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A81)),1),\"\")","v":""},{"$f":"IF(A103=\"\",\"\",VLOOKUP($A103,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A103=\"\",\"\",VLOOKUP($A103,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A82)),1),\"\")","v":""},{"$f":"IF(A104=\"\",\"\",VLOOKUP($A104,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A104=\"\",\"\",VLOOKUP($A104,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A83)),1),\"\")","v":""},{"$f":"IF(A105=\"\",\"\",VLOOKUP($A105,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A105=\"\",\"\",VLOOKUP($A105,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A84)),1),\"\")","v":""},{"$f":"IF(A106=\"\",\"\",VLOOKUP($A106,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A106=\"\",\"\",VLOOKUP($A106,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A85)),1),\"\")","v":""},{"$f":"IF(A107=\"\",\"\",VLOOKUP($A107,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A107=\"\",\"\",VLOOKUP($A107,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A86)),1),\"\")","v":""},{"$f":"IF(A108=\"\",\"\",VLOOKUP($A108,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A108=\"\",\"\",VLOOKUP($A108,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A87)),1),\"\")","v":""},{"$f":"IF(A109=\"\",\"\",VLOOKUP($A109,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A109=\"\",\"\",VLOOKUP($A109,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A88)),1),\"\")","v":""},{"$f":"IF(A110=\"\",\"\",VLOOKUP($A110,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A110=\"\",\"\",VLOOKUP($A110,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A89)),1),\"\")","v":""},{"$f":"IF(A111=\"\",\"\",VLOOKUP($A111,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A111=\"\",\"\",VLOOKUP($A111,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A90)),1),\"\")","v":""},{"$f":"IF(A112=\"\",\"\",VLOOKUP($A112,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A112=\"\",\"\",VLOOKUP($A112,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
["Current","30+","60+","90+","Total"]
[{"$f":"SUMIF($D15:$D44,A$45,$E15:$E44)+SUMIF($D49:$D78,A$45,$E49:$E78)+SUMIF($D83:$D112,A$45,$E83:$E112)+SUMIF($D117:$D146,A$45,$E117:$E146)+SUMIF($D151:$D180,A$45,$E151:$E180)","v":0},0,0,40,{"$f":"SUM(A114:D114)","v":40}]
[]
[]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A91)),1),\"\")","v":""},{"$f":"IF(A117=\"\",\"\",VLOOKUP($A117,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},{"$f":"IF(A117=\"\",\"\",TODAY()-B117)","v":""},{"$f":"IF(A117=\"\",\"\",VLOOKUP(C117,AgingTable,2))","v":""},{"$f":"IF(A117=\"\",\"\",VLOOKUP($A117,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A92)),1),\"\")","v":""},{"$f":"IF(A118=\"\",\"\",VLOOKUP($A118,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A118=\"\",\"\",VLOOKUP($A118,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A93)),1),\"\")","v":""},{"$f":"IF(A119=\"\",\"\",VLOOKUP($A119,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A119=\"\",\"\",VLOOKUP($A119,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A94)),1),\"\")","v":""},{"$f":"IF(A120=\"\",\"\",VLOOKUP($A120,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A120=\"\",\"\",VLOOKUP($A120,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A95)),1),\"\")","v":""},{"$f":"IF(A121=\"\",\"\",VLOOKUP($A121,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A121=\"\",\"\",VLOOKUP($A121,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A96)),1),\"\")","v":""},{"$f":"IF(A122=\"\",\"\",VLOOKUP($A122,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A122=\"\",\"\",VLOOKUP($A122,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A97)),1),\"\")","v":""},{"$f":"IF(A123=\"\",\"\",VLOOKUP($A123,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A123=\"\",\"\",VLOOKUP($A123,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A98)),1),\"\")","v":""},{"$f":"IF(A124=\"\",\"\",VLOOKUP($A124,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A124=\"\",\"\",VLOOKUP($A124,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A99)),1),\"\")","v":""},{"$f":"IF(A125=\"\",\"\",VLOOKUP($A125,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A125=\"\",\"\",VLOOKUP($A125,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A100)),1),\"\")","v":""},{"$f":"IF(A126=\"\",\"\",VLOOKUP($A126,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A126=\"\",\"\",VLOOKUP($A126,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A101)),1),\"\")","v":""},{"$f":"IF(A127=\"\",\"\",VLOOKUP($A127,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A127=\"\",\"\",VLOOKUP($A127,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A102)),1),\"\")","v":""},{"$f":"IF(A128=\"\",\"\",VLOOKUP($A128,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A128=\"\",\"\",VLOOKUP($A128,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A103)),1),\"\")","v":""},{"$f":"IF(A129=\"\",\"\",VLOOKUP($A129,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A129=\"\",\"\",VLOOKUP($A129,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A104)),1),\"\")","v":""},{"$f":"IF(A130=\"\",\"\",VLOOKUP($A130,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A130=\"\",\"\",VLOOKUP($A130,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A105)),1),\"\")","v":""},{"$f":"IF(A131=\"\",\"\",VLOOKUP($A131,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A131=\"\",\"\",VLOOKUP($A131,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A106)),1),\"\")","v":""},{"$f":"IF(A132=\"\",\"\",VLOOKUP($A132,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A132=\"\",\"\",VLOOKUP($A132,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A107)),1),\"\")","v":""},{"$f":"IF(A133=\"\",\"\",VLOOKUP($A133,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A133=\"\",\"\",VLOOKUP($A133,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A108)),1),\"\")","v":""},{"$f":"IF(A134=\"\",\"\",VLOOKUP($A134,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A134=\"\",\"\",VLOOKUP($A134,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A109)),1),\"\")","v":""},{"$f":"IF(A135=\"\",\"\",VLOOKUP($A135,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A135=\"\",\"\",VLOOKUP($A135,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A110)),1),\"\")","v":""},{"$f":"IF(A136=\"\",\"\",VLOOKUP($A136,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A136=\"\",\"\",VLOOKUP($A136,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A111)),1),\"\")","v":""},{"$f":"IF(A137=\"\",\"\",VLOOKUP($A137,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A137=\"\",\"\",VLOOKUP($A137,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A112)),1),\"\")","v":""},{"$f":"IF(A138=\"\",\"\",VLOOKUP($A138,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A138=\"\",\"\",VLOOKUP($A138,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A113)),1),\"\")","v":""},{"$f":"IF(A139=\"\",\"\",VLOOKUP($A139,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A139=\"\",\"\",VLOOKUP($A139,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A114)),1),\"\")","v":""},{"$f":"IF(A140=\"\",\"\",VLOOKUP($A140,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A140=\"\",\"\",VLOOKUP($A140,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A115)),1),\"\")","v":""},{"$f":"IF(A141=\"\",\"\",VLOOKUP($A141,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A141=\"\",\"\",VLOOKUP($A141,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A116)),1),\"\")","v":""},{"$f":"IF(A142=\"\",\"\",VLOOKUP($A142,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A142=\"\",\"\",VLOOKUP($A142,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A117)),1),\"\")","v":""},{"$f":"IF(A143=\"\",\"\",VLOOKUP($A143,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A143=\"\",\"\",VLOOKUP($A143,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A118)),1),\"\")","v":""},{"$f":"IF(A144=\"\",\"\",VLOOKUP($A144,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A144=\"\",\"\",VLOOKUP($A144,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A119)),1),\"\")","v":""},{"$f":"IF(A145=\"\",\"\",VLOOKUP($A145,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A145=\"\",\"\",VLOOKUP($A145,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A120)),1),\"\")","v":""},{"$f":"IF(A146=\"\",\"\",VLOOKUP($A146,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A146=\"\",\"\",VLOOKUP($A146,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
["Current","30+","60+","90+","Total"]
[{"$f":"SUMIF($D15:$D44,A$45,$E15:$E44)+SUMIF($D49:$D78,A$45,$E49:$E78)+SUMIF($D83:$D112,A$45,$E83:$E112)+SUMIF($D117:$D146,A$45,$E117:$E146)+SUMIF($D151:$D180,A$45,$E151:$E180)","v":0},0,0,40,{"$f":"SUM(A148:D148)","v":40}]
[]
[]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A121)),1),\"\")","v":""},{"$f":"IF(A151=\"\",\"\",VLOOKUP($A151,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},{"$f":"IF(A151=\"\",\"\",TODAY()-B151)","v":""},{"$f":"IF(A151=\"\",\"\",VLOOKUP(C151,AgingTable,2))","v":""},{"$f":"IF(A151=\"\",\"\",VLOOKUP($A151,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A122)),1),\"\")","v":""},{"$f":"IF(A152=\"\",\"\",VLOOKUP($A152,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A152=\"\",\"\",VLOOKUP($A152,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A123)),1),\"\")","v":""},{"$f":"IF(A153=\"\",\"\",VLOOKUP($A153,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A153=\"\",\"\",VLOOKUP($A153,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A124)),1),\"\")","v":""},{"$f":"IF(A154=\"\",\"\",VLOOKUP($A154,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A154=\"\",\"\",VLOOKUP($A154,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A125)),1),\"\")","v":""},{"$f":"IF(A155=\"\",\"\",VLOOKUP($A155,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A155=\"\",\"\",VLOOKUP($A155,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A126)),1),\"\")","v":""},{"$f":"IF(A156=\"\",\"\",VLOOKUP($A156,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A156=\"\",\"\",VLOOKUP($A156,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A127)),1),\"\")","v":""},{"$f":"IF(A157=\"\",\"\",VLOOKUP($A157,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A157=\"\",\"\",VLOOKUP($A157,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A128)),1),\"\")","v":""},{"$f":"IF(A158=\"\",\"\",VLOOKUP($A158,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A158=\"\",\"\",VLOOKUP($A158,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A129)),1),\"\")","v":""},{"$f":"IF(A159=\"\",\"\",VLOOKUP($A159,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A159=\"\",\"\",VLOOKUP($A159,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A130)),1),\"\")","v":""},{"$f":"IF(A160=\"\",\"\",VLOOKUP($A160,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A160=\"\",\"\",VLOOKUP($A160,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A131)),1),\"\")","v":""},{"$f":"IF(A161=\"\",\"\",VLOOKUP($A161,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A161=\"\",\"\",VLOOKUP($A161,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A132)),1),\"\")","v":""},{"$f":"IF(A162=\"\",\"\",VLOOKUP($A162,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A162=\"\",\"\",VLOOKUP($A162,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A133)),1),\"\")","v":""},{"$f":"IF(A163=\"\",\"\",VLOOKUP($A163,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A163=\"\",\"\",VLOOKUP($A163,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A134)),1),\"\")","v":""},{"$f":"IF(A164=\"\",\"\",VLOOKUP($A164,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A164=\"\",\"\",VLOOKUP($A164,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A135)),1),\"\")","v":""},{"$f":"IF(A165=\"\",\"\",VLOOKUP($A165,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A165=\"\",\"\",VLOOKUP($A165,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A136)),1),\"\")","v":""},{"$f":"IF(A166=\"\",\"\",VLOOKUP($A166,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A166=\"\",\"\",VLOOKUP($A166,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A137)),1),\"\")","v":""},{"$f":"IF(A167=\"\",\"\",VLOOKUP($A167,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A167=\"\",\"\",VLOOKUP($A167,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A138)),1),\"\")","v":""},{"$f":"IF(A168=\"\",\"\",VLOOKUP($A168,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A168=\"\",\"\",VLOOKUP($A168,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A139)),1),\"\")","v":""},{"$f":"IF(A169=\"\",\"\",VLOOKUP($A169,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A169=\"\",\"\",VLOOKUP($A169,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A140)),1),\"\")","v":""},{"$f":"IF(A170=\"\",\"\",VLOOKUP($A170,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A170=\"\",\"\",VLOOKUP($A170,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A141)),1),\"\")","v":""},{"$f":"IF(A171=\"\",\"\",VLOOKUP($A171,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A171=\"\",\"\",VLOOKUP($A171,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A142)),1),\"\")","v":""},{"$f":"IF(A172=\"\",\"\",VLOOKUP($A172,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A172=\"\",\"\",VLOOKUP($A172,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A143)),1),\"\")","v":""},{"$f":"IF(A173=\"\",\"\",VLOOKUP($A173,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A173=\"\",\"\",VLOOKUP($A173,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A144)),1),\"\")","v":""},{"$f":"IF(A174=\"\",\"\",VLOOKUP($A174,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A174=\"\",\"\",VLOOKUP($A174,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A145)),1),\"\")","v":""},{"$f":"IF(A175=\"\",\"\",VLOOKUP($A175,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A175=\"\",\"\",VLOOKUP($A175,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A146)),1),\"\")","v":""},{"$f":"IF(A176=\"\",\"\",VLOOKUP($A176,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A176=\"\",\"\",VLOOKUP($A176,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A147)),1),\"\")","v":""},{"$f":"IF(A177=\"\",\"\",VLOOKUP($A177,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A177=\"\",\"\",VLOOKUP($A177,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A148)),1),\"\")","v":""},{"$f":"IF(A178=\"\",\"\",VLOOKUP($A178,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A178=\"\",\"\",VLOOKUP($A178,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A149)),1),\"\")","v":""},{"$f":"IF(A179=\"\",\"\",VLOOKUP($A179,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A179=\"\",\"\",VLOOKUP($A179,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
[{"$f":"IFERROR(INDEX(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount),SMALL(IF((--(INDIRECT(\"'INVOICE DATA'!$D$1:$D$\"&invoicecount)=STATEMENT!$B$1)),ROW(INDIRECT(\"'INVOICE DATA'!$A$1:$A$\"&invoicecount)),\"\"),ROW(A150)),1),\"\")","v":""},{"$f":"IF(A180=\"\",\"\",VLOOKUP($A180,'INVOICE DATA'!$A:$D,2,FALSE))","v":""},"","",{"$f":"IF(A180=\"\",\"\",VLOOKUP($A180,'INVOICE DATA'!$A:$D,3,FALSE))","v":""}]
["Current","30+","60+","90+","Total"]
[{"$f":"SUMIF($D15:$D44,A$45,$E15:$E44)+SUMIF($D49:$D78,A$45,$E49:$E78)+SUMIF($D83:$D112,A$45,$E83:$E112)+SUMIF($D117:$D146,A$45,$E117:$E146)+SUMIF($D151:$D180,A$45,$E151:$E180)","v":0},{"$f":"SUMIF($D15:$D44,B$45,$E15:$E44)+SUMIF($D49:$D78,B$45,$E49:$E78)+SUMIF($D83:$D112,B$45,$E83:$E112)+SUMIF($D117:$D146,B$45,$E117:$E146)+SUMIF($D151:$D180,B$45,$E151:$E180)","v":0},0,40,{"$f":"SUM(A182:D182)","v":40}]

{"sheet":"INVOICE DATA","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Invoice #","Date","Amount","Customer"]
[123,"2017-01-01",10,"Company A"]
[124,"2017-03-15",20,"Company B"]
[125,"2017-04-10",30,"Company A"]
[126,"2017-05-01",40,"Company D"]

{"sheet":"CUSTOMER DATA","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Customer","Address","Address Line 2","City","Province","Postal/Zip"]
["Company A","Address Line 1","Address Line 2","City","Province","POSTAL CODE"]
["Company B","Address Line 1",null,"City","Province","POSTAL CODE"]
["Company C","Address Line 1","Address Line 2","City","Province","POSTAL CODE"]
["Company D","Address Line 1",null,"City","Province","POSTAL CODE"]