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) viewing balances & transactions video viewing balances & transactions instructions step 1 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 account summary page displaying all bank accounts connected to the plugin select into an account to view their intraday and previous day balances intraday balances (updated time bank dependent) previous day balances (updated time bank dependent) step 2 view balances & transactions bank account balances are displayed at the top of the page bank transactions scroll down to see what is essentially your bank statement, populated on this page you’ll see all of the settled transactions, debits and credits, for the account go to the details column → select view to see richer details about a transaction including any available remittance information reconciliation video reconciliation instructions step 1 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 step 2 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 on a daily basis transactions that settled the day before will be imported early in the morning step 3 confirm transaction matches go to transactions → bank → match bank data select the appropriate account from the drop down 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 go to your bank → reports → balances & transactions select the account you would like to access 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 go to transactions → bank → banking import history → upload file 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 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 for the bai2 import to work successfully, you will need to make sure the routing and bank account numbers present 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 go to the 'bank import mapping' tab make sure that record 02 includes the routing number of the bank account and that record 03 includes the account number in full this should match exactly what is in the bai2 file