{"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":121,"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":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Commisioners",null,"Bill Sears",null,null,"Howel Carr",null,null,"Jacob Chambers",null,null,"Mark Carrico",null,null,"Mickey Grooms",null,null,"Phillip Carr",null,null,"Steve Mason"]
[null,null,null,null,null,"Jan - Dec 23",null,null,"Jan - Dec 23",null,null,"Jan - Dec 23",null,null,"Jan - Dec 23",null,null,"Jan - Dec 23",null,null,"Jan - Dec 23",null,null,"Jan - Dec 23",null,null,"Jan - Dec 23"]
["Employee Wages, Taxes and Adjustments"]
[null,null,"Gross Pay"]
[null,null,null,"SALARY",null,3600,null,null,2700,null,null,3600,null,null,3600,null,null,3600,null,null,3600,null,null,3600,null,null,{"$f":"ROUND(F5+I5+L5+O5+R5+U5+X5,5)","v":24300}]
[null,null,"Total Gross Pay",null,null,{"$f":"ROUND(SUM(F4:F5),5)","v":3600},null,null,{"$f":"ROUND(SUM(I4:I5),5)","v":2700},null,null,{"$f":"ROUND(SUM(L4:L5),5)","v":3600},null,null,{"$f":"ROUND(SUM(O4:O5),5)","v":3600},null,null,{"$f":"ROUND(SUM(R4:R5),5)","v":3600},null,null,{"$f":"ROUND(SUM(U4:U5),5)","v":3600},null,null,{"$f":"ROUND(SUM(X4:X5),5)","v":3600},null,null,{"$f":"ROUND(F6+I6+L6+O6+R6+U6+X6,5)","v":24300}]
[null,null,"Deductions from Gross Pay"]
[null,null,null,"SCHOLARSHIP",null,-142.91999999999999,null,null,-107.19,null,null,-142.91999999999999,null,null,-142.91999999999999,null,null,-142.91999999999999,null,null,-142.91999999999999,null,null,-142.91999999999999,null,null,{"$f":"ROUND(F8+I8+L8+O8+R8+U8+X8,5)","v":-964.71}]
[null,null,"Total Deductions from Gross Pay",null,null,{"$f":"ROUND(SUM(F7:F8),5)","v":-142.91999999999999},null,null,{"$f":"ROUND(SUM(I7:I8),5)","v":-107.19},null,null,{"$f":"ROUND(SUM(L7:L8),5)","v":-142.91999999999999},null,null,{"$f":"ROUND(SUM(O7:O8),5)","v":-142.91999999999999},null,null,{"$f":"ROUND(SUM(R7:R8),5)","v":-142.91999999999999},null,null,{"$f":"ROUND(SUM(U7:U8),5)","v":-142.91999999999999},null,null,{"$f":"ROUND(SUM(X7:X8),5)","v":-142.91999999999999},null,null,{"$f":"ROUND(F9+I9+L9+O9+R9+U9+X9,5)","v":-964.71}]
[null,"Adjusted Gross Pay",null,null,null,{"$f":"ROUND(F6+F9,5)","v":3457.08},null,null,{"$f":"ROUND(I6+I9,5)","v":2592.81},null,null,{"$f":"ROUND(L6+L9,5)","v":3457.08},null,null,{"$f":"ROUND(O6+O9,5)","v":3457.08},null,null,{"$f":"ROUND(R6+R9,5)","v":3457.08},null,null,{"$f":"ROUND(U6+U9,5)","v":3457.08},null,null,{"$f":"ROUND(X6+X9,5)","v":3457.08},null,null,{"$f":"ROUND(F10+I10+L10+O10+R10+U10+X10,5)","v":23335.29}]
[null,"Taxes Withheld"]
[null,null,"Federal Withholding",null,null,0,null,null,0,null,null,-504,null,null,-720,null,null,0,null,null,-600,null,null,0,null,null,{"$f":"ROUND(F12+I12+L12+O12+R12+U12+X12,5)","v":-1824}]
[null,null,"Medicare Employee",null,null,-52.2,null,null,-39.15,null,null,-52.2,null,null,-52.2,null,null,-52.2,null,null,-52.2,null,null,-52.2,null,null,-352.35]
[null,null,"Social Security Employee",null,null,-223.2,null,null,-167.4,null,null,-223.2,null,null,-223.2,null,null,-223.2,null,null,-223.2,null,null,-223.2,null,null,-1506.6]
[null,null,"KY - Withholding",null,null,-27.96,null,null,-20.97,null,null,-160.44,null,null,-27.96,null,null,-27.96,null,null,-27.96,null,null,-27.96,null,null,-321.20999999999998]
[null,null,"Graves County tax",null,null,-36,null,null,-27,null,null,-36,null,null,-36,null,null,-36,null,null,-36,null,null,-36,null,null,-243]
[null,null,"Medicare Employee Addl Tax",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,"Total Taxes Withheld",null,null,null,{"$f":"ROUND(SUM(F11:F17),5)","v":-339.36},null,null,{"$f":"ROUND(SUM(I11:I17),5)","v":-254.52},null,null,{"$f":"ROUND(SUM(L11:L17),5)","v":-975.84},null,null,{"$f":"ROUND(SUM(O11:O17),5)","v":-1059.3599999999999},null,null,{"$f":"ROUND(SUM(R11:R17),5)","v":-339.36},null,null,{"$f":"ROUND(SUM(U11:U17),5)","v":-939.36},null,null,{"$f":"ROUND(SUM(X11:X17),5)","v":-339.36},null,null,-4247.16]
["Net Pay",null,null,null,null,{"$f":"ROUND(F3+F10+F18,5)","v":3117.72},null,null,{"$f":"ROUND(I3+I10+I18,5)","v":2338.29},null,null,{"$f":"ROUND(L3+L10+L18,5)","v":2481.2399999999998},null,null,{"$f":"ROUND(O3+O10+O18,5)","v":2397.7199999999998},null,null,{"$f":"ROUND(R3+R10+R18,5)","v":3117.72},null,null,{"$f":"ROUND(U3+U10+U18,5)","v":2517.7199999999998},null,null,{"$f":"ROUND(X3+X10+X18,5)","v":3117.72},null,null,19088.13]
["Employer Taxes and Contributions"]
[null,"Federal Unemployment",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,21.6,null,null,0,null,null,{"$f":"ROUND(F21+I21+L21+O21+R21+U21+X21,5)","v":21.6}]
[null,"Medicare Company",null,null,null,52.2,null,null,39.15,null,null,52.2,null,null,52.2,null,null,52.2,null,null,52.2,null,null,52.2,null,null,{"$f":"ROUND(F22+I22+L22+O22+R22+U22+X22,5)","v":352.35}]
[null,"Social Security Company",null,null,null,223.2,null,null,167.4,null,null,223.2,null,null,223.2,null,null,223.2,null,null,223.2,null,null,223.2,null,null,{"$f":"ROUND(F23+I23+L23+O23+R23+U23+X23,5)","v":1506.6}]
[null,"KY - Unemployment",null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,{"$f":"ROUND(F24+I24+L24+O24+R24+U24+X24,5)","v":0}]
["Total Employer Taxes and Contributions",null,null,null,null,{"$f":"ROUND(SUM(F20:F24),5)","v":275.39999999999998},null,null,{"$f":"ROUND(SUM(I20:I24),5)","v":206.55},null,null,{"$f":"ROUND(SUM(L20:L24),5)","v":275.39999999999998},null,null,{"$f":"ROUND(SUM(O20:O24),5)","v":275.39999999999998},null,null,{"$f":"ROUND(SUM(R20:R24),5)","v":275.39999999999998},null,null,{"$f":"ROUND(SUM(U20:U24),5)","v":297},null,null,{"$f":"ROUND(SUM(X20:X24),5)","v":275.39999999999998},null,null,{"$f":"ROUND(F25+I25+L25+O25+R25+U25+X25,5)","v":1880.55}]
[]
[]
[null,null,null,"2023 Annual Compensation Rate",null,3600,null,null,3600,null,null,3600,null,null,3600,null,null,3600,null,null,3600,null,null,3600]
[]
[null,null,null,"Term Beginning",null,"2021-02-01",null,null,"2021-02-01",null,null,"2020-02-01",null,null,"2023-02-01","*",null,"2023-02-01","*",null,"2021-02-01",null,null,"2020-02-01"]
[null,null,null,"Term Ending",null,"2025-01-31",null,null,"2023-09-29","**",null,"2024-01-31",null,null,"2027-01-31",null,null,"2027-01-31",null,null,"2025-01-31",null,null,"2024-01-31"]
[]
[null,null,"*","Mickey Grooms and Mark Carrico previous terms expired 1/31/23 but they were reappointed ."]
[]
[null,null,"**","Howel Carr resigned 9/29/23"]