PDF import from AJ Bell Securities / YouInvest

Hi there. Any chance you could add support for AJ Bell / YouInvest in the UK?

Buy example 1:


PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
XXXXXX CONTNOTE                      06122019 XXXXXX     000000050007561 44619C5L6DQ
Tel: 0845 373 3479
Email: dealingservices@Youinvest.co.uk
Mr X Y
200
10 Some Street
London
United Kingdom
XXXX YYY
CONTRACT NOTE
Account No. XXXXXX AJ Bell Youinvest ISA for Mr X Y
     Deal date           Time Settlement date Bought or Sold          Sedol Reference
05/12/19 13.15 11/12/19 Bought BF41Q72 C5L6DQ
We have bought for you as agent
LEGAL & GENERAL(UNIT TRUST MNGRS) WORLD CLIM CHNGE EQTY FACTORS IND I
ACC
Venue Quantity Price Consideration
XOFF            17,940.965 0.5573         9,998.50 GBP
Dealing charge          1.50 GBP
                     _____________    
                                     
Total debit     10,000.00 GBP
Order type: Market order
This stock is not listed on the London Stock Exchange
Fund manager’s initial charge       0.00%
Unit trust accumulation
Dealing services for AJ Bell Youinvest are provided by AJ Bell Securities Limited (company number 2723420)
whose registered office is: 4 Exchange Quay, Salford Quays, Manchester M5 3EE .
AJ Bell Securities Limited is a member of the London Stock Exchange and is authorised and regulated by the Financial Conduct Authority (number 155593)

Buy example 2:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
XXXXXX CONTNOTE                      11112019 XXXXXX     000000049284919 44619C46TWX
Tel: 0845 373 3479
Email: dealingservices@Youinvest.co.uk
Mr X Y
200
10 Some Street
London
United Kingdom
XXXX YYY
CONTRACT NOTE
Account No. XXXXXX AJ Bell Youinvest ISA for Mr X Y
     Deal date           Time Settlement date Bought or Sold          Sedol Reference
08/11/19 13.15 14/11/19 Bought BF41Q72 C46TWX
We have bought for you as agent
LEGAL & GENERAL(UNIT TRUST MNGRS) WORLD CLIM CHNGE EQTY FACTORS IND I
ACC
Venue Quantity Price Consideration
XOFF            14,008.055 0.5711         8,000.00 GBP
Dealing charge          1.50 GBP
                     _____________    
                                     
Total debit      8,001.50 GBP
Order type: Market order
This stock is not listed on the London Stock Exchange
Fund manager’s initial charge       0.00%
Unit trust accumulation
Dealing services for AJ Bell Youinvest are provided by AJ Bell Securities Limited (company number 2723420)
whose registered office is: 4 Exchange Quay, Salford Quays, Manchester M5 3EE .
AJ Bell Securities Limited is a member of the London Stock Exchange and is authorised and regulated by the Financial Conduct Authority (number 155593)

Sell example 1:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
XXXXXX CONTNOTE                      28062021 XXXXXX     000000083357074 44621CNG7G1
Tel: 0345 373 3479
Email: dealingservices@youinvest.co.uk
Mr X Y
200
10 Some Street
London
United Kingdom
XXXX YYY
CONTRACT NOTE
Account No. XXXXXX AJ Bell Youinvest ISA for Mr X Y
     Deal date           Time Settlement date Bought or Sold          Sedol Reference
28/06/21 08.10 30/06/21 Sold  B8NZ739 CNG7G1
We have sold for you as agent
UBS (LUX) FUND SOLUTIONS MSCI WORLD SOC RSPON A UCITS USD DIS
Venue Quantity Price Consideration
XLON                   159 99.328        15,793.15 GBP
Dealing charge          9.95 GBP
                     _____________    
                                     
Total credit     15,783.20 GBP
Order type: Market order
This transaction is subject to the rules of the London Stock Exchange
Dealing services for AJ Bell Youinvest are provided by AJ Bell Securities Limited (company number 2723420)
whose registered office is: 4 Exchange Quay, Salford Quays, Manchester M5 3EE .
AJ Bell Securities Limited is a member of the London Stock Exchange and is authorised and regulated by the Financial Conduct Authority (number 155593)

Sell example 2:

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
XXXXXX CONTNOTE                      17082022 XXXXXX     000000113903746 44622C8M779
Tel: 0345 54 32 600
Email: dealingservices@youinvest.co.uk
Mr X Y
200
10 Some Street
London
United Kingdom
XXXX YYY
CONTRACT NOTE
Account No. XXXXXX AJ Bell Youinvest ISA for Mr X Y
     Deal date           Time Settlement date Bought or Sold          Sedol Reference
17/08/22 09.01 19/08/22 Sold  B7NLLS3 C8M779
We have sold for you as agent
VANGUARD FUNDS PLC S&P 500 UCITS E T F INC NAV GBP
Venue Quantity Price Consideration
XLON                   470 67.3483        31,653.70 GBP
Dealing charge          9.95 GBP
                     _____________    
                                     
Total credit     31,643.75 GBP
Order type: Market order
This transaction is subject to the rules of the London Stock Exchange
Dealing services for AJ Bell Youinvest are provided by AJ Bell Securities Limited (company number 2723420)
whose registered office is: 4 Exchange Quay, Salford Quays, Manchester M5 3EE .
AJ Bell Securities Limited is a member of the London Stock Exchange and is authorised and regulated by the Financial Conduct Authority (number 155593)

Many thanks!

Hello @Abacus6923
Welcome to the PP forum.

I have edited your PDF debug and implemented the new importer. If everything is ok, this should be included in the next release.

If there are more documents like dividend statements and statements with currency exchange, please post a PDF debug here.

Greets
Alex

Great, thanks @Nirus! AJ Bell don’t give branded PDF statements for dividend statements, but they offer to print from a webpage a statement with a breakdown. See this example. Happy to dig out more if useful.

PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
Corporate action detail
Account XXXXXXXX Mr XXXX XXXX
Account type Dealing account
Investment HSBC OPENFUNDS GLOBAL STRATEGY DYNAMIC PTF C ACC
TrEaxn dsataection h16is/1t0o/2r0y21: Dealing account
MrP aJya dmaetes XXXX1e5y/1(2A/2B0281KHQD)
01H/o0l9di/n2g022 11:31629:60761.84
DGaroteup 1 holdingTransa0ction Description Quantity Amount Reference
Group 1 pay rate GBP 0.0171 (£)
1G7r/o0u3p/ 210 p2a2ymePnturchaGseBP 0 HSBC Global Strategy 13,250.22 30,000.00 44622C3K9R2
Group 1 tax GBP 0 Balanced C Acc
1 4/02/2022 Purchase HSBC Global Strategy 12,603.22 29,001.50 44622C2GTW5
Balanced C Acc
Group 2 holding 169,671.84
3G1r/o0u1p/ 220 p2a2y ratPeurchaGseBP 0.0029 Royal London Sustainable 9,218.9613 30,000.00 44622C1X3KJ
World C Acc
Equalisation rate GBP 0.0142
27/01/2022 Purchase HSBC Global Strategy 17,330.37 40,000.00 44622C1WK1D
Group 2 payment GBP 492.04 Balanced C Acc
Group 2 Tax GBP 0
27/01/2022 Purchase Royal London Sustainable 5,849.4088 18,801.50 44622C1WHN4
Equalisation GBP 2409.34 World C Acc
24/01/2022 Purchase HSBC Global Strategy 12,908.78 30,001.50 44622C1RHW8
Balanced C Acc
24/01/2022 Purchase HSBC Global Strategy 21,513.99 50,000.00 44622C1QRVP
Balanced C Acc
17/01/2022 Purchase Royal London Sustainable 17,683.0239 60,000.00 44622C1HWF2
World C Acc
12/01/2022 Purchase Royal London Sustainable 4,107.1949 14,101.50 44622C1B5N5
World C Acc
12/01/2022 Purchase Royal London Sustainable 7,282.2604 25,001.50 44622C1B3MT
World C Acc
11/01/2022 Purchase Royal London Sustainable 3,500.1459 12,000.00 44622C090V0
World C Acc
11/01/2022 Sale Premier Miton UK Multi Cap Inc 6,100 13,668.60 44622C09X2G
B Inc Ins
11/01/2022 Sale HSBC Global Sustainable MA 18,435.48 25,623.82 44622C090VC
Dyn C Acc
11/01/2022 Sale Gold Bullion Securities GBP 40 4,931.02 44622C09XX2
11/01/2022 Sale UBS(Lux)FS MSCI EM SRI 601 6,860.80 44622C09XT9
USD Adis GBP
31/12/2021 Equalisation Acc Vanguard FTSE Glb All Cp Idx £ 0 805.88 44622##0086
Units Acc
31/12/2021 Accumulation Vanguard FTSE Glb All Cp Idx £ 0 1,694.55 44622##0086
Distribution Acc

Also, I found a buy that was buying denominated in USD, but it doesn’t look like they give any currency conversion info:



PDFBox Version: 1.8.16
Portfolio Performance Version: 0.59.1
-----------------------------------------
XXXXXXX CONTNOTE                      05122019 XXXXXX     000000049992168 44619C5L6BV
Tel: 0845 373 3479
Email: dealingservices@Youinvest.co.uk
Mr XXXX XXXX
XXXX
XXXX
XXXX
UNITED KINGDOM
XXXXXXXX
CONTRACT NOTE
Account No. XXXX AJ Bell Youinvest Dealing account for Mr XXX XXXX
     Deal date           Time Settlement date Bought or Sold          Sedol Reference
05/12/19 10.22 09/12/19 Bought BDGSVH2 C5L6BV
We have bought for you as agent
XTRACKERS (IE) PLC MSCI WLD INFO TECHNOLOGY UCITS ETF 1C
Venue Quantity Price Consideration
XLON                   380 26.23712         9,970.11 GBP
Dealing charge          9.95 GBP
                     _____________    
                                     
Total debit      9,980.06 GBP
Order type: Market order
This transaction is subject to the rules of the London Stock Exchange
Dealing services for AJ Bell Youinvest are provided by AJ Bell Securities Limited (company number 2723420)
whose registered office is: 4 Exchange Quay, Salford Quays, Manchester M5 3EE .
AJ Bell Securities Limited is a member of the London Stock Exchange and is authorised and regulated by the Financial Conduct Authority (number 155593)

Many thanks!

Hello @Abacus6923

I have added the purchase as well.

We are not able to process the dividend posting. Reason is that this is not an original PDF document, but as you mentioned it is a web print.
We only process documents created by the bank, because of the different converters to PDF is not possible. Please talk to your bank to provide you with these documents in PDF. They are obliged to do so.

Greetings
Alex

@Nirus, understood - I will ask. Hargreaves similarly does not provide any PDF format for dividends.

1 Like