This calculator may assist in CGT calculations - CHECK THE FIGURES THAT YOU GET and let me know if you have problems - send an email to david@stonebanks.co.uk

ADDED 8 October 2009:
The program now adds same-day buys and same-day sells - but same-day buys must be listed before sells.

ADDED 15 April 2009:
Currently the rules are:
1: buys get added to a 'pool' - my prog reports pool qty, pool cost, and pool average price paid.
2: match sale(s) with buy(s) on the same day,
3: match sale(s) with any buy(s) in the following 30 days,
4: match other sale(s) from the pool.

The program reports gain or loss for each sale and for all sales listed.

Another site that provides a CGT calculator and advice on CGT is http://www.cgtcalculator.com/algorithm.aspx

I have provided translation programs - from www.stonebanks.co.uk - so that results from the two programs can be easily compared.

Notes on Capital Gains: http://www.inlandrevenue.gov.uk/pdfs/2003_04/capital_gains/sa108_notes.pdf
CGT on shares helpsheet: http://www.inlandrevenue.gov.uk/pdfs/2003_04/capital_gains/ir284.pdf
CGT and employee share schemes helpsheet: http://www.inlandrevenue.gov.uk/pdfs/2003_04/capital_gains/ir287.pdf

Format for source data:

Source file is a text file with comma "," to separate fields:
; comments starting with a semi-colon are copied to the output text
@ comments starting with @ are NOT copied to the output text

Share name - if line starts with a letter.

Data list with comma (",") separating fields:
date dd-mm-yy or ddmmyy, b or B or s or S, qty, unit price (pence), total paid or received (pounds.p)

If you prefer the dd-mm-yy date format, then the separator can be space (dd mm yy), / (dd/mm/yy) or - (dd-mm-yy).

Deals for each share should be listed in date order.

Clicking the diag info box will display all calculations so that you can check the maths.

The program should cope with up to 50 deals for any one security.

Comments welcome to stonebanks@ntlworld.com

abc co ord U
01-02-02, b, 1000, 25, 260.55
01/03/02, b, 2000, 20, 420
01/04/03, b, 500, 50, 260.23
02-05-03, b, 100, 60, 59
020503, s, 1000, 60, 590.35
03-06-03, s, 1000, 70, 680.45

Discovery tst ord
; bt as warrants 6/4/00 at 101p
; exercised 30/4/02 (converted to shares) at 100p
06-04-00, b, 1500, 201, 3037.73
06-12-02, s, 1500, 91.2, 1353.00

Ottakar's ord - Hemscott tip
250702, b, 1500, 165, 2512.13
13-11-02, s, 1500, 170, 2524.50

Enter your data into a word processor (I used WordPad) then Edit>Select All>Copy and paste into the upper text area of this calculator page.

Click on Process - the lower text area then displays the data in the format required for the Inland Revenue CGT form. Right click on this text area - use copy and paste to your word processor.

I have simply copied the totals to the revenue CGT form and sent a copy of the calculations with my tax return. It has been accepted without question for the last couple of years. Alternatively, http://convert.neevia.com/ or http://www.dopdf.com are websites that can be used to convert the calcs to PDF if you wish to post your tax return online.

The last text box shows a list of companies and closing pool figures. At the end of a tax year, this can be copied to form the start of a data list for the next tax year.

YOU ARE RESPONSIBLE FOR THE FIGURES YOU PROVIDE TO THE INLAND REVENUE - CHECK THEM.