Can you bulk-reconcile cash account transactions?

teaguew · March 2022

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!

Boatnmaniac · March 2022

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?

Boatnmaniac · March 2022

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?

splasher · March 2022

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:

Image: https://us.v-cdn.net/6031128/uploads/editor/07/g2skktiifubr.png

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".

teaguew · March 2022

Thanks. It did!

SomebodyInGNV · March 2022

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 · March 2022

Thanks!

Can you bulk-reconcile cash account transactions?

Best Answer

Answers

Categories