Contents x
    Reconcile Subsidiary Modules with G/L Report
    • 23 Aug 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    Reconcile Subsidiary Modules with G/L Report

    • Updated on 23 Aug 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary


    Reconcile Subsidiary Modules with G/L Report

    This report allows you to compare the amounts in subsidiary modules (Gifts, Grants, and Accounts Payable) with the amounts posted to General Ledger. The report displays the amounts posted in each module and in General Ledger, along with any variance. This report helps to make sure the FIMS outer modules stay in sync with General Ledger.

    You can select specific contribution accounts, Grant payable and expense accounts, and administrative payable accounts, or run the report for all accounts. You can also choose to show information for all Funds, or only those with differences.

    NOTE: You can access this report from anywhere in FIMS by selecting Reports > General Ledger > Reconcile Subsidiary Modules with G/L.

    Reconcile Subsidiary Modules with G/L Report (Differences Only)


     Reconcile Subsidiary Modules with G/L Report Fields

    Field

    Description

    Fiscal Year

    The fiscal year that the report is based on.

    Period

    The period through which data appears on the report.

    Detail Through

    The last date of the selected period.

    Fundid

    The ID code that identifies the Fund.

    Name

    The Fund’s report name.

    G/L

    The G/L amount (for Gifts, Grants, Grant Payables, and Administrative Payables).

    Detail

    The amount from the subsidiary module.

    Variance

    The variation between G/L and the subsidiary module.

    Running the Reconcile Subsidiary Modules with G/L Report

    1. In the General Ledger module, select Reports > Reconcile Subsidiary Modules with G/L. The Reconcile Subsidiary Modules Selections window opens.

    Reconcile Subsidiary Modules Selections Window

    2. In the Display Fund Balances For fields, select the fiscal year and period that you want to include in the report.

    3. In the Contribution Accounts, Grants Payable Accounts, Grants Expense Accounts, and Admin Payable Accounts sections, click the Add button and select the desired accounts.

    4. If you only want to display Funds that have a variance between the outer modules and General Ledger, select the Differences Only checkbox. If you want to display all of the Funds, clear this checkbox.

    5. Select the date to be used (Document Date or G/L Post Date)

    6. Using the Include checkboxes to the right of each of the 4 sections of the report, indicate which section should be included in the report.  By default, all sections of the report are included.

    NOTE: By eliminating some sections and focusing on one section you will reduce text wrapping and improve readability of the report.

    7. Click OK. You will be prompted to save your settings. This allows you to run the report again at a later time without having to configure your settings again.

    8.Verify the Send To destination, and then click the Run Report button.

     

    Was this article helpful?
    What's Next