Sign-based mapping enables you to automatically route imported data to different target members based on whether the source value is positive (+) or negative (-). 

This is useful for handling accounting scenarios, such as reclassifying a cash account with a negative balance from an asset to a liability during data import. This feature removes the need for manual journal entries or other workarounds for sign-based reclassifications.

Set up sign-based mapping

  1. Navigate to Configure > Maps.
  2. Create a new mapping table or select an existing one.
  3. In the Mapping Options, select the Sign-Based Mapping checkbox.
  4. On the mapping table row, select the ellipsis and choose Edit Mappings.
  5. In the mapping table grid, a Source Sign column will appear. For a specific Source Value, you can create separate mapping lines for positive (+) and negative (-) values.

Note: If you leave the Source Sign empty, all the values are mapped to the same target. You can't use empty in combination with positive (+) and negative (-).

  1. Define the target Mapped Value for each sign. For example, for source account BA5500 (Cash), you can map positive values to target 1000 (Cash) and negative values to target 2300 (Accrued Liabilities).

Related content