I need to manually mark a bank transaction for an already reconciled month to reconciled status.

chic316860 · ‎December 11, 2023

i was having problems with an automatic transfer from paypal to our checking account. i had to delete a transfer transaction and manually reenter it. but i did this after the month that contained the transaction had been reconciled. (the transaction that i deleted did have an "R" status. how can i change the status of this new manually entered transaction to "R" status (reconciled). the fact that is showing as unreconciled is now causing me a beginning balance error when i try to reconcile the following month.

thanks

FritzF · ‎December 11, 2023

Hello there, chic316860.

I'm here to help you mark the transaction you've recreated as reconciled in QuickBooks Online (QBO).

Upon recreating a transaction, it will reappear in your register. Subsequently, you can manually reconcile it by placing R status in the Reconcile (✓) column. The process for doing this is fairly swift and straightforward.

Let me show you how:

In QBO, go to the Accounting menu on the left pane.
Proceed to the Chart of Accounts.
Locate the bank account in question, then click View register and look for the recreated transaction.
Under the Reconcile (✓) column, click on the blank field to mark the transactions as reconciled (R).
Hit Save and select Yes to confirm.

After completing this, your starting balance should display the accurate amount. For additional assistance on manually reconciling bank transactions and removing their reconciled status, you can consult this article: Undo or remove transactions from reconciliations in QuickBooks Online.

Once done, you can now proceed with the reconciliation process. Refer to this article for future reference: Reconcile an account in QuickBooks Online.

Please leave a comment below if you have additional questions about reconciliation or anything else, chic316860. I'll be here to assist. Keep safe.

View solution in original post

FritzF · ‎December 11, 2023

Hello there, chic316860.

I'm here to help you mark the transaction you've recreated as reconciled in QuickBooks Online (QBO).

Upon recreating a transaction, it will reappear in your register. Subsequently, you can manually reconcile it by placing R status in the Reconcile (✓) column. The process for doing this is fairly swift and straightforward.

Let me show you how:

In QBO, go to the Accounting menu on the left pane.
Proceed to the Chart of Accounts.
Locate the bank account in question, then click View register and look for the recreated transaction.
Under the Reconcile (✓) column, click on the blank field to mark the transactions as reconciled (R).
Hit Save and select Yes to confirm.

After completing this, your starting balance should display the accurate amount. For additional assistance on manually reconciling bank transactions and removing their reconciled status, you can consult this article: Undo or remove transactions from reconciliations in QuickBooks Online.

Once done, you can now proceed with the reconciliation process. Refer to this article for future reference: Reconcile an account in QuickBooks Online.

Please leave a comment below if you have additional questions about reconciliation or anything else, chic316860. I'll be here to assist. Keep safe.

chic316860 · ‎December 12, 2023

thank you. i was able to get the transaction to 'R' (reconciled) status. once i did that i no longer had a beginning balance error and was able to reconcile current month's bank statement. all is good now!

again thanks!

LollyNino_C · ‎December 12, 2023

Appreciate the update, @chic316860.

We're glad to hear that the steps provided by my colleague have helped with your issue. And thank you for sharing. We want to ensure our users are on top of their business.

You may visit our Help Articles page to read different information that will guide you in future tasks.

I'll be one message away if you need anything else. I wish you a prosperous rest of the year! Have a great day, and keep safe!

RRUSTreasurer · ‎November 04, 2025

Help! I am having the same problem, but when I get to my register and click on the box in the reconcile column for me new recreated transaction, I get a message that I cannot edit that column. When I try to edit the transaction, there is no reconcile column to edit. What can I do?

ShyMae · ‎November 04, 2025

I appreciate your effort in marking the transaction as reconciled, RRUSTreasurer. I understand the importance of having an accurate and balanced record.

To better understand what's causing this issue, could you let us know the exact message you're seeing when clicking on the box in the Reconcile (✓) column?

Manually changing the reconciliation status can be completed within the Bank Register, which is why the Reconcile (✓) column doesn't appear when you try to edit the transaction.

Since you're unable to edit the status, I recommend logging out of your account and then logging back in to refresh the system.

Once you've accessed the system, manually mark the transaction as reconciled again.

Please don't hesitate to add a comment below if you have further questions. We're always here to help.

alex2265 · ‎November 07, 2025

That’s exactly why I built ReconcileBook it helps you clean up and reconcile faster without fighting QuickBooks.
You can upload pdf or csv bank statements, flag duplicates, and match transactions automatically before they ever touch QuickBooks.
Once everything looks right, just export straight to QuickBooks or Excel so your books stay clean and balanced.
It’s been super helpful for cleanup jobs and catching errors that QBO misses.

Topics

Training

Community

Resources

I need to manually mark a bank transaction for an already reconciled month to reconciled status.