Microsoft Copilot $21 now $18/user/month + 1 month free

November 8, 2021

Bank Account Reconciliations in Business Central

One of our experts at Bond Consulting Services has been working on resolving bank transactions in Business Central. The process described is helpful for accounting professionals or anyone managing transactions to fulfill their daily tasks. To reconcile bank transactions in Business Central follow these steps:

  • Select the bank account that you want to reconcile, and on the General FastTab, enter the following fields:
    • Statement Date you are reconciling
    • Statement No.
    • Statement Balance from the bank
  • Select Process > Select “Suggest Lines” to populate the bank reconciliation with all posted bank transactions.
  • Under Record type to process, select the posting date filter, so the system only pulls transactions for the given period. Click “Ok” to pull the transactions.

  • The system will pull the transactions and add them to the corresponding sections. At this point, the Bank Statement Lines now displays the bank statement lines that are applied with the open bank ledger entries that are displayed in the Bank Accounts Ledger Entries window.

  • To remove entries that do not appear in the bank statement, on the “Bank Statement Lines” side, click Select More > Delete Line. Business Central will automatically remove the application on the Bank Account Ledger Entries window and the non-reconciled transactions can be used on the next period or reconciliation.
  • To add the bank related transaction that are not in the system, manually add the line in the Bank Statement Lines window and populate the Transaction Date, Description, Amount fields. Then select Process > Transfer to General Journal.

  • This transaction can be posted in the General Journals window. When posted, Business Central will create a bank account ledger entry that will be included in the bank reconciliation window.
  • Once the reconciliation difference is zero, you can post the reconciliation under Posting > Post.

Once posted, you can reference posted reconciliations within the bank account card under Navigate > Bank Acc. > Posted Reconciliations.

For more information about Business Central or other Dynamics 365 products visit our website or schedule a free consultation with one of our experts!

https://lime-falcon-860444.hostingersite.com/schedule-a-free-consultation/

Other articles

Migrating 1.3 Million CRM Records in Dynamics 365: Why We Used a Custom Console App

Marisa Mini

|

March 5, 2026
A government client needed to restructure 1.3 million contact records in Microsoft Dynamics 365 CRM. At that scale, traditional UI tools and flows can throttle, fail silently, or leave a…

AI Agents in Manufacturing ERP: D365 Business Central Guide

Seetharaman Andiappan Rajaram

|

March 4, 2026
AI agents are now live inside Microsoft Dynamics 365 Business Central. For manufacturers evaluating AI in ERP systems, the practical question isn’t what an agent is it’s how AI agents…

How to Use D365 Business Central Analysis Mode

Carlos Lozano

|

March 3, 2026
Transforming Data into Decisions for Modern Businesses Organizations using Microsoft Dynamics 365 Business Central generate significant volumes of financial and operational data. However, collecting data is only the first step. The…

BCS Partners with RUX Software to Deliver Equipment Rental and Field Service on Business Central

Jackie Gant

|

February 26, 2026
Bond Consulting Services (BCS) has partnered with RUX Software to deliver equipment rental and asset management capabilities for small and mid-sized businesses running on or moving to Microsoft Dynamics 365…

What AI Agents in Dynamics 365 Actually Do (A Plain-English Guide)

Jennifer Ryan

|

February 19, 2026
From Assistance to ActionIf you've been using Microsoft 365 Copilot, you've probably noticed something shift. Email gets drafted faster. Meeting notes appear without you scrambling. Spreadsheet analysis that used to…

D365 Business Central: Realistic AI Agent Scenarios for Operations Teams

Zoltan Orban

|

February 18, 2026
A Practical Look at Where AI Actually Helps in BC TodayThere’s a lot of talk about AI and ERP becoming fully automated. In reality, most teams aren’t trying to replace…