{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["QuickBooks Desktop Export Tips","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":130,"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":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Jan - Dec 26",null,"Notes"]
[null,"Ordinary Income/Expense",null,null,null,null,null,null,null,"PY - Prior Year, CY - Curent Year"]
[null,null,null,"Income"]
[null,null,null,null,"Direct Public Support"]
[null,null,null,null,null,"Grants",null,2850,null,"$350 from PY, $2500 TVA for CY"]
[null,null,null,null,null,"Individ, Business Contributions"]
[null,null,null,null,null,null,"Boat Fund",915,null,"PY"]
[null,null,null,null,null,null,"Friends",360,null,"PY"]
[null,null,null,null,null,null,"Undesignated Donations",2000,null,"PY"]
[null,null,null,null,null,"Total Individ, Business Contributions",null,{"$f":"ROUND(SUM(H7:H10),5)","v":3275}]
[null,null,null,null,"Total Direct Public Support",null,null,{"$f":"ROUND(SUM(H5:H6)+H11,5)","v":6125}]
[null,null,null,null,"Fundraising"]
[null,null,null,null,null,"4th of July Sales",null,1500,null,"Projected from PY "]
[null,null,null,null,null,"Flower Bouquet Sales",null,0,null,"No plans to do this"]
[null,null,null,null,null,"Flower Bulb Sales",null,2481,null,"PY"]
[null,null,null,null,null,"Raffle",null,1000,null,"PY "]
[null,null,null,null,null,"Raffle #2",null,500,null,"Projected with more advance notice than PY"]
[null,null,null,null,"Total Fundraising",null,null,{"$f":"ROUND(SUM(H13:H18),5)","v":5481}]
[null,null,null,null,"Other Types of Income"]
[null,null,null,null,null,"Bottle Drop",null,1000,null,"Projected from PY"]
[null,null,null,null,null,"Inventory Sales",null,120,null,"Remaining jerseys"]
[null,null,null,null,"Total Other Types of Income",null,null,{"$f":"ROUND(SUM(H20:H22),5)","v":1120}]
[null,null,null,null,"Program Income"]
[null,null,null,null,null,"Membership Dues",null,{"$f":"(33*225)+(2*40)","v":7505},null,"33 dues paying members and 2 exclusive steers"]
[null,null,null,null,"Total Program Income",null,null,{"$f":"ROUND(SUM(H24:H25),5)","v":7505}]
[null,null,null,"Total Income",null,null,null,{"$f":"ROUND(H4+H12+H19+H23+H26,5)","v":20231}]
[null,null,null,"Cost of Goods Sold"]
[null,null,null,null,"Cost of Goods Sold"]
[null,null,null,null,null,"Fundraising Purchases",null,1988.2,null,"4th of July and Flower Bulbs"]
[null,null,null,null,"Total Cost of Goods Sold",null,null,{"$f":"ROUND(SUM(H29:H30),5)","v":1988.2}]
[null,null,null,"Total COGS",null,null,null,{"$f":"ROUND(H28+H31,5)","v":1988.2}]
[null,null,"Gross Profit",null,null,null,null,{"$f":"ROUND(H27-H32,5)","v":18242.8}]
[null,null,null,"Expense"]
[null,null,null,null,"Business Expenses"]
[null,null,null,null,null,"Business Registration Fees",null,70,null,"Annual fees"]
[null,null,null,null,"Total Business Expenses",null,null,{"$f":"ROUND(SUM(H35:H36),5)","v":70}]
[null,null,null,null,"Facilities and Equipment"]
[null,null,null,null,null,"Equipment Maintenance",null,1038,null,"OR registration, R & M"]
[null,null,null,null,null,"Rent, Parking, Utilities",null,300,null,"Port lease"]
[null,null,null,null,"Total Facilities and Equipment",null,null,{"$f":"ROUND(SUM(H38:H40),5)","v":1338}]
[null,null,null,null,"Fundraising Costs"]
[null,null,null,null,null,"Fundraising Costs - Other",null,50,null,"Farmers Market fees"]
[null,null,null,null,"Total Fundraising Costs",null,null,{"$f":"ROUND(SUM(H42:H43),5)","v":50}]
[null,null,null,null,"Operations"]
[null,null,null,null,null,"Books, Subscriptions, Reference",null,149.99,null,"TeamSnap"]
[null,null,null,null,null,"Postage, Mailing Service",null,30]
[null,null,null,null,null,"Printing and Copying",null,2650,null,"$2500 from CY grant"]
[null,null,null,null,null,"Website",null,350,null,"$350 from PY grant"]
[null,null,null,null,"Total Operations",null,null,{"$f":"ROUND(SUM(H45:H49),5)","v":3179.99}]
[null,null,null,null,"Other Types of Expenses"]
[null,null,null,null,null,"Insurance - Liability, D and O",null,2312,null,"D&O, Liability and Hull"]
[null,null,null,null,null,"Memberships and Dues",null,300,null,"PDBA"]
[null,null,null,null,null,"Team Meetings",null,39.96]
[null,null,null,null,"Total Other Types of Expenses",null,null,{"$f":"ROUND(SUM(H51:H54),5)","v":2651.96}]
[null,null,null,"Total Expense",null,null,null,{"$f":"ROUND(H34+H37+H41+H44+H50+H55,5)","v":7289.95}]
[null,"Net Ordinary Income",null,null,null,null,null,{"$f":"ROUND(H3+H33-H56,5)","v":10952.85}]
[null,null,"Other Expense"]
[null,null,null,"Acquisitions & Payments",null,null,null,10000,null,"$2500 pmt to NCRD, $6,500 for new boat incl delivery, $1,000 laptop and programs for admin"]
[null,null,"Total Other Expense",null,null,null,null,{"$f":"ROUND(SUM(H58:H59),5)","v":10000}]
[null,"Net Other Income",null,null,null,null,null,-10000]
["Net Income",null,null,null,null,null,null,{"$f":"ROUND(H57+H61,5)","v":952.85}]
[]
[null,null,null,"Prior Year ending cash balance",null,null,null,6440]
[null,null,null,"Carry over to 2027",null,null,null,{"$f":"SUM(H62:H64)","v":7392.85}]