PDF import from AJ Bell Securities / YouInvest

English Import/export
1

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!

2

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

3

3 posts were merged into an existing topic: PDF import from Hargreaves Landsdown

6

Hi,
I was hoping for a bit of help with importing the data into PP from my AJ Bell account rather than do it all manually.

I have downloaded PDFs statements and contract notes and imported into PP but I get an error stating the files could not be imported.

@Abacus6923 do you have any tips on how to import the PDFs from AJ Bell and what process you have to use?
Thanks
Rob

7

Hello @rob_c and @Abacus6923
I have revised the importer since it was not added last time.
If everything is OK, it should be included in the next release.

Regards
Alex

8

@rob_c I decided in the end to bypass the pdf imports and just use Excel with exports from AJ Bell and convert into PP’s CSV import format, as that means I get accurate dividend data too.