Contents x
    FACTS Menus
    • 22 Apr 2024
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    FACTS Menus

    • Updated on 22 Apr 2024
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary


    FACTS Menus

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

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

    FACTS Reports Menu

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

    Menu Option

    Function

    List Funds Within a Pool

    Runs a report that lists all Funds participating in a Pool during a selected Cycle, with ending market values and income balances.

    NOTE: This report also indicates whether the Funds have been reconciled for the selected Cycle.

    List Accounts Within a Pool

    Runs a report that lists all bank accounts or money managers in which a Pool is invested for a selected Cycle, with ending market and income balances. The report also indicates whether the accounts have been reconciled.

    Transaction Entry Listing

    Runs a report that lists current (unposted) Transactions for FACTS.

    This report is often used during the reconciliation process to identify confirmed Transactions.

    Transaction History Listing

    Runs a report that lists posted Transactions for FACTS.

    NOTE: This report is identical to the Transaction Entry Listing Report, except that it lists posted rather than unposted Transactions.

    Reconciliation History

    Runs a report that lists beginning balances, activity broken out by all categories, and ending balances. This report is similar to the Reconciliation Report for the current Cycle, except that you can run it for any posted Cycle.

    YTD – Reconciliation Report

    Runs a report that lists beginning balances, activity broken out by all categories, and ending balances.

    This report is similar to the Reconciliation Report for the current Cycle, with an additional column for Year-to-Date values.

    Unitization History Report

    Runs a report that provides a complete list of posted and unposted allocation results from any reconciliation Cycle. Each line displays activity for one Fund, with columns for Beginning Balance, changes during the Cycle, and Ending Balance.

    YTD – Unitization Report

    Runs a year-to-date version of the Unitization History report.

    Investment Performance

    Runs a report that provides a simple calculation of investment performance.

    NOTE: The calculation for this report provides an approximation of total investment return. It does not look at asset allocation or risk, nor does it consider daily stock prices or daily cash flow. It assumes that changes in market value (not due to earnings) occur evenly over the month and can be estimated by dividing the net contributions for the month in two.

    Historic Gift Value Report

    Runs a report that provides the historic Gift Value for each selected Fund. This value is the accumulated total of contributions to an endowed Fund, without considering any additional earnings.

    NOTE: This report sums transactions coming from General Ledger with a GifP Type code, so it will not be accurate if Gifts are initially deposited outside of the Pool and then swept into FACTS via a utility that creates Journal Key codes that are not set up to translate into the GifP Type. This method of tracking historic Gift value is seldom used – most organizations use a Fund balance.

    FACTS – General Ledger Comparison Report

    Runs a report that checks that the Pool balances in FACTS (in the F-Fund-balance records) are exactly the same as those tracked by the Pooled asset account in General Ledger.

    NOTE: The balance between FACTS and General Ledger is so essential to the integrity of your fiscal system that you should run this report along with the Edit Report before posting allocations from the current Cycle back to General Ledger.

    Outstanding Check Report / Export

    Runs a report that displays any checks that are outstanding in FACTS reconciliation. You can either run the report to the screen or export the data to an ASCII file.

     

    Was this article helpful?
    What's Next