DOC

Budget Rollup

By Lawrence Rose,2014-12-13 09:58
9 views 0
Budget Rollup

    Georgetown University

    Budget Report Training

    Budget Rollup Report

1. Navigate from

    a. Go > Process Financial Information > GT Financial Planning

    b. Report > Budget Rollup > Update/Display > Enter run control ID or select OK and

    choose run control ID from list.

    Note: Select ADD instead of Update/Display the very first time the report is requested so

    that a run control ID may be created.

2. Complete the request parameters:

    ; Budget Period (required) enter the appropriate fiscal year

    ; Accounting Period enter the appropriate accounting period (during budget

    development period is not tracked. Enter 12)

    ; From/To Account are used to restrict account codes selected. If left blank all

    accounts between 50000 and 99999 are selected.

    C:\convert\temp\106567972.doc 1 of 6

    Budget Rollup Report

    Level of Detail. Select one of the first four options and/or Show Recruitment, Suppress Non-Operating. Important: You must select one of the first four options to get data. If none is selected, you will not receive an error message saying that one is required. This means you can run the report, but the output will not make sense.

    ; Summary returns accounts rolled up to the xx000 level.

    ; Sub-Summary - returns accounts rolled up to the xxx00 level.

    ; Account - returns actual accounts as budgeted.

    ; Financial Plan Categories - returns the presentation used by the budget office for

    operating plans.

    ; Show Recruitment this option pulls account code activity for cost centers

    designated as recruitment centers and displays the totals below the operating net.

    ; Suppress Non-Operating - this option suppresses non-operating results.

    Columns. Select one of the six options. Important: You must select one of these options to get data. If none is selected, you will not receive an error message saying that one is required. This means you can run the report, but the output will not make sense.

    ; Original Financial Plan The Board approved plan created in January; display 4

    plan years and year-end projection.

    ; Revised Financial Plan - The plan for the coming year built in December; display 4

    plan years and year-end projection.

    ; New Original Budget Useful when reviewing the new Original Budget in

    November- December timeframe.

    ; Year-End Projection Useful when preparing year-end forecast in November-

    December timeframe.

    ; Operating Results Useful for monthly review of CAB to actual activities.

    ; CAB Development - Useful when preparing CAB. Report shows OAB and CAB for

    development year, OAB/CAB for prior year, and Actuals from two years prior.

     C:\convert\temp\106567972.doc 2 of 6

    Budget Rollup Report

Filters:

    ; Campus Allows you to narrow output by campus. Use the drop-down arrow to see

    the list of campuses. Double-click the campus needed.

    ; School Allows you to narrow output by school. Use the drop-down arrow to see

    the list of schools. Double-click the school needed.

    ; Division Allows you to narrow output by division. Use the drop-down arrow to see

    the list of divisions. Double-click the division needed.

    ; Department - Allows you to narrow output by department. Use the drop-down

    arrow to see the list of departments. Double-click the department needed.

    ; Program Allows you to narrow output by program. Use the drop-down arrow to

    see the list of programs. Double-click the program needed.

    ; Cost Center - enter a cost center or partial cost center with wildcard (%) to limit

    results to a single cost center or group of cost centers. Otherwise leave blank.

Fund Centers: Select one or more fund centers to include in the output. If none are

    checked ALL fund centers are included.

     C:\convert\temp\106567972.doc 3 of 6

Budget Rollup Report

    Output Options:

    ; Cost Center Detail one report for each cost center

    ; Fund Center Totals one report per fund center

    ; Total Page one grand total report for all centers in criteria

    ; (in Thousands) displays a rounded to the nearest thousand. For example,

    34,311 would display as 34.

    Subtotals by Use these options to obtain separate reports into the hierarchy levels.

    None: No hierarchy subtotals Campus: Campus subtotals

    School: School subtotals Division: Division subtotals

    Department: Department subtotals Program: Program subtotals

    3. Initiate the report by selecting the ‘run’ button (stoplight)

    4. Run the report to the printer or to the file.

Original Financial Plan

     C:\convert\temp\106567972.doc 4 of 6

Budget Rollup Report

Revised Financial Plan

New Original Budget

     C:\convert\temp\106567972.doc 5 of 6

Budget Rollup Report

Year-End Projection

CAB Development

     C:\convert\temp\106567972.doc 6 of 6

Report this document

For any questions or suggestions please email
cust-service@docsford.com