Foreign security reporting how to get value of just certain foreign stocks

Stephen Fisher

In Canada at tax time now we have two foreign holdings reports to file.

The first is income from all foreign holdings for the year.  I was able to get this done by going back to every transaction and adding the word "foreign" as a tag.  I then could run a report for all "Foreign" tags for "Last year" and get the totals needed. Unfortunately Q doesn't let you save the report to PDF and when I sent the .csv to my accountant he was unhappy.  So I moved the report by .csv to a spreadsheet, played with it a bit to make it look pretty and so got it done.  Quite a pain, but doable.

The second report the gov requires is a monthly value of the foreign holdings over the year.   The only report that I could find in QM that shows values (not transactions) is the Net Worth report. It allows you to select an account but the TAGs are greyed out. SO the best you can do is get the value of the whole account, not the foreign files you need.  This might sound like it's not a problem in the US funds account, but even there, there are several holdings that are Canadian but denominated in US funds which I cannot figure out how to omit from a report. And on the Canadian side there are several companies with a foreign HO that trade in CAN funds, like most of the Brookfield stocks  

Any ideas to get this done?

Thanks

Quicken Sarah

Hello @Stephen Fisher

I apologize, the prior instructions are intended for the Windows version of Quicken and unfortunately, do not apply to the Mac product version.

In Quicken for Mac, there are currently not any specific reports for investments, however, I would recommend trying to create a "New Report", and working with the customization for categories and tags to group the foreign investment transactions.

Or exporting a transaction report to a program like excel to further customize and manipulate the data.

I hope this information is helpful and please let us know if there are further questions/concerns.

Thank you,

Sarah

Tom Young

If you're only referring to securities here then the reporting is trivial.  You simply run an "Investing" > "Investment Income" report limiting the securities selected to the "foreign holding" ones.  Do likewise for your monthly value report buy using the "Investments" > "Portfolio Value" report, again with only the "foreign holdings" securities.  Any "Investing" report - transactional or balances - can be filtered to to securities to be included or excluded as well as the Accounts to be included or excluded. 

If you're running Windows then "Microsoft print to PDF"

https://answers.microsoft.com/en-us/windows/forum/windows_10-hardware/how-to-add-or-reinstall-the-microsoft-pdf-printer/70377c34-e50a-42be-b9f3-92345d6e25df

should be available to you.  You go to print you select "Microsoft print to PDF", give it a file name, and the report you're printing will we in PDF form.

smayer97

The OP identifies this issues in "QM" -> QMac, not QWin.

Stephen Fisher

Unfortunately there is no "investing" menu for reports of any kind that I can find in QM

Quicken Sarah

Hello @Stephen Fisher

I apologize, the prior instructions are intended for the Windows version of Quicken and unfortunately, do not apply to the Mac product version.

In Quicken for Mac, there are currently not any specific reports for investments, however, I would recommend trying to create a "New Report", and working with the customization for categories and tags to group the foreign investment transactions.

Or exporting a transaction report to a program like excel to further customize and manipulate the data.

I hope this information is helpful and please let us know if there are further questions/concerns.

Thank you,

Sarah