I’ve noticed there’s an issue with the Reconciliation Summary screen in NetSuite which is affecting some of the bank accounts. If we look at GL 200003 for example, when I have gone back and re-reconciled the account for December 2022, there were 2 receipts and then one suppler payment with a net income of £28,245.58. This matches the 31/12/2022 bank statement and you can see on the reconciliation screen that this reconciles with no difference as expected:
However, once I submit the reconciliation and then go back to the Reconciliation Summary screen to review it, it seems to be showing the transactions through the account with the opposite parity than they should have, and therefore showing a difference on the rec because the balances are summing rather than netting off as they should:
You can see in the Reconciliation Detail above that it is showing the supplier payment as positive and the 2 receipts as negative, when it should be the other way around.