Introduction

In this tutorial, you learn how to import balances with data integration and load them into Account Reconciliation.

Background

In this tutorial, you perform the following tasks in Account Reconciliation:

  • Review the Account Reconciliation target application
  • Review Periods and Category Mapping
  • Create an Integration
  • Test the Integration
  • Import balances into Account Reconciliation
  • Review reconciliation balances
  • Create reconciliations

Prerequisites

Before starting this tutorial, you should have:

  • A working knowledge about Account Reconciliation.
  • Access to Account Reconciliation, and a source data load file. You can save this sample file locally and then use it to create an integration.

Reviewing target application in Data Exchange

In Account Reconciliation, you can check the target application by performing the following steps:

  1. From the Account Reconciliation home page, click the Application card and select Data Exchange.
    2. Launch Data Exchange
  2. From Data Integration, select Actions > Applications.
    3. Navigate to Applications
  3. Select Reconciliation Compliance Balances to view the application details.
    4. Navigate to Reconciliation Compliance Balances
  4. In the Application Details, review the dimension details of the target application. In this example, the target application includes the Account, Company, Currency Bucket, Period, Profile, and Source Type dimensions.
    5. View of Applications Details

Reviewing period and Category Mapping

To review Period Mapping and Category Mapping, perform the following steps:

  1. In Data Integration, select Actions > Period Mapping.
    2. Navigate to Period Mapping

    The Period Mapping page is displayed. Here, you can view the Global Mapping and Application Mapping tabs.

    View Period Mapping
  2. In Data Integration, select Actions > Category Mapping.
    3. Navigate to Category Mapping

    The Category Mapping page is displayed. Here, you can view the Global Mapping and Application Mapping tabs.

    View Category Mapping

Creating integration

In Data Exchange, you can create a data integration by using the following steps:

  1. In data integration, click the New icon.
    2. Click New
  2. In the General tab, provide the required Name, Location, Source and Target. Proceed by clicking the Save and Continue button.
    3. General tab
  3. In the Map Dimensions tab, you can specify how source columns map to the dimensions in the target application. Proceed by clicking the Save and Continue button.
    4. Map Dimensions tab
  4. In the Map Members tab, define the data load mappings for each target dimension.
    5. Map Members tab
  5. To save the integration, click the Save drop-down and select Save and Close.
    6. Click Save and Close

Testing data integration

In Data Exchange, you can run a data integration by following these steps:

  1. To run a data integration, click the Run icon.
    2. Click Run
  2. The Run Integration pop-up window is displayed. Here, you can select the required Import Mode, Export Mode, Start Period, End Period and File. After providing the required information, click the Run button.
    3. Run Integration

    The integration is executed successfully.

    Integration Successful

Importing balances into Account Reconciliation

In Account Reconciliation, you can import balances by following these steps:

  1. From the Account Reconciliation home page, click the Applications card and select Periods card.
    2. Select Periods
  2. The Periods page is displayed. Click the Actions icon for the required period and select Import Data.
    3. Select Import Data
  3. The Data Load Execution window is displayed. You can click the New button to add new balances.
    4. Run Integration
  4. The New Data Load Execution window is displayed. Enter the required details, select the correct location, and then click the OK button.
    5. New Data Load Execution
  5. The balances have been imported successfully.
    6. New Data Load Execution

Reviewing loaded balances

In Account Reconciliation, you can review loaded balances by following these steps:

  1. From the Account Reconciliation home page, click the Reconciliations card.
    2. Click Reconciliations
  2. The Reconciliations page is displayed. Click the Reconciliation Balances tab.
    3. Click Reconciliation Balances
  3. The Reconciliation Balances tab displays the balances loaded for all reconciliations in a particular period. Click a reconciliation name to view the required details.
    4. Reconciliation Balances tab
  4. Click the Detail Balances tab.
    5. Click Detail Balances
  5. The Detail Balances tab displays information such as Account ID, Name, Company, Account, Bucket, Currency, Type, and Amount. You can sort the information in ascending or descending order by using the arrow icons against each column. Note that balances are loaded for new company and account combinations as well. You will need to create Profiles for such cases. To create Profiles directly from this screen, you can use the Ellipsis against each balance either on the Detail Balances tab or on the Reconciliation Balances tab for Group Reconciliations.
    6. Detail Balances tab

Reviewing profiles and creating reconciliations

In Account Reconciliation, you can review profiles and create a reconciliation by following these steps:

  1. From the Account Reconciliation home page, click the Applications card and select Profiles.
    2. Select Reconciliations
  2. The Profiles page is displayed. Here, you can view the required profiles by adding filters. Click the New icon to create new profiles for balances that have been loaded but do not have any profiles assigned to them.
    3. View Profiles
  3. Click the Actions drop-down and select Create Reconciliation.
    4. Click Create Reconciliation
  4. Select the required period and click Apply.
    5. Select Period
  5. You can create a reconciliation for the selected profile or for all available profiles. For this example, we will create a reconciliation for the selected profile. Click Apply.
    6. Select Profiles

    The reconciliation has been created.

    Reconciliation created
  6. From the Periods page, you can now change the status from Pending to Open.
    7. Select Profiles