Budget Module Processing

1
Budget Module Processing

• Kathy Thurman, Director
• MTSU
• Budget and Financial Planning

2
Banner Mod TBR-044

• The primary objective of the TBR-044 was to
  develop a set of reports, and an extract file for
  TBR, that would replace the FRS Budget Module.
• There are 2 new forms and 18 reports that make up
  the Banner Budget Module.
• Reports are submitted using Banner Job
  Submission.
• The budget data is stored in Budget Phases which
  correspond with the columns on the reports.

3
Budget ID and Budget Phases

• Budget IDs equate to the fiscal year. There is
  only one ID per year. This ID is used on HR and
  FI. This year the ID is FY2008.
• Budget Phases contain the data for the columns in
  the budget document.
• The TBR prototype for the budget module
  pre-installed Budget IDs (FTVOBUD) and Budget
  Phases (FTVOBPH).

4
FY2008 Phases
The Budget ID and Phases are accessed in Banner
via FTMOBUD

• 075A Actual FY 06-07
• 081O July Original Budget FY 07-08
• 082R Revised Budget FY 07-08
• 083E Estimated Budget FY 07-08
• 084P Proposed Budget FY 07-08
• Other phases can be added as needed
• HR uses LBR08

5
Budget Phase Flowchart
Budget ID FY2007
July 07-08 Budget phases
Actual 05-06 065A
Oct 06-07 072R
Estimated 06-07 073E
July 07-08 084P
Amounts rolled from FY2007 084P to FY2008 081O
Budget ID FY2008
October 07-08 Budget phases
Actual 06-07 075A
July 07-08 081O
Oct 07-08 082R
Budget ID FY2008
July 08-09 Budget phases
Actual 06-07 075A
Oct 07-08 082R
Estimated 07-08 083E
July 08-09 094P
6
October Budget
The October Budget document contains 3 columns
(Banner Phases)

• Prior Year Actual (FY 2006-07)
• July Original Budget (FY 2007-08)
• October Revised Budget (FY 2007-08)

7
Loading Prior Year Actual data

• Key the data via FBABDRA (replacement for FRS U03
  screen)
• Spreadsheet Budgeting
• Download 06-07 operating ledger YTD Activity.
• Upload it to 075A phase by matching the YTD
  Activity column in the spreadsheet to the Budget
  Amount in the phase.
• Beware of terminated FOAPALs!

8
Loading the July Budget Phase
Method 1

• If Banner was used to create the July budget, it
  will be in Budget ID FY2007, Phase 084P.
• Move the data to FY2008, Phase 081O using FBABPRC
  to setup the parameters followed by FBRBDBB to
  roll from one phase to another.

9
Loading the July Budget Phase
Method 2

• Spreadsheet Budgeting
• Download the operating ledger Adopted Budget.
• Upload it to 081O phase by matching the Adopted
  Budget column in the spreadsheet to the Budget
  Amount in the phase.

10
October Budget MTSU method

• Enter budget revisions in the operating ledger
  using BD02 or BD04 transactions (FGAJVCD).
• Use FBABPRC to set the parameters to roll the
  operating ledger budget (OPAL) to the October
  Phase (082R).
• Run FBRBDBB to move the data.
• Review using FBIBUDG or FBABDRA.

11
October Budget another method

• Use FBABPRC to set the parameters to roll the
  operating ledger budget (OPAL) to the October
  Phase (082R).
• Run FBRBDBB to move the data.
• Review using FBIBUDG or FBABDRA.
• Make changes using FBABDRA.
• Use spreadsheet budgeting to calculate the
  changes and update the operating ledger using
  FUPLOAD.

12
Ready to run reports!
13
New Form FZVALLC

• Pre-installed values for fund balance, approved
  allocations, and restricted revenues and
  expenses.

N not on FZMTBRB
14
New Form FZMTBRB

• Used for Forms I, II, and VIII

October populates July
ETSU and TSU only
Populates from Form II
Subtotals recalculate
15
Forms I thru VIII

• Run using job submission
• Instructions are on the UOM drive
• https//umdrive.memphis.edu443/xythoswfs/webui/_x
  y-4047672_docstore1-t_16zBsYBG
• Folder MODS
• TBR-044
• Functional Specifications
• Web Virtual Classroom Training

16
New Report FZRAVER

• Comparison Report to be sent to TBR
• In July, this report must be run twice.
• Compare Estimated and Proposed
• Compare Revised and Estimated
• In October, only run one time.
• Compare Original and Revised
• Reports or -10 variance, or when one value is
  zero.

17
FZREDIT

• Replaces FRS Edit FBAT20
• Runs all of the reports, creates the extract file
  to be sent to TBR, and checks for errors.
• Be sure all errors are fixed before sending the
  file to TBR.

18
Questions ??