The Book-keepers Forum (BKF)

Post Info TOPIC: Sage Exam


Member

Status: Offline
Posts: 8
Date:
Sage Exam
Permalink Closed


Hi everybody,

Before I ask my question I'd just like to say how helpful I have found your forum in the past and thanks in advance for any help offered regarding my current dilemma.  aww

I have just completed a Level 2 computerised exam on Sage.  Opening balances of £3000 Accruals needed reversing to Accountancy - I'd not covered this in the course so after extensive research online and off I decided that I would post the journal Dr £3000 Accruals and Cr £3000 Accountancy.  I was confident about this and continued to work my way through the rest of the paper until I finally had to print off P&L and B/Sheet reports - thats where the confusion has started.  no 

In my list of overheads the reversal has shown up as a bracketed figure and is also bracketed on the balance sheet under short term creditors.  I cant make sense of this in my head at all and now I'm not sure if my original transaction was correct.  Would somebody explain to me in simple terms what the software has done - the trial balance now shows Cr Accountancy £3000 which is I think is correct.  hmm

Hope the above makes sense - thanks again   



__________________


Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Hi Karen,

Your original journal was correct. To reverse accrual journals you DR Accruals and CR whatever expense account was originally debited (in your case Accountancy). If you ran the P&L for just the month that you did the reversal then Sage shows the movement on the Accountancy account for that month, which in this case was CR 3000, hence the figure is in brackets. And when you run the BS for just the one month then the movement on the Accruals account is showing, in this case DR 3000 (and because this is a debit entry in a liability account which is usually in credit, again the figure will be in brackets). If you run the reports over the two months then these figures will cancel each other out and neither will appear.

HTH
Pauline

__________________

Pauline



Member

Status: Offline
Posts: 8
Date:
Permalink Closed

Hi Pauline,

Thanks a lot for taking the time to reply.

It's much clearer in my head this evening - the difficulty I seem to be having is translating what I know about manual bookkeeping in to what the software is doing - honestly, my head has been ready to explode.

I'm still a bit confused about something though. The original Trial Balance I was given showed Dr Accruals £3000 - but there was not a O/Bal for Accountancy. On entering the reversal - The T/B now shows a credit balance in Accountancy for £3000, and thinking through it manually doesn't that mean that when the invoice for £3000 finally arrives I'll end up with a cr Accountancy balance of £6000?

As I've explained, my head has been so full of debits and credits that I'm probably missing something very simple - but any light you can throw on this would be great.

For the record - I posted my exam off this morning - so fingers crossed!

Thanks again.

Karen

__________________


Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

Hi Karen

I don't understand how an opening Accrual can be a Dr, it's a liability of the company.

The O/bal you're expecting to be in Accountancy would probably be in Retained Earnigs. The p&l account on day 1 of the new year would be zero.



-- Edited by ADAS on Wednesday 6th of April 2011 10:29:09 PM

__________________
Tony

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


Member

Status: Offline
Posts: 8
Date:
Permalink Closed

Thanks Tony -

Of course you are correct - the opening Accruals balance was Cr and not Dr - frazzled brain!

I did wonder about retained earnings what about the TB cr balance now in Accountancy

On another note - does anybody have any good ideas on how to switch your brain off when it just won't stop!  I've had this problem before when I physically know thinking about a problem cant do any more good but I keep going over and over it. 

Thanks in advance - Karen



__________________


Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

There's two methods really.

Method 1:

Dr Accruals
Cr Accountancy

on day 1 on new year, leaving the credit you have.

Then when the invoice is received from the Accountant

Dr Accountancy
Cr Trade Creditors

If the invoice is for last years accounts, this contra's your credit.

Method 2:

Post the opening TB "as is" with the opening credit on the accruals account

When the invoice is received from the accountant

Dr Accruals
Cr Trade Creditors

Therefore accruals account is zero.

Btw - wasn't trying to be clever with the Dr query, I thought there might have been a trick in the question ;)



__________________
Tony

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


Member

Status: Offline
Posts: 8
Date:
Permalink Closed

It didn't enter my head that you were trying to be clever.

I'm really grateful for your detailed response - the penny has finally dropped - thanks a lot Tony biggrin



__________________


Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Sorry, I got left behind...went off to watch something on tele at 9! smile.gif Glad you are sorted now though!

Pauline

__________________

Pauline

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