Enable Bank Feeds (Sage 300)

bank feeds is available for eligible sage 300 users this guide covers eligibility requirements, how to install the product, and the steps for retrieving bank transactions eligibility requirements to use sage 300 bank feeds, you must have an active subscription to sage 300 access to the reconcile e statement module within sage 300 installation overview to map your sage 300 bank accounts to the corresponding accounts at your financial institution, complete the registration process during installation keep an eye on your inbox for an invitation email from fispan, sent on behalf of bmo this email contains links to install the bmo sync plugin and access {{fispansync}} , along with easy to follow instructions for using both tools the invitation email will arrive with the following subject line welcome to bmo sync powered by fispan \[production] \[your name] register & login create an account in your invitation email, select the get started button you will be brought to the {{fispanportal}} create your login credentials and select next note the password you create here will be used every time you want to access the {{fispanportal}} if you need to update it later on, you have the option to use the forgot password option login to your account once registered, you will be redirected to the login page please note that your username and password are unique per environment, and you will have separate logins between https //sandbox fispan cloud/login and https //sys fispan live/login note the sandbox environment is used as a testing or uat environment please refer to the sandbox checklist for test scenarios from the welcome page, you'll be taken to the login page enter your username and password to proceed setting up sms mfa note multi factor authentication (mfa) is only required if you are a user in the production environment if you are a sandbox user, you may skip this step the first time you log in to the production environment, you will be prompted to establish your multi factor authentication (mfa) setup you have the option to select various methods of mfa enroll phone number select your country code then enter your phone number, you will receive a text message with a 6 digit code via sms to the phone number you provided for enrollment if you are unable to receive a text message to this number, or you prefer a different multi factor authentication method, click try another method enter code otherwise, enter the 6 digit code you received in the applicable field select continue save recovery code after setting up sms and inputting the first one time code, you will be presented with a recovery code that should be stored in a safe location this code is for resetting the mfa, to switch the mfa type (i e , authenticator), or to use a different phone number connect to sage 300 bank feeds to connect your bank accounts in sage 300 to the bank feeds feature, follow these steps access bank reconciliation log in to sage 300 navigate to common services > bank services > bank transactions > reconcile e statements on the reconcile e statements page, enter the bank code you want to connect bank feeds to click connect bank feed after a bank code has been defined, select connect bank feed on the right side of the screen you may be asked to enter an email address (if you didn't do so during initial sage 300 setup) and/or complete a captcha connect your bank a new pop up window should appear, prompting you to connect your bank in the search bar search {{mybank}} and select " {{mybank}} online banking for business (powered by fispan)" review the terms and conditions and select continue log in to the {{fispanportal}} now, you will be redirected to a landing page for the {{fispanportal}} click on login now and sign in to the fispan portal authenticate bank connection once you log in to the fispan portal, you will be taken to the installation wizard follow the steps below in the installation wizard to connect to the bmo olbb portal and grant access to your bank accounts initiate connection click rec onnect to your bank a new window for you to log in to bmo log in to bmo olbb portal log in to the bmo olbb portal with the credentials provided by bmo select accounts once logged into the bmo portal, s elect the account information checkbox you will then be presented with bmo accounts check the box(es) next to the account numbers provided on the enrolment form then, press allow click next confirm accounts review your account selection for each api click complete the success confirmation window will be displayed click return to application to be directed to the installation wizard syncing bank feeds connect account on the installation wizard, you will be selecting the bank account you chose earlier in sage 300 select save and finish you will automatically be redirected back to sage after being redirected back to sage, select the same account again select ok select import start date you will be prompted to select a date to begin importing bank transactions from once the date is selected, click continue complete the setup with the bank account now connected, click on finish to close the pop up window view bank feeds data to view data that has been pushed, click on get transactions button on the right side of the screen retrieve imported bank transactions settled bank transactions are pushed to the bank feeds feature once per day, typically in the morning (eastern standard time/est) tip we recommend retrieving transactions once a day at most, as there won't be any new settled transactions pushed multiple times throughout the day once your bank accounts are connected via bank feeds, your bank transactions will automatically feed into the bank reconciliation module in sage 300 to manually retrieve the latest daily transactions go to bank reconciliation navigate to common services > bank services > bank transactions > reconcile e statements get bank feed transactions on the reconcile e statements page, enter the bank code you want to retrieve transactions click on get transactions button on the right side of the screen save transactions once the transactions have loaded, click save the comment 2 column contains additional payment information passed from your bank to the memo field within {{fispan}} and is now displayed in the comment 2 column