{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["FTD Verify"],"not_rendered":{"charts":0,"images":2,"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":"FTD Verify","index":0,"n_rows":32,"n_cols":30,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,24,3,26],[3,28,3,29],[0,0,0,1],[2,1,2,2],[2,3,2,12],[3,15,3,18],[3,21,3,22]]}
["Semi-Weekly"]
[]
[null,"Liability",null,"Deposit "]
["Quarter","Date","Amount","Due Date","Paid Date","Paid Amount","Quarterly","Monthly","SemiWeekly","Daily","Timeliness","Days Late","Accuracy","Difference",null,"Quarters",null,null,null,null,null,"Holidays",null,null,"Semi-Weekly Depositor",null,null,null,"Next Bus Day"]
[{"$f":"IF(OR(Table5[[#This Row],[Date]]=\"\",Table5[[#This Row],[Amount]]=\"\"),\"\",YEAR(Table5[[#This Row],[Date]])&\" \"&_xlfn.XLOOKUP(MONTH(B5),QtrTable[Month],QtrTable[Qtr.]))","v":""},null,null,{"$f":"IF(OR(Table5[[#This Row],[Date]]=\"\",Table5[[#This Row],[Amount]]=\"\"),\"\",IF(Table5[[#This Row],[Amount]]>99999.99,Table5[[#This Row],[Daily]],IF(AND(Table5[[#This Row],[Amount]]<100000,$A$1=\"Semi-Weekly\"),Table5[[#This Row],[SemiWeekly]],IF(AND(Table5[[#This Row],[Amount]]<100000,$A$1=\"Monthly\"),Table5[[#This Row],[Monthly]],IF(AND(Table5[[#This Row],[Amount]]<100000,$A$1=\"Quarterly\"),Table5[[#This Row],[Quarterly]])))))","v":""},null,null,{"$f":"_xlfn.XLOOKUP(MONTH(B5),QtrTable[[#All],[Month]],DATE(YEAR(Table5[[#This Row],[Date]]),MONTH(QtrTable[[#All],[Return Due]]),DAY(QtrTable[[#All],[Return Due]])))","v":"1900-04-30"},{"$f":"_xlfn.XLOOKUP(MONTH(B5),QtrTable[[#All],[Month]],QtrTable[[#All],[FTD Due]])","v":"2022-04-15"},{"$f":"_xlfn.XLOOKUP(MONTH(C5),QtrTable[[#All],[Month]],DATE(YEAR(Table5[[#This Row],[Date]]),MONTH(QtrTable[[#All],[FTD Due]]),DAY(QtrTable[[#All],[FTD Due]])))","v":"1900-04-15"},{"$f":"WORKDAY(Table5[[#This Row],[Date]],1,HolidayTable[Date])","v":"1900-01-02"},{"$f":"IF(OR(Table5[[#This Row],[Date]]=\"\",Table5[[#This Row],[Amount]]=\"\"),\"\",IF(Table5[[#This Row],[Due Date]]-Table5[[#This Row],[Paid Date]]>=0,\"Timely\",\"Late\"))","v":""},{"$f":"IF(Table5[[#This Row],[Paid Date]]>Table5[[#This Row],[Due Date]],Table5[[#This Row],[Paid Date]]-Table5[[#This Row],[Due Date]],\"\")","v":""},{"$f":"IF(OR(Table5[[#This Row],[Date]]=\"\",Table5[[#This Row],[Amount]]=\"\"),\"\",IF(Table5[[#This Row],[Amount]]<Table5[[#This Row],[Paid Amount]],\"Overpaid\",IF(Table5[[#This Row],[Amount]]>Table5[[#This Row],[Paid Amount]],\"Underpaid\",IF(Table5[[#This Row],[Amount]]=Table5[[#This Row],[Paid Amount]],\"Sufficient\"))))","v":""},{"$f":"IF(Table5[[#This Row],[Paid Amount]]<Table5[[#This Row],[Amount]],Table5[[#This Row],[Paid Amount]]-Table5[[#This Row],[Amount]],\"\")","v":""},null,"Month","Qtr.","Quarter End","FTD Due","Return Due",null,"Date","Holiday",null,"Payday","Deposit due n days later","Deposit due weekday",null,"Weekday","Add day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"1st","2022-03-31","2022-04-15","2022-04-30",null,"2022-01-01","New Year's Day",null,"1900-01-04",7,{"$f":"Y6+Z6","v":"1900-01-11"},null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"1st","2022-03-31","2022-04-15","2022-04-30",null,"2022-01-17","Martin Luther King Jr. Day",null,"1900-01-05",6,{"$f":"Y7+Z7","v":"1900-01-11"},null,2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"1st","2022-03-31","2022-04-15","2022-04-30",null,"2022-02-14","Valentine's Day",null,"1900-01-06",5,"1900-01-11",null,3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"2nd","2022-06-30","2022-07-15","2022-07-31",null,"2022-02-21","Presidents' Day",null,"1900-01-07",6,"1900-01-13",null,4,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"2nd","2022-06-30","2022-07-15","2022-07-31",null,"2022-03-17","St. Patrick's Day",null,"1900-01-01",5,"1900-01-06",null,5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"2nd","2022-06-30","2022-07-15","2022-07-31",null,"2022-04-17","Easter Sunday",null,"1900-01-02",4,"1900-01-06",null,6,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"3rd","2022-09-30","2022-10-15","2022-10-31",null,"2022-04-18","Easter Monday",null,"1900-01-03",3,"1900-01-06",null,7,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"3rd","2022-09-30","2022-10-15","2022-10-31",null,"2022-04-18","Tax Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"3rd","2022-09-30","2022-10-15","2022-10-31",null,"2022-05-05","Cinco de Mayo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"4th","2022-12-31","2022-01-15","2022-01-31",null,"2022-05-08","Mother's Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"4th","2022-12-31","2022-01-15","2022-01-31",null,"2022-05-30","Memorial Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"4th","2022-12-31","2022-01-15","2022-01-31",null,"2022-06-14","Flag Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-19","Father's Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-19","Juneteenth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-20","'Juneteenth' day off"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-07-04","Independence Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-09-05","Labor Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-10","Columbus Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-10-31","Halloween"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-08","Election Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-11","Veterans Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-24","Thanksgiving Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-11-25","Black Friday"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-24","Christmas Eve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-25","Christmas Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-26","'Christmas Day' day off"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-12-31","New Year's Eve"]