05 February 2012

Accountancy ForumsGot a question to ask?

Bit of advice to give?

Or something to offer?


 
The Accountants Circle ForumsThe Accountants Circle ForumsGeneral ForumsGeneral ForumsGeneralGeneralBank Reconciliation on SageBank Reconciliation on Sage
Previous Previous
 
Next Next
New Post
 23/08/2010 12:34
 

I wonder if someone can help me with a problem.


I have input all items on Sage and then carried out a Bank Reconciliation which was all OK. However, there appears to be something very wrong with the bank current account shown on Sage. At present the actual bank figure is approximately £40k in credit but Sage says we are overdrawn by £6k. It looks like I have duplicated a couple of items and used these when reconciling the bank statement (I have checked and I added a couple of items which were dividend payments to the directors. I couldn't find these on Sage at first hence putting them on again but it transpires the director put these on himself previously and were part of a larger BACS payment and these are the ones which should have been reconciled).

Apparently, when attempting to rectify this I cannot cancel the ones the director put on there already as it will effect the PAYE and NI accounts.

I have no idea what I am going to do as I can't undo the bank reconciliation and as its now reconciled I can't get rid of the items I put on myself either. I have been asked not to cancel the entries the director put on himself for the reasons stated above.

Many thanks,
Leigh

New Post
 23/08/2010 12:43
 

Hi Leigh

As I understand it, you posted the transactions and reconciled these although the director had already posted the same transactions which weren't chosen in the reconciliation. Is that right?

So long as the director's posting is correct, I'd look to reverse the duplicate entries by posting a journal, or opposing entry (eg. Payment instead of receipt) ensure it would completely clear your duplication entry (incl VAT etc).

This would then mean you could choose this reversing entry along with the director's transactions and reconcile these as an additional bank reconciliation to clear each other, so long as the net effect is zero which is should be unless either his postings or your duplicates are not correct.

Hope this provides you with a solution!

New Post
 23/08/2010 13:17
 

Thank you so much for your reply John, I will do as you suggest. Much appreciated. Leigh

Previous Previous
 
Next Next
The Accountants Circle ForumsThe Accountants Circle ForumsGeneral ForumsGeneral ForumsGeneralGeneralBank Reconciliation on SageBank Reconciliation on Sage

    About Us     Testimonials     Case Studies     FAQs     Contact Us    


Privacy StatementTerms Of Use • Copyright 2007-2011 The Accountants Circle LLC. All Rights Reserved.