Fixed assets

Import fixed asset data

After setting up a fixed assets chart of accounts and the corresponding mapping, the last step is to import the data from external fixed assets systems or registers to populate the worksheets. The data import file should be in a format similar to the standard trial balance import.
It is possible to import fixed assets data for multiple entities at one time. To do this, specify the entity identifier in the column headers.
note
For a successful import, we recommend using only text and hard-coded values in the file. Links and formulas can disrupt the upload.
To import the file:
  1. Select
    Imports
    , then
    Import Details
    .
  2. Select
    Add
     to start a new import task.
  3. On tab
    1| Data Source &Target
    , specify the target dataset and configure the import task. The import type must be Fixed assets.
  4. In the
    Data Source
     section, browse to the fixed assets import file.
  5. Select
    Next
    .
  6. On tab
    2 | Field Options
    , specify the selected worksheet, header rows, entities, and code based on the layout of the import file.
  7. If the entity IDs are in the header, select
    In the header row
    .
  8. Select
    Next
    .
  9. On tab
    3 | Map Data
    , map the source data columns from the import file into destination column, based on the nature of the source data column.
    tip
    You can select
    Save Import Specification
     to save the configurations from this import. Preset parameters are created and you can use the specification for future import tasks.
  10. Select
    Import
    .
While the data is being imported, it will fill in the relevant fixed assets categories fields in the import worksheets. The data will then flow into the corresponding fixed assets worksheets and the summary sheets.
note
  • After data is imported, most blue manual entry fields in the import sheets disappear and only populate the categories that have data flowing in from the import.
  • Importing opening balances do not override the opening balances that were carried forward.
  • It’s not necessary to import closing balances. These fields are calculated in the worksheets.

This article applies to:

  • Product: ONESOURCE Corporate Tax