tag:infinitekind.tenderapp.com,2009-01-14:/discussions/switching-from-another-personal-finance-program/11757-adjustment-transactionInfinite Kind: Discussion 2019-03-08T19:40:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/466303362018-12-07T01:51:58Z2018-12-07T01:52:01ZAdjustment Transaction<div><p>I am trying to migrate maybe 25 years of data from Quicken to Moneydance and so far I'm doing good. I discovered that importing the accounts and data at the same time seemed to mix the transactions across wrong accounts. By importing the accounts first and then importing the data for each account one at a time it works pretty good.</p>
<p>However, I'm having trouble adding adjustment transactions in an investment account. Short stock and option sales don't work right in Moneydance (or Quicken or MS Money) so occasionally I have to adjust..</p>
<p>So in the Register when I try and enter an adjustment the only "action" that's similar is "MiscExp". OK I can live with that, but it seems to insist on a security entry. If I leave it blank it keeps filling-in with AT&T Corp. I just want adjust my cash balance, what am I doing wrong?</p>
<p>Thanks,<br>
Frank</p></div>franktag:infinitekind.tenderapp.com,2009-01-14:Comment/466303362018-12-07T03:07:31Z2018-12-07T03:07:31ZAdjustment Transaction<div><p>I'm a fellow user.</p>
<p>MiscExp and MiscInc transaction in Moneydance always relate to a specific security, hence the need to select one hence the transaction is recorded as an income or an expense item against that security and either increase or reduce the cash balance in the Investment account. Moneydance uses accounting rules as its basis hence why there is two sides to the transaction, once side here relates to the impact on the cash balance the other is the security that is involved.</p>
<p>It is impossible to make one sided entries in Moneydance due to it using accounting rules.</p>
<p>If you need to adjust a balance in moneydance it is necessary to follow the rules to make it happening. One way of doing this is to create a category, you could call it something like "Investment Adjustments" then use an XFR transaction in the investment account to adjust the balance and using the adjustment category as the transfer source/destination.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/466303362018-12-07T03:23:54Z2018-12-07T03:23:54ZAdjustment Transaction<div><p>Hi Frank,</p>
<p>If you only need to make a 'one-time' or a 'not-too-often' adjustment to the cash balance, you can do so by entering or editing the 'Initial Balance' value in the account's properties form.<br>
(While viewing the account > MD menu bar > Account > Edit Account)</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/466303362018-12-07T15:34:21Z2018-12-07T15:34:23ZAdjustment Transaction<div><p>Okay, I kinda get it,.but......</p>
<p>If I click on "Bank Register" in my same investment account I can easily add a transaction with a category of adjustment without any description. And it seems to put that transaction into the "Register" as I originally wanted. Seems simple, Maybe this is what dwg was talking about except I seem to already have a category called "adjustment" so no need to make a new one.</p>
<p>Am I on the right track?</p>
<p>Thanks guys for the input.<br>
Frank</p></div>franktag:infinitekind.tenderapp.com,2009-01-14:Comment/466303362018-12-07T19:32:20Z2018-12-07T19:32:20ZAdjustment Transaction<div><p>Same effect.</p>
<p>I was thinking of how to do it in Moneydance before Investment accounts had a Bank Register, so in other words how to do it from the Securities register.</p></div>dwg