Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Tax Accounting System (TAS)

Import trial balance data with Data Hub into a binder

You can now
import Trial Balance data from Data Hub into an Income Tax
 binder either for a single binder or in a batch.
Data Hub/GLM Single Binder Import
  1. To import Trial Balance data for an Income Tax binder from Data Hub, open a binder.
  2. Select
    Balances
    , then
    Data Hub/GLM Import
    .
  3. You will see a list of Data Hub collections along with each collection’s version number that is published for that year and available to import.
  4. Select the Data Hub collection you want to import.
  5. Once the application retrieves the selected Data Hub collection, the
    Import
     button becomes active.
  6. Select
    Import
     to begin the process.
  7. Next you will either see a success message or an error message.
  8. The following are types of errors: 
    • Invalid Account Number
    • Account Tax Return Type Invalid
    • Activity Number must be numeric (1065 and 1120S)
    • Activity Number cannot exceed 3 characters (1065 and 1120S)
    • Activity Transfer only applies to Accounts assigned to TRC Categories 38 or 48 (1065 and 1120S)
  9. After the Import process is complete, the system will update the Audit trail for the last import submitted.
  10. After the Data Hub/GLM import collection list screen is closed, the Balances screen will display the imported balances.
  11. New with this release, Data Hub Aggregation Logic can be used for the imported data. You can use either an aggregation for its Entities, its Account Codes or both. If you set up an Aggregation Logic, you can change that drop-down from
    None
     to the aggregated logic name given in Data Hub.

Data Hub Aggregation Logic

Entity Aggregation:
 Create an Entity Rollup group in ONESOURCE Administration, select
Entities
.
Account Aggregation:
 Set up an Account Rollup group in ONESOURCE Administration, select
Accounts
.
To apply aggregation logic, select the appropriate option from the drop-down menu on the Balances screen.

This article applies to:

  • PRODUCT: ONESOURCE Income Tax
  • Subject: Import

Related Content

Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close