Page 1 of 1

Problem in Bank reconciliation

Posted: 07 Aug 2012, 17:39
by Angeline
Hi,
I have started working in a company who has been using sage 50 and sage payroll, since there was a gap in the bank rec, I needed to do it from April.
I noticed some discrepancies,which cannot be sort out now,so I have started matching the items by changing the end date to June 30th. I want to know, whether I could enter the end balance as the reconciled April end balance(calculate from the real bank statement) and press reconcile and continue to do the same for other months, without deleting the matched ones? sorry I am really confused on what I am doing...please help?

Re: Problem in Bank reconciliation

Posted: 08 Aug 2012, 15:50
by brucedenney
If you can't sort out the discrepancies make a bank payment or receipt to equal the value of the discrepancies and match it off.

Post it to a suspense account with a good description like "bank rec discrepancy"

Re: Problem in Bank reconciliation

Posted: 09 Aug 2012, 06:30
by Angeline
Hi,
Thank you for the reply. Actually the discrepancies are some sort of fraud done by the previous worker, so those have to be kept til the case come to an end...But at the same time, I need to do the bank rec to have a correct accounts...really struggling to do that....any suggestions?

Re: Problem in Bank reconciliation

Posted: 09 Aug 2012, 09:19
by brucedenney
It doesn't matter what the cause of the discrepancy is, you either deal with it or live with it.

As far as forensics go, I would keep a backup from the day that the fraud was discovered, this is better evidence than what is in the system right now as it has a date stamp.

If you need to be able to refer to the data for your case then I would create an archive of the system as it stands right now which you can view and report on.