What does 'Amount representation' mean and how do I choose it?

Short Answer: 'Amount representation' defines how transaction amounts are stored in your file—either in a single column with positive/negative values or in separate credit and debit columns. Choose the option that matches your file structure.

Answer

PreRequisites

1. Open 'Configure bank statement' or 'Configure books data' modal.

Steps

1. Click 'Edit' on the uploaded file card to open the Configure modal.
   The Configure modal opens with mapping fields.

2. Locate 'Amount representation'.
   You will see two options:
   • Single signed amount column
   • Separate credit and debit columns

3. Choose the correct option based on your file format:
   • Select 'Single signed amount column' if your file has one column with positive (+) and negative (-) values.
   • Select 'Separate credit and debit columns' if your file has two columns—one for credit and one for debit.

4. Map the 'Amount column' (or the credit/debit columns if applicable).
   This ensures the system correctly understands the transaction amounts.

5. Click 'Save & apply' to confirm the mapping.
   The amounts are now interpreted correctly during reconciliation.

Troubleshooting

1. Amounts appear incorrect (sign reversed or values doubled).

   Likely Cause:

   • The wrong amount representation option was selected.
   • The system is misinterpreting credit/debit values.

   Action:

   • Open the Configure modal using 'Edit'.
   • Switch to the other 'Amount representation' option.
   • Re-map the amount columns.
   • Click 'Save & apply' again.

Note: Always choose the option that matches your file structure to ensure accurate amount calculation during reconciliation.