Dividend Data feed issues affecting returns — Support Bulletin 26/07/23

There are issues relating to 2 holdings in the Dividend Data feed in Personal, Business and Trust Tax version 23.2.

Holding 1: HSBC Holdings PLC — $0.50 (ISIN GB0005405286)

An incorrect payment rate is used for the payment on 28 April 2022.
Date
Current Rate (incorrect)
Correct rate
28/4/2022
£0.185392
£0.138188

Holding 2: Shell PLC — €0.07 (ISIN GB00BP6MXD84)

An incorrect payment rate is used on all 4 payments within 2022/23.
Date
Current Rate (incorrect)
Correct rate
27/6/2022
£0.1870
£0.2001
20/9/2022
£0.2190
£0.2157
19/12/2022
£0.1870
£0.2061
27/03/2023
£0.2200
£0.2411

Income/Accumulation Unit Trust Dividends

Equalisation isn't automatically calculated on in-year purchases where needed.

Identify clients using Query Manager

To help you identify affected clients, we've provided some queries for HSBC and Shell.
  1. In Personal, Business and Trust Tax, select
    Tools
    , then
    Query Manager
    .
  2. Select
    Temporary (Work in progress)
    .
  3. Select
    New
    , then
    Query
    .
  4. Select
    Advanced
    , then
    Yes
    .
  5. Download the HSBC query or Shell query and paste it into the main part of the
    Advanced Query
    window.
  6. Enter a name for the query, then select
    OK
    .
  7. Run the Client Details report:
    1. Go to
      Reports
      ,
      Client Details
      , then
      Use Query
      .
    2. Select the name of your query, then
      OK
      .

Updated Dividend Data feed

This issue will be resolved in the next release of Personal, Business and Trust Tax, version 23.2 (anticipated late 2023). If you prefer to update the dividend data feed manually before then, follow these instructions:
  1. Download the updated Dividend files.
  2. Unzip the files and copy them to
    C:\Program Files (x86)\Digita\Personal Tax\Dividend\22-23\
  3. Install these files on any workstations using Digita, Personal Business and Trust Tax.