Skip to main content
Data

Data upload and validation

Upload data files, validate them, and address discrepancies.

Upload formats

Support for delimited files and Excel files. You can configure the upload settings based on the file type.

Data upload

Upload data from ERP consolidation systems or general ledger systems. Validate that the data matches the charts of accounts and entities in the Administration module.
  1. Select
    General Ledger Manager
     in ONESOURCE.
  2. Select
    Upload Data
     or a similar option.
  3. Select the data source (ERP, consolidation system, or general ledger).
  4. Select the file format or API connection method.
  5. Initiate the data upload process.

Validate incoming data

GLM validates incoming data against the defined charts of accounts and entities. Invalid records are flagged for review.
  1. Once data is uploaded, select
    Validate Data
     or an equivalent option.
  2. The system will automatically check:
    • Accounts against known accounts in administration.
    • Entities against administration entities.
  3. Review the validation report.

Addressing unrecognized accounts or mismatches

  1. Identify any accounts or entities that failed validation.
  2. For unrecognized accounts:
    • Add them to the appropriate chart of accounts in Administration, or
    • Map them to existing accounts in the account roll-up.
  3. For unrecognized entities:
    • Add them to the entity list in Administration, or
    • Map them to existing entities in the entity roll-up.
  4. Re-run validation after making changes.

Data consolidation

General Ledger Manager consolidates data based on account roll-ups to a master chart of accounts and, optionally, entity roll-ups. It produces a tax consolidation of the data.
Update data incrementally
  1. For subsequent data updates, select the data option.
  2. Upload new or changed data.
  3. The system will automatically merge the new data with existing snapshots.
  4. Review and validate the updated data set.

This article applies to:

  • Product: ONESOURCE General Ledger Manager