Bridge Import

In Data Transfer, you can transfer data using the bridge import process from two data sources.

•	The "Bridge" spreadsheet enables you to transfer information from the "General Ledger Extract" to the selected "Dataset." The extract relies on the bridge mapping rules for the transfer of the 'General Ledger" data for various "Data Input " pages.

•	You can transfer data from General Ledger Manager.

Notes:

•	A user must have access to the Bridge Import assigned by an Administrator.

•	In order to "Bridge" data into units, an administrator must assign the units to the user.

Screen Entry Fields

1.	In the Control Center, select the Target Dataset.

2.	Select Data Transfer and then Bridge Import.

Set up Configurations for Dataset

1.	Select a Target Components to be updated.

2.	Click Select All to update all components.

3.	Select Class and Subclass or Tag (depending on the Target Dataset type), Report Level and Unit Type Value (for Unit or Subconsolidation Report Levels only).

For Class/Subclass Datasets

1.	Select Class. You can change default class value Bridge – GL Automation.

2.	Select Subclass. You can change the Default - Default to a user defined subclass.

For Tag Datasets

•	Select a Tag. You can change the default tag from I-Import. The tag that you choose is assigned to the data bridged into the application. Consider setting up a tag that easily identifies data that is imported with a bridge file.

Report Level

•	The Report Level enables you to Bridge import data into a unit, sub-consolidation, or consolidated (all units).

•	Set up the following system parameters to limit the users ability to select units, sub-consolidations, and consolidations.

•	BRIDGE_ALLOW_UNIT_SELECT

•	BRIDGE_ALLOW_SUBCON_SELECT

•	BRIDGE_ALLOW_ALL_UNITS

To activate the system parameters for Bridge:

1.	Select Administration and then System.

2.	Select Manage Configurations and then Advanced Functionality.

3.	Select Bridge.

4.	Choose the Data Source.

To browse for the import file:

1.	Choose the format(s) and file(s) of legacy data.

•	The extract file needs to be defined in a specific format.

o	There are two file formats - comma and tab delimited.

o	There are two data formats - 4 and 6 columns.

2.	To open the file directory, click Browse.

3.	Select the file(s) with General ledger extract file.

4.	Click Open and then Add.

5.	To import additional files click Browse, choose a file and then Add.

6.	Click Preview Bridge Import to view the bridge mapping.

7.	Click Submit to update Tax Provision data entry pages.

8.	Click Start Over to cancel the bridge import.

To Upload Data from General Ledger Manager:

1.	Choose the Master Trial Balance Year and Master Trial Balance.

2.	Select Preview Bridge Import to view the bridge mapping.

3.	Select Submit to update Tax Provision.

4.	Click Start Over to cancel the bridge import.

To activate the system parameters for General Ledger Manager as a data source:

1.	Select Administration and then System.

2.	Select Manage Configurations and then Integration.

3.	Select General Ledger Manager.

4.	Select the parameter Enable Data Transfer from General Ledger Manager.

5.	Submit Update Tax Provision.

A message appears All report data will be refreshed automatically. Are you sure you want to update Tax Provision?

1.	Click Cancel to cancel the update.

2.	Click OK to update the Tax Provision.

3.	Review the Bridge Import - Log.

4.	To return to the Bridge Import - Log, click ONESOURCE Bridge Logs.

Preview Bridge Import and ONESOURCE Bridge Logs

You can choose Preview Bridge Import to view Bridge Mapping, Missing Sublines, Missing Bridge Assignment, and Missing Units. Component types include PTBI (Local), PTBI (Reporting), Tax Accounts (Activity), Book Trial Balances (Activity), Perm Diffs – Tax Basis (Activity), Perm Diffs – Book/Tax Basis (Activity), Temp Diffs – Tax Basis (Activity), Temp Diffs – Book/Tax Basis (Activity) and Temp Diffs – Tax Basis (Bal Sheet Only). The Bridge Import data can be reviewed later in ONESOURCE Bridge Logs. ONESOURCE Bridge Logs also provides the bridge import log status.

When the data source is General Ledger Manager, the beginning and ending balances are hyperlinked to General Ledger Manager. When a hyperlink is selected, General Ledger Manager opens and you can access the supporting details for the selected amount.