BUDGET REPORTS FROM BANNER FINANCE Presented by Lesley Wilmeth, HSC Budget Office
Budget Reports Purpose • Provide departments with a view of their available balance for spending • Allow drill through to spending and budget detail • Help departments understand Budget Account Codes and Banner Organization Codes
Budget vs other Finance Reports • How are the reports developed from the Budget Office different than those already presented? • View is from the perspective of what is budgeted – not necessarily what has been spent. • Reports are delivered based on the organization (department) code. • Future Budget Reports will contain position/employee information.
http://webraider.ttuhsc.edu Webraider is the new portal Choose Cognos Reporting:UDEV
Budget Financial Reports Highlighted Reports are your starting point.
Budget Financial Reports OPAL and TRANH you can drill to from the BAVL Report
BAVL Report: Budget Available Balance • Choose the Organization Code you wish to view. • Data will be displayed in a Summarized Available Balance Level • No detail on this report. • Very similar to OLEB screen in TFIM or the summary portion of your current ledger sheets. • Shows how much is left to spend
BAVL Report – Budget Available Balance Budget Account Code Like the TFIM object code. Summary level. Fund and Budget Control Orgn
BAVL Report – Budget Available Balance Original Budget Current Budget: (contains budget revisions processed during the fiscal year)
BAVL Report – Budget Available Balance Actual expenditures and encumbrances
BAVL Report – Budget Available Balance Uncommitted shows what is available to spend
BAVL Report – Budget Available Balance Pending transactions: Transactions in process, but not approved and posted. These go against your available balance.
BAVL Report – Budget Available Balance If you see the word BAVL it means the available balance is held at the Fund/Orgn level only. Not down to the account code.
BAVL Report – Budget Available Balance Click on underlined fund for more detail. This takes you to the OPAL report.
OPAL Report – Operating LedgerMore detailed information Data entry organization. More detailed information.
OPAL Report – Operating LedgerMore detailed information Now we see expenditure account codes. Similar to TFIM subobject code. More detailed information.
OPAL Report – Operating LedgerMore detailed information Click on an amount to see transaction detail.
Transaction History – Transaction level dataMost detailed information Detailed information by document number. Transaction description is included.
Transaction History – Transaction level dataMost detailed information If account code begins with “6”, it is a salary code. Payroll history can be run by clicking on the symbol next to the dollar amount. This drill through will only work if security has been granted. Payroll history will not be available until HR go-live.
Lowest level of detail – Payroll HistorySecurity Applied (Budget HR Report)
Budget and Data Entry Account Codes • Budget Account Code • Budget Account Code is similar to TFIM object/revenue code • Expenditure/Revenue Account Code • Expenditure/Revenue Account Code is similar to TFIM sub-object/sub-revenue source code • Report lists all Budget Account Codes and which expenditure account code will use that budget.
Organizational Listing • Will list every Organization Code in your Department • Contains Expenditure Orgn Code – cost center/sub-department level • Shows the Budget Control Orgn – this is where the Budget Available Balance is held
QUESTIONS? Call the HSC Budget Office if you have questions. 743-2969