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Â
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.
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
Use the Change Rollup feature to create/edit Account rollups and easily preview how the changes will look. Â
When viewing the Account Structure for the Report Type, hold the CTRL key and select the accounts to be included in the rollup. Â
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.
Select a rollup (double-click on it) from the existing list if appropriate. Accounts will be moved to selected rollup.
To create a new rollup, after selecting the accounts to change rollup, click Quick Add in the lookup screen.
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.
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.
Â
Â