{"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":81,"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":73,"n_cols":13,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["Type",null,"Date",null,"Num",null,"Name",null,"Memo",null,"Amount",null,"Balance"]
[null,null,null,null,null,null,null,null,null,null,null,null,456975.9]
["Bill Pmt -Check",null,"2023-07-05",null,"15229",null,"Allied Benefit Systems LLC",null,"Inv#0000759529",null,-12019.24,null,{"$f":"ROUND(M2+K3,5)","v":444956.66}]
["Bill Pmt -Check",null,"2023-07-05",null,"15230",null,"B. Dalton Bookkeeping",null,"Inv#9195",null,-455,null,{"$f":"ROUND(M3+K4,5)","v":444501.66}]
["Bill Pmt -Check",null,"2023-07-05",null,"15231",null,"Mosty Law Firm",null,"Inv#01313 BCRAGD-Vanderpool Federal suit",null,-1912,null,{"$f":"ROUND(M4+K5,5)","v":442589.66}]
["Bill Pmt -Check",null,"2023-07-05",null,"15232",null,"B. Dalton Bookkeeping",null,"Inv#9196",null,-455,null,{"$f":"ROUND(M5+K6,5)","v":442134.66}]
["Bill Pmt -Check",null,"2023-07-05",null,"15233",null,"Mosty Law Firm",null,"Inv#01375 BCRAGD-Dougherty",null,-745,null,{"$f":"ROUND(M6+K7,5)","v":441389.66}]
["Bill Pmt -Check",null,"2023-07-05",null,"15234",null,"Mosty Law Firm",null,"Inv#01374 BCRAGD-OTX",null,-1620,null,{"$f":"ROUND(M7+K8,5)","v":439769.66}]
["Bill Pmt -Check",null,"2023-07-05",null,"15235",null,"Mosty Law Firm",null,"Inv#01312  BCRAGD-General",null,-180,null,{"$f":"ROUND(M8+K9,5)","v":439589.66}]
["Bill Pmt -Check",null,"2023-07-05",null,"15236",null,"Culligan of the Hill Country",null,"Inv# 202307524700 Acct#524700",null,-275.5,null,{"$f":"ROUND(M9+K10,5)","v":439314.16}]
["Bill Pmt -Check",null,"2023-07-05",null,"15237",null,"Xerox Business Solutions Southwest",null,"Inv#IN4510062...Apr-Jun overage period",null,-164.3,null,{"$f":"ROUND(M10+K11,5)","v":439149.86}]
["Liability Check",null,"2023-07-06",null,"ACH",null,"Vanguard",null,null,null,-5242.5,null,{"$f":"ROUND(M11+K12,5)","v":433907.36}]
["Liability Check",null,"2023-07-07",null,"ACH",null,"Texas Workforce Commission",null,"99-882103-1",null,-3.89,null,{"$f":"ROUND(M12+K13,5)","v":433903.47}]
["Bill Pmt -Check",null,"2023-07-10",null,"D",null,"AT&T Mobility",null,"Inv# 287301086391X3203",null,-129.30000000000001,null,{"$f":"ROUND(M13+K14,5)","v":433774.17}]
["Bill Pmt -Check",null,"2023-07-10",null,"D",null,"Bandera Bank",null,"July 2023 3 Veh Loan",null,-2052.79,null,{"$f":"ROUND(M14+K15,5)","v":431721.38}]
["Bill Pmt -Check",null,"2023-07-10",null,"15238",null,"David Jeffery",null,"Inv# 2306",null,-1365,null,{"$f":"ROUND(M15+K16,5)","v":430356.38}]
["Bill Pmt -Check",null,"2023-07-10",null,"15239",null,"Texas Water Foundation",null,"Inv# 1106 Texas Runs on Water",null,-1000,null,{"$f":"ROUND(M16+K17,5)","v":429356.38}]
["Bill Pmt -Check",null,"2023-07-10",null,"15240",null,"Wex Bank",null,"Inv# 90393169 Acct#0496004861134",null,-440.42,null,{"$f":"ROUND(M17+K18,5)","v":428915.96}]
["Deposit",null,"2023-07-11",null,null,null,null,null,"Deposit",null,29728.51,null,{"$f":"ROUND(M18+K19,5)","v":458644.47}]
["Liability Check",null,"2023-07-13",null,null,null,"QuickBooks Payroll Service",null,"Created by Payroll Service on 07/06/2023",null,-26295.06,null,{"$f":"ROUND(M19+K20,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Schnoebelen, Paul",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M20+K21,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Blair, Prari D",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M21+K22,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Carter, Clinton R",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M22+K23,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Curd, Charley",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M23+K24,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Fox, Corrina D",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M24+K25,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Hernandez, Hayli D",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M25+K26,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Irvin, Diane J",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M26+K27,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Mauk, David A",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M27+K28,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Sckittone, Shelby L",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M28+K29,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Sparks, Levi L.",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M29+K30,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Thomas, Larry B",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M30+K31,5)","v":432349.41}]
["Paycheck",null,"2023-07-14",null,"DD",null,"Whitmire, Luke E",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M31+K32,5)","v":432349.41}]
["Liability Check",null,"2023-07-14",null,"EFTPS",null,"United States Treasury",null,"74-2576034",null,-8395.4599999999991,null,{"$f":"ROUND(M32+K33,5)","v":423953.95}]
["Bill Pmt -Check",null,"2023-07-18",null,"15244",null,"Card Service Center",null,"X0067---June 8, 2023-July 7, 2023",null,-4647.0200000000004,null,{"$f":"ROUND(M33+K34,5)","v":419306.93}]
["Bill Pmt -Check",null,"2023-07-18",null,"15245",null,"GM Ellis Law Firm PC",null,"BCRAGD-091 April 2023-June 2023",null,-1800,null,{"$f":"ROUND(M34+K35,5)","v":417506.93}]
["Bill Pmt -Check",null,"2023-07-18",null,"15246",null,"HACH",null,"172238-001",null,-353.6,null,{"$f":"ROUND(M35+K36,5)","v":417153.33}]
["Check",null,"2023-07-18",null,"15241",null,"VOIDED",null,null,null,0,null,{"$f":"ROUND(M36+K37,5)","v":417153.33}]
["Check",null,"2023-07-18",null,"15242",null,"VOIDED",null,null,null,0,null,{"$f":"ROUND(M37+K38,5)","v":417153.33}]
["Check",null,"2023-07-18",null,"15243",null,"VOIDED",null,null,null,0,null,{"$f":"ROUND(M38+K39,5)","v":417153.33}]
["Deposit",null,"2023-07-20",null,null,null,null,null,"Deposit",null,5478.44,null,{"$f":"ROUND(M39+K40,5)","v":422631.77}]
["Deposit",null,"2023-07-25",null,null,null,null,null,"Deposit",null,6288.18,null,{"$f":"ROUND(M40+K41,5)","v":428919.95}]
["Bill Pmt -Check",null,"2023-07-25",null,"15247",null,"Allied Benefit Systems LLC",null,"Inv#0000772454..08/2023",null,-12019.24,null,{"$f":"ROUND(M41+K42,5)","v":416900.71}]
["Bill Pmt -Check",null,"2023-07-25",null,"15248",null,"Mosty Law Firm",null,"Inv#01430 BCRAGD-General",null,-654,null,{"$f":"ROUND(M42+K43,5)","v":416246.71}]
["Bill Pmt -Check",null,"2023-07-25",null,"15249",null,"Mosty Law Firm",null,"Inv#01379 BCRAGD-Dougherty",null,-560,null,{"$f":"ROUND(M43+K44,5)","v":415686.71}]
["Bill Pmt -Check",null,"2023-07-25",null,"15250",null,"Mosty Law Firm",null,"Inv#01429 BCRAGD-Vanderpool Federal Suit",null,-230,null,{"$f":"ROUND(M44+K45,5)","v":415456.71}]
["Bill Pmt -Check",null,"2023-07-25",null,"15251",null,"Araseli Avalos",null,"Inv#AA2131 - Cleaning Service 8/4/23 & 8/11/23",null,-250,null,{"$f":"ROUND(M45+K46,5)","v":415206.71}]
["Bill Pmt -Check",null,"2023-07-25",null,"15252",null,"Araseli Avalos",null,"Inv#AA2132 - Cleaning Services 8/18/23 & 8/25/23",null,-250,null,{"$f":"ROUND(M46+K47,5)","v":414956.71}]
["Bill Pmt -Check",null,"2023-07-27",null,"15253",null,"Advanced Groundwater Solutions, LLC.",null,"INV#12574 Services 5/23-7/23",null,-4500,null,{"$f":"ROUND(M47+K48,5)","v":410456.71}]
["Bill Pmt -Check",null,"2023-07-27",null,"15254",null,"BPS Security",null,"INV#2610 7/23 Services Customer ID69330004",null,-645,null,{"$f":"ROUND(M48+K49,5)","v":409811.71}]
["Bill Pmt -Check",null,"2023-07-27",null,"15255",null,"Environmental Systems Research Institute,",null,"INV# 94528072 ARCGIS Annual 23-24",null,-2630,null,{"$f":"ROUND(M49+K50,5)","v":407181.71}]
["Bill Pmt -Check",null,"2023-07-27",null,"15256",null,"GM Ellis Law Firm PC",null,"INV# BCRAGD-092 8/23 Legislative Services",null,-2400,null,{"$f":"ROUND(M50+K51,5)","v":404781.71}]
["Bill Pmt -Check",null,"2023-07-27",null,"15257",null,"Nippon Life Insurance Co of America",null,"INV#0000812307 GU9300 8/2023",null,-1179.77,null,{"$f":"ROUND(M51+K52,5)","v":403601.94}]
["Bill Pmt -Check",null,"2023-07-27",null,"15258",null,"Xerox Financial Services",null,"010-0038073-001",null,-306.39,null,{"$f":"ROUND(M52+K53,5)","v":403295.55}]
["Deposit",null,"2023-07-27",null,null,null,null,null,"Deposit",null,2399.31,null,{"$f":"ROUND(M53+K54,5)","v":405694.86}]
["Liability Check",null,"2023-07-28",null,null,null,"QuickBooks Payroll Service",null,"Created by Payroll Service on 07/06/2023",null,-26424.639999999999,null,{"$f":"ROUND(M54+K55,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Schnoebelen, Paul",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M55+K56,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Blair, Prari D",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M56+K57,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Carter, Clinton R",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M57+K58,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Curd, Charley",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M58+K59,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Fox, Corrina D",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M59+K60,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Hernandez, Hayli D",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M60+K61,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Irvin, Diane J",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M61+K62,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Mauk, David A",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M62+K63,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Sckittone, Shelby L",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M63+K64,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Sparks, Levi L.",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M64+K65,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Thomas, Larry B",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M65+K66,5)","v":379270.22}]
["Paycheck",null,"2023-07-31",null,"DD",null,"Whitmire, Luke E",null,"Direct Deposit",null,0,null,{"$f":"ROUND(M66+K67,5)","v":379270.22}]
["Liability Check",null,"2023-07-31",null,"EFTPS",null,"United States Treasury",null,"74-2576034",null,-8440.2999999999993,null,{"$f":"ROUND(M67+K68,5)","v":370829.92}]
["Bill Pmt -Check",null,"2023-07-31",null,"15260",null,"Ken Stoepel",null,"ACCT# AC5027 Transaction Number 227235",null,-15.85,null,{"$f":"ROUND(M68+K69,5)","v":370814.07}]
["Bill Pmt -Check",null,"2023-07-31",null,"15259",null,"Ken Stoepel",null,"VOID: ACT# 5027 13JUL23 Transaction 227235",null,0,null,{"$f":"ROUND(M69+K70,5)","v":370814.07}]
["Deposit",null,"2023-07-31",null,null,null,null,null,"Interest",null,37.53,null,{"$f":"ROUND(M70+K71,5)","v":370851.6}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(K2:K71),5)","v":-86124.3},null,{"$f":"M71","v":370851.6}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K72","v":-86124.3},null,{"$f":"M72","v":370851.6}]