Skip to main content

Solutions

Products

Recommended products

Questions? We are here to help.
Contact us

Purchase

Questions? We are here to help.

Resources

Accounts

Import accounts to a chart of accounts or an account rollup

You can import CSV files for
Charts of Accounts
 or
Account Rollup
 that was previously created or create new templates that maps the data.
  1. Sign in to ONESOURCE, then select
    Administration
    .
  2. Select
    Company Info
    , then
    Accounts
    .
  3. For accounts listed in the chart of accounts, select a chart link on the
    Charts of Accounts
     tab.
    1. Select
      Import
      on the
      Accounts
       screen. This opens the
      Import Accounts
       wizard
      Step 1 Upload
      .
    2. Select a chart
       from the dropdown.
  4. For accounts listed in the account rollup, select the
    Account Rollup
     tab.
    1. Select an account rollup link that has accounts attached.
    2. Select
      Import
      in the
      Account Rollup section
      . This opens the
      Import Rollup
       wizard
      Step 1 Upload
      .
  5. In the Data Mapping Template section,
    select from an existing template
     or select
    Create a New Template
    . You can also drag and drop the file in the pane on the screen, or
    Browse for file
    .
  6. Select
    Next
    . This opens the
    Step 2 Mapping
    .
  7. Enter a template name.
  8. Select the
    Start Row
     number using the up and down arrows.
  9. For accounts listed in the
    Charts of Accounts
    :
    1. Select the dropdown buttons on the
      Row
       columns and map the
      Account Code
       and
      Account Name
      . 
  10. For accounts listed in the
    Account Rollup
    :
    1. For Financial Hierarchy mapping type, select the dropdown buttons on the Row columns and map the
      Account Code
       and
      Financial Hierarchy ID
      .
    2. For Chart of Account mapping type, select the dropdown buttons on the Row columns and map the
      Account Code
      ,
      Chart of Account
      , and
      Code
      .
  11. Select
    Save
     to save your changes.
    note
    The
    Template
    and
    Start Row
     fields and
    Row
     columns are automatically filled in if you are using an existing template. You only need complete these steps if you're creating a new template.
  12. Select
    Next
     to move to
    Step 3 Validate
    .
  13. Step 3 Validate
     compares the imported information with the existing data and gives the status of the Accounts.
  14. Select each category tab to review the status of each of the Accounts.
    1. New
      ,
      Duplicate
      ,
      Existing
      , or
      Issues
      .
  15. Select
    Continue
    .
  16. For accounts listed in the chart of accounts, select
    Import
     to import all changes, or select
    Only Import New
     on the
    Import Summary
     window.
    note
    For master charts, you won't need to use the validate steps for the Financial Hierarchy mapping column.
  17. For accounts listed in the account rollup, view the
    Import Summary
     window to see what is getting imported, then select
    Import
     to import those changes.

This article applies to:

  • PRODUCT: ONESOURCE Platform
  • Sub-Product: ONESOURCE Administration

Related Content