--- title: Bank Feeds (Sage 100) slug: pnc/bank-feeds-sage-100 description: Use this guide to install Bank Feeds and follow the steps to retrieve bank transactions. docTags: createdAt: 2024-03-21T23:03:36.863Z --- Bank Feeds is available for eligible Sage 100 users. This guide covers eligibility requirements, how to install the product, and the steps for retrieving bank transactions. *** ## 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. - **Bank Reconciliation Module:** The Bank Reconciliation module must be installed and properly registered in 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. :::hint{type="warning"} **IMPORTANT:** 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. ::: *** ## Installation Overview To map your Sage 100 bank accounts to the corresponding accounts at your financial institution, complete the registration process during installation. :::hint{type="warning"} **IMPORTANT: **A Sage Intacct Administrator is required. Our onboarding calls require a Sage Intacct 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. ::: Registration is required in order to map your Sage 100 bank accounts to your accounts that exist at your bank. You will have received an invitation email from PNC with links to install the PNC plugin and easy-to-follow instructions for installation. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/esRrtwOqWOnqRGt5HGU-O_pnc-invitation-email.png" size="80" isUploading="false" position="center" caption="Invitation Email" width="800" height="1202" darkWidth="800" darkHeight="1202" showCaption="true"} ## Register & Login :::::WorkflowBlock ::::WorkflowBlockItem ### 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.** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/g4G9Lvri0IMAoRCMKw8W7-20260511-204440.png" size="80" width="800" height="445" darkWidth="800" darkHeight="445" position="center" caption="Passwords are required to be 8 characters and contain at least one uppercase, lowercase, number and special character" showCaption="true"} :::hint{type="info"} **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. ::: :::: ::::WorkflowBlockItem ### 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](https://sandbox.fispan.cloud/login) and [Production](https://sys.fispan.live/login). :::hint{type="info"} **NOTE: **The Sandbox environment is used as a testing or UAT environment. For Sandbox users, please refer to the Sandbox Checklist for test scenarios. ::: ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/gSU8lFD9vQ043qOkFcPsN-20260530-225206.png" size="80" width="3398" height="1850" position="center" caption="Welcome Page for Sandbox" showCaption="true"} From the welcome page, you'll be taken to the login page. Enter your username and password to proceed. :::: ::::: *** ## Setting Up SMS MFA :::hint{type="info"} **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. ::::WorkflowBlock :::WorkflowBlockItem ### 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**. ::: :::WorkflowBlockItem ### Enter Code Enter the 6-digit code you received in the applicable field. Select **Continue.** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/9oSXbSR9WPqNmRmKgSjIL_image.png" size="70" width="922" height="840" caption="6-digit Verification" position="center" showCaption="true"} ::: :::WorkflowBlockItem ### 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. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/YwLGIYBoKob_nwUcCBYJH_image.png" size="70" width="442" height="562" caption="Recovery Code" position="center" showCaption="true"} ::: :::: *** ## Connect to Sage 100 Bank Feeds To connect your bank accounts in Sage 100 to the Bank Feeds feature, follow these steps. :::::WorkflowBlock :::WorkflowBlockItem ### Access Bank Reconciliation Navigate to **Modules -> Bank Reconciliation -> Bank Code Maintenance**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/_ZX8Y5poh7fezL4Mz7bVM_image.png" size="70" width="1058" height="1764" position="center" caption="Navigate to "Bank Code Maintenance"" darkWidth="1058" darkHeight="1764" showCaption="true"} On the Bank Code Maintenance page, enter the **Bank Code** you wish to connect Bank Feeds to. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/4v8ooQeOtZZTziCguYhQm_image.png" size="80" width="620" height="542" position="center" caption="Enter Bank Code" darkWidth="620" darkHeight="542" showCaption="true"} ::: ::::WorkflowBlockItem ### Click Connect Bank Feed After a Bank Code has been defined, a **More** button will appear on the top right. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/vQAkcHa5g4MVy8laPJI2o_image.png" size="80" width="753" height="543" position="center" caption="Select "Connect Bank Feeds"" darkWidth="753" darkHeight="543" showCaption="true"} Click on the **More** button and select** Connect Bank Feeds**. :::hint{type="info"} **NOTE: **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. ::: :::: :::WorkflowBlockItem ### Connect Your Bank In the search bar, search **"PNC Bank"** Select **PNC Bank - Powered by FISPAN**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/8AdwwDNU2u4WEdeTYEUdC_image.png" size="80" width="1024" height="572" caption="Search PNC Bank" position="center" darkWidth="1024" darkHeight="572" showCaption="true"} Agree to the terms and conditions and select **Continue.** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/mVf5PzXea1umag7-GD5-3_png-bank-powered-by-fispan-sage-100.png" size="80" isUploading="false" position="center" caption="Agree to Terms and Conditions" width="4096" height="2436" darkWidth="4096" darkHeight="2436" showCaption="true"} Select **Continue**. You will be redirected to a landing page that will require you to sign in to the FISPAN Portal. Select **Login** **Now**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/3csw6KAQZNaCht257yuSK_image.png" size="80" width="1024" height="583" caption="Select Login Now" position="center" darkWidth="1024" darkHeight="583" showCaption="true"} ::: :::WorkflowBlockItem ### Authenticate Bank Account Click on **Connect to Bank**, and it will open a new window for you to log in to PNC. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/pcntEtf8uFv2TLNMzpvZS_screenshot-2023-09-26-at-24727-pm.png" size="80" width="1904" height="930" position="center" caption="Click Connect To Your Bank" darkWidth="1904" darkHeight="930" showCaption="true"} Log in to the PNC Portal with the credentials supplied by PNC. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/vOZbAmXZI32NywqMJd_UY_image.png" size="80" width="2048" height="1246" caption="Log into PNC portal" position="center" darkWidth="2048" darkHeight="1246" showCaption="true"} Once logged into the PNC Portal, you will be presented with your PNC accounts. Check the box(es) next to the account numbers provided on the enrolment form. Then, press **Authorize.** The window will close after a few moments, and you can then press the **Next Step** button in the installation wizard. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/XaPRbsN9HL_Nze5eT0K0M_image.png" size="80" width="1085" height="850" caption="Authorize bank accounts" position="center" darkWidth="1085" darkHeight="850" showCaption="true"} ::: ::::WorkflowBlockItem ### Connect Accounts to Sage :::hint{type="warning"} **NOTE: **You must complete the account matching flow within 60 minutes, or the installation wizard will time out. ::: ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/U-Ometc6uybbQ8OTN4Zj6_image.png" size="80" width="768" height="353" caption="Select Account" position="center" darkWidth="768" darkHeight="353" showCaption="true"} After logging in, select the account that you selected earlier and click **Save and Finish**. You will automatically be redirected back to Sage. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/mbV93W-ruFDy6OcwGsuo-_image.png" size="80" width="768" height="253" position="center" caption="Select OK" darkWidth="768" darkHeight="253" showCaption="true"} 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. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/dUUWzdIy7DNYAD6gYLaac_image.png" size="80" width="1854" height="1096" position="center" caption="Click "Finish" to complete" darkWidth="1854" darkHeight="1096" showCaption="true"} :::: ::::: *** ## 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). :::hint{type="success"} **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 100. To manually retrieve the latest daily transactions: :::::WorkflowBlock :::WorkflowBlockItem ### Go to Bank Reconciliation Navigate to **Modules -> Bank Reconciliation -> Check, Deposit and Adjustment Entry**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/Dc_KxzajXpoIm_GkwvnEr_image.png" size="70" width="1050" height="1220" position="center" caption="Select Check, Deposit and Adjustment Entry" darkWidth="1050" darkHeight="1220" showCaption="true"} ::: :::WorkflowBlockItem ### Get Bank Feed Transactions Select the** Bank Code** corresponding to the account you have connected to Bank Feeds. Click **Get Bank Feed Transactions**. This may take a while, depending on the number of bank transactions you have. ::: ::::WorkflowBlockItem ### Save Transactions Once the transactions have loaded, **click** **Accept**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/eR1ywIYFQeMiYeUVurL2m_image.png" size="80" width="690" height="459" position="center" caption="Click Accept" darkWidth="690" darkHeight="459" showCaption="true"} 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. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/d41LZn_6To2ZRxQMz9EXK_image.png" size="80" width="1802" height="902" position="center" caption="Retrieved Bank Transactions" alt="dsimon+archbee@fispan.com" darkWidth="1802" darkHeight="902" showCaption="true"} 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. :::hint{type="info"} **NOTE:** If there are no transactions, you will see a "Pending" status until there are transactions to be pushed. ::: :::: :::::