Bank Feeds (Sage 100)
Bank Feeds is now available for eligible Sage 100 users! This guide will walk you through eligibility requirements, installation, and bank transaction retrieval for the Sage 100 Bank Feeds feature.
Users must have the following to be eligible to use Sage 100 Bank Feeds:
- An active subscription to Sage 100
- NOTE: Sage 100 Contractor is different from Sage 100 and is therefore unsupported. Not-for-resale environments, such as those provided to Sage Partners for testing and development purposes, are also unsupported.
- Bank Reconciliation module on Sage 100 must be installed and registered
Registration is required in order to map your Sage 100 bank accounts to your accounts that exist at your bank.
To connect your bank accounts in Sage 100 to the Bank Feeds feature, log into Sage 100 and navigate to Modules > Bank Reconciliation > Bank Code Maintenance.
On the Bank Code Maintenance page, input the Bank Code you wish to connect Bank Feeds to.
After a Bank Code has been defined, a More button will appear on the top right.
Click on the More button to open a drop-down. In the drop-down, select Connect Bank Feeds.
A new pop-up window should appear, prompting you to "Connect your bank".
Here, you may be prompted to enter an email address if you have not done so previously during your initial Sage 100 setup. You may also be prompted to complete a Captcha.
In the search bar search ‘Santander - Powered by FISPAN.’
Select Santander - Powered by FISPAN.
Agree to the terms and conditions and select Continue.
Select Continue.
You will be redirected to a landing page that will require you to sign in to the FISPAN Wizard.
Select Login Now.
You must complete the account matching flow within 60 minutes or the wizard will timeout
After logging in, select the account which you have selected in Step 1.
After you have selected the account, select Save and Finish. You will automatically be redirected back to Sage.
After being redirected back to Sage, select the same account and select OK.
The browser window should now close, and you will be prompted to select a date to begin importing bank transactions from.
Once selected, select Finish and close the pop-up window.
Settled transactions are only pushed once per day, typically in the morning (EST). Therefore, it is advisable to download those transactions once a day at most, as there will not be any new transactions multiple times during the day.
After connecting your bank accounts Bank Feeds, your bank transactions will now be pushed into the Bank Reconciliation module in Sage 100.
To retrieve these bank transactions, navigate to Modules > Bank Reconciliation > Check, Deposit and Adjustment Entry.
Select the Bank Code of a bank account that you have connected to bank feeds previously.
Click Get Bank Feeds Transactions. This may take a while depending on the number of bank transactions you have.
Once the transactions have loaded, click Accept.
If Accept is not selected, the transactions will not be saved within the Bank Reconciliation module and you will need to click Get Bank Feeds Transactions to generate them once more.
If there are no transactions, you will see a "Pending" status until there are transactions to be pushed.
The Comment column contains additional payment information passed from your bank to the Memo field within FISPAN, and is now displayed in the Comment column.