Solved

How to unreconcile a monthly statement that has already by reconciled?

Forum|Forum|7 years ago
November 27, 2018
6 replies
0 views

Original commenter did not share additional details

QuickBooks Online

Best answer by GlinetteC

We can undo a reconciled statement by manually unreconciling each transaction. I'd be glad to guide you with the steps:

Go to the Gear icon and select Chart of Accounts.
Find the appropriate bank, then click View register.
Select the transaction to edit.
Under the Check column, click the box repeatedly to change the status. ("C" - Cleared, "R" - Reconciled, and "Blank" - Not cleared or reconciled)
Click Save.

You can learn more information on how to undo from reconciliation in this article: Undo and remove transactions from reconciliations in QuickBooks Online.

If you want hands-on help, you can get a QuickBooks-certified bookkeeper to show you how to do reconciliations and other tasks, check out QuickBooks Live.

You may also consider looking for an accountant to Redo the reconciliation process.

Here's how to invite an accountant:

Click on the Gear Icon > Manage Users.
Go to the Accountants section and click Invite Accountant.
They will be asked to create a user ID before signing for the first time unless they already have an account with Intuit Business Services.
Until your accountant signs in, their status on the Manage Users page is "Invited." After accepting the invitation, their status changes to "Active."
Click Next and Finish.

You can also refer to this article for the detailed steps: How to invite your accountant to QuickBooks.

Let us know if you have additional concerns, we're here to help.

R

Rasa-LilaM

Greetings, jthornton17.

Thanks for dropping by the Community space. I’d be glad to assist you with unreconciling previous statements so they will not throw off your records.

If you’re currently using QuickBooks Online Accountant, use the Undo a reconciliation feature to unreconcile previous transactions without manually editing individual transactions from within the register. To visually guide you through the steps, click on this link: Undo a reconciliation.

However, if you’re using a different version, manually unreconcile each transaction to undo the reconciliation. Let me provide you the step by step process.

Here's how:

Go to Accounting tab on the left panel.
Under Your Company, select Chart of Accounts.
Choose the account you’re working on, and click on View Register.
Select the transactions you want to unreconcile.
Keep on clicking the R status until it shows blank or cleared (C).
Click on Save.
Choose Yes in the confirmation window.

I also added a link to give more insights about unreconciling transactions. I recommend consulting with your accountant before performing any of the steps. This is to ensure your records are in order.

Reach out to me directly if you have additional questions about working in QBO. I'm here to answer them for you. Have a good one.

S

sforg

I unreconciled every transaction from a previous statement, but QB still won't let me go back re-reconcile for that month.

C

Charies_M

Hello there, sforg.

Let's get this sorted out so you'll be able to unreconcile your statement in QuickBooks Online (QBO).

To resolve this, make sure to choose the correct ending date in the reconciliation window.

Here's how:

Go to Accounting.
Choose Reconcile.
Select the account you want to reconcile and click Resume reconciling.
In the Ending date section, enter the date you want to reconcile.
Click Start reconciling.

Here's an article to learn more about unreconciling transactions in QBO: How to unreconcile a transaction or undo a reconciliation.

Let me know if you have additional questions or clarifications about recording refunds from a vendor. I'm always here to help.

F

felisseyy

Hi, it seems that it is very easy to unreconcile if you're an accountant. However, as an admin user of our QB accounts it is not possible. QB doesnt provide an "undo" button for us?

Could someone please let me know how to undo a month's reconcialiation?

Thank you.

Felisse

john-pero

In register view - uncheck every R that was in the reconciliation, which reinforces importance of printing a recon detail report each and every time. You should be able to view the last one in reports. Accountant users can view more than the most recent.

If you have an accountant user you can ask them to one button reverse the recon for you (for a billable hour fee) or you can get your own QBOA (using a second email). Regular users accessing their accounts as an accountant user is not prohibited nor for the novice but a savvy bookkeeper will enjoy the extra tools provided

F

felisseyy

Hi John,

Thanks for your reply!

How do I go about getting my own QBOA to fully benefit from the undo tool? Are we required to be an accountant to get access in QBOA? If you could please let me know how we can do it. I'd appreciate it very much.

Felisse

M

MJW3

Hi,

I had my accountant unreconcile a few months for me, but it also changed my beginning balance by a large amount. I followed the steps prompted by QBO to get to the discrepancy report, edited those, but my beginning balance is still off by a large amount. How can I fix my beginning balance to match the ending balance of (what is now) my last reconciled month?

Thanks!

M

MaryAnn_E

Hi there, @MJW3.

Let’s check the different causes why you’re having a beginning balance discrepancy in QuickBooks Online. This way, you can reconcile the accounts successfully. They include:

Changes in the amount of a reconciled transaction.
Deleting previously reconciled transactions.
Modifying the transaction's status in the register. For example, from reconciled (R) to cleared (C) or neither (blank), or when an unreconciled entry was changed to reconciled (R).
Someone entered an incorrect opening and ending balance for the account at the start of reconciliation.
There are missing or duplicate transactions in QuickBooks.
Someone entered a transaction in QuickBooks that hasn’t cleared the bank yet.

There are different resolutions provided to resolve the beginning balance mismatched. Read through these articles and follow the instructions given depending on your scenario:

For other recommended solutions, see Resolve reconciliation differences. It has tips that can help hunt down tricky transactions and get the difference to equal zero.

Know that I'm always here and ready to help if you need further assistance, so leave a comment. Have a good one!

JenoP

I want to join the conversation and help with your questions related to reconciliations, esthelamaeballarta0804.

Yes, it's possible to reconcile a specific month even if the previous periods were not. You just need to select a date in the Ending Date field at the start of the reconciliation.

However, that might affect the beginning balance since that amount is usually the statement ending balance from the previous reconciliation. There's also a column in the Reconciliation screen where you can see all the payment transactions.

You can use these articles as your guide:

I'd also like to share a couple more articles for additional guidance and references:

You can always give us another visit and post another question or reply if you have other questions. We're always here to help with your QuickBooks inquires.

R

Ron4082

Hello,

Could you please help me to fix my issue about the monthly reconcilliation, I reconcilled oct to december only to find out the bank and qbo balance does not match,I already finished reconciled it but unfornately the register is not balance , So i do manually reconcilliation bank statement and the register and found out that there are lots of duplicates , so I deleted it all . Is this okay? How to reconcile it again?

I hope you can help me.

Thank you,

Ron

Tori B

Good morning, @Ron4082.

Thank you for taking the time to follow along with the thread and sharing your concerns.

If you’re currently using QuickBooks Online Accountant, you can use the Undo a reconciliation feature to unreconcile previous transactions without manually editing individual transactions from within the register. However, if you're not using QuickBooks Online Accountant, you'll need to unreconcile each transaction from the register. I've included some steps to unreconcile both ways below.

QuickBooks Online Accountant:

Go to the Accounting menu.
Select the Reconcile tab.
Click History by account.
Choose the account you want to reconcile and the date range from the dropdowns.
Find the reconciliation on the list.
Tap on View report to open the Reconciliation Report.
Review any discrepancies and changes your client wants to make.
When you’re ready, select the dropdown in the Action column, and then choose Undo.
Hit Yes and then Undo to confirm.

Non-accountant:

Go to the Accounting tab on the left panel.
Under Your Company, select Chart of Accounts.
Choose the account you’re working on, and click on View Register.
Select the transactions you want to unreconcile.
Keep clicking the R status until it shows blank or cleared (C).
Click on Save.
Choose Yes in the confirmation window.

I also wanted to include additional information about resolving issues at the end of reconciling. Check out Fix issues at the end of a reconcile in QuickBooks Online to review this information.

For additional details about undoing reconciles and individual transactions, check out the help articles I've included below.

Please let me know if you have any questions or concerns. I'm always here to lend a hand. Take care and have a great day!

S

snour

I have just completed copying company A to company B and company B shows the correct ending balance. However, now I have to click through 3,689 transactions to show the "R" for reconciled. All transactions date back to 2010. Is there a quicker way to show All transactions as reconciled? I don't understand why the copy function didn't bring over All transactions as reconciled. I made sure everything was reconciled Prior to copying. I feel carpel tunnel coming on clicking through 3,689 transactions. Thanks.

N

nataly710cpa

In a company , the reconsilation has been done till 07/31/21 . afterwards the period is entered 08/31/22 instead of 08/31/21 and it is saved .

how can we solve this problem??

please let me know

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded