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/

Share On: 

Other articles

Microsoft 365 Copilot for Outlook | Manage Email Smarter

Joel Trinidad

|

November 7, 2025
The Email Overload Holding Teams BackFor most of us, email isn’t just communication—it’s command central. But the volume is relentless. Between updates, requests, and follow-ups, your inbox can feel like its own full-time…

Copilot for Power BI: Your Personal Data Assistant

Joel Trinidad

|

October 30, 2025
Microsoft has been steadily adding AI features to their broad range of business products, and Power BI is no exception. Copilot can be utilized to take full advantage of your…

How to Migrate Fixed Assets from Dynamics GP to Business Central Smoothly

George Rios

|

October 28, 2025
PlanningWhen working on a migration of Dynamics GP fixed assets to Business Central, you will want to identify which fields you want to transfer from one system to another. It…

Introducing the BCS Support Portal

TJ Sedarski

|

October 23, 2025
At Bond Consulting Services, we know how important it is to get help when you need it, and to know where things stand once you’ve asked. That’s why we are…

Announcing Unlimited Support for Dynamics 365

TJ Sedarski

|

October 17, 2025
It's like having an in-house Dynamics team - without the overhead A Smarter Way to Get Support for Microsoft DynamicsWe've listened to your feedback and we're making support simpler, faster, and…

Meet Bond Consulting at Community Summit NA 2025

TJ Sedarski

|

October 9, 2025
Discover how we’re helping growing companies streamline operations and accelerate ROI with Microsoft Dynamics 365.Community Summit North America is right around the corner! From October 19–23 in Orlando, FL, business…