Import Bank Data for Bank Account Reconciliations

Required Permission Set in Business Central: KXA ACCOUNTANT PERM (Bank Connect Accountant)

Bank Connect can automatically import bank statement data into Business Central's Bank Account Reconciliations to help you reconcile transactions against your bank accounts. You can also manually import bank data to retrieve missing or updated transactions.

Manually Import Bank Data

Note: Users with the Bank Connect Accountant permission set can manually import bank data without being linked in Bank Connect.

1. Search for Bank Account Reconciliations.

2. Open the statement for the bank account you want to update
   Or
   select New and choose your desired bank account.

3. Select Bank Connect → Import Bank Data to manually retrieve bank statement data for the selected account.

4. In the Import Bank Data window, select the Date Range to Import:

   • Single Date: Import bank data for a specific date.
   • Last 7 Days: Import bank data for the seven days ending yesterday.
   • Previous Calendar Month: Import bank data for the entire previous calendar month.

5. If Single Date is selected, enter the desired date.

   • Current and future dates cannot be selected.

6. Click Import Bank Data to begin the import.

Automated Bank Data Imports

Bank Connect also supports automated bank statement imports for Bank Account Reconciliations. When enabled, bank data is imported automatically according to the configured schedule.

Manually importing bank data does not affect the date range used for the next scheduled automated import.

For instructions on enabling and managing automated imports, see Bank Connect Automation Settings.