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

Importing Credit Card Transactions

I would like to connect to my credit card provider to download my transactions into my checking account register. I know how to add a banking account but I want to know how I can download the credit card transactions into the same register as my checking account register.

Solved
Best answer February 18, 2019

Best Answers
Highlighted
QuickBooks Team

Importing Credit Card Transactions

Thank you for posting here in the Community, @jbnewengland.

 

I can help you download the credit card transaction into QuickBooks Desktop,

  1. Click Banking.
  2. Choose Bank Feeds
  3. Select Banking Center.
  4. From the Bank Accounts list, choose the account you need to connect.
  5. Click Download Transactions to receive transactions.
  6. Select Synchronize.
  7. Choose Sync all for this Bank to connect all accounts for the same bank.
  8. Type your PIN or password.
  9. Select OK.

 

You can also manually import your transaction using the Web Connect feature. For detailed instruction, please check this article: Download Bank Feed transactions.

 

Let me know if you're able to successfully connect your credit card. I'm still here to help you more if you have follow-up questions.

View solution in original post

Highlighted
Anonymous
Not applicable

Importing Credit Card Transactions

@jbnewengland

RE: I want to know how I can download the credit card transactions into the same register as my checking account register.

RE: I'm assuming all of my credit card charges will now be imported into the register just like my banking transactions when I sync to the bank. 

 

No, they will be imported into your Credit Card account register.  Credit card transactions don't have anything to do with your bank account.

 

RE: How does Quickbooks handle to payment made out of my bank account to the credit card company?

 

The payment will come down as any other transaction.  Generally they're not handled well automatically.  Instead, record the payment as a Check in your bank account, using your CC account, before downloading that detail for the credit card.  Then you can match the payment to the downloaded transaction.

View solution in original post

15 Comments 15
Highlighted
QuickBooks Team

Importing Credit Card Transactions

Thank you for posting here in the Community, @jbnewengland.

 

I can help you download the credit card transaction into QuickBooks Desktop,

  1. Click Banking.
  2. Choose Bank Feeds
  3. Select Banking Center.
  4. From the Bank Accounts list, choose the account you need to connect.
  5. Click Download Transactions to receive transactions.
  6. Select Synchronize.
  7. Choose Sync all for this Bank to connect all accounts for the same bank.
  8. Type your PIN or password.
  9. Select OK.

 

You can also manually import your transaction using the Web Connect feature. For detailed instruction, please check this article: Download Bank Feed transactions.

 

Let me know if you're able to successfully connect your credit card. I'm still here to help you more if you have follow-up questions.

View solution in original post

Highlighted
Level 1

Importing Credit Card Transactions

Got it! All set up now. One question... I'm assuming all of my credit card charges will now be imported into the register just like my banking transactions when I sync to the bank. How does Quickbooks handle to payment made out of my bank account to the credit card company? I'm assuming all of the individual charges will get added to the register and then there will be the actual payment from my checking account. Just need to understand how all of this reconciles.

Highlighted
Anonymous
Not applicable

Importing Credit Card Transactions

@jbnewengland

RE: I want to know how I can download the credit card transactions into the same register as my checking account register.

RE: I'm assuming all of my credit card charges will now be imported into the register just like my banking transactions when I sync to the bank. 

 

No, they will be imported into your Credit Card account register.  Credit card transactions don't have anything to do with your bank account.

 

RE: How does Quickbooks handle to payment made out of my bank account to the credit card company?

 

The payment will come down as any other transaction.  Generally they're not handled well automatically.  Instead, record the payment as a Check in your bank account, using your CC account, before downloading that detail for the credit card.  Then you can match the payment to the downloaded transaction.

View solution in original post

Highlighted
Level 1

Importing Credit Card Transactions

I already have QB connected to my bank and credit card accounts to automatically import, but I just found a whole month missing on one of the CC accounts and a few weeks here and there missing from the bank account. If I manually import transactions, will QB catch any duplicates for me or do I have to check these myself?

Highlighted
QuickBooks Team

Importing Credit Card Transactions

Hello there, @Pablogm13.

 

Thanks for joining this thread about importing transactions in QuickBooks Desktop. I'm here share some more insights.

 

When uploading your transactions, you still have the option to review all the transactions. You'll have to check it by yourself and remove the duplicates if necessary.

 

Depending on the mode you're using, please refer to this article for the steps in removing duplicate transaction.

 

That should keep you going today, Pablogm13. Let me know if there's anything else you need. I'll be around for you. Wishing you all the best!

 

Highlighted
Level 1

Importing Credit Card Transactions

I use QB 2015, which no longer supports online banking; however my credit card company has never been associates with QB so I have had to download .pdf statements and use a third party converter to make qbo’ or IIF’s which I then import.  Now that my version of QB no longer supports online banking, it will not allow me to manually Import such files.  This is disconcerting to say the least.  I would like to avoid having to upgrade QuickBooks.  Is there any way I can accomplish what I need?

Highlighted
Level 1

Importing Credit Card Transactions

I am using QB 2015, which no longer supports online banking.  However,  neither my bank nor my credit card provider has ever been associated with QB (they therefore have no FID). Therefore, I have always downloaded .pdf statements and then used a third party software to convert them into QBO’s or IIF’s which I then imported manually.  Now that the online banking has expired for my version of QB, it will no longer allow me to do this.  This is disconcerting.  I really do not want to upgrade to a subscription based version, which I otherwise do not need, just to be able to do this....especially when I have to have third party software to even attempt it.  Is there anyway I can accomplish what I need without upgrading?

Highlighted
Moderator

Importing Credit Card Transactions

Hello @TMGgmt,

 

Manually uploading your transactions with the unsupported versions of QuickBooks is unavailable. You'll want to update your software to the supported versions at least.

 

Here's an article you can read to learn more about unsupported versions and service discontinuation: QuickBooks Desktop service discontinuation policy and upgrade information.

 

You can always visit our Help Articles page in case you need some ideas and references in managing your account and transactions.

 

If there's anything else that I can help you with, please let me know in the comments. Always around ready to help.

Highlighted
Level 12

Importing Credit Card Transactions

@TMGgmt 

Utilize the importer tool to import your bank activity into QBD.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

 

Highlighted
Level 1

Importing Credit Card Transactions

I don't have a "bank feeds" option in the 2019 Desktop Version I'm using. I'd like to directly connect so transactions automatically post to the desktop version. I tried manually downloading the statement, and it's greyed out, won't let me select it to upload manually either? I do have this account connected to mobile app for mint - and works fine there. But need the info in my QB desktop to manage the business.

Highlighted
QuickBooks Team

Importing Credit Card Transactions

Hello there, @kimniemi.

 

You'll want to set up your account for online banking or Bank Feeds in single-user or multi-user mode to manage your bills and bank transactions in QuickBooks.

 

Here's how: 

 

  1. From the Banking menu, go to Banking, then Set up Bank Feeds.
  2. Enter, your Bank’s name field, and select the name of your bank.
  3. Connect your bank.
  4. Select existing or Create new ▼ drop-down and find the QuickBooks account you want to link to your bank account.
  5. If you haven't set up your bank account, select Create New Account.
  6. Select Connect, then Close.

Then, we can use Web connect(.QBO) to download the transactions so they become available in your Bank Feeds. For more information, kindly click this article: Import web connect (.qbo) files.

 

You can read out this article that covers basic information about Bank Feeds: Get started with Bank Feeds for QuickBooks Desktop.

 

Also, I'm adding our Help Articles it provides tips on how to manage your account in QuickBooks.

 

Please let me know if you have any other concerns. I'll be right back to you. Take good care.

Highlighted
Level 1

Importing Credit Card Transactions

I downloaded my credit card transactions, and they show in the credit card register.  I'm going to pay online from my bank, but how does the downloaded info get onto the check stub?

Thanks.

Highlighted
QuickBooks Team

Importing Credit Card Transactions

Hi there, @CaseyHart.

 

You'll have to manually match the transactions you downloaded with the ones in the check register. I'll guide you how:

 

  1. Go to the Banking menu then  Bank Feeds and then choose Bank Feeds Center.
  2. Open the Match Transactions window then make sure the correct bank account is showing from the Financial Institution dropdown.
  3. Click View then download and check the electronic statement.
  4. Make sure the Show Register checkbox is selected in the Match Transactions window.
  5. Choose the transaction in the statement that you need to match to a transaction in the register.
  6.  Find the transaction in the register to match to. Make sure the amounts match.
  7. Hit Match once confirmed.

B42.PNG

Furthermore, here is an article about bank feeds in QuickBooks Desktop. This way, you'll have better options on how to manage your bank feeds.

 

Please feel free to read this handy help article if you've got other QuickBooks concerns, such as setting up payments and inventories, running reports, reconciliation, etc. to keep your business up and running well.

 

Please let me know if you have other concerns. Have a nice day!

Highlighted
Level 1

Importing Credit Card Transactions

How do I set up the credit card account?  I get no response when I select Credit Card

Highlighted
QuickBooks Team

Importing Credit Card Transactions

Hello there, @ sscarp1.

 

Let's make sure the steps are correct in setting up credit card accounts. Let me show you the steps on how to do it.

 

 Here’s how:

 

  1. Go to Lists at the top menu bar, then select Chart of Accounts.
  2. Select Credit Card, then select Continue.
  3. On the Add New Account window, enter the credit card name.
  4. Type the Credit Card Name. Note: If you are setting up a sub-account, you need to check the Sub account of. From the drop-down, choose the parent credit card account. 
  5. Select an option under When do you want to start tracking your finances from this account in QuickBooks?Enter your account's balance and choose Save Close.

 

 I'm adding this article on how to set up your credit card in QuickBooks Desktop: Set up, use, and pay credit card accounts.

 

If you still can’t select the credit card option, then let’s perform some steps to fix this error. You can start downloading the QuickBooks Tool Hub, this contains the different tools used to fix common issues within the software. Let me show you how.

 

 Download and install the QuickBooks Tools Hub:

  1. Close your QuickBooks.
  2. Download the most recent version (1.4.0.0) of the QuickBooks Tool Hub. Save the file somewhere you can easily find it.
  3. Open the file you downloaded (QuickBooksToolHub.exe).
  4. Follow the on-screen steps to install and agree to the terms and conditions.
  5. When the install is done, double-click the icon on your Windows desktop to open the tool hub.
  6. If you can't find the icon, search in Windows for QuickBooks Tool Hub and choose the program. Then, use the QuickBooks Install Diagnostic Tool:
  7. Open the QuickBooks Tool Hub. In the tool hub, select Installation Issues.
  8. Choose QuickBooks Install Diagnostic Tool. Let the tool run.
  9. When the tool finishes, restart your computer.

 

If the solutions in the article above won't work, you can update the window and follow step 3, to solution 5 in this article: Fix QuickBooks Desktop install errors.

 

If there’s anything else you need, I’ll be here to help you out. Take good care.

Need to get in touch?

Contact us