Part III - UNM Finance: Practical Applications

SARM Site Search

 



Standard Accounting Resource Manual (SARM)

MSC 0000 00
1 University of New Mexico
Albuquerque, NM 87131

Tools to assist you in checking for NSF

MyReports can be found at: https://myreports.unm.edu/ibi%20apps/bip/portal/MyReportsPortal.  Sign in to MyReports and select the F All Campus Reports folder. 

Finding indices with Deficit Balances:

MyReport FBRBAVL: Budget Availability Detail & Summary Report. This report can be found in the Finance Production Reports folder.   Select report values by org leve 3 or 5.  Enter the value, or part of the value, for your org.  Select "Find Values".  All values that meet those criteria will be displayed.  Select the values you wish to run.  Leave the report at Executive Summary at this point, since all values, not just negative values, will be displayed.  In the example below, an Internal Medicine value (851) was selected.  851A was selected.  The report was then run.

nsf1

Examine the report for negative balances.  In the example below, fund 2U0008 has a negative balance of $7,222.63. 

NSF2

To determine the indices for this fund, run the same report again in Department Detail, rather than Executive Summary.

nsf3

The indices for each fund will be displayed.  Here, the relevant index is 8511OK.  To examine the detail for this index, use Banner form FGIBDST 

 

 nsf4

In FGIBDST you can drill down on each account, and examine the relevant documents that comprise the negative amounts.

 

MyReports FNRSLBE: Labor Distribution Report. This report can be found in the F All Campus Reports folder, and will allow you to verify whether the organization labor distributions are current and accurate.

Banner Form FGIBAVL, Budget Availability Status Form – allows you to query by index code or specific Fund/Organization combination and check the available balance at org level 5 and fund.

FGIBAVL shows you Available Balance

To query, select F7, input the Fund and Organization numbers, and select F8.

The fund for this example is 3U0007, a level 3 fund.  The Level 5 Organization is 997A.

Available Balance Screen

FGIBAVL, a Banner Screen, will show you in one line the available balance at org level 5 for this level 3 fund. In this case, we are checking on fund 3U0007.

You can see that this fund has $1,515 budgeted, and so far this fiscal year has spent $3,189.27. There are no commitments, so the fund 3U0007 for Pediatrics Level 5 Org (997A) is in deficit spending of $1,674.27.

Banner form FGIBDST, Organizational Budget Status Form – allows you to query by index code and check the available balance.

FGIBDST shows you Available Balance for an index or fund.

Input the index number and select “next block”.

FGIBDST Available Balance Screen

This gives you an account breakdown. The expense accounts [-428.44, -1537.98,308.72, -16.57=1,674.27] add to the same total.

By unchecking the “Include Revenue Accounts” box, this form will give you fund results, as below:

Results Screen

Again, the available balance shows the level 3 fund 3U0007 is in deficit by $1,674.27.