Using Bank Feeds (BC365)

this page includes instructions for the new bank feeds service you must be on version 2024 3 0 0+ to have access to this version of bank feeds to migrate bank feeds, follow these instructions docid\ s8 g0olim60zcbtsfnj2f this guide covers how to use bank feeds with the bank account reconciliation module or the payment reconciliation journal to streamline your reconciliation process 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 module to initiate your first bank feed using the bank account reconciliation module, begin by using the system search bar to locate and open bank account reconciliation once the page loads, navigate to the top menu bar, select process , and then click new you will then be prompted to select the specific bank account you wish to reconcile to complete the setup import button for bank account reconciliation select cash management and then navigate to the bank account reconciliation module select the bank account you would like to start with to pull new transactions, select import bank statement it will load all transactions we have received since you last triggered an import if there are no new transactions, a pop up will inform you there are no new transactions to import expected fields here is how information maps into the selected columns business central column transaction data transaction date settled date document number customer reference or, if ach recon details is enabled, it will be the payment request id which matches the external document number column in the gl related party name counter party name or related 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 matching transactions automatically matching transactions to automatically match transactions click on matching > match automatically it will ask you to enter transaction date tolerance depending on the payment rails used, it may impact the suggested tolerance days ach and wire payments normally take five business days checks are dependent on when your vendor deposits it business central will now attempt to match the transactions once completed, it will provide an overview of the number of lines they were able to match successfully manually matching individual transactions to manually match transactions, click on the transaction lines that match on the bank statement line and the bank account ledger entry side once you have selected those, click on matching > match manually once the transactions have turned green, they have been successfully matched manually matching multiple entries to one bank statement line if you would like to match multiple bank account ledger entries lines to one bank statement line you can also do that click on the bank statement line on the bank account ledger entries side, click on one transaction hold down control (windows) or command (macbooks) and select the other transactions you would like next, click matching > match manually after, all the selected transactions will be highlighted green on the bank account ledger entries side and the single entry on the bank statement lines will turn green removing matches if you accidentally match a transaction wrong, you can remove the match click on both lines on the bank statement lines and the bank account ledger entries after that, click on matching > remove match once the line items are no longer green, they are no longer matched and can be rematched payment recon journal module creating the first bank feed users can also use bank feeds from the payment reconciliation journal select cash management → payment reconciliation journal select process → import bank transactions import button for payment recon journal select cash management and then navigate to the payment recon journal module select the bank account you would like to start with to pull new transactions, select import bank statement it will load all transactions we have received since you last triggered an import if there are no new transactions, a pop up will inform you there are no new transactions to import matching transactions automatically matching transactions click on apply automatically you will now be prompted to see if the automatic matching can overwrite any previously applied entries click yes or no depending on your preference business central will now attempt to match the transactions once completed, it will provide an overview of the number of lines they were able to match successfully manually matching transactions to manually match transactions, click on the transaction line you would like to match once you have selected the line, click on manual application > apply manually you can then select multiple lines or a single line item to match the transaction successfully once applied, the transaction will have a description and the match confidence will update accordingly