How do I merge 2 accounts and remove duplicate transactions in the merged account?
Hinson Chan
Member Posts: 8 ✭
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
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
0
Comments
-
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 G0 -
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
Hinson0 -
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 G0 -
no worries, thanks John0
-
Hi Hinson
Just check to make sure there isn't a third account with the same name you are using for the merge.0 -
thanks, I've checked and there isn't any other accounts with the same name.0
-
Have you checked the supplier names, you will get this message if you have a customer with the same name as a supplier.0
-
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.
0 -
thanks, no, there are no duplicate supplier names0
-
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.0
-
Each account has ~1500 transactions, and probably ~20% duplicates.
Yeah, what we do is from CSV ==> QIF ==> Reckon0
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community