The Book-keepers Forum (BKF)

Post Info TOPIC: Help Needed with Journal Entry on Home Study Please.


Veteran Member

Status: Offline
Posts: 32
Date:
Help Needed with Journal Entry on Home Study Please.
Permalink Closed


Hi All, 

 

I could do with a little help please,

 

I'm doing a practice paper for my upcoming IAB level 3 exam and I've come across this to add as a journal entry and I can't seem to get it right at all and now I'm getting a very foggy head trying to suss it out, it would be great if anyone could show me an example of how they would write the journal entry down please, I've added screen shots of the question and info I have to do with the acquisition/disposal of a vehicle on 11 Jan 2016, Screen Shot 2018-01-30 at 20.09.46.png

 

 

I think you'll also need the info on the old vehicle cost & depreciation ? (This info is on the page previous in the question paper )

 

 

Screen Shot 2018-01-30 at 20.10.46.png

 

 

 

I can see from the audit trail in the answer book the journal entry on 11 Jan ( JV3 ) is £41,300 for it but I can't figure out how to do the journal to end up at that figure of £41,300 ?

 

 Screen Shot 2018-01-30 at 20.11.35.png

 

 

 

I've done a screenshot at my attempt at the journal but you'll see i've got to the £41,300 on the credit side and i've not even accounted for the £5,000 VAT on the new car or the £300 Vehicle tax, also Im not even sure if the vehicle tax should even be classed as prepayment or an accrual, presumably the double entry for which ever one of those it is (if either of them) is Motor expenses? I've got a feeling I've gone way off with my attempt & overcomplicated it?

 

 

fullsizeoutput_167d.jpeg

 

 

 

 

 

 

 

 

 

 

 

I'm annoyed with myself because I was doing OK on other examples of Disposal/Acqusition of assets but this one, I've lost it & i'm getting in a right tangle and last minute doubts now about the iniment exam, 

 

If I see the journal written down correctly I think I'll have a penny drop moment.

 

Thanks in advance for any help.

 



-- Edited by Martin S on Tuesday 30th of January 2018 08:49:25 PM



-- Edited by Martin S on Tuesday 30th of January 2018 10:31:37 PM

Attachments
__________________

Martin.

 



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Possibly not the best day to ask a question! wink



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Veteran Member

Status: Offline
Posts: 32
Date:
Permalink Closed

I know, I didn't think the timing through did I with me going round in circlesconfuse

hopefully when the SA dust settles somebody can helpthumbsup.gif

 

 



__________________

Martin.

 



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

I don't do tax returns; I'm just generally very busy with other stuff. :)

But...

Think the journal through in stages, separately, rather all in one - once you them down on paper, then and only then can you consider lumping it all together as a single journal. And try to attack those stages in a logical order. Using the details in the image, for example, you should probably thinking about the addition first, then the disposal, then the CC payment, then the loan agreement.

And don't attempt to build up values as the totals of others - the end result needs to be clear. In your journal, for example, the cost of the new vehicle would be shown as multiple figures that would need to be totted up. That lacks the clarity of a single entry for actual cost with details that state exactly what it is.

So, given that the vehicle cost £30,300 including VAT of £5,000 and vehicle tax of £300, think about the necessary lines of the journal for those items, as if that was all you were posting. The result will be an imbalanced journal, leading to the question "where did the funds come from?"

That's when you move onto the next stage. The first source is the disposal, so you need to think about and add the relevant lines for that. Take the cost and depreciation values from where they currently sit on the balance sheet, and think about where they need to go - along with the proceeds - so that you can show a profit or loss on the disposal of a motor vehicle. And don't forget where the VAT needs to be posted on that transaction.

Then you can add the credit card payment to the journal, appropriately worded.

Then the loan agreement - hint: if you've followed each step above (and got the numbers right) this SHOULD be a single line that balances the journal.


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Veteran Member

Status: Offline
Posts: 32
Date:
Permalink Closed

Hi Vince,

 

Thanks For your help, I've had another go at the Journal, does this look more like it should do you think?

 

Screen Shot 2018-01-31 at 19.37.42.png

 

 

I don't feel confident at all with getting this area correct yet.



Attachments
__________________

Martin.

 



Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

Well, at a quick glance that appears to put the right total amounts in the right accounts - £30,000 in vehicle costs for the new vehicle, £18,000 out for the old (and £10,500 out for the depreciation), and so on.

However - and bear in mind I'm not actually formally qualified, so I don't know what an examiner would think - one of my golden rules is for the end result to have clarity. I'd expect to be able to go into any one of those individual accounts and see figures that are meaningful. Consider if that was a real set of accounts you were working on, and you came back to look at these figures in six months, a year, two years later. Would they make sense?

For example, I'd expect to be able to go into "Motor Vehicles - Cost" and see:

1) An entry to remove the cost of the old vehicle - that'll be the credit of £18,500, worded such that I know it's the disposal of a vehicle (and which one if necessary). You have that (with as much detail as you've been provided), so fair enough.

2) An entry (singular) to show the cost of the new vehicle on the debit side - but you have "Part exchange on old vehicle" of £7,000 and "Balance new vehicle" of £18,000.

Similarly, I'd expect to go into "Profit & Loss on Asset Disposal" and see three lines: Firstly, the proceeds from the disposal, on the credit side, and secondly its net book value on the debit side. Instead you have a single line, "Loss on Disposal of Old Vehicle" which (in effect) doesn't show its working.

If you look back at what I said, I suggested a logical order - which if you go back to the original question, is the order the information is given. If you follow it through, you should get not just the right results, but meaningful ones.

Think of the individual parts of the question separately first. The first part says:

"Purchased a new vehicle for £30,300.00. This included VAT of £5,000.00 and £300 for vehicle tax for the first year to 31 December 2016."

So that's three debits to think about, which I'll give you - the net cost of the vehicle, the VAT, and the vehicle tax:

0050 - Motor Vehicles Cost - Purchase of new vehicle - DR £25,000.00
2201 - VAT on Purchases - Purchase of new vehicle - DR £5,000.00
7300 - Motor Expenses - Vehicle tax to 31/12/2016 - DR £300.00

Those should be your first three lines.

You then add the lines for the next part of the question: £7,000 plus VAT given for the old vehicle in PX - one line for the £7,000 net proceeds (to the P&L disposals account), and one line for the VAT.

Then add the lines to complete the disposal part - as you've done, credit the cost value and aggregate depreciation to the cost and depreciation accounts - and the net of the two goes to the P&L disposals account. (This isn't breaking the sequence of the question - it's handling the disposal).

The next part of the question is the credit card payment, so add the necessary lines for that.

And finally, the loan.


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Veteran Member

Status: Offline
Posts: 32
Date:
Permalink Closed

Thanks again for your answers, can I just make sure I'm understanding that part right, 

2) An entry (singular) to show the cost of the new vehicle on the debit side - but you have "Part exchange on old vehicle" of £7,000 and "Balance new vehicle" of £18,000.

Instead of those 2 entries I would be better going in with just the one entry of the 2 amounts together? - Purchases of new vehicle DR £25,000.00



-- Edited by Martin S on Wednesday 31st of January 2018 10:16:02 PM

__________________

Martin.

 



Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Ive not read everything, sorry, can't see it all too well as I've lost my glasses! A suggestion....forget sage for now.

Draw up your t accounts for each of the items individually, then write out the list of debits and credits. Will take a look once I've found my glasses.

__________________

 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



Veteran Member

Status: Offline
Posts: 32
Date:
Permalink Closed

Hi Joanne, 

 

I did hand write it first before putting it into sage but didn't post that because of my crap handwriting, and also because the exam is computerised so all on sage

 

This is my hand attempt

 

Screen Shot 2018-01-31 at 22.36.23.png

 



Attachments
__________________

Martin.

 

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