The Book-keepers Forum (BKF)

Post Info TOPIC: Sage 50 Help with bank recs


Veteran Member

Status: Offline
Posts: 65
Date:
Sage 50 Help with bank recs
Permalink Closed


Hi.. i have a feeling this will be my first of many posts. I have been a finance administrator for 2years, and have somehow landed myself a job as a "clerical assistant" but i am actually the bookkeeper. I am untrained but (hopefully) a fast learner...

So i have a question

The lady who did this job before me reconciled the bank in may about 5 times, at various points with different weekly statements she had, i cant seem to get anything to balance, any way of deleting the recs for may and starting again?

......please say yes!

__________________


Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

ok adding to my problems, if i cant delete it and reenter/reeconcile

I have found a transaction which is one of my problems....

on the real b/s there was a dd out for 848.00 4/5/10 , i have checked, it did not bounce. on the bank rec sheet it also shows this 848 out on the same day

However when i look for this tran in financials, it has been deleted. it has then been reentered same amount, same date etc but obviously must have been after the rec date and is now showing in my bank statment. How do i go about correcting this? :-s

__________________


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

Nicola

You cannot delete a saved reconciliation, sorry!

Find a point where you feel it all matches and balances ok and start from there. Not sure what version you have but you may be able to get a recociled report on the bank tab.

The 848 which was deleted needs to be reconciled again, if reconciled before. Patience is needed on this one - its a case of going through all the transactions to see if they have been reconciled on the system....

P

__________________


Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

I think i am going to cry cry.gif

So re reconciling it again, do you reccommend i match it up in the blocks that she has done and so reconcile upto the 5th again and try to get that part to balance and so on?


__________________


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

yes, bit by bit, if you can do it that way.

I had a look at the reports and they are very good, not sure if they are on earlier versions. What version are you using?

P

__________________


Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

im on 2009 i have tried to do it untill 5/5 but i have like 1300 difference :-S its going to be a long night!

__________________


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

take a deep breath.....plenty of coffeeeeee, not over the bank holiday weekend!!

P

__________________


Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

why oh why did i decide to look at the bank accounts on a friday! this is only my first week cry.gif

__________________


Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

lots of brownie points to be earned....

and now I have an interview to conduct!

P

__________________


Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Hi there,

I sympathise with your bank rec problem. So many people just are not methodical when it comes to reconciliations. Sounds like you have got a job on your hands.

When I do bank recs I like to do them manually as well as on Sage. I usually print off a bank nominal activity report for the period I'm reconciling - Nominal - Reports - Nominal activity and then enter the bank nominal code and the dates you require. I have set up a copy of this report so that it sorts in numerical order by amount, so that they are easier to find. This helps if you have loads of transactions. Then it is a question of going through the bank statement and ticking off the entries on the report. I am then left with entries which have not yet gone through the bank.

When I go into the bank reconcile window I then highlight all the entries that haven't yet gone through the bank, click on Swap (which then highlights all the reconciled entries) and then click match.

With regard to the amount that had been reconciled and then deleted and re-entered, it is obviously sitting on your bank rec un-reconciled, so you need to go back to the period when this was reconciled (somewhere about or after 4/5) and enter the balance that was reconciled at the time. Then highlight this transaction and click match and the difference box should be zero.

It all boils down to the fact that you have to start back from where you know you had a correctly reconciled figure and take it from there. There is no quick fix unfortunately cry.gif

Probably totally confused you now!

Pauline

__________________

Pauline



Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

Hi Pauline

Thanks for the advice, i spent the best part of friday going through the transactions upto the 5th, i added the 848 which was outstanding but still couldnt get it to balance! I intended to have a look over the weekend but unfortunately i have slept the whole weekend, having caught some nasty bug cry.gif

I guess i will have another look Tuesday and repost on here what is still going wrong cry.gif

__________________


Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

I DID IT!!!!!

woop woop!

__________________


Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Hi Nicola,

Sorry to hear you weren't well cry.gif Glad you did it though! Well done!! All that sleep must have helped smile.gifsmile.gif

Pauline

__________________

Pauline



Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

Hi Pauline, it was really easy, quite embarressed i spent so long on it!

Onto my next problem, im trying to enter all the June stuff tomorrow so i can try and reconcile it..good luck to me!

I have what is probably a really stupid question...

A suspense account is where you post stuff while you are waiting to find out what its for right so if my directors take £100 out the bank and dont tell me what its for I journal it to there and then put it back when they tell me what it is right?

So my suspense account has £11k in since march 10 is that bad? does the balance need to be 0 for end of year or does it not matter?

__________________


Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

In a perfect world Suspense will be "0", as for whether £11k is bad - it would annoy me but I guess it depends on the level of turnover.

Hopefully there aren't too many transactions to get to the bottom of.

You're right in your treatment of £100, that's what I'd do.

__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.


Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

I think i'll leave that at the bottom of my to do list!


__________________


Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

I disagree. If a director has taken £100 out of the bank without any back up receipts I would put it to the Directors current account (cr bank dr directors current a/c) - if/when s/he produced receipts to cover the drawings, I would also post them to the directors account (cr directors current a/c dr expense nominal account).

Yes, ideally you shouldn't have anything in a suspense account.

-- Edited by semsley on Tuesday 31st of August 2010 10:01:44 PM

__________________

Advice from beyond the grave!!!

E&OE



Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

It's interesting the way peoples opinions differ.

If it was a common occurrence and you got the feeling the Director was treating the money as their own, I would absolutely follow Sheila's advice.

I've had some great conversations as to why watching late night movies while on a business trip abroad doesn't constitute a business expense biggrin

But as Nicola has stated it's a new role, I'd be more cautious to begin with.



-- Edited by ADAS on Tuesday 31st of August 2010 10:31:40 PM

__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.


Guru

Status: Offline
Posts: 1329
Date:
Permalink Closed

ADAS

That's the beauty of the site to discuss different ways of doing things. Makes life more interesting.

__________________

Advice from beyond the grave!!!

E&OE



Guru

Status: Offline
Posts: 882
Date:
Permalink Closed

I think it also depends on whether you are working for a company in accounts or as a freelance bookkeeper!

If working for a company in accounts, although they should respect your views and knowledge, what the Director says to do with something is what you should be following, so long as you have back up ie an email telling you to do something.

As a freelance, its your neck on the line.

P

__________________


Veteran Member

Status: Offline
Posts: 65
Date:
Permalink Closed

i work for the company, but they havn't directed me to do anything, i am just trying to follow the trail of the last bookkeeper

__________________
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