Skip to content

Import bank and credit card transactions

To reconcile a bank or credit card account, first import the transactions from your bank’s or card company’s website. Each imported line is given a trans group, which tells Nexsyis how to reconcile it.

Nexsyis keeps the bank statement detail and the check register separately and matches them one transaction at a time. You can import and reconcile at any time, not only at month-end. Credit cards are imported and reconciled the same way as bank accounts.

  1. On your bank’s website, export the transactions to a .bai file (preferred), .csv file or .qif file.

  2. In Nexsyis, on the Accounting tab, select Account Reconciliation, then Import Bank File.

    The Account Reconciliation menu with Import Bank File, Bank Imports, Reconcile Bank Accounts and Reconcile Credit Cards

  3. Select the search button next to File and find the file you exported.

    The Import Bank File screen with the search button next to File

  4. Depending on the file type:

    • CSV file: select the bank in Import Template to load its mapping.

      The Import Template list on the mapping screen for a CSV file

    • QIF file: select the bank or credit card, and use the Bank and Credit Card options to change the type.

      Selecting a bank for a QIF file, with the Bank and Credit Card options

  5. Select the green next arrow at the bottom of the screen.

  6. Check that no line has a blank Tr Grp (trans group).

    An imported line with a blank Tr Grp

  7. For each blank line, double-click the Tr Grp column and select the right trans group from the list.

    The trans group list on an imported line

  8. Select Save. When asked whether to delete the source file from your computer, select Yes if you don’t need the exported file (the most common choice).

    The Import Complete message asking whether to delete the source file

Check the Totals By Account at the bottom: the previous ending balance plus the imported transactions should equal your statement’s ending balance. You can now reconcile the account.

Trans group Use
CASH-CHECK Cash and check deposits.
RTM Returned checks. You can search for the matching payment from the reconciliation screen.
FEES Bank and credit card fees.
TRF Transfers between bank accounts. Nexsyis tries to match the in and out transactions automatically: opposite amounts within a day of each other. If they can’t be matched automatically, you match them on the reconciliation screen.
EFT Electronic payments deposited to your account that match payments in Nexsyis, such as one insurance payment for several repairs. You create a deposit of the payments that make up the transaction.
CCRD Credit card deposits and withdrawals. You create a deposit of the payments that make up the transaction.

The full list is set up under Setup › Accounting › Banking / Cash › Trans Groups. See Map banking transaction groups.

On the Accounting tab, select Account Reconciliation, then Bank Imports. Set the From and Thru dates and the Bank, and refresh the list.

The Bank Imports list with Beg Bal, Deposits, Withdrawls, Net Change and End Bal

  1. Log in to the American Express website.

  2. On the Statements & Activity tab, select Current Statement.

    The Current Statement list on the American Express website

  3. Select the download icon, then Current View.

    The download icon and Current View

  4. Select CSV and Include all additional Transaction Details, then select Download and save the file.

    The download options with CSV selected