PDF import from Commonwealth

CommSec is almost the most popular Broker for ASX:

Here is an example of the PDF how it looks like: https://www.coursehero.com/file/63931397/Contract-98505191pdf/

1 Like

Hello @Ismail_Mogal

We do not have access to your uploaded documents.
For a PDF importer we need examples of purchase, sale, dividend and so on… please post them here. You can see how it works in the video tutorial.

Video tutorial:
Extract PDF documents for debugging

Portfolio Performance must extract text from a pdf. That is a pdf of an image of a pdf so text can’t be extracted. (It’s like trying to buy something with a photo of money instead of real money.) Text must be extracted from an original CommSec pdf to develop an extractor.

Sorry I got busy, here is the PDF sample, I don’t have a sample PDF and I cannot attach the actual PDF as it has personal details. Should I just copy-paste the text remove personal details.

Yes, please as you can see in the tutorial video, create the PDF debug and replace your personal data.

You have unfortunately forgotten the formatting of the text. Please edit your post and insert the back ticks before and after it.

Hmm… you have deleted a lot of information.
Please edit again and replace the name, address and account numbers with random characters.
Do not delete or add anything manually. Please always post the complete PDF debug.
Do you have any other documents that CommSec can provide you with?

PDF author: ''
PDFBox Version: 1.8.16
-----------------------------------------
BUY
Address - Locked Bag 22 Australia Square NSW 1215
  Telephone - 13 15 19 TAX INVOICE
  Facsimile - 1300 131 519
  Email - shares@commsec.com.au CONFIRMATION
  Internet - commsec.com.au
  Please retain for taxation purposes
  Trading, Clearing and Settlement of this transaction is undertaken by
  Commonwealth Securities Limited.
XXX XXX XXXX
2 XXXXXX XXX
ST XXXX XXX XXX
WE HAVE BOUGHT THE FOLLOWING SECURITIES FOR YOU
COMPANY: MESOBLAST LIMITED
MSB
SECURITY: ORDINARY FULLY PAID
DATE: 09/09/20XX UNITS AT PRICE
AS AT DATE: 09/09/20XX 4,500 4.550000
CONFIRMATION NO: XXXXX
AVERAGE PRICE: 4.550000
ORDER NO: NXXXXXXXX
ACCOUNT NO: XXXXX PID XXXX HIN XXXXXX
ORDER COMPLETED
TOTAL UNITS: 4,500
CONSIDERATION (AUD): $20,475.00 CONTRACT COMMENTS:
BROKERAGE & COSTS INCL GST: $20.47 XXXXXXX XXXXXXXX
(may include printed confirmation postal fee) 105
APPLICATION MONEY: $0.00
TOTAL COST: $20,495.47
TOTAL GST: $1.86
SETTLEMENT DATE: 11/09/20XX
PAYMENT METHOD - DIRECT DEBIT OF CLEARED 
FUNDS FROM NOMINATED BANK A/C ON 
SETTLEMENT DATE.
1. This Confirmation Contract Note is issued by Commonwealth Securities Limited and is issued subject to:
  
  (a) The current General Conditions of Trade of Commonwealth Securities Limited ("CommSec");
  
  (b) Directions, decisions and requirements of the Market Operators, the ASIC Market Integrity Rules, the Market Operating Rules, the Clearing Rules and where relevant, the 
Settlement Rules, the customs and usages of the Market Operators, and the correction of any errors and/or omissions. Under the Rules of ASIC and the Market Operators, 
CommSec is required to act consistently with a fair and orderly market. CommSec or the Market Operators are entitled to cancel a trade without further reference to you as 
permitted by the current General Conditions of Trade and the Market Operating Rules. 
  
  If you request a Confirmation Contract Note to be sent to you by post, a $1.95 fee will be charged in addition to brokerage.
  
  Commonwealth Securities Limited ABN 60 067 254 399, AFSL 238814 is a wholly owned, but non-guaranteed subsidiary of the Commonwealth Bank of Australia ABN 48 123 
123 124 and a Participant of the ASX Group and Chi-X Australia. 
  
  Your order may have been executed as multiple market transactions across multiple trade execution venues in accordance with our Best Execution policy. This Confirmation 
specifies the volume weighted average price for those market transactions.

PDF author: ''
PDFBox Version: 1.8.16
-----------------------------------------
SELL
Address - Locked Bag 22 Australia Square NSW 1215
  Telephone - 13 15 19 TAX INVOICE  
  Facsimile - 1300 131 519
  Email - shares@commsec.com.au CONFIRMATION
  Internet - commsec.com.au
  Please retain for taxation purposes
  Trading, Clearing and Settlement of this transaction is undertaken by
  Commonwealth Securities Limited.
XXX XXXX XXXX
2 XXXXX XXXX
ST XXXXX XXX XXXX
WE HAVE SOLD THE FOLLOWING SECURITIES FOR YOU Ex Dividend
COMPANY WISETECH GLOBAL LIMITED
SECURITY ORDINARY FULLY PAID WTC
DATE: 09/09/20XX
AS AT DATE: 09/09/20XX UNITS AT PRICE
CONFIRMATION NO: XXXXXXX 1,000 28.060000
ORDER NO: NXXXXXX
ACCOUNT NO: XXXXXX AVERAGE PRICE: 28.060000
TOTAL UNITS: 1,000
CONSIDERATION (AUD): $28,060.00 PID XXXX HIN XXXXXXX
BROKERAGE & COSTS INCL GST: $28.06 ORDER COMPLETED
(may include printed confirmation postal fee) CONTRACT COMMENTS:
APPLICATION MONEY: $0.00
XXXXXXXX XXXXXXXXX
NET PROCEEDS: $28,031.94
TOTAL GST: $2.55 105
SETTLEMENT DATE: 11/09/20XX
PAYMENT METHOD - DIRECT CREDIT TO NOMINATED 
SETTLEMENT A/C ON SETTLEMENT DAY. FUNDS AVAILABLE 
FOLLOWING DAY.
If not already provided, Security Document and/or Holder Information to be provided by 11/09/2020
1. This Confirmation Contract Note is issued by Commonwealth Securities Limited and is issued subject to:
  
  (a) The current General Conditions of Trade of Commonwealth Securities Limited ("CommSec");
  
  (b) Directions, decisions and requirements of the Market Operators, the ASIC Market Integrity Rules, the Market Operating Rules, the Clearing Rules and where relevant, the 
Settlement Rules, the customs and usages of the Market Operators, and the correction of any errors and/or omissions. Under the Rules of ASIC and the Market Operators, 
CommSec is required to act consistently with a fair and orderly market. CommSec or the Market Operators are entitled to cancel a trade without further reference to you as 
permitted by the current General Conditions of Trade and the Market Operating Rules. 
  
  2. Credits from sales of securities are not available until the settlement date and all documents and security holder information have been delivered to Commonwealth Securities 
Limited and verified through CHESS Settlement Facility, if a CHESS Participant Sponsored Holding security has been sold. Subject to the relevant Terms and Conditions, the 
proceeds of your sale will be paid to you in accordance with your standing instructions on the settlement date, unless otherwise agreed.
  
  If you request a Confirmation Contract Note to be sent to you by post, a $1.95 fee will be charged in addition to brokerage.
  
  Commonwealth Securities Limited ABN 60 067 254 399, AFSL 238814 is a wholly owned, but non-guaranteed subsidiary of the Commonwealth Bank of Australia ABN 48 123 
123 124 and a Participant of the ASX Group and Chi-X Australia. 
  
  Your order may have been executed as multiple market transactions across multiple trade execution venues in accordance with our Best Execution policy. This Confirmation 
specifies the volume weighted average price for those market transactions.

Would be better with dummy data (eg fake names) than X for characters and numbers.

Very good. I’ll get on it and implement the importer in PP. Since this is a new importer, please check the other purchases, sales, income and dividends to see if there are any other fees, taxes, etc. hiding in the documents. Also, it may be that not all PDF documents are working yet. Please post them here.

I have attached BUY and SELL, for dividends will be quite complex, get different PDF from different companies.

Same for SelfWealth - dividend notices come from the companies in different formats.

Then please post these PDF debugs here, analogous to these you have posted so far. The more examples we have, the better the importer will work and recognize and process all documents.

If they are documents from SelfWeath, then post → here ← . If they are documents from CommSec, then post here.

@Nirus, dividend statements are TOTALLY different from each company and it has nothing to do with Commsec or SelfWealth or share registry (Stock transfer agent ), it’s the company.

I think bank statements and cashbook reports are the way to go for Australian dividends. eg https://templatelab.com/bank-statement/

1 Like

Hallo @flywire
Okay, then please open a new post for this analogous to CommSec and SelfWealth. Post the PDF debugs here, then they can be implemented in PP.

@Nirus - anyone looked at this request - ASX feature request · Issue #2351 · buchen/portfolio · GitHub.
I can’t find my post here for the LIFO request.

I am looking for the ISIN or WKN and the name of the security in your PDF debugs. Did you delete these by any chance?

No they are not mentioned here much in Australia, only three-character security code:

1 Like