Importing Plaid Bank Statement Details

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

The Plaid bank integration process, through permission-based, secure authentication, enables FinancialForce Accounting to import bank account transactions from your bank or other financial institution on demand.

For more information about Plaid Integration, see Plaid Bank Integration Overview.

Note:

You must run this process in single company mode.

To import bank statements for one or more bank accounts belonging to the current company:

1. Click the Bank Accounts tab.
2. Click one of the bank accounts for which you want to import bank statements.
3. Click Import Statements. This displays a list of all bank accounts for the current company, with the bank account you clicked on seleted.
4. [Optional] Select additional bank accounts if required. Statements will be imported for all selected accounts, as long as they have an associated bank account connection record.
5. Enter the Statement Date to import transactions up to that date.
6. Click Import Statements. The import process runs in the background and you will receive an email when the process completes.

Note:

If the volume of bank statement line items exceeds the number specified in the Maximum Bank Reconciliation Transactions custom setting, multiple bank statements are created. You must reconcile them in order based on the numerical statement reference suffix, starting with the lowest. For example: "2020-10-07 - Plaid - 1" followed by "2020-10-07 - Plaid - 2".

Calculating the Start Date and Opening Balance for the Imported Statements

If this is the first statement you have imported for the bank account:

• All transactions dated from the start date entered on the bank account connection record up to and including the statement date are imported
• The statement’s opening balance is derived from the opening balance entered on the bank account connection record

If statements already exist for the bank account:

• The start date is the day after the statement date of the most recent statement
• The opening balance is derived from the closing balance of the most recent statement

Note:

The statement’s closing balance is a calculated value. You must check that this matches the balance in your bank’s software.

Troubleshooting

If you attempt to import a statement for bank accounts that are not configured correctly for Plaid Integration, you will receive an error message when you click the Import Statements button.

Check the following if you do receive an error:

• The selected bank account must belong to the current company
• The selected bank account must be linked to a bank account connection record
• The selected bank account and its associated bank account connection must share the same currency
• If no statements already exist for the bank account, the start date and the opening balance must be defined on the associated bank account connection