Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
Margaret Camp
June 17, 2026
Question

Bank accounts disconnected/reconnected - best cleanup approach?

  • June 17, 2026
  • 1 reply
  • 12 views

I inherited a QuickBooks Online where bank feeds were disconnected last year and immediately reconnected. Instead of reconnecting to the existing bank accounts, it appears that new bank accounts were created and historical transactions were imported going back to January 2024.

 

As a result, there are now active bank accounts and inactive/deleted bank accounts representing the same real-world bank accounts for Jan 2024 to mid-year 2025.

 

The deleted accounts still contain historical activity and balances. The active accounts also contain historical activity. The balances are not exact duplicates, which makes me think the transaction history may have been split between the old and new account structures rather than simply duplicated.

 

QuickBooks later created several transactions labeled “Created by QB Online to adjust balance for deletion” and posted the offsets to Opening Balance Equity in order to zero the deleted accounts.

 

I have already adjusted the active bank accounts so they match the actual bank balances, but I am now trying to determine the best way to clean up the historical account structure and ultimately clear Opening Balance Equity.

 

Any guidance would be greatly appreciated.

1 reply

E
EmanE17QuickBooks Team
QuickBooks Team
June 17, 2026

You can run a Transaction Detail by Account report for each account and compare them side by side with your actual bank statements. This will help you identify which transactions are in the deleted accounts, which are in the active accounts, and where any gaps or overlaps occur.

 

Here's how:

 

  1. Go to the Reports menu.
  2. Search for Transaction Detail by Account.
  3. Set the correct date range.
  4. Filter for each bank account individually.
  5. Export the reports to Excel and compare them to your bank statements for January 2024 through mid-2025.

 

Once you have compared the reports with your bank statements, the next step is to seek guidance from an accounting professional. They can help you properly address your historical account structure and clear the Opening Balance Equity account, as they are best equipped to identify the correct accounts that need to be settled.

 

Let us know if you need further assistance.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement