Converting from (Mac) Quicken 2005

bhull's Avatar

bhull

05 Jun, 2011 07:36 AM

Have just imported Quicken for Mac (2005) QIF into Moneydance (791). Most of the accounts came thru just fine. Some had weird balances (the last several years of data is good, so I just "adjusted" the balance to be correct now).

The only thing left right now is that the pull-down menu item "Home" shows a value of about $671,000, and the corresponding account register shows the correct value of about $297,000. Is there a way to reset the pull-down value?

Thanks,
Brad.

  1. 1 Posted by paleolith on 05 Jun, 2011 07:04 PM

    paleolith's Avatar

    Brad,

    Congrats on the conversion! I'm not sure what you mean by "Home". Possibly I'm seeing different labels just from having used MD for several years and therefore starting with different defaults. Perhaps a little more detail would help. (Or perhaps someone else will see what I missed.)

    Edward

  2. 2 Posted by bhull on 05 Jun, 2011 11:25 PM

    bhull's Avatar

    Sorry 'bout that - "Home" is just an account name. See screenshot below. All the other accounts in the left column "mirror" the final account value.
    Thanks for responding,
    Brad.

  3. 3 Posted by -Kevin N. on 06 Jun, 2011 12:47 AM

    -Kevin N.'s Avatar

    Hi Brad,
    Access the 'Home' account then click on the 'Balance' in the lower right-hand corner of the register. See if any of those different balances sheds any light on the issue.
    HTH -Kevin N.

  4. 4 Posted by paleolith on 06 Jun, 2011 02:03 AM

    paleolith's Avatar

    That was my thought. In particular, if you are showing "cleared balance", and if "Home" is an asset representing your residence, then probably most of the items in the account are not cleared. Just plain "balance" is what you want in this case, which means all transactions, past and future, cleared or not.

    Edward

  5. 5 Posted by bhull on 06 Jun, 2011 02:07 AM

    bhull's Avatar

    Tried that: didn't see any combination of balances that equals the left column number. All of the balances in the account are even dollars - no cents, but the summary has 28 cents on it. Maybe I'm not understanding your suggestion. The 297,263.00 is the current (latest) balance.
    Brad.

  6. 6 Posted by paleolith on 06 Jun, 2011 03:17 AM

    paleolith's Avatar

    Sorry. We are talking about the "balance" in the lower right corner of the window. It looks like a button, but click on it and you get three options (see attachment).

    But ... you say "all the balances ... are even dollars". Do you mean that every item (transaction) in the account is even dollars? If so, then this is clearly a bug. And that 28 cents rings a distant bell in my mind, as though it were once a sign of some error, but at the moment I can't dredge up any more of that memory.

    Back to your original question about a "reset", no, there is no way to force a recalculate. In any case, I'm pretty sure that MD is calculating this on the fly anyway. If the balance in the bottom right corner is set to just "balance" (not cleared or current), then it should always exactly match the sidebar balance.

    Oh, there is an exception -- investment accounts. This isn't an investment account, is it? For investment accounts, the lower right balance shows the cash balance in the investment account (which is usually zero) and the sidebar shows the current value of the account (based when applicable on downloaded stock and bond prices).

    Yet another exception: when an account is the parent for other accounts, the sidebar shows the total of the balances for all the child accounts, where the bottom right shows the balance only for the parent account, which is usually zero (since most people don't put transactions directly in parent accounts). But from the sidebar in your screen shot, I'm pretty sure that your HOME account is a stand-alone account, not a parent.

    I just went through all the accounts I'm displaying in my sidebar, and those were the only exceptions I found.

    Edward

  7. 7 Posted by bhull on 06 Jun, 2011 03:50 AM

    bhull's Avatar

    OK, got it! See screenshot below.
    Yes, every transaction in the account is even dollars - screenshot below shows all ten transactions in the account.
    No, it is not an investment acct. Each year I just add (or subtract) a value that brings the balance to the tax appraiser's "valuation".
    Yes, the HOME account is a stand-alone account, not a parent.

    This is obviously not a critical issue - the only bad effect would be if I wanted to know my "net worth", and I can do that manually. Perhaps we have used enuf "manpower" on this . . . if you do come up with something, though, I'd certainly like to hear about it!

    Thanks for your time and effort - I do appreciate it. If there's any info I can supply, please let me know - I'll be happy to help.

    Regards,
    Brad.

  8. 8 Posted by paleolith on 06 Jun, 2011 04:41 AM

    paleolith's Avatar

    Clearly a calculation bug then. Hopefully MD support will pick up on this thread (since it's already in the "problems" board) and create a trouble ticket for it. Even though as you say it's not a big deal for you, any calculation bug needs to be fixed.

    BTW, I could not reproduce it. I created a new asset account and entered ten transactions, in the order and amounts that you had, and the sidebar total is correct. So there's something odd affecting your setup, but I have no more clues as to what it is.

    Edward

  9. 9 Posted by Ben Spencer on 08 Jun, 2011 07:03 PM

    Ben Spencer's Avatar

    if you would be willing to privately email me a copy of your .md file I will run the software in a debugger and see exactly where the number is coming form in the sidebar. You could copy your .md data file and delete all the accounts other than the HOME account.

    You can reach me with ben @ moneydance.com

    Ben Spencer
    Moneydance Support

  10. 10 Posted by bhull on 08 Jun, 2011 09:31 PM

    bhull's Avatar

    Thanks for the offer, Ben, but I think I've spent too much time on this with no end in sight. There are too many accounts that come up with different balances, and when I try to correct them, other accounts are affected. Maybe I'll try again someday . . .
    Thanks for all the efforts of your support group. I'll unsubscribe now.
    Brad.

  11. bhull closed this discussion on 08 Jun, 2011 09:43 PM.

Comments are currently closed for this discussion. You can start a new one.

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