Importing Credit Card Transactions

BaseballFan · ‎March 17, 2018

We have a business credit card with Chase Bank - with 8 user accounts (meaning each person has their own card number but they are all billed on one statement with one total balance due). Up until a recent change with Chase we were able to download the transactions per card to a seperate GL account within the chart of accounts. We were recently issued new cards for each user. Knowing this, I disconnected each account and then re-connected them to download the activity for the new cards. This was all working fine until one account downloaded everyone's activity. This one account has always been our main business account with Chase - meaning the bills even come with this number as the billing account number. Yet, everyone's activity is seperated out within the bill and have always been downloaded seperately until this recent change.

What is your suggestion to seperate the activity for this one card so that only the transactions for that card will download to QuickBooks for their activity? (We like to have them download to individual GL accounts so that we can determine which card holder owes us receipts. Yet, this will make that difficult.)

MichelleT · ‎March 19, 2018

Hi there, @BaseballFan,

Thank you for giving a thorough explanation of what’s happening with the Chase credit card transactions.

Our Online Banking Team sent a communication that there’s currently an issue with importing credit card transactions from Chase into QuickBooks Online. The same transactions are showing up in all accounts even if these accounts are set up as sub-accounts of the main account.

In the meantime, you’ll need to exclude the duplicate transactions. Then, manually import the transactions into your individual GL accounts. Here are the steps:

1.   Login to your bank website and select the date range of transactions you want.
2.   Select an approved file type to convert transaction data to.
3.   Save the transaction file to your computer.
4.   Log into QuickBooks Online.
5.   Go the Banking tab and choose Upload.
6.   Under Browse select your transaction file.

While we’re still working on finding a fix, I need to get you in contact with our Customer Care Team. I need to have you added to the list of affected users so you’ll be notified through email once a fix is available.

I’m sure our Online Banking Team will find an immediate fix to this issue. If there’s anything else you need, feel free to let me know.

View solution in original post

BaseballFan · ‎March 19, 2018

Thank you, Michelle. Do I need to do anything to get on the list with Customer Care so I will get the email update?

MichelleT · ‎March 21, 2018

Hi there, @BaseballFan,

All you need to do is get in touch with a specialist from our Customer Care Team. The specialist will ask a few questions to verify your account, such as the company ID and email address.

You will receive email notifications about the status of the issue once you’re added to the list. Please check your email from time to time and make sure the notifications are not going to the spam or junk emails.

Stay in touch with me if you need additional information.

kateb77 · ‎April 16, 2018

Just wondering if this issue has been fixed or if you've had any update from the customer care team?

I am having this same issue with several clients who have MANY transactions so it is not easy to filter through the main card holder and cross-reference the online list of transactions to then exclude the relevant charges. This is becoming quite stressful as it's been happening for months..

So just curious if there's an update?!

FritzF · ‎April 16, 2018

Hello there, kateb77.

Thank you for responding to this thread.

Currently, our product developers are still working to get this issue fix as soon as possible. I'd suggest contacting our Customer Care team so you'll be added to the notification list as well.

Click this link on how to reach them:

QuickBooks Customer Care Team

Please leave a comment below if you need anything else.

mgbff15 · ‎April 19, 2018

How can I manually upload into QB's from Chase? They only have excel, iif, or csv file. I had it sync through QB's but had same issues uploading to one account and after deleting transactions, QB will not let me go back further then the last upload even though transactions were deleted. Is there a way to remove that setting?

Dwayne · ‎April 20, 2018

Hello Mgbff15,

I've got what you're looking for. You have a step by step way of manually uploading transactions by going here.

Let me know if you have more questions.

UMDJeremy · ‎April 28, 2018

@MichelleT can you please add me the list of affected users for this? It's incredibly frustrating that this has occured since March for two of my clients. The way it used to work is what needs to happen, because as it is now, it's impossible to reconcile or link to Expensify for each cardholder. Thank you.

4comp · ‎May 11, 2018

Please add me to the list of those who are informed when this matter is fixed. Or please clarify if this is the new way transactions will be brought in to QBO. Thanks

MfB · ‎May 11, 2018

The fix is taking many months to resolve...

MichaelDL · ‎May 11, 2018

Hi there, 4comp and MfB.

@4comp, in order to be given e-mail updates, your QBO company needs added to the affected list. This list helps the developers stay up-to-date on the scale of any given issue. I can't take this information in a public space like the Community, so I'd recommend reaching out to the QuickBooks support team to make sure you're included. You can find their contact information at the link here.

@MfB, I appreciate your continued patience while this gets resolved. Banking feed issues like this are the result of financial institutions like Chase constantly updating their websites and security measures to meet the ever-changing world of business technology. When these updates occur, QuickBooks has to change the way it interacts with that bank in order to keep things importing smoothly. It would seem this particular change with Chase has created some technical barriers that are taking longer than usual to work around. Rest assured, once you're added to the list, you'll be the first to know once a resolution is found.

If either of you need a hand with anything, feel free to reach back out. I'm always here to help.

JMills00 · ‎August 02, 2018

Is this still not resolved? I'm having this issue and it's so frustrating!

kateb77 · ‎August 02, 2018

Nothing has been resolved and I have this issue with multiple clients, still. It is VERY frustrating. I tried talking to QB support and was told I would need to call the bank and resolve it with them instead.

UMDJeremy · ‎August 02, 2018

@kateb77 if you get anywhere with Chase please reply back here as that'd be great! This is so frustrating and making me contemplate having my client move from Chase to Amex or something else. Anyone know if Amex works correctly for business cards with additional cardholders?

kateb77 · ‎August 02, 2018

Now that you mention it, I just started working with a new client who uses AMEX. They have 2 AMEX cards, both are linked, but only one of the cards is importing the transactions. Again.

MichelleT · ‎August 02, 2018

Hi, everyone.

We appreciate your patience while waiting for this to be fixed. Let me share some updates about the duplicate transactions from Chase and Amex.

We continue to partner with Chase to fix this in a timely manner. In the meantime, you need to exclude the duplicates, so the bank balance will be up to date.

Let me walk you through the steps:

1.   Click Banking.
2.   Choose Chase Credit Card from the Bank and Credit Cards drop-down menu.
3.   Locate and select the duplicates in the For Review tab.
4.   Select Batch actions.
5.   Choose Exclude Selected.

If you have not contacted our Support Team yet, please do so to ensure you receive notification emails about its status.

@kateb77, we have received reports from some users that Amex credit cards with multiple sub-cardholders are downloading all transactions to one card. I know you’ve already contacted our Support Team.

However, I need to get you back in touch with them to add you to the affected list. We’ll provide more information once you’re added.

I’ll update this thread as soon as I get new information. If you need assistance with anything, please reach out to me and I’ll be here to help. Thank you once again for the patience.

View solution in original post

kateb77 · ‎August 23, 2018

Looks like this issue has been fixed, folks!! Woohooo!!!

SterlingD · ‎August 23, 2018

Hello, @kateb77.

WooHoo is right! I'm happy to hear your transactions are importing properly now.

Thank you for being patient as this was sorted out. If you need any further assistance, don't hesitate to reach out. I am always just a post away. Have a wonderful weekend.

UMDJeremy · ‎August 24, 2018

@kateb77 @SterlingD

How can you tell it's fixed? I just went into one of my clients experiencing this problem with Chase Ink card and updated the bank feed. There are some charges that posted 8/22 and appear on both the individual cardholder AND the master cardholder's feed.

So not sure if it is truly fixed!

JMills00 · ‎August 24, 2018

Agree, I just checked as well, I have some transactions that posted 8/22 and only appear on the master cardholder account feed.

UMDJeremy · ‎August 24, 2018

@JMills00 Chase or Amex?? is the post date of 8/22 the date that appears in QBO? Finally did you ever disconnect then reconnect the feed?

JMills00 · ‎August 24, 2018

It's a Chase account and yes, 8/22 is the posted date that appears in QBO. I had not done a recent disconnect and reconnect of the feed but since your message I performed that task. Now, I have transactions in the correct sub-accounts.

arodwh99a · ‎August 30, 2018

Hi -

As of 8/30/18 I can say that this problem is still occurring with the master Chase credit card. Do we have an ETA when this problem will be fixed?

Thanks.

FritzF · ‎August 30, 2018

Hello, arodwh99a.

Thanks for posting here in the Community. I want to make sure this is properly addressed for you.

I've checked with our Support Team to see if there are any updates with this issue and there are no updates yet. Our product engineers are still working with Chase Bank to resolve this issue. For the meantime, if you're still getting duplicate transactions, you can manually exclude them from your Banking menu.

Here's how:

1. Go to the Banking menu at the left pane then select For Review tab.
2. Click the check boxes to the left of the date for the transactions you want to exclude.
3. Once done, click the Batch Actions drop-down and select Exclude Selected.
4. The transactions move to the Excluded tab.

While we don't have an exact time frame as to when this will be fixed, I'd suggest you contact our QuickBooks Customer Care Team again if you haven't yet. They can add you to our list of affected users, and you'll receive an email notification once an update is available.

You can reach them through this link: https://community.intuit.com/articles/1145770.

Thanks for your understanding and patience while we look into this. Don't hesitate to leave a comment if you need further assistance. I'll be around to help.