Solved

HELP - - Accidentally Auto Adjusted During Bank Reconciliation

Forum|Forum|5 years ago
December 16, 2020
2 replies
0 views

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

QuickBooks Online

Best answer by Rea_M

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.

DivinaMercy_N

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.

C

Custom SoundAuthor

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?

R

Rea_MAnswer

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.

M

Myralyn

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

AlcaeusF

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#M72307.

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!

Sign up

Login with SSO

Login to the community

Login with SSO