1 / 16

INTRO

INTRO. education solutions development inc. Budget Development 1.0. ANUA 2011, Ft. Lauderdale. 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

zurina
Download Presentation

INTRO

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related