SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

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.
azjb
Level 2

Maintaining a Connection with American Express Business Credit Cards

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. 

Solved
Best answer March 28, 2022

Best Answers
azjb
Level 2

Maintaining a Connection with American Express Business Credit Cards

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.

View solution in original post

9 Comments 9
DebSheenD
QuickBooks Team

Maintaining a Connection with American Express Business Credit Cards

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.

azjb
Level 2

Maintaining a Connection with American Express Business Credit Cards

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...

azjb
Level 2

Maintaining a Connection with American Express Business Credit Cards

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...

azjb
Level 2

Maintaining a Connection with American Express Business Credit Cards

pt 2.  When re-entering my sign in details to reconnect, I always receive a request for a password code (2-step security) twice.  I suspect herein lies the problem as every time QB tries to login automatically, Amex might be requesting a code.  Therefore and again, unable to maintain the connection as that cod is random each time. Seems to me that there is (or should be) a partnership protocol that allows for this connection to be maintained; I'm no expert of course but this seems a reasonable guess.

Jen_D
Moderator

Maintaining a Connection with American Express Business Credit Cards

 

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.

azjb
Level 2

Maintaining a Connection with American Express Business Credit Cards

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.

AlcaeusF
Moderator

Maintaining a Connection with American Express Business Credit Cards

Hello @azjb,

 

I have reviewed the solution you’ve shared and it's correct and accurate. Thank you for sharing your inputs to help address the issue.

 

We love to see members supporting one another! Have a great day.

GemmaR
Level 1

Maintaining a Connection with American Express Business Credit Cards

Where can I find the Business Credit Card Option? I only have the delegate option

 

JeraldR
QuickBooks Team

Maintaining a Connection with American Express Business Credit Cards

Looks like you're having trouble finding your bank in QuickBooks, and there could be several reasons for this issue, Gemma. I can guide you through some steps to resolve it.
 

Here are the reasons why you can't find or connect to your bank.
 

  • Your bank has multiple names on our list.
  • Some banks don't connect to all types of accounts (e.g., personal vs. business accounts).
  • Your bank is not a participating financial institution.
     

Here are some tips you can perform:
 

  • Ensure you spell your bank’s name exactly as it appears on their website.
  • Use broader names like Citi.
  • Enter your bank's URL directly into the search bar (e.g., hsbc.com for HSBC).
  • Search by the issuing bank's name (the bank that issued your bank card), which you can find on the back of your card.
     

If you have tried all the tips above and still don't work, you can request support from your bank. Here's how:
 

  1. Navigate to Transactions, then select Bank Transactions.
  2. Click on the Link account.

  3. Enter your financial institution’s name. If it’s not found, QuickBooks might say, Hmm, we can’t find [bank’s name] in our list of providers, and give you further suggestions.
  4. If you’re still unable to find your bank, select Request.

  5. Enter your bank's web address (URL) in the field provided, then select Request.


     

For more information and detailed steps on how you can find your bank in QuickBooks, refer to this material: Find your bank or credit card account when you connect to online banking in QuickBooks Online or Sel....

 

Moreover, when you connect your bank in QuickBooks Online here's an article that guides you on how to categorize bank transactions to ensure accurate and detailed record-keeping of financial transactions: Categorize online bank transactions in QuickBooks Online.

Additionally, once you connect your account, you can check our QuickBooks Live Expert Assisted if you need help keeping your business organized. 
 

Let me know if you have questions about finding a bank in QuickBooks Online by replying to this thread. I'm here to help. 

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

Need to get in touch?

Contact us