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

QUICKBOOKS RECONCILIATION

I've been trying to reconcile an account for months, but every time I upload transactions, they come through as duplicates. When I try to reconcile and delete the extras, it throws off the reconciliation balance. So, I decided to delete all transactions and manually upload them as a CSV. Even with a zero bank balance and entering the opening balance, the system still shows that the account is reconciled through May in the reconciliation history, despite my efforts to unreconcile all transactions. There's no option to batch unreconcile, and my bank register doesn't display any unreconciled transactions. This is preventing me from completing the reconciliation, as the beginning bank balance is shown as zero, but there's a discrepancy that needs to be addressed. Additionally, the account still appears reconciled through May, even after I manually unreconciled it in the bank register.

1 Comment 1
ShyMae
QuickBooks Team

QUICKBOOKS RECONCILIATION

I appreciate you sharing detailed information and a screenshot, Christine. Dealing with these reconciliation issues can be challenging, especially considering all the effort you've put in. Let's work together to ensure your records are accurate.

 

Duplicate entries can occur when you connect your bank account and manually upload transactions simultaneously. It could also happen if you add transactions without matching them to existing records in QuickBooks.

 

Before anything else, review the original opening balance and make sure it's correct since this is the starting point for accounts in QuickBooks. If it's incorrect, it can impact all future reconciliations. That said,  I'd still recommend consulting your accountant on this process. 

 

I appreciate your efforts in manually undoing your transactions. Undoing the reconciliation manually aims to correct specific transactions and it doesn't affect the previously reconciled periods. Check out this article for additional details: Undo or remove transactions from reconciliations.

 

Regarding the batch undo reconciliation feature, you'll need to invite your accountant to have them undo and redo the entire reconciliation on your behalf. The option to do it by yourself is unavailable. Rest assured, your accountant can help minimize disruptions and navigate the process smoothly.


Here's how you can invite your accountant:

  1. In your QuickBooks account, head to the Gear icon. 
  2. Select Manage users.
  3. Click the Accountants or Accounting firms tab.
  4. Enter your accountant's email address, then select Invite.

 

Sample.png


For additional reference, you can check out these articles as a guide to reconciling your accounts:

 

 

Moreover, you can print or export your reconciliation report to share it with your accountant or financial team in the future.


Consulting your accountant will guarantee you can undo your entire reconciliation and fix any discrepancies, Christine. If there's anything more you'd like to know or require additional clarification on any aspect, post it below. I'll ensure all your concerns are addressed and you receive the support you need.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us