cancel
Showing results for 
Search instead for 
Did you mean: 
jthornton17
Level 1

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

 
Solved
Best answer February 08, 2020

Best Answers
GlinetteC
Moderator

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

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

  1. Go to the Gear icon and select Chart of Accounts.
  2. Find the appropriate bank, then click View register.
  3. Select the transaction to edit.
  4. Under the Check column, click the box repeatedly to change the status. ("C" - Cleared, "R" - Reconciled, and "Blank" - Not cleared or reconciled)
  5. 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.

 

You can also get one-on-one help for your business:
Check out QuickBooks Live.

 

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

 

Here's how to invite an accountant:

  1. Click on the Gear Icon > Manage Users.
  2. Go to the Accountants section and click Invite Accountant.
  3. 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.
  4. Until your accountant signs in, their status on the Manage Users page is "Invited." After accepting the invitation, their status changes to "Active."
  5. 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.

View solution in original post

61 Comments 61
Rasa-LilaM
QuickBooks Team

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

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:

  1. Go to Accounting tab on the left panel.
  2. Under Your Company, select Chart of Accounts.
  3. Choose the account you’re working on, and click on View Register.
  4. Select the transactions you want to unreconcile.
  5. Keep on clicking the R status until it shows blank or cleared (C).
  6. Click on Save.
  7. 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.

sforg
Level 1

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

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

Charies_M
Moderator

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

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:

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

123.PNG

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.

felisseyy
Level 2

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

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
Community Champion

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

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

felisseyy
Level 2

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

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

 

HoneyLynn_G
QuickBooks Team

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

Hi there, @felisseyy.

 

On behalf of John, you can look for someone with a ProAdvisor access. They are QuickBooks-certified independent accounting professionals who can provide reconciliation service and help undo your reconciled transactions.

 

Here's how to reach them:

  1. Visit this link: Business is better with a ProAdvisor.
  2. Select Accounting & Bookkeeping and type-in your location.
  3. Click Search.
    1.PNG
  4. From the results, pick the best accountant near you.

For additional insight, check out the Find-a-ProAdvisor resources article. It gives accountants' ranking, relevant links, and troubleshooting steps.

 

Let me know how if goes, @felisseyy. I'm always here to offer assistance about QuickBooks. Just leave a comment below.

Jerry
Level 1

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

hi. how do i re reconcile a monthly bank statement that has already been reconciled. 

 

thanks

GlinetteC
Moderator

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

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

  1. Go to the Gear icon and select Chart of Accounts.
  2. Find the appropriate bank, then click View register.
  3. Select the transaction to edit.
  4. Under the Check column, click the box repeatedly to change the status. ("C" - Cleared, "R" - Reconciled, and "Blank" - Not cleared or reconciled)
  5. 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.

 

You can also get one-on-one help for your business:
Check out QuickBooks Live.

 

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

 

Here's how to invite an accountant:

  1. Click on the Gear Icon > Manage Users.
  2. Go to the Accountants section and click Invite Accountant.
  3. 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.
  4. Until your accountant signs in, their status on the Manage Users page is "Invited." After accepting the invitation, their status changes to "Active."
  5. 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.

Signsforsandiego
Level 1

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

The problem with this answer is that when you go back to reconciliation the old report is still there and the start balance and date are unchanged. So it works for a single month, but fails with more than one month.  It is crazy that Intuit does not have the unreconcile feature in the standard program.  They waste my time with artificial requirements that cost time and money

Roxie1
Level 1

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

I need to un-reconcile 3 months and be able to reconcile them afterward. How do I do this in QB desktop?

I cannot afford to pay anyone to do it for me.

Ryan_M
Moderator

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

Hi @Roxie1,

 

I've got your back in this query. Let me provide the steps on how you can undo a reconciled period in QuickBooks Desktop (QBDT).

 

 Follow these steps:

 

  1. Go to the Banking menu.
  2. Select Reconcile.
  3. On the Begin Reconciliation window, tap the Undo Last Reconciliation button.

This will undo the last period you reconciled. Keep repeating the provided steps above until you undo 3 months worth of bank statements. 

 

You can then make the necessary changes to the bank register as necessary. Then proceed with reconciliation once you're done.

 

In case you encounter any errors or issues during this process, take a look at this article: Fix issues when you're reconciling in QuickBooks Desktop. Here you'll find a step by step guide on how to finish a reconciliation, whenever you encounter an issue.

 

Feel free to comment below if you have other questions. I'll be sure to get back to you. 

AN16
Level 1

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

I need to delete a transaction wrongly registered and I need to do it correctly what will be the best option for this without altering the correspondent reconciliation 

Anna S
QuickBooks Team

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

Thanks for joining the thread, @AN16.

 

I'm happy to provide some info on deleting transactions from reconciles in QuickBooks Online.

 

By changing or deleting a transaction in a reconciliation, you can unbalance your accounts and change the ending balance. This will also affect the beginning balance for your next reconciliation. However, you can unreconcile the one transaction that is registered incorrectly, but you'll want to make sure it doesn't affect your beginning and ending balances. The steps below will show you how:

 

  1. Navigate to the Accounting tab and pick Chart of Accounts.
  2. Find the account and press View register.
  3. Select the transaction you want to unreconcile.
  4. In the check column, click the until the box is blank.

 

       5. Hit Save.

 

Now your transaction can be deleted since it is no longer attached to the reconciled account. You can also check out this article for more information: Undo and remove transactions from reconciles.

 

I'm only a post away should you have any other questions or concerns. Enjoy the rest of your day!

caleb_hanson
Level 1

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

In Quickbooks Online, I am clear about how to unreconcile for multiple months via the account register. Is there a way to redo the reconciliation for multilple months in Quickbooks Online without paying an outside person?

LieraMarie_A
QuickBooks Team

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

Yes, you can redo the previous reconciliations. @caleb_hanson.

 

Once you have your bank statements, compare the list of transactions with what you recorded into QuickBooks. If everything matches, you know your accounts are balanced and accurate. 


Here's how:

  1. Go to the Gear ⚙ icon and select Reconcile.
  2. From the Account drop-down menu, select the account you want to reconcile. Make sure it's the same one on your statement.
  3. Check the Last statement ending date link. Ensure your bank statement starts the day after your last reconciliation.
  4. Review the beginning balance. See to it that the beginning balance in QuickBooks matches the one on your bank statement. Here’s what to do if they don't match.
  5. Enter the ending balance and ending date as they're written on your bank statement.
  6. When you're ready to start, select Start reconciling.

 

You can read through this article as well to learn more about the reconciliation workflow and how to fix issues during the process: Reconcile.

 

Let us know if you need further assistance. We're always around to help. Have a wonderful day, @caleb_hanson!

MJW3
Level 1

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

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!

MaryAnn_E
QuickBooks Team

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

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!

 

 

sjones78
Level 1

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

This is not applicable to undoing a reconcile. To undo a reconciliation the user has to change the R in the status column of the transaction in the bank register to a C or leave the it blank. The above instructions allow a user to re-do a reconciliation rather than undo a reconciliation. Unless the status for each transaction is changed in the register they will not appear as available for reconciliation. 

pirraglia
Level 2

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

Hi I just need to change the starting balance as I int the wrong one then carried over my mistake. I use quickbooks online ...I need to undo 2 months so I can fix everything going forward ...Thank you!

Angelyn_T
QuickBooks Team

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

I appreciate you for joining the thread, @pirraglia.

 

You can update the opening balance through the register. I can guide you on how.

 

  1. Open your QuickBooks Online account, then click on Accounting at the left pane.
  2. Select Chart of Accounts.
  3. Find and open your account.
  4. Search the account register for the opening balance entry. It should be labeled Opening Balance Equity with “Opening Balance” in the Memo column.
  5. In QuickBooks, select the opening balance entry to expand the view.
  6. In the Deposit column, edit the balance so it matches your bank records.
  7. Hit Save to record the changes.

 

Once done, you can start undoing the 2 months reconciliation. You can either invite an accountant to perform the process or edit the individual transactions manually

 

Here's an article you can read more about undoing reconciliations in QuickBooks Online.

 

Moreover, you can open this link to know more about modifying the account's opening balance.

 

For additional hints about banking and reconciliation, you can also check out the topics from our help articles: Find help with bank feeds and reconciling accounts.

 

Please feel free to get back to me here for any additional questions about QuickBooks or reconciliation. I always have your back. Thanks for dropping in, and cheers for more success!

pirraglia
Level 2

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

Hello Unfortunately that didnt work. Maybe I should clarify that its a credit card statement? for November and December I need to unreconcile   When I looking in the registry there were only numbers there from many years past. I was 30 minutes chatting online with quickbooks before got disconnected and another rep showed up. still not able to help me. I find that for the amount of money paid to quickbooks I never get any help from customer support 

I greatly appreciate any help you can give as I am bout ready to cancel the subscription and move on to something more consumer friendly 

Catherine_B
QuickBooks Team

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

I do appreciate you for doing the steps my colleagues provided, pirraglia.

 

There are two ways to reconciling an account. First, manually changing the status in the bank's register. Doing this causes the Reconcile feature not to detect the date when it was reconciled but affects the opening balance. Second, reconciling through the reconcile page where it creates a reconciliation history report that shows each transaction included.

 

To undo a reconciliation, you can either invite an accountant to undo the entire period or manually changing each transaction. You can use the filter option or sort it by date so you can easily locate them. Let me show you how: 

 

  1. Go to the Accounting menu and select Chart of Accounts
  2. Look for the credit card account and click View register.
  3. Above the DATE column, click the filter icon. 
  4. Select the Reconcile status and Date.
  5. Click Apply

For more details, you can use this link that will help you through reconciling an account and how to pull up the reconciliation reports. 

 

Let me know if you have other questions. Take care and have a great day!

chadhuniu
Level 1

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

This is honestly a scam. They force you to pay someone just to unreconcile something? This is the most ridiculous pile of dog doo-doo I've ever heard. I switched over to Quickbooks Online last year and have had nothing but problems since doing so. I am extremely unhappy with the product and am looking to replace it with something else as soon as possible. It has cost me hours and hours of my time and tons of money just to try to get close to be fixed. Horrible. 0 stars.

Need to get in touch?

Contact us