Reconciliation Balances Tab

The Reconciliation Balances tab displays the source system and subsystem balances for all reconciliations in the selected period.

This tab is primarily used to analyse reconciliation balances and check if they have been loaded correctly. Actions that can be performed on this tab are as follows:

  • Filter the displayed data by using the filters on the page. Additional filters can be created using Add a Filter. See Working with Filters.
  • View balances data in the form of a list view (default), pivot view, or chart view. See Working with Views.
  • Edit the reconciliation associated with the balance by clicking the Actions menu and selecting Edit Reconciliation.
  • Edit the profile associated with the balance by clicking the Actions menu and selecting Edit Profile.
  • Import pre-mapped balances by using Import Pre-Mapped Balances under Actions.
  • Export the displayed balances to a Microsoft Excel file by clicking Actions and then selecting Export to Excel.

The image below shows the Reconciliation Balances tab for Account ID 102-151XX. Filters are used to display only the source system balance for June 2024, which is 53,552,550 USD.


This image displays the Reconciliation Balances tab of the Reconciliations card.

If a balance has been loaded, but its corresponding reconciliation has not been created, the Name column displays text (not a link). For such balances, depending on your business scenario, take one of the following actions:

  • Create a profile for this balance.

    For example, if there is a source system balance displayed for Account ID 101-11602, but the Name column is blank, it means that there is no profile corresponding to this balance.

  • To create a profile, click the Actions menu for this balance and then select Create Profile. See Creating Profiles in Setting Up and Configuring Account Reconciliation.

    Update the data load mapping to ensure that this balance is loaded into the correct reconciliation.