Skip to main content
May 2, 2025
Question

QBO bank feed impacting register balance

  • May 2, 2025
  • 1 reply
  • 0 views

I imported QB Desktop to QB Online a couple of days ago. Everything matched perfectly: register balance matched the bank balance, Balance Sheet and Statement of Activities numbers matched to the penny. Today I connected my bank account with transactions starting 1/1/24. That connection changed the register balance in QBO to an incorrect number, though the bank balance is still correct.

 

Got on the phone with QBO support, one of the more frustrating experiences I have had recently, and after poking around for awhile, the support representative had me comparing bank statements to equivalent periods in the QBO register.  He suggested that I needed to go back and do that until I found where the errors were.  I asked if I couldn't just wipe the data out and reimport from Desktop again, and he said that I would have to cancel the subscription, get a refund, create a new company, subscribe again, etc.  That made no sense.  So after declining the sales pitch he made after he failed to resolve my issue, I got off the phone and did my own research. 

 

If I understand correctly, since my QBO account is only a few days old, I can just purge the data and re-import from Desktop.  Is it that simple? 

 

For further aggravation, I went back to 2015 in my Desktop file and compared May 2015 transactions to QBO, and those don't match up either.  So something in the bank feed import changed the register data going back a long time, even though I (thought I) was only importing bank transactions from 1/1/24.

 

Second question:  what about adding the bank feed could have caused this, and how do I avoid it happening again?


Thanks!

1 reply

JenoP
May 2, 2025

Providing accurate and efficient solutions is something that we always strive to deliver when customers call us for help, rwallis54. Allow me to make it up to you by addressing your concerns and providing guidance about resetting data in QuickBooks Online.

 

There's no need to purge your data if you'll be reimporting from Desktop. The system is designed to automatically overwrite the existing data in your Online version with the information from your Desktop file.

 

Here's how to initiate another upload:

 

  1. Go to the Company menu, then select Export Your Company File to QuickBooks Online.
  2. Click Get started.
  3. Choose Bring all of your company data.
  4. Click Yes, sign me in, then select Continue.
  5. Sign in with your user ID and password for your QuickBooks Online subscription.  
  6. Select the company you want to move your data to.
  7. If asked, choose Yes, go ahead and replace the data, and then select Replace.

 

 

You can see more details about this process here:

 

 

When it comes to Online Banking, most banks provide the last 90 days' worth of transactions, regardless of the chosen starting date. This can be the reason why the balance was changed when you connected your bank.

 

Here's an article that explains this feature in more detail: Connect bank and credit card accounts to QuickBooks Online.

 

I suggest reviewing the list of transactions in your bank register to see if there are missing transactions, especially beyond the 90 days.

 

You can also ask for a CSV copy of the bank transactions that are not present in BQO. Then, import it into the system to sort out the balance. Let me provide this article for a step-by-step guide: Manually upload transactions into QuickBooks Online.

 

Additionally, I'd like to share these articles that can serve as reference materials when working with your financial data in QBO:

 

 

Don't hesitate to reply if you still need more help with the bank balance. We're here to support you with any QuickBooks-related concerns you may have about Online Banking, other general bookkeeping tasks, and starting your journey in QBO.

rwallis54Author
May 2, 2025

Thank you, jenop2.  I followed your recommendation to just let the upload overwrite the existing file.  The register balance did not match this time, though the Balance Sheet and P&L did match. In fact, the incorrect register balance is the same number as it was yesterday after I added the bank feed. I ran the upload once again, and again the register balance is incorrect.

 

What is my next step?