Can a bank reconciliation be restarted after bad data import?

Hi Xean45,

Thanks for contacting us in the Community. Reconciliation can be a lengthy process and I'm glad you're using QuickBooks to help streamline this process. The program is designed to help you save time so you can do the things that you enjoy the most. I'll be glad to share more information about reconciling your accounts. 

Based on what you've shared, I highly recommend getting in touch with an accounting professional for expert advice on how to handle the transactions. If you're not in contact with a professional, don't worry, you can search for one using this link here. Otherwise, I recommend you to check out these helpful resources with more info about reconciling in QuickBooks:

• Reconcile hub
• Fix issues for accounts you've reconciled

I encourage you to go through the articles above as they provide helpful information which will help you complete your reconciliation with ease. If you have questions, don't hesitate to reach back to me here. Otherwise, I wish you a great rest of the week.

Hello James,

I AM the accounting professional. I have decades of experience, work in a firm that serves thousands of clients and my specialty is periodic bookkeeping and bank reconciliations. The articles linked help with a bank reconciliation that has gone astray, but does not deal with an account that was imported with bad data.

To reiterate: I know what the GL should be, I know what the bank's opening balance is and I know what checks are outstanding. Can the reconciliation just be reset, as you can with other bookkeeping software, to get this back on track?

Thank you.

Hi there Xean45

I can provide some information about this. An accountant-level user using QuickBooks Online Accountant can undo a reconciliation by following the steps outlined in this article,

If you have any other questions, feel free to reach out here.

@Xean45 

Which QB Desktop year version does your client have?

Hi Xean45,

QuickBooks Online, enables you to enter the beginning balance, so it matches the bank account.  Since the accounts were previously reconciled prior to moving to QuickBooks Online, you can choose to add or edit the opening balance by following the steps here.

Should you require additional assistance, please don't hesitate to contact us. Your success is our number one priority and we'd be happy to help!

Hello Alex,

As stated in the original write up, there are no bank reconciliations to Undo.

It was from the 2023 version, but it's kind of irrelevant at this point since they've already plugged in an entire year of bookkeeping in QBO post conversion.

Hello Trish,

I found that article and tried it before posting here. Though I can use that to adjust the GL balance, the bank reconciliation then reports 'The opening balance is off but we can help fix it' by the same amount. If I adjust that, then the GL is once again out by the same amount. I can make it match but then the reconciliation is then out by the same amount.

@Xean45 

It was from the 2023 version, but it's kind of irrelevant at this point

This is very relevant. You may have 2 options

1. Purchase a third-party condense service to remove old data and you don't need to convert data from 2010.

2. Start your QBO account from scratch. You can use the trial version to access your historical data in QB Desktop for good.