Enable Bank Feeds (Sage 100)
NOTE: Sage 100 is currently in pilot.
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.
Eligibility Requirements
To successfully use Sage 100 Bank Feeds, your organization must meet the following criteria:
- Active Sage 100 Subscription: You must have a current, active subscription to Sage 100.
NOTE: Sage 100 Contractor is a separate product and is not supported by this feature. Not-for-resale (NFR) environments, including those used by Sage Partners for testing or development, are not eligible.
- Bank Reconciliation Module: The Bank Reconciliation module must be installed and properly registered within your Sage 100 system.
- On-Premise Version: Your Sage 100 system must be on-premise. Sage Partner Cloud is not required for Bank Feeds functionality.
Installation Overview
To map your Sage 100 bank accounts to the corresponding accounts at your financial institution, complete the registration process during installation.
IMPORTANT: A Sage Administrator is required.
Our onboarding calls require a Sage Administrator to be present, as they will need to enable a number of settings, create a web service user, install the plugin, and assign various permissions.
You should have received an invitation email from J.P. Morgan with links to install the J.P. Morgan Treasury Ignition™ plugin and easy-to-follow instructions for installation.
Register & Login
Create an Account
In your invitation email, select the Get Started button. You will be brought to the FISPAN Portal. Create your login credentials and select Create Account.
NOTE: The password you create here will be used every time you want to access the FISPAN Portal. 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. Your username and password are unique per environment, and you will have separate logins between Sandbox and Production.
NOTE: The Sandbox environment is used as a testing or UAT environment. For Sandbox users, 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 accessing the Sandbox environment, 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
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 100 Bank Feeds
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".
NOTE: 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 'J.P. Morgan' and select J.P. Morgan Access – Powered by FISPAN.
You will see Agree to the terms and conditions page and select Continue.
Now, you will be redirected to a landing page that will require you to sign in to the FISPAN Wizard.
Select Login Now.
After logging in, select the account which you have selected earlier.
After you have selected the account, select Save and Finish. You will automatically be redirected back to Sage.
IMPORTANT: You must complete the account matching flow within 60 minutes or the wizard will timeout
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, click Continue
Once the Bank Account is connected, click on Finish to close the pop-up window.
Retrieve Imported Bank Transactions
NOTE: 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.
NOTE: 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.