Corporation Switch User Manual

Submitting Data 14-13
are checked.
Note: Input the dimension member codes in the spreadsheet.
Selected User Interface Elements for Submitting Data for External Sources
Selected user interface elements for submitting data for entities with External sources
are described in the following sections.
Balance Type
You can submit actual or average balances for the data submission. You can also submit
data for any additional data types that you have defined and assigned to the entity.
Measure
For external entities, you can submit balances using Debits and Credits or Net. If your
source system outputs a trial balance with separate columns for debits and credits,
select the Debits and Credits option. If your trial balance includes only a single net
balance number for each combination of dimension members, select Net. In this case,
Financial Consolidation Hub expects debit balances to be entered as positive numbers
and credit balances to be entered as negative.
Currency Type
If you select the Functional Currency Only option, you must specify a functional
currency in the Currency field. In the spreadsheet loader, fill in the trial balances in that
currency.
If you select the Transactional Currency option, in the spreadsheet loader you must
enter the transactional currency, transactional amount, and the functional amount of
each account.
Execution Mode
Data is submitted to the system in one of the following modes:
• Initial Load - This will be the first data submission performed for the entity, period,
currency, and balance type.
• Incremental - The loaded balances are aggregated to previously uploaded balances
data for that entity, period, currency, and balance type.
• Replace - The system replaces rows where an existing dimension combination is
also part of the latest upload, inserts new rows where the two sets do not overlap,