so what I normally do is use the "write check tran...
# accountingk
KevinJ of Kansas
05/05/2020, 8:58 PMso what I normally do is use the "write check transaction" post the line to a holding account - and then I do a reversal journal entry to clear it off. Then I do an "opening" bank rec, where I select all the GL history of the account plus the reversing entry and it should tie to the last known balance of the account, that I enter into the ending balance.
a
Alex K
05/05/2020, 9:23 PMThanks for the guidance as always. I got a little lost, I understand the check has Dr. Clearing account and Cr. Bank account, but reversing this leaves the account with net 0 to reconcile against
k
KevinJ of Kansas
05/05/2020, 9:25 PMthat's the idea. You are adding open transactions that can be reconciled against - and then clearing off the reversal entry out of the bank account with all the GL history imports in an opening balance Bank Rec (often called a dummy reconciliation)
KevinJ of Kansas
05/05/2020, 9:26 PMNetSuite will say "do this even with variance" but my goal is always to get to $0 variance in it because then there isn't cleanup to do again later.
KevinJ of Kansas
05/05/2020, 9:27 PMso the approach effectively is to remove all the "bad" transactions that will never clear because they don't really exist, and to leave open the Check portion for the ones that actually did in the account, without changing the GL balance in the account from what it was at time of cutover
KevinJ of Kansas
05/05/2020, 9:28 PMunfortunately, that's about as much as I'm gonna give away free, haha.
a
Alex K
05/05/2020, 9:29 PMha-understandable, appreciate the help!