Finance

From Ni Wiki

(Difference between revisions)
(Using the Budget Templates)
(Using the Budget Templates)
Line 15: Line 15:
===Using the Budget Templates===
===Using the Budget Templates===
-
Budget templates for the chapter level and individual ventures can be found on your chapter's Google docs page.  If you do not have a Google docs page you can set one up with any [[http://www.gmail.com gmail] account.  There are four basic budget templates; one for [[Hunger Lunch]], one for [[Hold 'em for Hunger]], one designed for any event, and one for the chapter level that incorporates general expenses & revenue as well as project expenses.  With each template you can create a budget and then keep track of expenses and revenue as they come in.  To access an accounting template, simply click on the link.  Then at the bottom of the page click '''edit this page''' and then go to '''File''', '''Copy Spreadsheet'''.  Then save the document in the format of "University Chapter, Name of Document, Academic Year" (ex. UNC-CH Hold 'em for Hunger '06-'07).  Then after it is saved you can collaborate with Chaz at the National Office (chaz.littlejohn@gmail.com) as well as the appropriate people on each committee.
+
Budget templates for the chapter level and individual ventures can be found on your chapter's Google docs page.  If you do not have a Google docs page you can set one up with any [http://www.gmail.com gmail] account.  There are four basic budget templates; one for [[Hunger Lunch]], one for [[Hold 'em for Hunger]], one designed for any event, and one for the chapter level that incorporates general expenses & revenue as well as project expenses.  With each template you can create a budget and then keep track of expenses and revenue as they come in.  To access an accounting template, simply click on the link.  Then at the bottom of the page click '''edit this page''' and then go to '''File''', '''Copy Spreadsheet'''.  Then save the document in the format of "University Chapter, Name of Document, Academic Year" (ex. UNC-CH Hold 'em for Hunger '06-'07).  Then after it is saved you can collaborate with Chaz at the National Office (chaz.littlejohn@gmail.com) as well as the appropriate people on each committee.
[[Image:Hunger-lunch.jpg|thumb|The Hunger Lunch Accounting Template|300px|right]]
[[Image:Hunger-lunch.jpg|thumb|The Hunger Lunch Accounting Template|300px|right]]

Revision as of 18:58, 25 July 2007

Managing your chapter's finances can be a trying (boring) experience, but preparation and organization can really be the difference between success and failure. Healthy finances will ensure a strong future for your chapter by allowing you to recruit members, run profitable ventures, and fund excellent summer projects. This article will provide for you some tools you can utilize to maintain fiscal responsibility and ensure that your chapter remains in good financial standing.

Contents

Structure

A chapter's financial structure is divided between the Treasurer who handles the chapter bank account and the venture committees who can request funds for venture expenses. This relationship is not unlike the one between an entrepreneur searching for capital and a bank in need of a financial return. The Chapter's Treasurer acts as the director of finance for each & every venture. Their job will be to work with the venture directors in developing a budget & to manage the financial records for inflows & outflows.

Budget

Principals

The best first step on the path to fiscal responsibility is to develop and maintain a detailed chapter budget. At the beginning of the year, the executive committee should outline what ventures it plans on doing and create a budget for each using the chapter accounting documents. It is also good to refer to copies of your past budgets when developing a current or projected budget for your chapter.

When developing your budgets, remember to be realistic and conservative. A well-organized budget has two parts: revenue and expenses. Revenue could include ticket sales, plate sales, sponsor donations, departmental contributions, and any other planned revenue sources. When projecting your revenue, list all sources and add up all contributions, then subtract 10% of the gross revenue just in case everything doesn’t come through. Expenses include any money you plan to spend throughout the course of the year. Your primary expenses will be related to ventures. So for Hunger Lunch you should budget expenses for food, supplies such as plates, utensils, and promotional materials among other things.

Using the Budget Templates

Budget templates for the chapter level and individual ventures can be found on your chapter's Google docs page. If you do not have a Google docs page you can set one up with any gmail account. There are four basic budget templates; one for Hunger Lunch, one for Hold 'em for Hunger, one designed for any event, and one for the chapter level that incorporates general expenses & revenue as well as project expenses. With each template you can create a budget and then keep track of expenses and revenue as they come in. To access an accounting template, simply click on the link. Then at the bottom of the page click edit this page and then go to File, Copy Spreadsheet. Then save the document in the format of "University Chapter, Name of Document, Academic Year" (ex. UNC-CH Hold 'em for Hunger '06-'07). Then after it is saved you can collaborate with Chaz at the National Office (chaz.littlejohn@gmail.com) as well as the appropriate people on each committee.

The Hunger Lunch Accounting Template

Hunger Lunch: The Hunger Lunch Accounting Document gives you the ability to plan out yearly revenue and expenses based on variables such as price per lunch, number of lunches, and cost of food and supplies among other things. On the front page you'll find the projected earnings calculator as well as the total revenue and total expenses aggregator. Feeding into this aggregator is the Running Tally on the next page. As money comes in and out you can input each item under revenue or expenses. Each entry can be itemized and color coded based on its respective category (such as "plate sales" or "food expense"). You can also keep track of current total inflows and outflows under the "To Date" column. To aggregate, first sum up the itemized data into their respective categories on the running tally page. After you've summed up your revenue & expenses on that page you can feed it onto the front page by typing in the equals sign into a relevant cell on the front page and then match it to the category on the running tally page. Once aggregated, you can divide the totals by the number of lunches held to find out how much you are averaging per lunch. As the semester goes along you can use the Actual Earnings (Projected) field see how well your estimated earnings are keeping up with what you budgeted for. On the last page you'll find a total profit loss statement with a graph showing how you did over the course of the year.

Hold 'em for Hunger: The Hold 'em for Hunger Accounting Template has the same budgeting and revenue & expenses tracking functionality as the Hunger Lunch document along with a few expanded features. Expenses and revenue have been split between pages and there is an additional sheet to list prizes. Expenses are divided pretty cleanly along committee lines with separate categories for Sponsorship, Sales & Marketing, Food & Prizes, and Event Planning. Subcategories divide up the larger categories into fields such as "Brochure Printing", "Fliers", and "T-shirts" giving you the option of added granularity. The Income sheet has similar budgeting function as the Hunger Lunch accounting template. You can vary both ticket price and projected attendance to see how it affects budgeted revenue & income. As ticket sales come in you can feed them in accordingly from the Running Tally sheet. The prize list is fairly self explanatory. Having it on the accounting document allows you to match up expected ticket receipts with prize valuation.

Generic Event: There are a wide variety of events that you can put on to raise money for your chapter. Possible events include swing dances, concerts, and/or cooking competitions to name a few. Each one of these events requires you to budget for certain expenses and track cash flows as they come in and out. Luckily the Generic Event Accounting Template is flexible enough to be used for any of these ventures. The format is very similar to the Hold 'em for Hunger template and it can be modified to suit the needs of your particular event.

Chapter Level: The Chapter Level Accounting Template gives you the birds eye view of venture and project finances. At the beginning of the fall semester, your chapter should come up with a plan of what ventures to run and budget for total venture revenues and expenses. On the front page you'll find inputs for venture revenue & expenses along with profitability breakdowns for each venture. The second page contains chapter level expenses like NI t-shirts, equipment, and dues to the national office and revenue from chapter level activities like grants and seed money. Like in the other documents there is a Running Tally so you can keep track of chapter level inflows & outflows. The next sheet manages money going to projects. Here you can budget & record project costs & see how much money you'll have left over for the beginning of the next year. The profit and loss summary surveys your chapters finances from the beginning of the year to the end. In the first field you'll find beginning cash. This is the amount of cash you started with on hand carried over from the previous year. After subtracting total chapter revenue & expenses you can see what you have available for projects and after subtracting project expenses you'll come up with retained earnings, or what's actually left over for the next year.

Managing your Budget

Once your chapter has finalized a budget, refer to it often and update it as needed. Your chapter will better stay on track toward reaching its goals if it maintains a budget that accurately reflects income and expenses. It is fiscally responsible to make every attempt to stay within your set budget; fiscal responsibility will aid your chapter’s future financial planning.

While the treasurer & financial officers are the primary managers of financial matters, it is important that more than one person understands the financial operations of the chapter. A lack of understanding could lead to disregard for paying bills and controlling expenditures. If more members understand revenue potential and expenditure constraints, they will be more willing to work within them.

While every member should understand the budget, only a few people in your chapter should be authorized to handle financial transactions or access your account. Maintaining monthly financial reports and documentation could help divert a financial disaster, so your treasurer should keep a record of all deposits and expenses for comparison to your bank statments. At the chapter level the treasurer is responsible for tracking the chapter budget dispersing funds for venture expenses. At the venture level the finance committee crafts the venture budget and handles all of the finacial transactions.

Cash Handling Procedures

Segregation of duties is an important component of the internal control environment and helps prevent errors and fraud. The ideal set of procedures would separate the following functions of the cash handling process:

1.Collecting cash and other payments

  • Handling payments and entering transactions into the cash register system
  • Preparing manual check listing, manual cash receipts ledger, or preparing multiple-copy receipts.
  • Preparing daily cash balancing of cash register or cash drawer.
  • Performing reconciliation of credit card receipts.

2.Depositing and recording

  • Preparing bank deposit and deposit slip.
  • Maintaining accounts receivable records (if applicable).

3.Control activity

  • Reviewing daily cash balancing cash register or cash drawer.
  • Comparing daily cash balancing report, listing of checks, and other manual reports to bank deposit.
  • Comparing cash register report to bank deposit.

For example, at every Hunger Lunch, there should be one person who is responsible for collecting cash, checks and one cards. That person also will record income into the accounting template. Another person, the Treasurer or the Finance Committee Chairperson, will be incharge of making the deposit into the bank account. A third person,possibly one of the co-chairs, will be responsible for comparing the accounting sheets to bank statements. By separating all of these duties you will ensure proper controls over your chapter's finances.

Contacts

Personal tools