Business Central 365
...
Bank Statements (BC)
Bank Feeds Migration (BC365)
a new edition of bank feeds is now available! this guide will walk you through the migration of your existing bank feed to the new edition pre requisites for new bank feeds installation there are a few prerequisites that must be met before being able to migrate the new bank feeds must update your plugin to version 2024 1 0 0 or greater if you completed a plugin migration client, you must have all old versions of the plugin uninstalled both of these items can be confirmed by searching for the extension management page plugins starting in 15 4 20xx xx should be uninstalled must have a plugin installed that is at least version 2024 1 0 0 update the plugin keeping the plugin up to date with the latest version is crucial for ensuring you have access to all the newest features, important bug fixes, and updates to update, please follow these steps navigate to settings navigate to {{productname}} and select settings download the update navigate to actions, and select update plugin confirm download this will prompt the user to download the latest plugin version select yes to download the file upload the extension once downloaded, search extension management under global search select manage and then click upload extension deploy the extension this opens up a pop up screen to upload and deploy extensions you can select the … in the select app file field and choose the file from your computer once selected, accept the disclaimer and select deploy check installation status to view the status of the deployment, select installation status under manage if you are experiencing an error deploying using the above steps, on the upload and deploy extension window, enable schema sync mode force , then select deploy repeat step 6 check installation status pull transactions in if you haven't already, pull in all transactions on your desired reconciliation module until two days ago for example, if today is the 12th, i will pull in the 10th if you are concerned about the migration impacting your month end, we recommend pulling the previous month's transactions in the old bank statement import format you can then create a new reconciliation module and switch your bank statement import format to the new format this will ensure the migration does not impact your previous month's reconciliation adjust the date range to pull in all missing transactions including the previous day update your bank statement import setup bank accounts to assign the newly created bank statement import format to a bank account, navigate to cash management → bank accounts and open a bank account under the transfer tab, set cnb bank feed from the list for bank statement import format you will need to repeat this for each bank account once done, you’re ready to import bank statements directly into the bank reconciliation module bank feeds allow you to import transactions into only one module either the bank account reconciliation module or the payment reconciliation journal, but not both please select the module that best suits your organization's workflow during the setup of your bank feed bank account reconciliation use this section to learn how to import your first transactions using the bank account reconciliation module customize columns to ensure all necessary transaction data is visible, you must customize your view in business central select cash management and navigate to the bank statement reconciliation module open the bank account you wish to configure the bank statement reconciliation module will now load from this screen, click the gear icon in the top right corner and select personalize next, click on the bank statement lines section to load the columns for this screen select + field from the top left corner a sidebar list of available columns will appear drag and drop the following columns into the bank statement lines section you may reorder or resize them as needed we suggest adding these columns additional transaction info check no document no related party name once you have added all columns, you can click done this will now save this configuration field mapping the table below explains how the transaction data maps to the business central columns you just added business central column transaction data transaction date settled date document number customer reference related party name counter party name description description amount amount check no check no additional transaction info bai2 code items marked with an asterisk ( ) are conditional this data will only appear in business central if it is provided in the transaction details received from the bank import transactions now, when you click import bank statement , you can select a start date select yesterday's date to pull new transactions, select import bank statement it will load all transactions we have received since you last triggered an import payment reconciliation journal if you prefer to use the payment reconciliation journal, follow these steps go to payment reconciliation journal select cash management and then navigate to the payment reconciliation journal module select the bank account you would like to start with import transactions when prompted for a start date, select yesterday's date select import bank statement the system will load all transactions received since your last import trigger note you may notice that your bank accounts are listed as not linked within business central this is expected behavior because these bank feeds are provided through a custom integration rather than business central’s native offering, the native status indicator will not update this does not affect the functionality of your import moving back to old bank feeds change bank accounts setup if you run into any issues and need to revert your bank feeds to, navigate to cash management → bank accounts and open a bank account under the transfer tab, set the bank statement import format back to the cnb bank bf v3 you will need to repeat this for each bank account once done, you will be able to use the old data range bank feeds easily