Creating chart of accounts mapping

  1. Click the Accounts hyperlink of the corresponding general ledger mapping record for which to create a chart of accounts mapping.
  2. Select manual or batch uploading.

    For manual adding, perform these steps:

    1. Click Add.
    2. Specify this information:
      From Account
      Select the desired account number. This dynamic list displays the account numbers associated to the selected From Accounting Chart.
      Note:  Total Mapped Rate is displayed below this field to show the accumulated allocation rate mapped for the same source ledger account.
      Allocation Rate
      Specify a numeric value ranging from 0.01 to 100.00 representing the percentage of amount to be allocated from source ledger account to destination ledger account.
      To Account
      Select the desired account number. This dynamic list displays the account numbers associated to the selected To Accounting Chart.

    For batch uploading, perform these steps:

    Note: The batch upload facility allows to create multiple chart of accounts mapping records from an upload file.
    The upload file must have a .csv file extension and adhere to this format:
    Column Names Type Field size
    From Account Alphanumeric 255
    Description Alphanumeric 255
    Allocation Rate Numeric 15
    To Account Alphanumeric 255
    Description Alphanumeric 255
    Note: Make sure to convert the GL accounts properly. For example, if the GL account starts with leading zeroes, ensure that the .csv file must start with zeroes.
    1. Click Import Account Mapping.
    2. Specify this information:
      File Location
      Select the .csv file to import.
    3. Click Upload.
  3. Click Save.