Linking Edward Jones Account brings in investment transactions, mixes accounts

Hi there, ericaTTPB.

The account you linked to QuickBooks may be linked to a different one. That said, the other data is pulled out of the system.

With that, I'd recommend reaching out to your financial institution and checking the setup of the account.

Once done, you're good to categorize the downloaded transactions. Here's an article as your guide:  Categorize items.

I'll be around whenever you need help with bank transactions. Keep safe!

Hello, I am a new customer and having the same issue.  The data being imported from my lone Edward Jones business checking account appears to be pulling not just the one account I requested, but all of my accounts at Edward Jones!!!  this seems like a major security issue...I am being told by the EJ rep that Edward Jones sends all accounts under the same User ID so the only way around this is to move that one EJ account to a new user id and password.  Is there a way around this as I am trying to just pull my business account and not any of my other EJ accounts?  IS EJ just antiquated and not up to date like all the other banks?

Please know this isn’t the kind of impression we want you to have, @burningskylodge. I'm here to turn the tables around and help provide information about the EJ account.

You’ll want to reach out to your bank to see if they’re performing some maintenance. One of their specialists can use their tools to pull your account from their database and investigate the issues you’ve encountered.

As for QuickBooks, you’ll need to exclude the transactions to avoid duplicates. If you’re unable to see them, go to the Categorize tab and undo those transactions so they’ll appear in the For review tab.

Here's how:

1. On the left pane, go to the Banking menu.
2. In the For review tab, tick the transactions.
3. Click the Exclude button.

You can also check this link for the complete details: Exclude a bank transaction you downloaded into QuickBooks Online.

I'd also recommend reaching out to your accountant to ensure your account is well accounted for. Once everything is settled, you might want to read these resources about matching your transactions and reconciling your accounts seamlessly:

• Categorize and match online bank transactions in QuickBooks Online
• Reconcile an account in QuickBooks Online

I want to make sure this is taken care of for you. If you have any other concerns, you can always comment below. I’m here to help you further.

Does it help to solve the issue if I let you know the bank account balance being pulled is correct but the transactions are being pulled across many (potentially all) accounts?  So the balance is the correct and updated amount, but all the ins and outs are not.  Is this an EJ thing or a QB thing? 

Im not sure your solution is a viable one.  Will I have to go and exclude things every month that don't belong?  So basically Im just manually inputting all the transactions myself?

looking at it again, it appears the transactions in my bank account, like checks I've written or direct deposits are not being brought over, so the the transactions from Edward Jones being pulled are not correct overall.

It appears there are only select transactions from all my EJ accounts being brought over.  

Is there another option, because exclusions won't work if the transactions aren't there in the first place, right?

Again, the correct balance is being brought over, just not the ins and outs.  

Thanks for joining this thread, burningskylodge.

Since your transactions are importing with invalid data, I'd recommend getting in touch with your financial institution to verify if there's any known issues on their end. If there aren't any reports yet, you can notify them of what's occurring for you. QuickBooks relies on the data provided by your bank, so it's possible they're sending transactions with invalid in and out information.

Until the problem's solved, you can use the steps from JamaicaA's post to exclude invalid transactions, such as duplicates. You also have an option to manually upload banking records into your books.

If they're unable to find any issues on their end, or open an investigation into this, I'd recommend getting back in touch with me here so Intuit can make sure you're on the right track towards a solution.

I've also included a detailed resource about working with online banking which may come in handy moving forward: What to do if you get a bank error or can't download transactions

Please feel welcome to send a reply if there's any questions. Have a lovely day!

From my financial advisor/Edward Jones.  It appears they do not integrate with Quickbooks.

-Clients can import Edward Jones information to several sites, including Quicken and Mint. We don't have a comprehensive list of all aggregation sites. Clients can try to import to other sites, but the only support we can give is to confirm that their Edward Jones login is working. Quickbooks is not compatible with Edward Jones. As with other sites, clients can try to import, but if it doesn't work, there isn't much we can do to assist. One item that comes up for clients has to do with their password. The Edward Jones site allows for up to one special character in their password, but some aggregation sites don't recognize them. If a client is unable to import, it may be helpful to change the Edward Jones password to just have letters and numbers, and no special characters. Also, it is helpful if the client logs into the Edward Jones site from the same device they use to import data on. For further assistance, clients are advised to contact the support for the import site.