*Note: The "Selector" role is necessary to view funds and fund reports in Alma.

What are Fund Reports

1. Some familiar with previous fund reports
2. Can monitor balances
3. Can monitor orders and order status
4. Biggest impact selectors can have is on firm orders and/or spending out approvals ledger budgets
5. However, worth looking at "9" funds to ask questions – encumbrances that don't make sense, things you think should be cancelled.

Viewing Fund Balances in Alma

1. Search by using the Persistent search bar - set search to "Funds" and type in fund code.
2. View fund balances.
   1. Cash Balance: Allocation minus  Expenditures
   2. Available Balance: Allocation minus  Expenditures minus  Encumbrances

Alma Fund Reports

The Alma Fund Reports replace the previous system. They provide both an overview of fund balances as well as a list of orders on each fund in the current fiscal year.

Fund report data is usually updated daily and is typically current as of 6:00 pm the previous day.

To access the Fund Reports:

1. Log on to Alma. (Note that you must have the Selector role to view the fund reports. All fund managers and the staff they designate to handle orders can have this role assigned).
2. On the left-hand side of the screen, choose Analytics / Reports / Fund Reports.
   1. Note that after clicking on Analytics, under "Data updated as of:", you can see the date/time that the data was last updated that will be retrieved by the reports.

3. A new tab will open with the Fund Reports Dashboard.
    

Fund Report Layout and Data

The dashboard consists of 4 tabs: Title by Title List  |  Fund Balances |  Fund Balances Visualization  |  Invoice Lookup.

Title by Title List

Fund Balances are also included at the top of the screen, with a list of Purchase Order Lines below it.

Filters:

Limit by Fund Manager Name and/or Fund Code by specifying the option(s) here and clicking Apply.

Note that they can be chosen from the drop-down list OR typed in directly. Choosing just fund manager name will display all funds for that fund manager.

If only Fund Manager is specified, all funds for that fund manager will appear.

If resetting any of the filters in the same session, click Reset / Clear All first before applying the new filter.

Filters will carry across to the other tabs of the dashboard.

Fund Balances:

• Available Balance: Allocation  minus  Expenditures  minus  Encumbrances
• Cash Balance: Allocation  minus  Expenditures
• Percent Year: What percent of the total fiscal year has already passed.
• Percent Spent YTD: What percent of the fund has been spent year to date.
• Fund Area Description: Type of fund (state, special, recurring, firm, central pool).
• Grand Total: Note that when viewing multiple funds, with any central pool funds included, this may give a misleading number as money in the central pool is duplicated in the main ledger.

Title List:

Will display all PO lines in the current fiscal year for the selected fund(s). The PO lines typically correspond to a title, though there are also some "package" PO lines that pay for multiple titles which are not listed separately.

Columns included in the Title List:

• Fund Name
• Fund Code

• Reporting Code: The type of material or service ordered.

• PO Line Title
• PO Line Number: The number associated with each individual title/item to uniquely identify that PO line.
• PO Number: The number of the purchase order on which the PO line appears. There might be more than one PO line on a given purchase order.
• ISBN
• ISSN
• Publisher
• List Price: The price of the item ordered. In the rare cases where multiple funds pay for an item, the price reflects the total price of the item. PO lines in Alma can not have a $0 price, even if we do not want the fund encumbered for that order. In these cases, a price of $1.00 or less will appear.
• Current Encumbrance: The amount for which this specific fund is currently encumbered for that PO line. Once the item has been paid, this will be $0.
• Amount Paid Current FY: The amount paid by this fund for this PO line in the current fiscal year.
• Receiving Date: For print materials, this is the date it was marked received in Alma. Note that because of the migration from Voyager, this field might be empty for some items even if they've been received. (Receipt info can be viewed in Alma in that instance.)
• Status: Whether the PO line is ACTIVE, CLOSED, or CANCELLED. CLOSED status is assigned once the PO line has been paid.
• Vendor Name: Name of the vendor from which the item was ordered.
• PO Line Type: Whether the item is PRINT or ELECTRONIC as well as whether it is ONE TIME, SUBSCRIPTION, or STANDING ORDER. Note that this types are not always reliable for electronic resources, as some e-resources migrated as print from Voyager.
• PO Line Creation Date: Date the PO line was created in Alma.

Fund Balance Visualization

High level visualization of fund balances

Invoice Lookup

Provides more specific information about an invoice payment for a PO line, such as invoice date, number, and notes.
 

Exporting Data from Fund Reports

After choosing any of the filters which you wish to set, click the gear icon on the top, right hand corner of the page. Then choose Export to Excel / Export Current Page.

File will be exported to your default download folder from which you can open it in Excel.