Short Answer: Choose 'Single signed amount column' if amounts use positive/negative signs, or 'Separate debit and credit columns' if debits and credits are in separate columns.
PreRequisites
-
Configure entity A statement dialog open
-
'2. Header row' set so amount columns are visible
Steps
-
Find '6. Amount representation' in the Required fields panel and read the prompt 'How is the amount represented in this file?'.
You see two radio options: 'Single signed amount column' and 'Separate debit and credit columns'. -
Select 'Single signed amount column' if your file has one amount column where negative numbers indicate credits, or select 'Separate debit and credit columns' if there are two separate columns.
The selected option matches the format used in your source file. -
Verify a few amount values in 'Data preview (20 rows)' to ensure amounts appear correctly according to your selection.
Amounts in the preview align with the option chosen. -
If totals or signs look wrong after saving, return to this control and switch to the other option to test which matches your data.
Amounts parse correctly after selecting the correct representation.
Troubleshooting
- Totals or reconciled amounts are incorrect after mapping.
LikelyCause: Incorrect selection between signed amounts and separate debit/credit columns.
Action: Switch the selection under '6. Amount representation' to the other option and reapply. Confirm values in 'Data preview (20 rows)'.