the export button isn't available to select and I'm in administrator mode. the file is not large and there are less than 200 rows of data.

Katerina, I appreciate your help and diligence. I only wish I received this from NetSuite. This issue has been going on for months and I could no longer wait. We did a workaround that no one is happy with but we had to move on. I won't have a screen capture to share with you any longer. My only hope is that this issue is…

Excluding the transaction from the match data bank side will still leave the reconciliation out of balance. We ended up excluding the transactions and altering the starting bank balance to reflect the checks that were already in the trial balances

I never got an answer that made sense to my CFO or CPAs. It is as if no one really understands the situation. We were not given clear instruction on the migration of uncleared transactions prior to go-live so the detailed transactions for AR weren't brought in only the account's trial balance.

Thank you for asking. No. The question has not been answered which leads me to believe the question isn't understood. Option 1 was not liked by my CFO and Option 2 didn't make sense because all of the checks written in the legacy system were included in my trial balances so any Journal Entry making a GL impact won't work.…

I must not be clear in my question because the answer doesn't make sense. The outstanding checks were written and not cleared in the legacy system. As a result, I have a NetSuite bank statement reconciliation where NetSuite has no record of the transaction.

Yes we have imported the bank statement into NetSuite. The transactions (written checks) were from the legacy system and cleared the bank after we went live so there is not a NetSuite Transaction to clear/match. does that answer your question?

Great! If you need more detail let me know. This question is about doing our first bank statement reconciliation. We can't because of legacy system checks and deposits that cleared the bank after our go-live.