Investment categories

rodwhd's Avatar


19 Jul, 2017 03:13 PM

Hi I am based in the UK and currently use an old version of Quicken (2002!) on an old windows computer. But I now have a mac and want to switch to software like Moneydance, Banktivity or Personal Investing. I use it entirely for tracking investments held in different brokerage accounts (ISAs and ordinary accounts with 3 brokers for my wife and for me).
Q1: I want to be able to see my investments by category - not just stocks, bonds, etf's or unit trusts, but by sector (tech, consumer staples, retail, healthcare etc) and or by country or region (US/UK/Europe/China). Is it possible to insert categories when I enter new investments, and then show portfolio values by these customised categories? (cheeky question - If not do you know of alternative software that would do this? )
Q2: Will I be able to transfer the windows based QIF files from Quicken 2002 to a mac version of Moneydance (not totally vital, i can just start with current investments)

  1. 1 Posted by rodwhd on 19 Jul, 2017 03:35 PM

    rodwhd's Avatar

    the article on Investment sub-type confirms you can create a sub-type which is great. but can you create a report which allows you to look at investments by sub-type?

  2. 2 Posted by derekkent23 on 19 Jul, 2017 04:09 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    I think the answer to your question is yes. Look at a section of one of my Asset Allocation Reports. You can see the securities are grouped by type and subtype. Each security have a value, a percentage of “Type” and a percentage of the “Total”.
    You can download the free trial version and experiment with the program. The demo version is fully functional and allows you to manually enter 100 transactions. Imported transactions are not limited, so you'll be able to fully test downloading data from your bank, and importing data from other personal finance software.
    If you decide to purchase the program at a later date you can keep all your data, the license key simply unlocks the ability to manually enter more transactions. You can download the trial version of Moneydance from
    You'll find the Moneydance knowledge base articles here which will be useful if you're using Moneydance for the first time.

    Hope this helps.

  3. 3 Posted by rodwhd on 19 Jul, 2017 08:42 PM

    rodwhd's Avatar

    thanks derekkent! this looks like what i am trying to achieve - presumably you specified the categories shown yourself, as sub-types, which is what i hope to do e.g. Mutual Europe ex Uk and Mutual Global Emerging Markets? Those don't appear to be standard categories shown in the manual

  4. 4 Posted by derekkent23 on 20 Jul, 2017 07:05 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    For each security you can select a Type, Stock, Mutual, CD, Bond, Stock option, Ohers from a fixed list, see picture below. Once you have selected the type the available entries change to a list relevant to the security type you select. For each Security Type you can also add a Subtype. Importantly by clicking on Edit next to Subtype you can add any text you like adding as many Subtype as you need.

    Hope this helps.

  5. 5 Posted by rodwhd on 20 Jul, 2017 08:54 AM

    rodwhd's Avatar

    thanks a million - i will take the plunge - not sure if message gets
    through to you be replying to this email?

  6. 6 Posted by derekkent23 on 20 Jul, 2017 09:03 AM

    derekkent23's Avatar

    Hi, yes it does, also appears on the forum.
    Have Fun

  7. 7 Posted by rodwhd on 25 Jul, 2017 01:50 PM

    rodwhd's Avatar

    hi derkkent. quick question you may be able to help with.... I own the same
    stocks across different accounts, so i often want to view and print my
    investments by stock(security) rather than by investment account e.g. want
    to see how many Amazon shares and the value that I own in total, not split
    into separate accounts. The report Portfolio appears to give me this Edit
    option, but when I select Portfolio/Edit/Show by type/All security, it
    still displays and prints out the stocks separated into Investment
    accounts. The Moneydance support guy has suggested I use Extensions and set
    up extra Investment Reports, and design my own report there, but its very
    complicated and I haven't worked it out yet. Is there a simpler way? In my
    old Quicken 20002 its a core option to view a portfolio investments either
    subtotalled by Account, or by security

    *Yours, *
    *Rod Whitehead*
    *01344 842958 / **0780 330 9230*
    *Skype: rodwhd*

    *I am the voluntary UK Co-Ordinator for New Generation, a street kids
    charity in Burundi, in East Africa. They help hundreds of street kids in
    the capital, Bujumbura, and also run leadership &
    entrepreneurship training and peace events for young people across Burundi.
    See *** <>
    *and **New Generation Burundi*
    <>* in Facebook. This **3
    minute film*
    <>* gives
    you a good feel for the project *


  8. 8 Posted by derekkent23 on 26 Jul, 2017 07:48 AM

    derekkent23's Avatar

    Sorry can help you with this one. Have never wonted to report by Security, but can see it could be useful.

  9. Support Staff 9 Posted by Jenny on 26 Jul, 2017 11:34 AM

    Jenny's Avatar

    Hi Ron,

    Using the 'Portfolio' report, you can select "Show: By Individual" on the right of the settings screen. You can then choose which securities you'd like to report on (rather than All Securities), allowing you to run a report for each specific security. However, these reports will still be subtotaled by each account.
    If you're having trouble creating reports using the extension, you can create a new discussion that includes screenshots of the settings you're using. I'd be happy to provide guidance and assistance so you can generate the data you need.

    Infinite Kind Support

  10. System closed this discussion on 25 Oct, 2017 11:40 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac