Best way to re-reconcile to REMOVE adjustment transactions which were entered previously?

CyborgOne
CyborgOne Quicken Mac Subscription Member ✭✭✭

I've previously performed about a year's worth of reconciliations of an offline checking account, against just the final balances - adding an "adjustment transaction" to match the delta between the prior month's balance, and the next one. I didn't want to manually enter all such transactions, so this worked fine for my needs.

However, I now have access to all historical transactions (via newly-enabled online account access), so would like to track this additional level of detail, if possible (for tax reporting, etc.). I have now enabled online access, and have imported all such transactions into this account in Quicken. The result is that the latest tracked balance is off by the same amount as all of these "Reconcile adjustment" transactions combined - since the REAL transactions now appear in the register, as well.

In other words: If the balance went up by, say, $1000 in a given month, I previously had a "Reconcile Adjustment" transaction for $1000 entered, in order to have the final balance match the statement's ending balance. But now, with the additional transactions downloaded, I have a bunch of additional transactions (some deposits, some withdrawals) which in aggregate match that final delta themselves - as expected. BUT, since the "adjustment" transactions still appear in my transaction log, this means each month is now off by $1000 - and the current displayed balance for this just-reconciled account, after a year of these additional imports being added, is off by, say, $12,000.

In trying to recover from this, I figured it would be as easy as simply deleting those Adjustments, accessing Reconcile History, selecting each month in turn, and then reconciling it again. But, this is not working: Quicken seems to remember those prior reconciliation transactions, and inexplicably keeps wanting to add them BACK… throwing off not only that month's ending balance, but also that of all subsequent months. I delete these adjustments, but it keeps adding them back. As such, the numbers don't work out at all - despite the ACTUAL math working out perfectly (I've tripled-checked each time). This odd "I won't let you remove those adjustments which I know about previously" behavior on the part of Quicken is an absolute nightmare.

I could delete the ENTIRE reconciliation history and start over - but really don't think I should have to do this, if I can avoid it. It seems there should be some way of re-reconciling each month individually - telling the app to ignore the prior Adjustment, and JUST use the new transactions, added to the prior reported balance, to come up with the new ending balance. But, it is actively preventing me from being able to do this.

Is there some trick to ACTUALLY re-reconciling prior months, and having Quicken get out of its own way?

(Note: Yes, if I'm going to correct each month's reconciliation anyway, it's probably just easier to wipe out all such reconciliations and start again. But, the behavior itself is confusing me: If I had a SINGLE month which I didn't have all transactions for, and had entered an adjustment for - and now want to correct to add the actual list of transactions - it seems this is essentially impossible to complete. Why?)

Any and all insights into what Quicken is trying and failing to do in this case, would be appreciated.

  • macOS Tahoe 26.0.1 (25A362)
  • Quicken Classic - Business & Personal v8.3.2 (Build 803.58902.100)

Comments

  • Jon
    Jon Quicken Mac Subscription SuperUser, Mac Beta Beta

    There’s no trick that I’m aware of, the best thing is to just delete the previous reconciliations and re-reconcile. You don’t need to do each month individually, you can just do one mass reconciliation up to the end of last month.

  • RalphC
    RalphC Quicken Windows Subscription Member ✭✭✭✭

    Seeing as you were remiss in balancing in the past, I wouldn't do anything. If your current balance(s) agree with the financial institution(s), I would just go forward being greatly more fastidious about entering transactions as they occur and balancing as statements arrive (probably monthly). The newly acquired online status should help with these tasks.

This discussion has been closed.