Setup 0: Loads to Data Hub

You can either: 

• Use S0.01 to validate the load for each list.
• Visit the individual pages below to update an individual list.

To use this page to load lists and hierarchies for each list:

1. Select Refresh.
2. Select Choose File for each CSV file to import.
   You will see a summary of unmapped flies when the imports are complete. 
3. Select Run process.
4. Select the Current month to update the Data Hub model's current month at the start of a planning cycle.

To import income statement (IS) accounts and assign leaf level:

1. Select Refresh.
2. Select Choose File for to import a CSV file.
3. Select Run process.
4. In the Source account parent child relationship grid, select or clear the checkboxes in the Is leaf level? column.

To load trial balance by month:

1. Select Load DH trial balance.
2. To view the trial balance for a specific combination in the Depreciation expenses grid, use the dropdowns at the top-right to set the:
   • Entity
   • Department

To refresh balance sheet (BS) accounts:

1. Select Refresh Source Account BS.
2. For each account, select the relevant checkbox to define the subsets.

To load BS trial balance by month:

1. Select Refresh balance.
2. To view the trial balance for a specific combination in the Trial balance grid, use the dropdowns at the top-right to set the:
   • Entity
   • Department
   • Account

To load monthly balance sheet subledger:

1. Select Refresh balance.
2. To view the load balance for a specific combination in the grid, use the dropdowns at the top-right to set the:
   • Entity
   • Department
   • Asset type
   • Account

To load depreciation expense by month: 

1. Select Load expenses.
2. To view the load expenses for a specific combination in the grid, use the dropdowns at the top-right to set the:
   • Entity
   • Department
   • Account

To map planning income statement (IS) to balance sheet (BS) accounts, use the dropdowns in the Map to columns.

You must map all accounts before you exit this page. Unmapped items will cause problems with your balance sheet data.

To load cash flow (CF) accounts:

1. Select Refresh accounts.
   The refresh process requires you load a .csv file that already has the account and corresponding attribute filled out.
2. If needed, select or clear the relevant checkbox for each CF account.

To map balance sheet planning accounts to cash flow accounts, use the dropdowns in the Map to Planning Account CF column.

You must map all accounts before you exit this page. Unmapped items will cause problems with your cash flow data.

Each department should be defined as either a revenue department or a cost-of-goods (COGS) department. 

To define a revenue or COGS departments, select or clear items in the columns Revenue Departments or COGS Departments.

To load FX currencies and monthly FX rate:

1. Select Refresh currencies.
2. Select Refresh rates.