VAT question for other CDCs

Discussion in 'Cambridge Weight Plan' started by Coley, 24 October 2006 Social URL.

  1. Coley

    Coley Re-starter

    Posts:
    2,214
    Likes Received:
    111
    Start Weight:
    13st9lb
    Current Weight:
    11st5lb
    Goal Weight:
    10st0lb
    Lost(%):
    2st4lb(16.75%)
    Diet:
    Cambridge
    Hi there, I am doing my accounts as I am looking at the VAT. In the automatic spreadsheet the formula is for example: =IF(H13="y",G13*7/47,0) and if you put in your values you don't get VAT at 17.5%, it's actually way under so now all my accounts are wrong and I don't know how to do this formula with the correct values.

    Any ideas? I can do it manually (0.175 x the value of the goods) to find the VAT which is how I know but I don't want to do that all the time!! HELP!!:confused:
     
  2. Avatar

    MiniMins.com Matched Content

  3. MandyB2

    MandyB2 Moderator/CD Counsellor

    Posts:
    1,931
    Likes Received:
    68
    Are you earning enough to be VAT registered hun??... if not you don't need to worry about breaking down the figures...

    xxx:)
     
  4. Coley

    Coley Re-starter

    Posts:
    2,214
    Likes Received:
    111
    Start Weight:
    13st9lb
    Current Weight:
    11st5lb
    Goal Weight:
    10st0lb
    Lost(%):
    2st4lb(16.75%)
    Diet:
    Cambridge
    nah....but I'm just looking at the VAT when I'm doing the accounts using the spreadsheet we get with the business pack on the CD. Cause we get some of the VAT back don't we?:confused: plus I hate it when things are wrong......grrrrrr
     
  5. MandyB2

    MandyB2 Moderator/CD Counsellor

    Posts:
    1,931
    Likes Received:
    68
    .. I don't think you will get any VAT back if your not registered hun...I've been self employed for 4 years and am not yet VAT registered... unless you are, and pay the VAT you receive to the tax man you can't claim any that you've paid back !!!
    Sucks eh???.. I'm not an expert though.. so I'd check it out with IR or an accountant..

    xxxx:)
     
  6. Coley

    Coley Re-starter

    Posts:
    2,214
    Likes Received:
    111
    Start Weight:
    13st9lb
    Current Weight:
    11st5lb
    Goal Weight:
    10st0lb
    Lost(%):
    2st4lb(16.75%)
    Diet:
    Cambridge
    Hrm....maybe I'm getting confused between VAT and tax.....:rolleyes:? It's still wrong though!!!!:mad::mad::mad::mad:
     
  7. MandyB2

    MandyB2 Moderator/CD Counsellor

    Posts:
    1,931
    Likes Received:
    68
    Yeh.. I know what you mean hun.... accounts are a minefield:eek::eek:... I've not checked out the CD spreadsheet though.. I prefer to do my own....
    Maybe someone else uses it and can enlighten the both of us??

    xxxx:):D
     
  8. DQ

    DQ Queen of the Damned

    Posts:
    23,285
    Likes Received:
    588
    Sorry, I use my own as at present I don't earn enough to be VAT registered :(
     
  9. Isobel1965

    Isobel1965 Gold Member

    Posts:
    8,051
    Likes Received:
    209
    I think you have to earn 55K in order to be VAT registered, don't you???????

    Doh - I don't 'do' sums!!!!!!!!!!!
     
  10. Coley

    Coley Re-starter

    Posts:
    2,214
    Likes Received:
    111
    Start Weight:
    13st9lb
    Current Weight:
    11st5lb
    Goal Weight:
    10st0lb
    Lost(%):
    2st4lb(16.75%)
    Diet:
    Cambridge
    yeah, you have to be taking in a fortune, but this is just for my own records.......and it's wwwrong!!! aaaaaargh!! Why can't Cambridge count?
     
  11. Isobel1965

    Isobel1965 Gold Member

    Posts:
    8,051
    Likes Received:
    209
    I bet they count better than I do - just ask my clients lol!
     
  12. Coley

    Coley Re-starter

    Posts:
    2,214
    Likes Received:
    111
    Start Weight:
    13st9lb
    Current Weight:
    11st5lb
    Goal Weight:
    10st0lb
    Lost(%):
    2st4lb(16.75%)
    Diet:
    Cambridge
    Have just changed the formula to =IF(H13="y",G13*0.175,0) and so the VAT works out now to what it says on my invoices....just have to change it on each months spreadsheet now......:)

    I don't 'do' sums either, just hate it when it's wrong!! I am so bad with counting as well....you should see me trying to keep track of how many rations a client has picked....and forever asking, "how many of that one again?":rolleyes:
     
  13. Isobel1965

    Isobel1965 Gold Member

    Posts:
    8,051
    Likes Received:
    209
  14. htpink

    htpink CDC

    Posts:
    722
    Likes Received:
    29
    I keep all mine in a database - otherwise stock control would be a nightmare!!
     
  15. DQ

    DQ Queen of the Damned

    Posts:
    23,285
    Likes Received:
    588
    My stock control is a basic spreadsheet - I'm teaching my girls to use it so they can help me out! :cool:
     
  16. Isobel1965

    Isobel1965 Gold Member

    Posts:
    8,051
    Likes Received:
    209
    Erm...stock control.....spreadsheet??? Now I'm really depressed lol!
     
  17. Coley

    Coley Re-starter

    Posts:
    2,214
    Likes Received:
    111
    Start Weight:
    13st9lb
    Current Weight:
    11st5lb
    Goal Weight:
    10st0lb
    Lost(%):
    2st4lb(16.75%)
    Diet:
    Cambridge
    Yeah...I just use the one that came with the business pack...been merrily doing my accounts.....until now....flippin' VAT. Have changed all my spreadsheets now...of course it makes no difference to the final amounts, I'm just a fuss pot and want my VAT to be right and not look like a dip stick when some maths whizz points it out that I hadn't calculated VAT correctly!

    Hrm....who do I email at CD to get them to fix the CD's they give out? :)
     
  18. DQ

    DQ Queen of the Damned

    Posts:
    23,285
    Likes Received:
    588
    Lol, it's just a list of flavours and as clients order stuff I miunus it :)
     
  19. Isobel1965

    Isobel1965 Gold Member

    Posts:
    8,051
    Likes Received:
    209
    Ah well - that's still very organised.......I kind of just use the "Force" LMTO!!
     
  20. DQ

    DQ Queen of the Damned

    Posts:
    23,285
    Likes Received:
    588
    ROFPMSL!!!! :D :D
     
  21. Coley

    Coley Re-starter

    Posts:
    2,214
    Likes Received:
    111
    Start Weight:
    13st9lb
    Current Weight:
    11st5lb
    Goal Weight:
    10st0lb
    Lost(%):
    2st4lb(16.75%)
    Diet:
    Cambridge
    Ooooooough....so am I just being totally anal here? I do a reciept form for every client, everytime, but I keep it and number it, and put it in the funny spreadsheet thingie......thought we had to do it for self assessment tax return or something uber important?:confused:
     
Popular Forums
  1. MiniMins.com is a weight loss support community helping each other on their weight loss journey. We have a multitude of forums, from Slimming World and Exante, to Success Stories. Click the logo at the top right to return to the forum home page at any time.
Loading...