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

HELP - - Accidentally Auto Adjusted During Bank Reconciliation

To All,

 

I am hoping someone in the community can assist. I currently run Quickbooks online. I was just getting ready to reconcile my November 2020 books and I saw that I was out of balance before I could start.

 

Looking back at my records I sort of see where the issue is, but I am not sure how to correct it.

 

My September records in Quickbooks were reconciled on 10/19/2020 with a beginning bank balance of $1,904.20 and an ending bank balance of $17,017.78 which are both correct. This is my last good reconciliation.

 

I messed up in the system and there are TWO statement endings 9/30/2020. I am trying to delete 3 reports (my second 9/30/2020, 10/31/2020 and 11/30/2020), see screen shot attached.

 

In my angst of trying to understand where my error was I made a couple of auto adjustments. This now has the system thinking that my books are reconciled through 11/30/2020, which is not correct. I cannot attach multiple screen shots to show you this one. Is there a way to attach a second screen shot? 

 

I just went back into the Chart of Accounts under the bank and said to View Register. Any transaction for November that had a “C” I updated it so it was blank (no “C”), there weren’t any that were showing reconciled. However, despite updating the bank register the reconciliation under the gear still thinks that I am reconciled through 11/30/2020.

 

I have not yet, but can go back through and remove all the “C” or “R” for October to start over. However, the system will most likely still think I am reconciled through October. When I went back in to reconcile an account it showed November as still reconciled. What can I do to force the system to understand that November is not reconciled?

 

I would like to start back with October 1st and for the system to use the last GOOD September 2020 report. 

 

Please let me know if I can provide any additional data to assist. Thank you!!!

 

Sara

Solved
Best answer December 16, 2020

Best Answers
Rea_M
QuickBooks Team

HELP - - Accidentally Auto Adjusted During Bank Reconciliation

Thank you for getting back to us, @Custom Sound. I'm here to provide options in handling your reconciliation issue in QuickBooks Online (QBO).

 

Both the undoing and manual reconciliation processes are a good practice to help keep your account updated. When you opt to use the Reconcile page, you'll need to have your accountant undo the reconciliation. This way, the section where it shows the incorrect statement ending date (11/30/2020) will be fixed to the right one (9/30/2020) along with the accurate beginning balance. Then, you can go ahead and continue with your reconciliation.

 

Manually reconciling your November transactions from your check register won't change any information in your account. This is because you're just telling the system they're already reconciled and matched with the said month's bank statement. In case you choose to proceed with this process, you need to go back to the check register's page and click each of the transactions to "R" to reconcile. (Please see the attached screenshot below). Then, the next reconciliation period will surely display the correct statement ending date on the Reconcile page.

 

Additionally, you need to regularly (every month) review your accounts in QuickBooks to effectively monitor the growth of your business. In case you need help doing or fixing a reconciliation, you can always refer to this article: Reconcile workflow in QuickBooks. It includes helpful links to start a new and/or editing completed reconciliation and fixing any possible issues.

 

I'm just around if you have other concerns or follow-up inquiries about the reconciliation process in QBO. Take care always, @Custom Sound.

View solution in original post

3 Comments
DivinaMercy_N
QuickBooks Team

HELP - - Accidentally Auto Adjusted During Bank Reconciliation

The Community has you covered, @Custom Sound.

 

You'll need to make sure that you select the correct date when reconciling your bank statement for November. 

 

To start, you have to check the opening balance. Ensure that your real-life account matches the balance with QuickBooks. Here's how:

 

  1. Go to the Accounting menu, then select Chart of Accounts.
  2. Find the account on the list.
  3. Click View register.
  4. Search for the opening balance entry. It should have Opening Balance Equity in the Account column.
  5. Take note of the date and balance.

 

If not, follow the steps in this article to fix the opening balance: Fix opening balance issue in QuickBooks Online.

 

For the next steps see our reconciliation guide

 

Also, for further assistance with the process, I suggest reaching out to your accountant. They know how to handle steps in reconciling your account. If you don't have one, use our Find an Accountant tool.

 

When the reconciliation is done, you can pull up a reconciliation report to have a summary of your beginning and ending balances and lists of cleared and uncleared transactions in QBO. 

 

Keep me posted here if you have further concerns about reconciling your account in QuickBooks. I want to ensure your success. Thanks for coming to the Community and take care.

Custom Sound
Level 1

HELP - - Accidentally Auto Adjusted During Bank Reconciliation

Thank you for your reply. My issue is that I cannot reconcile November under the gear icon>reconcile as the system thinks I already reconciled it due to my error, see attached screenshot. Is there a way to fix this section so that it shows the last statement ending 9/30/2020 with the beginning balance instead of 11/30/2020 which it shows now? Am I stuck and cannot "undo" those reconciliation reports, without my accountant doing it even though I have undone the corresponding reconciliation in the checkbook register. 

 

I have all the November transactions unchecked in my check register so I need to go through and click each of them to reconcile. Once I have clicked all the transactions to "R" that match the November bank statement will that change any information anywhere else? 

Rea_M
QuickBooks Team

HELP - - Accidentally Auto Adjusted During Bank Reconciliation

Thank you for getting back to us, @Custom Sound. I'm here to provide options in handling your reconciliation issue in QuickBooks Online (QBO).

 

Both the undoing and manual reconciliation processes are a good practice to help keep your account updated. When you opt to use the Reconcile page, you'll need to have your accountant undo the reconciliation. This way, the section where it shows the incorrect statement ending date (11/30/2020) will be fixed to the right one (9/30/2020) along with the accurate beginning balance. Then, you can go ahead and continue with your reconciliation.

 

Manually reconciling your November transactions from your check register won't change any information in your account. This is because you're just telling the system they're already reconciled and matched with the said month's bank statement. In case you choose to proceed with this process, you need to go back to the check register's page and click each of the transactions to "R" to reconcile. (Please see the attached screenshot below). Then, the next reconciliation period will surely display the correct statement ending date on the Reconcile page.

 

Additionally, you need to regularly (every month) review your accounts in QuickBooks to effectively monitor the growth of your business. In case you need help doing or fixing a reconciliation, you can always refer to this article: Reconcile workflow in QuickBooks. It includes helpful links to start a new and/or editing completed reconciliation and fixing any possible issues.

 

I'm just around if you have other concerns or follow-up inquiries about the reconciliation process in QBO. Take care always, @Custom Sound.

View solution in original post

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us