tag:infinitekind.tenderapp.com,2009-01-14:/discussions/switching-from-another-personal-finance-program/1852-merge-acctsInfinite Kind: Discussion 2018-03-17T02:59:18Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-28T09:57:14Z2016-04-28T09:57:14Zmerge accts?<div><p>Hi,</p>
<p>Regarding the duplicate transactions - are the dates the same on
both sides of the transfer for these transactions? Some versions of
Quicken support different dates on the other side of transfers.
Unfortunately, Moneydance cannot match the two sides of a transfer
in such a case.</p>
<p>I may need you to clarify what you mean by "merging the
'imported' account with it's real counterpart". If you can provide
more details about the accounts/transactions you'd like to
amend/merge, and the outcome you'd like to see, then I will try to
provide instructions.</p>
<p>Jenny<br>
Infinite Kind Support</p></div>Jennytag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-28T15:03:59Z2016-04-28T15:03:59Zmerge accts?<div><p>The ‘imported’ accounts are the ones MD creates when
it can’t match up a transaction. What I am now ending up
doing is, deleting all the ‘imported’ credit and bank
accounts. Deleting all transactions in all accounts, one by one,
then reimporting transactions from my original files. Where MD has
created an bank account instead of a liability or asset, I am doing
as you suggested and creating the correct account and batch
transferring, or importing, transactions into it.</p>
<p>Someone else must have run into these import problems. I
can’t be the only one that has twenty years of history in
Quicken. I understand MD cannot cover every situation but this
seems like a pretty basic one.</p>
<p>Back to the grindstone. I did this professionally. I worked for
nonprofits and for nearly every company, I either set them up with
accounting software or, went through a major conversion to new
software. Seems like nothing has changed in the ten years
I’ve been retired.</p>
<p>Thank you for your help.</p></div>dmcneillytag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-28T21:06:14Z2016-04-28T21:06:14Zmerge accts?<div><p>QIF files do not absolutely define account types.nor
differentiate between accounts and categories hence why it can be
problematic (the original expectation with QIF files is that the
accounts & categories would already be present.</p>
<p>One way of avoiding some of the problems is to import account
information only on the first pass, then correct anything that has
been incorrectly created, then performs the full import (do not
change any names however they must appear exactly as they do in the
QIF file or they will be recreated)</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-28T23:10:07Z2016-04-28T23:10:07Zmerge accts?<div><p>Now, I am chasing my tail as it were. Started with the big
accounts (6000+ entries), delete everything, re-import everything
to get a current and correct balance. Move on to the next account.
Eventually deleting transactions from some other account will
affect and account already done. Discrepancies are getting less and
less drastic but this is getting ridiculous. Missing all sorts of
stuff in the portfolio. Having to go through fourteen years, item
by item, comparing Q to MD.</p></div>dmcneillytag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-29T12:30:28Z2016-04-29T12:30:28Zmerge accts?<div><p>Sorry to hear about your frustrations!</p>
<p>Most customers are able to export their data from Quicken
without any issues. That being said, the QIF file format was never
really intended for transferring all data from Quicken to another
program and as such it can contains inherent ambiguities that may
need to be manually corrected post import. How much manual
correcting needs to be done is hard to predict, as the Quicken
export capabilities seem to vary with each version. Typically
investment accounts fair worse that regular accounts in this
matter.</p>
<p>If there any features you feel would help you through this
process, please advise and I can provide details of the necessary
functions, or can create a suggestion ticket for the feature.</p>
<p>Jenny<br>
Infinite Kind Support</p></div>Jennytag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-29T12:55:43Z2016-04-29T12:55:43Zmerge accts?<div><p>FWIW I migrated to MoneyDance some 4 years ago, with the version
I was coming from I had to do it account by account - some 70
accounts in the end in order to get the entire history.</p>
<p>Investment accounts were the main problem, partly because
Moneydance does not have all the investment actions, partially due
to the QIF filter in Moneydance ,and partially due to the fact that
some investment actions are not transactions at all.</p>
<p>The bottom line was that no matter what solution I went to a
considerable amount of work was needed, only by staying with
Quicken/Reckon could I avoid it. I felt that MoneyDance was the
best solution at the time (though not perfect and not complete) and
that it had the most promise for the future.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-29T14:29:49Z2016-04-29T14:29:49Zmerge accts?<div><p>Firstly, dwg, it's worth a lot to know someone has gone through
this AND stayed with MD. I actually got through the portfolio
yesterday and have correct, cost, current and cash. I don't really
understand yet the difference between register and bank register
but am just going to ignore the latter as it doesn't seem to impact
balances.</p>
<p>As I said above in post 4, now I am deleting transactions in
accounts where the balance is wrong, and re-importing the activity,
again. Problem is, of course, delete purchases with a credit
account and it throws asset accounts off. Really don't see how this
can end. If there were any way of seeing what other accounts change
when I delete transactions that might help but other than printing
the entire list of accounts with balances, I don't see any way of
doing that.</p></div>dmcneillytag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-29T14:43:32Z2016-04-29T14:43:32Zmerge accts?<div><p>What will happen if I make account A 'inactive',then delete
transactions in account B and it has splits that will affect
account A?</p></div>dmcneillytag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-29T21:05:21Z2016-04-29T21:05:21Zmerge accts?<div><p>Having a bank register in MD was implemented to allow for those
investment accounts that have the capability to be used like a bank
account for example to allow for the writing of Cheques.</p>
<p>It makes no difference if the account is inactive if you delete
a transaction in one account that is a transfer to an inactive
account the transaction is also removed from the inactive
account.</p>
<p>Often the reason for a wrong balance in an account is that no
initial balance has been set, sometimes this come over in a QIF
File as a transfer from a category or a hidden account in Quicken
sometimes it doesn't, I would not expect you to have to delete
legitimate transactions.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-04-29T22:19:46Z2016-04-29T22:19:46Zmerge accts?<div><p>Yes, I discovered the removal also happens. I am at a loss as to
how to fix these accounts. I have now lost the correct cash balance
in Portfolio.</p>
<p>I am also at a loss as to how to change a view. In portfolio
view, I have to have theMD window as wide as my screen allows
because the Security Name column is so wide I cannot see the
numbers columns. Is there something to turn on somewhere that
allows resizing of columns?</p></div>dmcneillytag:infinitekind.tenderapp.com,2009-01-14:Comment/397452172016-06-06T23:18:35Z2016-06-06T23:18:35Zmerge accts?<div><p>I am afraid it is not possible to manually resize the columns in
the portfolio view of an investment account.</p>
<p>Ben Spencer<br>
Infinite Kind Support</p></div>Ben Spencer