Account Reconciling: "As of Date" stuck in 2016
Hello,
Can you please make a change to the programming so that when I choose "Account" - "Reconcile" the "As of" date either shows the date that was last input into the field or it automatically displays today's date?
I use this function a lot and as per my attachment, the date always defaults to 25th October 2016. Why this date I am not sure.
I, therefore, have to type in the date that I want it to reconcile to manually every time and it would be an enhancement to either show the last date used in this field or today's date. This would then make the drop-down calendar more suitable to use as with the current configuration scrolling from 2016 to 2022 is not efficient.
Alternatively, please advise if there is a setting somewhere that I have missed that already changes this behaviour.
Many Thanks
Jason
-
Moneydance_Reconcile.png 17 KB
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
1 Posted by Stuart Beesley ... on 15 Apr, 2022 06:19 AM
Do you do ofx dc or md+ bank downloads on this account? Or file imports? If not, have you ever done so?
2 Posted by jeff_l on 15 Apr, 2022 09:41 AM
Not really an answer to your problem, but as a work around in the meantime, if you just type the letter T in the date field, it will take you instantly to today’s date.
Fellow user
3 Posted by Stuart Beesley ... on 15 Apr, 2022 09:47 AM
Can you run this script in moneybot, and post the results back here (but redact your account names)
Depending on the reason, you may or may not be able to adjust the date.... It's based on downloaded data:
- OFX Ledger date, ... then OFX last txn downloaded date, ... ... then the most recent download txn date (in all sub accounts).....
Easy to force off.. Harder to force set...
4 Posted by jason on 15 Apr, 2022 11:04 AM
@ Stuart Beesley,
I normally import QIF files into the accounts. I don't recall importing any other file tye into the accounts.
5 Posted by jason on 15 Apr, 2022 11:05 AM
@jeff_I
Perfect - that works for me as well. Many Thanks.
6 Posted by jason on 15 Apr, 2022 11:07 AM
@Stuart Beesley
I am not sure what "Moneybot" is.
7 Posted by Stuart Beesley ... on 15 Apr, 2022 11:09 AM
Download this py file, then Menu. Window. Show Moneybot Console. Click Open Script. Select the file. Click Run (not run snippet).
8 Posted by Stuart Beesley ... on 15 Apr, 2022 12:38 PM
FYI - I have just added this feature to Toolbox - Online Banking (OFX) Tools menu... The latest preview is here:
https://github.com/yogi1967/MoneydancePythonScripts/raw/master/tool...
(accept any signing warnings)
9 Posted by jason on 16 Apr, 2022 01:25 AM
Hi @ Stuart Beesley. I ran the first script and the following was output
Note that I am using DD/MM/YYYY format for dates
Account: 1 as_of enabled: True as_of end balance: 104450 *** as_of date: 25/10/2016 ***
..... OFXLedgerDate: 25/10/2016, OFXLastTxnDownoadDate: 09/10/2016 Most Recent Downloaded Txn Date: 14/04/2022
Account: 2 as_of enabled: True as_of end balance: 0 *** as_of date: 07/10/2021 ***
..... OFXLedgerDate: 01/01/1970, OFXLastTxnDownoadDate: 01/01/1970 Most Recent Downloaded Txn Date: 07/10/2021
Account: 3 as_of enabled: True as_of end balance: -851537 *** as_of date: 09/07/2019 ***
..... OFXLedgerDate: 09/07/2019, OFXLastTxnDownoadDate: 19/07/2019 Most Recent Downloaded Txn Date: 10/10/2021
Finished running normally at Sat Apr 16 09:22:13 AWST 2022
10 Posted by jason on 16 Apr, 2022 01:40 AM
As an update,
I imported an OFX into an account this morning, after running the above scripts and extensions from Stuart Beesley and when I selected "Reconcile" the "As at" date was shown as today's date.
I then deleted the imported transactions to test the behaviour with a QIF file, and the "As at" date was shown as today's date in the reconciliation dialogue box.
Not sure what the above scripts extensions may have done, however, I will report back in the next few days and advise if the behaviour is consistent.
Many Thanks
11 Posted by dwg on 16 Apr, 2022 02:20 AM
I believe that importing a OFX file would have updated the internal OFX date data, deleting the transactions would not have changed this.
I do not think that subsequent importing QIF files would change the as of date on the reconciliation screen I am thinking it will only be the import of OFX files that will impact this date.
12 Posted by Stuart Beesley ... on 16 Apr, 2022 04:51 AM
The script does nothing...
The OFX import will / might change the date depending on what it does... The purpose of my script is to tell you how the date is derived.
as_of date: this is what's shown on reconcile
OFXLedgerDate: if not, then if this is set, then this takes precedence
OFXLastTxnDownoadDate - then if not, if this is set, then this will be used.
Most Recent Downloaded Txn Date: Lastly, this is used.
Thus if OFXLedgerDate is set, then this overrides the date. If this was set by OFX DC download years ago then it might be stuck.
OFXLastTxnDownoadDate normally gets set by an OFX DC Download OR md+ download.
Most Recent Downloaded Txn Date: this comes off your transactions. The most recent one it finds. QIF may in fact set this...
So the way to test, is run the script (or now toolbox), do an import and see which fields change.
If the first two dates are stuck as you no longer download, this then you can manually zap these in toolbox. This would leave the last check on txn dates.
If old txn dates are the issue, then harder to fix.
Let me know?
13 Posted by kking18474 on 19 Apr, 2022 08:26 PM
Interested party here. Sorry for the hijack.
So Stuart you're saying there is no Zapping of the OFXLedgerDate?
That's where my problem lies
Account: Credit Card
as_of enabled: True
as_of end balance: -78124 ***
as_of date: 06/09/2018 ***
..... OFXLedgerDate: 06/09/2018,
OFXLastTxnDownoadDate: 03/15/2021
Most Recent Downloaded Txn Date: 04/04/2022
thanks,
KK
14 Posted by Stuart Beesley ... on 19 Apr, 2022 09:07 PM
Are you using ofx Dc downloads, md+, or manual file downloads/imports?
I think, toolbox, online banking tools, ‘ Delete single cached OnlineTxnList record/Txns’ might do the job.
Let me know?
15 Posted by kking18474 on 19 Apr, 2022 09:23 PM
This is an account where I used to use QFX, then the bank stopped offering it, and I've had to switch to manual imports of CSV. I think that my OFXLedgerDate is probably the last time I was able to download QFX for this account.
When I run the ‘ Delete single cached OnlineTxnList record/Txns’
i see an option for "Delete All 0 txns stored on this record"
or "Delete the whole OnlineTxnList record"
thanks for your help,
KK
16 Posted by Stuart Beesley ... on 19 Apr, 2022 09:23 PM
Select delete whole record. It’s fine to do.
17 Posted by kking18474 on 19 Apr, 2022 09:27 PM
Nevermind, only one option works when the option is 0 txns!
Thanks, it looks like this worked.
Account: Credit Card as_of enabled: True
as_of end balance: 0 *** as_of date: 04/04/2022 ***..... OFXLedgerDate: 12/31/1969, OFXLastTxnDownoadDate: 12/31/1969 Most Recent Downloaded Txn Date: 04/04/2022
KK
18 Posted by Stuart Beesley ... on 19 Apr, 2022 09:39 PM
Toolbox 🧰 +1 😃
19 Posted by jason on 19 Apr, 2022 11:50 PM
Hello @Stuart Beesley and @kking18474,
I imported some new activity into one of the accounts today (20th April) using a QIF file and the "OFXLedgerDate:" stayed as the last actual date that I performed an import (16th April) and the "OFXLastTxnDownloadDate:" remained as the last transaction date that I had imported (15th April). Accordingly, the "As Of" Date in the reconciling window stayed on 16th April.
I used the ToolBox to "Delete the whole OnlineTxnList record" (which I was apprehensive about given all of the warnings! :) ) and after doing this the "As Of" date in the reconciling window changed to the last downloaded transaction date.
So the "Deleting the whole Online TxnList record" worked perfectly.
Many thanks, Stuart
I am sure there are some reports in MD that have the same behaviour of the first date being a long time ago - I will post in here again when I find them and see if this Toolbox thing can assist.
Once again - many thanks
JT
20 Posted by Mark Bowen on 23 Apr, 2022 01:13 PM
Hi Stuart,
I owe you a beer (or non-alcoholic drink if you prefer)!
This problem has been bugging me for a few years on my Barclaycard account, which always defaulted to a date and balance in 2018.
Ran the toolbox and "Delete the whole OnlineTxnList record" worked perfectly, clearing the as_of end balance and OFXLedgerDate.
Many thanks,
Mark
21 Posted by Stuart Beesley ... on 23 Apr, 2022 01:20 PM
Toolbox 🧰 +1 🍺 +1 😃
System closed this discussion on 23 Jul, 2022 01:30 PM.