Skip to main content

Posts

Showing posts with the label Bank Account Reconciliation

Setting Up Envestnet Yodlee Bank Feeds for Business Central

Introduction: In this blog, I will be explaining how to set up Envestnet Yodlee Bank Feeds and perform Bank Account Reconciliation. Pre- requisites : Microsoft Dynamics 365 Business Central Envestnet Yodlee  Banks Feed Add-On  Demonstration: 1. Installing Envestnet Yodlee  Banks Feed Add-On: Goto the Marketplace App and install the Envestnet Yodlee App. 2. Setup Envestnet Yodlee Setup: Goto Envestnet Yodlee Setup and input Consumer Email and enable. After that run the Test Setup action which will set up the Consumer connection with Envestnet Yodlee App. If there are any errors while setting up the app such as the one below. "You cannot use the Envestnet Yodlee Bank Feeds Services on the demonstration company. Open another company and try again". To handle this error, goto Company Information and ensure that the copy doesn't have 'Demo' field set to true. Use Configuration Package to set it to false. 3. Setup Import Bank Statement Setup Goto Bank Import / Export se

Performing Bank Account Reconciliation in D365 Business Central

Introduction: In Microsoft Dynamics Business Central Bank Account Reconciliation is relatively easier task. You can make use of Suggest Vendor Payments or make use of Bank Reconciliation Statement file from the Bank to verify payments. Pre-requisites: Microsoft Dynamics Business Central Demonstration: 1. Creation of Bank Account Reconciliation: Click on New > Select the Bank to create the Bank Account Reconciliation Card Creation of Bank Account Reconciliation  Bank Account Reconciliation 2. Bank Account Reconciliation using Suggest Lines: Select Process > Suggest Lines > Fill in the required details to filter suggestions Suggest Lines Criteria Note: When you use Suggest Lines, the lines are suggested from Bank Account Ledger Entries. Thus Bank Account Ledger Entries and Payment Journal is reconciled 3. Bank Account Reconciliation using Bank Reconciliation Statement File: 4. Reconciling / Matching: i. Filtering the NonMatched using S