Adjustment Transaction

frank's Avatar

frank

07 Dec, 2018 01:51 AM

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.

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..

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?

Thanks,
Frank

  1. 1 Posted by dwg on 07 Dec, 2018 03:07 AM

    dwg's Avatar

    I'm a fellow user.

    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.

    It is impossible to make one sided entries in Moneydance due to it using accounting rules.

    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.

  2. 2 Posted by -Kevin N. on 07 Dec, 2018 03:23 AM

    -Kevin N.'s Avatar

    Hi Frank,

    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.
    (While viewing the account > MD menu bar > Account > Edit Account)

    -Kevin N. (not a member of MD support)

  3. 3 Posted by frank on 07 Dec, 2018 03:34 PM

    frank's Avatar

    Okay, I kinda get it,.but......

    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.

    Am I on the right track?

    Thanks guys for the input.
    Frank

  4. 4 Posted by dwg on 07 Dec, 2018 07:32 PM

    dwg's Avatar

    Same effect.

    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.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac