See Microsoft 365 Copilot in action across Outlook, Teams, Excel + more.

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

Free vs Paid: How Microsoft 365 Copilot Unlocks Real Productivity ROI

TJ Sedarski

|

November 13, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.Copilot Free Chat is a good place to start in…

What the 2026 Business Central Updates Mean for Small and Midsized Organizations

Lupe Haro

|

November 12, 2025
Microsoft is doubling down on what matters most to today’s small and midsized organizations: automation, intelligence, and agility.The upcoming Dynamics 365 Business Central 2026 Release Wave 1 focuses on AI-powered…

Microsoft 365 Copilot Is Hot! Highlights from Community Summit 2025

TJ Sedarski

|

November 11, 2025
This article is part of our “Work Smarter with Copilot” series—spotlighting the latest Microsoft 365 Copilot updates announced at Community Summit 2025.One message rang loud and clear at this year’s…

How Microsoft 365 Copilot in Outlook Helps You Manage Email Smarter (and Tame Your Inbox)

Joel Trinidad

|

November 7, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.The Email Overload Holding Teams BackFor most of…

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…