Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Contra Accounts

Contra Accounts

With 2022R2, we now enable you to use contra accounts in Adaptive Planning, helping you better align your account hierarchy with source systems.
Watch the video:
 4m 36s

Contra Accounts for Modeling

Release: 2022-09-10
With this update, you can now change the Balance Type account details on a general ledger account. When you change the balance type of an account to be different than the root account it rolls up to, the account becomes a contra account. Using contra accounts reduces rollup values while reducing the manual effort needed to enter negative numbers.
We also deliver these new columns when you export spreadsheets for your accounts:
  • Balance Type, which you can use to change the account type to credit or debit.
  • Contra Account, which indicates contra accounts in your account structure.
We also add the new Balance Type column to the template you can use for importing accounts.

Contra Accounts for Standard and Cube Sheets

Release: 2022-09-10
For clarity, we now display an icon next to contra accounts and contra account rollups on:
  • Sheet rows on standard and cube sheets.
  • Sheet columns on cube sheets.
  • The Explore Cell for accounts and contributing accounts on standard and cube sheets.
When you have a contra account on a sheet, you can also view these items in the printable view:
  • Contra Account column on standard and cube sheets.
  • Contra Account row on cube sheets.
On the printable view of a sheet, we also add a new Contra row on the Information about this Sheet tab when you:
  • View by level or select an account on standard and cube sheets.
  • Pin an account on cube sheets.

Support for Contra Accounts in APIs

Release: 2022-09-10
We now support contra accounts in updateAccounts and createAcount APIs to:
  • Set the balance type for an account.
  • View if an account is a contra account.

Support for Contra Accounts in Adaptive Planning Integration

Release: 2022-09-10
With this update, you can now update the balance type for general ledger accounts using the Account loader in Adaptive Planning integrations.

Ledger Account Normal Credit or Debit Balance Report Field

Release: 2022-09-10
We deliver a new Ledger Account Normal Credit or Debit Balance report field on the Plan Dimension business object (secured to the Public Reporting Items domain) that you can use in condition rules and custom reports to view whether a ledger account has a normal credit or debit balance.

Support for Contra Accounts in Dashboards

Release: 2022-09-10
We update dashboard charts by now indicating when an account is a contra account. When you include a contra account in a waterfall chart, we also now invert the breakdown to ensure that the sum of the waterfall steps equals the comparison value.

Contra Accounts for EIP

Release: 2022-09-10
To improve the user experience and support contra accounts, we update sheets by now indicating when an account is a contra account.

Contra Accounts for Matrix Reports

Release: 2022-09-10
In the matrix report viewer, we now indicate when an account is a contra account. Workday also now bases the Reverse Sign property in Difference calculation elements on the balance type, not root account.

Contra Accounts for OfficeConnect

Release: 2022-09-10
When you use contra accounts in OfficeConnect, we now enable you to indicate the accounts in the Microsoft Excel report. You can apply a new Account Contra Indicator label on your report to view the indicator, and we also display the indicator in the Review tab for cell, row, column, workbook, and worksheet nodes.