The Book-keepers Forum (BKF)

Post Info TOPIC: Sage Accounts Professional - Reversing Incorrect Opening Bank Balances?


Member

Status: Offline
Posts: 15
Date:
Sage Accounts Professional - Reversing Incorrect Opening Bank Balances?
Permalink Closed


Hi,

The owner's original plan was just to start using Sage 01-Dec, so we started with bank account O/Bs from 30-Nov.

Then the owner decided to drop the entire year into Sage, so we need to post the entire year's transactions.

Will Sage "know" that transactions prior to 01-Dec are before the not-so-"opening" balances, and adjust accordingly?

Or do I need to correct the O/Bs for the three bank accounts?

If I need to correct them, can I simply enter a journal to credit the O/B amounts originally entered (and debit the suspense account, where the other side is still sitting)?

Thanks all,

Kate



__________________
-Kate


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Kate
Welcome to the forum.

Once you have keyed all the opening balances you should have nothing in the suspense account, which leads me to presume that perhaps you havent got too far with this exercise. This being the case - a couple of questions - when was their year end? Why does he want the whole year putting in? Just thinking that he may be paying a lot in your fee for no gain, so it could be a way of 'persuading' him that this exercise would be pointless. What software was he using before and can he still access the information once you move to Sage?

How much of the keying have you done? If it really isnt much I would suggest you just re-set Sage and start again.

Dont forget to take regular backups as your progress this exercise so you can restore easily in the event of any mistakes.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Hi, and thanks for the fast reply.

The owners did literally no bookkeeping for the entire year. They kept thinking the bookkeeper would do it, but then just didn't get around to getting a bookkeeper.

We intentionally left the O/B amounts in suspense because we needed to piece together what was contributed by which owner.

We have also keyed in about 600 transactions over the last couple of weeks, so I really don't see re-setting and starting over.

Can I just create a journal reversing the O/B amounts in the bank accounts and suspense accounts?

Or will Sage basically "work backwards" from the 30-Nov O/B as earlier transactions are entered?

Thank you!

 



__________________
-Kate


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Kate
Reckon thats a good enough reason! You would need to reverse out the incorrect opening balance via journal and then re-enter the correct figures.

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Member

Status: Offline
Posts: 15
Date:
Permalink Closed

Thank you Joanne!

And thank you for answering so quickly - shouldn't you be off someplace enjoying a holiday?

Take care!



__________________
-Kate
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