Add the ability to add or remove transactions from a reconcile period [Edited]

Background:
Citi has this malfunction (i.e. bug) with downloaded transactions. Sometimes a tranaction will be assigned a posted date but later it will be changed; however the original posted date remains in the downloaded transaction even after the statement is generated. The creates a problem with Quicken's reconcile logic that picks the transactions to be in the set.
Suggestion:
Since editing the download date is not permitted (and could create confusion), I suggest creating a way to remove transaction from the reconciliation set without removing the cleared status. Also transactions with posted dates outside of the statement date range (that are not reconciled) would need a way to be selected and added to the set.

I would hope this feature would be added to the MAC versions as well as the Windows version.
4
4 votes

New · Last Updated

Comments

  • NotACPA
    NotACPA SuperUser ✭✭✭✭✭
    I'm not a Citi customer ... BUT, perhaps, are they downloading "Pending" card transactions ... and then changing the date to the actual Posted date?
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭✭
    edited May 2020
    besmith said:
    Suggestion:
    ...I suggest creating a way to remove transaction from the reconciliation set without removing the cleared status. Also transactions with posted dates outside of the statement date range (that are not reconciled) would need a way to be selected and added to the set.

    I would hope this feature would be added to the MAC versions as well as the Windows version.
    I've got Citi cards and always use OSU for downloads.  I haven't seen the changed posting dates issue.  But Citi does offer options for what is downloaded manually and one of those options is to download All Transactions which includes pending ones...something that doesn't happen with OSU.  I suppose it is possible that when using WC with the "All Transactions" option selected those pending transactions do get entered into the register placing the Transaction Date in both the Transaction Date and Posted Date columns.  And then when those pending transactions do post and get downloaded, the actual Posting Date replaces the original date entered there.  I don't have any pending transactions on my Citi cards right now so I can't test this out but I will.
    That being said, I wholeheartedly support @besmith 's suggestion to allow for removal of transactions from the reconciliation set without removing the cleared status in the register.  This would be very helpful in reconciling investment transactions which have cleared but not yet settled.  It would also be helpful in reconciling bank and credit card accounts when transactions have been downloaded but the FI has not yet updated/downloaded the new online balance.  The way the reconciliation process now works is that these cleared transactions get unmarked during reconciliation which then unclears them in the register which in turn then requires manually changing them back to cleared status in the register, again.  That is something that should not need to be done and it introduces possible clearance status issues in the register which can mess up future reconciliations.
    (QW Premier Subscription: R47.15 on Windows 11)
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    I wonder if the reason that @besmith is getting this strange "behavior" is because the account is setup for Express Web Connect instead of Direct Connect.  If you use Citibank for the financial institution you will get Express Web Connect.  If you use CitiCards for the financial institution you will get Direct Connect, which is much more reliable.  If you switch over you will get about a month's worth of duplicate transactions, but after those are deleted it will be much better.
    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • Rocket J Squirrel
    Rocket J Squirrel SuperUser ✭✭✭✭✭
    I encounter this issue every month with Morgan Stanley via Direct Connect. Cohen & Steers funds pay dividends on the last day of the month which don't show on the statements in time. I have 1 or 2 dividends every month I must un-clear, then reconcile, then re-clear. There is no bug in my case, it's just a brief lag in reporting on the statements.

    I have found my mouse-hand-rhythm for dealing with this, so - for me - I consider this not a "must have," but a "nice to have." With every new feature seemingly introducing new bugs these days, I'll withhold my vote.
    Quicken user since version 2 for DOS, now using QWin Premier Subscription (US) on Win10 Pro.
  • FlyerFran
    FlyerFran Windows Beta Beta
    I agree with @Rocket J Squirrel  This is a nice to have.
  • Quicken Anja
    Quicken Anja Moderator mod
    Hello All,

    The Community Support team regularly reviews long-standing posts and Ideas for relevancy and current interest. This Idea seems to have stalled and we would like to gauge the current interest in this request. 

    If you would like to see this idea implemented, please add your vote and a comment explaining how this idea would be beneficial for you. More information, including steps to vote and how to submit your own Ideas for future product features/improvements, is also available here.

    Thank you,

    Quicken Community Support Team
    -Quicken Anja