{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Prop.Act Budget","CK REG","Income","Expenses","Yr End Financial","Accounts"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Prop.Act Budget","index":0,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Brighton High PTA"]
[null,"Financial Report",{"$f":"TODAY()","v":"2012-12-06"}]
[]
[null,"2012-13 Approved","2012-13 Actual"]
["Income"]
["Lifetouch Photos"]
["Membership Dues",1512,1771.97]
["Donations",3336,419.53000000000003]
["Sales Tax Refund",0]
["Region monies-Graduation"]
["Total",{"$f":"SUM(B6:B10)","v":4848},{"$f":"SUM(C6:C10)","v":2191.5}]
[]
["Expenditures:",null,null,"Balance"]
["PTC Lunches",1800,null,{"$f":"+B14-C14","v":1800}]
["Holiday Teacher Lunch",50,null,50]
["Teacher Awards",225,122.12,102.88]
["Teacher Appreciation",500,null,500]
["Teacher B days",75,null,75]
["Teacher Gift",300,null,300]
["NAMI",100,34.51,65.490000000000009]
["Liability Insurance",320,null,320]
["PTSA Training",260,null,260]
["Reflections",100,null,100]
["Magnets",927,null,927]
["Student Relations",150,755,-605]
["Student \"You Got Caught Award\"",300,null,300]
["Student Fundraiser",300,null,300]
["Projects",200,null,200]
["Graduation"]
["PTA dues",918]
["Council dues"]
["Totals",{"$f":"SUM(B14:B31)","v":6525},{"$f":"SUM(C14:C31)","v":911.63},{"$f":"SUM(D14:D31)","v":4695.37}]
["Income less Expenditures",{"$f":"B11-B32","v":-1677},{"$f":"C11-C32","v":1279.8699999999999}]
["Current Bk Balance",7968.16]

{"sheet":"CK REG","index":1,"n_rows":53,"n_cols":14,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["BHS CHECK REGISTER '12- '13"]
[null,null,null,"2012-11-09"]
[]
[null,null,null,null,"Check","Deposit"]
["Num,","Date","Description","Acct","CK Amount","D Amount","Balance"]
[null,"2012-10-12","Starting Balance",null,null,null,6688.29]
["Deposit","2012-10-23","Birthday Donations","Donations",null,365.23,7053.52]
[1713,"2012-10-30","Halloween Party","Student Relations",755,null,6298.52]
["Deposit","2012-11-12","Lauren Mckell","Donations",null,54.3,6352.8200000000006]
[1714,"2012-11-12","Teacher day awards","Teacher Awards",122.12,null,6230.7000000000007]
[1715,"2012-11-15","NAMI Dues","NAMI",34.51,null,6196.19]
["Deposit","2012-11-18","Fall period dues","Membership Dues",null,1448.17,7644.36]
["Deposit","2012-11-19","Late dues","Membership Dues",null,323.8,7968.16]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," ",null," "]

{"sheet":"Income","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3]]}
["Brighton High PTA"]
["Income Register"]
[{"$f":"TODAY()","v":"2012-12-06"}]
[]
["Income Source","Date","Description","Amount Rec'd "]
["Lifetouch Photos"]
["Membership Dues","2012-11-18","Fall period dues",1448.17]
[null,"2012-11-19","Late dues",323.8]
["Donations","2012-10-23","Birthday Donations",365.23]
[null,"2012-11-12","Lauren Mckell",54.3]
["Sales Tax Refund"]
["Region monies-Graduation"]
["Total Income",null,null,{"$f":"SUM(D6:D12)","v":2191.5}]

{"sheet":"Expenses","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4]]}
["Brighton High PTA"]
["Expense Report"]
[{"$f":"TODAY()","v":"2012-12-06"}]
[]
["Expense Category","Date","Check #","Description","Amount"]
["PTC Lunches"]
["Holiday Teacher Lunch",null,null,null,null,null,null,null,null,null," "]
["Teacher Awards","2012-11-12",1714,"Teacher day awards",122.12]
["Teacher Appreciation"]
["Teacher B days"]
["Teacher Gift"]
["NAMI","2012-11-15",1715,"NAMI Dues",34.51]
["Liability Insurance"]
["PTSA Training"]
["Reflections"]
["Magnets"]
["Student Relations","2012-10-30",1713,"Halloween party",750]
["Student \"You Got Caught Award\""]
["Student Fundraiser"]
["Projects"]
["Graduation"]
["PTA dues"]
["Council dues"]
["Total Expenses",null,null,null,{"$f":"SUM(E6:E23)","v":906.63}]

{"sheet":"Yr End Financial","index":4,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
["Brighton High PTA"]
["Year-End Financial Report"]
["2012-2013"]
["Balance Forward:","(as of 8/31/2012)",6688.29]
[]
["Annual Revenue:"]
["Lifetouch Photos",null,{"$f":"VLOOKUP(\"Lifetouch Photos\",Income!$A$6:$D$37,4,FALSE)","v":0}]
["Membership Dues",null,{"$f":"VLOOKUP(\"Membership Dues\",Income!$A$6:$D$37,4,FALSE)","v":1448.17}]
["Donations",null,{"$f":"VLOOKUP(\"Donations\",Income!$A$6:$D$37,4,FALSE)","v":365.23}]
["Sales Tax Refund",null,{"$f":"VLOOKUP(\"Sales Tax Refund\",Income!$A$6:$D$37,4,FALSE)","v":0}]
["Region monies-Graduation",null,{"$f":"VLOOKUP(\"Region monies-Graduation\",Income!$A$6:$D$37,4,FALSE)","v":0}]
["Total 2012/13 Revenue",null,{"$f":"SUM(C7:C11)","v":1813.4}]
[]
["Expenses:"]
["PTC Lunches",null,{"$f":"VLOOKUP(\"PTC Lunches\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Holiday Teacher Lunch",null,{"$f":"VLOOKUP(\"Holiday Teacher Lunch\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Teacher Awards",null,{"$f":"VLOOKUP(\"Teacher Awards\",Expenses!$A$6:$E$35,5,FALSE)","v":122.12}]
["Teacher Appreciation",null,{"$f":"VLOOKUP(\"Teacher Appreciation\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Teacher B days",null,{"$f":"VLOOKUP(\"Teacher B Days\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Teacher Gift",null,{"$f":"VLOOKUP(\"Teacher Gift\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["NAMI",null,{"$f":"VLOOKUP(\"NAMI\",Expenses!$A$6:$E$35,5,FALSE)","v":34.51}]
["Liability Insurance",null,{"$f":"VLOOKUP(\"Liability Insurance\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["PTSA Training",null,{"$f":"VLOOKUP(\"PTSA Training\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Reflections",null,{"$f":"VLOOKUP(\"Reflections\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Magnets",null,{"$f":"VLOOKUP(\"Magnets\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Student Relations",null,{"$f":"VLOOKUP(\"Student Relations\",Expenses!$A$6:$E$35,5,FALSE)","v":750}]
["Student \"You Got Caught Award\"",null,{"$f":"VLOOKUP(\"Student \"\"You Got Caught Award\"\"\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Student Fundraiser",null,{"$f":"VLOOKUP(\"Student Fundraiser\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Projects",null,{"$f":"VLOOKUP(\"Projects\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Graduation",null,{"$f":"VLOOKUP(\"PTC Lunches\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["PTA dues",null,{"$f":"VLOOKUP(\"PTC Lunches\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Council dues",null,{"$f":"VLOOKUP(\"PTC Lunches\",Expenses!$A$6:$E$35,5,FALSE)","v":0}]
["Total Expenditures",null,{"$f":"SUM(C15:C32)","v":906.63}]
[]
["Ending Balance",null,{"$f":"C4+C12-C33","v":7595.06}]

{"sheet":"Accounts","index":5,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Expenditures:"]
["PTC Lunches"]
["Holiday Teacher Lunch"]
["Teacher Awards"]
["Teacher Appreciation"]
["Teacher B days"]
["Teacher Gift"]
["NAMI"]
["Liability Insurance"]
["PTSA Training"]
["Reflections"]
["Magnets"]
["Student Relations"]
["Student \"You Got Caught Award\""]
["Student Fundraiser"]
["Projects"]
["Graduation"]
["PTA dues"]
["Council dues"]
[]
[]
["Income"]
["Lifetouch Photos"]
["Membership Dues"]
["Donations"]
["Sales Tax Refund"]
["Region monies-Graduation"]