--- title: Managing Balances & Transactions (NetSuite) slug: pnc/managing-balances-and-transactions-netsuite description: Learn how to view your Balances & Transactions, and enable transaction matching for Reconciliation. 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 Balances & Transactions View account balances and transaction details across all of your accounts, all within NetSuite. ::::WorkflowBlock :::WorkflowBlockItem ### Navigate to the Balances & Transactions page. Go to PINACLE® | PNC** → Reports → Balances & Transactions.** 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/qBRKfsU5LinNX0BcJLic1-20260512-235350.png" size="80" width="800" height="352" position="center" caption="Account Summary" darkWidth="800" darkHeight="352" 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 further below. Use the date filters to help narrow your search. You’ll see all settled transactions, debits, and credits for the account. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/hQJ1CCiRPnLdOTD1lrZ4C-20260512-235350.png" size="80" width="800" height="384" position="center" caption="Transactions View by Account" darkWidth="800" darkHeight="384" showCaption="true"} To see additional details about a specific transaction, click **View** under the **Details** column. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/9jhM_AyTSmJCAu8iPw2XN-20260513-000058.png" size="80" width="800" height="645" position="center" caption="View Transaction Pop Up" darkWidth="800" darkHeight="645" showCaption="true"} ::: :::: *** # ACH Reconcilement Details If your organization has enabled the ACH Reconcilement Details service, you will see unbatched ACH transactions in the transaction details popup within the Transactions page. Click **YES** in the Items column to view these transactions. ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/P8lKvTW7mtABc-oYoswMv_screenshot-2024-05-30-at-92228-am.png" size="80" width="1717" height="634" position="center" caption="Click Yes" showCaption="true"} ::Image[]{src="https://api.archbee.com/api/optimize/MM6nC_bKbIkwCRqiFZqEu/9FTLajywXZqGH7sZchbKL_screenshot-2024-05-30-at-92439-am.png" size="80" width="1282" height="818" position="center" caption="View Unbatched Transactions" showCaption="true"} This additional service supports your day-to-day reconciliation processes by providing detailed information about batched ACH transactions that appear on the bank statement. Bank Feeds supports the export of the detailed view of transactions to directly reduce the time spent on transaction matching during reconciliation. ACH payments made through the plugin are highly compatible with the ACH Reconcilement Details. These transactions are specially enriched to provide the highest opportunity for automatching once uploaded for Bank Feeds. To learn more about enabling ACH Reconcilement Details for your organization, please reach out to your PNC Treasury Management Officer. *** ## 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 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"} ::: :::: :::::