Enabling Bank Feeds (Business Central)

this guide covers how to set up your bank accounts for bank feed imports and how to import your first transactions into either the bank account reconciliation module or the payment reconciliation journal set up bank account import format before importing, you must assign the bank statement import format to your bank accounts navigate to cash management → bank accounts open the desired bank account card navigate to the transfer tab in the bank statement import format field, select {{mybank}} bank feed from the list you must repeat this step for every bank account you wish to connect once complete, you are ready to import bank statements directly into the reconciliation modules 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