Skip to content

PDF document

Banks and brokers often provide transaction statements (buy, sell, dividend, etc.) for your convenience on paper or in PDF format. PP can read PDF documents from more than 90 banks and brokers and import the described transactions. The PDF in Figure 1 describes a (fictitious) buy transaction from an Australian broker. If you want to follow along with the example, you can download the PDF document.

Figure 1. Buy statement from SelfWealth of 25 pcs of Beta SP500 YieldMax.

Checking the Existence of the Importer

PP must "know" some details about the PDF document from your bank or broker. For example, the type of transaction in Figure 1 is identified by the title "Buy Confirmation," and the ticker symbol (UMAX) is indicated under the column header "Security Code." PP must recognise these details for each transaction to extract the necessary content from the PDF. Therefore, for each supported bank or broker, PP has developed a specific importer (parser) with knowledge of the different transaction types. To develop these importers, PP relies on information provided by its users (see Requesting a New Importer).

To verify if your bank or broker is supported, try to import a PDF document (see next section). The import wizard will either recognise it automatically or display an error message listing all the banks/brokers it has tried. You can also search the forum using the term PDF import or PDF import [name-of-your-bank-or-broker] to see if an importer for your institution is available or if there are any issues with it. If the importer exists, you can move on to the next section. Otherwise, you need to first request a new importer (see Requesting a New Importer).

Importing a PDF

Use the menu File > Import > Import PDF Bank Documents or the shortcut key CTRL+I, P, and navigate to the PDF document on your local system. You can select more than one PDF document. If a document is recognised by PP (i.e., an importer exists for the bank or broker of this document), an Import Transaction dialog box, such as in Figure 2, is displayed.

In this particular case, there is a small problem and the import operation could not be fully executed. The error message at the bottom provides an indication: the cash account Call Money Account from the demo Kommer portfolio is used for the cash handling of the transaction, but this deposit account is in EUR while the transaction currency is AUD. Selecting (or creating) an AUD deposit account will fix the problem. Please note that in Figure 2, two operations are scheduled: (1) the buy transaction, and (2) the creation of the security Beta S&P500 Yieldmax. If this security already exists in the portfolio, then the import wizard will use the existing security.

Figure 2. Imported transaction from PDF of Figure 1.

Figure 3. Search for suppliers of historical prices (example available at Portfolio Report).

In case of a new security, a Search for suppliers of historical prices box is displayed. If the security is listed on Portfolio Report, then the historical prices could be automatically added. Otherwise, the security is created, but you will need to manually edit the data source to download the historical prices.


Requesting a New Importer

If PP doesn't have a PDF importer for your bank/broker or for the specific type of transaction you need, you can request the development of this importer. More info can be found at How-to > Requesting a new PDF Importer.