Useful information relating to the Dividend Database (2022-23)

Article ID: 3247
Last updated: 21 Jun, 2023

Below is some useful information surrounding the data held within the Dividend Database for the 2022-23 tax year. If you are looking for information relating to the 2021-22 tax year, please review our article for Useful information relating to the Dividend Database (2021-22)

The following companies performed a share split (or reverse split) during or just prior to the 2022-23 tax year.

AVI Global Trust, Aviva, GlaxoSmithKline, JD Sports, Personal Assets Trust

Quilter, Tate & Lyle, Temple Bar Investment Trust and Secure Income REIT

This means that you may have more (or less) shares in a company.

(New share certificates would have been sent to shareholders)

Some Companies also paid cash to shareholders at the split; this may be treated as a Capital Gain, the company would advise of this.

The Dividend Database rolls forward the shareholding from the previous year’s Dividend Database

After using ‘Refresh’, the holding for 2022-23 must be updated manually in the wizard for these companies.

The 2022-23 holding is the rounded down figure of the 2021-22 holding x a multiplier.

The 2022-23 ‘ordinary share price’ will show which holding may need to be updated.

Example (GSK see below)

317 ‘Old’ shares, gives 253.60 ‘New’ shares which would result in a holding of 253 ‘New’ shares

The holding for dividend payments made after 19 July MUST be adjusted based on above example.

AVI Global Trust (AGT)

From 17th Jan 22 5 new 2p shares for every 1 existing 10p share

NEW shareholding = old holding x 5

Aviva (AV.)

From 16 May 22 76 new 32 17/19p shares for every 100 existing 25p shares

NEW shareholding = Rounded down figure of (old holding x 0.76)

Potential CGT liability: For each original share of 25p held - GBP 1.0169 in cash

GlaxoSmithKline (GSK)

From 19 Jul 22 4 new 31.25p shares for every 5 existing 25p shares

NEW shareholding = Rounded down figure of (old holding x 0.8)

JD Sports (JD.)

From 30 Nov 21 5 new 0.05p shares for every 1 existing 0.25p share

NEW shareholding = old holding x 5

Personal Assets Trust (PNL)

From 01 Aug 22 100 new GBP 0.125 shares for every 1 existing GBP 12.50 share

NEW shareholding = old holding x 100

Quilter

From 20 Mar22 6 new 8 1/6p shares for every 7 existing 7p shares

NEW shareholding = Rounded down figure of (old holding x 0.8571)

Potential CGT liability: For each Quilter of 7p held – 20p in cash

Tate & Lyle (TATE)

From 3 May 22 6 new 29 1/6p shares for every 7 existing 25p shares

NEW shareholding = Rounded down figure of (old holding x 0.857143)

Note: Special dividend of 1.07 in May was paid against the original 25p shares

Temple Bar Investment Trust (TMPL)

From 13 May 22 5 new 5p shares for every 1 existing 25p share

NEW shareholding = old holding x 5

Secure Income REIT (SIR) replaced by LXI REIT (LXI)

From 06 Jul 22 3.32 new 1p LXI shares for every 1 existing 10p Secure Income shares

New LXI holding = Rounded down figure of (original Secure holding x 3.32)

Note: Last payment from Secure was 0.0395 paid 07 June 22

Potential CGT liability: For each Secure share of GBP 0.1 held - GBP 1.434 in cash

To add or update the LXI holding for 2023….

Leave the original Secure dividend of 0.0395 paid 07 June 22 in the wizard

Calculate the new or additional holding of LXI

No LXI in 2022

Use company database lookup to ADD the new LXI holding

LXI holding in 2022

Manually update the LXI holding in wizard (add the new figure to the brought forward figures)

(DO NOT ‘add’ another set of entries for LXI – you must update as above)

Article ID: 3247
Last updated: 21 Jun, 2023
Revision: 8
Views: 817
This article was:  


Also read
item Useful information relating to the Dividend Database (2021-22)

Also listed in
folder Tax Return Production -> SA100 Individual Return