OSE Base Budget

The link below will allow you to create a copy of the base student budget.

Base 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 below 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.

 

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 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.

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 - Date of Event.
  • Column C - Description - Describe the details of the purchase.
  • Column D - Cost - Enter the cost of the purchase.
  • Column E - 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 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 F - Budget Code - This is the number associated with the sub code you selected in Column E.
  • 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"

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.