Processing Bank Account Reconciliations in Microsoft Dynamics 365 Business Central


The bank account reconciliation example I am going to use is with an account that I have linked. If you're bank account isn't linked, you can review this blog on steps to complete that task. 

  1. Search for Bank Reconciliation

  2. Process > New

  3. Select Bank Account you'd like to reconcile

  4. Populate the Statement Date and Statement Ending Balance fields.

  5. Bank > Import Bank Statement

    Update the from/to dates that you want to import transactions for.

    If you forgot to put in the statement date, then this window will pop up as you import the bank statement.

  6. Bank Statement Lines vs Bank Account Ledger Entries
    • Bank Statement Lines: this is going to show the imported bank statement lines. I have seen before where a transaction isn't imported into Business Central from the bank and in that case, you can just add a line manually. 
    • Bank Account Ledger Entries: this is going to show the entries entered into the bank account sub-ledger in Business Central. If you're missing a transaction here that means it wasn't entered to a bank account yet. If you see it in the G/L of the bank account, then it could've been entered directly to the G/L Account and not the Bank Account. In that case reverse the transaction and re-enter correctly. TIP: the Account Card for bank accounts should have Direct Posting turned off to avoid this issue.

  1. Matching > Match Automatically

    Add number of days you want to allow for the date tolerance. For example, if you cut vendor check on 09/01 and it doesn't clear the bank until 09/10 that is 9 days. If you put 8 days into this field, then it won't match. I like to tell clients to start with a low number and then run this process again with a higher number if they want to match more transactions that were missed the first time around. 

  2. Matching > Match Manually
    This feature allows you to select a transaction on the Bank Statement Lines side and on the Bank Account Ledger Entries side and match them together manually. In the example below I have two payroll transactions on bank statement lines side for $567.66 and $1,054.24. Both total $1,621.90 which is on the bank account ledger entries side. I am going to multi-select them all and match manually.

  3. Matching > Remove Match
    This feature allows you to remove the match if it's incorrect. 

  4. Matching > Match Details
    This will show you the details of the match. 

  5. Process > Transfer to General Journal
    If you have a transaction on the Bank Statement Lines side that doesn't have anything to match to on the Bank Account Ledger Entries side, then you can use the Transfer to General Ledger tool to make the entry really fast. 

    In my case below I have a bank fee of $2.00 that needs to be entered.

    Select Process > Transfer to General Journal

    Select your Gen. Journal Template and Gen. Journal Batch to proceed.

    Populate the General Journal and post. Close window. 

  6. Actions > Matching > Show Nonmatched
    I love this feature because it allows you to show all transactions that aren't matched. Makes it easier to review the data and then manually match if needed.

  7. Actions > Matching > Show All
    Use this to show all transactions again if you have show unmatched active.

  8. Print test report prior to posting. Actions > Posting > Test Report

  9. Bank Acc. Recon. - Test
    Turn on Print Outstanding Transactions and verify the Filter: Bank Acc. Reconciliation section is correct. 

  10. Review report and make sure to print or save. You want to make sure the difference is $0.00 and also that the G/L balance and the Bank balance tie out (match).

11. Posting > Post

Written by: Kristen Hosman, Microsoft MVP


Popular posts from this blog

Microsoft Dynamics 365 Business Central: adding new licensed users to BC

Invited External Accountant in Dynamics 365 Business Central now what?

Dynamics 365 Business Central - Is this a feature or a bug? Filtering and posting General Journal lines