Creating a csv for importing historical Investment Transactions

cgalvan
cgalvan I do not have Quicken yet Member

I'm working with a CSV file containing all activity across four brokerage accounts. I've successfully imported all but the cash deposit and withdrawals. What is the secret to getting those formatted correctly in the CSV so that they upload properly?

Comments

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭

    It seems like they are using the same action terms as used in the QIF files, so "Cash" could be used with the sign of the amount flagging if it is a Withdraw or a Deposit, but it seems like the normal syntax of [Other Account] in the category field for a transfer will not work. It turns it into regular category with this syntax -Other Account-.

    Signature:
    This is my website (ImportQIF is free to use):

    http://www.quicknperlwiz.com/