cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Best way to import only some Capital One Credit Cards into Quickbooks Pro

We have a few cards at Captial One that all have different credit card numbers with them.  We have 3 locations all in quickbooks desktop pro where we are trying to link just some of the cards to each.  Outside of exporting all transactions, sorting then importing just those needed, does anyone know of a quick way to link to just those cards that are needed?  When we connect via quickbooks, only the main (MASTER) account is listed.

1 Comment
Highlighted
QuickBooks Team

Best way to import only some Capital One Credit Cards into Quickbooks Pro

Hello there, CoastalVentures.


I’m here to help fix your credit card transactions and ensure you’re able to bring in and post them to the correct accounts.


You need to create sub-accounts for the different card numbers you can link to the Capital One Credit Card (Master account). This way, you’ll be able to select the appropriate sub-cards upon importing the transactions.


If you only want to use the Webconnect functionality, you can create the sub-accounts right-away, then import the transactions to each card numbers. However, if this is through the Direct connect process; you need to first identify how your bank sends the downloaded transactions.


If the transactions download to one account, connect only the parent account. Otherwise, connect the sub-accounts and not the parent account. Either way, their total will show in the Master/Parent account.

 

To add a subaccounts :

  1. Go to Lists at the top menu bar, then select Chart of Accounts.
  2. Choose New from the Account drop-down at the bottom of the screen.
  3. Enter necessary information, then put a check mark in the Subaccount of box.
  4. Click Save and Close.

To continue the process of importing via a Webconnect file, click the Set up your account WebConnect section of this article:


Set up account for Bank Feeds


If this is through a Direct connect process, here's what you'll want to do:

  1. From the QuickBooks Banking menu, select Bank Feeds, then Set Up Bank Feeds for an Account.
  2. In the Enter your Bank’s name field, enter the name of your bank.
  3. Select the Continue button.
  4. Enter your Online Banking ID and Password.
    Choose Connect. QuickBooks will then connect to the bank’s server.
  5. Pick the credit card sub account you want to connect.
  6. Then, click Finish after the process completes.

That’s it! You can now accept all of your bank transactions and arrange them per credit card number.


Don’t hesitate to let me know if you have questions. I’ll be here anytime.

Need to get in touch?

Contact us