---
title: Managing Bank Accounts (NetSuite)
slug: vantage-connect/managing-bank-accounts-netsuite
docTags: bSho0M8HRjDvZq9EBIWDy
createdAt: 2022-08-02T17:21:55.000Z
---

Access your bank account balances directly within your financial management software, using the Cash Management Reporting features. Drill down into the details of every deposit, withdrawal, and transfer.

Follow this guide to learn how to view balances and transactions, and use bank data for reconciliation.

***

## Viewing Bank Accounts 

View account balances and transaction details across all of your accounts, all within NetSuite.

::::WorkflowBlock
:::WorkflowBlockItem
### Navigate to the Bank Accounts page.

Go to Vantage Connect** → Reports → Bank Accounts.**

Here, you can view all of the bank accounts that you have connected with the plugin. The bank accounts that are shown to a user depend on their level of permissions. 

For instance, if a user is restricted to a subsidiary, they can only view accounts that are associated with that specific subsidiary and not accounts belonging to other subsidiaries.
:::

:::WorkflowBlockItem
### Select Account

Click on any account's name to view the Intraday and Previous Day Balances.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/TTUL2T8f2OEWdIZhN_asy-20260513-211925.png" size="80" width="800" height="403" position="center" caption="Accounts Overview" darkWidth="800" darkHeight="403" showCaption="true"}

- Intraday Balances (updated time bank dependent)
- Previous Day Balances (updated time bank dependent)
:::

:::WorkflowBlockItem
### View Balances & Transactions

**Bank Account Balances** are displayed at the top of the page.

**Bank Transactions **that have been posted to your account are presented in the table below. Use the date range filters to view transactions over specific timeframes, such as the past week or month, or to set a custom date range to narrow your search.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/-Ufp6rMDIPvYsZMQh6b1F-20260513-211926.png" size="80" width="800" height="207" position="center" caption="Account Balances and Transactions" darkWidth="800" darkHeight="207" showCaption="true"}

You can see all settled transactions, debits and credits for the account.

To see additional details about a specific transaction, click **View** under the **Details** column.
:::
::::

***

## Viewing Posted Paid Checks

This feature will provide the ability for users to view the front and back of previously posted paid checks, if available. 

:::hint{type="info"}
If there is no image available for the check, no images will be displayed.
:::

If images are available for the paid check, thumbnails of the front and back thumbnail images will be displayed on the **Transaction Details **window.

::Image[]{src="https://api.archbee.com/api/optimize/z7B2F1SpvEnr9KImiRpyQ-Lh9IMbqH_lopoQB2Wxt1S-20250228-191804.png" size="80" width="1647" height="845" position="center" caption="Transaction Details - select the thumbnail image" darkWidth="1647" darkHeight="845" showCaption="true"}

To automatically download the image, click **“View Front” ** or **“View Back”**. Check images will be saved in the “Downloads” folder. 

**Sample Front of Check Image**

::Image[]{src="https://api.archbee.com/api/optimize/z7B2F1SpvEnr9KImiRpyQ-ism2FZALzAC7modG98NrX-20250228-192150.png" size="80" width="1652" height="709" position="center" caption="Front view of check" darkWidth="1652" darkHeight="709" showCaption="true"}

**Sample Back of Check Image**

::Image[]{src="https://api.archbee.com/api/optimize/z7B2F1SpvEnr9KImiRpyQ-BM1GqQqwLThZzSRFGcspN-20250228-192747.png" size="80" width="1651" height="717" position="center" caption="Back view of check" darkWidth="1651" darkHeight="717" showCaption="true"}

***

## Match Transactions for Reconciliation 

Follow these steps to start matching bank data and reconcile your accounts. 

::::WorkflowBlock
:::WorkflowBlockItem
### Enable Transaction Matching

Go to **Setup** **→** **Accounting** **→** **Chart of Accounts (Click on the title)**.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/K1FaAe7eiYWBqrePvpZ-D_image.png" size="70" width="800" height="556" caption="Chart of Accounts" position="center" darkWidth="800" darkHeight="556" showCaption="true"}

Select **Edit** on the bank account for which you would like to use the reconciliation feature.

![](https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/5r2t8K5Vp5zKccD0t1zf7-20260115-234757.png "Click 'Edit' to Open the Bank Account")

Select the **Use Match Bank Data and Reconcile Account Statement Pages **box to enable this feature for the account.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/0vEKIuU3WrkUKvjzUWzSL_image.png" size="80" width="800" height="468" caption="Use Match Bank Data and Reconcile Account Statement Pages" position="center" darkWidth="800" darkHeight="468" showCaption="true"}

Then, select **Save.**
:::

:::WorkflowBlockItem
### Enable Bank Feeds

Ensure that Bank Feeds have been properly enabled for your account. Once Bank Feeds have been enabled, you should be able to see transactions coming into the Match Bank Data page daily. Transactions that settled the day before will be imported early in the morning. If you do not set a custom schedule, NetSuite will default to a randomized time between 4 AM to 7 AM PST.
:::

:::WorkflowBlockItem
### Confirm Transaction Matches

Go to **Transactions →** **Bank → Match Bank Data**. 

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/OUcqIheuvbaScVUGhOQNE_image.png" size="80" width="800" height="770" caption="Go to Match Bank Data" position="center" darkWidth="800" darkHeight="770" showCaption="true"}

Select the appropriate account from the dropdown, and your transactions will appear in the left column for matching.
:::
::::

***

## Importing Bank Transactions inside NetSuite

If you need to manually import transactions into NetSuite's Match Bank Data page, follow the instructions below. This process works even if your bank feeds are already enabled.

:::::WorkflowBlock
:::WorkflowBlockItem
### Navigate to Bank Accounts

Go to Vantage Connect** → Reports → Bank Accounts**

Select the account you would like to access.

![](https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/TTUL2T8f2OEWdIZhN_asy-20260513-211925.png "Bank Accounts")
:::

::::WorkflowBlockItem
### Export BAI2 or CSV File

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/ln7HSOkRZcyxevSOUND1Q-20260513-213439.png" size="30" width="800" height="1087" position="center" caption="Export Options" darkWidth="800" darkHeight="1087" showCaption="true"}

:::hint{type="info"}
**NOTE:** If the file does not download, make sure your pop-up blocker is disabled.
:::
::::

::::WorkflowBlockItem
### Upload BAI2 or CSV 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="800" height="511" caption="Upload File" position="center" darkWidth="800" darkHeight="511" showCaption="true"}

Select **Choose a file **and select the file you just downloaded in the previous step.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/tteen_RHVxfsi8u8R_pvR_image.png" size="70" width="800" height="504" caption="Upload File" position="center" darkWidth="800" darkHeight="504" showCaption="true"}

Then, select** Import with a default parser, **choose the appropriate account, and select** Import. **

:::hint{type="info"}
**NOTE: **If you have selected a BAI2 file, you will not need to select your account, as the bank account information is already present in the BAI2 file itself.
:::

:::hint{type="warning"}
**IMPORTANT:** For the BAI2 import to succeed, the routing and bank account numbers in the BAI2 file's first three rows must match the corresponding data in the Chart of Accounts.

::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/_hTuo-glaUfZZ_YHNjFkK_image.png" size="64" width="800" height="332" darkWidth="800" darkHeight="332" position="center" caption="Bank Import Mapping tab" showCaption="true"}

To update the Chart of Accounts records:

- Navigate to the **Chart of Accounts**.
- Click **Edit** on the relevant bank account.
- Go to the **Bank Import Mapping** tab.
- Ensure that Record 02 contains the routing number and Record 03 contains the full account number. This information must be an exact match for what is in the BAI2 file.
:::
::::
:::::