Skip to main content
A
Anonymous
February 18, 2019
Solved

Importing Credit Card Transactions

  • February 18, 2019
  • 8 replies
  • 0 views

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.

Best answer by HoneyLynn_G

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

 

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.

8 replies

HoneyLynn_G
HoneyLynn_GAnswer
February 18, 2019

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

 

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.

A
Anonymous
February 18, 2019

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.

A
Anonymous
February 19, 2019

@482881

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.

    C
    CaseyHart
    April 17, 2020

    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.

    R
    ReyJohn_D
    April 17, 2020

    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.

    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!

    J
    JVizza
    December 29, 2020

    I am trying to import credit card transactions into Quickbooks 2019 for Mac DESKTOP. In my one account it won't recognize the account as a credit card. In my other account it won't allow it to import at all. It doesn't see it as a new account so I can't even select Credit Card. What's the fix please? Thanks

    Adrian_A
    Adrian_A
    December 29, 2020

    Let's run the verify and rebuild steps, JVizza.

     

    It is to isolate if your company file has data issues. 

     

    You can do that by going to the File menu. Under Utilities, select Verify Data. Then, OK. If you see an error message, you can try searching for it on our QuickBooks Desktop Help page. If you are prompt with Your data has failed the integrity check, you'll have to rebuild the file. 

     

    Here's how:

     

    1. Click the File menu.
    2. Under Utilities, select Verify Data.
    3. Once the rebuild's complete, click OK.

     

    Afterward, let's categorize the transactions again. I've added this reference for more information: Add and match Bank Feed transactions in QuickBooks Desktop.

     

    I'm just a post-away if you need help. Keep safe!

    J
    JVizza
    December 29, 2020

    Thanks. So I ran the Verify Data and it was all ok. I tried to import that file and here is the message I get 

    N
    NadineG730
    February 1, 2021

    I am trying to view all the previous credit card transactions from 2020 when I linked the account I put a date of 1/1/2020 but the only transactions I can see are from 11/2020 forward. Is there a way to change the date or add other statements that are missing there??

      Rubielyn_J
      Rubielyn_J
      February 1, 2021

      Hi there, @NadineG730. I can provide some insights about transactions imported inside QuickBooks Online.

       

      The first time you connect, QuickBooks automatically downloads the maximum number of transactions available from your bank. Depending on the bank, this can give you up to a year of historical transactions and the default period when it will be sync. Most banks may only download the previous 90 days.

       

      In this case, I suggest reaching out to your bank to download the missing transactions using Web Connect.

       

      For more information, you may consider checking out this article: Download Bank Feed transactions in QuickBooks Desktop. This includes a detailed process on how to download transactions inside QuickBooks. 

       

      Additionally, I'll be adding these reference you can use in the future: 

       

      Feel free to let me know if you have other concerns. I'll make sure to get back to you right away. Wishing you all the best. 

      Fiat Lux - ASIA
      Fiat Lux - ASIA
      June 2, 2021
      This post has been deleted.

      @Mason_olly 

      Afaik, the product you mentioned only works with QBD. It is similar to this app

      https://transactionpro.grsm.io/qbo

       

      If you are using QB Online, explore the trial version of SlickConnect or another converter app as I mentioned in the earlier post.

      https://www.moneythumb.com/?ref=110

       

      R
      RCV
      June 2, 2021
      This post has been deleted.

      Thanks for checking in with us, Mason_olly. 

       

      If you are using QuickBooks Desktop, we can use the Web connect (.QBO) files feature to download bulk credit card transactions from your bank’s website into QuickBooks. The (.QBO) files can be downloaded and saved on your computer. Then, you can import the transactions so they become available in your Bank Feeds. If your bank offers Web Connect, juts follow the steps below: 

      1. Go to the Banking menu.
      2. Select Bank Feeds, then Import Web Connect Files.
      3. Choose the QBO file you saved, then tap Open.
      4. When prompted to Select Bank Account, select:
        • Use an existing QuickBooks account if the account you're importing transactions into is already set up in QuickBooks.
        • Create a new QuickBooks account if the account you're importing transactions into isn't in QuickBooks yet. Learn how to create an account.
      5. Hit Continue. You'll see a dialogue box telling you that the data has been successfully read into QuickBooks. Select OK.
      6. Go to the Bank Feeds Center to review your transactions.

       

      You an also download your credit card transactions using the Direct Connect feature. The first time you connect, QuickBooks automatically downloads the maximum number of transactions available from your bank. This is as much as QuickBooks can download depending on the bank, this can give you up to a year of historical transactions.  Most banks may only download the previous 90 days. See the Download Bank Feed transactions in QuickBooks Desktop article for the steps and details.

       

      Feel free to visit our Banking page for more insights about managing your bank feeds in QuickBooks Desktop. 

       

      I'm just one post away if you need a hand with reconciling your accounts or any QuickBooks related. I'll be here to ensure your success. You have a good one.

      N
      NorthCarolina22
      March 15, 2022

      Hello,

      I am relatively new to Quickbooks Online.  Could someone please let me know if my receipts from American Express app will download into Quickbooks online?

      J
      JamaicaA
      March 15, 2022

      Congratulations on making your first post here, @NorthCarolina22. I'd be glad to clarify your sales receipt concern from American Express App.


      Once you connect your American Express account to online banking, QuickBooks Online will automatically download your transactions.


      Additionally, any receipts you take with the American Express Business App are synced with QuickBooks seamlessly. These receipts appear among your other downloaded transactions on the Banking menu.


      Feel free to read this handy article to know more about American Express connections. You can proceed to the last part to learn what you need to do to keep getting transactions from American Express.


      You’ll want to open this links to categorize and match transactions including reconciling them to keep your business up and running well:

       

       

      You can comment here if you have follow up question with managing your American Express Bank or any other banking-related concerns. I'm always around to help.

      M
      mv808
      January 28, 2025

      I downloaded the bank and credit card transactions on excel and they have all the transactions from the time I started my business, I've already reconciled everything, will all the transactions be uploaded and will it mess up my accounting? 

      Terms & ConditionsAccessibility statement