One enhancement NetSuite released in their recent upgrade is that users are now able to select all bank transactions (i.e., on the left side) from the Match Bank Data page. However, there is still a need for an enhancement that allows users to export data from both the Match Bank Data and Reconcile Account Statement pages into a CSV or Excel file.
Users sometimes need to export bank data (especially when imported via Bank Feeds) or matched bank transactions for manual reconciliation or record-keeping purposes.
To export the data, you can do the following:
- Set the desired date filters.
- Highlight some cells until you see the blue highlight box.
- Press Ctrl + A in the keyboard to select all cells, then press Ctrl + C to copy.
- Paste it in Excel.
The method above also works in the Reconcile Account Statement page.
Limitations
- Selecting all data works on a per-page basis. Therefore, if there are 8 pages, you need to copy and paste the data from each page separately.
- The View Details in the Reconcile Account Statement (where the line is classified as Matched or Cleared) are not copied.