Skip to main content
A
azjb
March 18, 2022
Solved

Maintaining a Connection with American Express Business Credit Cards

  • March 18, 2022
  • 1 reply
  • 0 views

I've been at this for the better part of this week and maintaining the connection with American Express is simply not happening.  I can connect and download my transactions for certain, but the connection is lost immediately afterwards and therefore, I have to re-enter my login information every single time.  I've contacted customer service on both ends, but nothing resolved yet or any solid ideas on how to fix this.  Does anybody know what's going on, have a suggestion or guess at what I can try to maintain this connection as QB suggest can be done?  Please let me know and thanks in advance. 

Best answer by azjb

 

Thanks for coming back to us and sharing some updates about this banking issue, @azjb.

 

While QuickBooks is just a receiver of your bank feeds, the connection authentication is something that is out of our control. This security is controlled by the financial institution you connect in QuickBooks.

 

Users usually get those mentioned errors if the F.I. requires additional security requirements. While researching the issue we found that the bank website is prompting for OTP during each login attempt for security purpose and our product will behave the same way as per FI website and thus it is prompting for OTP in each login attempt (and /refresh ) for security purpose. If your bank or FI asks for an OTP, get your OTP (on a device, through text, call, etc.), the only workaround is to enter the code each time you see the errors.

 

I'm leaving the following links to help explain the error messages you're getting and how to handle them:

 

 

This thread is always open for updates and additional concerns. I'll be right here if you need other help too.


Thank you everyone for your replies...  Actually, turned out to be something far more simpler...  In order to keep the connection open with American Express, I needed to switch the connection to "American Express Business Credit Card (US)" and now everything seems to be working okay.  Please note that there are several choices when setting up an American Express card, but for me, this setting worked.

1 reply

D
DebSheenD
March 18, 2022

Thank you for posting your concern here in the Community, azjb.


May I know the specific error code/message? This way, I can provide a timely solution to your concern.

 

It could be there are formatting restrictions in your file, and that's why the system says the format is incorrect. That being said, I suggest checking the file format if it's accepted by QuickBooks. And, you can try to change/rename the file extension to lowercase as having done with other users to main the connection. Then, make sure that your file doesn’t break the following formatting limitations:

 

  • Special characters are not allowed.
  • Zeros (0) are not allowed anywhere in the file.
  • Correct any transactions that display an amount in the Description column.
  • Remove the word amount if it appears in the name of the Credit or Debit column.
  • MAC  users must save the file as a Windows CSV file.
  • Correct and standardize the Date format to a single format (for example, dd/mm/yyyy).
  • Some banks provide the day of the week and include it in the Date column (for example, 20/11/2018 TUE in column A) which is not an acceptable format. To correct this, split the date and the day of the week in two separate columns.

 

Please check this article to see steps on how to fix different banking errors: What to do if you see a bank error or bank transactions won’t download. 

 

As always, you can reach back out if you have further questions about bank connections in QuickBooks Online. I’d be happy to answer it for you.

A
azjbAuthor
March 18, 2022

Different errors at different times: 103 / 107 / 185.  Looked up the codes via your string as since I've reconnected several times, ruled out 103 and 185.  However, 107 is a new one on me.

 

As for uploading .csv files, no need/avoiding this as I prefer the convenience and accuracy of downloading the transactions.  The connection works temporarily after reconnecting via the link provided in the error message and therefore, I can stay up to date.  However, ideally and as suggested, the connection should be maintained.

 

Thanks for any and all help...

Terms & ConditionsAccessibility statement