The Book-keepers Forum (BKF)

Post Info TOPIC: Bank Reconciliation on Sage


Senior Member

Status: Offline
Posts: 154
Date:
Bank Reconciliation on Sage
Permalink Closed


Help! no

Just spent rather too long trying to complete my reconciliation - with no success. £220 difference, couldn't find it anywhere, getting to the tearing hair out stage. Finally realised that the problem was with the last reconciled balance figure, which within the reconciliation function is being given as       -£8774.89.

Unfortunately, the last time I reconciled, the closing balance was -£8994.89, as proved by the reconciliation statement I have printed off. Also, if I go into the bank account record, in the reconciliation box it also gives the last reconciled balance as -£8994.89.

So how on earth is this happening? confuse And how can I stop it / change it? I have tried discarding the reconciliation and starting again, but no good.

Would really appreciate any help anyone can give, preferably before I throw my computer against the wall in frustration!



__________________


Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Hi there,

If your last reconciled balance is different it means that you have changed something in the previous month after you did the reconciliation. I would suggest printing off the saved bank rec/statement from last month and then printing off the nominal activity report for your bank account for last month and ticking off the transactions....maybe/hopefully something will come to light. Of course it's possible that it's not in that month but any previous month, so if the difference isn't standing out then I'm afraid it's a question of being methodical

I assume you've looked to see if there is a specific transaction for £220?

Pauline

__________________

Pauline



Senior Member

Status: Offline
Posts: 154
Date:
Permalink Closed

Pauline & Donna,

Thank you both for your help. Never again will I believe a client who tells me that they only looked at the information on Sage!

I took Pauline's advice and went methodically through all the payments, and did indeed find one that had been deleted after it had been reconciled - not by me!! My client thought it was wrong as she "didn't think she paid that many dd's to British Gas" - unfortunately when you have 4 different sites and B Gas supply your gas & electric to all of them, yes you do. I'm not allowing her near Sage again. disbelief

Thank you again - I should have realised what must have happened, but had got so wound up with it, I was ready to scream.

Thanks, Helen



-- Edited by Helz on Friday 3rd of February 2012 07:45:26 PM

__________________


Senior Member

Status: Offline
Posts: 426
Date:
Permalink Closed

have you tried sorting details in the audit trail - I would presume someone has deleted a line that was previously bank reconciled.

__________________

 

Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900

Payroll & bookkeeping solutions - info@completebookkeeping.co.uk

www.completebookkeeping.co.uk

IAB Training centre - Ringwood

 



Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

No problem Helen.....I always take a deep breath, count to 10 or take a coffee break when I get het up...lol

Pauline

__________________

Pauline



Guru

Status: Offline
Posts: 501
Date:
Permalink Closed

You should always take a back-up of the file before returning to the client for your own protection and sanity

__________________

Thanks, Nadia.

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About