A web-based tool accessible through the Thomson Reuters ONESOURCE portal, ONESOURCE General Ledger Manager enables you to create master trial balances
A Master Trial Balance is a composite of various trial balances, which may be generated from different accounting systems, that shows entities, their master account codes and the beginning and ending balances for those accounts in a spreadsheet format. from various trial balances that you upload, validate, and, if valid, selectively import into the application. You create master trial balances by combining trial balance filesA trial balance file should contain a single trial balance. The records within the trial balance should at least have a reporting unit, general ledger account code, beginning balance (optional), and ending balance. according to account mapsMaps that associate accounts in charts of accounts, which underly trial balance data files, to master accounts in a master chart of accounts. You must create and apply these maps to control how trial balance files are merged and summed in the creation of master trial balances. For example, you might map Petty Cash and Other Cash in a chart of accounts to the Cash master account in an account map. When trial balance files are merged to create a master trial balance, all of the Petty Cash and Other Cash accounts in the various files will be itemized and summed under Cash on the resulting master trial balance in accordance with the account map. that you select. You can then use these master trial balances to update ONESOURCE Income Tax and ONESOURCE Tax Provision.
If you are a licensed user of General Ledger Manager, you should be able to use this application when you log in to ONESOURCE since its Single Sign-on (SSO) authentication accepts your ONESOURCE log in. Just click the ONESOURCE General Ledger Manager link in the ONESOURCE platform.
The security role assigned to you in User Administration determines the functionality that you can use in the application. Either a user security role or an administrator security role may be assigned to you. A user security role lets you add trial balances to the General Ledger Manager server, import them into the application, create master trial balances, and review them. Users cannot access Setup or use any links that go to files in Setup. An administrator security role lets you use all of the functions within General Ledger Manager.
Administrators may click Settings on the far right of the top menu bar in General Ledger Manager to gain access to User Administration which displays a list of the people who are authorized to use the application in addition to those who are not authorized, if any. An administrator can change the role of a user to administrator or vice versa by highlighting a user and then clicking edit. An administrator can also remove a person's authorization to use this application.
ONESOURCE General Ledger Manager is organized into modules whose links in the Navigation Pane follow, from top to bottom, a logical workflow that you use to create master trial balancesA Master Trial Balance is a composite of various trial balances, which may be generated from different accounting systems, that shows entities, their master account codes and the beginning and ending balances for those accounts in a spreadsheet format.. Each module is a self-contained unit that encapsulates all of the records that you need to use to complete or view an entire stage of the workflow. The following modules comprise the application:
Setup, Import Trial Balances, and Create Master Trial Balance represent the core modules in which you must make entries to create master trial balances. In Setup, you must enter information about the content and layout of the files of trial balance data that you will be uploading to establish criteria for validating those files and to create account maps that can be used to combine them. Import Trial Balances enables you to upload trial balances and to import those that have been validated against your setup criteria. In Create Master Trial Balance, you select the account map that you want to use to combine specific trial balance filesA trial balance file should contain a single trial balance. The records within the trial balance should at least have a reporting unit, general ledger account code, beginning balance (optional), and ending balance. into a master trial balance.
Review Trial Balances enables you to review and adjust trial balances that you may want to combine into master trial balances, and Review Master Trial Balances enables you to review the master trial balances that you have created.
In most instances when you select a module to work with, the first view that you see contains a list of all of the items that exist in the module itself or in a specific area of the module. This is the List View. For example, when you click Import Trial Balances, you will see all of the trial balance data files that have been uploaded to the General Ledger Manager server listed in the Import Queue.
Also, in most of the List Views, the name of each item in the list is a link to a Detail View that is displayed when you click the name to reveal the item's data. When you click Add or Create, you also get a Detail View that enables you to enter the details required to add or create an item.
ONESOURCE General Ledger Manager enables you to:
Maps that associate accounts in charts of accounts, which underly trial balance data files, to master accounts in a master chart of accounts. You must create and apply these maps to control how trial balance files are merged and summed in the creation of master trial balances. For example, you might map Petty Cash and Other Cash in a chart of accounts to the Cash master account in an account map. When trial balance files are merged to create a master trial balance, all of the Petty Cash and Other Cash accounts in the various files will be itemized and summed under Cash on the resulting master trial balance in accordance with the account map. and, optionally, reporting unit rollup mapA map that controls how General Ledger Manager “rolls up” reporting units under entities in the creation of a master trial balance. When applied, these maps override the system default of mapping reporting units as entities on a one-to-one basis in the creation of a master trial balance. When such a map is applied in the creation of a master trial balance, only the reporting units that are associated to entities will be mapped in the master trial balance. in Setup that will govern how trial balances are merged and summed in the creation of master trial balancesA Master Trial Balance is a composite of various trial balances, which may be generated from different accounting systems, that shows entities, their master account codes and the beginning and ending balances for those accounts in a spreadsheet format..An enterprise-wide information software system for collecting, managing, analyzing, and distributing company information, including operating information such as finance and accounting data. ERPs can export accounting information such as trial balances in flat files for use in other financial reporting systems. In this instance, they are a source of data for General Ledger Manager. to the ONESOURCE General Ledger Manager server either automatically using General Ledger Manager connect, if your installation is licensed for it, or manually by using the Add a File to Queue wizard in the Import Queue in Import Trial Balances or by using Excel Add-in if your installation is licensed for it;In Create a Master Trial Balance, the choice of an account map determines the specific trial balance files that are available for the creation of a master trial balance. Only the trial balance files that have the same charts of accounts as those in the selected account map appear for selection. in Create Master Trial Balance to produce a master trial balance. 
Accessing the Application