Expense Management Bank Account Reconciliation

  • 01/09/2022
  • 4 minutes to read

Find missing transactions and reconcile transactions with a statement, using the Expense Management Bank Account Reconciliation feature.

This feature is very similar to the standard bank reconciliation feature in Dynamics 365 Business Central. However, Expense Management Bank Account Reconciliation comes with a few extra advantages:

  • You can reconcile a bank account, G/L account, or vendor
  • You can see the status of expenses

You can carry out monthly reconciliations by suggesting lines, importing statement transactions, or entering information from a statement manually while comparing paper statements from the bank to transactions in Expense Management.

You can choose to match automatically or manually.

Automatic matching

  1. Search Search for Expense Management Bank Account Reconciliation, then choose the related link.

  2. On the action bar, select New.

  3. Under General, select a bank account type.

  4. Select a bank account number. Any bank transaction entries connected to this account will be display automatically.

  5. To get bank statement lines, either:

    1. On the action bar, select Bank > Import Bank Statement.
    2. In the dialog box, select Import a new Bank Statement File or Find existing statement transactions in the system, then select OK.

    Or

    1. On the action bar, select Home > Suggest Lines.
    2. Under Options, fill in the fields, then select OK.

  6. On the action bar, select Matching > Match Automatically, then select OK.

  7. When you have matched both sides, copy the amount from Total Balance and insert it into Statement Ending Balance.

  8. On the action bar, select Home > Post to post the reconciliation.

To view posted reconciliations, search Search for Expense Management Bank Account Statements, then choose the related link.

Manual matching

  1. Search Search for Expense Management Bank Account Reconciliation, then choose the related link.

  2. On the action bar, select New.

  3. Under General, select a bank account type.

  4. Select a bank account number. Any bank transaction entries connected to this account will display automatically.

  5. To get bank statement lines, either:

    1. On the action bar, select Bank > Import Bank Statement.

    2. In the dialog box, select Import a new Bank Statement File or Find existing statement transactions in the system, then select OK.

      Or

    3. Refer to your bank statement, fill in the fields for Transaction Date, Type, Description, and Statement Amount.

  6. Select the bank statement line and the bank transaction entry you want to match, then on the action bar, select Matching > Match Manually. Repeat the process for each bank statement line.

  7. On the action bar, select Home > Post to post the reconciliation.

To view posted reconciliations, search Search for Expense Management Bank Account Statements, then choose the related link.

See also