Account problems

Cheryl Wong's Avatar

Cheryl Wong

21 Jun, 2021 03:57 AM

I have been using Moneydance since 2018 (from Quicken) and have been very happy with it. Recently I recorded some credit card transactions. I have two credit cards and one of them has reversed all of the payments to repayments and vice versa (for the whole of its history). The first thing to say is that I am not connected to a bank and reconcile all of my accounts manually. That is, I don't download transactions from my bank. I notice that this reversal has occurred in the past when downloading from a bank, but that is not the case here. The only change that I can think of is that on the credit card account in question, I changed the card number. However, I can't see how this would cause a problem. My other credit card account is fine and I have checked that all of the settings are the same for both accounts. My solution has been to open a new credit card account for the new card. However, I don't want to manually transfer many hundreds of transactions from over the past 10 years. Is there a solution out there?

  1. 1 Posted by Stuart Beesley ... on 21 Jun, 2021 06:55 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    I’ve never heard of a situation where the sign has been reversed on all txns (out of nowhere). Is this what you are saying? Ie all payments and credits have reversed? I dont have an suggestions other than, restart MD, check you are really viewing the account register and not a category register, and check your (Help) console for errors.

    My preference would be to restore a backup and go from there.

    However, the toolbox (manage) extension(s) has an option to reverse the sign on txns within an account between dates. If you really want, you can try this. Backup first. Menu advanced mode. Transaction menu:

    • Reverse Transaction Amounts between dates (reverse_txn_amounts.py)

    Thoroughly check results. If not happy, use file, restore from backup.

    (Not support, just a fellow user)

  2. 2 Posted by Stuart Beesley ... on 21 Jun, 2021 06:56 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    PS. Toolbox only works on MD2021.1(3069). Are you on this version?

  3. 3 Posted by Stuart Beesley ... on 21 Jun, 2021 06:58 AM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    If not, and you are on a lower version, please ask support to provide the script called: reverse_txn_amounts.py. They will have to provide guidance on this for you.

    (Not support, just a fellow user)

  4. 4 Posted by derekkent23 on 21 Jun, 2021 07:11 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Cheryl

    in addition to Stuarts comments on fixing existing transactions you could try the following for newly download transactions

    I would do a FILE (MONEYDANCE on Mac) – EXPORT BACKUP and then RESTORE FROM BACKUP to try out the following. If it works you can switch back to your original data set using FILE (MONEYDANCE on Mac) – OPEN.

    Under FILE (MONEYDANCE on Mac) – PREFERENCES – NETWORK – and tick IGNORE TRANSACTION TYPES IN FAVOR AMOUNT SIGNS.
    Download all your accounts and check if all the newly downloaded transactions are correct.

    Hope this helps.

  5. 5 Posted by Cheryl Wong on 21 Jun, 2021 08:27 AM

    Cheryl Wong's Avatar

    Thanks for these suggestions. I have tried some of them without success. Will try backup tomorrow and let you know.

  6. 6 Posted by Cheryl Wong on 26 Jun, 2021 12:13 PM

    Cheryl Wong's Avatar

    Hi everyone! Thanks so much for all your help. It turned out that I didn't have the latest version, so upgraded to that, and installed the updater extension and the toolbox extension. After that, and then looking more closely at the account from the beginning onwards, I think what had happened is that somehow the credit card account had lost its initial debt value and thus all the transactions looked wrong. Everything else was a red herring - sincere apologies to all. I really appreciate all the helpful suggestions.

  7. 7 Posted by Stuart Beesley ... on 26 Jun, 2021 12:52 PM

    Stuart Beesley - JUST A FELLOW USER and Toolbox ‘guy’'s Avatar

    👍 That makes more sense.. Glad you sorted it!

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