Home → Problems →

Issue With MD Not Updating the Last Reconciled Date

• Edit

Joe_H

06 Jun, 2023 03:31 AM

I'm running MD 2023.2 (5007) and am having an issue with five MD accounts always using the date As of: 10/25/22. My belief is that when I reconcile the accounts each month that the default reconcile date changes to be a current date. All of the accounts other than these five behave correctly.

One thing that's different with these five accounts (2 Checking, 2 Savings, and one Credit Card) is that they're with Bank of America. Bank of America used to support Direct Connect, but they dropped support right around the time in question here. So now I am downloading the QIF file from BofA and importing them. I have deleted the connection settings for each of the accounts in Toolbox so MD would no longer try to connect.

Using <ctrl>+t does get the date to the current date, but it's still an annoyance that behaves differently then any of the other accounts.

• Reconcile_As_of.jpg 110 KB

1. 1 Posted by Joe_H on 06 Jun, 2023 03:33 AM

   

   Making private.

   • Edit

2. 2 Posted by dwg on 06 Jun, 2023 03:38 AM

   

   Downloaded QIF files are unable to be used to update the "As of Date" as they do not contain the information that would allow Moneydance to do so.

   • Edit

3. 3 Posted by dtd on 06 Jun, 2023 04:24 AM

   

   just a user - this is still public if you want to make it private, but you can get help from users like dwg if you do not do so.

   • Edit

4. 4 Posted by Stuart Beesley ... on 06 Jun, 2023 04:26 AM

   

   If 10/25/22 is the date of your last ofx download then you’re probably snookered. That date will be on your txns and that is where it’s where it’s coming from.

   Run toolbox. Online banking tools. Diagnose as_of dates and upload the output here.

   • Edit

5. 5 Posted by Joe_H on 06 Jun, 2023 03:42 PM

   

   Thanks for the reply, Stuart. Here’s the output, which I sanitized for content, and just listed the affected accounts. All of the other accounts had dates that looked fine:

   OFX - VIEW ACCOUNTS' CALCULATED RECONCILE 'AS_OF' DATES
   -------------------------------------------------------

   NOTE: Multiple OFXLastTxnUpdate dates (i.e. per OFX/MD+ connection) are possible with this build...

   Processing 18 active accounts

   Diagnosing the Reconcile: as_of date:

   Account: BofA Checking - J (9876)
      as_of enabled: True
      calculated 'as_of' date: 10/25/2022
      as_of end balance: $ 1,000.6
            as_of Preference: <not set>
            OFXLedgerDate: 10/25/2022
            Most Recent Downloaded Txn Date: 06/01/2023 (715 txns)
            Most recent OFXLastTxnUpdateDate: 10/24/2022
            ... Multi keys found: 10/24/2022 ofx_last_txn_update

   Account: BofA Checking - R (7890)
      as_of enabled: True
      calculated 'as_of' date: 10/25/2022
      as_of end balance: $ 1,000.23
            as_of Preference: True
            OFXLedgerDate: 10/25/2022
            Most Recent Downloaded Txn Date: 06/01/2023 (410 txns)
            Most recent OFXLastTxnUpdateDate: 10/24/2022
            ... Multi keys found: 10/24/2022 ofx_last_txn_update

   Account: BofA MM - J (4567)
      as_of enabled: True
      calculated 'as_of' date: 10/25/2022
      as_of end balance: $ 1000.68
            as_of Preference: <not set>
            OFXLedgerDate: 10/25/2022
            Most Recent Downloaded Txn Date: 04/18/2023 (102 txns)
            Most recent OFXLastTxnUpdateDate: 10/19/2022
            ... Multi keys found: 10/19/2022 ofx_last_txn_update

   Account: BofA MM - R (5789)
      as_of enabled: True
      calculated 'as_of' date: 10/25/2022
      as_of end balance: $ 1000.44
            as_of Preference: <not set>
            OFXLedgerDate: 10/25/2022
            Most Recent Downloaded Txn Date: 04/18/2023 (87 txns)
            Most recent OFXLastTxnUpdateDate: 10/19/2022
            ... Multi keys found: 10/19/2022 ofx_last_txn_update

   Account: BofA Visa (1234)
      as_of enabled: True
      calculated 'as_of' date: 10/25/2022
      as_of end balance: $ -1000.25
            as_of Preference: True
            OFXLedgerDate: 10/25/2022
            Most Recent Downloaded Txn Date: 06/01/2023 (365 txns)
            Most recent OFXLastTxnUpdateDate: 10/22/2022
            ... Multi keys found: 10/22/2022 ofx_last_txn_update

   To zap the OFXLedgerDate, use Toolbox>Online Banking Tools Menu
                             option 'Delete Single cached OnlineTxnList Record/Txns'
                             and then the option 'delete whole record'

   To change OFXLastTxnDownloadDate, use Toolbox>Update OFX Last Txn Update Date (Downloaded) field for an account
                             and edit the date (or if available Toolbox>Reset ALL OFX Last Txn Update Dates)

   If 'Most Recent Downloaded Txn Date' shown then not a lot can be done. You have previously downloaded txns

   <END>

   Regards,

   Joe

   • Edit

6. 6 Posted by Stuart Beesley ... on 06 Jun, 2023 04:44 PM

   

   Try this..

   BACKUP FIRST

   Toolbox, update mode, online banking tools,
   Delete Single cached OnlineTxnList record/txns.
   Delete the whole record.

   I suspect the date will move to 6/1/23. Let me know.

   • Edit

7. 7 Posted by Joe_H on 07 Jun, 2023 03:10 AM

   

   I performed the modification on each of the accounts and as you predicted, the date for reconcile is now 6/1/23. I'm guessing that going forward the as of date will now be the first of the month where I perform the reconcile, or will it update based on the last reconcile? Thanks for the help.

   • Edit

8. 8 Posted by Stuart Beesley ... on 07 Jun, 2023 05:22 AM

   

   Nope. It’s now using the date of the last downloaded txn, so you are snookered. I need to write a fix which would allow you to nuke the downloaded data flags to get around this. But I can’t tackle that right now. Sorry.

   • Edit

9. Joe_H closed this discussion on 07 Jun, 2023 03:29 PM.

10. Stuart Beesley (Mr Toolbox) re-opened this discussion on 07 Jun, 2023 09:22 PM

11. 9 Posted by Stuart Beesley ... on 07 Jun, 2023 09:22 PM

    

    OK, I just added a feature to Toolbox called:
    "Added "Remove (hidden) downloaded OFX/MD+ data from Transactions within an Account" feature".

    Get the latest PREVIEW from here:
    https://yogi1967.github.io/MoneydancePythonScripts/

    BACKUP first.

    It allows you to remove (or disable) the downloaded data within an account, which will have the effect that the as_of date is nullified..

    It does not affect your balances, just removes or disables the hidden data....

    Let me know if you try it out..?

    Again, BACKUP FIRST!

    • Edit

12. 10 Posted by Stuart Beesley ... on 19 Jun, 2023 05:34 AM

    

    @joe - did you try this?

    • Edit

13. 11 Posted by Joe_H on 08 Jul, 2023 02:29 AM

    

    @Stuart Sorry, I seem to have completely missed this after I closed the issue. I updated Toolbox and ran the new script. It completely removed the downloaded data and now when I reconcile, there is no date listed. Thanks, and sorry I missed this and it took so long to get back to you.

    • Edit

14. 12 Posted by Stuart Beesley ... on 08 Jul, 2023 06:39 AM

    

    👍 ✅ Toolbox 🧰 +1 😃

    • Edit

15. Maddy closed this discussion on 10 Jul, 2023 08:13 PM.