Deleted duplicate payments and now balances are messed up - cannot reconcile my QB online bank account

@vhmills  That happens whenever you delete transactions that have already been reconciled.

While you can correct this by doing a 'mini-reconciliation', say for the first non-reconciled day, to restore your proper opening balance, I'm more concerned that you were able to reconcile despite, presumably, including these duplicate transactions in the reconciliation. That implies that you had other problems in your books offsetting those duplicates.

For the time being, may be helpful to share what the journal entries in question were.

Managing payment transactions in QuickBooks Online (QBO) can be challenging, especially for new users. If you've already tried to fix the concern, I'm here to further assist you, Vhmills.

During reconciliation, we rely on the bank/credit card statements. Since the payments were deleted, QuickBooks records will no longer match your statement, leading to an incorrect opening balance. It's no longer needed to add the deleted payments, your CPA already created a journal entry to adjust this. What we need to do next is to manually reconcile this journal entry to correct the opening balance and start your new reconciliation.

Here's how:

1. Go to Transaction and choose Chart of Accounts.
2. Locate the Receive payments deposit account (Cash, Bank, Checking).
3. Click View Registered.
4. Find the exact payment amount, then mark it with an "R" to manually reconcile.
5. Click Save.

Please consult your accounting professional or CPA for assistance and guidance on the chart of accounts section.

You can then check last year's opening balance and proceed to reconciliation. Refer to this article for guidance: Reconcile an account in QuickBooks Online.

Additionally, learn how to categorize transactions uploaded to QuickBooks Online: Categorize and match online bank transactions in QuickBooks Online.

If you need additional assistance with managing or reconciling transactions in QuickBooks Online (QBO), please know that I'm always here and eager to help. Don't hesitate to reach out whenever you need support.