1 / 73

Banner Finance 201

Banner Finance 201. Presented by Roz Kieschnick & Paige Smith. Course Goals. Review Banner Finance 101 Query information to limit data results Understand data presented from various INB finance screens Extract data to Excel to aid in analysis Run reports . Basics. Runs in 2 windows:

cricket
Télécharger la présentation

Banner Finance 201

An Image/Link below is provided (as is) to download presentation 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Banner Finance 201 Presented by Roz Kieschnick & Paige Smith

  2. Course Goals • Review Banner Finance 101 • Query information to limit data results • Understand data presented from various INB finance screens • Extract data to Excel to aid in analysis • Run reports

  3. Basics • Runs in 2 windows: • The one you see and work in • Behind the scenes control window • Can have more than one ‘set’ open

  4. LOV (List of Values) Banner Products Custom Links Direct Access Field Auto Hints/Error Messages Basics (continued)

  5. Prev Block (Ctrl+PgUp) Next Block (Ctrl+PgDwn) Exit or Cancel (Ctrl+Q) Next Record ( ) Save (F10) Remove Record (F10) Rollback (Shift-F7) Enter Query (F7) Print (Shift+F8) Cancel Query (Ctrl+Q) Insert Record (F6) Previous Record (Shift+F6) Not Currently Used Help Execute Query (F8) Basics (continued)

  6. Forms • All Banner forms have seven characters • Example: FGIBDST • Naming Convention • The first letter of the name identifies the primary system (product) in Banner which owns the job, report, form or table. • (F = Finance).

  7. Forms (continued) • Naming Convention • The second letter of the name identifies the module in Banner that owns the job, report, form or table. • (G = General Finance) • For your purposes, G will be the only module you will use. • All Banner forms have seven characters • Example: FGIBDST

  8. Forms (continued) • Naming Convention • The third letter of the name identifies the type of job, report, form or table. • (I = Inquiry) • All Banner forms have seven characters • Example: FGIBDST

  9. Forms (continued) • Naming Convention • The last four letters of the name is the name of the job, report, form, or table. • (BDST = Budget Status) • All Banner forms have seven characters • Example: FGIBDST

  10. Queries • Wild Cards are characters used in queries to represent one or more unspecified characters. • The percent character (%) represents any number of unspecified characters. • The underscore character (_) represents one occurrence of an unspecified character.

  11. Financial Data (FGIBDST) • Accessed by inputting the seven-character form name in the ‘Direct Access Field’.

  12. Financial Data (FGIBDST)

  13. Financial Data (FGIBDST) • FGIBDST – Budget Status Screen • Provides the Budget Available Balance for Budget Funded FOPs: • 110100, 110200, 140100, 15XXXX, etc • Grants • Used to obtain Operating Ledger transaction information for Budget funded FOPs • *To obtain the available balance, you must ‘uncheck’ the “Include Revenue Accounts” checkbox.*

  14. Financial Data (FGIBDST) • FGIBDST – Budget Status Screen • In the Chart Field, ‘S’ (capital letter S) defaults • Current Fiscal Year Defaults, change year if a previous fiscal year is desired. • Enter your Fund-Org combination without the Account or Program codes filled in; these will act as ‘filters’ rather than displaying the entire data. • Click ‘Next Block’ or Ctrl+PgDwn to populate form. • Data is displayed by Account Code for each line item. • “Net Total – Available Balance” equals your available balance, which consists of your total budget less any year-to-date activity. Year-to-date activity includes salaries and other expenditures, less money set-aside for purchase orders.

  15. Financial Data (FGIBDST) • FGIBDST – Budget Status Screen • ‘Type’ • R=Revenue • L=Labor • E=Expense • T=Transfer • Transfers IN show as negative amounts and vice-versa for transfer OUT. • ‘Adjusted Budget’ • Spending authority granted by the Budget Office. • Three digit accounts are ‘Budget Pools’ and hold the budget for their corresponding groups of expense Account Codes (i.e. 710, 720, etc.) • Budget pools cannot have transactions posted against them.

  16. Financial Data (FGIBDST) • FGIBDST – Budget Status Screen • ‘YTD Activity’ • This column displays all of the actual expenses incurred in the selected fiscal year. • ‘Commitments’ • All encumbrances for the selected fiscal year are displayed here and summed in the ‘Net Total’ cell at the bottom. Once a requisition has been approved then it will appear on FGIBDST, However, funds are reserved or set aside to cover a possible purchase on FGIBAVL before requisition is even completed. • ‘Available Balance’ • This column displays the net affect of each row (Adjusted Budget-YTD Activity-Commitments=Available Balance). • If the bottom right Available Balance cell is empty; ‘rollback’ (shift+F7) and uncheck the ‘Include Revenue Accounts’ check box. Ctrl-PageDown again, and the Available Balance will be displayed.

  17. Financial Data (FGITRND)

  18. Financial Data (FGITRND) • FGITRND – Transaction Detail Screen • Can be directly accessed through Banner Start Screen, or while in FGIBDST, using Options or pressing F3 brings you here as well. • Provides detailed information for all ‘accounts’ (Operating Ledger only)

  19. Financial Data (FGITRND) In the top block, you can limit query by Fund/Org & even Account

  20. Financial Data (FGITRND) After hitting “next block”, you can see your results, or start a new query… Query using Wildcards or query on specific account

  21. Financial Data (FGITRND) Hit F8 or the “Query” icon to execute your query. You can start a new query by hitting the “Enter Query” icon or use the F7 short cut. A wildcard query for “73%” returns all transactions on account codes beginning with 73…for this Fund/Org

  22. Financial Data (FGITRND) You can query by account code budgeted pools (710,720,750..) and this provides the totals of all transactions for the specified pool, however it will not show each individual account code with in that pool.

  23. Financial Data (FGITRND) Hit F8 or the “Query” icon to execute your query. You can start a new query by hitting the “Enter Query” icon or use the F7 short cut. F3 brings the individual document information. You can use next block to view the detail.

  24. Financial Data (FGITRND) • FGITRND – Transaction Detail Screen • ‘Activity Date’ • Date the transaction occurred • ‘Type’ • Four digit ‘Rule Code’. See below for common codes: Please refer to Legacy for Detail on Transactions prior to 01/01/2011.

  25. Financial Data (FGITRND) • FGITRND – Transaction Detail Screen • ‘Activity’ and ‘Location’ • Not currently used. • ‘Field’ • ENC=Encumbrance (Funds are dedicated or set aside for the payment of a purchase after the Purchase Order is cut.) • YTD=Year to Date (Actual expense) • F3 drills down even further to the document level.

  26. Financial Data (FGITBSR)

  27. Financial Data (FGITBSR) • FGITBSR – Trial Balance Summary Form • Provides the Current Balance for Fund Balance accounts. • To obtain available balance, the encumbrances (account 314100) must be subtracted from the ‘current fund balance’ cell at the bottom of the form. • If ‘D’ is displayed in the ‘D/C’ column to the right of the current fund balance cell, the fund is in deficit. • Displays only General Ledger data • If looking for Transaction Detail, use FGIBDST. • F3 drills down to see G/L detail only.

  28. Financial Data (FGITBSR) • FGITBSR – Trial Balance Summary Form • In the Chart Field, ‘S’ (capital letter S) defaults • Current Fiscal Year defaults, change year if a previous fiscal year is desired. • Enter your Fund, the account code field can be left blank. • Click ‘Next Block’ or Ctrl+PgDwn to populate form.

  29. Financial Data (FGITBSR) • FGITBSR – Trial Balance Summary Form • ‘Acct Type’ • ‘Account’ • General Ledger accounts – Basically a summary of all the Operating Ledger Accounts.

  30. Financial Data (FGITBSR) • FGITBSR – Trial Balance Summary Form • ‘Beginning Balance’ • Dollar amount as of the beginning of the fiscal year, listed by account code. • ‘D/C’ • Debit or Credit • Accounting 101 • ‘*’ • Denotes amount is opposite of normal balance.

  31. Financial Data (FGIENCD)

  32. Financial Data (FGIENCD) • FGIENCD – Encumbrance Detail Activity • Shows transaction detail and remaining balance of encumbrances. • Enter encumbrance and Click ‘Next Block’ or Ctrl+PgDwn to populate form. • Note that the second ‘block’ may have multiple items in it. Press the down arrow when in this ‘block‘ to view them. • Ctrl+PgDwn navigates to the last ‘block’. • Displays all activity that has occurred against a given encumbrance (Invoices, checks, change orders, etc.) • Very last line shows the remaining balance of the encumbrance.

  33. Financial Data (FAIINVE) • FAIINVE – Invoice Query • Displays all information for a given invoice. • Enter document number and Click ‘Next Block’ or Ctrl+PgDwn to populate form. • Ctrl+PgDwn displays additional invoice information. • Invoice • Commodity Information • Accounting Amounts • Balancing/Completion

  34. Banner Finance Reports FGRBDSC & FGRODTA

  35. FGRBDSC is a Banner report for current period budget status. This report will list summarized activity based on entered parameters. NOTES: Use the next block icon, when moving between the yellow lines. Printer controls block, you must enter DATABASE in all CAPS for the report to run properly. DATABASE must be entered in all CAPS

  36. BANNER FINANCE: FGRBDSC – Parameter Values1. In Fiscal Year field, type current fiscal year – 11.2. In Chart field, type a capital “S”.3. To Fundand From Fund, if running just one fund, enter the same fund (six digit number).4.To Organizationand From Organization need to be the same six digit number, unless you want a conclusive look at several orgs with in the same department; however the orgs must be consecutive number sequence. Enter the SAME FUND/ORG for the TO and FROM range.

  37. BANNER FINANCE: FGRBDSC – Parameter Values..continued….5. To Account Code and From Account Code you can leave blank if you would like to see all account codes However you can also specify an account code if you would only like to see a certain one or a specific range of account code. You can also type a specific budget pool (710, 720, 750..).6. As of Date field, will always default to current date. Keep or change date to what you need.7. Include Accrual Period defaults to Y, Print Reports Totals defaults to Y, and Print Net Totals defaults to Y. In the Commitment Type field, leave blank to see all commitment types. Leave ACCOUNT codes BLANK, this will generate ALL the codes to appear on the report Banner provides a help line of what to enter for guidance

  38. 8. Click Next Block to move to the Submission block. If you click the box “Save Parameter Set as” you are able to save the parameter values ,so you can run the report again for the same fund/org, which will be found in the Parameter Set field on the first block. Keep in mind you will need to change the date.

  39. 9. After you have checked the Save Parameter Set as box, then click SAVE from toolbar icon. 10. A window will pop-up alerting you that the parameters are now set as a default. Click OK.

  40. 11. After you click SAVE, this will clear the screen and it will look as it did at the beginning.

  41. 12. Now click on Options, then Review Output.

  42. 13. On this next screen, double click on the File Name field. NOTE: Sometimes the report is still running, so the Number field will be highlighted, please tab to File Name and if the report has completed the cursor will appear in the File Name field at which point you can double click and proceed in retrieving the report.

  43. 14. Then choose the file name ending in “.lis” from the available files. Click OK.

  44. 15. Here is the report. You may scroll down by using the page down button on your keyboard or use the scroll bar on the side of the report. Do NOT use your Mouse to scroll through the report.

  45. 16. To get a printable and savable report, click on Options, then Show Document (Save and Print File).

  46. 17. When asked if you are ready to save, click Save File.

  47. 18. The report will be saved to your s: drive. Which is the message that will pop-up along with the .lis file name. Click OK to complete.

  48. 19. You must close the pop-up window after you have saved the file. To retrieve the report you will then need to find the fgrbdsc_#xxxxxx.lis file on your S: Drive.

  49. 20. Open your S: drive and sort by date to find the latest file fgrbdsc_#xxxxxx.lis file on your S: Drive.

  50. 21. Your report should open in WordPad. If you are asked to “select program from list” to open your file, choose WordPad.Your printable report will look like this (change print preferences to landscape before printing):

More Related