Finance Reports by Business Cycle

Daily or As Needed - These reports can assist you in monitoring your indices, researching unusual charges, etc.

FNRIFOP - Hierarchies and Index Lookup
  • Elements - Fund, Organization, Program, and Activity (FOPA).
  • Use this report to view Banner Finance Indices and Organization Hierarchy.
  • Run by index to identify FOPA associated with your index.
  • Run by organization code to confirm the appropriate Financial Manager is associated with your org code.
  • Run by Fund, Organization, Program, or Activity to review the hierarchy of each element.
FNRLDST - Labor Distribution Report
  • Displays active or historical labor distributions.
  • Use this to view the breakdown of how salary is paid for your employees. Before submitting an index termination request, run this report (select Report Type: Active Distributions) to determine whether any employees are being paid from this index. If so, you can correct this before submitting the term request. For "shared" employees, you may not be able to submit labor redistribution requests when salary needs to be corrected - the Hiring Org column on this report shows the employee's hiring org. This can help you determine who to contact in order to request assistance with processing labor redistributions affecting your index.
FNRMBTA - Main and Branch Transfers Allocation
  • You enter the index you will be transferring or allocating funds from "index funds are coming from" and the index that will be receiving the funds "Index funds are going to".  This report shows you the rule class and account codes to use when transferring budget and actual funds.
  • Run this report before processing transfers or allocations to ensure than you are using the correct rule class and account codes.  It also provides notes on Budget Office requirements for the description - this report is very useful in helping you enter everything correctly so that your JV meets requirements and will not be rejected for rule class and/or account code errors.
  • Hierarchy Lookup button allows you to see the index FOPA elements such as fund, program and organization codes.
FNRPCARD - PCard Transaction Report
  • Displays PCard holder name and PCard charge information.
  • This can be used to research charges that post to your index.  If you see an unknown charge in Banner, you can look it up using this report to view more information on it.  If your department has multiple PCard holders, this report is very handy in identifying the person who placed a charge so that you know who to follow up with if you need more information on a charge.  Note that when reporting by Org, hierarchy is not included so you must select the exact org that the PCard charges fall under (e.g. you may need to search for the Level 6 org even if you're used to searching for Level 5).
FMRFAQR - Finance Approval Queue Inquiry Report
  • This report is specific to Banner Finance Approval Queues; users must have Banner Finance access to be an approver.
  • Provides you with a list of department approval queue IDs, queue limits and approvers.
  • You can run the list by Organization Code, Approval Queue ID, or an Approver's NetID.
  • Run by NetID to identify staff who have left the department.
FBRBAVL - Budget Availability Detail and Summary
  •  Very helpful in assisting departments to determine why an NSF situation exists.

Monthly - These reports can assist you in your monthly reconciliations

FOROLDS - Operating Ledger Detail and Summary
  • Displays detail or summary of budgets and actuals for your selection.  Can be run for a single month or fiscal year to date.
  • The Detail report will be your go-to report when performing monthly reconciliations.  Summary is useful for a quick visual of your budget vs. actual spending.
FOGOPER - Operating Ledger Guided Ad Hoc (Data Extract)
  • Guided ad hoc version of the FOROLDS Summary report.
  • If you are able to get everything you need from the published FOROLDS report, use that instead.  If you want more information than what is available in FOROLDS (e.g. comparing multiple fiscal years, etc.), use FOGOPER.  You only need to click through the tabs where you want to add filters.  Choosing HTML Active Report allows you to do some simple manipulations of the data for quick comparisons; for more detailed manipulations, recommended to output to Excel and use Pivot Tables for comparison.  A tutorial on Pivot Tables can be found on Lynda (log in with your NetID and password).
FNRSLBE - Salary Labor Benefits and Encumbrance Report
  • Displays information on salary and fringe.
  • This will be your go-to report when performing monthly reconciliations. Reviewing this report for your indices on a monthly basis will assist you in ensuring salary for your employees is posting to the correct indices.
FNRPCRD - PCard Transaction Report
  •  Displays PCard holder name and PCard charge information.
  • This can be very useful in reconciling your PCard statements and identifying any outstanding charges.  You can run this by your Banner ID for the month in question and can reconcile to the PCard statement.
FNGSLBE - Salary Labor Benefits and Encumbrance Guided Ad Hoc (Data Extract)
  •  Guided ad hoc version of the FNRSLBE report.
  • If you are able to get everything you need from the published FNRSLBE report, use that instead.  If you want more information, this guided ad hoc can be very useful.  Main benefit is the ability to run by an employee's current home org so you can easily view the salary for all of your employees.  Note that you will need to select all of your org codes, as hierarchy is not automatically reflected for this report.  Guided ad hoc also has the ability to calculate Fringe Rate.

Monitoring Restricted Indices (Contracts & Grants) - These reports can assist you with tasks specific to Contracts & Grants

FRRCGES - Contract and Grant Ledger Executive Summary
  • Displays a high-level overview for your grant organization.
  • Very useful in terms of getting a "big picture" of the restricted indices for your organization.  This report can be very useful in helping you monitor the spending rate on your organization's awards (i.e., burn rate).  It displays percent of budget used and percent of time used for each index.  This can help you in assisting your PIs in managing their expenditures to ensure that they are able to complete their research according to budget.
FORFAPI - F&A Generated by PO
  • Displays the total F&A generated by your organization or by PI.
  • Recently added the ability to query by PI.  Note that this is by the Principal Investigator - if your faculty member is a co-PI, indices will not be reflected on his/her report.  Many departments return a portion of F&A generated to the PI; this report provides you with the starting point for your calculations (the percentage distributed to the Colleges, the percentage of that distributed to your department, and your department's percentage distributed to PIs will then need to factor into your calculations).  Can also be useful as an indicator of faculty performance in terms of how much F&A is being generated by individual faculty members.
FRGGR90 - Closeout Workflow for Funds Ending on Contracts and Grants
  • Quickly check the closeout status on your awards.
  • You can only run this for Main or HSC Campuses, so it is highly recommended that you choose to display ORG CODE when running this report.  If you output to HTML Active Report, you can then filter based on your org code.  Choosing AGING will help you prioritize which closeout tasks to tackle first, as you'll be able to quickly tell which grants have ended earliest.  A negative number in the AGING column means that the budget period end date has not yet passed.  A positive number reflects the number of days that have passed since the budget period end date.  STAGE NAME will show the current status of the closeout.  When stage name includes the word "Dept" such as stage 1, 3a, 3b, 5b or 8 does; those awards should be in department's workflow queue and department needs to take action. 
FRRGLDS - Grant Ledger Detail and Summary
  • Displays the ledger detail or summary for a selected index, fund, org, program, or grant.  Allows inception-to-date reporting.
  • Useful for viewing the inception-to-date charges on a restricted index.  Viewing the inception-to-date summary will give you a high-level picture of the budget and expenditures on the grant.
FNRECRT - Effort Certification Status Report
  • Displays information on the effort certification records based on your selection.
  • Run it for your org using the Search By "Pending Queue Actions" to see just the records that need attention (i.e. either need to be pre-reviewed or certified).  Run it for "All Queue Actions" to see detail on everything - when a record was reviewed, when it was certified, etc.  Run it by State and Status to see a high-level overview of all records for your org.  Run it by Organization Level 5 to run the report by department or by Organization Level 7 to run the report by PI Org Code.
FNGSLBE - Salary Labor Benefits and Encumbrances Guided Ad Hoc (Data Extract)
  •  This is a guided ad hoc version of the Salary Labor Benefits report.  Because it allows you to summarize data for multiple fiscal years, it can be very useful in helping you perform trend analysis to assist you in determining how to allocate budgets for future fiscal years.
  • This is a data extract, not a true report.  You will get the most use out of this if you extract it to Excel or Active HTML and perform some manipulations after the fact to organize the data as you need.  Pivot Tables are extremely useful for this - for simple manipulations, use the built-in tool in Active HTML.  For more detailed manipulations, highly recommended to use Excel's Pivot Tables.  Lynda.unm.edu has training on Pivot Tables; you can access this using your NetID and password.
FNRLDST - Labor Distribution Report
  •  Displays active or historical labor distributions.
  • Useful for seeing all employees paid by your org during the prior fiscal year so you can ensure you do not miss anyone when completing Salary Planner. You can run it by Historical Distributions to see all distributions throughout the year, which may assist you in ensuring that people paid from multiple indices are entered correctly in Salary Planner for the upcoming fiscal year. Because this report also displays Hiring Org, it can assist you in identifying which org(s) you need to confirm percentage allocations with for shared faculty members, as the Home Org will be responsible for entering allocations for those employees. Select Excel output and filter based on certain account codes if you want to exclude pooled positions from your analysis.

Budgeting & Projections - These reports can assist you in researching spending trends on your indices to assist you in making your budgets and projections

FOGOPER - Operating Ledger Guided Ad Hoc (Data Extract)
  • This is a guided ad hoc version of the Operating Ledger Detail and Summary report.  Because it allows you to select multiple fiscal years, it is very useful in helping you perform trend analysis to assist you in determining how to allocate budgets for future fiscal years.
  • This is a data extract, not a true report.  You will get the most use out of this if you extract it to Excel or Active HTML and perform some manipulations after the fact to organize the data as you need.  Pivot Tables are extremely useful for this - for simple manipulations, use the built-in tool in Active HTML.  For more detailed manipulations, highly recommended to use Excel's Pivot Tables.  Lynda.unm.edu has training on Pivot Tables; you can access this using your NetID and password.
FNGSLBE - Salary Labor Benefits and Encumbrances Guided Ad Hoc (Data Extract)
  • This is a guided ad hoc version of the Salary Labor Benefits report.  Because it allows you to summarize data for multiple fiscal years, it can be very useful in helping you perform trend analysis to assist you in determining how to allocate budgets for future fiscal years.
  • This is a data extract, not a true report.  You will get the most use out of this if you extract it to Excel or Active HTML and perform some manipulations after the fact to organize the data as you need.  Pivot Tables are extremely useful for this - for simple manipulations, use the built-in tool in Active HTML.  For more detailed manipulations, highly recommended to use Excel's Pivot Tables.  Lynda.unm.edu has training on Pivot Tables; you can access this using your NetID and password. 
FNRLDST - Labor Distribution Report
  • Displays active or historical labor distributions.
  • Useful for seeing all employees paid by your org during the prior fiscal year so you can ensure you do not miss anyone when completing Salary Planner. You can run it by Historical Distributions to see all distributions throughout the year, which may assist you in ensuring that people paid from multiple indices are entered correctly in Salary Planner for the upcoming fiscal year. Because this report also displays Hiring Org, it can assist you in identifying which org(s) you need to confirm percentage allocations with for shared faculty members, as the Home Org will be responsible for entering allocations for those employees. Select Excel output and filter based on certain account codes if you want to exclude pooled positions from your analysis.
FORDCBL - UAP 7000 Deficit Compliance and Balance Reports
  • Displays the amounts in account codes 1901 (Budgeted Use of Reserves), 1900 (Reserves), 1903 (Change in Reserves) - and calculates the Unbudgeted Net Reserves based on these values.
  • If you're running this by org, run it by "All Balances" to see deficit balances. The fund overall must be in deficit for it to show up for "Deficit Balances Only". Don't be put off by the "Deficit Compliance" in the report name - it is a very useful tool to help you monitor your reserve balances in non-deficit indices as well.
FBRBAVL - Budget Availability Detail and Summary
  •  Very helpful in assisting departments to determine why an NSF situation exists.

Effort Certifications (Restricted Indices) - This report can assist you in monitoring your effort certifications and identifying records that need to be reviewed or certified for your department

FNRECRT - Effort Certification Status Report
  • Displays information on the effort certification records based on your selection.
  • Run it for your org using the Search By "Pending Queue Actions" to see just the records that need attention (i.e. either need to be pre-reviewed or certified).  Run it for "All Queue Actions" to see detail on everything - when a record was reviewed, when it was certified, etc.  Run it by State and Status to see a high-level overview of all records for your org.  Run it by Organization Level 5 to run the report by department or by Organization Level 7 to run the report by PI Org Code.
FNGSLBE - Salary Labor Benefits and Encumbrances Guided Ad Hoc (Data Extract)
  •  This is a guided ad hoc version of the Salary Labor Benefits report.  Because it allows you to summarize data for multiple fiscal years, it can be very useful in helping you perform trend analysis to assist you in determining how to allocate budgets for future fiscal years.
  • This is a data extract, not a true report.  You will get the most use out of this if you extract it to Excel or Active HTML and perform some manipulations after the fact to organize the data as you need.  Pivot Tables are extremely useful for this - for simple manipulations, use the built-in tool in Active HTML.  For more detailed manipulations, highly recommended to use Excel's Pivot Tables.  Lynda.unm.edu has training on Pivot Tables; you can access this using your NetID and password.
FNRLDST - Labor Distribution Report
  •  Displays active or historical labor distributions.
  • Useful for seeing all employees paid by your org during the prior fiscal year so you can ensure you do not miss anyone when completing Salary Planner. You can run it by Historical Distributions to see all distributions throughout the year, which may assist you in ensuring that people paid from multiple indices are entered correctly in Salary Planner for the upcoming fiscal year. Because this report also displays Hiring Org, it can assist you in identifying which org(s) you need to confirm percentage allocations with for shared faculty members, as the Home Org will be responsible for entering allocations for those employees. Select Excel output and filter based on certain account codes if you want to exclude pooled positions from your analysis.

UAP7000 Categorization of Reserve Balances - These reports can assist you in monitoring your reserve balances

FNRRCAT - UAP 7000 Reserve Categorization
  • Displays the carryforward reserve balance, Banner commitments and dedications, department commitments and dedications, and the net reserves.
  • Useful as a quick overview of your reserve balances, commitments, and dedications.  Use the Grouping option to group by index to see the information summarized for each of your unrestricted indices.
FORBAUF - Budget Availability for Unrestricted Funds/Indices
  • Displays the budget, expenditures, commitments, NSF Balance available, net unbudgeted reserves, revenues, and transfers for your selected org.
  • This report is very useful in monitoring the spending on your unrestricted indices and especially in helping you monitor the reserve balance that will carry forward from year to year based on the current budget and spending.  Also helpful in identifying unrestricted  indices where spending has exceeded budget.  Keep an eye on the NSF Balance Available at the fund level to ensure that you have sufficient budget available to cover any planned expenditures.
FORDCBL - UAP 7000 Deficit Compliance and Balance Reports
  • Displays the amounts in account codes 1901 (Budgeted Use of Reserves), 1900 (Reserves), 1903 (Change in Reserves) - and calculates the Unbudgeted Net Reserves based on these values.
  • If you're running this by org, run it by "All Balances" to see deficit balances. The fund overall must be in deficit for it to show up for "Deficit Balances Only". Don't be put off by the "Deficit Compliance" in the report name - it is a very useful tool to help you monitor your reserve balances in non-deficit indices as well.
FORUBSS - Unrestricted Balances and Saving Summary for UAP 7000
  • Displays the budget, reserves, net balance and fiscal year information for all indices that fall under the selected org.
  • This is a very useful report for monitoring your carryforward reserves.  Because this report shows budget, actual revenues, and actual expenditures, it can give you an idea of how your spending for the current fiscal year will affect your carryforward reserves for the next fiscal year and assists you in monitoring your reserves on an index-by-index basis.
  • The net balance on this report is also critical in monitoring a deficit balance, as it calculates revenue less expenditures; versus expense budget less actual expenditures.

Additional Resources

  • For news, training, and more on Finance reports, expand the Finance tab on http://myreportsinfo.unm.edu
  • Pivot tables in Excel are an extremely useful tool - FSM does not provide support for this, but training can be found on Lynda
  • To report a problem with a published report, email fsm@unm.edu