General Ledger Menus
  • 22 Apr 2024
  • Contributors
  • Dark
    Light
  • PDF

General Ledger Menus

  • Dark
    Light
  • PDF

Article summary


General Ledger Menus

The General Ledger module has several module-specific menu options on the Reports menu and File Maintenance menu.

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

General Ledger Reports Menu

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

NOTE: Refer to Design Statements for more information on Consolidated Financial Statements, Fund Statements, and Columnar Financial Statements.

Menu Option

Function

YTD General Ledger

Runs a report that lists General Ledger accounts, beginning and ending balances for each, and posted General Ledger journal entries to those accounts.

Trial Balance

Runs a report that provides debit and credit balances for the selected account(s) as of a selected period.

NOTE: If you select 0 as the period, the report will print beginning Fund balances.

Consolidated Trial Balance

Runs a traditional trial balance report that is consolidated based on the criteria you select. For example, you can consolidate the report based on Fund coding or consolidate to the organization level.

Journal History Report

Runs a report that lists posted journal entries. You can sort and select based on journal fields (for example, the apply date or journal key) and General Ledger account segment fields (for example, Fund ID, Fund Class, Fund Type, and Sub Type).

Fund Activity Report

Runs a report that provides the opening Fund Balance, a list of all the activity in the revenue and expense accounts, and the ending Fund Balance.

Fund Balance Report

Runs a report that provides a list of Funds, along with a column for total assets, total liabilities, three Fund balances, and the total Fund balance.

Chart of Accounts Report

Runs a report that lists all of your General Ledger accounts, along with their descriptions and account types. You can run the report for all accounts in your organization, or for the accounts in a single Fund (or group of Funds).

Master Chart Report

Runs a report that lists all of the records in the Master Chart file – which serves as a template to automatically create General Ledger accounts for new Funds.

You can run the report to list all of the available accounts, or you can select Fund Class to view the accounts that will be built for a specific class.

G/L Segment Report

Runs a report that lists all of the Division, Class, Type, and Sub-Type codes used by your organization.

Asset Analysis by Division Report

Runs a report that analyzes General Ledger values based on the Fund Division and Fund Type or Sub-Type.

Journal History – Expanded Description

Runs a report for posted General Ledger Journal entries. It is similar to the Journal History Report, except that selections are limited to the fiscal year, General Ledger accounts, and an Apply Date range.

The Description field is also expanded on this report so that you can view more of the description text (it may be truncated on the Journal History report).

Reconcile Subsidiary Modules with G/L

Runs a report that 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, Grants Payable and Expense accounts, and Administrative Payable accounts. You can also choose to show information for all Funds, or only those with differences.

Consolidated Financial Statements

Runs a report (created in Design Statements) that collapses General Ledger values from selected Funds into a single report.

Consolidated Financial Statements Export

Runs a report (created in Design Statements) that creates an ASCII data file that you can use to create a presentation quality statement in Microsoft Word. Like printing consolidated financial statements, this export will combine balances from selected Funds into a single report.

Fund Statements

Runs a report (created in Design Statements) that prints multiple statements (one or more per selected Fund or Fund Rep. It cannot consolidate financial information from more than one Fund, unless they are set up as Master/Subordinate Funds.

Fund Statements Export

Runs a report (created in Design Statements) that creates an ASCII data file that you can use to design a presentation quality statement in Microsoft Word.

Like printed Fund Statements, the export is not designed to consolidate financial information from more than one Fund, except when they are set up as Master/Subordinate Funds.

Columnar Financial Statements

Runs a report (created in Design Statements) that displays one Fund per row, with General Ledger values in columns.

 

General Ledger File Maintenance Menu

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

Menu Option

Function

General Ledger Accounts

Allows you to add, edit, or delete General Ledger account records.

G/L Account Mass Add / Delete

Allows you to autobuild or delete a single account from a group of specified Funds.

Refer to Mass Adding/Deleting General Ledger Accounts for more information.

Master Chart of Accounts Maintenance

Allows you to add, edit, or delete accounts on your Master Chart of Accounts.

Refer to Maintaining the Master Chart of Accounts for more information.

NOTE: Adding or deleting an account in the Master Chart does not automatically add or delete the accounts in the actual Chart. Use the G/L Account Mass Add/Delete utility to add or delete accounts in the actual General Ledger.

G/L Calendar Maintenance

Allows you to set fiscal periods and dates for the General Ledger.

Refer to Maintaining the General Ledger Calendar for more information.

Journal Key Code Maintenance

Allows you to add, edit, and delete Journal Key codes. These codes are used to categorize General Ledger Journal entries.

Refer to Maintaining Journal Key Codes for more information.

Enter G/L Budgets

Allows you to add budget figures for a give year (for example, for operating expenses, operating revenues, or Grant expenses).

Refer to Entering General Ledger Budgets for more information.

NOTE: You must run End of Year Closing to create accounts in the new year before you can enter budget figures for the new year.

Enter Opening G/L Balances

Allows you to enter beginning balances for all of your General Ledger accounts.

Refer to Entering Opening General Ledger Balances for more information.

NOTE: This utility should only be used during the initial General Ledger implementation.

Close Modules by Date

Allows you to close the General Ledger based on the selected date. The system will prevent posting any journal entries on or before this date.

You can also use this utility to close Gift and Pledge posting or Grants and AP posting to General Ledger.

Refer to Closing Modules by Date for more information.

Purge Unused G/L Accounts

Allows you to delete General Ledger accounts if there are no Actual or Budget balances in any period or in the beginning balance field, and there are no unposted GL entries for the account.

Refer to Purging Unused General Ledger Accounts for more information.

NOTE: You cannot use this utility to delete Fund Balance accounts.

Functional Expense Code Maintenance

Allows you to update the Functional Expense code table.

Refer to Maintaining Functional Expense Codes for more information.

Build Functional Expense Accounts

Allows you to automatically add accounts that have a specified Functional Expense segment.

Refer to Building Functional Expense Accounts for more information.

Calibrate G/L Account Types

Allows you to synchronize the account types in General Ledger with those assigned to natural accounts by Fund Class in the Master Chart.

Refer to Calibrating General Ledger Account Types for more information.

G/L Budget Import

Allows you to import your yearly G/L budget from a spreadsheet into FIMS.

Refer to Importing General Ledger Budgets for more information.

G/L Journal Import

Allows you to import General Ledger Journal entries from a spreadsheet into FIMS.

Refer to Importing General Ledger Journal Entries for more information.

End-of-Year Closing

Runs the End-of-Year Closing process, which creates the General Ledger accounts for the new year and establishes the beginning balances for the balance sheet accounts.

Refer to Performing End of Year Closing for more information.

 


Was this article helpful?