QBO bank feed impacting register balance

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:

• Move your QuickBooks Desktop file to QuickBooks Online
• Learn how features and data move from QuickBooks Desktop to QuickBooks Online

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:

• Unmatch downloaded bank transactions or move them to another account
• Reconcile an account in QuickBooks Online

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.

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?

Thank you, jenop2.  I did upload the file again, and this time the register balance was incorrect compared to the desktop file though the Balance Sheet and P&L were correct.  Interestingly, the incorrect register balance is the same number as it was changed to after connecting the bank account yesterday.  I tried one more time and it is still incorrect.  Seems that the number is being cached somewhere. The bank feed was disconnected yesterday while on the phone with the support rep and I also deleted it on the bank side, so I don't think that it causing the problem.

What is my next step?  

I appreciate you following my colleague's advice to overwrite the existing file during the upload, and it's reassuring that the Balance Sheet and P&L are aligned. Let's look more closely at this issue and work together to resolve the register balance discrepancy, rwallis54.

The Bank register includes all transactions that have been imported from your connected bank as well as those manually entered in QuickBooks Online (QBO). The bank balance, however, is derived from transactions conducted with your actual bank.

To resolve this issue, I suggest checking all your transactions from the register and then matching and categorizing all your downloaded transactions. You may also delete transactions that you do not recognize.

Here's how:

1. Go to the Banking menu, then choose the Banking transactions tab.
2. Scroll down to select the For Review tab.
3. Select the checkboxes of the transactions to exclude.
4. Click the Batch actions drop-down button, then choose Exclude Selected. 

5. Once done, it will transfer on the Excluded tab for your reference. From there, you can select the transaction by putting a check mark beside it, then select Delete on the Batch actions button.

On the other hand, I'd recommend reconciling your account to ensure your bank and credit card statements match with QBs.

Additionally, you may also access expert accounting and tax assistance all in one location with QuickBooks Live Expert Assisted.

If you need further assistance matching your bank with your register balance, just reply on the thread. We are here to help. Have a good day ahead!

Marilyn, thank you for your response.  There is no connected bank feed.  I removed that before trying the upload again, both from within QBO and also on my bank's side.

I guess I will try phone support again, to see if I get a different agent this time.

I worked with a telephone agent who was helpful as much as he could be.  He had me do the purge company process and then reupload.

Once again the balance in the QBO bank register is wrong.  However, I did notice something else.  I have been solely focused on the primary bank account balance, since adding that feed yesterday was where things went wrong.  I do also have a Paypal register, and I noticed today that the Paypal register is $629.20 more than it should be, whereas the primary bank account register is $629.20 less than it should be.  Apparently in the upload process there are transactions being changed, but I really don't have a way of identifying them.  I have already searched in the Desktop file for a single transaction of that amount and there isn't one.

Any more suggestions?  Is there a next-level support tier who could help?

Thanks for the additional details you've provided, rwallis54. I've got the extra help you need to fix this register balance discrepancy in QuickBooks Online (QBO).

I appreciate your efforts in contacting our live support team to find possible solutions for this issue.

Since you've mentioned that you have a PayPal account in your register, please note that connecting a bank to QBO doesn't affect the register balance. Only manually entered, categorized transactions and the beginning balance can affect it.

To identify which transactions caused this balance discrepancy, I suggest manually reviewing them. If there are multiple transactions involved, feel free to reach out to your accountant for help in examining those unusual entries.

If you want to track the dates when your account balance and bank statement balance match, you can start reconciling your account. Here's how:

1. Go to the Transactions menu and select Reconcile.
2. Choose the account you want to reconcile from the Account dropdown.
3. Match the Beginning balance in QuickBooks on your statement.
4. Enter the Ending balance and Ending date on your statement.
5. Once you're ready to start, click Start reconciling.
6. One by one, compare the transactions on your statement with what's in QuickBooks.
7. When you reach the end, the difference between your statement and QuickBooks should be $0.00. If it is, tick Finish now.

For guidance on the next steps after reconciling, please refer to this guide: Reconcile an account in QuickBooks Online.

Additionally, this article can help you resolve issues with past reconciliations: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Keep me in the loop by tagging me in your reply if you have more queries about fixing account balances. We're determined to help, rwallis54.