Map the value of each bank movement as Amount, Money in or Money out. A running Balance column shows the account balance after activity and must not be used as the movement amount.
- Compare a known transaction with the bank statement and identify the exact charge or deposit column.
- Check the mapping in Imports. If it points to Balance, select the actual amount column or the separate debit and credit columns.
- Review the interpreted amount and aggregate money-in and money-out totals again.
Running balances may look like valid numbers, so numeric validation alone cannot detect that you chose the wrong financial meaning. A preview showing large repeated amounts or only positive inflows can be a clue to revisit the mapping.
Preserve balance evidence separately
Opening and closing balances are useful for statement and reconciliation checks. Keep them in the original statement, while the transaction table contains the individual movements.
If you already committed an import with a balance column mapped as amounts, stop further posting and inspect that batch’s results. Use the available rollback or correction process and review protected rows separately. Reimport only after the source mapping is corrected.
Was this article helpful?
Tell us whether this answered the question you came with.