--- title: Enabling Bank Feeds (NetSuite) slug: pnc/enabling-bank-feeds-netsuite description: Follow this guide to learn how to enable Bank Feeds for your NetSuite plugin and perform code type mapping in BAI2. docTags: bSho0M8HRjDvZq9EBIWDy createdAt: 2022-08-02T19:22:01.000Z --- :::hint{type="info"} 📣 **NetSuite 2026.1 Compatibility Update** NetSuite version 2026.1 introduced new functionalities for the Bank Feeds module, including custom automated import scheduling and the ability to choose an exact start date for historical transaction imports. Our Bank Feeds service has been fully updated and is completely compatible with these new features, giving you greater control over your reconciliation process from day one! ::: Bank Feeds allow for your settled bank transactions to automatically flow into NetSuite's Match Bank Data module for reconciliation, removing the need to export and import bank statements manually. To enable Bank Feeds, follow the instructions below. Please take note of the following field mappings for data received from your bank within the Match Bank Data page in NetSuite. | **NetSuite (Match Bank Data)** | **Transaction Data** | | ------------------------------ | ---------------------------------------------------------------------- | | Transaction Date | Settled Date | | Type | Transaction Type | | Transaction Number | Check Number**\*** (if non-null) or Customer Reference**\*** | | Name | Counter-Party Name**\*** | | Memo | Description | | Amount | Amount | **\*** Information denoted with a star will only be displayed if the transaction includes it. :::hint{type="info"} **NOTE:** Aside from the custom Connectivity Method and Transaction Parser 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 - Financial Institution configuration - Format Profile configuration - Banking Import History page As this process is managed by NetSuite, the timing and execution of the daily imports are controlled within their system. If you are on NetSuite version 2026.1 or later, you can customize the frequency and timing of your automated imports using the Import Schedule subtab within your format profile. (If you do not set a custom schedule, NetSuite will default to a randomized time between 4 AM to 7 AM PT). ::: :::hint{type="info"} **Historical Transactions at Setup:** You now have control over your historical data sync at setup without needing to contact Support. - **For NetSuite 2026.1 or later:** During the account linking process, you can select an **Earliest Transaction Date for Import**. This allows you to automatically import up to 60 days of historical transactions upon setup, or pick a future date to delay your initial import. - **For NetSuite 2025.2:** Upon initial setup, the system will automatically import up to your last 60 days of historical transactions by default. If you have any questions regarding transaction import, please reach out to PNC Support after setting up your bank feeds connection. ::: *** ## 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 Find the **PNC** bundle from the list. Then, hover over the green icon and select **Update**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/07BEjJK3dEtdUWL0Deeil_screen-shot-2022-10-06-at-43034-pm.png" size="60" width="708" height="446" caption="Select Update" position="center" showCaption="true"} Select **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. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/lRni8n2WoaZH8jorNdMgg_image.png" size="60" width="1023" height="618" caption="Select Update Bundle" position="center" showCaption="true"} **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**): - **PNC Trans Feed Config** (ID: customdeploy\_pnc\_rpt\_feed\_s) *** ## Step 3: Create a New Financial Institution Navigate 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 the name of your bank the **Financial Institution **field. Then, select **Save**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/FQtEppWvX_QTSLZP2BDMh_image.png" size="60" width="657" height="397" position="center" caption="Enter your bank's name as the Financial Institution" showCaption="true"} *** ## Step 4: Create a New Format Profile On the Financial Institution, click the **Format Profile: Configuration** tab and then click the **Add **button. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/ypalvKjhwSVwPCUPwO5vn_screenshot-2024-05-22-at-25737-pm.png" size="80" width="800" height="651" position="center" caption="Configure Format Profile" darkWidth="800" darkHeight="651" showCaption="true"} Fill in the following fields under **Primary Information**: - **Profile Name:** Any name, we suggest PINACLE® | PNC Profile - **Profile Type:** Bank Reconciliation - **Connectivity Method:** PINACLE® | PNC Transaction Feed - **Transaction Parser:** PINACLE® | PNC Transaction Feed ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/2N7QQM3mCjfdbARHMsllZ_image.png" size="80" width="800" height="244" position="center" caption="Fill in the required fields under Primary Information" darkWidth="800" darkHeight="244" showCaption="true"} Next, click on the **Account Linking** tab. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/P3xGRc8qEqXfS9TUgS0v8_image.png" size="80" width="800" height="395" position="center" caption="Format Profile -> Account Linking tab" darkWidth="800" darkHeight="395" showCaption="true"} :::hint{type="info"} **NOTE: **Previously, each Format Profile was only able to support one linked bank account. With this new edition of Bank Feeds, a Format Profile can have multiple Bank Accounts and linked GL accounts. ::: Based on the account seen under the** Bank Account** column, click on the space below the **Linked GL Account** to show a dropdown. In this dropdown, select the GL account that maps to the Bank Account. Repeat this step for all accounts you wish to enable Bank Feeds. Once all bank accounts have been linked, click **Save**. :::hint{type="warning"} **IMPORTANT:** Please ensure you link all of your bank accounts on the same day to avoid missing transactions for any unlinked bank accounts. ::: ### Set up the Transaction History Date On the **Account Linking** subtab, use **Earliest Transaction Date for Import (All Accounts)** to control how far back NetSuite should reach when it first pulls transaction history. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/IgSu6BLyqa4hZ3K5ckcvx_earliest-transaction-date-for-import-netsuite.png" size="40" isUploading="false" position="center" caption="Select the Earliest Transaction Date for Import" width="800" height="164" darkWidth="800" darkHeight="164" showCaption="true"} - This date applies to **all bank accounts by default**. - To set a different start date for one account, edit that row's **Earliest Transaction Date for Import** column directly. - To force every account back to the same date (overwriting any per-account overrides), enter a date and click **Apply Date to All Bank Accounts**. - If left blank, NetSuite defaults to importing the last 60 calendar days of available history. - You can select a start date up to **60 days in the past**. :::hint{type="warning"} **IMPORTANT**: Once the first import for an account has run, this date is locked in. If you need to change it afterward, you'll need to unlink and re-link that bank account to select a new date — editing the field alone won't retroactively change what was already imported. ::: ### Configure the Import Schedule Once your accounts are linked, open the **Import Schedule** subtab on the format profile to control when NetSuite pulls transaction data from your financial institution. Complete the following fields: - **Unit of Time:** Choose the interval unit (e.g. *Day*) for how often imports should run. - **Repeat Every:** Set the frequency within that unit (e.g. *1 day* for a daily import). - **First Scheduled Import Date:** The date the first automated import should run. - **First Scheduled Import Time:** The time of day the import should kick off. - **Time Zone:** The time zone your scheduled time should be interpreted in. Click **Save** once these are set. *** ## Step 5: Monitor Bank Import Process :::hint{type="info"} **NOTE: **You may not see transactions in the Match Bank Data page upon setup, as our Bank Feed solution will import all prior-day transactions the day after setup and continue to do so onwards. ::: 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 → **PINACLE® | PNC** → Banking Import History**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/BsGgj5K8k4yWjrJVHxHcF_screenshot-2024-05-22-at-30219-pm.png" size="80" width="818" height="97" position="center" caption="Click Track your status" showCaption="true"} If the import is successful, you will see **Completed** under the **Import Status** column. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/NN0WWR7_wbbukCoD5PQE7_image.png" size="80" width="2452" height="488" 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. 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 PNC Support. [Contact Us](docId:8_JBWcKPCwaeZlWI_jIv4) *** ## Troubleshooting ### Identifying Errors In the situation where a bank data import fails, the failure reason can be found on the Banking Import History page. ::::WorkflowBlock :::WorkflowBlockItem Navigate to **Transactions → PINACLE® | PNC → Banking Import History.** ::: :::WorkflowBlockItem Find the line item that shows the Import Status as **FAILED**, accompanied by a red caution icon. On that line item, click on the small plus icon on the far left to expand the row. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/wX4WHEJme0HlSqAk9B7Gx_image.png" size="80" width="800" height="71" position="center" caption="Failure Reason" darkWidth="800" darkHeight="71" showCaption="true"} ::: :::WorkflowBlockItem After expanding the row, the Failure Reason is provided. ::: :::: ### Unrecognized Bank Transaction Codes ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/6DX-D5iZBx_G9DP6Gmysw_image.png" size="58" width="800" height="809" position="center" caption="Sample import failed error on the Match Bank Data page" darkWidth="800" darkHeight="809" showCaption="true"} In the event that a bank data import fails due to an unrecognized bank transaction code, you will need to do the following: - Map any missing BAI2 codes - Retrieve Statement IDs from Connectivity Method / Parser Execution logs - Contact a FISPAN representative with the following: - Statement IDs from impacted accounts - The date the import failed - The date of the transactions that are missing Please refer to the sections below for instructions on how to proceed. ### Mapping Bank Transaction Codes :::::WorkflowBlock :::WorkflowBlockItem **Locate the Financial Institution ** Navigate 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 you have also created previously. ::: :::WorkflowBlockItem **Fill in the Bank Transaction Code Details** Fill in the following fields for the bank transaction code that was unrecognized: - **Bank Transaction Code: **The three-digit code from the error message seen on the Banking Import History page, or on the Match Bank Data page. - **Description: **Fill in with the code's description, which can be found here: [BAI.org Cash Management Balance Reporting Specifications, page 10](https://www.bai.org/docs/default-source/libraries/site-general-downloads/cash_management_2005.pdf) - **Bank Data Type** - **Credit / Debit** **Bank Data Type** and **Credit / Debit** values will be the same. They both must be either **Credit,** **Debit, **or **N/A**. This can also be found on [BAI.org Cash Management Balance Reporting Specifications, page 10](https://www.bai.org/docs/default-source/libraries/site-general-downloads/cash_management_2005.pdf), or by referring 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 PNC support. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/oYKTI344SOfhT8ksLyiie_image.png" size="80" width="800" height="124" position="center" caption="Sample data for BAI2 code 389" darkWidth="800" darkHeight="124" showCaption="true"} ::: ::::WorkflowBlockItem **Save the Code Details** Once you have entered the missing BAI2 code information, click **Save** on the Format Profile. :::hint{type="warning"} **IMPORTANT:** NetSuite will attempt to re-import bank transactions, but they will not yet appear on the Match Bank Data page. You will still need to retrieve the Statement IDs and contact PNC Support with affected dates to request a re-sync. ::: :::: ::::: ### Retrieving Statement IDs from Execution Logs In the case of a failed import, you will need to retrieve Statement IDs from the Execution Logs from either the Connectivity Method or the Transaction Parser prior to reaching out to our Support Team to resync transactions. :::hint{type="warning"} **NOTE: **NetSuite will only store 30 days' worth of Execution Logs and, by default, will only display the past 24 hours' worth of logs. ::: :::::WorkflowBlock :::WorkflowBlockItem **Locate the Financial Institution ** Navigate to **Setup → Accounting → Financial Institution → List** Click **Edit** on the Financial Institution that you have created previously. Select the **Format Profile: Configuration** tab and click on the **Name of the Format Profile** you have created previously. ::: :::WorkflowBlockItem **Open Transaction Feed** On the Format Profile, under **Connectivity Method**, click the hyperlinked Bank Transaction Feed, and open it in a new browser tab. Under **Transaction Parser**, also click the hyperlinked Bank Transaction Feed and open it in a new browser tab. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/D8Q2LP6YvKXRhaLd6D_hX_image.png" size="80" width="800" height="290" position="center" caption="Hyperlinked Connectivity Method and Transaction parser" darkWidth="800" darkHeight="290" showCaption="true"} ::: ::::WorkflowBlockItem **Locate Execution Logs** In both of the new tabs that were opened for the **Connectivity Method** and **Transaction Parser**, click the **Execution Logs** tab in the sub-menu. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/yhK5qXRu8Z7Ay_mf6V2qw_image.png" size="78" width="800" height="245" position="center" caption="Connectivity Method (Financial Institution Connectivity) Execution Logs" darkWidth="800" darkHeight="245" showCaption="true"} ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/4pC9nWByWzxi2nNmy9rie_image.png" size="88" width="800" height="300" position="center" caption="Transaction Parser (Financial Institution Parser) Execution Logs" darkWidth="800" darkHeight="300" showCaption="true"} The Statement IDs, Account IDs, and Number of Transactions should be identical between both the **Connectivity Method** and **Transaction Parser**. Each row corresponds to a bank account linked with the new bank feeds service. :::hint{type="info"} **NOTE:** The **Connectivity Method** (Financial Institution Connectivity) downloads bank transactions from FISPAN. The Execution Logs here will display any errors relating to connectivity issues with FISPAN. The **Transaction Parser** (Financial Institution Parser) pushes the downloaded bank transactions from FISPAN into the Match Bank Data page in NetSuite. The Execution Logs here will display any errors relating to missing BAI2 codes or other formatting issues in the bank transaction data. ::: :::: ::::: ### Unable to see Execution Logs? If you are unable to see any Execution Logs from the past 24 hours, you will need to add a Date filter as a Custom View. Please note that any logs that are older than 30 days are not stored by NetSuite. ::::WorkflowBlock :::WorkflowBlockItem **Customize View** From the Plug-In Implementation page that you were on for either the Financial Institution Connectivity or Financial Institution Parser, click on the **Customize View** button. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/Q_IGljAzocxeY2Y0qDCIG_image.png" size="80" width="800" height="247" position="center" caption="Click on Customize View" darkWidth="800" darkHeight="247" showCaption="true"} ::: :::WorkflowBlockItem **Create Custom View ** On the Customize Script Server Script Log Search Results page that just opened, rename the **Search Title** to `[BANK] Bank Feeds - Execution Log Dates`. Next, click on the **Available Filters** sub-tab. ::Image[]{src="https://app.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/sQbigUE0CP841z61lZQDQ_image.png" size="80" width="2872" height="908" position="center" caption="Rename the Search Title, then click on Available Filters" darkWidth="2872" darkHeight="908" showCaption="true"} Click the dropdown in the last row of the table. Select a **Date** from the options. ::Image[]{src="https://app.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/s5Jsdr5r-lnvXa668L3i5_image.png" size="80" width="2872" height="898" position="center" caption="Custom Default Script Notes View - filter by Date" darkWidth="2872" darkHeight="898" showCaption="true"} Once you have added the **Date**, click **Save**. This Custom View will now be available on both the **Financial Institution Parser **and **Connectivity Method** logs. ::: :::WorkflowBlockItem **Access the Custom View** Clicking **Save** will take you back to the Plug-In Implementation page. From here, click on the **Execution Log** tab. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/cY6UhUuuA6NfLt3PKz9b-_image.png" size="80" width="800" height="334" position="center" caption="Date filter applied" darkWidth="800" darkHeight="334" showCaption="true"} There will be a new option under the **View** dropdown, which is the **Custom View **you have just created. When the new **Custom View** is selected, a **Date** filter will now appear. ::: :::WorkflowBlockItem **Locate Execution Log** Using the new **Date** filter, find the date the error occurred on. This should be the same date you are missing transactions for. Once a date within the past 30 days has been selected, the table will populate with several rows containing Statement IDs, Account IDs, and the Number of Transactions for every bank account linked with the bank feeds service for the selected date. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/cY6UhUuuA6NfLt3PKz9b-_image.png" size="80" width="800" height="334" position="center" caption="Execution Log tab" darkWidth="800" darkHeight="334" showCaption="true"} Copy the contents of the whole table and paste into an email addressed to PNC Support. Ensure the following is included in your message - Execution Log table contents (containing Statement IDs from impacted accounts) - The date the import failed - The date of the transactions that are missing With this information, our PNC Support will be able to retrieve your missing transactions and resync them as part of your next morning's automatic import. ::: :::: Here is an updated list of BAI codes that PNC sends to both the plugin and via bank feeds. ::File{src="https://api.archbee.com/api/presign/MM6nC_bKbIkwCRqiFZqEu/tWj0cQtmH8GVXiZDohlLS_supported-bai-codes.pdf" label="Supported BAI Codes.pdf" isUploading="false"} *** ## Importing Transactions In NetSuite If you need to import transactions inside the Match Bank Data page of NetSuite, follow the instructions below. This will work even if you have Bank Feeds enabled. :::::WorkflowBlock :::WorkflowBlockItem ### Go to Account Go to **Your Bank → Reports → Balances & Transactions** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/_3eMKx8U3xmq3WYTpVUFC_image.png" size="70" width="1150" height="602" caption="Navigating to Balances & Transactions Page" position="center" showCaption="true"} Select the account you would like to access. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/kjxWlC2VK_sS8FTlYWSTm_image.png" size="80" width="1864" height="758" caption="Select Account to Export Transaction" position="center" showCaption="true"} ::: ::::WorkflowBlockItem ### Export BAI2 or CSV Apply the appropriate filters, select **Export**, and select the appropriate export type. You should select BAI2 or CSV. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/rLXM3liosFL2DHyB0VKgp_image.png" size="80" width="2860" height="1322" caption="Select Desired Export File Type" position="center" showCaption="true"} :::hint{type="info"} **NOTE: **If the file does not download, make sure your pop-up blocker is disabled. ::: :::: ::::WorkflowBlockItem ### Import File Go to **Transactions** **→** **Bank** **→** **Banking Import History** **→** **Upload File**. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/QAS3xTe2ZhgSpZox_DqlN_image.png" size="70" width="750" height="479" caption="Upload File" position="center" showCaption="true"} Select **Choose a file **and select the file you just downloaded earlier. Then, select** Import with a default parser, **choose the appropriate account, and select** Import. ** ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/tteen_RHVxfsi8u8R_pvR_image.png" size="70" width="755" height="476" caption="Upload File" position="center" showCaption="true"} :::hint{type="warning"} **IMPORTANT: **If you have selected a BAI2 file, you will not need to select your account, as the bank account information should already be present in the BAI2 file itself. ::: :::hint{type="danger"} **WARNING: **For the BAI2 import to work successfully, you will need to make sure your Routing Number and Bank Account Number present (4 digits only) in the BAI2 file (in the first three rows) match the records 02/03 from the Chart of Accounts. To modify the Chart of Accounts records, navigate to Chart of Accounts, click **Edit** on the appropriate bank account, and then hit **Bank Import Mapping**. Make sure that record 02 includes the Routing Number of the bank account and that record 03 includes the 4 digits of the Account Number. This should match exactly what is in the BAI2 file. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/_hTuo-glaUfZZ_YHNjFkK_image.png" size="68" width="352" height="146" position="center" showCaption="false"} ::: :::: ::::: [Contact Us](docId:8_JBWcKPCwaeZlWI_jIv4)