Discussions
Streamline Invoice Processing with AI-Powered Automation
Use AI-Driven Insights for Faster, Better Planning and Forecasting
Bank Reconciliation Reports are showing wrong sign for the reconciled amounts > causing Difference.
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: