reconciling account issues
Charles McEniry
This has been going on now for several years. When I go to reconcile my checking account, the "as of" feature always shows 8/25/2017. It does not populate with current date.
When I reconcile my credit card, the current date shows up in the field.
-
checking-screenshot.png
28.2 KB
checking-screenshot.png
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 Charles McEniry on Nov 25, 2022 @ 08:27 PM
Also:
I change the "as of" date to the current date but next time it reverts back to 8/25/2017.
2 Posted by Stuart Beesley ... on Nov 25, 2022 @ 08:49 PM
Use toolbox extn, online banking tools, diagnose as of date option to see why it’s doing this.
3 Posted by Charles McEniry on Nov 25, 2022 @ 09:43 PM
Here's what toolbox shows.
4 Posted by Stuart Beesley ... on Nov 26, 2022 @ 10:54 AM
OK, this area is quite complicated to diagnose... But I think I have the fix for you. I assume that you are NOT currently downloading to this account?
Toolbox, enable update mode, online banking tools menu.
'Delete Single cached OnlineTxnList Record/Txns' Select your account
'CHANGE: DELETE the whole OnlineTxnList record' (don't worry, this is harmless)
Try reconcile again and see if it worked?
If it did not, then please rerun the toolbox/diagnose as_of dates and we'll see if there's another step to follow.
?
5 Posted by Charles McEniry on Nov 26, 2022 @ 11:21 AM
Before I attempt this, will I lose any data? I do have a backup.
6 Posted by Stuart Beesley ... on Nov 26, 2022 @ 11:25 AM
Nope. It’s extremely safe. But anyway, when you select the option it will ask if you want to do a backup first, so say yes.
Or just do file/export backup manually.
7 Posted by Charles McEniry on Nov 26, 2022 @ 11:44 AM
Did not solve the problem..
8 Posted by Charles McEniry on Nov 26, 2022 @ 11:45 AM
I tried unticking and ticking "as of" box and manually entering today's
date. Reverts back to the 8/25/2017 date every time.
9 Posted by Stuart Beesley ... on Nov 26, 2022 @ 11:49 AM
Thought not!
Can you find the transaction dated 08/25/2017 and then right click and Show Transaction details.... then find the one after this and do the same... Post results here..
I'm assuming you used to download txns up until that date? Do you know if you have a lot of these or just one or two?
10 Posted by Stuart Beesley ... on Nov 26, 2022 @ 11:50 AM
.... I can provide a little script that will 'erase' the flag that tells MD that a txn was downloaded, which will 'fix' this issue..?
11 Posted by Charles McEniry on Nov 26, 2022 @ 11:54 AM
My bank is not set up to download to MD. I have always had to manually
enter transactions. When the bank statement closes, I then go to
reconcile the checking account.
I have just one transaction dated 8/25/2017.
For what it's worth, the bank statement closes around the 20th or each
month. I reconcile on that day usually. It is puzzling why the 8/25
date would be entered since that is not a closing date.
12 Posted by Stuart Beesley ... on Nov 26, 2022 @ 11:59 AM
.... and please right click that txn and select show record details and post the details here..?
Thx
13 Posted by Charles McEniry on Nov 26, 2022 @ 12:01 PM
I have tried several times to right click and show details but nothing
happens.
14 Posted by Charles McEniry on Nov 26, 2022 @ 12:03 PM
Figured it out. I changed to single line mode and got the following:
0.acct: 36
0.acctid: c2423177-f43a-4bc8-9cd6-fd847c87d5ac
0.desc: Alliant - WPL
0.id: 5abaefff-debd-45bb-95f3-9208bcf4d4d7
0.obj_type:
0.oldid: -1
0.pamt: -3463
0.samt: 3463
0.tags:
acct: 1
acctid: 8b08e2df-6b8d-4c53-8fae-969fcf0e1c03
chk:
desc: Alliant - WPL
dt: 20170825
dtentered: 1504266968349
id: b855c840-3749-4247-9bca-492ecfe65b25
memo: PREAUTHORIZED DEBIT Alliant - WPL PAYMENT 170825
netsync.txnid: a558de7c-2bcd-44d6-9276-d7e792136101
obj_type: txn
ol.match-status: n
ol.match-type: 0
ol.orig-memo: PREAUTHORIZED DEBIT Alliant - WPL PAYMENT 170825
ol.orig-payee: Alliant - WPL
ol.orig-txn: {
"dtinit-int" = "20170825"
"name" = "Alliant - WPL"
"amt" = "-3463"
"fitxnid" = "D = 08/25/2017; M = PREAUTHORIZED DEBIT Alliant - WPL
PAYMENT 170825; P = Alliant - WPL; T = -34.63; "
"dtpstd-int" = "20170825"
"fi_id" = "qif"
"dtavail-int" = "20170825"
"memo" = "PREAUTHORIZED DEBIT Alliant - WPL PAYMENT 170825"
"chknum" = ""
"ptype" = "2"
}
ol_fi_id: qif
ol_fitid_2: D = 08/25/2017; M = PREAUTHORIZED DEBIT Alliant - WPL
PAYMENT 170825; P = Alliant - WPL; T = -34.63;
oldid: -1
rec_asof: 20170920
rec_dt: 1506001827339
stat: X
td: 20170825
ts: 1506001827349
15 Posted by Stuart Beesley ... on Nov 26, 2022 @ 12:08 PM
OK, so this was a QIF import....
Do you have earlier txns imported by QIF?
Anyway, try this... Right click again and DUPLICATE.... put a marker in the cheque field on the new txn that appears so you know which one is the new one.
Then delete the old txn
Then you may need to right click the new txn and select Mark as Cleared (if it was already cleared) to not throw out your reconciling balances.
Then try reconcile again... If the date is still wrong, send a new toolbox/diag as_of dates
16 Posted by Charles McEniry on Nov 26, 2022 @ 12:22 PM
Now the reconcile as of date is 8/23/2017.
There was a time when I would download bank data and then import it to
MD. Can't remember when I stopped doing it this way. It's easier now
to post transactions as they occur. Do you think MD is remembering the
last as of date based on the last time I imported data? Maybe the as of
date is not something I can override.
17 Posted by Stuart Beesley ... on Nov 26, 2022 @ 12:29 PM
As I said, I need to give you a script that removes the online download flag on all the old txns that were imported via QIF.. Then the date will disappear....
BUT..... When MD thinks that the account is not an online account then then asof option will disappear...
So.... what do you want to do/try?
18 Posted by Stuart Beesley ... on Nov 26, 2022 @ 12:43 PM
The (slightly flawed) thinking by MD on this is that when you download txns, then the as_of is enabled with a date and txns get auto marked as reconciling.... But when you are not downloading and entering manual txns, then there is no way to know the auto as_of date and perhaps you have txns missing, so you have to do it all the hard way..
Of course it goes wrong, when you change methods, like you have...
I can think of one possible 'fix', Toolbox could set a date into the future (e.g. 31/12/2099) and then the asof will be enabled and prepopulated with that date. Of course, if you have more recent txns than your bank balance, then you will get txns marked as reconciling when you didn't want them...
??
19 Posted by Charles McEniry on Nov 26, 2022 @ 12:45 PM
It might be easiest to just let it be. I can always manually enter a date
The as of date really should be based on the last time the account was
reconciled and independent of how or when data is downloaded or entered.
For now I'll live with it. Thanks for your help.
20 Posted by Charles McEniry on Nov 26, 2022 @ 12:53 PM
When I enter data manually, I tick reconciling right away.
I download credit card data daily. I also tick reconciling manually for
each transaction. This might explain why the as of date is current when
I deal with this data.
MD is a slick program and I have been enjoying it much over the years.
Lots of hard work to keep everyone happy, I'm sure. Thanks again for
your help, thoughts and efforts.
21 Posted by Stuart Beesley ... on Nov 27, 2022 @ 10:55 AM
Having thought about this a lot overnight. The asof date must be useless in your scenario. There is simply no point setting the date as it only auto marks txns as reconciling (up to the asof date) when they are downloaded. If you are entering manual txns then it has no effect.
So what use do you have for the date?
22 Posted by Charles McEniry on Nov 27, 2022 @ 11:12 AM
You're absolutely right. The date really doesn't matter. Thanks again
for your help.
23 Posted by Stuart Beesley ... on Nov 27, 2022 @ 11:35 AM
So. If you untick the box it will stay unticked.
24 Posted by Charles McEniry on Nov 27, 2022 @ 12:02 PM
Yes. Thanks.
Much easier to deal with now that I understand what's going on.
You've been very helpful.
Maddy closed this discussion on Nov 27, 2022 @ 01:41 PM.