{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["QuickBooks Desktop Export Tips","Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":136,"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":"QuickBooks Desktop Export Tips","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet1","index":1,"n_rows":50,"n_cols":49,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Adams, Bonnie J",null,"Anderson, Tammy B.",null,"Ashley, Richard H.",null,"Bach, Anna K",null,"Blair, Sherri L.",null,"Bobal, Amanda M",null,"Durbin, Bart T",null,"Erickson, Sue A",null,"Hopf, Sarah E",null,"Housman, Amy M",null,"Housman, Kimberly A",null,"Jackson, Lori A",null,"Kuban, Stephen R",null,"Ozee, Gabrielle D",null,"Ruff, Rochelle K",null,"Shull, Carla M",null,"Smith, Grace J",null,"Smith, Katie B",null,"Smith, Tammy M.",null,"Swanson, Ashley A",null,"Swanson, Pamela J.",null,"Zippel, Zachary E",null,"TOTAL"]
[null,null,null,null,"Head of Circulation",null,"Desk Clerk",null,"Director",null,"Page",null,"Desk Clerk",null,"Page",null,"Bookmobile Driver/Clerk",null,"Bookmobile Driver/Clerk",null,"Children's Librarian",null,"Desk Clerk",null,"Desk Clerk",null,"Desk Clerk",null,"Maintenance",null,"Page",null,"Head of Circulation",null,"Custodian",null,"Custodian",null,"Desk Clerk",null,"HR Coordinator",null,"Technical Services",null,"Adult/Teen Librarian",null,"Desk Clerk"]
[null,null,null,"Date of Hire","02/27/2006",null,"05/17/2017",null,"11/10/2009",null,"08/24/2017",null,"5/17/2017",null,"6/15/2015",null,"4/25/2011",null,"9/07/2004",null,"11/01/2012",null,"6/19/2012",null,"01/07/2015",null,"5/20/2017",null,"01/04/2005",null,"9/08/2014",null,"01/07/2015",null,"11/09/2015",null,"7/31/2017",null,"06/09/2015",null,"01/03/2001",null,"9/10/2014",null,"12/13/2005",null,"10/03/2012"]
[null,null,null,"Rate of Pay 1/1/17 - 6/30/17","15.40/hr",null,null,null,null,null,null,null,"10.35/hr",null,"9.02/hr",null,"13.33/hr",null,"13.33/hr",null,"16.07/hr",null,"10.35/hr",null,"10.35/hr",null,"10.35/hr",null,"15.34/hr",null,"9.02/hr",null,"13.50/hr",null,"9.60/hr",null,null,null,"10.35/hr",null,"17/00/hr",null,"16.00/hr",null,"18.64/hr",null,"10.35/hr"]
[null,null,null,"Rate of Pay 7/1/17 - 12/31/17",null,null,"10.35/hr",null,"66,000 salary",null,"8.25/hr",null,"$10.35/hr",null,"9.25/hr",null,"13.53/hr",null,"13.60/hr",null,"16.23/hr",null,"10.56/hr",null,"10.51/hr",null,"10.61/hr",null,"15.49/hr",null,"9.16/hr",null,"15.40/hr",null,null,null,"9.60/hr",null,null,null,"18.02/hr",null,"16.64/hr",null,"19.76/hr",null,"10.77/hr"]
["Employee Wages, Taxes and Adjustments"]
[null,null,"Gross Pay"]
[null,null,null,"Salary",0,null,0,null,50119.18,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E8:AU8),5)","v":50119.18}]
[null,null,null,"Sick Salary",0,null,0,null,3202.31,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E9:AU9),5)","v":3202.31}]
[null,null,null,"Vacation Salary",0,null,0,null,9216.92,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E10:AU10),5)","v":9216.92}]
[null,null,null,"BKKP",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E11:AU11),5)","v":0}]
[null,null,null,"Bonus",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E12:AU12),5)","v":0}]
[null,null,null,"Hourly Regular Rate",10083.15,null,5128.43,null,462,null,576.69000000000005,null,4015.81,null,4044.54,null,20616.37,null,24095.16,null,29461.83,null,12080.24,null,8823.27,null,7585.34,null,7583.18,null,6676.11,null,21542.53,null,1567.2,null,1689.6,null,3503.48,null,30898.38,null,31160.32,null,33474.720000000001,null,12917.41,null,{"$f":"ROUND(SUM(E13:AU13),5)","v":277985.76}]
[null,null,null,"Overtime",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E14:AU14),5)","v":0}]
[null,null,null,"Sick Hourly Rate",238.7,null,0,null,0,null,0,null,0,null,253.48,null,1422.68,null,199.96,null,375.17,null,114.27,null,0,null,0,null,231.45,null,0,null,296.45,null,57.6,null,0,null,124.2,null,982.43,null,0,null,503.88,null,136.22999999999999,null,{"$f":"ROUND(SUM(E15:AU15),5)","v":4936.5}]
[null,null,null,"Vacation Hourly Rate",2957.72,null,0,null,0,null,0,null,0,null,454.55,null,1037.55,null,2028.99,null,1487.91,null,126.72,null,680.91,null,322.05,null,369.51,null,36.08,null,1308.05,null,196.42,null,0,null,543.58000000000004,null,2179.4,null,672,null,3517.32,null,269.10000000000002,null,{"$f":"ROUND(SUM(E16:AU16),5)","v":18187.86}]
[null,null,"Total Gross Pay",null,{"$f":"ROUND(SUM(E7:E16),5)","v":13279.57},null,{"$f":"ROUND(SUM(G7:G16),5)","v":5128.43},null,{"$f":"ROUND(SUM(I7:I16),5)","v":63000.41},null,{"$f":"ROUND(SUM(K7:K16),5)","v":576.69000000000005},null,{"$f":"ROUND(SUM(M7:M16),5)","v":4015.81},null,{"$f":"ROUND(SUM(O7:O16),5)","v":4752.57},null,{"$f":"ROUND(SUM(Q7:Q16),5)","v":23076.6},null,{"$f":"ROUND(SUM(S7:S16),5)","v":26324.11},null,{"$f":"ROUND(SUM(U7:U16),5)","v":31324.91},null,{"$f":"ROUND(SUM(W7:W16),5)","v":12321.23},null,{"$f":"ROUND(SUM(Y7:Y16),5)","v":9504.18},null,{"$f":"ROUND(SUM(AA7:AA16),5)","v":7907.39},null,{"$f":"ROUND(SUM(AC7:AC16),5)","v":8184.14},null,{"$f":"ROUND(SUM(AE7:AE16),5)","v":6712.19},null,{"$f":"ROUND(SUM(AG7:AG16),5)","v":23147.03},null,{"$f":"ROUND(SUM(AI7:AI16),5)","v":1821.22},null,{"$f":"ROUND(SUM(AK7:AK16),5)","v":1689.6},null,{"$f":"ROUND(SUM(AM7:AM16),5)","v":4171.26},null,{"$f":"ROUND(SUM(AO7:AO16),5)","v":34060.21},null,{"$f":"ROUND(SUM(AQ7:AQ16),5)","v":31832.32},null,{"$f":"ROUND(SUM(AS7:AS16),5)","v":37495.919999999998},null,{"$f":"ROUND(SUM(AU7:AU16),5)","v":13322.74},null,{"$f":"ROUND(SUM(E17:AU17),5)","v":363648.53}]
[null,null,"Deductions from Gross Pay"]
[null,null,null,"AFLAC (pre-tax)",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,-566.28,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E19:AU19),5)","v":-566.28}]
[null,null,null,"Employee Paid Health Insurance",0,null,0,null,0,null,0,null,0,null,0,null,-925.2,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E20:AU20),5)","v":-925.2}]
[null,null,null,"IMRF-Employee Share",-597.62,null,0,null,-2835.07,null,0,null,0,null,0,null,-1038.43,null,-1184.5999999999999,null,-1409.68,null,0,null,0,null,0,null,0,null,0,null,-1041.6400000000001,null,0,null,0,null,0,null,-1532.78,null,-1432.45,null,-1687.32,null,-374.92,null,{"$f":"ROUND(SUM(E21:AU21),5)","v":-13134.51}]
[null,null,null,"IMRF Voluntary Additional Contr",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,-854.34,null,0,null,0,null,0,null,-121.62,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E22:AU22),5)","v":-975.96}]
[null,null,null,"Nationwide 457 Regular",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,-1000,null,0,null,0,null,0,null,-1050,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E23:AU23),5)","v":-2050}]
[null,null,"Total Deductions from Gross Pay",null,{"$f":"ROUND(SUM(E18:E23),5)","v":-597.62},null,{"$f":"ROUND(SUM(G18:G23),5)","v":0},null,{"$f":"ROUND(SUM(I18:I23),5)","v":-2835.07},null,{"$f":"ROUND(SUM(K18:K23),5)","v":0},null,{"$f":"ROUND(SUM(M18:M23),5)","v":0},null,{"$f":"ROUND(SUM(O18:O23),5)","v":0},null,{"$f":"ROUND(SUM(Q18:Q23),5)","v":-1963.63},null,{"$f":"ROUND(SUM(S18:S23),5)","v":-1184.5999999999999},null,{"$f":"ROUND(SUM(U18:U23),5)","v":-1409.68},null,{"$f":"ROUND(SUM(W18:W23),5)","v":0},null,{"$f":"ROUND(SUM(Y18:Y23),5)","v":0},null,{"$f":"ROUND(SUM(AA18:AA23),5)","v":0},null,{"$f":"ROUND(SUM(AC18:AC23),5)","v":0},null,{"$f":"ROUND(SUM(AE18:AE23),5)","v":0},null,{"$f":"ROUND(SUM(AG18:AG23),5)","v":-2895.98},null,{"$f":"ROUND(SUM(AI18:AI23),5)","v":0},null,{"$f":"ROUND(SUM(AK18:AK23),5)","v":0},null,{"$f":"ROUND(SUM(AM18:AM23),5)","v":0},null,{"$f":"ROUND(SUM(AO18:AO23),5)","v":-3270.68},null,{"$f":"ROUND(SUM(AQ18:AQ23),5)","v":-1432.45},null,{"$f":"ROUND(SUM(AS18:AS23),5)","v":-1687.32},null,{"$f":"ROUND(SUM(AU18:AU23),5)","v":-374.92},null,{"$f":"ROUND(SUM(E24:AU24),5)","v":-17651.95}]
[null,"Adjusted Gross Pay",null,null,{"$f":"ROUND(E17+E24,5)","v":12681.95},null,{"$f":"ROUND(G17+G24,5)","v":5128.43},null,{"$f":"ROUND(I17+I24,5)","v":60165.34},null,{"$f":"ROUND(K17+K24,5)","v":576.69000000000005},null,{"$f":"ROUND(M17+M24,5)","v":4015.81},null,{"$f":"ROUND(O17+O24,5)","v":4752.57},null,{"$f":"ROUND(Q17+Q24,5)","v":21112.97},null,{"$f":"ROUND(S17+S24,5)","v":25139.51},null,{"$f":"ROUND(U17+U24,5)","v":29915.23},null,{"$f":"ROUND(W17+W24,5)","v":12321.23},null,{"$f":"ROUND(Y17+Y24,5)","v":9504.18},null,{"$f":"ROUND(AA17+AA24,5)","v":7907.39},null,{"$f":"ROUND(AC17+AC24,5)","v":8184.14},null,{"$f":"ROUND(AE17+AE24,5)","v":6712.19},null,{"$f":"ROUND(AG17+AG24,5)","v":20251.05},null,{"$f":"ROUND(AI17+AI24,5)","v":1821.22},null,{"$f":"ROUND(AK17+AK24,5)","v":1689.6},null,{"$f":"ROUND(AM17+AM24,5)","v":4171.26},null,{"$f":"ROUND(AO17+AO24,5)","v":30789.53},null,{"$f":"ROUND(AQ17+AQ24,5)","v":30399.87},null,{"$f":"ROUND(AS17+AS24,5)","v":35808.6},null,{"$f":"ROUND(AU17+AU24,5)","v":12947.82},null,{"$f":"ROUND(SUM(E25:AU25),5)","v":345996.58}]
[null,"Taxes Withheld"]
[null,null,"Federal Withholding",null,-1459,null,-364,null,-10130,null,0,null,-1,null,-316,null,-2409,null,-2603,null,-1319,null,-600,null,-201,null,-7,null,0,null,-75,null,-370,null,0,null,0,null,-340,null,-1831,null,-3120,null,-4541,null,-1137,null,{"$f":"ROUND(SUM(E27:AU27),5)","v":-30823}]
[null,null,"Medicare Employee",null,-192.55,null,-74.36,null,-913.51,null,-8.36,null,-58.23,null,-68.91,null,-321.2,null,-381.7,null,-454.21,null,-178.66,null,-137.81,null,-114.66,null,-118.67,null,-97.33,null,-335.63,null,-26.41,null,-24.5,null,-60.48,null,-485.66,null,-461.57,null,-543.69000000000005,null,-193.18,null,{"$f":"ROUND(SUM(E28:AU28),5)","v":-5251.28}]
[null,null,"Social Security Employee",null,-823.33,null,-317.95999999999998,null,-3906.03,null,-35.75,null,-248.98,null,-294.66000000000003,null,-1373.39,null,-1632.09,null,-1942.14,null,-763.92,null,-589.26,null,-490.26,null,-507.42,null,-416.16,null,-1435.12,null,-112.92,null,-104.76,null,-258.62,null,-2076.62,null,-1973.6,null,-2324.75,null,-826.01,null,{"$f":"ROUND(SUM(E29:AU29),5)","v":-22453.75}]
[null,null,"IL - Withholding",null,-444.24,null,-230.25,null,-2452.4299999999998,null,-28.55,null,-182.47,null,-184.6,null,-981.16,null,-1059.98,null,-1077.9000000000001,null,-422.45,null,-404.79,null,-333.5,null,-252.88,null,-278.14999999999998,null,-643.33000000000004,null,-21.37,null,-38.79,null,-156.41999999999999,null,-1120.58,null,-1283.22,null,-1512.73,null,-542.76,null,{"$f":"ROUND(SUM(E30:AU30),5)","v":-13652.55}]
[null,null,"Medicare Employee Addl Tax",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E31:AU31),5)","v":0}]
[null,"Total Taxes Withheld",null,null,{"$f":"ROUND(SUM(E26:E31),5)","v":-2919.12},null,{"$f":"ROUND(SUM(G26:G31),5)","v":-986.57},null,{"$f":"ROUND(SUM(I26:I31),5)","v":-17401.97},null,{"$f":"ROUND(SUM(K26:K31),5)","v":-72.66},null,{"$f":"ROUND(SUM(M26:M31),5)","v":-490.68},null,{"$f":"ROUND(SUM(O26:O31),5)","v":-864.17},null,{"$f":"ROUND(SUM(Q26:Q31),5)","v":-5084.75},null,{"$f":"ROUND(SUM(S26:S31),5)","v":-5676.77},null,{"$f":"ROUND(SUM(U26:U31),5)","v":-4793.25},null,{"$f":"ROUND(SUM(W26:W31),5)","v":-1965.03},null,{"$f":"ROUND(SUM(Y26:Y31),5)","v":-1332.86},null,{"$f":"ROUND(SUM(AA26:AA31),5)","v":-945.42},null,{"$f":"ROUND(SUM(AC26:AC31),5)","v":-878.97},null,{"$f":"ROUND(SUM(AE26:AE31),5)","v":-866.64},null,{"$f":"ROUND(SUM(AG26:AG31),5)","v":-2784.08},null,{"$f":"ROUND(SUM(AI26:AI31),5)","v":-160.69999999999999},null,{"$f":"ROUND(SUM(AK26:AK31),5)","v":-168.05},null,{"$f":"ROUND(SUM(AM26:AM31),5)","v":-815.52},null,{"$f":"ROUND(SUM(AO26:AO31),5)","v":-5513.86},null,{"$f":"ROUND(SUM(AQ26:AQ31),5)","v":-6838.39},null,{"$f":"ROUND(SUM(AS26:AS31),5)","v":-8922.17},null,{"$f":"ROUND(SUM(AU26:AU31),5)","v":-2698.95},null,{"$f":"ROUND(SUM(E32:AU32),5)","v":-72180.58}]
[null,"Deductions from Net Pay"]
[null,null,"Life Insurance",null,0,null,0,null,-208,null,0,null,0,null,0,null,-200,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E34:AU34),5)","v":-408}]
[null,null,"Roth 457b Plan Emp.",null,0,null,0,null,-2375,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,-300,null,0,null,0,null,0,null,{"$f":"ROUND(SUM(E35:AU35),5)","v":-2675}]
[null,"Total Deductions from Net Pay",null,null,{"$f":"ROUND(SUM(E33:E35),5)","v":0},null,{"$f":"ROUND(SUM(G33:G35),5)","v":0},null,{"$f":"ROUND(SUM(I33:I35),5)","v":-2583},null,{"$f":"ROUND(SUM(K33:K35),5)","v":0},null,{"$f":"ROUND(SUM(M33:M35),5)","v":0},null,{"$f":"ROUND(SUM(O33:O35),5)","v":0},null,{"$f":"ROUND(SUM(Q33:Q35),5)","v":-200},null,{"$f":"ROUND(SUM(S33:S35),5)","v":0},null,{"$f":"ROUND(SUM(U33:U35),5)","v":0},null,{"$f":"ROUND(SUM(W33:W35),5)","v":0},null,{"$f":"ROUND(SUM(Y33:Y35),5)","v":0},null,{"$f":"ROUND(SUM(AA33:AA35),5)","v":0},null,{"$f":"ROUND(SUM(AC33:AC35),5)","v":0},null,{"$f":"ROUND(SUM(AE33:AE35),5)","v":0},null,{"$f":"ROUND(SUM(AG33:AG35),5)","v":0},null,{"$f":"ROUND(SUM(AI33:AI35),5)","v":0},null,{"$f":"ROUND(SUM(AK33:AK35),5)","v":0},null,{"$f":"ROUND(SUM(AM33:AM35),5)","v":0},null,{"$f":"ROUND(SUM(AO33:AO35),5)","v":-300},null,{"$f":"ROUND(SUM(AQ33:AQ35),5)","v":0},null,{"$f":"ROUND(SUM(AS33:AS35),5)","v":0},null,{"$f":"ROUND(SUM(AU33:AU35),5)","v":0},null,{"$f":"ROUND(SUM(E36:AU36),5)","v":-3083}]
["Net Pay",null,null,null,{"$f":"ROUND(E6+E25+E32+E36,5)","v":9762.83},null,{"$f":"ROUND(G6+G25+G32+G36,5)","v":4141.8599999999997},null,{"$f":"ROUND(I6+I25+I32+I36,5)","v":40180.370000000003},null,{"$f":"ROUND(K6+K25+K32+K36,5)","v":504.03},null,{"$f":"ROUND(M6+M25+M32+M36,5)","v":3525.13},null,{"$f":"ROUND(O6+O25+O32+O36,5)","v":3888.4},null,{"$f":"ROUND(Q6+Q25+Q32+Q36,5)","v":15828.22},null,{"$f":"ROUND(S6+S25+S32+S36,5)","v":19462.740000000002},null,{"$f":"ROUND(U6+U25+U32+U36,5)","v":25121.98},null,{"$f":"ROUND(W6+W25+W32+W36,5)","v":10356.200000000001},null,{"$f":"ROUND(Y6+Y25+Y32+Y36,5)","v":8171.32},null,{"$f":"ROUND(AA6+AA25+AA32+AA36,5)","v":6961.97},null,{"$f":"ROUND(AC6+AC25+AC32+AC36,5)","v":7305.17},null,{"$f":"ROUND(AE6+AE25+AE32+AE36,5)","v":5845.55},null,{"$f":"ROUND(AG6+AG25+AG32+AG36,5)","v":17466.97},null,{"$f":"ROUND(AI6+AI25+AI32+AI36,5)","v":1660.52},null,{"$f":"ROUND(AK6+AK25+AK32+AK36,5)","v":1521.55},null,{"$f":"ROUND(AM6+AM25+AM32+AM36,5)","v":3355.74},null,{"$f":"ROUND(AO6+AO25+AO32+AO36,5)","v":24975.67},null,{"$f":"ROUND(AQ6+AQ25+AQ32+AQ36,5)","v":23561.48},null,{"$f":"ROUND(AS6+AS25+AS32+AS36,5)","v":26886.43},null,{"$f":"ROUND(AU6+AU25+AU32+AU36,5)","v":10248.870000000001},null,{"$f":"ROUND(SUM(E37:AU37),5)","v":270733}]
["Employer Taxes and Contributions"]
[null,"Medicare Company",null,null,192.55,null,74.36,null,913.51,null,8.36,null,58.23,null,68.91,null,321.2,null,381.7,null,454.21,null,178.66,null,137.81,null,114.66,null,118.67,null,97.33,null,335.63,null,26.41,null,24.5,null,60.48,null,485.66,null,461.57,null,543.69000000000005,null,193.18,null,{"$f":"ROUND(SUM(E39:AU39),5)","v":5251.28}]
[null,"Social Security Company",null,null,823.33,null,317.95999999999998,null,3906.03,null,35.75,null,248.98,null,294.66000000000003,null,1373.39,null,1632.09,null,1942.14,null,763.92,null,589.26,null,490.26,null,507.42,null,416.16,null,1435.12,null,112.92,null,104.76,null,258.62,null,2076.62,null,1973.6,null,2324.75,null,826.01,null,{"$f":"ROUND(SUM(E40:AU40),5)","v":22453.75}]
[null,"IL - Unemployment Company",null,null,84.24,null,33.33,null,84.24,null,3.75,null,26.1,null,30.89,null,84.24,null,84.24,null,84.24,null,80.09,null,61.78,null,51.4,null,53.2,null,43.63,null,84.24,null,11.84,null,10.98,null,27.11,null,84.24,null,84.24,null,84.24,null,84.24,null,{"$f":"ROUND(SUM(E41:AU41),5)","v":1276.5}]
[null,"IMRF - Company Share",null,null,1698.42,null,0,null,8057.71,null,0,null,0,null,0,null,2951.53,null,3366.9,null,4006.46,null,0,null,0,null,0,null,0,null,0,null,2960.48,null,0,null,0,null,0,null,4356.33,null,4071.36,null,4795.7,null,1065.6400000000001,null,{"$f":"ROUND(SUM(E42:AU42),5)","v":37330.53}]
["Total Employer Taxes and Contributions",null,null,null,{"$f":"ROUND(SUM(E38:E42),5)","v":2798.54},null,{"$f":"ROUND(SUM(G38:G42),5)","v":425.65},null,{"$f":"ROUND(SUM(I38:I42),5)","v":12961.49},null,{"$f":"ROUND(SUM(K38:K42),5)","v":47.86},null,{"$f":"ROUND(SUM(M38:M42),5)","v":333.31},null,{"$f":"ROUND(SUM(O38:O42),5)","v":394.46},null,{"$f":"ROUND(SUM(Q38:Q42),5)","v":4730.3599999999997},null,{"$f":"ROUND(SUM(S38:S42),5)","v":5464.93},null,{"$f":"ROUND(SUM(U38:U42),5)","v":6487.05},null,{"$f":"ROUND(SUM(W38:W42),5)","v":1022.67},null,{"$f":"ROUND(SUM(Y38:Y42),5)","v":788.85},null,{"$f":"ROUND(SUM(AA38:AA42),5)","v":656.32},null,{"$f":"ROUND(SUM(AC38:AC42),5)","v":679.29},null,{"$f":"ROUND(SUM(AE38:AE42),5)","v":557.12},null,{"$f":"ROUND(SUM(AG38:AG42),5)","v":4815.47},null,{"$f":"ROUND(SUM(AI38:AI42),5)","v":151.16999999999999},null,{"$f":"ROUND(SUM(AK38:AK42),5)","v":140.24},null,{"$f":"ROUND(SUM(AM38:AM42),5)","v":346.21},null,{"$f":"ROUND(SUM(AO38:AO42),5)","v":7002.85},null,{"$f":"ROUND(SUM(AQ38:AQ42),5)","v":6590.77},null,{"$f":"ROUND(SUM(AS38:AS42),5)","v":7748.38},null,{"$f":"ROUND(SUM(AU38:AU42),5)","v":2169.0700000000002},null,{"$f":"ROUND(SUM(E43:AU43),5)","v":66312.06}]
[]
[null,null,null,"Dates of Holiday Pay","2018-01-02",null,"7/4, 11/23, 12/26",null,"1/2,4/14, 5/29,7/4",null,null,null,"9/4, 12/26",null,"1/2, 12/25",null,"1/2, 4/14, 5/29, 7/4,  ",null,"1/2, 4/14, 5/29, 7/4",null,"1/2, 4/14, 5/29, 7/4",null,"1/2, 5/29, 7/4,",null,"5/29 7/4, 9/4, ",null,"2018-11-23",null,"1/2, 5/29, 9/4",null,"4/14, 7/4, ",null,"1/2, 4/14, 5/29",null,"2018-04-14",null,"11/3, 12/26",null,"2018-01-02",null,"1/2, 4/14, 5/29, ",null,"1/2, 4/14, 5/29, 7/4",null,"1/2, 4/14, 5/29,",null,"1/2, 4/14, 5/26,"]
[null,null,null,null,null,null,null,null,"9/4. 11/23, 11/24, ",null,null,null,null,null,null,null,"9/4 ,11/23, 11/24, ",null,"9/4, 11/23, 11/24, ",null,"9/4, 11/23, 11/24,",null,"9/4, 11/23, ",null,"12/25, 12/26",null,null,null,"11/23, 12/25",null,"11/24, 12/26",null,"7/4, 9/4, 11/23, ",null,null,null,null,null,null,null,"7/4, 9/4,11/24",null,"9/4, 11/23, 11/24",null,"7/4, 11/23, 11/24,",null,"7/4, 9/4, 11/24"]
[null,null,null,null,null,null,null,null,"12/25, 12/26",null,null,null,null,null,null,null,"12/25, 12/26",null," 12/25, 12/26",null,"12/25, 12/26",null,"12/25, 12/26",null,null,null,null,null,null,null,null,null,"11/24,12/25,12/26",null,null,null,null,null,null,null,"12/25, 12/26",null,"12/25, 12/26",null,"12/25, 12/16",null,"12/25, 12/26"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12/18 Death"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"in the family"]