cancel
Showing results for 
Search instead for 
Did you mean: 
QuickBooks Team

Re: This is a LIE, You DO have to have the accountants version.

Hello there, Tammi Miller.

 

Me me share some insights about undo reconciliation option in QuickBooks Online.

 

The option to batch undo reconciliations is only available in QuickBooks Online Accountant (QBOA). If you're not an accountant and is using a regular QuickBooks Online version, you'll have to manually unreconcile each transaction.

 

You can check out this article for more details: Clear, unclear, reconcile or unreconcile transactions

 

Also, here's an article to learn how to undo a reconciliation using QBOA: Undo a reconciliation.

 

If you wish to sign up for this, you can visit this article and know more about the features of QBOA for Accountant: https://quickbooks.intuit.com/accountants/products-solutions/accounting/quickbooks-online/

 

In case you require further assistance from a live technical support, feel free to reach them out through the steps below:

  1. Sign in to your QuickBooks Online company.
  2. Click the Help icon in the upper right of the screen.
  3. Select Contact US on the pop-up. 
  4. Enter what you're needing assistance with in the How can we help? field and choose Continue
  5. Click Get a callback.
  6. Enter your contact information.
  7. Select Call me.

Should you need help or questions while working with reconciliation, just let me know as I'm always here to help you out.

Level 1

Re: This is a LIE, You DO have to have the accountants version.

The workaround for not having the QBO Accountant version for me was to invite myself as an accountant, so that I have the "Undo" option. Keep in mind, I have a QBO Plus account, so this is untested in any other version. The fictional company below is Company XYZ. Here were my steps:

  1. Click the "Gear" icon in the upper right.
  2. Click on "Manage Users".
  3. Click on the "Accounting Firms" tab (next to the "User" tab).
  4. Click the "Invite" button and fill out the form using a different email address than the account you are currently managing.
  5. Go to your email account that was sent the invitation
  6. Open the email titled "Company XYZ has invited you to use QuickBooks Accountant".
  7. Click on the "Accept Invitation" button. You will be logged into a QuickBooks Accountant version with this secondary email address.
  8. Click on "Go to client's QuickBooks" in the top left.
  9. Click on Company XYZ. You will now have access to Company XYZ as an accountant.
  10. Click on the "Gear" icon.
  11. Under the Tools list, click on "Reconcile".
  12. Click on "History by Account".
  13. Choose a Report and click on the arrow next to "View Report".
  14. Click "Undo".
Level 1

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

Thank you! I followed the steps and my version does not have an undo option on the drop-down menu.

 

I went to reconcile item per item but I now how a discrepancy, and it is being carried from one year to another (I am working on entering data for two years)

 

Is there another way?

 

 

Marcia

Moderator

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

The Undo option is only available in QuickBooks Online Accountant version, MaciaTsedeq.

 

I'd recommend inviting your accountant and let them undo the reconciled period. Here's how to do it:

  1. Click the Gear icon in the upper-right corner and select Manage Users.
  2. Go to the Accounting firms tab and click the Invite button.
  3. Enter your accountant's information and click Save.

Once they accept the invitation, you can share this article in undoing a reconciliation (QuickBooks Online Accountant): Undo a Reconciliation.

 

Otherwise, you'll need to undo the reconciled transactions one at a time. You can use this article for reference: How to Unreconcile a Transaction or Undo a Reconciliation.

 

Let me know if you need anything else.

Capture.JPG

Level 2

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

Hi, 

   I have added an "Accountant" user ID, then I logged in as the Accountant and there is still no UNDO option.  I have been communicating with Glenn from Tech Support and he literally sends me the exact same instructions.  I think I have the same instructions easily 5 times.    I have read in many places where others don't have the Undo option either.  So, I am begging for a phone number where I can speak to a person, but that doesn't exist either.  I am in Mexico, but obviously, I can speak English.  Can someone please send me a phone number where someone can speak to me?  I have sent multiple screenshots showing me Logging in as the Accountant User ID and going to the history of accounts and trying to UNDO a reconciliation and still, there is somehow doubt that I can follow remedial instructions.  The instructions that I have been given simply don't work.  Please help.  It's been 2  months now that I have been working on this identical issue with zero help.  I think Quickbooks Online may just not be the program for me.  I am shopping for a different program now so that I can end this nightmare.  Because as I'm sure everyone is aware, YOU CANNOT move forward to do any more reconciliations until you can get the ONE fixed.  I'm absolutely STUCK.  

 

 

QuickBooks Team

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

Hi @Tammi Miller,


I know you've been through a tough experience. But I’m here to ensure you can move forward in running your business. Let’s work together to figure out how you can unreconcile your accounts.

Currently, the accountant version is available in the US. This is why you are not able to see the Undo option even after adding yourself as an accountant in QBO Mexico.


As a workaround, you have to manually undo each reconciled transaction. Here’s how:

  1. Select the Gear icon.
  2. Under Your Company, select Chart of Accounts.
  3. Click on the account in question.
  4. From the Action column, select View Register (or Account History).
  5. Select the transaction to edit.
  6. In the reconcile status column (indicated by a check mark), repeatedly click on the box until it changes from "R" to blank.
  7. Select Save.


Please feel free to read this article for more details: How to Unreconcile a Transaction or Undo a Reconciliation.


Please know that we've recently updated our support experience. The best way to reach Support Team is to sign in to your account, select the Help icon, then click on Contact Us. You’ll be routed to ways on how you can connect with them.


If you have other concerns, I’m here to help.

Level 1

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

These instructions are incomplete and cause more trouble, not fixing anything. QB continues to hold the ending balance/beginning balance numbers even after the individual items were un-R-ed. moreover, this thread has so many incomplete and conflicting answers it is impossible to make any sense out of it.  QB needs to learn how to manage a help thread or change systems entirely. 

Level 2

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

I just managed to Undo my reconciliation.

To ensure you can see all reconciliations, you need to select "All Dates" from the "Report Period" drop-down.

I've attached a screenshot below:

Screen Shot 2019-04-20 at 3.47.29 PM.png

 

 

Level 2

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

Just invite yourself to be your own accountant (using a different email), register, then login, and do as I have shown in the screenshot, in my other post.

 

It works.

Level 2

Thanks to shaigrr for first posting a solution that works.

Thank you shaigrr (I replied to you and others but QB forum just posts every reply as a new post with no reference to the one I replied to!)

 

I'm posting the screenshot below one more time.

----

 

Everyone looking for a solution, trust me,  this works. 

I have a simple QuickBooks online version and I was able to Undo my reconciliations.

 

First, invite yourself as an accountant with an email that's different from your current one.

 

Then accept that invitation, register as an accountant - doesn't cost you anything and it takes a few seconds.

 

Once you're logged in, find your "client" company - it should be right there in front of you, and then the "Chart of Accounts", "History by Account" and make sure under Reporting Dates "All Dates" is selected.

 

You'll see your reconciliation report and to its right, drop-down options to "Print" or "Undo".

 

Enjoy!

 

Krishna

Agile Entrepreneurs

Make Your Own Mistakes, Learn From Mine!

Undo QB Reconciliation Screen Shot 2019-04-20 at 3.47.29 PM.png

Level 3

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

@SterlingD what is wrong with you? There were literally 3+ other pros that responded with accountant-only version solutions (no one made any mention they're using that version and you / the others did not even specify it was an accounting-only version [why would you not say this...?]) and every person is screaming,

"NOT THE ACCOUNTANT VERSION"

 

Are these BOTs auto responding or what? It's so confusing. There's no way customer service is this poor.

Level 1

Re: This is a LIE, You DO have to have the accountants version.

This worked for me!!!

Level 1

Re: Can I unreconcile an entire reconciliation? I accidentally entered the wrong year and QB hasn...

I actually managed to add myself under the same email.  So when I log into the desktop app or phone/ipad I can select to either go into the accountant account or my normal business account.  Makes it easier than remembering two passwords and all that.

Level 1

As an admin user, you cannot undo the reconciled accounts. Only the accountant who was invited into your Quickbooks online can UNDO the whole reconciliation report.


@emedicine wrote:
Thanks Lynda but I don' thave UNDO as an option under the Action dropdown.  All I get is PRINT.  Perhaps UNDO is a feature not on my online Essentials and I need an upgrade?

@emedicine wrote:
Thanks Lynda but I don' thave UNDO as an option under the Action dropdown.  All I get is PRINT.  Perhaps UNDO is a feature not on my online Essentials and I need an upgrade?

 

Level 1

Let a bookkeeper handle that matter, because only the accountant version has the UNDO RECONCILIATION feature. This is to prevent some admin users or master admin to mess up the books already reconciled by the accountant or bookkeeper.

 
Level 1

Re: This is a LIE, You DO have to have the accountants version.

I have the accountants version, triple checked that I am under the "Accounting firms" in "Manage users" and I still do not have access to the undo button. Is the undo only available for the Advanced version of QBO? Very frustrating.

Moderator

Re: This is a LIE, You DO have to have the accountants version.

Hi marissar,

 

Welcome aboard to the Community. I can show you how to undo reconciliation in the QuickBooks Online Accountant version.


The Undo option is only visible if you click the drop-down option from the History by account section. Here's how:

 

  1. On the left panel, click Accounting.
  2. Go to the Reconcile tab.
  3. Click History by account.
  4. Below the Action column, click the drop-down arrow.
  5. Click the next drop-down arrow next to View report.
  6. Click Undo.

Please refer to the screenshot below for your visual guide:

 

 

If you're still not being able to locate the option, I recommend reaching out to our QuickBooks Support through these steps:

 

  1. Log into your QuickBooks account.
  2. Click the Help option in the upper-right corner.
  3. Click the Contact us option.

For more information on reconciling accounts, I'm adding the article I recommend on this:

 

Undo your client’s reconciliations with QuickBooks Online Accountant.

 

Get back to me if need further help with using QuickBooks, and I'll be sure to get back to you.

Level 1

I unreconciled, but now the starting balance is wrong

I took over the accounts at the beginning of the year. When I did monthly reconciliations, there was no problem. The reconciliations for our main account are correct.

 

When I did the monthly reconciliations for our Interest bearing account, I entered the interest each month on the opening page of the reconciliation as opposed to creating a deposit transaction. The interest is added by the bank each month. Thus there is only one transaction per month.

 

However, after I completed 6 months of reconciliations, I was informed that the interest bearing account should only be reconciled at the end of the year. I followed the "unreconciliation" procedure for each of the 6 months working backwards through the register changing the "R" six times to "blank".

 

Preparing for end of year when I will need to do this reconciliation, I notice that the reconciliation will be blocked because the Reconciliation page states that the starting balance is off by the exact amount of the unreconciled transactions.  It appears that the "R" to "blank" unreconciliation method works only for actual deposit entries rather than the interest being entered in the reconciliation process.

Trying to fix the problem, I deleted the six transactions. This doesn't fix the problem which remains the same - I still get the same Reconciliation Discrepancy Report showing that the unreconciled - and then deleted - transactions are still showing and that the starting balance is off even though the Reconciliation page shows the correct and of 2018 reconciled balance.

 

While the amounts shown for the 6 months are "correct", they need to be included in the end of year reconciliation. Any ideas how I sort this out in QB Online? (Bank account is not linked.)

 

I have a month to find a solution so any help will be greatly appreciated!

QuickBooks Team

Re: I unreconciled, but now the starting balance is wrong

Hi briton,

 

Changing the reconciliation status is the first step to remove the transaction from your reconciled account. After that, you can change your beginning balance manually to resolve this. Though, I'd still recommend consulting with an accountant before doing these steps.

 

Here's how to manually change your beginning balance:

 

  1. Click Accounting, then Reconcile.
  2. Choose an Account, then click Resume reconciling.
  3. In the reconciliation window, click Edit info.
  4. Manually edit the Beginning balance Ending balance and Ending date.
  5. Click Save.

Additionally, you'll have to create a deposit in QuickBooks to record your interest bearing. This way, you can add your deposit transaction (interest bearing) to your reconciliation.

 

I've got this article about fixing opening balance issues for additional resources.

 

You can always swing by anytime if you have other concerns. We're here to help.

Level 1

Re: I unreconciled, but now the starting balance is wrong

Thank you for the very quick reply.

 

The starting balance is fixed as it is the balance at the end of the previous year as reconciled. I am sorry that I misled you. I was quoting the error message which appears when I start the reconciliation ""Your beginning balance is off by $..."

 

Also, I don't get "Resume reconciling" as there is no saved reconciliation since the end of last year as I unreconciled the monthly reconciliations I had done.

 

However following your solution, I simply ignored that error message, inserted the ending balance, date and then entered the total interest received this year and the reconciliation works.

 

So apparently the real "error" is that QuickBooks displays the error message at all. Assuming the actual reconciliation I do at the end of December works the same as the test run I did (without saving), ignoring the error message will be the correct solution.

QuickBooks Team

Re: I unreconciled, but now the starting balance is wrong

It's our pleasure to help, @briton.

 

You’ll receive this error when you unreconcile the status of that interest bearing account.

 

However, you can always create an adjusting entry to resolve the discrepancy. You can check the amount that you’ve added to that account by using the Search function. That’ll usually display Reconcile Adjustment on the memo field.

 

See the following article on how to find previous reconciled adjustments

 

If you have other questions in mind, please don't hesitate to go back to this thread. I’m always here to assist.

Level 1

Re: I unreconciled, but now the starting balance is wrong

I am in the same situation where I unreconciled through the accountant version now the beginning balance is off. Following your instructions, it does not allow me up update the starting balance as you state it should. How do I correct the starting balance? I use the desktop version of quickbooks daily. The online version IS NOT USER FRIENDLY. This is incredibly frustrating! 

Moderator

Re: I unreconciled, but now the starting balance is wrong

Hi Kacie, 

 

We can update the starting balance in the Bank Register. Though, in your case, we'll have to consider checking the reconciliation report. Let's look at those transactions which affect to change your starting balance. Once found out, let's redo the reconciliation.

 

Before giving you the steps on how to do it, let me share with you the two possible reasons why the starting balance was off after you unreconciled them:

 

  • Transactions were reconciled which should not be part of the reconciliation.
  • There were transactions we missed to reconcile.

 

Here's how to pull up the reconciliation discrepancy report: 

  1. Hover your mouse to the Accounting bar.
  2. Choose the Reconcile section.
  3. Click on History by account link from the upper right hand,
  4. Choose a report and when you open it, you'll see Reconciliation Change Report.

acc.PNG

 report.PNG

 

Here's how to update the starting balance:

  1. Go to Accounting on the left panel.
  2. Select the Chart of Accounts section.
  3. Select the opening balance entry to expand the view. 
  4. Edit the balance In the Deposit column. This way, it'll match your bank records.
  5. Hit Save. Then select Yes if QuickBooks asks you to confirm.

 

For more details, please consider checking these articles:

 

I'll be around if you need further assistance. 

Need to get in touch?

Contact us