Troubleshoot bank and credit card imports
Most bank and credit card import problems come from the file itself: amounts in the wrong column, a bad or blank date, reversed signs, or transactions from another account. Run the checklist below before you import.
Common causes
Section titled “Common causes”Nexsyis reads your file with an import template that says which column holds the date, description, reference and amount. If any row doesn’t follow that layout, the import or the reconciliation is off.
- Shifted columns. Some bank exports put a few rows’ amounts one column to the right. The total is then off by those amounts.
- Bad dates. A blank or badly formatted date can cause the error “Conversion from string to type ‘Date’ is not valid” when you open the Reconcile Items tab.
- Reversed signs. The template treats charges as deposits, or the other way around.
- Mixed accounts. One export can include several cards or accounts, so the ending balance won’t match the one account you’re reconciling.
Checklist
Section titled “Checklist”- Download a .bai file if your bank offers one. It’s the preferred format. Use .csv or .qif only if .bai isn’t available.
- Open a CSV file in a spreadsheet first. Scroll to the bottom and make sure every amount is in the same column. Move any shifted amounts back.
- Check that every row has a valid date in the date column, with no blanks or text.
- Make sure the file has only one account or card. Remove rows for other accounts.
- Select the right import template for that bank or card. If the signs look backwards, check the Amount, Sign Col, or withdrawal and deposit mapping. See Map a bank file.
- After loading, check the Tr Grp column. Fill in any blank lines before you select Save.
- Compare the totals. The previous ending balance plus the imported transactions should equal the statement’s ending balance. If not, add up the file’s transactions to find the gap.
Example
Section titled “Example”An import is off by the total of the last three rows. Opening the CSV file shows those three amounts are one column to the right. Moving them back and importing again fixes the balance.
When to contact Nexsyis Support
Section titled “When to contact Nexsyis Support”- You get an error when opening the reconciliation or the Reconcile Items tab.
- Your file looks clean but the ending balance still won’t match.
Attach the exact download file and tell Nexsyis Support the ending balance you expect, so they can test it against your template.
