Can you bulk-reconcile cash account transactions?

teaguew
teaguew 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 SuperUser ✭✭✭✭
    edited March 6 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?
    (QW Premier Subscription: R39.23 on Windows 10)

Answers

  • Boatnmaniac
    Boatnmaniac SuperUser ✭✭✭✭
    edited March 6 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?
    (QW Premier Subscription: R39.23 on Windows 10)
  • splasher
    splasher 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 since 1996 -  Subscription  -  Win10
    -also older versions as needed for testing
    -Questions? Check out the  Quicken Windows FAQ list
  • teaguew
    teaguew Member
    Thanks. It did!
  • SomebodyInGNV
    SomebodyInGNV 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 Member ✭✭✭✭
    edited March 9
    Thanks!
    Quicken user since 1996
    Quicken Home & Business Subscription
This discussion has been closed.