cancel
Showing results for 
Search instead for 
Did you mean: 
bdeshazer
Level 2

How can I sync my credit card account so that I can see charges separated out by cardholder or card number?

 
3 Comments 3
GebelAlainaM
QuickBooks Team

How can I sync my credit card account so that I can see charges separated out by cardholder or card number?

Sending good vibes to you, @bdeshazer. I can be able to help you sync your credit card account.

QuickBooks Online allows you to add your bank and credit card account and it will automatically download transaction.

Here's how:
 

  1. Go to Banking menu.
  2. For first time user select Connect account. If you’ve already set up an account, select Add account or Link account if you've already created one.
  3. Search for your bank, credit card, or credit union on the search bar.
  4. Select Continue. Then sign into your bank using your username and password. 
  5. Follow the onscreen steps, including any additional security checks your bank might require.
  6. Choose any accounts you want to connect like your savings, checking, or credit card. Then select the account type dropdown and choose the matching account type from your chart of accounts in QuickBooks.
     

For more details, you can check out this article: Connect bank and credit card accounts to QuickBooks Online.

You may check out this article to learn more about bank or credit card subaccount setup.

I've also added this following articles for your future help:
 

Post a reply if you need any further assistance on how to pull up reports in QuickBooks Online. I'll get back to you as soon as possible. Enjoy the rest of the day!

bdeshazer
Level 2

How can I sync my credit card account so that I can see charges separated out by cardholder or card number?

Thank you @GA for your relpy!

 

I already set up my credit card account so I'm good there. So I reviewed the Connect bank and credit card accounts to QuickBooks Online article you sent and it recommended that I create sub-accounts on my chart of accounts for each credit card we have.

 

However, if I do that, all the charges will still sync with my parent account and I don't know how to assign each transaction, as it comes in, to the appropriate card numbered sub-account. Further, even if I'm able to do so, it would be a time-consuming process to lookup a charge, match it with a person/card# on my bank account, go back to Quickbooks and use whatever means I need to to reassign the charge to that subaccount and then categorize the expense now that we know where comes from. Is there a way to make charges automatically go to a subaccount to make that process faster?

Rea_M
Moderator

How can I sync my credit card account so that I can see charges separated out by cardholder or card number?

You're already on the right track in setting up your credit card account and managing transactions in QuickBooks Online (QBO), @bdeshazer. I'm here to share further insights about this.

 

When you connect to online banking, you'll first need to know how your bank sends the downloaded transactions. If the transactions download to one account, connect only the parent account. If the transactions download to the individual accounts, connect the subaccounts and not the parent account.

 

You can’t connect both a parent account and its subaccounts. Since all the charges will sync with your parent account, you're unable to make them automatically go to a subaccount. You may exclude those transactions and manually add or assign each of them to the appropriate card numbered subaccount. This way, you can avoid duplicates and keep your data updated and accurate.

 

To exclude, here's how:

 

  1. Go to the Banking menu .
  2. Select the Banking tab.
  3. Choose  the tile for the account you want to review.
  4. Go to the For Review tab.
  5. Select the checkbox of the transactions to exclude.
  6. Click Exclude82.jpg

 

Also, when it’s time to reconcile (every month), you only need to reconcile the parent account. This is because all transactions in the subaccounts roll up into it. For the step-by-step guide, I'd recommend checking out this article: Reconcile an account in QuickBooks Online.

 

Keep me posted in the comments if you have other banking concerns and questions about managing credit card transactions in QBO. I'm always around to help. Take care, and I wish you continued success, @bdeshazer

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us