{"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":78,"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":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[null,"Type",null,"Date",null,"Num",null,"Name",null,"Split",null,"Amount","Gallons"]
[]
["610 · Purchased Water"]
[null,"Bill",null,"2024-01-10",null,"CON121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11259.9,5463500]
[null,"Bill",null,"2024-01-10",null,"CONBKSBG",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,5049.08,2368541]
[null,"Bill",null,"2024-01-10",null,"HARDEMAN",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,3476.64,1548701]
[null,null,null,null,null,null,null,null,null,"JANUARY",null,{"$f":"SUM(L4:L6)","v":19785.62},{"$f":"SUM(M4:M6)","v":9380742}]
[]
[null,"Bill",null,"2024-02-15",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,3959.15,1799790]
[null,"Bill",null,"2024-02-15",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8863.34,4353684]
[null,"Bill",null,"2024-02-15",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,12841.99,6226170]
[null,null,null,null,null,null,null,null,null,"FEBRUARY",null,{"$f":"SUM(L9:L11)","v":25664.48},{"$f":"SUM(M9:M11)","v":12379644}]
[]
[null,"Bill",null,"2024-03-14",null,"CON121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,15724.04,7648850]
[null,"Bill",null,"2024-03-14",null,"CONBKSG",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,9680.64,4779054]
[null,"Bill",null,"2024-03-14",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4281.57,1964960]
[null,null,null,null,null,null,null,null,null,"MARCH",null,{"$f":"SUM(L14:L16)","v":29686.25},{"$f":"SUM(M14:M16)","v":14392864}]
[]
[null,"Bill",null,"2024-04-10",null,"con121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,12983.18,6301380]
[null,"Bill",null,"2024-04-10",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,3932.17,1785766]
[null,"Bill",null,"2024-04-10",null,"CONBKSG",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,9000.69,4425167]
[null,null,null,null,null,null,null,null,null,"APRIL",null,{"$f":"SUM(L19:L21)","v":25916.04},{"$f":"SUM(M19:M21)","v":12512313}]
[]
[null,"Bill",null,"2024-05-09",null,"CONSBKSG",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8301.2900000000009,4031163]
[null,"Bill",null,"2024-05-09",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,3636.03,1631614]
[null,"Bill",null,"2024-05-09",null,"CON121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,10789.45,5226260]
[null,null,null,null,null,null,null,null,null,"MAY",null,{"$f":"SUM(L24:L26)","v":22726.770000000004},{"$f":"SUM(M24:M26)","v":10889037}]
[]
[null,"Bill",null,"2024-06-11",null,"HARDEMAN",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,3511.77,1567101]
[null,"Bill",null,"2024-06-11",null,"CONBKG",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,7475.23,3631238]
[null,"Bill",null,"2024-06-12",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,10377.84,5021810]
[null,null,null,null,null,null,null,null,null,"JUNE",null,{"$f":"SUM(L29:L31)","v":21364.84},{"$f":"SUM(M29:M31)","v":10220149}]
[]
[null,"Bill",null,"2024-07-09",null,"CON121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11435.48,5543690]
[null,"Bill",null,"2024-07-09",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4008.21,1825262]
[null,"Bill",null,"2024-07-09",null,"CONBKS",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,7870.6,3837008]
[null,null,null,null,null,null,null,null,null,"JULY",null,{"$f":"SUM(L34:L36)","v":23314.29},{"$f":"SUM(M34:M36)","v":11205960}]
[]
[null,"Bill",null,"2024-08-06",null,"CON2ND",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8436.7199999999993,4131651]
[null,"Bill",null,"2024-08-06",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4614.0200000000004,2140667]
[null,"Bill",null,"2024-08-06",null,"FF INTERCONNECT",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,6097.78,1873858]
[null,"Bill",null,"2024-08-06",null,"CONSUMERS",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11837.3,5742020]
[null,null,null,null,null,null,null,null,null,"AUGUST",null,{"$f":"SUM(L39:L42)","v":30985.82},{"$f":"SUM(M39:M42)","v":13888196}]
[]
[null,"Bill",null,"2024-09-12",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8979.15,2839195]
[null,"Bill",null,"2024-09-12",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,12057.98,5851990]
[null,"Bill",null,"2024-09-12",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4806.82,2240943]
[null,"Bill",null,"2024-09-12",null,null,null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8517.2900000000009,4173583]
[null,null,null,null,null,null,null,null,null,"SEPTEMBER",null,{"$f":"SUM(L45:L48)","v":34361.24},{"$f":"SUM(M45:M48)","v":15105711}]
[]
[null,"Bill",null,"2024-10-14",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,5701.21,2706277]
[null,"Bill",null,"2024-10-14",null,"CONSBKSG",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,9282.31,4571741]
[null,"Bill",null,"2024-10-14",null,"CONS121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,13334.87,6480870]
[null,"Bill",null,"2024-10-14",null,"FF",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,117.33,19359]
[null,null,null,null,null,null,null,null,null,"OCTOBER",null,{"$f":"SUM(L51:L54)","v":28435.72},{"$f":"SUM(M51:M54)","v":13778247}]
[]
[null,"Bill",null,"2024-11-13",null,"FF",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,15.56]
[null,"Bill",null,"2024-11-13",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,5114.03,2400950]
[null,"Bill",null,"2024-11-13",null,"CONBKS",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8363.89,4093745]
[null,"Bill",null,"2024-11-13",null,"CON121",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,11146.08,5397880]
[null,null,null,null,null,null,null,null,null,"NOVEMBER",null,{"$f":"SUM(L57:L60)","v":24639.559999999998},{"$f":"SUM(M57:M60)","v":11892575}]
[]
[null,"Bill",null,"2024-12-11",null,"CONBKG",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,8906.31,4198530]
[null,"Bill",null,"2024-12-11",null,"HRD",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,4266.43,1875099]
[null,"Bill",null,"2024-12-11",null,"CON",null,"MAYFIELD ELECTRIC & WATER SYSTEMS",null,"20000 · Accounts Payable",null,12222.82,5700630]
[null,null,null,null,null,null,null,null,null,"DECEMBER",null,{"$f":"SUM(L63:L65)","v":25395.559999999998},{"$f":"SUM(M63:M65)","v":11774259}]
[]
["Total 610 · Purchased Water",null,null,null,null,null,null,null,null,null,null,{"$f":"+L7+L12+L17+L22+L27+L32+L37+L43+L49+L55+L61+L66","v":312276.19000000006},{"$f":"+M7+M12+M17+M22+M27+M32+M37+M43+M49+M55+M61+M66","v":147419697}]