Capital gains tax calculator

Just wondering if anyone knows of any good CGT calculator's. I have multiple transactions for multiple shares that I would like to plug into a single spreadsheet, if possible, to calculate if any CGT is due. Any decent calculators out there?

thanks

Comments

  • Tom99
    Tom99 Posts: 5,371 Forumite
    1,000 Posts Second Anniversary
    List each disposal on a separate line (A: sale price, B: less costs of disposal, C: less acquisition price, D: less costs of acquisition = E: profit/loss) in a spreadsheet and add a total at the bottom.
    What more do you need?
  • System
    System Posts: 178,302 Community Admin
    10,000 Posts Photogenic Name Dropper
    By the time you have entered all the data in a spreadsheet you could have worked it out with one of these:
    https://www.amazon.co.uk/Casio-MX-8B-Desk-Top-Calculator/dp/B0006L25FQ/
    This is a system account and does not represent a real person. To contact the Forum Team email forumteam@moneysavingexpert.com
  • colb15
    colb15 Posts: 52 Forumite
    Seventh Anniversary 10 Posts
    There's multiple buys and sells at different dates for the same security. Hence getting the average price is not that easy
  • Tom99
    Tom99 Posts: 5,371 Forumite
    1,000 Posts Second Anniversary
    colb15 wrote: »
    There's multiple buys and sells at different dates for the same security. Hence getting the average price is not that easy
    Did you sell any of these 'same shares/fund' in the 30 days after your last acquisition of these shares?
  • colb15
    colb15 Posts: 52 Forumite
    Seventh Anniversary 10 Posts
    Tom99 wrote: »
    Did you sell any of these 'same shares/fund' in the 30 days after your last acquisition of these shares?

    Yes there are a few trades that fall into that bracket, sale price was lower than purchase price, in any case aware of the 'bed and breakfasting' rule that would impact those.
  • Tom99
    Tom99 Posts: 5,371 Forumite
    1,000 Posts Second Anniversary
    colb15 wrote: »
    Yes there are a few trades that fall into that bracket, sale price was lower than purchase price, in any case aware of the 'bed and breakfasting' rule that would impact those.
    Then if you list all the trades in that share on a separate tab it should be easy enough to work out the running totals of your Section 104 Holding and flag any shares acquired within 30 days after the last sale.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350K Banking & Borrowing
  • 252.7K Reduce Debt & Boost Income
  • 453.1K Spending & Discounts
  • 243K Work, Benefits & Business
  • 619.8K Mortgages, Homes & Bills
  • 176.4K Life & Family
  • 255.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 15.1K Coronavirus Support Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.