Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Collinm
Level 1

Duplicate “Opening Balance from Bank” created after reconnecting M&T feed — bank and posted balances off

Hi everyone,

 

After reconnecting our Bank account in QuickBooks, the system automatically created a duplicate “Opening Balance from Bank” deposit.

One version of this entry is reconciled (the original, correct one), and the other is uncleared, which seems to have been generated when the bank feed reconnected. I verified in the Audit Log that our online banking connection was disabled and reconnected that same day.

 

The strange part is that this duplicate deposit appears in reports like the Deposit Detail, but it doesn’t appear anywhere in the bank register, even when sorting by date.

Because of this, the bank balance matches our actual bank account, but the QuickBooks posted balance is lower, creating a difference between the two that I have been working to resolve. 

We’ve confirmed this duplicate isn’t a real transaction and that it’s a system-generated placeholder entry created by the reconnection, at least I believe so. 

 

Has anyone else experienced this issue after reconnecting a bank feed? Is deleting the unreconciled duplicate “Opening Balance” the correct solution, or has Intuit provided a different fix for this situation?

Thanks in advance for any help or confirmation from others who’ve dealt with this.

3 Comments 3
MariaSoledadG
QuickBooks Team

Duplicate “Opening Balance from Bank” created after reconnecting M&T feed — bank and posted balances off

When a bank feed is reconnected, QuickBooks Online (QBO) attempts to re-establish the link between your bank account and the account register, which can lead to the issue you're experiencing. Collinm.

 

During this process, QBO automatically downloads your recent transactions to ensure your records are up to date. This action may create duplicate entries, like Opening Balance from Bank. If there is a transaction like the opening balance in the initial connection, the system may retrieve it again during reconnection and mistakenly treat is as a new one. 

 

Since this transaction isn't showing in your bank register, you can drill down your transactions through the reports by clicking on the duplicate. This will take you to the actual transaction details, where you can verify whether they are indeed duplicate which showing on the same account and confirm if they need to be deleted. You'll want to delete if the transaction isn't necessary.

 

As a reference, I've added a screenshot below with a green box highlighting where you can click the amounts. This will allow you to drill down into the transaction details directly and verify the information thoroughly:
deposit detail.png

 

Another possible reason for this issue is when you use a bank rule, which is set to automatically to categorize transactions once they are downloaded from your bank. If the rule misapplies or duplicates certain transactions during the download process, it could lead to this discrepancy. To prevent this from happening again, double check if a rule is correctly set up. To do so, follow the steps below:

 

  1. Go to the Gear icon and select Rules.
  2. Double-check the rule or you can click Delete if this isn't needed.
     delete rule.png

 

Let me know if you need further assistance with your bank feeds or anything related to your bank balances. We're always right here to help you.  Have a nice day ahead.

Collinm
Level 1

Duplicate “Opening Balance from Bank” created after reconnecting M&T feed — bank and posted balances off

Thank you for clarifying this, that makes sense. I was able to locate and confirm the duplicate “Opening Balance from Bank” entry and found it was linked to an inactive M&T (deleted) account. When I tried deleting it, QuickBooks gave me the message saying it’s tied to an inactive account.

I reactivated that old account and successfully deleted the duplicate entry. However, the posted and bank balances on my dashboard still haven’t updated yet. Can you confirm how long it typically takes for QuickBooks to refresh those balances after a deletion like this? Or if I am off course here and maybe the problem is elsewhere?

ArielI
QuickBooks Team

Duplicate “Opening Balance from Bank” created after reconnecting M&T feed — bank and posted balances off

Thank you for coming back to this thread, @Collinm. I appreciate you following up on my colleague’s answer. To clarify, once the deletion completes it should be reflected in your feed immediately. Since the changes doesn’t appear right away, you can sign out and then sign back in to force your session to reload and pull fresh data from the server, or refresh your browser by clicking the circular reload icon.

 

333.png

 

After following the steps above and the changes still doesn't appear, I recommend reaching out to our Live Support Team so we can help resolve this concern. To reach out, you can follow the steps below:

 

  1. Click the (? Help) icon in your QuickBooks Online account in the top-right corner.
  2. Select Contact Us, then enter a short description of your concern about the Spreadsheet.
  3. Choose Chat with us to start a live chat with an agent or request a callback for phone support.

 

You can also check our support hours to know our support availability time: Get help with QuickBooks products and services.

 

Thank you for your patience and understanding. If you have any other concerns or need further assistance, please reply to this thread or contact our support tea, we’re always here to help. Take care!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us