Detailed Procedure To Import Credit Card Transactions Into QuickBooks

oval Image
Import Credit Card Transactions Accounting
Mar 30, 2023

Are you unable to import credit card transactions into QuickBooks Online? If yes, then you have arrived to the appropriate place. In this comprehensive guide, we have covered everything essential to import bank transactions. Moreover, the users can also import the transactions into QBO using the QBO file or a CSV file. To learn more details about importing credit card transactions in QuickBooks, we suggest you to read the post thoroughly.

What Should Be Done to Import Credit Card Transactions Into QuickBooks?

Below are some simple steps to import credit card transactions into QuickBooks; check them out.

Stage 1: Locate Your Credit Card Company In QuickBooks Online

  1. Initially, tap on the Banking drop-down menu beneath the left menu bar of the QuickBooks online dashboard.
  2. If you are linking your credit card account to QuickBooks for the first time, you must tap on the Connect Account button. This will add your credit card account to QuickBooks successfully.
  3. On the other hand, if your credit card account is already linked, it will redirect you to the Banking Center. Herein, hit the Link Account button from the upper right corner of the screen.
  4. Insert your credit card company’s name to verify whether it can link with QBO.
  5. After choosing your bank name, select the Continue button to redirect you to the bank sign-in page.

Stage 2: Sign-In To Your Credit Card Account

  1. QuickBooks will present you with a new window to wind up the login process of your credit card account.
  2. After successfully logging in, you will receive a mail from your financial institution for your confirmation.
  3. Now, you must share your bank details with Intuit along with the description of the information that needs to be shared.
  4. Once you hit the Agree button to give your consent. Then, tap on the Suitable option from the Bank Confirmation window. Doing so, will directly move you to the QuickBooks application.

Recent Post – Export Chart of Accounts QuickBooks

Stage 3: Connect Your Credit Card Account To Charts of Accounts

  1. While returning to QuickBooks, you will get the lists of accounts associated with bank or credit card accounts.
  2. After this, pick the bank account or account that you wish to link with the Charts of Accounts.
  3. You must choose all the bank accounts you want to link with QuickBooks Online.
  4. If you find that you have a checking account and credit card from the same financial institution, you can link both.
  5. Next, hit on the An Account option and move ahead.
  6. Consequently, it will redirect you to the new window with a drop-down button listed with all bank accounts connected with the Charts of Accounts.
  7. If your credit card account is previously added in Charts of Accounts, choose them.

Generate a New Credit Card Account in Charts of Accounts

  1. In the initial stage, tap on the Add New button.
  2. As a result, it will launch a prompt in which you must include the relevant information for adding an account in Charts of Accounts.
  3. You must verify that the Detail Type and the Account Type must be set as Credit Card.
  4. It is mandatory to note down the credit card company name, which will help them to recognize it easily.
  5. For instance, if you have various credit cards with the same company file, you must include the last four digits visible on the credit card.
  6. After adding all the required information accurately, hit the green-colored Save button. Later on, tap on the Close option and move further to the next step.
  7. As a result, it will redirect you to the screen with the new account.

Stage 4: Choosing the Appropriate Date Range

  1. Once you have successfully linked your credit card account to Charts of Accounts, you must decide when QuickBooks must initiate importing transactions.
  2. After this, you must pick the beginning date to transfer the bank transactions.
  3. The default start date will be shown at the beginning of the year to pull the transactions.
  4. For instance, if your QuickBooks or the credit card company won’t allow you to return, you can utilize the QBO or CSV file to shift the previous transaction.
Stage 5: Examine Downloaded Transactions In the Banking Center

Once you have successfully connected your bank account, QuickBooks will redirect you to the Banking Center. Look at the steps below to initiate reviewing the transaction in Banking Center.

1. Review Transactions:- 

The Orange number represented within the Capital One box reflects the number of transactions that have been imported. But these are the transactions that still need to be examined and categorized.

2. Review Tab:-

The Tab entitled For Review consists of all the transactions imported from your chosen bank or credit card account that is in waiting.

3. Add Account:-

You must tap the green Add account button located at the top-right corner to link another bank or credit card company with QuickBooks Online.

Instructions to Import Credit Card Transactions Manually in QBO Via CSV or Similar File

Process 1: Get the Transfer File Downloaded From Your Credit Card Company

  1. Users can utilize CSV, QBO, QFX, OFX, and TXT to import credit card transactions in QuickBooks Online.
  2. After this, you must sign in to your credit card account and look for the option to download your account transactions.
  3. You will get different options to download the transactions. Herein, you must pick either the QBO or QFX format.
  4. You must walk through some additional steps if you don’t see any of these file types.
  5. At last, save the transfer file to a location where it is easy to find so you can import it without any inconvenience.

Process 2: Pick the Transfer File to Upload in QuickBooks

  1. From the Banking Center, tap the dropdown menu beside the Update option. Then, hit the Upload from file option.
  2. Afterwards, hit Select Files to search your file on your device. Later on, select the Continue button to go ahead.

Process 3: Pick the QuickBooks Account

  1. You are supposed to pick an account associated with Charts of Accounts.
  2. Click on Add New button to set up a new credit card account.
  3. Proceed to the next step if your file format is QBO, OFX, or QBX.

Process 4: Map Columns to QuickBooks Fields

  1. You must verify the columns of credit card charges because some credit card companies might get the charges in different columns.
  2. After accomplishing process 3, if you start importing a TXT or CSV file, QuickBooks have to name this column in CSV format to import.
Process 5: Choose Transactions for Import (CSV and TXT files)
  1. You can now easily pick the transactions from the field to begin the import process.
  2. Verify that you have selected all the transactions and click the Next button to wind up the import of transactions.
Process 6: Go Back To the Banking Center
  1. Tap the Transactions button and click the Banking option from the left menu.
  2. You will obtain the bank accounts with the number of pending transactions for Review.
  3. At last, refresh your browser so that your Banking center can present you with the newly updated import transactions.
Ending Words!!

With the help of this article’s help, the users can now easily import credit card transactions into QuickBooks. If you still have any queries, you can contact our professionals anytime through live chat for instant help.

For Immediate Help +1-844-266-9345