reconciling account issues

Charles McEniry's Avatar

Charles McEniry

25 Nov, 2022 08:25 PM

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.

  1. 1 Posted by Charles McEniry on 25 Nov, 2022 08:27 PM

    Charles McEniry's Avatar

    Also:

    I change the "as of" date to the current date but next time it reverts back to 8/25/2017.

  2. 2 Posted by Stuart Beesley ... on 25 Nov, 2022 08:49 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Use toolbox extn, online banking tools, diagnose as of date option to see why it’s doing this.

  3. 3 Posted by Charles McEniry on 25 Nov, 2022 09:43 PM

    Charles McEniry's Avatar

    Here's what toolbox shows.

  4. 4 Posted by Stuart Beesley ... on 26 Nov, 2022 10:54 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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. 5 Posted by Charles McEniry on 26 Nov, 2022 11:21 AM

    Charles McEniry's Avatar

    Before I attempt this, will I lose any data?  I do have a backup.

  6. 6 Posted by Stuart Beesley ... on 26 Nov, 2022 11:25 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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. 7 Posted by Charles McEniry on 26 Nov, 2022 11:44 AM

    Charles McEniry's Avatar

    Did not solve the problem..

  8. 8 Posted by Charles McEniry on 26 Nov, 2022 11:45 AM

    Charles McEniry's Avatar

    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. 9 Posted by Stuart Beesley ... on 26 Nov, 2022 11:49 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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. 10 Posted by Stuart Beesley ... on 26 Nov, 2022 11:50 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    .... 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. 11 Posted by Charles McEniry on 26 Nov, 2022 11:54 AM

    Charles McEniry's Avatar

    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. 12 Posted by Stuart Beesley ... on 26 Nov, 2022 11:59 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    .... and please right click that txn and select show record details and post the details here..?

    Thx

  13. 13 Posted by Charles McEniry on 26 Nov, 2022 12:01 PM

    Charles McEniry's Avatar

    I have tried several times to right click and show details but nothing
    happens.

  14. 14 Posted by Charles McEniry on 26 Nov, 2022 12:03 PM

    Charles McEniry's Avatar

    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. 15 Posted by Stuart Beesley ... on 26 Nov, 2022 12:08 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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. 16 Posted by Charles McEniry on 26 Nov, 2022 12:22 PM

    Charles McEniry's Avatar

    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. 17 Posted by Stuart Beesley ... on 26 Nov, 2022 12:29 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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. 18 Posted by Stuart Beesley ... on 26 Nov, 2022 12:43 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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. 19 Posted by Charles McEniry on 26 Nov, 2022 12:45 PM

    Charles McEniry's Avatar

    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. 20 Posted by Charles McEniry on 26 Nov, 2022 12:53 PM

    Charles McEniry's Avatar

    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. 21 Posted by Stuart Beesley ... on 27 Nov, 2022 10:55 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    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. 22 Posted by Charles McEniry on 27 Nov, 2022 11:12 AM

    Charles McEniry's Avatar

    You're absolutely right.  The date really doesn't matter.  Thanks again
    for your help.

  23. 23 Posted by Stuart Beesley ... on 27 Nov, 2022 11:35 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    So. If you untick the box it will stay unticked.

  24. 24 Posted by Charles McEniry on 27 Nov, 2022 12:02 PM

    Charles McEniry's Avatar

    Yes.  Thanks.

    Much easier to deal with now that I understand what's going on.

    You've been very helpful.

  25. Maddy closed this discussion on 27 Nov, 2022 01:41 PM.

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