Jira code: BLL-146
Issue: The problem is now we have is we cannot analyse the bank statement side. We would like to be able to download the unmatched bank statement lines (left hand side of bank matching screen) and we would like to be able to look at the bank statement lines and view which NetSuite transactions they are matched to in a report. This would be particularly useful to identify when someone has misdated a NetSuite transaction – e.g. we found statement lines dated 10/10/2019, 12/11/2019 and 10/12/2019 and they were all entered with the date 17/02/2020 and all matched. This causes errors on the bank rec but we currently have no way to find these items as we cannot extract the bank statement data.
Findings/Solution:
The Request for downloading the unmatched bank statement lines is still logged as an enhancement in Netsuite. So we are not able to build a report for the same.
- 519976: Transactions > Bank > Confirm Transaction Matches > Ability to Export Unmatched > Statement Transactions and NetSuite Transactions to Excel and CSV
- 472892: Transactions > Bank > Reconcile Account Statement > Be able to Export Unmatched and Matched transactions
- 466130: Transactions > Bank > Reconcile Account Statement > Have a summary view of both Matched and Unmatched Transactions