First Previous - Page 1 of 1 - Next Last

Problems reconciling bank...

  • 4 posts
  • # 72426

Hi All,

Sorry - two posts in one day...I've just realised how useful this forum is!!

I've been given the task of problem solving with some books by an accountant... essentially its just reconciling the bank, however it appears to be in an awful mess...but not an obvious one...

The bank is about £2,000 out, however I can't find what on earth has gone on.  They seem to have entered most things in there, (maybe a couple of duplicates which I am weeding out) but it appears to be out from the previous year end (which was completed by a different accountant). 

But I was wondering if anyone could let me know the way you would go around finding the problem, as I seem to be taking an awful long time!!!

Any help would be massively appreciated! :-)

Lizzie

  • Member PM.Dip
  • Practice Licence
  • 117 posts
  • # 72428

Hi Lizzie

Sometimes a bank recn just takes a long time!

Best starting point is the opening balance.  Don't assume that because the previous accountant's figure doesn't match the bank statement it is wrong as there may be timing differences - eg cheques in transit.  Best thing would be to get their recn, if poss.

Personally I would then take a test: take a random statement and see how accurate the bookkeeping is.  This can highlight the area there may be issues with, eg DDs unentered, certain banking missed etc.

If it then looks like you are after just a few rogue transactions check the balance half way through the period and if it is still out go back in time until you find a fully recd month.  Then go forward to the next unrecd month.  This saves looking at months that aer already recd.  This is tricky though if there are a lot of timing differences.

Other than that most softwares have a recn function so that you can tick the recd transactions.  And then there is manual ticking...

Be careful of falling into the trap that if the diff is small there must only be one missing transaction. 

And, finally, if it is taking too long and your accountant agrees, any diff below <5% is immaterial and could be w/off...  but that would be to admit defeat!

  • Companion Fellow PM.Dip
  • Practice Licence
  • 1137 posts
  • # 72431

Hi 

I am sorry if my answer seems strict, but I am hoping it will guide you the right way and help

I would ask the previous accountant to provide the bank reconciled Balance and the bank book balance with the o/s Dr and Cr so that you know you are starting off correctly.  If they cannot then you need to inform them their rec is incomplete and ask the new accountant  want they want you to do.   If it is down their lack of double checks , then they should sort.  

I am little concerned that you have not checked this out before you started, as this is the  basics of completing Recs .  I sorry if I have misunderstood , but is my understanding from your post. Please accept my apologies if you have already done this.

I would also be very concerned if I was a client and it was regarded anything Less then 5 % if it takes to long could be written off if the accountant agree.   I strongly disagree with any balance been written off, this is down to incorrect entry.   If it helps and you are using sage .  It has pdf of every statement  .  Start and closing balance in the view history on the rec screen.

Its personal view , but I have a problem if the bank rec does not agree.  It could be a creditor not paid or even paid twice or Debtor entered incorrectly paid  and infact is still  outstanding.  The client now may have lost money . 

I have to question 5% of what the bank balance of say  50,000 or 100,00 for example that is £2,500,  £5000 . 

I don,t want to sound negative and I sorry if it comes across as harsh.  If I was a business owner I would have a problem with someone writing off for example 5% of £50,000 balance or even say a £100,000 .  Money is money and it pays salaries and bills.   If this is down to the accountants are the bookkeepers incorrect entry then we as professionals must find it.   Otherwise you could be costing clients money.  I would be pretty annoyed if it was my money.



Edited at 22 Jun 2011 09:41 PM GMT

  • 4 posts
  • # 72461

Hi All,

Thanks for your replies.  This has been given to me by an accountant who has recently got this job - but has to do it quickly.  We have a starting balance (bank statement) for the year but it differs greatly from Sage.

Looking at the statements printed off sage of the bank rec's, and matching this with the bank statement 99% of items have been entered correctly, however there does seem to be someone who has got in a muddle with bank transfers...entered them twice...entered them the wrong way round etc...!  I'll sort these out and then see how we're looking....

Liz

First Previous - Page 1 of 1 - Next Last
bottomBanner
loading