Skip to main content
Convert from General Ledger Manager Classic

Convert reporting unit rollups

To export, adjust, and import the Reporting Unit Rollups data from General Ledger Manager Classic into
ONESOURCE Administration
Entity
Entity Rollup
 so that it can be consumed in the new General Ledger Manager, follow these steps:

Export the file

  1. In General Ledger Manager Classic, go to
    Setup
    , then
    Reporting Unit Rollups
    .
  2. Select the Rollup you want then go to Section 2.
  3. Select the option to
    Export
     the data.
  4. The export process will generate an
    .xlsx
     file containing 3 columns.

Adjust the file

  1. Swap Columns A and B:
    • Column A should now contain
      EntityCode
      .
    • Column B should now contain
      ReportingUnitCode
      .
  2. Copy the entire data including headers into a new sheet.
  3. Remove the values in Column B.
  4. Select only Column A and remove duplicates for that column. This will prepare a final list for Parent Entities.
  5. Copy over the entire data (excluding headers) from the old sheet and add as rows below into this current sheet. This will prepare a final list of Child Entities along with corresponding Parent Entities.
  6. Delete the old sheet and there will be just 1 sheet now which is the new sheet.
  7. Set
    Sort
     and
    Filter
     options on the headers.
    • Sort Column A in ascending to descending order. This will give the order of how the import file needs to be for the Rollup module.
    • Set a filter on Column A selecting only
      Blanks as option
      .
    • Remove all data resulted from that filter. This will produce a clean file.
  8. Insert a Column Between B and C:
    • This column represents Code level 3 which will be empty in this scenario.
  9. Make sure
    Allocation%
     is in Column D.
  10. Insert a new column at the end (Column E).
  11. For every row with data, enter
    Latest
     in Column E.
  12. Save the adjusted file in CSV format.

Import the file

  1. Go to
    ONESOURCE Administration
    Entities
    Entity Rollup
    .
  2. Create the Entity Rollup then select
    Import
    .
  3. Import the prepared CSV file and follow the instructions to continue with the upload.
  4. Check the Validate area for any issues that may arise during the import process.
  5. Resolve any validation issues as needed.
note
The Import process will fail under the following conditions:
  • The total aggregation of an Entity is greater than 100%.
  • Parent and Child Entities in a single row are the same.

This article applies to:

  • Product: ONESOURCE General Ledger Manager