The Budget Template is a CSTA product in partnership with Organisports

1. The Budget Template is a CSTA product in partnership with Organisports

2. What does the budget software accomplish? • Breaks down the revenues and expenses into 2 distinct columns: CASH and VIK • The program is divided into 3 main tasks: • Producing a budget with main reports; • Restructuring the budget in various configurations for specific reports • Creating a budget follow-up process.

3. Producing a budget that: • Outlines a budget structure identifying all the necessary potential budget items in Cash and VIK, You just have to input the quantity and the unit cost; • Identifies for each VIK budget line who will be the eventual providers; • Identifies for each budget line if it is taxable or not; • Identifies for each budget line if the transaction was originally converted from foreign currency; • Includes percentage (%) parameters ensuring that the established maximum expenditure is not exceeded; • Produce main reports

4. Restructuring the budget in various configurations • Permits to regroup similar items spread out over the entire budget for an eventual sponsor or supplier • Permit to regroup all the items from which an; authorities, institution, and a corporation will provide • Measure the economic impact in relation to the CSTA STEAM Model. • Permits the calculation of the return on taxes from each item;

5. Creating a budget follow-up process that: • Manages the cash flow; • Carries out budget tracking by imputing all expenses in the appropriate budget categories for the purposes of verifying if the allocated funds are sufficient to issue a purchase order; • Issue a purchase order • Track invoices received in relation to the purchase orders that have been issued. • Produced a report between what has been budgeted, spent and manage for the cash flow

6. Budget Structure Example • Division • e.g.: 01-01-00.000 Event Management • Sub-division • e.g: 01-05-00.000 Meeting expenses • Work package • e.g.: 01-05-01.000 Board of Directors • Example of objects within a work package • 683 Buffet prior to the events • 693 Non-alcoholic beverages • 694 Coffee The code for coffee in the Board of Directors work package would be: 01-05-01.694

7. Basic Budget Plan Template Version First task: Producing a budget

8. Welcome Page

9. Step 1: Input the information on your event

10. Step 2: Decide which work packages you will only use and input data

11. You can decide to cancel certain budget divisions, sub- divisions and work packages by using the button Not Used or, as shown, you can decide to open a specific work package.

12. Step 3 : Input of data for a work package that you need.

13. Each work package includes a list of all the possible objects in 2 columns (Cash or VIK): you select only the one that you need (Column: Qty and Price). For each object, you can also check if it is not taxable or if it was originally in a foreign currency. Also, for VIK objects, you can input who is the VIK provider.

14. Step 4: You can generate different kinds of budget reports: Example of the most detailed budget report.

15. You can use filters in order to select a specific section of the report.

16. Report according:– to the work package which you have kept; – the data that you have entered.

17. Step 5: You can decide to include a percentage above which you do not want to go.

18. Percentages can be set for all divisions and sub-divisions.

19. You can check in a report if you are over or not.

20. Red line = Work Package which is over the percentage projection.

21. You can change the name of an existing division or create a new one.

22. You can change the name of an existing sub-division or create a new one.

23. You can change the name of an existing work package or create a new one.

24. You can create new objects or include a cash or VIK value which will be automatically included in the entire budget structure. (ex. cost of coffee)

25. You can add new VIK providers. (authorities, institutions, corporations)

26. Basic Budget Plan Template Version Second task: Restructuring the budget in various configurations

27. You can automatically restructure your budget in a different configuration.

28. You can track similar objects spread out over the entire budget for a prospective sponsor or supplier.

29. You can select a specific object. (ex. coffee)

30. List of work packages where the coffee appears in your budget.

31. You can also have the total expense for coffee spread across your budget.

32. Knowing this amount, you can develop a proposal for a sponsor or sign a contract with a supplier.

33. You can generate budget reports by VIK providers which you have listed in the input of data section.

34. It is easy to have within one page all the VIKs that an authorities (City, governments), institution or a corporation should provide to your event.

35. You can generate a budget report according to the CSTA STEAM Model.

36. Then you can input these numbers in the STEAM software to know the economic impact of your event. (without visitor spending)

37. You can generate budget reports for the objects which you have inputted as non- taxable.

38. It is then easier to calculate how much tax return your event will receive.

39. You can generate budget reports by the objects which you have inputted as in a foreign currency. (Ex. $US or $Euros)

40. It is then easier to adjust your budget according to the changes in the Canadian exchange rate.

41. Advanced Budget Version 3rd task: Creating a budget follow up process Cash flow module

42. Step 1: Input your cash flow period for the event.

43. Step 2: Input Cash Flow

44. For each work package with cash amount: input your cash flow.

45. Once your cash budget has been set, you just have to select the cash flow option buttons.

46. Cash Flow Reports

47. Total cash flow per month for your event.

48. Report per month for a specific work package.

49. Details of a work package cash flow.

50. You can also check your cumulative cash flow amount for the current month.