Grantee and Grant Management Menus
  • 29 Mar 2024
  • Contributors
  • Dark
    Light
  • PDF

Grantee and Grant Management Menus

  • Dark
    Light
  • PDF

Article summary


Grantee and Grant Management Menus

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

Note: Refer to FIMS Menus in the Introduction for more information about general FIMS menus.

Grantee and Grant Reports Menu

Note: This section provides a brief description of each available report/export for Grantee and Grant Management. Refer to Grantee and Grant Reports chapter in the FIMS Reports Guide for more information and examples of these reports, as well as others you can run in FIMS.

Grant Reports

Note: These reports list Application information for all posted, approved Grant Applications.

Menu Option

Function

Grant History Report –Opt by Grant

Runs a report that lists posted Grants and is optimized to run faster based on your report selections. You should use this report if you are basing your selections on the Grant Date, Grant Number, ASF, ID Code, or other Grant coding.

Grant History Report – Opt by Fund/Tran

Date

Runs a report that lists posted Grants and is optimized to run faster based on your report selections. You should use this report if you are basing your selections on the Fund ID, Transaction Date, or other Fund coding.

Grant History Listing

Runs a report that lists posted Grants.

Note: This report is similar to the Grant History Report, except that it also includes the Requested Amount.

Grant History with Payments

Runs a report that lists posted Grants along with the complete payment history for each line in the payment plan.

Grant History by Fund

Runs a report that lists posted Grants, sorted and subtotaled by Fund. You can filter the report based on Fund Profile fields, but the report is always sorted and subtotaled by Fund.

Grant History by Group

Runs a report that list posted Grants, sorted by the group(s) that Grantees are a member of.

Conditions Follow-up Due Report / Export

Runs a report that lists all Grants that have conditions or follow-up records. You can use this report to view all conditions with an overdue Due Date and no corresponding Done Date. This can be a useful reminder report for tracking Condition fulfillment.

You can also run an optional export to send a reminder to those who appear on the report.

Cumulative Grants by Fund

Runs a summary report that lists the total Grant amount for each Fund.

 

Payments by Fund

Runs a report that lists all Grant payments made from each Fund. A Fund total appears at the end of each set of payments, and a grand total for all payments from all Funds appears at the end of the report.

Export Grant Information

Runs an export that creates an ASCII data file based on posted Grant information (approved Applications) that you can use to create mail merge letters in word processing.

Grants by Program Area

Runs a report that lists outstanding commitments before and after a user defined date range, along with any new Grants that were approved and any payments that were made during the given date range.

This report is automatically sorted and subtotaled based on the Program Area code.

Committee Budget Report

Runs a report that lists the remaining available budget for each committee. The report is based on the committee budget minus any commitments and the YTD Grants Voted amount (this amount is automatically calculated by FIMS when Grants are approved).

Available to Grant Report

Runs a report that provides an overview of money that is available to Grant from the selected Fund(s). A grand total of the available dollars and available to Grant for all Funds appears at the end of the report.

Note: Only Funds that have Fund Distribution records will appear on this report.

Grant Cancel / Refunds Report

Runs a report that lists Grants that have been canceled or Refunded (via Grant Adjustment processes).

Foundation Center

Survey Export

Runs an export that creates an ASCII data file of Grant data in the electronic format requested by the Foundation Center. This export is useful if you adhere to the Foundation Center coding scheme as regards the primary Population code and the primary Program Area code.

Grant Analysis by Fund

Runs a report that evaluates the past Grant making behavior of Funds, based on the program areas that received Grants. This can be useful for Grant budgeting because it reflects historic Grant budgeting for donor-advised Funds.

Grants by Date and Program Area

Runs a simple Grant report selectable only by a specified date range and for specified Program Areas.

Donor Advisor Letters

Runs a report that generates an addressed letter containing Fund’s Grant history for a selected time period. It is designed to create a calendar year-end letter for donor advisors.

Outstanding Grants by Fund

Runs a report that lists outstanding commitments before and after a user defined date range, along with any new Grants that were approved and any payments that were made during the given date range.

The Grants are automatically sorted and subtotaled by Fund.

 

Grantee Reports

These reports list Application information from the Grantee perspective for all posted Grant Applications, regardless of whether they are Approved, Denied, or Withdrawn.

Menu Option

Function

Grantee Profile

Runs a report that lists all posted Applications for a given date range and Grantee (or range of Grantees), including approved, denied, and withdrawn Applications, and payment information.

Grantee Listing w/Executive

Runs a report that lists Grantees and their addresses, along with the Grantee executive and the total amount they have received in Grants.

 

Grantee Summary History

Runs a report that shows the summary Grant history for each Grantee on an including an annual count of Grant Applications, the number of applications that were Approved or Denied, the amount of money they have received in Grants from the organization, and the largest Grant they have received.

Grantee Detailed History

Runs a report that lists detailed information about each Grant that a Grantee has received.

This report is automatically sorted and subtotaled by Grantee.

Payments by Grantee

Runs a report that lists information about the payments that have been made to a Grantee or range of Grantees.

This report is automatically sorted and subtotaled by Grantee.

Export Grantee Information

Runs an export that creates an ASCII data file based on the Grantee record that you can use to create mail merge letters in word processing.

IRS 990 Grantee Schedule

Runs a report that lists Grantees that require an IRS form 990 with their full address, total Grants, and program areas.

Summarized Grantee

Runs a summary report that lists Grantees and the total Grants received.

 

Application Reports

These reports list Application information from the Grantee perspective for all unposted Grant Applications, regardless of whether they are Approved, Denied, or Withdrawn.

Menu Option

Function

Unposted Application Listing

Runs a report that lists all Grant Applications that are still active in the system (have not been posted), including their associated Requested Amount, Grant Amount, and Action code.

Unposted Application

Profile

Runs a report that provides detailed information about unposted Applications.

When you run this report, you are given the option to print each Application on a separate page. This is useful if, for example, you want to use the report as a header sheet for presentation to committee members.

Unposted Application Registry

Runs a report that provides the Grantee name and address, and Grant information including whether there are conditions for each unposted Grant Application.

Unposted Application Export

Runs an export that creates an ASCII data file that you can use to create mail merge letters and other communication with applicants.

Unposted Application Export w/ Fund Rep

Runs an export that is similar to the Unposted Application Export except that it is based on the Application payment plan line items. If an Application has a payment plan with more than one line item, each line item will produce an export record. This export also includes the Fund Representative’s name and address for each Application.

Review and Required Items

Runs a report that prints information about review items and required items on unposted Applications (based on the data on the Application’s Prerequisites tab).

Unposted Application Listing by Fund

Runs a report that lists summary statistics for all unposted Grant Applications, based on the Fund ID for each payment line.

Unposted App Address Info by FundID

Runs a report that lists line items from unposted Grant Applications along with the name and address information for each applicant.

 

Review Available Balance of Unposted App

Runs a report that provides information about the available General Ledger balances for each Fund associated with an unposted Application. You can use this report to determine if a Fund will exceed its available General Ledger Grant balance when the Grant is complete.

 

Application History Reports

These reports list Application information for all posted Grant Applications, regardless of whether they are Approved, Denied, or Withdrawn.

Menu Option

Function

Application History Listing

Runs a report that lists complete Application history for all posted Applications (regardless of whether the application is Approved, Denied, or Withdrawn) for each Grantee.

Application History Registry

Runs a report that provides the Grantee’s name and address and Grant information for each posted Grant Application, including any conditions.

Application History Export

Runs an export that creates an ASCII data file that you can use to create mail merge letters and other communication with applicants. The data file that is created is the same as that for the Unposted Application Export, except that only posted Applications are accessed.

Application History

Export w/ Fund Rep

Runs an export that is similar to the Unposted Application Export w/ Fund Rep except that it is based on posted Applications. If an Application has a payment plan with more than one line item, each line item will produce an export record. This export also includes the Fund Representative’s name and address for each Application.

Review and Required Items – Posted

Runs a report that lists information about review items and required items on unposted Applications (based on the data on the Application’s Prerequisites tab).

User Defined Application History Export

Runs an export that allows you to select the actual fields you want to export. Any field from the AppHistory (fields from the application, including Scholarship User fields), AppHistLineItem (Payment Plan tab), Fund (fields from the Fund record), Fund-Rep (fields from Fund associations), Grantee (fields from the Grantee record), Scholarship Fund (fields from the Scholarship Fund record), and/or Profile tables can be selected for export, and fields are selected from the Fields tab on the FIMS Report Selections window.

Note: It is important that you understand how the FIMS database works and what the fields are before running this export. Please contact FIMS Support if you need help determining the appropriate fields to export to fit your needs.

Amortization Schedule

Runs a report that allows you to calculate interest and payments for loans.

 

Trends and Analysis Reports

These reports provide summarized information for either unposted or posted Applications analyzed by Grant coding.

Menu Option

Function

 

Pending Applications

Runs a summary report that analyzes pending Applications (includes all unposted Applications) based on the analysis code you specify. For example, you could run the analysis based on the Application Status code to show how many Applications are in each stage of the application process.

Application History

Runs a summary report that analyzes posted Applications (whether they are approved, denied or withdrawn) based on the analysis code you specify. For example, you could run the analysis based on Request Type.

Grantees

Runs a report that analyzes Grant data based on the Grantee analysis code you specify. For example, you could run the analysis based on the Grantee’s Type code.

Grant History

Runs a summary report that provides Approved Application history totals based on the analysis code you specify. For example, you could run the analysis based on the Population code.

Follow-up Activity

Runs a summary report that lists the number of conditions for each Grant, based on the Condition record analysis code you specify. For example, you could run the analysis based on the Condition code to get a count for each Condition.

Grants – Budget to Actual

Runs a summary report that compares budget figures from Grant codes with actual Grant amounts and lists the variance amount.

Full Grant Status Report

Runs a summary report that analyzes Grant totals by four date ranges and selected code categories.

 

Grantee and Grant File Maintenance Menu

This section provides a basic description of the File Maintenance menu options. Refer to File Maintenance – Grantees and Grants for more information on maintaining these files.

 Menu Option

Function

Auto-Create Grant Applications

Opens the Auto-Create Grant Applications utility, which allows you automatically create new Applications based on posted Application History. For example, you can use it to easily create annual designated distributions.

Refer to Automatically Creating Grant Applications for more information.

Recurring Grants from Fund Distributions

Opens the Recurring Grants from Fund Distributions utility, which allows you to automatically create new Applications based on the Action Date of your Fund Distribution records.

Refer to Creating Recurring Grants from Fund Distributions for more information.

Refer to Creating Fund Distribution Records in the Fund Management module for more information about setting up your Distributions.

Deactivate Grantee Profiles with no Grants

Opens a utility that reviews each Grantee in the FIMS database to see if the Grantee was issued a Grant during a selected date range and develops a list of Grantee Profiles that might be considered inactive. The list is displayed in the FIMS Viewer with a Flag Profiles as Inactive menu option. If you select this option, the utility will automatically mark each Profile record on the report as Inactive.

Refer to Deactivating Grantee Profiles with no Grants for more information.

Tip: Create a backup copy of your database before running this utility.

Import Grants

Runs a utility that allows you to import Grant applications from an external source directly into FIMS. This process reduces the amount of manual data entry, in turn

reducing the potential for errors. It is useful if, for example, your organization accepts applications online and you have a spreadsheet containing the application information.

Refer to Importing Grants for more information.

Grant Code Maintenance

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

Refer to Maintaining Standard Grantee and Grant Codes for more information.

Short Cuts

Opens a sub-menu with options that allow you to create a new Profile, new Grantee, new Application, or set Application Defaults.

Note: These options perform the same functions as clicking the buttons on the Grantee and Grant Management Toolbar.

 


Was this article helpful?