Importing Bank Statement Details

You can import bank statement details using a CSV file or through the Importing Plaid Bank Statement Details process.

Importing Bank Statement Details using a CSV File

To import bank statement details using a CSV file:

  1. Check that the relevant bank account has a valid bank statement definition associated with it.
  2. Click the Bank Statements tab.
  3. Click New.
  4. [Optional] Amend the default bank account, opening balance and statement date as required.
  5. [Optional] Enter the closing balance as an additional check.
  6. [Optional] Enter a reference to help you identify the bank statement later.
  7. Click Browse next to Statement File and select the bank statement import (CSV) file from your computer. If you are on a Mac, this file must be saved in windows.csv format.
  8. Click Import.
  9. If a closing balance has been specified, but it does not match the calculated balance, a warning is issued. Click Accept to continue using the calculated value, or Cancel to abort.

The imported CSV file is attached to the new bank statement record.

Note:

The import will fail with an error message if any of the statement lines have dates later than the statement date. If this happens, adjust the statement date and try again.