{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":111,"n_cols":9,"rows_kept":111,"cut":false,"hidden":false,"merged":[[100,2,100,6],[88,2,88,6],[86,1,86,6],[87,2,87,6],[90,2,90,6],[92,2,92,6],[91,3,91,6],[56,3,56,5],[59,3,59,6],[60,3,60,6],[61,3,61,6],[62,3,62,6],[63,3,63,6],[64,3,64,6],[6,1,6,6],[94,2,94,6],[96,2,96,6],[98,2,98,6],[84,3,84,6],[75,3,75,6],[76,3,76,6],[77,3,77,6],[78,3,78,6],[79,3,79,6],[80,3,80,6],[81,3,81,6],[82,3,82,6],[83,3,83,6],[70,3,70,6],[71,3,71,6],[72,3,72,6],[73,3,73,6],[74,3,74,6],[65,3,65,6],[66,3,66,6],[67,3,67,6],[68,3,68,6],[69,3,69,6]]}
[]
[]
[]
[]
[]
[]
[null,"Chapter Name: "]
[]
[null,null,"Qtr. 1","Qtr. 2","Qtr. 3","Qtr. 4","Annual"]
[null,"A. Beginning Book Balance ",0,{"$f":"C43","v":0},{"$f":"D43","v":0},{"$f":"E43","v":0}]
[null,"Revenue"]
[null,"Member Dues - reimbursements from National ",0,0,0,0,{"$f":"C12+D12+E12+F12","v":0}]
[null,"Program Participation Fees",0,0,0,0,0]
["A","Interest - all accounts ",0,0,0,0,0]
["B","Donations/Grants - (give Corporate info below)",0,0,0,0,0]
[null,"ONS Award Income",0,0,0,0,0]
[null,"ONS Foundation Award Income",0,0,0,0,0]
["C","Miscellaneous support - noncorporate ",0,0,0,0,0]
[null,"Exhibit Fees",0,0,0,0,0]
[null,"Fundraising",0,0,0,0,0]
["E","Miscellaneous - enter detail in revenue section",0,0,0,0,0]
[]
[]
[null,"B. Total Revenue",{"$f":"SUM(C12:C22)","v":0},{"$f":"SUM(D12:D22)","v":0},{"$f":"SUM(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0},{"$f":"SUM(G12:G22)","v":0}]
[]
[null,"Expenses","Qtr. 1","Qtr. 2","Qtr. 3","Qtr. 4","Annual"]
[null,"Printing",0,0,0,0,{"$f":"SUM(C27:F27)","v":0}]
[null,"Postage/PO Box Rental",0,0,0,0,{"$f":"SUM(C28:F28)","v":0}]
[null,"Supplies",0,0,0,0,0]
[null,"Meetings/Travel",0,0,0,0,0]
[null,"Bank Charges",0,0,0,0,0]
[null,"Honorarium/Speakers",0,0,0,0,0]
[null,"Donations",0,0,0,0,0]
[null,"Grants/Scholarships/Awards",0,0,0,0,0]
[null,"ONS Foundation Support ",0,0,0,0,0]
[null,"Fundraising Expenses",0,0,0,0,0]
[null,"Chapter Renewal Fees",0,0,0,0,0]
["E","Miscellaneous - enter detail in expense section ",0,0,0,0,0]
[]
[]
[null,"C. Total Expenses",{"$f":"SUM(C27:C39)","v":0},{"$f":"SUM(D27:D39)","v":0},{"$f":"SUM(E27:E39)","v":0},{"$f":"SUM(F27:F39)","v":0},{"$f":"SUM(G27:G39)","v":0}]
[]
[null,"D. Ending Balance (A+B-C)",{"$f":"C10+C24-C41","v":0},{"$f":"D10+D24-D41","v":0},{"$f":"E10+E24-E41","v":0},{"$f":"F10+F24-F41","v":0}]
[]
[]
["D","Ending Balance (Figure D)",null,null,null,null,{"$f":"F43","v":0}]
[]
[null,"Outstanding Deposits (not on bank statement)",null,null,null,null,0]
[null,"List date and amount"]
[null,"Outstanding Checks (not on bank statement)",null,null,null,null,0]
[null,"List check # and amount"]
[null,"Total (D-outstanding deposits + outstanding checks)",null,null,null,null,{"$f":"G46-G48+G50","v":0},null,"Totals should match!"]
[]
[null,"Checking  (Statement balance)",null,null,null,0]
[null,"Savings (Statement balance)",null,null,null,0]
[null,"Certificates/Money Markets (Statement balance)",null,null,null,0]
[null,null,null,{"$f":"IF(D58,\"Review work - does NOT BALANCE.\",\"Congrats, you BALANCE!\")","v":"Congrats, you BALANCE!"}]
["D","Total  (should match Figure D)",null,{"$f":"G52-G58","v":0},null,null,{"$f":"F54+F55+F56","v":0}]
[]
[null,"Revenue Detail - Misc & Corporate info","Amount","Other Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Expense Detail - Misc ","Amount","Other Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Under penalty of perjury, I declare that I have examined these financial statements, and to the best of my knowledge, they are true, correct, and complete.  preparer has any knowledge. (For e-signatures, type your full name above the signature line.) Declaration of preparer is based on all information of which"]
[]
[null,"Signature of Treasurer:"]
[]
[null,"Treasurer Email:"]
[]
[null,"Preparer's Address:"]
[]
[null,"Daytime Phone of Preparer:"]
[]
[null,"Signature of Chapter President:"]
[]
[null,"President Email:"]
[]
[null,"Date Submitted:"]
[]
[]
[]
[null,"Line Item Descriptions"]
[]
["A","Total for interest on ALL accounts - include CDs, Savings and Money Market accounts."]
["B","List all corporate donations - LIST names of companies, addresses and amounts - needed for IRS reporting"]
["C","Miscelleanous donations  - not from a company/corporation"]
["D","These two amounts should equal."]
["E","Miscelleanous revenue and expense should be detailed - who, what etc."]