Home Vendor Reconciliation How do I specify how amounts are represented in the file?

How do I specify how amounts are represented in the file?

Last updated on Apr 28, 2026

Short Answer: Under "6. Amount representation" choose either "Single signed amount column" or "Separate debit and credit columns" to match your file.

PreRequisites

  1. You have identified how amounts appear in the preview (signed single column or separate debit/credit).

Steps

  1. Look at the amounts in the preview rows to confirm whether they appear in one column with sign (positive/negative) or across separate debit and credit columns.
    You know which amount representation matches your file.

  2. Select the matching radio under "6. Amount representation":
    "Single signed amount column" or "Separate debit and credit columns".
    The chosen radio button is selected.

  3. Preview sample rows to verify amounts look correct, then click "Save & apply".
    Amounts will be interpreted according to the selected representation after saving.

Troubleshooting

  1. Totals or signs are wrong after applying mapping.
    LikelyCause: Wrong amount representation selected.
    Action: Return to the dialog and switch the option in "6. Amount representation" to the other choice, then reapply.