Bank Account Reconciliation

Created by James Smith, Modified on Tue, 1 Apr at 1:44 PM by James Smith

TABLE OF CONTENTS


Creating a New Reconciliation

  1. Navigate to the page "Bank Account Reconciliations"
  2. Click New
  3. Fill out the Bank Account No. based on your Business Central Bank Accounts. Add in the Statement Date and the Statement Ending Balance as provided by your bank.
  4. Choose one of the following
    1. If you have an electronic file with the bank statement
      1. Import your bank statement file received from the bank
         
      2. Run the Match Automatically Function
      3. Manually Match any missing matched lines (select the line on both sides so that the arrow points at a match)
      4. Click Transfer to General Journal if there are any remaining unmatched statement lines and move to step 5 of the main document
    2. If you do not have a file to import
      1. Choose Suggest Lines
      2. Unmatch and delete any unwanted lines
      3. Manually add any missing lines from the statement.
      4. Click Transfer to General Journal
         
  5. Fill in the details for the missing statement lines against the line created by the bank reconciliation
  6. Post the Journal and return to the Bank reconciliation. The lines you posted will automatically have matched.
  7. The Total Balance and Statement ending balance should now match.
  8. Post the reconciliation


What to Do if the Bank Account ledger is missing lines

  1. Manually add any missing lines from the statement onto the bank statement lines.
  2. Click Transfer to General Journal
     
  3. Fill in the details for the missing statement lines against the line created by the bank reconciliation
  4. Post the Journal and return to the Bank reconciliation. The missing lines will have automatically matched


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article