Hi, our internal accounting team have raised a concern and Im trying to figure out how this can happen. Bottom line its happened 3 times . The first 2 made a note of the incident but since it was within a month or so after our Go live I coughed it up to user error. but this time im not sure. So what's happened is they have done a bank reconciliation and they have proof they follow the steps and matched things then hit the reconcile and they have screenshots and the report to show it was reconciled and in balance. a month later things are unmatched and we have a variance. I am aware that if someone voided or edited a transaction that was previously matched that can break it and undo the matching of that line but not the whole thing. I've checked few things but wanted feedback what else should I look for?

I had similar but in a very simple cloud software, years ago, the client had deleted 3 customers and all the related transactions in an effort to "archive them"..... #painful. Undid 18months of bank rec's... Shouldn't be possible in the same way in NS though. In case it helps, a few thoughts that come to my mind of where I'd look. 🙂 Ask someone to re-reconcile the account, or export and compare with the bank, can they see the issue/what's missing/what's unticked? If you've got a variance, hopefully something should stick out & it'll give you a transaction to look at and start with. Audit trail for changed or deleted transactions that would be linked to that bank account and is within the time frame. Is there a lot of them/a particular user that's doing lots of edits/changes/deletions? Were the accounts locked or closed? It might be worth looking to get the accounts locked & closed earlier to ensure no one can go back and change transactions. Which roles have permissions to edit payments, who has them, focus on them in the audit trail?

Thank you Annabel, something to look at.

I hope you find the issue and can lock it down so it doesn't happen again. Nothing worse than having to find the annoying when no one seems to know what they did/won't own up.