General Ledger Plus offers multi-company reporting capabilities that the standard General Ledger does not. It automatically creates a Master Chart of Accounts in Company 0, which consolidates reports across all companies. Changes apply to the following areas: Chart of Accounts, Dashboard, Posted Journals, Reports, and Special Reports.
Chart of Accounts
General Ledger Plus allows you to set up your Master Chart of Accounts in Company 0, then link all accounts from your other companies to it. To link an account:
- Access one of your other companies.
- From the General Ledger menu, click Modify > Chart of Accounts.
- Click the Edit icon next to the account you want to link.
- In the Master Account section, select your level information and Account #.
- Click Update to save your changes and return to the previous page.
Note: Click the icon or press "s" in any field with the Search icon to open a Search window. Use the filter at the top to narrow your selection. In the Account Search window, you can also specify the Account Type from a drop-down list. Double-click an item to select it, or click the item and click Select. Click Close to return to the previous page without making a selection.
You can also click Reset to undo all changes since the last update, or Cancel to return to the previous page without saving.
Important: Finish linking your accounts to the Master Chart of Accounts before using any other features of General Ledger Plus.
Dashboard
The Budget Compared to Actual widget displays two charts: one showing Actual for Period and Budget for Period, and another for Actual YTD and Budget YTD. When viewed within Company 0, these amounts are consolidated totals for all companies based on how accounts are linked to the Master Chart of Accounts. Viewing the widget in any other company displays amounts for that company only.
Posted Journals
When you search for Posted Journals within Company 0, results include all companies based on how your accounts are linked to the Master Chart of Accounts. Accessing Posted Journals within any other company displays information for that company only.
Reports
General Ledger Plus allows you to run consolidated reports within Company 0 and consecutive reports within any other company. Both report types use an enhanced Account Structure filter to select which companies to include.
To set up an Account Structure selection:
- Use the Selection drop-down to choose an existing saved selection, or click Add new to create one.
- Enter a Selection name, then select the companies to include in the report.
- Click Save to save the selection, or click Cancel to add new.
To edit an existing selection, make your changes and click Save. Click Delete to remove a saved selection.
Consolidated Reports
You can run consolidated reports from Company 0. On the report page, Filters tab, select the levels within the companies on which you want to report. Your Company 0 is also available on the filter. Select the levels within Company 0 that you have linked to the levels in your other companies. This produces a concise report with combined totals from all selected companies.
Example: If you select "Fund 10" from two of your companies and have linked accounts in those funds to accounts in "Fund 10" within your Master Chart of Accounts, also select "Fund 10" within Company 0 using the filter.
Consecutive Reports
You can run consecutive reports from any company other than Company 0. On the report page, Filters tab, select the levels within the companies on which you want to report. The report prints consecutive reports for each selected company.
Company Information Report
The Company Information report has a Companies drop-down list on the Filters tab. Select the companies on which you want to report.
Account Structure List Report
The Account Structure List report has a Companies drop-down list on the Filters tab. Select the companies on which you want to report.
Chart of Accounts Report
The Chart of Accounts report automatically displays all account links for the accounts selected in the Account Structure filter. For best results, run this report within any company other than Company 0.
Special Reports
General Ledger Plus allows you to run consolidated Special Reports within Company 0. This works as described in the Reports section above.
Special Reports run normally for the selected company in Current Financial Settings, even when other companies are selected.
Updated