Importing bank statements for Expense Management reconciliation

  • 02/07/2025
  • 3 Minuten Lesedauer

To use bank account reconciliation, you must first upload a bank statement to Business Central, after which you can reconcile transactions for a period that you specify.

Importing a bank statement

To import a bank statement into Business Central:

  1. Search for Search Bank Transactions.
  2. On the action bar, click Import Statement Transactions (or open the More menu (...) if it isn't displaying directly on your action bar).
  3. Select your bank from the list. Alternatively you can create a new bank import template, for more information, see Importing transactions with custom templates.
  4. Fill in all relevant information.
  5. On the action bar, click Transaction Import Journal, under General, toggle Statement Transactions to on, and click OK.
  6. On the action bar, click Approve and Transfer.
  7. Verify that the statement transactions have been imported; On the Bank Transactions Inbox page, add the filter Bank Statement Transaction and select Yes from the dropdown menu.

You'll now see the imported statement transactions.

Reconciling transactions

After you've imported a bank statement (or bank statements), you can begin to reconcile transactions for the duration of the dates that you specify.

To reconcile the bank transactions of a specified period of time:

  1. Search for Search EM Bank Account Reconciliation.
  2. On the action bar, click New to create a new reconciliation.
  3. Under General, fill in all relevant fields that match your setup.
  4. On the action bar, click Bank > Import Bank Statement.
  5. In the dialog that pops up, select Find existing statement transactions in the system.
  6. Fill in the dates matching the period that you want to reconcile, then click OK.

Expense Management bank account reconciliation

Importing transactions with custom templates