{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Treasurer Report","Income Detail","Expense Detail","Open Invoices"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Treasurer Report","index":0,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,1,4],[0,0,0,4],[2,0,2,4],[3,0,3,4]]}
["WEST ROWAN HIGH SCHOOL BAND BOOSTERS"]
["TREASURER'S REPORT "]
["2018-08-25"]
["These are our income and expenses since 7/22/18 and current balance."]
[]
["INCOME AND EXPENSE REPORT"]
[]
[null,"General Fund Bank Account"]
["Starting Balance as of 7/22/18",null,null,null,4348.88]
[]
[null,null,"Income "]
[null,null,null,"All County Band Fee",10.0]
[null,null,null,"Band Fee Raffle Income",240.0]
[null,null,null,"Band Fees",200.0]
[null,null,null,"Chocolate Sales",120.0]
[null,null,null,"Classroom Supplies",4.0]
[null,null,null,"Equipment Sales",240.0]
[null,null,null,"Extra Rehearsal Shirt",6.0]
[null,null,null,"Extra Uniform Shirt",45.0]
[null,null,null,"Extra Uniform Shorts",14.0]
[null,null,null,"Krispy Kreme Doughnuts",412.0]
[null,null,null,"Merchandise Sales",2330.92]
[null,null,null,"Misc. Income",54.24]
[null,null,null,"Nightbeat Ticket Reimbursement",98.13]
[null,null,null,"Snapraise",115.0]
[null,null,null,"Staff Retreat Reimbursement",55.0]
[null,null,null,"Student Accounts",16.0]
[null,null,null,"Transfer from Savings",1200.0]
[null,null,null," Total Income",{"$f":"SUM(E12:E28)","v":5160.29}]
[]
[]
[null,null,"Expenses"]
[null,null,null,"Band Camp Instructors",-2100.0]
[null,null,null,"Band Camp Snacks & Meals",-696.18]
[null,null,null,"Color Guard Uniform (shoes, etc)",-169.57]
[null,null,null,"Krispy Kreme Expense",-225.0]
[null,null,null,"Merchandise Expense (partial payment)",-1500.0]
[null,null,null,"Percussion Equipment",-896.95]
[null,null,null,"Practice/Uniform T-shirts/shorts",-1910.5]
[null,null,null,"Tax Preparation (FY17)",-450.0]
[null,null,null,"To Cash Box",-8.0]
[null,null,null,"Total Expenses",{"$f":"SUM(E33:E41)","v":-7956.2}]
[]
["Ending Balance",null,null,null,{"$f":"E9+E29+E42","v":1552.97}]
[]
[null,"Savings Account"]
["Starting Balance",null,null,null,2153.08]
[null,null,null,"Transfer to General Fund",-1200.0]
[null,null,null,"Deposits",0.0]
[]
["Ending Balance",null,null,null,{"$f":"E47+E48","v":953.08}]
[]
[null,null,null,"Total Available Funds",{"$f":"E44+E51","v":2506.05}]

{"sheet":"Income Detail","index":1,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["BOOSTER CLUB TREASURER'S REPORTS  August"]
["INCOME DETAIL"]
[]
[]
["Nightbeat Tickets"]
["7/27/18  Stripe Deposit",98.13,"x"]
[]
[]
["Transfer from Savings"]
["2018-07-27",1000.0]
["2018-08-15",200.0]
[]
[]
["All County Band fee"]
["7/31/18  Salisbury High",10.0,"x"]
[]
["Snapraise -- outside app"]
["2018-07-31",20.0,"x","Austin C."]
[null,45.0,"x","Trevor Loflin"]
["2018-08-17",25.0,"x","JJ Giddings"]
["2018-08-21",25.0,"x","Brandon Richmond"]
[]
["Chocolate Income"]
["2018-07-31",120.0,"x"]
[]
[]
["Staff Retreat Reimbursement"]
["2018-07-31",55.0,"x"]
[]
["Classroom Supplies "]
["2018-07-31",4.0,"x","valve oil"]
[]
["Misc Income (Donations, etc.)"]
["2018-07-31",20.0,"x"]
["2018-08-13",34.24,"x","Amazon Smile"]
["Extra Uniform Shirt"]
["2018-07-31",45.0,"x"]
[]
["Band Fee Raffle Income"]
["2018-08-04",240.0,"x"]
[]
["Krispy Kreme Doughnuts"]
["2018-08-17",412.0,"x"]
[]
["Merchandise Sales"]
["2018-08-17",1587.6,"x"]
["2018-08-18",316.38,"x","Tomato Festival"]
["2018-08-23",426.94,"x","Open House"]
["Extra Rehearsal Shirts"]
["2018-08-17",6.0,"x"]
[]
["Extra Uniform Shorts"]
["2018-08-17",14.0,"x"]
[]
["Equipment Sales"]
["2018-08-17",100.0,"x"]
["2018-08-23",140.0]
["Student Accounts"]
["2018-08-17",16.0,"x"]
[]
["Band Fees"]
["2018-08-23",200.0,"x"]

{"sheet":"Expense Detail","index":2,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["BOOSTER CLUB TREASURER'S REPORTS August"]
["EXPENSE DETAIL"]
[]
[]
["Band Camp Instructors"]
["7/26/18  Gilson Fearnow -- Percussion Instructor Wk1",500.0,"x"]
["7/27/18  Nathan Bowman Wk1",500.0,"x"]
["7/17/18  Ashton Fisher Wk 1",550.0,"x"]
["8/2/18  Gilson Fearnow Wk2",550.0,"x"]
[]
[]
["Practice & Uniform T-shirts and Shorts"]
["7/27/18  RW Sportswear",1910.5,"x"]
[]
["Band Camp Snacks and Meals"]
["7/27/18 Walmart",37.77,"x"]
["7/27/18 BJ's",168.13,"x"]
["7/28/18 Sam's",142.74,"x"]
["7/28/18 Aldi",41.73,"x"]
["8/1/18 Sam's",194.96,"x"]
["8/1/18 BJ's",52.95,"x"]
["8/1/18 BJ's",57.9,"x"]
[]
[]
["Cologuard Uniform"]
["7/31/18  Discount Dance - Shoes",53.57,"x"]
["8/15/18 A Wish Come True",116.0,"x"]
[]
[]
["Tax Preparation"]
["8/6/18  Jennifer Weaver CPA (2017)",450.0,"x"]
[]
["Percussion Equipment"]
["8/15/18 Steve Weiss Music",766.95,"x"]
["8/20/18 Troy City Schools (noise makers)",130.0,"x"]
["Krispy Kreme Expenses"]
["8/17/18  Football game",225.0,"x"]
[]
["Merchandise Expense"]
["8/20/18 (partial payment)",1500.0,"x"]
[]
["To Cash Box"]
["2018-08-17",8.0,"x"]

{"sheet":"Open Invoices","index":3,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,1,3],[0,0,0,2],[2,2,2,3],[3,2,3,3],[6,2,6,3]]}
["Invoices To Be Paid"]
[null,"2018-09-02","Steve Weiss Music -- percussion equipment",null,-265.52,"x"]
[null,"2018-09-06","Howren Music Company -- supplies (lyres/folders)",null,-136.32,"x"]
[null,"2018-09-15","Campus Creations -- merchandise",null,-2674.0,"x"]
[null,"2018-09-19","The Band Room (Shoes)",null,-956.22,"x"]
[null,"2018-09-19","The Band Room (Gloves)",null,-189.25,"x"]
[null,"2018-10-04","JW Pepper -- music",null,-127.33,"x"]
[{"$nulls":4},{"$f":"SUM(E2:E6)","v":-4221.31}]