Importing Bank Statement Details Using a CSV File

You can import bank statement details using a CSV file.

Note:

You can also import bank statement details through:

• The Plaid bank integration process. For more information, see Plaid Bank Integration Overview.
• The Envestnet bank integration process. For more information, see Envestnet Bank Integration Overview.

Before importing your bank statements, you must ensure that your current company The company in which you are working. This is represented by the company queue to which you, and new instances of objects you create, are assigned. matches the company associated with the bank account defined for the bank statements. This means that you must set the company associated with the bank account as your current company The company in which you are working. This is represented by the company queue to which you, and new instances of objects you create, are assigned..

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.