Using Bank Feeds (BC365)

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 module creating the first bank feed to reconcile bank accounts, search for bank account reconciliation on this page select process → new and select the bank account to reconcile 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 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 deleting transactions if you need to remove a transaction, click on the three dots beside the transaction click on yes and the transaction will be deleted 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