Excel Add-in: Data Import Functions: New Mapping: Global Identifiers Map

If you have multiple worksheets within a workbook that have the same identifiers (Year, Account, and Locator) and in the same configuration, you can use Global Identifier to map the identifiers for all worksheets at one time.

To use the Global Identifiers:

1. In a workbook, open the sheet you want to map with global identifiers.
2. Select Global Identifiers, and select GoSystem Tax RS.

   

3. The GoSystem Tax RS - Global Identity XML Source pane opens.

   

4. Select the identifier in the XML Source pane, and drag and drop it in the appropriate cell on the spreadsheet. A blue box then surrounds the cell on the spreadsheet, and the identifier text in the XML Source pane is now bold (see the screen shot below for Year and Account mapped identifiers). Continue to drag and drop the identifiers until all global identifiers are mapped.

   

 

 

 

Import/Export/data_import_16.htm/TY2021

Last Modified: 11/09/2020

Last System Build: 10/18/2022

©2021-2022 Thomson Reuters/Tax & Accounting.