Import Bank Statement

Overview

The Bank Statement Importer allows you to manually import bank transaction data from statement files downloaded from your bank. This is useful when automatic bank feeds are not available or for importing historical transactions.

Bank Statement Importer UI

Accessing the Importer

Navigate to Bank Statement Importer in NexWave.

You can also access it directly from the Bank Reconciliation Tool by clicking Upload Bank Statement. When you do this, the bank account you selected in the reconciliation tool is automatically carried over, so you do not need to re-select it.

Supported File Formats

• CSV (Comma Separated Values)

• XLSX (Excel)

• XLS (Legacy Excel)

How to Import

Step 1: Select Bank Account

1. Open the Bank Statement Importer page

2. Select your Company

3. Select the Bank Account to import transactions into (this is pre-filled if you navigated from the Bank Reconciliation Tool)

4. The system will display the last imported transaction date for reference

Step 2: Upload Statement File

1. Click Import File to attach your bank statement

2. Select your downloaded statement file

3. Click Upload Statement

Step 3: Map Fields

After upload, the system reads your file and displays field mapping options. Map each column from your bank statement to the appropriate transaction field.

Mapping bank statement fields

Click Map Fields to preview the mapped data.

Date Format Guide

Selecting the correct date format is critical. If the wrong format is chosen, dates may be parsed incorrectly (e.g., month and day swapped). The field includes inline examples to help:

Tip: Open your CSV in a text editor (not Excel) to see the raw date values before selecting the format. Excel may auto-format dates and hide the actual format used in the file.

Step 4: Preview and Import

1. Review the preview table to ensure data is mapped correctly

2. Duplicate transactions are automatically detected and flagged

3. Click Import to create Bank Transaction records

Preview and import

Bank-Specific Mappings

If your Bank Account is linked to a Bank record with pre-configured field mappings, the importer will automatically apply those mappings, saving you time on repeated imports.

To save a mapping for future use, check the Save field mapping for future use option before importing. The next time you upload a statement for the same bank, the field mappings will be pre-filled.

Credit Card Accounts

Credit card statements report deposits and withdrawals the opposite way around to a normal bank statement. Charges on the card appear in the statement's "deposit" column, and payments to the card appear in the "withdrawal" column. If imported with the standard mapping, those transactions land in the wrong columns and the Bank Reconciliation Tool cannot match them correctly.

To handle this, the Bank Account form has a Credit Card checkbox. When ticked on a Bank Account, the Bank Statement Importer automatically swaps the Deposit and Withdrawal columns at import time for that account, so charges are recorded as withdrawals and payments as deposits.

If the flag is not ticked, the same result can be achieved manually by swapping the Deposit and Withdrawal column mappings during Step 3, or by flipping Positive Amount Field to Withdrawal if the file uses a single signed amount column.

The flag only affects new imports. Existing Bank Transactions are not modified when the flag is toggled.

After Import

Imported transactions appear in the Bank Reconciliation Tool where you can:

• Match transactions to existing invoices and payments

• Create journal entries or payment entries for unmatched transactions

• Run Bank Rules to automate recurring patterns

• Reconcile your bank account

Troubleshooting

Related Documentation

• Bank Reconciliation Tool - Reconciling imported transactions

• Bank Feeds - For automatic bank transaction synchronisation

• Accounting - Financial management overview