Skip to main content
K
KS1966
January 4, 2023
Question

I was told today by Bank of America that customers can no longer get automatic uploads into the bank feeds for review and that we have to do it manually. Is this true?

  • January 4, 2023
  • 2 replies
  • 0 views
I can manually download the checking, savings and payroll but the credit cards say, "The uploaded file isn't a valid web connect file"  If I use spreadsheet it puts the charges in the bank feed as payments and you cannot edit them to put in charges.  In addition, at the end of all this, the bank balance, (not the QB bank balance) but the bank balances don't match.  BOA says they can't do anything about that and that QB did this to all BOA customers so what bank is everybody moving to?  It would have been nice to get a notice from QB and I have the advanced version and 24 accounts.

2 replies

Adrian_A
Adrian_A
January 4, 2023

I appreciate you for posting in the forum, KS1966.

 

I'm here to help resolve your banking concerns.

 

Once you connect your bank account, QuickBooks will automatically download the recent transactions. From there, you can review and categorize them. However, if you manually upload the said transactions, and you're getting the The uploaded file isn't a valid web connect file error, you may be using a different file type.

 

Currently, QuickBooks Online only supports these file extensions for manually uploading of bank transactions:

 

  • Comma-Separated Values (CSV)
  • QuickBooks Online (QBO)
  • Quicken (QFX)

 

To isolate this issue we can download them again from your bank's website, the reupload it again to QuickBooks. You can refer to this article to be guided in doing it: Manually upload transactions into QuickBooks Online.

 

As for the bank balance, there are several reasons why this happens. It includes:

 

  • Outstanding transactions
  • New transactions for a connected account
  • Duplicate transactions
  • Edited or deleted transactions
  • Credit card (liability) account

 

Please check this article to find out the recommended fix for the mentioned reasons: How to Fix Differences Between QuickBooks Balance and Bank Balance.

 

Once all of your transactions are in QuickBooks, we can now start matching and categorizing them.

 

Don't hesitate to reach out to us if you need assistance in ensuring all your transactions are recorded accurately.

K
KS1966Author
January 5, 2023

Adrian, This doesn't work.  This is not true, it's what you tell people and no, I will not get stuck in another two hour loop of support that solves nothing.  

Fiat Lux - ASIA
Fiat Lux - ASIA
January 5, 2023

@KS1966 

Explore MT Online or one of the converter tools (e.g csv2qbo) as a workaround.

https://www.moneythumb.com/?ref=110

 

K
KS1966Author
January 5, 2023

Fiat, Thank you!  I have no choice but to find a work around and this might be it.  The "fluff" answer that QBO provides above is just what they have rehearsed and regurgitate over and over thinking that it actually solves the problem.  Those things don't work.  I have better things to do than to chat for hours with a support system that does not solve my problem so I will check out money thumb to upload transactions and I will ignore what the bank balance says, (not the QB bank balance but the bank balance displayed on QB, it falls on deaf ears, as if I don't know the difference).  My only concern is when I go to print financial reports.  I can only hope and pray that the bank balance on the reports will be the actual bank balance in the bank.  We shall see.  I need to become an engineer for QBO so I can learn to solve my own problems.  This is a start, thanks, again!

Terms & ConditionsAccessibility statement