Can you bulk-reconcile cash account transactions?

teaguew
teaguew Quicken Windows Subscription Member
Year-end backups only remove reconciled transactions from registers. So when I've done it, all those un-cleared, un-reconciiled cash transactions from past years remain, and cash transactions do not have a reconcile function. Is there a way to bulk-reconcile transactions from cash accounts, or is the only way to clear out past year's cash accounts is to enter a transaction on 12/31 or 1/1 that is the balance on that date, and then manually delete the earlier transactions? If so, that seems pretty clunky for software that automates so many things.

Thanks!
Tagged:

Best Answer

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited March 2022 Answer ✓
    You didn't say what kind of account(s) you are talking about but it sounds like it is a manual Cash account.  Am I correct?
    Assuming you are talking about a manual account, you can do the following:
    • Back up your data file in case something goes wrong.
    • In the Account Register, click on the Clr column header to sort the register by cleared status.
    • Left click on the 1st transaction not cleared transaction.
    • Scroll down the register to the last not cleared transaction and while holding down the Shift key left click on it.  All not cleared transactions should not be shaded.
    • Right click anywhere on the shaded transactions.
    • Left click on Reconcile Status.
    • Select the Reconcile Status that you want and then click on Yes.
    • All of the selected transactions will now have the cleared status that you selected.
    This just marks the transactions with a reconciled status.  It is not an actual reconciliation.  If there are missing transactions or incorrectly entered transactions the account might still need a balancing transaction to be entered.

    Did this answer your question?

    Quicken Classic Premier (US) Subscription: R59.10 on Windows 11

Answers

  • Boatnmaniac
    Boatnmaniac Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited March 2022 Answer ✓
    You didn't say what kind of account(s) you are talking about but it sounds like it is a manual Cash account.  Am I correct?
    Assuming you are talking about a manual account, you can do the following:
    • Back up your data file in case something goes wrong.
    • In the Account Register, click on the Clr column header to sort the register by cleared status.
    • Left click on the 1st transaction not cleared transaction.
    • Scroll down the register to the last not cleared transaction and while holding down the Shift key left click on it.  All not cleared transactions should not be shaded.
    • Right click anywhere on the shaded transactions.
    • Left click on Reconcile Status.
    • Select the Reconcile Status that you want and then click on Yes.
    • All of the selected transactions will now have the cleared status that you selected.
    This just marks the transactions with a reconciled status.  It is not an actual reconciliation.  If there are missing transactions or incorrectly entered transactions the account might still need a balancing transaction to be entered.

    Did this answer your question?

    Quicken Classic Premier (US) Subscription: R59.10 on Windows 11

  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭
    I have a cash account in Quicken for Windows and I periodically reconcile it, so you can reconcile a Quicken cash account.
    Do CTRL+R while in the account:


    It asks for a date and what the balance SHOULD be, it will calculate an adjustment transaction using the category selected.  If you don't want the balance to change, just enter your current balance in the account and a $0 or no adjustment will be entered (not sure which, never had that condition), but all of the previous transactions will be marked "R".

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • teaguew
    teaguew Quicken Windows Subscription Member
    Thanks. It did!
  • SomebodyInGNV
    SomebodyInGNV Quicken Windows Subscription Member ✭✭✭
    Beware of a bug when reconciling transaction in an account type that isn't usually reconciled (e.g., cash accounts) where the transaction is a transfer from a split transaction originating in an account type that is usually reconciled (e.g., checking). The split transactions will be broken and the net amount of the transaction in the checking account may change, with nothing telling you that happened other than the other account now being out of balance. The transaction in the checking account will remain reconciled despite now being broken.
  • dalehawaii
    dalehawaii Quicken Windows Subscription Member ✭✭✭✭
    edited March 2022
    Thanks!
    Quicken user since 1996
    Quicken Home & Business Subscription
This discussion has been closed.