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

How to Connect Power Pages & D365 Customer Engagement for a Seamless Self-Service Experience

Marisa Mini

|

December 4, 2025
Power Pages for Customer Service, Field Service, and Sales PortalsCreating a seamless, modern customer experience starts with reducing the back-and-forth. If your customers (or vendors, partners, applicants, members, etc.) still…

How to Tell if Your Distribution Business Has Outgrown Its Systems

Jennifer Ryan

|

December 1, 2025
As a former Controller inside a fast-moving distribution business, I learned this lesson the hard way: You don’t realize your system is breaking until growth exposes every weakness.It doesn’t happen…

Why Microsoft Killed Social Posting (And Why SMBs Should Care)

Jackie Gant

|

November 25, 2025
When Microsoft quietly pulled the plug on social posting in Dynamics 365 Customer Insights late last year, few in the small to mid-sized business (SMB) space raised an eyebrow. After…

Design Smarter, Present Better: How Microsoft 365 Copilot in PowerPoint Transforms Productivity

Joel Trinidad

|

November 20, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.The Presentation Problem We All Know Too Well The blinking cursor,…

How Microsoft 365 Copilot in Teams Helps You Work Smarter (and Recover Lost Time)

Joel Trinidad

|

November 18, 2025
Part of our “Work Smarter with Copilot” series — exploring how Microsoft 365 Copilot transforms productivity across Outlook, Teams, PowerPoint, Excel, and more.The Communication Overload Holding Teams Back We’ve all felt it—the…

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…