Solved

Correcting for bank reconciliation

Forum|Forum|5 years ago
October 6, 2020
16 replies
96 views

A transaction was deleted after it was reconciled. It SHOULD be deleted but now I can't reconcile without clearing it somehow. How do I do this?

QuickBooks Online

Best answer by Kathy GreenBudBooks

Hi Kathy GreenBudBooks.

Thanks for dropping by the QuickBooks Community. If the steps provided by my colleagues haven't help. I would definitely recommend reaching out to support, they will be able to dive into your personal account with you in a 1-on-1 setting to diagnose what's going on.

To reach them, you can follow these steps:

Sign in to your QuickBooks Online company.
Go to Help (?).
Select Contact Us.
Enter your concern, then select Let's talk.
Choose a way to connect with us:
- Start a chat with a support expert.
- Get a callback from the next available expert.

If there's anything else I can help with, feel free to post here anytime. Thank you and have a nice afternoon.

I was able to speak with a QBO agent. After 1.5 hrs, the problem wasn't fixed but she was able to guide me thru an acceptable work-around by adding a new Balance Equity entry for the next month to be reconciled.

AlcaeusF

Level 14

Hi there, @Kathy GreenBudBooks.

Thanks for dropping by here in the Community. I can help you correct the bank reconciliation in QuickBooks.

Once you delete a reconciled transaction, it will affect the specific period and the opening balance. If your accountant have access to your company file, I recommend you request to undo the reconciliation.

The ability to perform the process is only available in QuickBooks Online Accountant (QBOA) version.

Here's how:

Go to the Accounting menu.
Select the Reconcile tab.
Select History by account.
Select the account you want to reconcile and date range from the drop-down menus.
Find the reconciliation on the list.
If you haven’t already, select View report to open the Reconciliation Report. Review any discrepancies and changes your client wants to make.
When you’re ready, select the arrow in the Action column, and then select Undo.
Select Yes and then Undo to confirm.

If you don't have an accountant, you may need to unreconcile transactions individually. Please follow these steps:

Go to the Accounting menu. Then select Chart of Accounts.
Find the account and select View register.
Select the transaction you want to unreconcile.
Review the check column. If the transaction is reconciled, you’ll see an “R.”
Select the box and keep clicking it until the box is blank. This removes the transaction from the reconciliation.
Select Save. Then close your register.

Additionally, I recommend visiting the following article to resolve problems with reconciling accounts: Fix issues when you're reconciling accounts in QuickBooks Online.

Please let me know if you need anything else. The Community and I will be here to help you.

K

Kathy GreenBudBooksAuthor

Hello and thank you for your response. Unfortunately, I'm still stuck.

When I tried following the steps you outlined for QBOA, after going from History by Account and then to View Report, I can't find the Action column and am unable to complete steps 7 and 8 below.

When I try doing it manually, the transactions (which show on the History by Account/View Report) do NOT show in the registry because they've been deleted.

These transactions were intentionally deleted after reconciling and should stay deleted. Where do I go from here. There are several of these in each of the 2 bank accounts.

C

CharleneMaeF

QuickBooks Team

Allow me to share additional info about reconciliation, Kathy GreenBudBooks.

When reconciling, even small changes can unbalance your accounts. To correct your reconciliation, we'll have unreconcile the transactions and start over from the beginning. I recommend reaching out to your accountant to undo the entire reconciliation. Doing so can help QuickBooks detect that the deleted transaction is already excluded in the data.

You can use the reconciliation report to serve as a guide to see all the transactions that need to be unreconciled.

Here's how to run the report:

Go to the Reports menu.
Type Reconciliation Report in the search bar, then click to open.
Select the Account for the reconciliation report you want to view.
From the Report period drop-down arrow, choose the reconcile period.
Click the View Report option.

If you'd like to unreconcile the transactions manually, you may follow the steps shared by my colleague.

Once done unreconciling, let's reconcile the transactions again. Here's how:

Go to the Gear icon and then select Reconcile.
On the Account drop-down menu, select the bank account you want to reconcile.
Check the Last statement ending date. Make sure your bank statement starts the day after your last reconciliation.
Review the Beginning balance. Ensure the beginning balance in QuickBooks matches the one on your bank statement. Here’s what to do if they don't match.
Enter the Ending balance and Ending date written on your bank statement.
When you're ready to start, select Start reconciling.

For more details about the process, you can check out our reconcile guide.

Additionally, I've included our Year-end guide and checklist. This helps you complete the important task to maintain accurate data of your books.

You can count on us if you have other questions in reconciling your accounts in QuickBooks. We'd be glad to assist you.

Rustler

Level 15

@Kathy GreenBudBooks

If the check was reconciled, then it is a valid transaction and should not be deleted, it did clear the bank.

Please explain the issue

K

Kathy GreenBudBooksAuthor

Hi Rustler,

The business owner reconciled the transactions for each bank account, but didn't realize that 1 bank account was a sub-account at her bank. Transactions were entered twice in QBO when both the parent and sub-account were linked to QBO. Both sets of transactions were reconciled in QBO based on the separate QBO accounts for the parent and the sub-account. I went in and deleted everything from the sub-account and then made the sub-account inactive. But, to reconcile the parent account in QBO, the Reconciliation Discrepancy Report gives me a list of 5 transactions that were deleted after reconciling that I now need to handle. When I click on "View" from the Reconciliation Discrepancy Report for the individual transactions, I get a blank screen. The previous answers in this post didn't help me get rid of these.

T

TNichols2594

Let me help you run the discrepancy report in QuickBooks Desktop, mary_c.

This report can be found in the Reconciliation Discrepancy option under Banking. This shows any transactions that were changed since your last reconciliation and they're sorted by statement dates. Let me show you how:

Go to the Reports menu.
Hover over Banking and select Reconciliation Discrepancy.
Choose the account you're reconciling and then select OK.
Review the report. Look for any discrepancies.
Talk with the person who made the change. There may be a reason they made the change. Once you know, edit the transaction as needed.

To reconcile the discrepancy report, follow the steps below:

Go to Reports, then select Banking.
Choose Reconciliation Discrepancy.
Select the Account, and then press OK. You'll have a list of transactions that changed since your last reconciliation. Use this report to identify the transaction(s) causing the issue.
If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change happened.

On the other hand, you'll have to inform the QuickBooks Admin to grant access to reconcile accounts. Just follow the steps and details in this article: QuickBooks Desktop Users and Restrictions. To fix when your accounts in QuickBooks Desktop don't match your bank statements at the end of reconciliation, check out this article: Fix issues when you're reconciling in QuickBooks Desktop.

Also, if in case you need information from your past reconciliation to review or fix a current reconciliation, just pull up a reconciliation report. For the detailed steps, please see this article: Get reports for previous reconciliations in QuickBooks Desktop.

Feel free to post here in the Community if you have any concerns about reconciling your accounts in QuickBooks. I want to make sure you're taken care of, and I'm here to help you anytime. Take care always.

You guys just automatically think that everyone that uses quickbooks has multiple users and has an accountant on staff that we can call to fix our problems. I have had quickbooks for years and never had a problem when it was the desktop version. However, the online version messes up reconciled accounts and all of the suggestions from quickbooks don't work or show useless information. I am the sole user and I have a accountant login which enables me to undo past reconciliations. That worked great on the desktop version but not on the online version. At this point, I would just love to add some money in the accounts and in the memo feild say "Whoops, somewhere I screwed up and have to fix this boo boo!
You guys remind me of Microsoft's wifi error messages that just say "Consult your system or Network administrator" which for 99 percent of laptop users is the very person that is having the problem.

I expect no answer that I have not seen a gazillion times !!! &%$#@*&%

Sign up

Login with SSO

Let's get you signed in

Login with SSO