HELP - - Accidentally Auto Adjusted During Bank Reconciliation

Custom Sound · ‎December 16, 2020

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

Rea_M · ‎December 16, 2020

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

DivinaMercy_N · ‎December 16, 2020

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:

Go to the Accounting menu, then select Chart of Accounts.
Find the account on the list.
Click View register.
Search for the opening balance entry. It should have Opening Balance Equity in the Account column.
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 · ‎December 16, 2020

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 · ‎December 16, 2020

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.

Myralyn · ‎May 07, 2021

Help me now my employees will leave because this program keeps messing with their pay !!! The auto payroll just stopped for no reason!!!!!!! Today is pay day!!!!!! call me now [phone# removed] Ms Bryan

FritzF · ‎May 07, 2021

Thanks for joining this conversation, @Myralyn.

I see that you've posted the same question twice, and the other one was already answered by my colleague. Just in case you haven't been notified of the new response, here's the link: https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/re-auto-payroll/01/867293#M7....

To keep the conversation streamlined and provide you with the best resolution, I'll ask that you post any follow-ups there.

Please let me know if you have any other questions or concerns, and I'll get back to you right away. I'm always here to help. Have a good one!

casagrande · ‎September 08, 2021

Once again this month some items paid through Telpay were withdrawn from our bank account on August 30th, but the checks are dated September 2nd in QB Online, so it is impossible to reconcile the bank statement. How is this to be resolved?

Second, this happened last month and QB did an auto adjustment entry, but now the checks cleared in August but I can't check them off as cleared because QB did that auto adjustment entry and so I'll be off the total amount of those checks too.

Rose-A · ‎September 08, 2021

Hi, casagrande. I appreciate you getting back to us.

To get this sorted out, you can delete the QuickBooks adjustment entry, go back to the Review tab, and change the dates of those transactions. This way, you'll be able to reconcile your Telpay account. Let's get started.

Click Banking in the left panel and go to the Reviewed tab.
Filter the From and To Dates to 08-01-2021.
Click Apply.
Locate and click the transaction on the Added or Matched column.
In the transaction screen, change the Date to August 30th.
Hit Save and close.

I recommend visiting this website: Reconcile Workflow. It provides you more details about starting, fixing any differences, and completing the reconciliation process. Just click the links beside QuickBooks Online.

Should you need additional help, please let me know. I need to make sure this is resolved and you're back to running your normal business processing. All the best!

Topics

Training

Community

Resources

HELP - - Accidentally Auto Adjusted During Bank Reconciliation