How do I merge 2 accounts and remove duplicate transactions in the merged account?

  • 1
  • Question
  • Updated 1 month ago
I'm using Reckon Accounts Australia Home & Business 2019.
I'm trying to merge 2 accounts into a single account. There will be duplicate entries in the merged account. I'm having problems working out how to easily remove duplicates based on certain criteria, e.g. date, payee, amount; without doing it manually.
thanks
Photo of Hinson Chan

Hinson Chan

  • 140 Points 100 badge 2x thumb

Posted 1 month ago

  • 1
Photo of John Graetz

John Graetz

  • 23,728 Points 20k badge 2x thumb
In the first instance, I am not sure by what you mean by "two accounts" - are they two reckon files or are they two customer accounts?  Whilst not being familiar with the particular version you are using, I am of the opinion that the process should be the same as for other higher end versions, if you are dealing with customer accounts..  It should be a case of editing the customer account that you want to disappear and changing the name of the account to exactly the same as the one that you want to retain.  You should receive an warning message asking if you want to merge the two accounts, to which you would say yes.  By doing this, you  should not have any duplicated transactions.
John L G
(Edited)
Photo of Hinson Chan

Hinson Chan

  • 140 Points 100 badge 2x thumb
Hi John,

Thanks for the quick reply.

I have 1 x Reckon file, but 2 customer accounts (say Account1 & Account2). So I want to merge Account1 into Account2. 

I've tried to edit and renaming Account1 ==> Account2, and get the "warning to merge" message. But I get an error message, "Name already in use".

thanks
Hinson
Photo of John Graetz

John Graetz

  • 23,548 Points 20k badge 2x thumb
I have done this before on Reckon Accounts and would have got the message name already in use but this was followed by a question as to whether I wanted to merge the accounts, to which I said yes.  If you cannot see this, then I can only think that your version does not allow this.  Perhaps somebody else with more experience with your version can assist.  Sorry
John L G
Hi Hinson

Just check to make sure there isn't a third account with the same name you are using for the merge.
Photo of Hinson Chan

Hinson Chan

  • 140 Points 100 badge 2x thumb
thanks, I've checked and there isn't any other accounts with the same name.
Have you checked the supplier names, you will get this message if you have a customer with the same name as a supplier.
Photo of Hinson Chan

Hinson Chan

  • 140 Points 100 badge 2x thumb
thanks, no, there are no duplicate supplier names
Photo of Hinson Chan

Hinson Chan

  • 140 Points 100 badge 2x thumb
no worries, thanks John
Photo of Diver Dave

Diver Dave

  • 5,664 Points 5k badge 2x thumb
Hinson, if you are trying to merge two Banking & Cash Accounts, say, then it's quite simple to transfer transactions from Account 1 to Account 2 - Right click on a Transaction and  select Move Transaction(s), then select Account 2.  You can highlight individual transactions or select blocks to move.

You can transfer into a linked investment cash account, but not out of one.

Hope that helps 
Photo of Hinson Chan

Hinson Chan

  • 140 Points 100 badge 2x thumb
Thanks Dave, I can do that, but as Account1 and Account2, may have "identical" transactions. And I'm trying to eliminate any duplicates, this doesn't work for me. As the transfer simply moves the transaction from say, Account 1 to Account 2 and then I end up with 2 identical transactions in Account 2, as there are hundreds of transaction involved, I need to do bulk transfers.
Photo of Diver Dave

Diver Dave

  • 5,664 Points 5k badge 2x thumb
Don't think it would be quite as onerous as you think, Hinson.  Worst case transfer every transaction, then in the combined account scroll down and eliminate every duplicate - they'll be adjacent entries, so easy to identify.

Bit tedious but not that hard.  Alternatively, have a print out of Account 2's register and scroll down Account 1 and only select unique entries to transfer.

I don't know of any other way to achieve what you want. 
Photo of Hinson Chan

Hinson Chan

  • 140 Points 100 badge 2x thumb
Thanks Dave, yeah, that's what we are doing (manually). Thought of exporting as a CSV and then writing an Excel macro to eliminate duplicates, then back into Reckon; but as a once off (hopefully), we are taking the manual route for now.
Photo of Diver Dave

Diver Dave

  • 5,664 Points 5k badge 2x thumb
How many transactions are you talking about, Hinson?  Not sure you could import a csv file anyway.
Photo of Hinson Chan

Hinson Chan

  • 140 Points 100 badge 2x thumb
Each account has ~1500 transactions, and probably ~20% duplicates.
Yeah, what we do is from CSV ==> QIF ==> Reckon
Photo of Diver Dave

Diver Dave

  • 5,664 Points 5k badge 2x thumb
OK, so it's a matter of what's easier, I guess