Business Central 365
...
Features
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 step 1 navigate to settings navigate to the cnb plugin and select settings step 2 download the plugin navigate to actions, and select update plugin step 3 confirm download this will prompt the user to download the latest plugin version select yes to download the file step 4 upload the extension once downloaded, search extension management under global search select manage and then click upload extension step 5 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 their computer once selected, accept the disclaimer and select deploy step 6 check installation status to view the status of deployment, select installation status under manage appendix 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 step 6 check deployment 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 please note that bank feeds only allows you to import you transactions into bank account reconcilation module or the payment recon journal, not both please pick the module that works best for your organization when setting up your bank feed bank account reconciliation import your first transactions customize columns personalize your business central select cash management and then navigate to the bank statement reconciliation module select the bank account you would like to start with the bank statement reconciliation module will now load from this screen, click on the gear in the top right corner and then personalize next, click on the bank statement lines section to load the columns for this screen select + field from the top left corner there will now be a list of columns to add you can drag and drop the columns into the highlighted bank statement lines section business central allows you to reorder and resize columns as you see fit the columns suggested to add are 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 expected fields here is how information maps into the selected columns 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 all information denoted with a star will only be displayed if we receive this information about the transaction not all transactions will have all the above data select a start date now, when you click import bank statement , you can select a starting date select yesterday's date import transactions to pull new transactions, select import bank statement it will load all transactions we have received since you last triggered an import payment recon journal import your first transactions select cash management and then navigate to the payment recon journal module select the bank account you would like to start with now, 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 please note, your bank accounts will always say "not linked" this is because your bank feeds are not being offered through business central's native offering 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