tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/91084-issue-with-md-not-updating-the-last-reconciled-dateInfinite Kind: Discussion 2023-07-10T20:13:52Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-06T03:33:24Z2023-06-06T03:33:24ZIssue With MD Not Updating the Last Reconciled Date<div><p>Making private.</p></div>Joe_Htag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-06T03:38:00Z2023-06-06T03:38:00ZIssue With MD Not Updating the Last Reconciled Date<div><p>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.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-06T04:24:02Z2023-06-06T04:24:02ZIssue With MD Not Updating the Last Reconciled Date<div><p>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.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-06T04:26:49Z2023-06-06T04:26:49ZIssue With MD Not Updating the Last Reconciled Date<div><p>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.</p>
<p>Run toolbox. Online banking tools. Diagnose as_of dates and upload the output here.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-06T15:42:31Z2023-06-06T15:42:31ZIssue With MD Not Updating the Last Reconciled Date<div><p>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:</p>
<h2><a name="ofx-view-accounts-39-calculated-reconcile-39-as_of-39-dates-" class="anchor" href="#ofx-view-accounts-39-calculated-reconcile-39-as_of-39-dates-"></a>OFX - VIEW ACCOUNTS' CALCULATED RECONCILE 'AS_OF' DATES</h2>
<p>NOTE: Multiple OFXLastTxnUpdate dates (i.e. per OFX/MD+ connection) are possible with this build...</p>
<p>Processing 18 active accounts</p>
<p>Diagnosing the Reconcile: as_of date:</p>
<p>Account: BofA Checking - J (9876)<br>
as_of enabled: True calculated 'as_of' date: 10/25/2022 as_of end balance: $ 1,000.6 as_of Preference: 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</p>
<p>Account: BofA Checking - R (7890)<br>
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</p>
<p>Account: BofA MM - J (4567)<br>
as_of enabled: True calculated 'as_of' date: 10/25/2022 as_of end balance: $ 1000.68 as_of Preference: 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</p>
<p>Account: BofA MM - R (5789)<br>
as_of enabled: True calculated 'as_of' date: 10/25/2022 as_of end balance: $ 1000.44 as_of Preference: 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</p>
<p>Account: BofA Visa (1234)<br>
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</p>
<p>To zap the OFXLedgerDate, use Toolbox>Online Banking Tools Menu<br>
option 'Delete Single cached OnlineTxnList Record/Txns' and then the option 'delete whole record'</p>
<p>To change OFXLastTxnDownloadDate, use Toolbox>Update OFX Last Txn Update Date (Downloaded) field for an account<br>
and edit the date (or if available Toolbox>Reset ALL OFX Last Txn Update Dates)</p>
<p>If 'Most Recent Downloaded Txn Date' shown then not a lot can be done. You have previously downloaded txns</p>
<p>Regards,</p>
<p>Joe</p></div>Joe_Htag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-06T16:44:24Z2023-06-06T16:44:24ZIssue With MD Not Updating the Last Reconciled Date<div><p>Try this..</p>
<p>BACKUP FIRST</p>
<p>Toolbox, update mode, online banking tools,<br>
Delete Single cached OnlineTxnList record/txns.<br>
Delete the whole record.</p>
<p>I suspect the date will move to 6/1/23. Let me know.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-07T03:10:07Z2023-06-07T03:10:07ZIssue With MD Not Updating the Last Reconciled Date<div><p>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.</p></div>Joe_Htag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-07T05:22:55Z2023-06-07T05:22:55ZIssue With MD Not Updating the Last Reconciled Date<div><p>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.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-07T21:22:29Z2023-06-07T21:22:29ZIssue With MD Not Updating the Last Reconciled Date<div><p>OK, I just added a feature to Toolbox called:<br>
"Added "Remove (hidden) downloaded OFX/MD+ data from Transactions within an Account" feature".</p>
<p>Get the latest PREVIEW from here:<br>
<a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p>
<p>BACKUP first.</p>
<p>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..</p>
<p>It does not affect your balances, just removes or disables the hidden data....</p>
<p>Let me know if you try it out..?</p>
<p>Again, BACKUP FIRST!</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-06-19T05:34:48Z2023-06-19T05:34:48ZIssue With MD Not Updating the Last Reconciled Date<div><p>@joe - did you try this?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-07-08T02:29:52Z2023-07-08T02:29:52ZIssue With MD Not Updating the Last Reconciled Date<div><p>@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.</p></div>Joe_Htag:infinitekind.tenderapp.com,2009-01-14:Comment/591375222023-07-08T06:39:18Z2023-07-08T06:39:18ZIssue With MD Not Updating the Last Reconciled Date<div><p>👍 ✅ Toolbox 🧰 +1 😃</p></div>Stuart Beesley (Mr Toolbox)