Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

How can I start fresh reconciling account that's never been done, opening balance wrong, some entries marked as reconciled, but no history in qb online.

Hello, I am trying to sort out a checking account started in 2014, I have the old bank statements. Opening balance those 11k somehow, should be 0. Cannot be changed. I started off using qb desktop, then switched to online a couple years later. Some entries show as reconciled, but qb online has no history of reconcile for this account. Tried adding journal entry before all transactions showing 0, but still shows wrong opening balance. How can this be fixed?
4 Comments
QuickBooks Team

How can I start fresh reconciling account that's never been done, opening balance wrong, some entries marked as reconciled, but no history in qb online.

Thanks for joining us here today, @dansciol.

 

I'll help share some information on how you can fix your opening balance. Let's go to your Chart of Accounts to begin.

 

If you're reconciling this account for the first time, your opening balance entry will already be reconciled. Here's how to review the account.

  1. Go to the Accounting menu, then select Chart of Accounts.
  2. Find the account on the list. Then, choose Account history to get more details.
  3. Scroll through the list until you find the opening balance entry. It should have an R in the tick column.
  4. Review the rest of the list. There should be a C or blank box in the tick column.
  5. If there's an R on any other transactions, click the box in the tick column. Keep clicking it until you see a C or blank box. Then, hit Save.

After correcting the opening balance, you'll want to reconcile your account again. You can check out this guide for details: 

Fix beginning balance issues during your first reconciliation in QuickBooks Online.

 

I'm also attaching these handy articles for additional reference.

 

In case you need help with other QuickBooks tasks, click this link to go to our general topics with articles.

 

You can always count on me if you still have questions about reconciliation, @dansciol. Feel free to come back to this thread anytime. Take care and have a good one.

Level 1

How can I start fresh reconciling account that's never been done, opening balance wrong, some entries marked as reconciled, but no history in qb online.

Thanks, I did see this info when searching. Is there a way to uncheck all as not reconciled, even with none showing in the reconcile history? why can't I just edit opening balance to 0?

It's looking like I have to go a manually uncheck thousands of transactions as reconciled because the online and desktop versions could not translate this simple data.

Appreciate any advice. Thank you

QuickBooks Team

How can I start fresh reconciling account that's never been done, opening balance wrong, some entries marked as reconciled, but no history in qb online.

Hi there, @dansciol.

 

I'm here to help undo your reconciliations in QuickBooks Online (QBO).

 

For now, the option to undo multiple reconciled transactions is unavailable in QuickBooks. You may need to edit each transaction manually if you wish to undo it. You can use your bank statement to identify the transactions you need to edit. 

 

Here's how:

 

  1. Go to the Gear icon.
  2. Select Chart of Accounts under Your Company.
  3. Locate the appropriate account for the transaction.
  4. From the Action column, select View Register (or Account History).
  5. Identify the transaction to edit.
  6. In the reconcile status column (indicated by a checkmark), repeatedly select the top line of the transaction to change the status of the transaction.
  7. Select Save.

undo.PNG

I can see how this option would be helpful for you and your business. Therefore, let me take note of this as a suggestion to improve your QuickBooks experience.

 

In addition, you can reach out to your accountant and check if they have a QuickBooks Online Accountant (QBOA) account. This way, they can undo multiple reconciled transactions without manually editing individual transactions.

 

For additional information on how to undo a reconciliation using QuickBooks Online Accountant, you may check this article: How to undo a reconciliation using QuickBooks Online Accountant.

 

Feel free to add a comment below if you have any other reconciliation concerns. Wishing you continued success!

Level 1

How can I start fresh reconciling account that's never been done, opening balance wrong, some entries marked as reconciled, but no history in qb online.

Ok, looks like I'll be clicking for a while. It's ultimately my fault for not doing this sooner.

 

This option to un-reconcile would be something QB absolutely needs to add or correct going forward. Many people posting this issue. System should import reconcile history when importing from qb destop to Online.

Pass it on, thanks

Need to get in touch?

Contact us