Import data

Create an import task

After creating an import task, you can run it as often as necessary to import your data. Data is validated upon import. If one or more errors occur, you can view the error log that explains the issues with the file, then correct the errors. Depending on the options you select, amounts can be rounded or signage reversed upon import.
  1. On the main menu bar, select
    Imports
    , then
    Import Details
    .
  2. Select
    Add
     to start the wizard.
  3. On tab
    1 | Data Source & Target
    , enter the requested information for the import task. You also use this tab to specify and entity and import specification.
    Drag the file you are importing from into the
    Data Source
     box, or select the
    Browse for file
     button to find the file on your computer. When you have selected the source file, select the
    Next
    button to go to the next screen of the import wizard.
    note
    You won't be able to advance to the next screen until you've selected the import file.
  4. On tab
    2 | Field Option
    , enter the import parameters.
    • If your source file is a Microsoft® Excel® workbook and your data is not in Sheet1, select the appropriate worksheet from the
      Select Worksheet
       dropdown list.
    • If your source file has a header row, check the
      Select header row in the data preview below
       button and check the check box in the
      Select
      column in the preview that corresponds to the header row in the source file. Multiple header rows must be consecutive.
      note
      Only the first 100 rows appear in the in the preview.
    • If your file contains data at the top and the bottom of the file (for example, in a header and footer) that is not required to be read by the system, use the
      Start on row number
       and
      Row(s) at the end of the file to ignore
       fields to specify the row number to start with and the number of rows to ignore at the end of the file.
    • Your selection depends on whether entity information is contained in your file and, if it is, where in the file it is located. Entity information should correspond to the
      Entity ID
       field on the Entity Manager screen. If there is no entity identifier in the file return to tab
      1 | Data Source & Target
       and select the entity.
    • If the entity identifier is in a column in the file, select
      In a Column
       in step 2 of the wizard. This option is useful when you have account codes repeating down the page for multiple entities, and a single amount column. When you select this option, the
      Entity ID
       destination field is available in step 3 of the wizard and a column must be mapped to it.
    • If the entity identifier is in the heading, your file will have amount columns for each entity. Select
      In the header row
      . Each amount column must contain the entity ID and you must define a row as the header row in the preview section at the bottom of the screen.
      note
      If you import a trial balance, a journal is generated containing the updated amounts.
  5. Select the
    Next
    button to go to the next screen of the import wizard.
  6. On tab
    3 | Map Data
    , use the dropdowns in the left panel to map the source file columns to the import, then specify a name for the import specification in the panel on the right.
    • When a column description in the source data matches a destination field, the destination field is automatically populated. If there is no exact match, use the dropdown list in the
      Destination Field
       column to choose a corresponding field for each source data column. Fields to be mapped depend on the file type.
    • For trial balance files, destination fields include
      Entity ID
      ,
      Code
      ,
      Description
      , and
      Amount
      . If you have multiple amount fields in your file, select the first amount column and choose
      Amount
       from the dropdown list. All other amount fields are also mapped.
    • For transaction listing files, destination fields include
      Entity ID
      ,
      Date
      ,
      Reference, Code
      ,
      Description
      , and
      Amount
      .
    • If the file you selected on tab
      1 | Data Source & Target
       contains debit and credit columns, select the
      Source data has separate debit and credit columns
      check box at the top of the screen. (It is disabled if the entity is defined in a column header.)
    • If your file contains decimal places and you want them to be rounded upon import, select
      Round to whole amounts
      . By default, files are not rounded.
  7. Select the
    Save import specification
     button if you want to save this configuration.
  8. Select the
    Import
     button to begin the import.

This article applies to:

  • Product: ONESOURCE Trusts
  • Subject: Import