Dividends with Imputation Credits

Franking Credits are part of an investor’s income and not a tax they pay. Nevertheless, if the tax field is not used (as is normally the case for Australian investors) it can usefully be co-opted as the Franking Credits field.

I recommend the following workaround demonstrated using the data given in Import CSV file

Enter the dividend with Gross Value blank, Taxes containing Franking Value, and Credit Note containing Total (Franked, Unfranked, and Franking Credit (Imputation Credit)).

Let’s demonstrate it using the GUI and a text editor:

Paid,Code,Shares,Dividend,Franking,Total
23/03/21,REA,64,37.76,16.19,53.95

It is best not to enter Gross Value, and enter Taxes before Credit Note and note as the last digit is entered for Credit Note that Gross Value will update.

image

Save the file and exit Portfolio Performance.

Now open the *.xml file in a text editor (eg NP++) and search for type="TAX". Make the Tax value(s) negative and save the file. You can see below amount="1619" needs to be changed to amount="-1619".

If you open Portfolio Performance again and view the transaction the Gross Value has been updated but if changes are made the taxes must be saved as a positive value (and edited in the text editor again).

image

Portfolio Performance will now have the full dividend income which will be used in calculations:

image

Taxes can change over time but with a constant (30%) Franking Credit, the Franked and Unfranked amount can be calculated from the Total amount.

Be aware of the concerns raised in this topic but don’t be concerned.

Portfolio Performance
Version: 0.64.4 (July 2023)
Platform: win32, x86_64
Java: 17.0.5+8-LTS, Azul Systems, Inc.