Load Contra Accounts in Planning Account Loaders

For Workday Financials: Add the custom report field Ledger Account Normal Debit Balance
to the report used to load accounts in the Workday Data Source for Adaptive Planning.

The field is only available in preview tenants.

For all other data sources loading contra accounts, include a column that contains values of either Debit
or Credit
for the accounts. You can create a Custom SQL column within your data source for these values.

Security:

Model Management Access
permission.

Model
permission.

Integration Operator
permission.

Data Designer
permission.

Planning account loaders can load contra accounts when:

Data sources import a column with values for Debit
or Credit
.

That column maps to Balance Type
in the

Source Id Column

Go to

Integration

Design Integrations

and select the data source for your general ledger accounts.

Select

Import Structure

Select

Import Data

For Workday Financials data sources, ensure that the new custom report field for Ledger Account Normal Debit Balance
displays properly in the staging table.

The field is only avialable in preview tenants.

For data sources not from Workday Financials, ensure the column for Debit
or Credit
values displays properly in the staging table.

Select the account loader that you use to load general ledger accounts from the data source.

Select

Column Mapping

Find the

Balance Type

row and update the

Source Id Column

to select the new column containing the Debit
or Credit
values.

For Workday Financials data sources, select Ledger Account Normal Debit Balance
.

Save and select

Preview Loader Output

Select

Run manually

or run the integration task associated with the loader.

Go to

Modeling

General Ledger Accounts

and export the account structure to filter for Yes
in the Contra Account (Do not change)
column to verify the contra accounts.

Changing an account from contra to non-contra, or non-contra to contra, doesn't change existing values in Adaptive Planning. The values remain the same. How the values roll up when aggregating does change.

Before contra account changes:

Expense 5 (10+ -5)

Materials Expense 10

Contra Materials Expense -5

After contra account changes:

Expense 15 (10- -5)

Materials Expense 10

Contra Materials Expense -5

Contra Materials Expense should be reloaded as a positive 5, because it will now reduce when it aggregates in roll-up.

Delete and reload data for any accounts that have existing data after changing

Balance Type

to Contra
.