Transcript Reading Budget Balances in Banner and Other Related Budget Information HRD Class CT250

Reading Budget Balances in Banner
and Other Related Budget
Information
HRD Class CT250
Topics for Discussion

Banner Self Service (SSB)
–
–
–
–

Budget Queries
Transfers (Regular & Multi-Line)
Document Approvals
View Documents
Banner Admin (Admin)
– Budget Status (FGIBDST)
– Pool Balances (FGIBAVL)
– Cash Balances (FGITBAL, FGITBSR)
Budget Queries



Budget Status by Account
Budget Status by Organizational
Hierarchy
Budget Quick Query
Budget Queries (cont.)
10 Total Operating Ledger Data Columns
 Adopted Budget (Original Budget - BD01)
 Budget Adjustment (AU04, BD04)
 Adjusted Budget
 Year-to-Date
 Commitments
 Available Balance
Budget Queries (cont.)
Query Information
 Fiscal Year
 Budget Period
 Comparison Columns
 Chart
 Fund/Org
 Wildcard
 Revenue
Reading Balances
Formula for calculating balance:
(Adjusted Bud) +/- (Year to Date) +/(Commitments) = Available Balance
Budget Status by Account
Budget Status by Org.
Hierarchy
Downloading Information
into Excel



Downloading selected ledger columns
“Taking out the trash”
Formatting the excel file
Budget Transfers

Regular
– Date
– Type
– Transfer Amount
– Chart
– Fund, Org, Account, Program
– Description
– Budget Period
Budget Transfers (cont.)

Multiple Line
–
–
–
–
–
–
–
–
–
Date
Type
Document Amount
Chart (Each line)
Fund, Org, Account, Program
Amount
Sign Indicator
Description
Budget Period
Document Approvals



Documents awaiting your approval
Documents you can approve
Disapproving documents
Viewing Documents



Drop-down box
View the document
View the history
Budget Status (Admin)

FGIBDST
– Org comes before fund
– No original budget
– Revenue box must be checked to see
revenue
Budget Availability Status

FGIBAVL
– Must use lowest pool account number for
your org
– Fund comes before org
– Revenue cannot be seen in this screen
– Balances by pool
General Ledger Balances

FGITBAL
– Only look at these if you have stand-alone funds
(no base or other unrestricted funds)
– Claim on Cash (11000)
– May have to add or subtract due to/due from
balances

FGITBSR
– Gives you one fund balance total at bottom of
screen
General Ledger vs.
Operating Ledger


Comparing balances
Who to contact
Other Topics






Budget Status Reports (FGRBDSC)
Organizational Detail Reports
(FGRODTA)
Budget Carryover
Position Control (NBAPBUD)
My Banner
Other Resources