INTRO

1. INTRO education solutions development inc. Budget Development 1.0 ANUA 2011, Ft. Lauderdale

2. SLIDES Budget Entry Preparation • Setup new fiscal year and roll forward accounts • Setup new fiscal year • Run batch job Finance new Fiscal Year Setup • Bring forward Accounts • Run batch job Finance Build New Year Account • Current Budget Year parameter.

3. SLIDES Budget Entry • Two Methods for Budget Preparation in APECSNET • Mass Entry of Budget Screen • Budget Request System • Both Methods use the same data tables, therefore both method can used together.

4. SLIDES Budget Entry

5. SLIDES Mass Entry of Budget • Account Selection For Data Entry By • Responsibility Group • By Account Elements • Control Account Number • Combination of Responsibility Group and Account Elements • Addition Sort Options • Option to Exclude Payroll / Benefit Accounts • ‘Print’ function to generate report of selected accounts

6. SLIDES Mass Entry Of Budget • Budget Entry • Distributed Online • Locations enter their own budget • Account Security by Responsibility Group or Location • Enter Budget for Selected Accounts on screen • Totals are shown as budget is entered • Distributed Print out (Budget Booklet) • Print Budget Booklet for each location from Online Screen or Budget Detail Report • Location writes Requested Budget on paper and send to Business office • Business office enters requested budget using Mass of Entry screen.

7. SLIDES Mass Entry Of Budget • Budget Entry (Cont…) • ‘Save to File’ and Budget Import Process • List selected accounts by entering search parameters • ‘Save To File’ to create a .csv (Excel) file • Distribute (email) Excel Sheets to budget coordinators • Budget coordinators enter budget on excel sheets • Budget Import process to import budget from excel sheet • ‘Save To File’ and Budget Import Process use same excel sheet layout for export and import

8. SLIDES Budget Request System • Completely Integrated into Finance System • Security By Responsibility Group • Account Level comments • Detail Screen for • Supplies Accounts • Payroll Accounts • Benefit Accounts • Allocation By Responsibility Group

9. SLIDES Budget Request System

10. SLIDES Budget Request System • Interface to Transfer Payroll Budget • Interface To Transfer Benefit Budget

11. SLIDES Budget Request System • Account Selection By • Budget Responsibility Group • Additional Filters By Account Elements • Combination of Responsibility Group and Account Elements • Sort Options • Option to Exclude Payroll / Benefit Accounts • ‘Print’ function to generate report of selected accounts • ‘Save To File’ and Budget Import as described for Mass Entry of Budget are available in Budget Request system also.

12. SLIDES Budget Request System • Detail Screen for Supplies • Optional entry of details for budget • Accounts can be marked as where Details are always required • Interface with warehouse catalog to facilitate ordering of same items by different locations • Detail Screen for Payroll • Payroll Data is transferred from Payroll using batch process • User can add new positions with budget amounts • User can delete existing positions for budget purpose • Any Change to Salary data in Budget system will not update Payroll system.

13. SLIDES Budget Request System • Security By Responsibility Group • Location can see only their authorized accounts • Business administrator can see all accounts

14. SLIDES Payroll Budget Interface • Batch Process ‘Budget HR/Salary Transfer’ to import salary data to Budget System • Option to use current year or next (budget) year payroll data • Option to budget based on current or next year salary • Process can be run multiple times, each time will replace the data except for that entered or modified in budget system.

15. SLIDES Report and Batch Programs • Budget Detail Report (under Batch menu) • Selection By multiple account elements ranges and/or Responsibility Groups • Grouping by Responsibility Group and/or Account Elements • User Defined Page Break • Option to print Single or 2 lines per account • Option to print ‘Comments’ • Option to leave Next year budget column as blank for Manual data entry • Option to print Summary Report at selected grouping level

16. SLIDES Reports and Batch Programs • Budget Supply/HR Detail (under Batch menu) • Prints budget details entered on Supply and Payroll Details screens • Budget Import • To import budget from an excel sheet • Supports 2 input layout (sample layout are available with job) • Budget Rollover to GL • Moves Requested/Approved Budget to GL • Can be run multiple times, replaces the previous budget values