--- title: Enabling Legacy Bank Feeds (NetSuite) slug: svb/enabling-legacy-bank-feeds-netsuite docTags: bSho0M8HRjDvZq9EBIWDy createdAt: 2024-02-01T19:32:53.010Z --- :::hint{type="danger"} ***Note:** These set of instructions cover the setup of our legacy bank feeds solution that will no longer be supported as of bank plugin version 2024.2.0.* *If you are an existing user of our legacy bank feeds solution, please refer to *[Migrating Bank Feeds (NetSuite)](docId:6Up_qmBYOEF7ot2c5ySA3) *to switch to the new solution.* *If you are new to bank feeds are are not currently using our legacy solution, please refer to *[Enabling Bank Feeds (NetSuite)](docId\:PfOuQHl-NHitQyUe4ER9z) *to set up the new bank feeds solution.* ::: :::hint{type="info"} **NOTE: **Upon setup, NetSuite will automatically import 60 days of past transactions into the Match Bank Data Module. The timing and 60 day date range of this import cannot be customized. You can find more information about this module by clicking this link to the Oracle NetSuite Applications Suite help center entry: [Bank Feeds SuiteApp FAQ](https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_159010939426.html). ::: The bank bundle adds support for Bank Feeds through a custom Connectivity Method, which allows transactions from your bank accounts to flow automatically into NetSuite's Match Bank Data module. To enable Bank Feeds in your NetSuite environment, please follow the steps outlined in this guide. This guide will walk you through two methods of enabling bank feeds, via: - CSV - BAI2 Which method to use is your choice, but most users prefer CSV for richer detail. Please note that aside from the custom Connectivity Method that is named after your bank, everything else discussed in this guide is owned and managed by NetSuite. This includes, but is not limited to, the following: - Match Bank Data module - Bank Statement Parsers bundle - Financial Institution configuration - Format Profile configuration - Banking Import History page While owned and managed by NetSuite, the following cannot be customized: - Timing of when the daily bank transaction import begins. - NetSuite randomly assigns a time, usually between 4 AM - 7 AM PT. - Timing of when the first automatic bank transaction import is. - The first import occurs immediately after a new Format Profile, as per instructions in this guide, is set up and saved. - Number of days of past transactions imported upon setup. - NetSuite will import 60 days' worth of transactions after initial setup. The Bank Feeds feature requires your bank bundle to be updated to version 2021.16.0 or newer. For users on newer versions, you may skip to **Step 3: Install Bank Statement Parsers**. *** ## Updating the Bank Bundle ## Step 1: Locate Bundle Go to **Customization → SuiteBundler → Search & Install Bundles** **→** **List**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/DJ2AV6f1t41nn64Xg0vkE_image.png" size="70" width="750" height="688" caption="Go to Search & Install Bundles List" position="center" showCaption="true"} *** ## Step 2: Update Bundle ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/2Y2ypd0o9Okj3H8rfiD5x_image.png" size="70" width="800" height="151" caption="Find SVB Go Link" position="center" darkWidth="800" darkHeight="151" showCaption="true"} Find the **SVB Go Link** bundle from the list. Then, hover over the green icon and select **Update**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/T3avqTLieJqBeCoxkg9K0_image.png" size="80" width="800" height="91" caption="Click Update Bundle" position="center" darkWidth="800" darkHeight="91" showCaption="true"} Click **Update Bundle**, and select **OK** on the confirmation pop-up. The bundle will take a few moments to update – it will appear as pending and then show the progress of the update. Once complete, the status column on the Installed Bundles page will show a check mark. Note: **Non-administrator** users who will be setting up and managing Bank Feeds must have the following permission: - **Setup → Financial Institution Records – Level: Full** They must also be added as an audience for the following Script Deployment (can be found under Customization **→** Scripting **→** Script Deployments): - **SVB Trans Feed Config** (ID: customdeploy\_svb\_rpt\_feed\_s) *** ## Step 3: Install Bank Statement Parsers Bundle Navigate to **Customization → SuiteBundler → Search & Install Bundles**. Then, search for **Bank Statement Parsers**, select the appropriate bundle (293699), and select **Install**. The bundle will take a few moments to install – it will appear as pending and then show the progress of the install. Once complete, the status column on the Installed Bundles page will show a check mark. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/wQUkMSp3lgGqaABQVQe-8_image.png" size="80" width="1536" height="804" caption="Install Bank Statement Parsers Bundle" position="center" showCaption="true"} *** ## Step 4: Enable Bank Account Feature Go to **Setup** **→** **Accounting** **→** **Chart of Accounts**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/oHzzOMLMC0dROJ6fbHBOM_image.png" size="50" width="848" height="590" caption="Go to Chart of Accounts" position="center" showCaption="true"} Select **Edit** on the bank account for which you would like to use the reconciliation feature. Select the “**Use Match Bank Data and Reconcile Account Statement Pages” **box to enable this feature for the account. Then, select **Save.** *** ## Step 5: Create Financial Institution Go to **Setup → Accounting → Financial Institution**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/R1aIxH4g7XDVVHfXmWRQi_image.png" size="50" width="768" height="761" caption="Go to Financial Institution" position="center" showCaption="true"} Enter a name for the **Financial Institution**. Then, select **Save**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/FQtEppWvX_QTSLZP2BDMh_image.png" size="60" width="657" height="397" caption="Define a Name" position="center" showCaption="true"} *** ## Enabling CSV Bank Feeds Users have the option to enable either CSV Bank Feeds or BAI2 Bank Feeds. While some users may wish to have some bank accounts connected to CSV and others to BAI2, this is uncommon and does not provide any added benefit. We recommend users to pick either CSV or BAI2 for all bank accounts they wish to enable Bank Feeds for. Refer to the steps below on how you can enable CSV Bank Feeds; otherwise, skip down to the **Enabling BAI2 Bank Feeds** section of this guide. :::::WorkflowBlock ::::WorkflowBlockItem ### Create a Format Profile Select the **Format Profile: Configuration** tab and select **Add**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/L3mrWh0lQSuIeT0YRstqW_screenshot-2024-09-13-at-25905-pm.png" size="80" width="1988" height="976" position="center" caption="Create a Format Profile" showCaption="true"} Fill in the following fields under **Primary Information**: - **Profile Name:** Any name. We recommend you name this after the bank account you are linking. - **Profile Type:** Bank Reconciliation - **Connectivity Method:** My Bank CSV Transaction Feed - **Transaction Parser:** CSV Plugin Implementation Do not click **Save** yet. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/XFawaXcxImLH-c6K1uh19_screenshot-2024-09-13-at-30049-pm.png" size="80" width="2274" height="1002" position="center" caption="Format Profile page with Primary Information filled in" showCaption="true"} :::hint{type="warning"} **IMPORTANT**: Each Format Profile can only support one linked bank account. Only the top-most account with a “Linked GL Account” in the Format Profile will have data imported, and other imports will show as failed within the Banking Import History page. To enable Bank Feeds for your other bank accounts, please create a separate format profile for each account by repeating the steps below. To add a new format profile, navigate to **Setup →** **Accounting → Financial Institution → List**. Select **View **for the Financial Institution you created previously, and then **Add **under the Format Profile: Configuration tab. ::: :::hint{type="info"} **NOTE: **The Connectivity Method we ask you to select above is custom and comes from your bank bundle. Everything outside of this Connectivity Method is considered native to NetSuite. ::: :::: :::WorkflowBlockItem ### Define Parser Configuration Parameters Select the **Parser Configuration **sub-tab. Ensure the following fields are shown under the **Field Mapping **sub tab: - Account Number - Date - Amount - Payee or Payer Name - Transaction Number - Memo - Transaction Type - Customer Name - Customer ID - Invoice Numbers ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/sYFXbZyZNII1vIWPq4Slj_screenshot-2024-09-13-at-30102-pm.png" size="80" width="2556" height="1246" position="center" caption="Select Parser Configuration" showCaption="true"} Then, select the **Formatting Preferences** tab within Parser Configuration. Ensure the **Number Format** is set to **1000000.00**, and **Negative Number Format** is set to **-100.** ![](https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/1VaDRZJZpelwcQ--ghX_e_screenshot-2024-09-13-at-30116-pm.png "Select 1000000.00 from the list of Number Formats") Then, select **Submit** to save the Parser Configurations. Do not click **Save** yet on the Format Profile. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/TtnCVyvIGm7sXRABye2uX_screenshot-2024-09-13-at-30130-pm.png" size="80" width="2498" height="1274" position="center" caption="Confirmation - Parser Configuration successfully submitted" showCaption="true"} ::: ::::WorkflowBlockItem ### Link GL Account to the Format Profile Now, select the **Account Linking** tab. Choose the appropriate Linked GL Account in the right-hand column for the Bank Account. Now you may finally click **Save** for this Format Profile. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/byrl_4-nSobaEDg-RcAxe_screenshot-2024-09-13-at-30157-pm.png" size="80" width="2836" height="1320" position="center" caption="Link a GL Account" showCaption="true"} :::hint{type="warning"} **IMPORTANT**: Each Format Profile can only support one linked bank account. Only the top-most account with a “Linked GL Account” in the Format Profile will have data imported, and other imports will show as failed within the Banking Import History page. To enable Bank Feeds for your other bank accounts, please create a separate format profile for each account by repeating the steps you took above. To add a new format profile, navigate to **Setup →** **Accounting → Financial Institution → List**. Select **View **for the Financial Institution you created previously, and then **Add **under the Format Profile: Configuration tab. ::: :::: :::WorkflowBlockItem ### Monitor Bank Import Process As soon as the Format Profile is saved, a blue banner will appear to notify you that NetSuite is beginning the bank import process. Select **Track your status** in the blue banner that appears, or go to **Transactions → **SVB Go Link** → Banking Import History**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/Bseqeoni4dsbllaoNR7cv_screenshot-2024-09-13-at-30220-pm.png" size="80" width="2860" height="1306" position="center" caption="Banner with a link to track your import status" showCaption="true"} If the import was successful, you will see **Completed** under the **Import Status** column. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/is6WzX3Gd0A3aqpaGedcI_screenshot-2024-09-13-at-30248-pm.png" size="80" width="2848" height="1300" position="center" caption="Banner Import History page with a Completed import" showCaption="true"} If the import fails, you will see **Failed** in the **Import Status **column. Select the plus (+) sign to expand the failure reason details. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/WWOso3gzh0Wxa2jLM3uUZ_screenshot-2024-09-13-at-30538-pm.png" size="80" width="2848" height="1232" position="center" caption="Import Failure error" showCaption="true"} Please take a screenshot of the error message and download the CSV provided from the link in the error message. Then, email this information to support. ::: ::::: [svb.support@fispan.com](#) *** ## Enabling BAI2 Bank Feeds Refer to the steps below on how you can enable BAI2 Bank Feeds. :::::WorkflowBlock ::::WorkflowBlockItem ### Create a Format Profile Each Format Profile can only support one linked bank account. Complete the following steps for each of your bank accounts. Select the **Format Profile: Configuration** tab and select **Add**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/FCFVxQ0YWIGpHwbuEOfKG_screenshot-2024-09-13-at-25905-pm.png" size="80" width="1988" height="976" position="center" caption="Configure Format Profile" showCaption="true"} Fill in the following fields under **Primary Information**: - **Profile Name:** Any name. We recommend you name this after the bank account you are linking. - **Profile Type:** Bank Reconciliation - **Connectivity Method:** My Bank BAI2 Transaction Feed - **Transaction Parser:** BAI2 Plugin Implementation ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/ioDJhz3BAQeRAjv1iB8EN_screenshot-2024-09-13-at-35224-pm.png" size="80" width="1557" height="507" position="center" caption="Format Profile page with Primary informartion filled in" showCaption="true"} Do not click **Save** yet. :::hint{type="info"} **NOTE: **The Connectivity Method we ask you to select above is custom and comes from your bank bundle. Everything outside of this Connectivity Method is considered native to NetSuite. ::: :::: ::::WorkflowBlockItem ### Link GL Account to the Format Profile Now, select the **Account Linking** tab. Choose the appropriate **Linked GL Account** in the right-hand column for the **Bank Account**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/cHFQUgyUJnqRttQoTdW4J_screenshot-2024-09-13-at-35406-pm.png" size="80" width="2045" height="819" position="center" caption="Link a GL Account" showCaption="true"} You can skip the Code Type Mapping tab for now and revisit it later if your bank has additional transaction codes. Also, skip the Parser Configuration tab, as it is required only for CSV Bank Feeds. Click **Save** to save this Format Profile. :::hint{type="warning"} **IMPORTANT: **Each Format Profile supports only one linked bank account; data will be imported only for the top-most account with a **Linked GL Account**. To enable Bank Feeds for additional accounts, you must repeat these steps for each one. Navigate to **Setup → Accounting → Financial Institution → List**. Select **View** for the Financial Institution you previously created, then click **Add** under the **Format Profile: Configuration** tab. ::: :::: :::WorkflowBlockItem ### Monitor Bank Import Process As soon as the Format Profile is saved, a blue banner will appear to notify you that NetSuite is beginning the bank import process. Select **Track your status** in the blue banner that appears, or go to **Transactions → Bank → Banking Import History**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/Ugo52sgRTZM9kygOIsi0b_screenshot-2024-09-13-at-35604-pm.png" size="80" width="2048" height="685" position="center" caption="Banner with a link to track your import status" showCaption="true"} If the import was successful, you will see **Completed** under the **Import Status** column. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/ddXYqPOt9U2Gyo7OJ9dkk_screenshot-2024-09-13-at-35845-pm.png" size="80" width="2046" height="909" position="center" caption="Banking Import History page with a Completed import" showCaption="true"} If the import fails, you will see **Failed** in the **Import Status **column. Select the plus (+) sign to expand the failure reason details. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/Y3vP2gfRLQXpmE-v7ndZS_screenshot-2024-09-13-at-40807-pm.png" size="80" width="2042" height="455" position="center" caption="Import Failure Error" showCaption="true"} If your Failure Reason states that a three-digit number “is not one of your recognized bank transaction codes”, please proceed to the next step. If your Failure Reason is anything other than an unrecognized bank transaction code, please take a screenshot of the error message and email it to the FISPAN Support team. ::: ::::: [svb.support@fispan.com](#) *** ## BAI2 Code Type Mapping Return to **Setup → Accounting → Financial Institution**. Click **Edit** on the Financial Institution that you have created previously. Select the Format Profile: Configuration tab and select **Edit** on the Format Profile that had a failed import. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/bv2zh9hwvxdul4KxPGGNk_screenshot-2024-09-13-at-42350-pm.png" size="80" width="2028" height="545" position="center" caption="Click "Edit" beside the Format Profile where the import failed" showCaption="true"} Click on the Code Type Mapping tab. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/K68zWZfcnPQI5kv_ThSTG_screenshot-2024-09-13-at-42448-pm.png" size="80" width="2038" height="609" position="center" caption="Code Type Mapping tab on a Format Profile" showCaption="true"} :::hint{type="info"} **NOTE: **If the Code Type Mapping could not be completed during the initial setup of this Format Profile, it is because the system has not read any bank transactions yet and does not know if there are additional codes that require mapping. ::: Fill in the following fields for the bank transaction code that was unrecognized: - **Bank Transaction Code ** - **Description** - **Bank Data Type** - **Credit / Debit** The **Bank Transaction Code** will be the three-digit code from the error message seen on the Banking Import History page. Fill in **Description** with something that will help you identify the bank transaction code. **Bank Data Type** and **Credit / Debit** values will be the same. They both must be either Credit, Debit, or N/A. To determine whether your Bank Transaction Code is a Credit or Debit, refer to the table below: | **Type Codes** | **Description** | | -------------- | ------------------------------------ | | 001-099 | Account status type codes | | 100 | Total Credits summary type codes | | 101-399 | Credit summary and detail type codes | | 400 | Total Debits summary type codes | | 401-699 | Debits summary and detail type codes | | 700-799 | Loan Summary and detail type codes | | 900-999 | Customized Type Codes | **Source**: [BAI.org Cash Management Balance Reporting Specifications, page 10](https://www.bai.org/docs/default-source/libraries/site-general-downloads/cash_management_2005.pdf)** Customized type codes should fall within the following ranges: | **Type Codes** | **Description** | | -------------- | ------------------------- | | 900-919 | Account Status Codes | | 920-959 | Credit Summary and Detail | | 960-999 | Debit Summary and Detail | **Source**: [BAI.org Cash Management Balance Reporting Specifications, page 11](https://www.bai.org/docs/default-source/libraries/site-general-downloads/cash_management_2005.pdf)** For any codes between the 900-999 range that are continuing to fail, please reach out to FISPAN Support. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/R1gddZVfxrV9j3Kc7YYgp_screenshot-2024-09-13-at-42710-pm.png" size="80" width="2042" height="607" position="center" caption="Complete Code Mapping" showCaption="true"} After filling in the above fields, click **Save**. This will trigger another import. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/8VRc4tWTTRK0qrqCG3T_U_screenshot-2024-09-13-at-35604-pm.png" size="80" width="2048" height="685" position="center" caption="Track the status of your bank import" showCaption="true"} Return to the Banking Import History page by either clicking **Track your status** in the blue banner that appears, or by navigating to **Transactions → Bank → Banking Import History**. If you receive a Failure Reason once more for an unrecognized bank transaction code, please repeat the above steps until the Banking Import status returns as **Completed**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/Cv-chSV9zwAer7A5nFmz6_screenshot-2024-09-13-at-41934-pm.png" size="80" width="2048" height="909" position="center" caption="Completed Banking Import" showCaption="true"} For any issues with enabling Bank Feeds or Code Type Mapping, please reach out to FISPAN Support at the below email address: [svb.support@fispan.com](#) *** # FAQs :::ExpandableHeading **How many days of transactions will the initial sync import?** Up to 60 days of Settled Transaction Data, if available. ::: :::ExpandableHeading **Will duplicates be removed?** NetSuite will attempt to remove duplicates. If any remain, they can be manually removed via the **Exclude** option on the page. ::: :::ExpandableHeading **When will the daily sync occur?** Between 4:00 AM and 7:00 AM EST. ::: :::ExpandableHeading **How will the data be transmitted?** A pre-formatted CSV is uploaded to NetSuite. ::: :::ExpandableHeading **Is it possible to add additional fields?** NetSuite does not allow the addition of fields at this time, nor can we customize special data on a per-client basis. ::: :::ExpandableHeading **Why are the 'Bank Balance' and 'Balance as of' fields in the Match Bank Data page empty, despite a successful import?** Due to a NetSuite limitation, we are unable to import the Balance data for bank accounts in our legacy Bank Feeds solution. This Balance data is available for users of our new version of bank feeds. Please refer to the** Enabling Bank Feeds (NetSuite) **page of our guides for instructions on how to enable this, or the **Migrating Bank Feeds (NetSuite)** page for how to move from the existing legacy Bank Feeds solution to the new version. :::