The Book-keepers Forum (BKF)

Post Info TOPIC: ICB LEVEL 1 HELP REQUIRED


Senior Member

Status: Offline
Posts: 153
Date:
ICB LEVEL 1 HELP REQUIRED
Permalink Closed


Hi folks

I hope I am posting this enquiry in the right section of the forum!  If not, can you please advice which section it so go under.

Anyway, I have recently started the above course and in order to further undertstand the concept of posting entires, can somebody please answer the following questions -

1. When sending payment to a supplier by chq (for example), do you have to calculate the VAT element of the total payment and post this VAT figure in the VAT account?  If so, doesn't that mean the VAT has been entered twice?

2. When there is money coming in from a debtor, does it need to be entered in the DR side of the cash/bank book AND the CR side of the debtors account?  Does anything need to be entered in the VAT account.

3. When generating a sales invoice, does the total figure go in the DR side of the debtors account AND the CR side of the sales ledger account.  I presume you also need to calculate the VAT element of this total amount and enter it in the VAT account?  If so, doesn't that mean that the VAT has been entered twice?


Thanks in advance for your response.




__________________


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

1. When sending payment to a supplier by chq (for example), do you have to calculate the VAT element of the total payment and post this VAT figure in the VAT account? If so, doesn't that mean the VAT has been entered twice?

I'm assuming that this is on a credit basis, you will have already entered and analysed the invoice to your expense account (net) and VAT account (vat element), at that point you are assuming payment has been made or will be made and therefore you wont have to re-enter anything in either of these account when you make payment.

2. When there is money coming in from a debtor, does it need to be entered in the DR side of the cash/bank book AND the CR side of the debtors account? Does anything need to be entered in the VAT account.

Just need to as you say Debit bank Credit debtors control and subsiduary, again nothing needs to be entered in the VAT account. The only time you will enter anything in the VAT control is when you enter an invoice or when you pay the VAT people.

3. When generating a sales invoice, does the total figure go in the DR side of the debtors account AND the CR side of the sales ledger account. I presume you also need to calculate the VAT element of this total amount and enter it in the VAT account? If so, doesn't that mean that the VAT has been entered twice?

Gross amount in debtors control and subsiduary on the Debit side and credit the sales account (net) and vat account (vat element)
A quick point there is a Sales account and a Sales ledger (subsiduary sales ledger) the two are seperate from each other, Sales account is in the main ledger Sales ledger as the name suggests is a seperate ledger purely for the purpose of keeping track of individual accounts, it's only connection to the main ledger is through the control account which is a summary of the sales ledger.

__________________
Steve


Senior Member

Status: Offline
Posts: 153
Date:
Permalink Closed

Hi Rhianrach

Many thanks indeed for your reply.

Just to clarify point 3 again -

3. When generating a sales invoice, does the total figure go in the DR side of the debtors account AND the CR side of the sales ledger account. I presume you also need to calculate the VAT element of this total amount and enter it in the VAT account? If so, doesn't that mean that the VAT has been entered twice?

Do you mean that the net value of the inv goes in the sales a/c, the gross value goes in the debtors a/c, and the vat element goes in the vat a/c?

Could you also be kind enough to clarify the following -

1. At what point in time do I need to make an entry in the vat account?
2. When making/receiving payments from supplier/customer, do any entries need to be made in the vat a/c?
3. When a payment is made, for example, phone bill, does the vat need to be calculated and entered in the vat a/c?  What figure goes in the bank and mobile phone a/c - the gross or the net figure?
4. If a customer pays for goods by cash, apart from the cash book, where would the other entry be made?
5. With regards to debit/credit notes, does the vat element need to be calculated and entered in the vat a/c?  If so, I presume the net figure would be entered in the goods received/returned a/c and the double entry to it in the debtors/credits a/c?

Many Thanks in advance for your response.


__________________


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

1. At what point in time do I need to make an entry in the vat account?

When you input the invoice sales or purchase, take a purchase invoice for example, you recieve it, match it, then enter it into the system, so you would credit the gross amount to credoitors control account and the other side of the double entry would be a debit to expense account (whatever the expense relates to ) and also debit the VAT account which in a simple syatem would be a control account. This would be your double entry in simple terms. So in answer to the question you would make an entry into the vat account when inputting the invoice, unless you are using a cash accounting system then you wouldn't enter anything till you pay the invoice in which case you would enter it all at the same time, just to confuse matters.

2. When making/receiving payments from supplier/customer, do any entries need to be made in the vat a/c?

No the VAT will of already been accounted for and entered into the system, unless of course as above you are using cash accoutning rather than accrual.

3. When a payment is made, for example, phone bill, does the vat need to be calculated and entered in the vat a/c? What figure goes in the bank and mobile phone a/c - the gross or the net figure?

If you have an account setup for phone service provider and they have invoiced you then you will have most likely already entered the invoice into the system including the vat.
EG phone bill £10.00 invoice already in system you would credit bank £10.00 and debit creditors control account to reduce the balance, the vat will of already been accounted for when the invoice was inputted earlier. In answer to your question it will be the gross figure in the creditors control and the bank.

4. If a customer pays for goods by cash, apart from the cash book, where would the other entry be made?

Assuming you are running the business properly you would enter it into the bank account, so debit bank credit sales credit vat unless you are using (as some do) the cash book as part of the main ledger then the debit side will of been taken care of and the analysis (sales and vat)
will need entering in the main ledger or if a sole trader it could go in the owners pocket smile which means you would credit sales as above and debit drawings.

5. With regards to debit/credit notes, does the vat element need to be calculated and entered in the vat a/c?  If so, I presume the net figure would be entered in the goods received/returned a/c and the double entry to it in the debtors/credits a/c?

Yes a credit note either way from yourselves or to yourselves would need entering thusly.
If you recieve a credit note from a supplier then it would be Debit purchase(creditors) control account (Gross) (treat as a payment would be an easy way to remember) and a credit to purchase returns account (net) and a credit to the vat control account (vat element).

I don't know where your up to in your studies but good luck and don't hesitate to ask more questions we are all here to help (a bit quiet tonight though).
Don't worry it all becomes crystal clear after a while, and once it does things start to become a lot easier to get your head round. The understanding of how the double entry system works is in my opinion the biggest hurdle, stick with it and you could be bankrupting the country in years to come (if your good enough that is). wink


-- Edited by Rhianrach on Wednesday 2nd of June 2010 08:16:55 PM

-- Edited by Rhianrach on Wednesday 2nd of June 2010 08:20:11 PM

__________________
Steve


Senior Member

Status: Offline
Posts: 153
Date:
Permalink Closed

Hi

Many thanks indeed for your help.

Have you also done this course or have you done a higher qualification?

The reason I am asking is that I am planning to do the AAT after this book keeping course. Is that the natural progression?

Thanks

__________________


Senior Member

Status: Offline
Posts: 153
Date:
Permalink Closed

Hi

I'm terribly sorry, but I just have 2 more questions -

1. When entering a sales/purchase invoice, does the net value go in the sales/purchase ledger and gross value in the debtors/credits account? If so, then obviously the vat element goes in the vat a/c?

2. I have an assignment question where a sole trader gives 30 days credit to his business customers and only excepts cash payments from other (smaller) customers. When he receives a cash payment, does the total payment go in the DR side of the cash book? What about the other part of the double entry. Where should I put that? From the sense of the question, there are no sales invoices generated for cash payments! Do I have to extract the vat element and put it in the vat a/c?

Again, many thanks for your response.

__________________


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

geek84 wrote:

Hi

Many thanks indeed for your help.

Have you also done this course or have you done a higher qualification?

The reason I am asking is that I am planning to do the AAT after this book keeping course. Is that the natural progression?

Thanks



No I've gone down the AAT route almost completed foundation.

In reality you would be better switching to AAT as soon as possible but thats just an opinion.



-- Edited by Rhianrach on Thursday 3rd of June 2010 11:50:25 AM

__________________
Steve


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

1. When entering a sales/purchase invoice, does the net value go in the sales/purchase ledger and gross value in the debtors/credits account? If so, then obviously the vat element goes in the vat a/c?

Firstly it would be a good idea to differentiate between sales/purchase ledger and sales/purchase account.
Typically an invoice would be entered into the sales/purchase ledger which is a completely seperate entity to the main ledger, its sole purpose is to keep track of individual accounts.
In manual accounting this would be a seperate book or ledger. It is very important that you don't confuse the 2 albeit they are very similar sounding.
The balances of all the accounts within the sales/purchase ledger would be totalled and entered in the sales/purchase control account which resides in the main ledger and its purpose is to give an overview of what money you are owed and need to pay out.
So when entering an invoice lets say a purchase invoice, typically you would have the gross on the credit side (as they are creditors) of the purchase ledger control account and the other side of the double entry would be the net value to the debit side of the purchases account (not ledger be wary of the difference) and the vat element to the debit side of the vat control account.
That in effect completes the double entry but it is also good practice to keep track of individual accounts which is where your sales/purchase ledger comes in, a seperate book or ledger entirely and you would enter the gross amount (net plus vat) to the credit side of the individual account.

As said above its important to differentiate between terms such as ledgers and accounts, accounts reside in ledgers, the double entry for an invoice involving vat is gross to one side net and vat to the other, job done, sales/purchase ledgers are a seperate thing.

The reason I repeat this is because there are still people on my course who are still at this late stage getting confused due to the inability to tell these apart. smile


__________________
Steve


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

2. I have an assignment question where a sole trader gives 30 days credit to his business customers and only excepts cash payments from other (smaller) customers. When he receives a cash payment, does the total payment go in the DR side of the cash book? What about the other part of the double entry. Where should I put that? From the sense of the question, there are no sales invoices generated for cash payments! Do I have to extract the vat element and put it in the vat a/c?


Yes it would be something like £50 would go on the debit side (being the total value of the invoice) then it would be analysed on the credit side to (in simple terms) sales column £42.51 (net) and £7.49 vat column.
Assuming that the cash book is part of the main ledger you would then enter the credit side only into your main ledger in both the sales account and the vat account, if however your cash book is not part of the main ledger then you would also enter the gross amount as a debit to your bank account or as said further up if the owner wants to spend the money at the pub or wherever basically take it as his/her own then you rather than debit bank account you would debit the drawings account. smile


__________________
Steve


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Steve, Majinder

just read this thread.

Well Steve, you should be awarded the ICB level 1 for this.

Majinder,

If your having difficulties at this level you may be better going back and working fro the start again but using different books.

Try the AAT units 1-4 revision companion and work through that for the Unit's 1-3 only.

I fear that Steve may be helping a little too much on this which in the long run will not help you understand bookkeeping fundamentals (although it's really good revision for Steve).

Not trying to put you off asking questions but it does seem from the number in this thread that you are having quite fundamental bookkeeping problems at the lowest level of of the ICB qualification so it may be better for you to slow down and go back tot he start of your studies and work through again.

Often at second or third viewing everything starts to drop into place and it's only really by struggling through some of the questions that you really get to understand things.

Wishing you all the best in your studies,

Shaun.



__________________

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.



Senior Member

Status: Offline
Posts: 153
Date:
Permalink Closed

Many, many thanks for your help, Steve.

However, I think it would also be a good idea if I go through the work book again as suggested by Shaun.

Once again many thanks for your help.



__________________


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

It's a good point by Shaun mainly because if you don't have a very good understanding at this level of how everything works then you will trully struggle later on when they make the assumption that you are comfortable with the double entry system and all its ins and outs.
As I said there are people still struggling with the whole concept of accounts, ledgers, books of prime entry and double entry at the end of AAT foundation and the tutor is not recomending they go on to the next level, as it assumes a level of understanding.

Thanks Shaun I just wish interviews were like this I'd have a job in no time biggrin


__________________
Steve


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

Hi Steve,

I think that when you do interviews maybe you should refer them back to your assistance on this site. Perhaps with a few specific examples such as this thread.

Regardless of where you are with AAT your assistance with queries such as this one is second to non.

Certainly if I were hiring I would have no qualms at all about taking you on.

What's happened about the Access interview? Has that one happened yet?

__________________

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.



Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

Shamus wrote:

Hi Steve,

I think that when you do interviews maybe you should refer them back to your assistance on this site. Perhaps with a few specific examples such as this thread.

Regardless of where you are with AAT your assistance with queries such as this one is second to non.

Certainly if I were hiring I would have no qualms at all about taking you on.

What's happened about the Access interview? Has that one happened yet?



The access interview changed roles from a supervisor needing all that to an assistant needing just this, so I got a phone call telling me I'm over qualified blah blah which I followed up with an e-mither stating that I look for jobs that are more locality and relative security based blah blah so upshot being I'm waiting to hear back.
As it turns out I got a gooooood job offer today which I have accepted and have another interview tomorrow that I will attend and do some playing off.
All of this is because I categorically stated "You do know who I am don't you, have a look on http://www.book-keepers.org.uk at Shamus that is me". evileye



 



__________________
Steve


Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:
Permalink Closed

OMG. Identity theft on the site!... I'd be careful whose identity you steal though as (as you know) someone was threatening to sue me for deformation the other day!

Don't believe that they would have got anywhere but just to be careful I removed my last name and date of birth from my profile!

Excellent news on the job offer matey. Don't abandon us though will you otherwise I might have to start answering techie questions myself!




__________________

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.



Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

Hmmm I'll be honest she asked me to do a dance and I declined,........... I think that was a good decision.

I wont abandon this forum, the job involves short hours (for parents with kids at school) and high wages (which is why I'm surprised I got it but hey you never know what to expect in an interview, they seemed more focused on the person fitting into their team than capabilities and I was already capable) so I still have time to post..... yay.

Deformation of character is a difficult and costly lawsuit to follow, I really wouldn't be concerned seeing as you haven't actually deformed anyones character. wink


__________________
Steve


Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

Rhianrach wrote:



Deformation of character is a difficult and costly lawsuit to follow,


Is this an "in" joke. How do you go about deforming someone's character?

 



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/



Senior Member

Status: Offline
Posts: 153
Date:
Permalink Closed

Hi Folks

Many thanks for your help so far.

My situatuon is as follows -

As you may be aware, I have started doing the ICB book keeping course. I am on level 1 and have gone through the allocated work book. I have done all the exercises in the book and checked against the answer book - I got them all correct!

I then contacted the learning provider - 'Training Link', to tell them this, and they said I now need to take a mock exam, on the computer, (in preparation for the real exam) for this level (level 1). However, they have said that I am at a stage where they cannot offer me any help wirth any of the questions. I have gone through this whole mock exam paper and cannot get the trial balance to balance. I have been told that they are not willing to check my answers until I get to balance the trial balance. I have been racking my brains over this for the last few days. I have also amended a few entries in accordance with the help given above by a few people, and I have gone through the work book several times to make sure I have posted my entries correctly. However, I still cannot get the figures to balance!

What do you suggest I do? Do you think I should get a professional book keeper to give me one to one tuition and explain to me where I am going wrong in posting my entries?

Thanks in advance for any advice

__________________


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

See your other post hmm


__________________
Steve


Senior Member

Status: Offline
Posts: 153
Date:
Permalink Closed

Hi Folks

Regarding the above, where I am getting stuck on a particular question, one or two of you have suggested that I should post my trial balance here so that you guys can point me in the right direction of where I am going wrong.

According to me, getting the trial balance is the easy bit (I think), once all the postings are made to the correct ledgers (the hard bit). It is the posting of the entries that I am getting stuck on - I am not sure that I have posted some of the entries to the correct ledgers!!
As a result of this, the error is filtering down to the trial balance stage.

What do you think I should do? Do you think I should post the entire question on this forum, so that you folks can point me in the right direction without giving me the answer?

Thanks


__________________


Senior Member

Status: Offline
Posts: 153
Date:
Permalink Closed

Hi Folks

As you may already know from my previous posts, I am doing the ICB Level 1 and I am on the mock exam stage. I still cannot get the trial balance to balance. The difference is £153.82. I have spent hours going over it again & again, but still cannot spot where I have gone wrong.

The assignment is about a mobile car valeting service. Have any of you don that? If so, can you give me any hints (without giving the answer), as to where I could have gone wrong?


By the way, the reason why I have been absent from this forum for a while is because I have started the AAT course (as suggested by a few members here!). I am also thinking that I might as well finish off this book keeping course since I have already paid for it - well at least I have agreed to pay it by instalments !!


Thanks in advance for your reply.

__________________


Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

Hi,

have a look at this topic:

http://www.book-keepers.org.uk/index.spark?aBID=106474&p=3&topicID=32058565&page=1



__________________

Attila



Senior Member

Status: Offline
Posts: 153
Date:
Permalink Closed

Hi

I have already looked at the the thread above before posting my query. I still cannot spot the error!

Any help would be greatly appreaciated.

__________________


Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

I posted step by step clues on the topic above with info on what transaction you have to post where and what your balance should be and how many items you should have on your trial balance. If you cannot spot the error after those, you have to do it again from the beginning I suppose.
If you still cannot get it right you will have to send it off to your training provider with the mistake, if you haven't got a training provider you should have the answers for the mock so you can check what went wrong...
Apart from step by step instructions posted on the other thread I don't really know how else I could help, especially without seeing your trial balance and ledgers.

__________________

Attila



Member

Status: Offline
Posts: 13
Date:
Permalink Closed

If the mock is for Lee Crescent car valeting - the balance on the TB is £25,007.28 - that might help you a bit.

I had the same problem (not on this one) I just went back to the beginning and started again.

__________________
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