Multiple NetSuite records to a single bank account
A single bank transaction can be matched to multiple NetSuite transactions. This is necessary in case of batch transactions where multiple NetSuite transactions are represented by a single transaction on the bank statement.
- Select bank transaction using the radio button.
- Then select the relevant NetSuite transactions from the checkbox.
- As the NetSuite transactions are selected, the total amount of the selected transactions gets calculated and difference in the amount between the bank statement and selected NetSuite transactions is shown in the Amount difference textbox.
- This difference should be zero if all the NetSuite transactions associated with the bank statement are selected.
NetSuite message before saving the records.
Message displays the summary of difference between ending bank statement balance and ending general ledger balance. The account summary displays amount for the following: Matched Transactions, Partially Matched Transactions, Potentially Matched Transactions, Unmatched Transactions. Ending Bank Statement Balance is also displayed.
Records is saved successfully.
View of the record in NetSuite as journals.
View of the individual journal.
Multiple bank accounts to a single NetSuite transaction
The Connector supports matching many bank transactions with a single NetSuite transaction. You can choose the configuration you want to use in the dashboard as often as you want.
Sample screen depicting the selections: