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
- To import Trial Balance data for an Income Tax binder from Data Hub, open a binder.
- SelectBalances, thenData Hub/GLM Import.
- 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.
- Select the Data Hub collection you want to import.
- Once the application retrieves the selected Data Hub collection, theImportbutton becomes active.
- SelectImportto begin the process.
- Next you will either see a success message or an error message.
- 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)
- After the Import process is complete, the system will update the Audit trail for the last import submitted.
- After the Data Hub/GLM import collection list screen is closed, the Balances screen will display the imported balances.
- 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 fromNoneto 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.