19 May 2012

Accountancy ForumsGot a question to ask?

Bit of advice to give?

Or something to offer?


HomeHomeGeneral ForumsGeneral ForumsGeneralGeneralBank Reconciliation on SageBank Reconciliation on Sage
Previous
 
Next
New Post
23/08/2010 11: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 11: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 12:17
 

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

 
Previous
 
Next
HomeHomeGeneral 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.