Office - General Ledger - Overview

Table of Contents


Overview

  • The General Ledger Overview provides users with an opportunity to view and define how General Ledger accounts roll up into the Financial Statements. Within the Overview, users can easily drill-down into the Financial Statement Groupings to see the details of the included accounts, and can also create and edit account groupings.

Required Permissions

  • General Ledger

  • Overview

  • Add/Edit/Delete Accounts

  • Change Rollup


Navigation 

To access the Overview, go to the Top Toolbar. Click on General Ledger Then, select Overview 

General Features 

The General features available when viewing any Report Type are as follows:

  • Drill-Down - Click the + sign to see the accounts included in the rollup.

  • Re-order - Highlight the account line and then use the up/down arrows to move it.

  • Preview - Click the Report Icon to preview the changes on the Financial Report selected.

  • Account Maintenance - Double click on an account to open its maintenance screen.

  • Company Selection - If applies, select the Company.

Report Type 

  1. To change the Report Type from Balance Sheet to either the Consolidated Income or Departmental Income report, click on the drop-down arrow in the Report Type field, and select the desired report type.

  2. For Departmental Income Report Type, a new Department field will appear.  Use the Lookup feature for assistance.  Select the desired Department to populate field.

Change Rollup

  1. Use the Change Rollup feature to create/edit Account rollups and easily preview how the changes will look.  

  2. When viewing the Account Structure for the Report Type, hold the CTRL key and select the accounts to be included in the rollup.  

  3. Then, click Change Rollup

    • The Ledger Category for the Rollup and Account must be the same; only rollups that match the Account Ledger Category will be listed.  As such, if the Account category is Income you will not see Expense Rollups listed.

  4. Select a rollup (double-click on it) from the existing list if appropriate. Accounts will be moved to selected rollup.

  5. To create a new rollup, after selecting the accounts to change rollup, click Quick Add in the lookup screen.

    • Enter the Name.  

    • Select a Ledger Category.  

    • Use the Lookup feature for assistance.  

    • This category must be the same as the accounts for rollup.  

    • Enter an optional Description.  

    • Designate whether the rollup should be included on Departmental and/or Consolidated Financial Statements.  

    • Save and Close when finished.

  6. New Rollup will display.

    • Remember to highlight the rollup and use the Move Up/Move Down feature to re-order the position of the rollups/accounts.  

    • Click the Report Icon to preview what the new rollup will look like on the selected Financial Report Type.


Best Practices

  • Preview changes made utilizing the Report Viewing icon to ensure Account rollup edits, translate into the desired reporting outcome.

FAQs

  • Q: How do I move an account out of a rollup I have established?

  • A: Double-click on the Account. Within the Ledger Accounts maintenance screen, click the X next to the Departmental Roll-Up field to clear out roll-up account. Then, click Save and Close.