OSE Base Budget
The link below will allow you to create a copy of the base student budget.
How to Use the Budget -
Clubs and organizations can use this budget to track organizational expenditures over the semester or year. This budget can also be modified to set up event budgets or budget proposals. You'll notice the base budget has built in summary tables and several sheets you'll manipulate to set it up. Read the instructions to learn more about how you can get the most out of this resource. Once you have your budget set up you can copy it into your organizational shared drive and share it with other members.
Main Sheet -
You'll use the main sheet to track your overall expenditures. The following column descriptions should provide an outline on how to use this sheet once your budget is set up. Read through the "Budget Sheet" instructions below to learn how to set up your sheet. Columns:
- Column A - Event - If your expenditures are associated with a specific event you can enter the event title here. This will allow you to summarize your costs by event on the "Events Sheet".
- Column B - Description - Describe your purchase.
- Column C - Cost - Enter the amount of your purchase, or the amount promised (see Column G).
- Column D - Type - Select the Institutional Sub Code your expenditure falls under. Think of these as budget categories. SBC Funded Groups will have all of their funds split amongst the sub codes that you requested during spring budgeting. You'll enter your starting budget in the "Budget" sheet of this document. You can manipulate this drop-down menu by editing the cells in Column A of the "Budget Sheet". See more info below
- Column E - Budget Code - This is the number associated with the sub code you selected in Column D.
- Column G - Paid vs Promised - Sometimes you'll plan to spend money. For example, you might tell a member to go out and purchase $50 in supplies. Enter that number in Column C and switch Column G to "promised". When the member returns the real receipt, lets say $44.95, then you record the correct amount and switch column G back to "Paid". You can also use this concept to hold money for future events.
- Columns I-L - Pivot table summary of your expenses compared to the allocation for each sub code. If you want to get rid of the sub codes you don't have money allocated for, delete the appropriate rows in lines 150-161 on the "Main Sheet"
Budget Sheet -
You'll use this sheet to enter your starting budget. The sub code categories are developed by the business office, and all SBC budgetary allocations are divided among the listed sub codes on this sheet. The name of the Sub Code is in Column A and the number for each Sub Code is in Column B. Check your spring budgeting results to learn more about how much you have for each sub code. Once you have those numbers enter them into Column C on this sheet.
Events Sheet -
The events sheet summarizes your expenses by event. This table will not auto populate unless you enter an event name in Column A on the "Main Sheet"
How to Modify the Base Student Budget -
You can use this sheet to set up a budget projection for an upcoming event. Let’s say you wanted to host a speaker with food. You can change the categories on the "Budget Sheet" for the categories for your event. For this event you'll have speaker fees, food costs, and event supplies. Enter the amount you'd like to spend in the Allocation Column on the "Budget Sheet". You can further refine your event budget projection by adding detailed estimates for each item to be purchased within each category.