I have recreated and marked reconciled any transactions I deleted or changed from the previous reconciliation.....but it still won't let me reconcile.  Any other ideas?  I've checked that all entries are correct for the 2022 year I'm working in.  It says my beginning balance is off my a certain amount but all past entries have been reconciled from the previous year.??

okay so I deleted a reconciled entry in qbo as it was incorrect. I added in the correct entry from open uncollected deposits. this was done multiple times as the accountant wanted the uncollected deposits cleared up. They are now cleared up; however I cannot reconcile because now my beginning balance is off and it's because of all the deleted reconcile transactions. please help!

Let's ensure that this is resolved, so you can proceed with your reconciliation smoothly, bookkeeper_99.

If a reconciled transaction is deleted, edited, or moved to a different bank account, it will impact the ending balance of your last reconciliation. Consequently, the beginning balance of the next reconciliation will also be affected. 

Since you have already recreated the transaction, you can manually change its status to "reconciled" to restore the correct balance.

Allow me to guide you through the entire process:

1. Go back to your Chart of Accounts and open the bank register.
2. Find the transaction and select it to expand the view.
3. Select or keep clicking the box in the checkmark column until you see an R. This manually reconciles the transaction.
4. Click Save.  

Just in case you still see an alert the next time you reconcile, open the discrepancy report. The deleted transaction may still appear on the list, but the difference should be $0.00.

Once you've thoroughly reviewed the discrepancy report and ensured everything is accurate, the Total Discrepancy Difference on the report should display US $0.00. Double-check the beginning balance again in QuickBooks to ensure that it matches the beginning balance on your bank statement.

Once you know your beginning balance is correct, you can now start reconciling. 

Please feel free to save these articles for additional guidance or references whenever you are working with reconciliation in QBO:

• Enter an Adjusting Entry for a Reconciliation in QuickBooks Online
• Undo or Remove Transactions from Reconciliations in QuickBooks Online

The Community and the entire QuickBooks Team are always available and eager to assist whenever you need help.

You stated Jenop2:

      "Just in case you still see an alert the next time you reconcile, open the

       discrepancy report. The deleted transaction may still appear on the list,

       but the difference should be $0.00"

I corrected a deleted reconciled transaction in the manner you outlined. However I do not have a difference of $0.00 in the Discrepany Report for both accounts. Just one. Both accounts have been successfully reconciled after re-entering the deleted transaction. I have restarted QB Desktop as well.

How to I fix the Discrepancy Report?

Hello, ARbooks.

Form your description, you're on the right track in correcting a deleted reconciled transaction in QuickBooks Desktop (QBDT). You'll have to do the same process to your other account, so its discrepancy report will also show a difference of $0.00. I'll elaborate this in detail below.

Once your other account also has a deleted reconciled transaction, re-enter it and manually change its status to "reconciled" to correct its discrepancy. Follow the steps shared by my colleague above to complete the process.

Furthermore, I'd still recommend consulting your accountant to further guide you in keeping your accounts and financial data accurate.

You can learn more about fixing reconciliation discrepancies in QBDT by seeing this article: Fix beginning balance issues in QuickBooks Desktop.

Additionally, I encourage you to reconcile your accounts in QBDT regularly (every month). This helps monitor your income and expense transactions and detect possible errors accordingly. You may want to check out this article as your guide in doing and fixing reconciliations in QBO: Learn the reconcile workflow in QuickBooks.

I'm always ready to back you up if you need more help with bank reconciliation in QBDT. I'll keep the thread open so you can comment back.

Hello, 

I deleted and re-entered payments received but the beginning balance is still off and the deleted payments are still listed on discrepancy report. I'm afraid if I enter the deleted payments, they will show up as a double payment. Should I just enter a general journal entry to clear up the discrepancy for the beginning balance? 

I understand your concern regarding the deleted payments and the persistent discrepancy in your QuickBooks beginning balance, @skennedy9907.

Thank you for bringing this to our attention, and I'm here to help you navigate this issue.

Entering a general journal entry can be a solution, but it's a step we should approach with caution to avoid any unintended complications. Before proceeding, let's explore an alternative avenue to address this problem.

The beginning balance will still be off because it was a deleted reconciled transaction. Let's make sure that by the time you recreate the transaction, you manually reconciled this on your account. 

Here's how: 

1. Proceed to Bookkeeping or Accounting, then select Chart of Accounts (Take me there).
2. Locate the account that has the reconciled transaction. Then select View register.
3. Find the transaction. If the transaction is reconciled, you’ll see an “R” in the checkmark ✔ column.
4. Click Save.
5. Close the account register.

Moreover, I'll be sharing the following articles to help manage your transactions in QBO: 

• Learn the reconcile workflow in QuickBooks
• Enter an adjusting entry for a reconciliation in QuickBooks Online.

Please feel free to reach out to us at any time if you have further questions. We're committed to providing you with the best possible support, and your satisfaction is our top priority.

I am so sorry.    I am not a Quickbooks person - but am willing to learn.   Some how I deleted a transaction on a reconciled report for the end of May 2023.    June report was approved as everything was still good at that point.   Now I'm trying to reconcile and it won't let me and gives me the error.   I know exactly what item I inadvertently deleted.   How can I get it back?   I show it.    Have tried changing the "Not Cleared" to reconciled.   Nothing seems to work.   Please help..........................   Thank you!

I've come to help ensure your accounting data are accurately reconciled, jills83.

When a reconciled transaction is deleted from your account, you may need to recreate it manually to resolve any discrepancies in your accounts. To help you track and review the deleted entries, you can view them from the Audit log page. To do this:

1. Go to the Gear icon and click Audit Log.
2. Click the Filter drop-down and select the right user, date, and event(s). Then, click Apply.
3. Locate the deleted transaction and click View under the History column.
4. You'll see all the information needed for the entry under the Event section.
5. Then, you may utilize the details shown from there when recreating the transaction.

Once ready, you can manually reconcile the transaction from your bank register. Here's how:

1. From the Chart of Accounts, open or view the bank register.
2. Find and select the specific transaction.
3. Continuously click on the checkbox column to enable R on this transaction so this manually reconciles the entry.

Then, you may run discrepancy reports to make sure the difference between the ending balance in QuickBooks and your bank statements is $0.00.

Once everything looks good, you can start reconciling these entries in the future to ensure your books are balanced.

We'll always be available in this forum if you require additional assistance managing your accounts. Please don't hesitate to leave them in the comments below. Keep safe!

I deleted 2 deposits by mistake (Quickbooks desktop) and both customer payments are still there, but do not show up in the register.  They both show up in the Undeposited funds report as being received.  How do I re-enter them into the register?  

I've also undone all the previous bank reconciliations so that I may go back through again once they show up in the register.

Welcome to the Community, @22551. Let me help re-enter the deleted deposits in QuickBooks Desktop (QBDT).

Leaving it as Undeposited Funds is fine. However, you’ll want to delete the payment you deposited to the bank to avoid the fund overstating in your bank. Moving forward, I recommend manually receiving the invoice payment in QuickBooks Desktop (QBDT).

Once you’ve received the payment manually, you can now deposit the funds to your bank account. All payments in the Undeposited Funds account automatically show in the Bank Deposit window. Let me show you how in your QBDT software:
 

1. Go to the Banking menu and select Make Deposits.
2. In the Payments to Deposit window, select the payments you want to combine. Then select OK.
3. In the Make Deposits window, select the account you want to put the deposit into from the Deposit to drop-down.
4. Enter the needed information in making the deposit.
5. When done, select Save & Close.

You can also check this article for more details about the process: Record and make bank deposits in QuickBooks Desktop.

I’ve also added this article that you can use for future guidance in effectively reconciling your accounts in QBDT: Reconcile an account in QuickBooks Desktop.

Let me know if you have other concerns about making deposits in QBDT, It's always my pleasure to help you out. Have a wonderful day ahead!

I have several transfers from checking to savings that were reconciled in checking, but not savings.   When I reconciled savings, I noticed manually entered transactions that were duplicated.    I deleted those and successfully reconciled savings.  Apparently.. the ones I deleted were already reconciled in checking.   SO now checking is not reconcilable.    I've tried both creating the transaction again, and creating a journal entry as suggested, including marking the re-created transaction as (R) reconciled in the register.   This does not get seen as a resolution to the reconcile, but adds another discrepancy to the beginning balance issue.   I'm totally confused as to how to fix this.   

I figured out my confusion.   Recreating the new entry does not remove the discrepancy from the report.  You just need the balance to match again.  So if you had more than one issue, like I did, don't try to reconcile again until you've fixed all the issues.   I do wish Quickbooks made it easier to see the linked transactions, or tells you that the transaction you are about to delete is reconciled in another account.   I'm not an accountant and I can get seriously confused.   

I cannot find the place where i can mark the transaction to R.

please help

Thanks for joining the thread, @lhill. I'm here to help you find where to mark a transaction as reconciled.

It's important to note that even small adjustments can throw off your accounts, so it's best to consult your accountant for advice.

Once you've identified the entry to reconcile, go to the chart of accounts and access the account's register to make the necessary changes. Here's how:

1. Navigate to the Gear icon and select Chart of accounts.
2. Look for the account with the unreconciled transaction and click View register under the Action column.
3. Locate the entry and select it to expand the view.
4. In the checkmark column, click the box until it shows "R".
5. Hit Save.
6. Repeat the process for any other transactions if needed.

For more detailed information, visit this article: Undo or remove transactions from reconciliations in QuickBooks Online.

Additionally, you can close your books to prevent unwanted modifications to past transactions.

Shoot me a reply if you need further assistance with reconciling your transactions. Our priority is to make sure everything is in balance. Hope you have a great day ahead!

I apologize if this is a duplicate post. When I submitted it before it failed to upload.

I tried following your instructions, but the View Register action did not appear in the pick list of the problem account. Attached is a screen shot of the Chart of Accounts showing the pick list for account 4600. Note that the View Register is a available for account 3300. It only seems to be unavailable for the some of the accounts I have created.

What should I do next?

[Screenshot removed]

I'm glad to team up with you on this task so you can proceed seamlessly with your reconciliation, Tom. 

Thank you for following the instructions and providing the screenshot. It looks like you might be seeing the View option because you’re in the Audit Log instead of the Chart of Accounts. Let’s navigate to the correct location together.

Follow these steps:

1. Click on the Gear icon.
2. Select Chart of Accounts under the Your Company section.
3. Locate account 4600 and click on View register.

Just a bit more information for you: The View register button is available for Balance Sheet accounts, such as banks, assets, liabilities, and equity accounts that run balances. In contrast, for Income and Expense accounts that affect the Profit and Loss, you’ll see the Run report option instead.

For expanded coverage on the topics above, check out these articles:

• Learn about the chart of accounts in QuickBooks Online
• What are account registers in QuickBooks Online?

Looking ahead, you'll find this guide on generating reconciliation reports helpful if you have trouble reconciling the following months: How do I view, print, or export a reconciliation report?

If you have any more questions or need further help, please feel free to use the comment section below. I'm here to make sure your reconciliation journey is not just smooth but also efficient. I'm looking forward to making this process seamless for you!