Branch Account Setup Tool of Intercompany Solution

Branch Account Setup Tool of Intercompany Solution

Enables you to map Due From and Due To accounts in the branch accounts setup.

To display the Branch Account Setup Tool window, choose Administration → Intercompany Tools → Branch Account Setup Tool.


Branch Account Setup Tool Window

Field

Description

Excel File Path

Select the path of the branch account template file.

Prepare Template

Choose this button to prepare a Microsoft Excel-based template.

Validate

Choose this button to have the application check the correctness and completeness of the data in the selected template.

Upload

Choose this button to import a branch account template.

Cancel

Choose this button to close Branch Account Setup tool window.


Use the following steps to import data using the branch account setup tool:

  1. Choose the Prepare Template button to generate the Microsoft Excel-based template. 
  2. Open the template and define the Due From Account and Due To Account fields against each branch code. Choose the Save button to save the template.

Note

 a. The Due From Account and Due To Account must be set up as an All Currencies account in the chart of  accounts to support transactions in multiple currencies.
 b. You specify the Due From Account and Due To Account fields for each branch code.

Caution

Do not alter the template or delete or modify records in any column other than the Due From Account and Due To Account column.

  1. Choose the Browse button to navigate to the template path.
  2. Choose the Validate button to check the correctness and completeness of the data in the selected template. If any errors If any errors are detected, they are displayed in the error column of the template. Rectify all errors and validate the template again.
  3. Choose the Upload button to import the data.


Next Step: Account Classification Setup Tool of Intercompany Solution

    • Related Articles

    • Consolidation Account Mapping Tool of Intercompany Solution

      Enables the user to map an active G/L account of the consolidation company to the active G/L accounts defined in the branch company’s chart of accounts. This tool updates the Consolidation Account Mapping window. To display the Consolidation Account ...

    • Consolidation Setup in Intercompany Solution

      To setup the consolidation process, perform the following tasks: Define the consolidation companies in the Intercompany Landscape application and set their Company Type as Consolidation. In the Administration Console, on the Company Registration ...

    • System Health Check (System Status) tool for troubleshooting in Intercompany Solution

      The users can look forward to the addition of a powerful "System Health Check" tool within the Intercompany Administration Console. This innovative feature empowers administrative users to initiate a thorough health check, obtaining a wealth of ...

    • Account Classification Setup Tool of Intercompany Solution

      Enables you to map a G/L account to the account classifications defined in the system. This tool updates the Intercompany Account Classification by Balance Sheet and Account Classification by Profit & Loss Setup windows. To display the Account ...

    • Branch Accounts Setup of Intercompany Solution

      The Branch Accounts Setup window enables you to define Due From and Due To accounts for branch companies other than the one to which you are logged on. You must choose accounts that are defined as All Currencies accounts in the Chart of Accounts. ...