Financial Liaison Meeting November, 2008 Role of the Liaison Be the primary financial contact (connecting link) between the Business Office and the college or college-level unit Facilitate enhanced communication and feedback to Business Office of immediate needs and concerns in unit
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Financial Liaison Meeting
Extract BC1 transactions for Unrestricted funds (10x001 – 10x003) no cost shares
Extract year end fund balances by org hierarchy for gifts, expendable endowments, unexpended plant funds and R&R plant funds
Compare Reserves by Unit to Prior Year
Information Provided to Administration, College Deans, Provost & Vice Presidents
Summary Data Available to Provost, EVP, Business Office – Total Reserve
Summary Data - Comparison of Current Year Unrestricted to Prior Years
More Summary Data – Comparing Other Reserve Balances to Prior Years
DATA by COLLEGE Provided to Dean & Financial Liaison-Unrestricted by FOAP
DATA by COLLEGE Provided to Dean & Financial Liaison-Other Unrestricted by Fund
Key Reports for Monthly Use:
FGRBDSC – Budget Status Report (YTD accumulation by account within Fund/Org) Available on demand or in e~Print
FGRODTA – Daily Transactions (monthly detailed transactions excluding payroll distribution) Available on demand for extended periods or monthly reporting in e~Print
Grant Inception to Date (C&G reporting FRRGITD…)
Payroll Distribution Reports (e~Print)
DISCUSSION FOR TODAY: New Base Budget Reports
Future 045 Replacement
Review of Organizational Hierarchy
A = Chart
1 = Division level
10 = Executive Level
100 = College or Major Unit
1000 = School
10000 = Department
100000 = Data Entryable Org
Drill down on most current report.
View just your area by using Magnifying glass or entire report using PDF.
Note drop down box: allows user to extract data by college, executive level or division
Select College, Executive Level or Division as Required (example: selected Executive Level 12)
Reports In Process continued:
Departmental Operating Summary (FRS 045 replacement)
Report is about 80% complete. Will be available to users monthly in
e~Print. Users will be able to extract data using Organizational
Hierarchy (College, School or Department).
Report will provide users with summary report of all fund-org
combinations. Quick access to the available balances and fund
balances by fund type.
All unrestricted information will be summarized within a department,
followed by contract & grant FRIGITD available balance & GL fund
balance. Restricted funds, plant funds (including R&R) will follow.
Report looks beyond just the operational ledger available balances.
If you have reporting needs, please provide a detailed sketch or marked up report lay out that can be forwarded to me for review (I will get with specific Business Office area to see if a report is already available or if there is consensus on need).
Remember Banner has numerous ways to get to your data. If this is something you require routinely, perhaps an automated report could be created.