This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hello,
I just got an urgent request from auditors and legal to to provide the list of Unmatched Bank Transactions.
Basically, the information that appears on both columns when we go to the "Match Bank Data" screen.
    Transactions > Bank > Match Bank Data
• Any ideas?
Thank you

I've looked for this data in the past. At the time, it wasn't available in the data model where it could be retrieved with SavedSearch or SuiteQL. Not sure why.

If you're looking for an "unsupported" option, you could hit the internal NetSuite API that the Match Bank Data screen calls with a URL similar to the following:

```https://&lt;YOUR_NETSUITE_ACCOUNT_ID&gt;.<http://app.netsuite.com/erp/resources/importedtransactions.nl?accountId=&lt;INTERNAL_ID_OF_BANK_ACCOUNT&gt;&amp;isMatched=F&amp;includeAutoPostStubs=F&amp;sortBy=dDate&amp;sortDirection=ASC&amp;skip=0&amp;includeDuplicates=T&amp;isExcludedOrDuplicate=T|app.netsuite.com/erp/resources/importedtransactions.nl?accountId=&lt;INTERNAL_ID_OF_BANK_ACCOUNT&gt;&amp;isMatched=F&amp;includeAutoPostStubs=F&amp;sortBy=dDate&amp;sortDirection=ASC&amp;skip=0&amp;includeDuplicates=T&amp;isExcludedOrDuplicate=T>```

That will return a JSON object of unmatched transactions for the specified bank account.

It looks it returned the "Excluded" transactions, no the ones under the "To Be Matched".

Try changing "isExcludedOrDuplicate" from "T" to "F"

Oh!
That worked.
Now I need to figure out how to convert that JSON to excel or some kind of list.
I am not a developer, so I have no idea how to do that.
Thanks a lot for your help.

There are some online JSON to CSV converters, but use at your own risk. Assume they're keeping a copy of any JSON you upload.

Yes, I found one.
THANKS A LOT FOR YOUR HELP!