Recent content by ch4580

  1. C

    VAT template for Excel?

    Menu -> Insert -> Object -> Microsoft excel worksheet though i'm not totally sure how it'd work... i'm thinking a worksheet that you enter quantity, description, price, and calculate subtotal on, and at the bottom, a cell with a sum of the subtotals, and the VAT figure
  2. C

    VAT template for Excel?

    And, sorry Pete, I've realised you were asking about an Invoice template, not a RETURN template (I've got these things on my mind just now)... I always use Word/Pages... Excel can print out a bit funny, and certainly not look as good as it might in Word... I think you can import Excel Cells...
  3. C

    VAT template for Excel?

    Hi Tom, Gonna be a 'problem man' or a 'solutions man' ???? ???? try this... if you use e.g this formula, you'll get your results... =ROUNDUP(SUM((B70/117.5)*17.5), 2) ROUND will apply normal rounding rules.... (e.g 1.005 = 1.01, 1.00499999 = 1.00) ROUNDUP obviously up to the...
  4. C

    Confused about VAT.....Help!

    Again, as above, I'm not sure how this applies to vending machines... but basically, VAT registration SHOULD help you out, so long as you're prepared to do the work.... since EVERYTHING that you pay VAT on, that you have to use, can be reclaimed... so, in this case, (working on vat...
  5. C

    VAT template for Excel?

    Hi, I'm just working on a template now... let me know if you want me to send it to you when I'm done. (ch4580 at mac.com) what fields would be helpful, just incase I'm unaware of some... if you need some formulas to get you by.... VAT from subtotal =SUM(<cellnumber>*17.5) Total...
See more
Top Bottom
Community
Articles
Menu