Short answer
A sign problem normally comes from the import mapping: separate debit and credit columns may be reversed, or a single amount column may use the opposite positive and negative convention from the selected mapping.
What to check first
Why this happens
Banks export CSV/Excel files in different formats. A positive number can mean money in for one source and money out for another, so Balansix relies on the import mapping to interpret direction correctly.
Steps to resolve it
- Cancel the import before posting if the preview direction is wrong.
- Return to column mapping.
- Map Debit/Credit separately where the file has two columns, or set the correct direction for the single amount column.
- Preview a known receipt and payment.
- Import only after the directions agree to the statement.
What to avoid
Frequently asked questions
Can Balansix import a bank file with one amount column?
Yes. Single-amount-column imports are supported, but the positive and negative direction must match the source file.
What if the bank uses brackets for negative numbers?
Check the preview to confirm the value is parsed correctly. If not, normalise the source or mapping before import.
Should I delete an incorrectly imported batch?
Use the supported correction/deletion workflow only if the batch is not protected by posting and reconciliation locks. It is better to catch sign errors in preview before posting.