Import Credit Card Transactions into QuickBooks Online

Import Credit Card Transactions into QuickBooks Online

In this, you can use a QBO file or Excel and a comma-separated values file. The below guide will help you to easily connect your credit card to QuickBooks Online and import credit card transactions into QuickBooks Online. QuickBooks accounting software is a general need of every organization. QuickBooks permits its user’s ease of import and export of invoices.

Know the Importance of Connecting your Credit Card to QuickBooks

Everyone wants to save time; fortunately, there are many time-saving options available in QuickBooks. Linking the credit card to QuickBooks saves valuable time. It will automatically download the transactions associated with the credit card. When connected they require signing into QuickBooks to categorize and transfer the daily transaction automatically. You can even import the transaction of the credit card in QuickBooks via a QBO file or a CSV file through the Excel without need for the sign-in credentials.

Tips and Tricks to Import Credit Card Transactions into QuickBooks Online

Users need to enter a username with a password to link the credit card to QuickBooks Online. Make sure you are using the same login credentials as used in creating a credit card account. You need to set up online access to your credit card account if not completed the setup process and activate the online access. Follow the below-given steps to import credit card transactions into QuickBooks Online (Automatic and Manually).

Automatically Import Credit Card Transactions into QuickBooks Online

Step 1: Detect your Credit Card Company in QuickBooks Online

  • First of all, locate the transactions
  • Discover the QuickBooks Online Company dashboard
  • Search on the left menu bar and then click on the Banking section
  • Hit on the Banking center to check if this is the first credit card account you are linking to QuickBooks online displaying on the screen
  • You have to click on the green-colored Connect Account button
  • On clicking this option you integrate the credit card account
  • In case you have an existing bank account you will be redirected to the Banking Center button
  • Now hit on the Green Add account option that appears in the upper right corner of the screen
  • Fill in the name of the credit card company to check if you are eligible to link to QuickBooks Online
  • If the name of the company is not listed in the button then you need to import the credit card transactions with an Excel or QBO file via a CSV file
  • Once you have chosen the bank then you have to hit on the green-colored Continue button
  • It will redirect you to the sign-in Windows automatically.

Step 2: Log Into the Credit Card

  • The QuickBooks will display a new browser window to complete the sign-in process to your credit card account.
  • Once signed in, then you might get a prompt from the bank side asking you the confirmation.
  • You need to share the banking details with Intuit and also display a description of the information to be shared.
  • Once you click to agree on the confirmation then you have to hit on the suitable option on the bank confirmation window. It will directly take you to QuickBooks.

Step 3: Link Credit Card Account to Chart of Accounts

  • Now you have returned to QuickBooks, there will appear the list of accounts related to bank or credit card
  • Choose the bank account or accounts that you need to connect to the Chart of Accounts
  • Now click and select all the bank accounts you want to connect to the QuickBooks online
  • If your checking account and the credit accounts belong to the same bank then you can link them both
  • Once done hit on an account
  • It will appear a drop-down button lists all the bank accounts linked with the Chart of Account
  • In case you have already included the credit card account in the Chart of Accounts, then click on it

Creating a New Credit Card Account in the Chart of Accounts

  • Locate the Add New button and click on it
  • It will display a prompt to provide the required information for adding an account to the Chart of Accounts
  • Make sure that the Detail Type and the Account Type must be credit cards.
  • It is suggested to write the credit card company name so that it is easy to identify.
  • If you have multiple credit cards with the same company file then you have to write the last four digits that appear on the credit card.
  • After you filled in all the information you have to hit on the green-colored save button and then click on the Close option
  • It will take you to the screen with the new account.

Step 4: Selecting the Right Date Range

  • Once you connect the credit card to an account with the Chart of Accounts
  • You just need to decide when the software should start importing transaction
  • Choose the beginning date to begin transferring the bank transactions
  • The default start date appears at the beginning of the year to pull the transactions
  • You can try pulling the transaction time to the date you need to begin using QuickBooks Online
  • If QuickBooks or the credit company does not let you go back then you can use a QBO or CSV file to transfer the previous transactions.

Step 5: Review Downloaded Transactions in the Banking Center

Once you connect the bank account to your QuickBooks Online. It will direct you to the Banking Center. Walk through the below information to start reviewing the transaction in the Banking Center:

  • Review Transactions: The number displayed in orange color in the company name box determines the transaction number that has been imported, but not yet categorized and reviewed.
  • Review option: The button labeled for Review contains all the transactions imported from the chosen bank or credit card that have not been reviewed yet.
  • Add Account: To link another credit card company or bank to QuickBooks online you have to hit on the green Add account option that appears on the upper right-hand side of the screen
  • Now repeat the process. You can glance at the details of managing QuickBooks Online Bank feeds for categorizing the transactions. It is an essential step to finalize the chart of Accounts before you proceed with assigning transactions.
  • Once you have connected the credit card account it will import the new transactions automatically or you can hit on Update button that appears in the upper right corner to process the importing of new transactions instantly.
  • Moreover, you can discover the Banking Center by clicking the Transactions button and then hitting on the Banking option from the left menu bar.

Manually Import Credit Card Transactions into QuickBooks Online

Step 1: Download a Transfer File from Your Credit Card Company

  • To proceed with this step let’s walk through the below-written information. Here is the list of types of file Consultants that import credit card transactions into QuickBooks Online:
    • QBO: The QBO files referred to the QuickBooks Web Connect file which is useful for exporting transactions from credit card accounts or banks to the QuickBooks online
    • CSV: CSV files are basic files used to export data for multiple objectives and can be accessed and edited through Excel
    • QFX: These are financial exchange files specially generated for exporting details to quicken; however, it is compatible with QuickBooks online
    • TXT: A TXT file refers to a text file used for the import process. However, it might need to be performed before editing. Sometimes you might need to open the TXL file via Excel and then convert it to a CSV file for a breeze transfer.
    • OFX: OFX files refer to text files used for exporting financial information
  • To get a transfer file you need to Log into the Credit card account
  • After this discover the button to download the account transactions
  • There will appear an option for downloading the transactions in different formats
  • Select the QBO or QFX format if listed there is another option available i.e. OFX file
  • In case there is no such file appears then you might need to follow some additional steps
  • Once done now save the transfer file to the desired location on your system which is easy to access and remember.

Step 2: Select the Transfer File to Upload in QuickBooks

  • Locate the Banking Center
  • Now you have to open the drop-down option that appears next to the update button in the upper right corner of the screen
  • Now choose File Upload
  • Hit on the browse option
  • Click on the transfer file you just downloaded from the credit card account
  • After this choose the transfer file to start importing data into QuickBooks Online
  • Once done now hit on the green-colored Next option.

Step 3: Select a QuickBooks Account

  • Later, you must choose an account listed in the Chart of Accounts
  • It will record the imported bank transactions
  • If required you can hit on Add new button to set up a new credit card Account
  • After this hit on the green color, the next option appears in the lower right corner of the screen
  • In case the transfer file format is QBO, OFX, or QBX file then you are done so you can skip to Step number 6.
  • However, if the transfer file is a TXT file or CSV file then you have additional steps to finish the process.

Step 4: Map Columns to QuickBooks Fields (CSV and TXT Files only)

Once you are done with the above step you should open the CSV or TXT file in Excel file to verify the exported information and its format in the bank. Once you open a CSV file with Excel then a prompt will appear on the screen notifying you to save the file as an Excel file. You are requested not to save it because that process is to preserve the feature and there is a need to keep a CSV file format to perform the import process.

  • Ensure the columns for the credit card charges because some credit card companies might contain the charges in different columns and payments in another column. You are required to explore organizing the amounts in the later step.
  • After the completion of step 3 if you begin importing a TXT or CSV file then QuickBooks needs you to name the column in the CSV file that should be imported for the below-given fields.

Start Mapping Columns from a CSV file to QuickBooks Online:

You are required to tell QuickBooks where it can discover the date, amount, and description in your transfer spreadsheet.

  • Header Row i.e. File First Row: You have to place a checkmark in the box if your first row in the transfer spreadsheet displays the title for each column.
  • Date Tab: You have to hit the drop-down arrow and then choose the column in the transfer spreadsheet with the date. Locate the next field and then choose the date format of the spreadsheet.
  • Description: Now choose the column with a transaction description. It is highly suggested to choose the column that helps you to get the information regarding classifying the transaction without the need for in-depth research.
  • Amount: First select the spreadsheets that contain all accounts in a single column or the payments and charges that appear in different columns.

Once you have done the mapping process then hit on the green color Next option appears in the bottom right corner of the active window.

Step 5: Select Transactions for Import (CSV and TXT files only)

  • Now you can choose the transactions from the file to start the import process.
  • It is more beneficial to import all the transactions into a single file.
  • Also, the personal transactions associated with the business credit card require being imported.
  • Make sure you have done accurately the reconciling of the credit card account from the QuickBooks online to the credit card statement; it is an essential step. However, the importing of the transaction is necessary for the reconciliation process. Ensure that you have chosen all the transactions
  • After this hit on the green Next option appears in the bottom right corner to finish the import process
  • After making the required modification to the spreadsheet you need to save it and then follow step 2
  • Again choose the file to import.

Step 6: Return to the Banking Center:

Here are the steps:

  • First of all, hit on the Transactions button.
  • Now click on the Banking option from the left menu bar.
  • It will redirect you to the Banking Center.
  • It will display the bank accounts with the number of transactions that are in queue to review in the upper left corner of the screen.
  • You might need to refresh the Browser for the banking center to display the newly updated imported transactions.

When do you need to Import Credit Card Transactions Manually in QuickBooks Online?

Many scenarios take place when you decide to import credit card transactions manually in QuickBooks Online. There are two major causes to import transactions from a QBO, CSV, or identical file. Several credit card organizations will not link with QuickBooks Online to permit an automatic import. Moreover, there is no requirement to import older transactions automatically without the need to connect credit cards to QuickBooks Online.

To import the already entered credit card transactions manually like paying the vendor bill through a credit card. It will not generate duplicate transactions because it provides the ability to match the transactions with the previous transactions when checking the imported transactions.

Here is the guide about How to import Credit Card Transactions in QuickBooks Online completes. In case of any doubts feel free to get in touch with QuickBooks Online support via live chat, call, or through email.

Frequently Asked Questions

  • What are the QuickBooks-supported files to import credit card transactions?

    ● CSV
    ● OFX
    ● TXT
    ● QFX
    ● QBO

  • What should I have done if the transaction does not appear on the screen while selecting transactions to import?

    If the transactions do not display on the screen then make sure you have done the below modification to the file:

    ● Locate the amount column to delete the formatting like dollar signs
    ● Check the blank rows and then delete them so that everything starts at column 1 and row 1 of the spreadsheet

  • How can I review the imported transactions in QuickBooks?

    ● Locate the Banking Center option
    ● Search for the review option and click on it
    ● It will display the list of the transactions imported into the chosen bank or credit card that are in a queue for the review process.

  • How can I upload the transfer file in QuickBooks while importing transactions?

    ● For this, you need to click on the Banking Center
    ● Open the drop-down button that appears near the Update option
    ● Now Hit on the Select File Upload
    ● Click on the Browse option and then choose the downloaded transfer file from the credit card account
    ● Once you have chosen the transfer file then hit on the next option.