Sales tax works...until it doesn't. Join our May 5 webinar.

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

Microsoft Dynamics 365 Business Central Implementation Packages

Clayton Jones

|

April 29, 2026
If you’re like 99% of our clients, you’re trying to rein in the soaring costs of technology. It’s a delicate balancing act. On the one hand, you understand that you…

Doing More With the Team You Have: What BCS is Changing with AI

Jackie Gant

|

April 29, 2026
AI is everywhere right now, but what feels different is the pace. For the first time in a long time, small and mid-sized businesses are adopting new technology just as quickly…

Why AI Sometimes Feels Off (Even When You Have the Data)

Zoltan Orban

|

April 23, 2026
Webinar: Doing More With the Team You Have | What BCS is Changing About AIApril 28 @ 12:00 PM PT/3:00 PM ETRegister Now!Most small and mid-sized businesses aren't behind on…

What 200% ROI from Business Central Really Looks Like

Jackie Gant

|

April 13, 2026
Where ROI actually shows up from finance efficiency to operational visibility Forrester says Business Central delivers 200% ROI. But what does that actually look like in practice? A recent Total Economic…

Do You Need Avalara for Business Central? A Practical Guide

Clayton Jones

|

April 10, 2026
Webinar: Sales Tax Works…Until It Doesn’t: Tax Complexity at Scale for Product CompaniesMay 5 @ 10:00 AM PT/1:00 PM ETRegister Now!Most companies focused on making, distributing, or selling products manage…

What Is Work IQ? How Microsoft Copilot Moves from Data to Context

Zoltan Orban

|

April 9, 2026
Work IQ is one of those terms that can sound more complex than it really is. Most AI tools today work by pulling from available data. They can read records, summarize…