The Book-keepers Forum (BKF)

Post Info TOPIC: Sage Problem, can anyone help??


Newbie

Status: Offline
Posts: 3
Date:
Sage Problem, can anyone help??
Permalink Closed


Hi Guys,

 

Ok, so i have spoke to Sage support who have basically offered me no help whatsoever on this problem:

 

Sage 50 Accounts Plus 2012 Version

 

On the 1st May 2012 (start of new financial year) we decided to use this accounts package.

Followed the wizard step by step in entering all the balances.

First mistake was I entered a customer balance which had been written off in the previous year.

I then reversed my opening balances which included the customer balance that shouldn't have been there.

Then i put in the TB Figures given by external accountant from the previous year which obviously did NOT include the above customer balance.

So by this stage i got warnings stating my Sales Aged Balance disagrees with Debtor control by £50K

I then deleted the transaction which i originally shouldn't have posted via corrections.

Also adjusted all my opening balance dates as advised by Sage Support to 30.04.12, this was originally posted as 01.05.12

However the reversal figure is now different by £50K and i have no idea how to reduce this to the correct amount.

Sage have advised to put it into mispostings, however such a huge amount i would rather just find a way to get rid

 

If anyone can help, please advise

 

 



__________________


Member

Status: Offline
Posts: 19
Date:
Permalink Closed

Gosh you seem to have had a bad time of it.

Your best bet, when you had overstated your opening debtors would have been to post a batch credit note to that customer as a T9 entry and nominal code reserves.

Do not post journals to the debtors control as Sage does not like it and your Trial balance figure will not agree to aged debtors printouts

Have you checked your opening balance on reserves agrees to the accountants ?

If it doesn't agree , hopefully its out by the amount you're looking for ? :)

__________________


Newbie

Status: Offline
Posts: 3
Date:
Permalink Closed

Hi,

Ok so my opening balances total £73000 dated 30.04.12

My Opening balance reversal to Debtors Control totals £123000 dated 01.05.13

The difference is exactly the amount for the customer balance w/o of £50000





__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Did you post the opening balances on the sales ledger to a suspense account?

__________________


Newbie

Status: Offline
Posts: 3
Date:
Permalink Closed

Yes they went 9998. This was done just using the Opening Balances Wizard

__________________


Senior Member

Status: Offline
Posts: 280
Date:
Permalink Closed

Seems the more you try to fix it, the more you make a mess of it. You could clear out sage and start again with the opening balances. Go to file > Maintenance > rebuild data This will wipe everything you have done and give your a fresh start to enter in the opening balances. However as its goes back to May 2012, this is not an option, unless you wish to re do it all

Remember, when entering opening balances, all balances except the creditors and debtors can be entered via a journal, the difference in this journal can go to nominal code 9998. The opening balances for the debtors and creditors, ideally, would need to be entered as opening balances within the customer or supplier account area. This will then net off in code 9998 to nil, leave you will a detailed transactional opening balance for each customer and supplier account and make your TB balance.

Did you do the opening balance reversal to Debtors Control via journal or via the customers account?

I think you will need to check what the correct opening balance should be for all your nominals, then work out if each one in sage is correct. You may find that the difference is either in 9998 (although this should be noticeable as £50,000 is not a small amount) or, it could be that your reserves are incorrect and the £50,000 needs to be corrected in the Debtors Control and the Reserves nominal code.



__________________
www.merlionabs.co.uk
info@merlionabs.co.uk


Expert

Status: Offline
Posts: 2021
Date:
Permalink Closed

Per above, you could print out the nominal transaction activity (without opening balances) from the current year, and then start again, doing the rebuild, re-entering opening balances, and posting the total nominal movement in the current year.. OR Ultimately, just leave it for the accountant to fix

__________________
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