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

What Copilot “Cowork” Means for Business Users

Zoltan Orban

|

March 26, 2026
Microsoft recently introduced Copilot Cowork, and I wanted to take a closer look at what it represents in practical terms, especially for business users working across Microsoft 365 and related…

Why CRM Data Quality Matters More Than Data Volume

Marisa Mini

|

March 24, 2026
A database of 100,000 messy, outdated records is far less valuable than 5,000 that are clean and accurate. Companies often obsess over data volume. But when more data is prioritized over…

From Reactive to Predictive: AI in Business Central Distribution

Zoltan Orban

|

March 19, 2026
Most distribution teams don’t lack reporting. If anything, they often have too much of it. Dashboards, planning worksheets, inventory reports, and KPIs are readily available inside Dynamics 365 Business Central. Yet…

AI Agents in Business Central: How the Payables Agent Works

Jennifer Ryan

|

March 17, 2026
If you're curious how AI agents in Microsoft Dynamics 365 Business Central actually work, we're hosting a live walkthrough of the Payables Agent on March 26. See live how the agent…

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…