Managing Balances & Transactions (NetSuite)

the balances & transactions feature allows you to see previous and intraday balances directly from your accounts in near real time if you would like to use bank data for reconciliation, we recommend enabling bank feeds (see bank feeds section for more info) access your bank account balances in near real time, directly within your financial management software, using balances and transactions drill down into the details of every deposit, withdrawal, and transfer, and view images of presented checks follow this guide to learn how to set it up viewing balances & transactions view account balances and transaction details across all of your accounts, all within netsuite go to balances & transactions go to your bank → 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 the account summary page displays all bank accounts connected to the plugin select an account to view its intraday and previous day balances intraday balances (updated time bank dependent) previous day balances (updated time bank dependent) view balances & transactions bank account balances are displayed at the top of the page scroll down to see the bank transactions , which are effectively your bank statement populated on this page you’ll see all settled transactions, debits, and credits for the account go to the details column → select view to see the details about a transaction, including any available remittance information match transactions for reconciliation enable transaction matching go to setup → accounting → chart of accounts 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 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 confirm transaction matches go to transactions → bank → match bank data 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 navigate to balances & transactions go to your bank → reports → balances & transactions select the account you would like to access export bai2 or csv file apply the appropriate filters, select export , and select the appropriate export type you should select bai2 or csv note if the file does not download, make sure your pop up blocker is disabled upload bai2 or csv file go to transactions → bank → banking import history → upload file select choose a file and select the file you just downloaded in the previous step then, select import with a default parser, choose the appropriate account, and select import 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 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 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