BUDGET REPORTS FROM BANNER FINANCE - PowerPoint PPT Presentation

Antony
budget reports from banner finance l.
Skip this Video
Loading SlideShow in 5 Seconds..
BUDGET REPORTS FROM BANNER FINANCE PowerPoint Presentation
Download Presentation
BUDGET REPORTS FROM BANNER FINANCE

play fullscreen
1 / 37
Download Presentation
BUDGET REPORTS FROM BANNER FINANCE
932 Views
Download Presentation

BUDGET REPORTS FROM BANNER FINANCE

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. BUDGET REPORTS FROM BANNER FINANCE Presented by Lesley Wilmeth, HSC Budget Office

  2. 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

  3. 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.

  4. Let’sTake a Look at Them

  5. http://webraider.ttuhsc.edu Webraider is the new portal Choose Cognos Reporting:UDEV

  6. Cognos Home Page

  7. Choose the Budget folder

  8. Budget Folders

  9. Budget Financial Reports Highlighted Reports are your starting point.

  10. Budget Financial Reports OPAL and TRANH you can drill to from the BAVL Report

  11. 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

  12. Budget Financial Reports

  13. Choose Chart of Account “H”

  14. Choose other parameters and Finish to run the report

  15. BAVL Report – Budget Available Balance Budget Account Code Like the TFIM object code. Summary level. Fund and Budget Control Orgn

  16. BAVL Report – Budget Available Balance Original Budget Current Budget: (contains budget revisions processed during the fiscal year)

  17. BAVL Report – Budget Available Balance Actual expenditures and encumbrances

  18. BAVL Report – Budget Available Balance Uncommitted shows what is available to spend

  19. BAVL Report – Budget Available Balance Pending transactions: Transactions in process, but not approved and posted. These go against your available balance.

  20. 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.

  21. BAVL Report – Budget Available Balance Click on underlined fund for more detail. This takes you to the OPAL report.

  22. OPAL Report – Operating LedgerMore detailed information Data entry organization. More detailed information.

  23. OPAL Report – Operating LedgerMore detailed information Now we see expenditure account codes. Similar to TFIM subobject code. More detailed information.

  24. OPAL Report – Operating LedgerMore detailed information Click on an amount to see transaction detail.

  25. Transaction History – Transaction level dataMost detailed information Detailed information by document number. Transaction description is included.

  26. 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.

  27. Lowest level of detail – Payroll HistorySecurity Applied (Budget HR Report)

  28. QUESTIONS?

  29. Budget Financial Reports

  30. 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.

  31. Budget and Data Entry Account Codes

  32. Budget and Data Entry Account Codes

  33. Budget Financial Reports

  34. 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

  35. Organizational Listing

  36. Organizational Listing

  37. QUESTIONS? Call the HSC Budget Office if you have questions. 743-2969