Moving security transactions from one Investment Account to a new Investment Account

  • 1
  • Question
  • Updated 1 year ago
I am running Reckon Accounts Personal Plus 2016 on a Windows 10 machine.

About 2 years ago I bought a bunch of shares in some managed funds, all through the one broker (Vanguard).  When I set these up in Reckon, I (unwittingly) created a separate Investment Account for each fund, and then added a single security to each of these Investment Accounts to represent each individual fund.

In hindsight, what I should have done is create a single Investment Account (e.g. Vanguard) and then add all of the managed funds as individual securities to this.  That's what I'm trying to do now.

However, the only way I seem to be able to do this is via "Shares Transfered Between Accounts".  This transfers all the transactions across, with the correct share qty, price and total amounts.  However it sets the transaction date to the date that I complete the share transfer, and doesn't maintain the actual transaction date of the share purchase.  This stuffs up all my cost basis info.

Is there anyway to essentially "cut and paste" transactions from one Investment Account to another in bulk, so I can keep all the transaction data from the original Investment Account?  There are about 50 transactions per account, and I have 4 accounts to transfer over, so doing it manually will be a major PITA
Photo of Mike Austin

Mike Austin

  • 80 Points 75 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Diver Dave

Diver Dave

  • 3,958 Points 3k badge 2x thumb
Mike, you can set the date of the transfer as the original purchase date, but so far as I understand it won't transfer any income details.  Also, if you have multiple parcels of a particular holding, and enter original dates, Reckon doesn't transfer individual parcel costs correctly. 

Reckon also uses the Add Shares transaction, so cash is not reflected in the related bank account.

Unfortunately, I think you'll be stuck with a lot of manual adjustment whichever way you do it.

One other question - why call your Investment Account "Vanguard", and not the holding entity?  is you, if personally held or your Super Fund?
Photo of Mike Austin

Mike Austin

  • 80 Points 75 badge 2x thumb
Thanks - I feared as much :-(  Will have to decide if the effort is worth the reward, otherwise I'll just stick with multiple accounts with single securities in them.  It does have the advantage that I can easily see individual security values in the Investing summary window, whereas with multiple securities per account, I only see the total account value unless I go into further detail in the Investment window

I have five investment accounts set up - four of them are named after the Vanguard funds they represent (seemed logical to me at the time), and one is named after the brokerage I use for direct share investments (this one has a number of individual ASX listed securities stored in it).  The idea was to consolidate all the Vanguard Funds under one account, call it Vanguard (or whatever - not that important really) and then have each fund as a separate security.

All of these are essentially held under my name (or my Family Trust's name in reality) and not through a Super Fund.
(Edited)
Photo of Diver Dave

Diver Dave

  • 3,958 Points 3k badge 2x thumb
Always easier with hindsight, Mike.  If all the investments have the same beneficial owner, then it's probably worth the effort - it's relatively easy to enter multiple entries of the same type.

I'd suggest printing out, or exporting all transactions in each account to make it easier to re-enter.  If you'd like to contact me directly, my e-mail is david.stewart@optusnet.com.au and I'd be happy to assist.

If you have multiple investment accounts, then you lose the benefits of having a linked bank account for all your investments to handle the cash.

If you have all the investments in on account, say, "Trust Investments", then under Portfolio view you can see the total holdings.