Contents x
    Fund Management Module Menus
    • 09 Oct 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    Fund Management Module Menus

    • Updated on 09 Oct 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary


    Fund Management Module Menus

    The Fund Management module has several Fund-specific menu options on the Reports and File Maintenance menus.

    Tip: Refer to FIMS Menus in the Introduction for more information on general FIMS menus.

     

    Fund Management Reports Menu

    This section provides a brief description of each available report / export for Funds. Refer to the Fund Reports chapter in the FIMS Reports Guide for more information and examples of these reports.

    Menu Option

    Function

    Fund Listing

    Runs a report that provides a list of Funds with the date they were established, the Available to Spend amount (if activated), and the Fund coding that will become part of the G/L account key (Division, Class, Type, and Sub Type).

    Fund Profile

    Runs a report that provides full profile information for each Fund (one Fund is printed per page).

    Fund Distributions by Fund

    Runs a report that provides a complete profile of distribution record information, sorted by Fund. Distribution records are used to track the program allocations for a Fund. Selections for this report are based on the Fund fields.

    Fund Distribution Listing

    Runs a report that provides a complete profile of each distribution record. Selections for this report are based on the Fund Distribution fields.

    Fund Summary Activity

    Runs a report that provides a yearly summary of Fund activity, based on the Fund Summary History record, which keeps annual statistics of Gift and Grant transactions.

    Fund Representative Listing

    Runs a report that lists the name and address information for Fund representatives, based on their association codes for the Fund.

    Fund Goal Report

    Runs a report that lists information about any goals that a Fund has set, including the beginning and ending dates for the goal, the total goal amount, and any Gifts that have been received toward that goal.

    Fund Representative Export

    Runs an export that creates a plain text (ASCII) file that you can use as a merge file for thank-you letters, envelopes, or labels.

    The data file includes information for anyone associated with a Fund who also has a Fund Representative Type code. One record is exported for each Fund rep. type for each selected Fund. This means that multiple records may be exported for a single Fund (and some Funds will not have any exported records).

    Retired Funds Listing

    Runs a report that provides a list of all retired Funds, including their Fund ID, name, and the date when the Fund was retired.

    Fund Notes

    Runs a report that prints the text from the Fund notepad.

    Fund w/ Anniversary Listing

    Runs a report that lists all Funds that were established during a given month or range of months, along with information about the selected Fund representative(s).

    Simple Fund Rep Listing

    Runs a report that lists basic information about every Profile record that has a Fund Representative Type code.

    Available to Spend Detail Report

    Runs a report that provides information about the amount that is available to spend for each Fund, including the total Fund balance and any amounts that are added to or subtracted from the Fund balance to calculate the Available to Spend amount.

    Note: The Available to Spend Calculation must be active before you can run this report. Refer to Maintaining Available to Spend Codes for more information.

    User Defined Fund Export

    Runs an export where you can select the actual fields that you want to export. You can select any field from the Fund table for export.

    (Trends and Analysis) Funds

    Runs a report that analyzes Fund records based on the analysis code you specify. For example, you could run a report that provides the number of Funds that have a specific Sub Type.

    You can create an instant pie chart from this report. Refer to Exporting Trends and Analysis Data to Excel in the Reports chapter for more information.

    (Trends and Analysis) Asset Analysis by Division

    Runs a report that analyzes Year to Date General Ledger assets based on the Fund’s Division code and then either by Fund Type or Sub Type.

     

    Fund Management File Maintenance Menu

    This section provides a brief description of the File Maintenance menu options in the Fund Management module. Refer to File Maintenance – Funds for more information on maintaining these files.

    Menu Option

    Function

    Auto-Build G/L Accounts

    Opens the Auto-Build G/L Accounts utility, which allows you to automatically create General Ledger accounts for the selected Fund.

    The accounts that are built depend on the Fund Class of the Fund and the Master Chart records on which the Fund Class code is listed.

    Refer to Autobuilding G/L Accounts for more information.

    Retire a Fund

    Opens the Retire a Fund utility, which allows you to retire a Fund and set its General Ledger accounts as inactive, so they will not be re-created during end-of-year processing.

    Refer to Retiring a Fund for more information.

    Copy Fund Representatives

    Opens the Copy Fund Representatives utility, which allows you to create a new Fund representative for a selected group of Funds, based on an existing Fund Rep association. For example, you could add a Receives Statement code to all Profiles that are associated to corporate division Funds as the Donor Advisor.

    Refer to Copying Fund Representatives for more information.

    Mass Fund Field Assignment

    Opens a utility that allows you to copy any available Fund codes to each Fund in a selected group.

    Refer to Mass Assigning Fund Fields for more information.

    Fund Code Maintenance

    Opens a sub-menu where you can select from a list of code tables that you want to update.

    Fund code tables include Fund Class, Fund Type, Fund Sub Type, Division, Administrative Fees, Interest, Spending Policy, Fund Representative Types, Grant Letter, Asset Strategy, Fund Statement Style, Staff, Available to Spend, and Special Handling.

    Refer to File Maintenance – Funds for more information about maintaining these codes.

     

    Fund Data Grid

    The Fund Data Grid provides a list of all of the available Fund records in FIMS.

    You can use this Data Grid to verify that a Fund record does not already exist before adding a new record, or to locate an existing record that you want to edit.

    To find a Fund, click the arrow in the Search By drop-down box and select the field that you want to search by, and then enter the first few characters of the Fund information in the Find Record field. The Data Grid will automatically scroll down as you enter each character. Scan the list of records until you find the one you need.

    To open the selected record, make sure it is highlighted in the list and then either double-click on the record or click the tab that you want to view.

    Note: You can configure the Fund Data Grid to display any fields that are associated with Funds. Refer to Configuring View Settings in the Introduction for more information on customizing your views.

    Fund Data Grid

     

    Was this article helpful?
    What's Next