Join BKN

Join BKN
Join BKN
Sage One
The Book-keepers Forum -> Book-keeping Software -> Bank Reconciliation on Sage
Post Info TOPIC: Bank Reconciliation on Sage
Helz


Veteran Member

Status: Offline
Posts: 57
Date: Thu Feb 2 13:55 2012
Bank Reconciliation on Sage
 

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!



__________________
Stardoe


Guru

Status: Offline
Posts: 760
Date: Thu Feb 2 17:53 2012
 

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

__________________

Donna CBK


Senior Member

Status: Offline
Posts: 293
Date: Fri Feb 3 19:15 2012
 

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

__________________

 

Donna - Complete Book-Keeping Ltd

Sage 50 One Day Workshop with follow up online Training - Opening May 2012 -

West Drayton (Near Heathrow)

www.completebookkeeping.co.uk
Sage Accredited Accountant Partner
Helz


Veteran Member

Status: Offline
Posts: 57
Date: Fri Feb 3 19:43 2012
 

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

__________________
Stardoe


Guru

Status: Offline
Posts: 760
Date: Fri Feb 3 20:54 2012
 

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

Pauline

__________________
NA_AA


Senior Member

Status: Offline
Posts: 246
Date: Tue Feb 7 21:49 2012
 

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

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
The Book-keepers Forum -> Book-keeping Software -> Bank Reconciliation on Sage
Post to Facebook Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  

BKN Special Offers

 

Resources

Careers & Qualifications  Start Up Essentials  Marketing Centre   Software Reviews
What is a book-keeper  Register as Self-Employed Networking  Software Blog
 Home Study Courses  Money Laundering Local Accountants  
 Qualifications/ Associations  Data Protection Direct Marketing  
 Franchises  Registering as an agent  Telemarketing  
 College / Night School  PI Insurance  Directories  
 Recruitment  Stationery  Google  
     Twitter  
     Volunteer Work  

 

 

 

 

  		 

  		   

 

Copy Right Bookcert Limited