Hello, Is there a way to remove this unreconciled balance (to make it 0 perhaps) from the reconciliation report?

no and why remove them? this will distort the bank reconciliation

so these transactions are going all the way back to 2021 and they hadn't reconciled back then!

do you use match bank data for your transactions?

oh I recently joined, the folks in this company are handling this. i'm just an admin.

Ok but how do you reconcile in Netsuite?

Match Bank Data

I love the question, that’s the spirit! LOL. sorry, could not resist 🙂 just remove it, and problem goes away

I would suggest help from the finance team/book keeper/accountant on a correction journal to correct the issue/s. The issues that are causing the balance need to be found and journals/corrections posted. But this should really have been picked up at an earlier point so bank procedures might need reviewing... The correction/journals would then be used to sort the balance. If you have to have transactions to match is against (because they were missed in the first place) you will need to create a csv bank import with dummy lines to clear the journals from match bank to the Rec screen.

Thanks!