--- title: Fixing Bank Reconciliation Errors in Business Central description: Bank reconciliation in Business Central is straightforward. Let’s look at Dynamics 365 Business Central bank reconciliation tips. image: https://www.iesgp.com/hubfs/Business%20Central%20bank%20reconciliation.jpg --- [![Microsoft Dynamics 365 Managed Services](https://www.iesgp.com/hs-fs/hubfs/IES-Logo.png?width=137&height=83&name=IES-Logo.png)](https://www.iesgp.com) [GET FREE QUOTE](https://www.iesgp.com/get-free-quote) # Fixing Bank Reconciliation Errors in Business Central Posted by [Alanna Friedberg](https://www.iesgp.com/blog/author/alanna-friedberg) on Jan 21, 2025 10:00:00 AM ![Business Central bank reconciliation](https://www.iesgp.com/hs-fs/hubfs/Business%20Central%20bank%20reconciliation.jpg?width=550&height=341&name=Business%20Central%20bank%20reconciliation.jpg) Businesses use bank reconciliation to ensure that cash balances and transactions from bank statements are recorded in the general ledger. During this process, the reviewer looks for discrepancies. If one is found, the two cash amounts are brought into alignment by adjusting for unrecorded transactions, which can include bank fees and deposits not yet cleared. [Dynamics 365 Business Central](https://www.iesgp.com/dynamics-365-business-central) bank reconciliation is made easier thanks to the tools provided by the platform. You can resolve any issues that might impact budgeting and forecasting. This article provides an overview of how to perform bank reconciliation in Business Central.  ## Bank Reconciliation with Business Central To get started, navigate to the Bank Reconciliation page in Business Central. 1. Go to the **Bank Accounts** module. 2. Select the bank account to use for reconciliation. 3. Go to **Process -> Bank Reconciliation**.  The worksheet that appears lets you review and match any transactions from your G/L to your bank statement. You can perform this process in three different ways. - Use the **Match Automatically** action - Use the **Reconcile with Copilot** action - Use the Match Manually option by selecting lines from both panes and linking bank statement lines to general ledger entries You should see an Applied checkbox appear on lines with matched entries. Click [here](https://learn.microsoft.com/en-us/dynamics365/business-central/receivables-how-set-up-payment-application-rules) to learn more about setting up rules for automatically applying payments.  The Total Balance field in the Bank Statement Lines page should be the same as the combined values of the Balance to Reconcile and Balance Last Statement fields in the Bank Account Ledger Entries pane.  Unmatched lines will have a value in the Difference field. They will remain on your Bank Acc. Reconciliation page after you post. These discrepancies must be resolved before you can complete your account reconciliation. Examples of why you can run into these differences include: - Bank transactions in Business Central are not reflected on bank statements because bank transactions were never created. - Bank transactions on statements are not reflected in Business Central because a posting was not made there - Transactions not matching because of errors, like a mistyped customer name or dollar amount You can fill in bank statement lines in the Bank Acc. Reconciliation page using one of the following methods:  ### 1. Import a Bank Statement You’ll need to set up the [Envestnet Yodlee bank feeds service](https://learn.microsoft.com/en-us/dynamics365/business-central/bank-how-setup-bank-statement-service) to import electronic bank statements from your bank. 1. Go to the search icon and look up **Bank Account Reconciliation** to locate the correct link. 2. Click the link, then select **New**. 3. Go to the **Bank Account No.** field and select the correct bank account. 4. Enter the bank statement date in the **Statement Date** field. 5. Enter the statement balance in **the Statement Ending Balance** field. 6. You can also import a bank statement file by selecting the **Import Bank Statement** action. 7. Locate your file and select the Open button. This will import your bank transactions into the **Bank Statement Lines** pane.  ### 2. Fill in Bank Reconciliation Lines Using Suggest Lines Action You can use this option as an alternative to fill in missing statement lines. 1. Go to the **Bank Acc. Reconciliation** page and select **Suggest Lines**. 2. Go to the **Starting Date** field and enter the earliest posting date for the entries you wish to reconcile. 3. Go to the **Ending Date** field and enter the most recent posting date for the entries you wish to reconcile. 4. The ending date usually matches the **Statement Date** field. You can enter a different date if you only need to reconcile transactions for a specific period. 5. If necessary, select the **Exclude Reversed Entries** option to exclude unmatched open reversed entries, then click OK. ### 3. Automatically Match Bank Statement Lines with Account Ledger Entries You can use the automatic matching functionality on the Bank Acc. Reconciliation page to match the text between your bank statement lines and bank account ledger entries. 1. Choose the **Match Automatically** option. That will open the **Match Bank Entries** page. 2. Go to the **Transaction Date Tolerance (Days)** field and enter the span of days to search for the bank account ledger entry posting date. You can enter 0 to search only for matching bank statement transaction dates. 3. Click **OK**. You’ll see color-coded lines to help you understand how to resolve the issue. Lines matched to the current bank reconciliation will be in green font, while those matched to other reconciliations will be in blue font. You can remove matches by selecting a bank statement line and clicking Remove Match. ### 4. Match Bank Statement and Ledger Lines Manually When using the manual option, use the options for Show All, Show Reversed Entries, Hide Reversed Entries, and Show Nonmatched to make it easier to see everything. 1. Choose an unapplied line from within the **Bank Statements Lines** pane. 2. From the **Bank Account Ledger Entries** page, select any bank account ledger entries you can match to any selected bank statement lines. 3. Select the **Match Manually** action. The bank statement line and the bank account entry font should change to green, and the Applied checkbox should also be selected. 4. Keep repeating the above steps for any unmatched bank statement lines. ## Validating Bank Reconciliation You should review your bank reconciliation before posting using the Test Report option. It’s available in two places: - From the **Bank Acc. Reconciliation** page when preparing a bank reconciliation - From the **Payment Reconciliation Journal** page when reconciling payments ## Add Missing Ledger Entries You can do the following to reconcile bank statement lines without matching entries in Business Central. 1. Go to the **Transfer to General Journal** option from the **Bank Acc. Reconciliation** page. 2. Specify which general journey to use on the Trans. Bank Rec. to Gen. Jnl. page and then click **OK**. 3. Fill in the journal line with the required information. 4. Review your posting results using **Test Report**. 5. Select the **Post** option, then match your bank statement line to the entry. 6. You should see the new ledger entry when you reopen or refresh the **Bank Acc. Reconciliation** page. 7. You can now match the bank statement line manually or automatically with the bank account ledger entry. ## Streamline Reconciliation Processes With IES Internet eBusiness Solutions (IES) can help you create automated processes to eliminate errors that can crop up during bank reconciliations. [Contact](https://www.iesgp.com/contact) an IES representative to learn more about our services. [![Top 5 Hidden Features of Dynamics 365 Business Central](https://no-cache.hubspot.com/cta/default/679984/c9e50554-7ae4-4787-a941-c503be0c1733.png)](https://cta-redirect.hubspot.com/cta/redirect/679984/c9e50554-7ae4-4787-a941-c503be0c1733)   ### Written by [Alanna Friedberg](https://www.iesgp.com/blog/author/alanna-friedberg) Topics: [Business Central](https://www.iesgp.com/blog/topic/business-central) ### Recent Posts ### Posts by Topic - [Dynamics 365 (138)](https://www.iesgp.com/blog/topic/dynamics-365) - [Microsoft Dynamics GP (66)](https://www.iesgp.com/blog/topic/microsoft-dynamics-gp) - [Microsoft Dynamics CRM (59)](https://www.iesgp.com/blog/topic/microsoft-dynamics-crm) - [Microsoft Gold Certified Partner (50)](https://www.iesgp.com/blog/topic/microsoft-gold-certified-partner) - [Business Solutions (48)](https://www.iesgp.com/blog/topic/business-solutions) - [Business Central (43)](https://www.iesgp.com/blog/topic/business-central) - [Microsoft Dynamics (37)](https://www.iesgp.com/blog/topic/microsoft-dynamics) - [Microsoft CRM Banking (21)](https://www.iesgp.com/blog/topic/microsoft-crm-banking) - [azure (13)](https://www.iesgp.com/blog/topic/azure) - [ERP (12)](https://www.iesgp.com/blog/topic/erp) - [CRM (10)](https://www.iesgp.com/blog/topic/crm) - [CRM Software (10)](https://www.iesgp.com/blog/topic/crm-software) - [Microsoft Dynamics ERP (10)](https://www.iesgp.com/blog/topic/microsoft-dynamics-erp) - [Dynamics NAV (9)](https://www.iesgp.com/blog/topic/dynamics-nav) - [Project Management (8)](https://www.iesgp.com/blog/topic/project-management) - [Sharepoint (8)](https://www.iesgp.com/blog/topic/sharepoint) - [Microsoft Dynamics Solutions (7)](https://www.iesgp.com/blog/topic/microsoft-dynamics-solutions) - [Dynamics CRM (6)](https://www.iesgp.com/blog/topic/dynamics-crm) - [Microsoft Dynamics Software (6)](https://www.iesgp.com/blog/topic/microsoft-dynamics-software) - [Microsoft Dynamics for the Health Care Industry (6)](https://www.iesgp.com/blog/topic/microsoft-dynamics-for-the-health-care-industry) - [Project Management System (6)](https://www.iesgp.com/blog/topic/project-management-system) - [Dynamics ERP (5)](https://www.iesgp.com/blog/topic/dynamics-erp) - [Cloud (4)](https://www.iesgp.com/blog/topic/cloud) - [Small Business (4)](https://www.iesgp.com/blog/topic/small-business) - [Cloud Based ERP (3)](https://www.iesgp.com/blog/topic/cloud-based-erp) - [Microsoft Sharepoint (3)](https://www.iesgp.com/blog/topic/microsoft-sharepoint) - [Quickbooks (3)](https://www.iesgp.com/blog/topic/quickbooks) - [B2B vs B2C (2)](https://www.iesgp.com/blog/topic/b2b-vs-b2c) - [CRM and Sales Team (2)](https://www.iesgp.com/blog/topic/crm-and-sales-team) - [Project Management Billing System (2)](https://www.iesgp.com/blog/topic/project-management-billing-system) - [Project Management Software (2)](https://www.iesgp.com/blog/topic/project-management-software) - [SaaS ERP (2)](https://www.iesgp.com/blog/topic/saas-erp) - [SharePoint Workflows (2)](https://www.iesgp.com/blog/topic/sharepoint-workflows) - [AWS (1)](https://www.iesgp.com/blog/topic/aws) - [Business Systems (1)](https://www.iesgp.com/blog/topic/business-systems) - [CRM Hosting (1)](https://www.iesgp.com/blog/topic/crm-hosting) - [CRM Integration (1)](https://www.iesgp.com/blog/topic/crm-integration) - [Customer Relationship Management (1)](https://www.iesgp.com/blog/topic/customer-relationship-management) - [HIPAA (1)](https://www.iesgp.com/blog/topic/hipaa) - [Integrated CRM (1)](https://www.iesgp.com/blog/topic/integrated-crm) - [LinkedIn (1)](https://www.iesgp.com/blog/topic/linkedin) - [Microsoft Dynamics Project Management (1)](https://www.iesgp.com/blog/topic/microsoft-dynamics-project-management) - [Microsoft Fabric (1)](https://www.iesgp.com/blog/topic/microsoft-fabric) - [Microsoft Sales (1)](https://www.iesgp.com/blog/topic/microsoft-sales) - [Microsoft Sharepoint Training (1)](https://www.iesgp.com/blog/topic/microsoft-sharepoint-training) - [Office 365 (1)](https://www.iesgp.com/blog/topic/office-365) - [Quickbooks vs. Microsoft Dynamics (1)](https://www.iesgp.com/blog/topic/quickbooks-vs-microsoft-dynamics) - [SharePoint Cloud (1)](https://www.iesgp.com/blog/topic/sharepoint-cloud) - [Talent Acquisition (1)](https://www.iesgp.com/blog/topic/talent-acquisition) - [Training (1)](https://www.iesgp.com/blog/topic/training) - [accounting (1)](https://www.iesgp.com/blog/topic/accounting) - [business productivity software (1)](https://www.iesgp.com/blog/topic/business-productivity-software) - [outlook (1)](https://www.iesgp.com/blog/topic/outlook) [see all](https://www.iesgp.com/blog/bank-reconciliation-errors-in-business-central#) ### Subscribe to Email Updates ### An Inside look at dynamics 365 ![](https://www.iesgp.com/hs-fs/hubfs/laptop.jpg?width=320&name=laptop.jpg "laptop.jpg") This eBook analyzes Microsoft Dynamics 365 and explains how companies can leverage the new robust platform to accelerate business. [Download Free Guide](https://www.iesgp.com/ms-dynamics-ebook?hsCtaTracking=5baf3a3d-408b-4eb9-8daf-39b983984193%7Cea0b10d3-bfc7-4eca-b7ae-5c721b37d70f) ## About IES Internet eBusiness Solutions, Inc. is a leading Microsoft Dynamics software reseller and developer based in the Miami and Tampa areas of Florida and operating nationally. Our business process consulting firm is dedicated exclusively to Microsoft® Dynamics products and supported services, including Microsoft Dynamics GP, Dynamics CRM, Dynamics NAV, and Sharepoint. ## Current News and Events ## Contact us ** 2200 N Commerce Pkwy Suite 200 Weston, FL 33326 **  [(954) 888-9223](tel:+19548889223) ![](https://googleads.g.doubleclick.net/pagead/viewthroughconversion/1072061139/?value=0&guid=ON&script=0) ```json { "@context" : "http://schema.org", "@type" : "Organization", "address" : { "@type" : "PostalAddress", "addressCountry" : "USA", "addressLocality" : "Weston", "addressRegion" : "FL", "postalCode" : "33326", "streetAddress" : "2200 N Commerce Parkway Suite 200" }, "alternateName" : "Microsoft Dynamics", "description" : "Internet eBusiness Solutions, Inc. (IES) is a leading business software reseller, development, implementation, and business process consulting firm dedicated exclusively to Microsoft® Dynamics products.", "email" : "ali@iescrm.com", "image" : "http://cdn2.hubspot.net/hubfs/679984/ies2.png", "logo" : "https://cdn2.hubspot.net/hubfs/679984/IES-Logo-1.png", "mainEntityOfPage" : { "@id" : "https://www.iesgp.com/blog/bank-reconciliation-errors-in-business-central", "@type" : "WebPage", "description" : "Bank reconciliation in Business Central is straightforward. Let’s look at Dynamics 365 Business Central bank reconciliation tips." }, "name" : "Internet eBusiness Solutions, Inc.", "sameAs" : [ "https://www.facebook.com/iesgp/", "https://twitter.com/IESCRM", "https://www.youtube.com/channel/UC_xV3Avsa4_LDVkhbTWlUaw" ], "telephone" : "(954)-888-9223", "url" : "https://www.iesgp.com/" } ``` ```json { "@context" : "http://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Alanna Friedberg" }, "dateModified" : "January 21, 2025, 3:00:01 PM", "datePublished" : "2025-01-21 15:00:00", "description" : "Bank reconciliation in Business Central is straightforward. Let’s look at Dynamics 365 Business Central bank reconciliation tips.", "headline" : "Fixing Bank Reconciliation Errors in Business Central", "image" : { "@type" : "ImageObject", "url" : "https://679984.fs1.hubspotusercontent-na1.net/hubfs/679984/Business%20Central%20bank%20reconciliation.jpg" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://cdn2.hubspot.net/hubfs/679984/IES-Logo-1.png" }, "name" : "Internet eBusiness Solutions, Inc." } } ``` ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@id" : "https://www.iesgp.com/blog/author/alanna-friedberg#person", "@type" : "Person", "name" : "Alanna Friedberg", "url" : "https://www.iesgp.com/blog/author/alanna-friedberg", "worksFor" : { "@type" : "Organization", "name" : "Internet eBusiness Solutions, Inc." } }, "dateModified" : "2025-01-21T15:00:01+0000", "datePublished" : "2025-01-21T15:00:00+0000", "description" : "Bank reconciliation in Business Central is straightforward. Let’s look at Dynamics 365 Business Central bank reconciliation tips.", "headline" : "Fixing Bank Reconciliation Errors in Business Central", "image" : { "@type" : "ImageObject", "url" : "https://679984.fs1.hubspotusercontent-na1.net/hubfs/679984/Business%20Central%20bank%20reconciliation.jpg" }, "mainEntityOfPage" : { "@id" : "https://www.iesgp.com/blog/bank-reconciliation-errors-in-business-central", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://cdn2.hubspot.net/hubfs/679984/IES-Logo-1.png" }, "name" : "Internet eBusiness Solutions, Inc." } } ```