FitSmallBusiness
  • HR
  • Retail
  • Sales
  • Marketing
  • Accounting
  • Real Estate
  • More Categories
    • Starting a Business
    • Banking
    • Credit Cards
    • Financing
    • Insurance
    • Office Technology
    • Online Business
    • Taxes
  • BE A PARTNER
  • WORK AT FSB
  • About
  • HR
  • Retail
  • Sales
  • Marketing
  • Accounting
  • Real Estate
  • More Categories
    • Starting a Business
    • Banking
    • Credit Cards
    • Financing
    • Insurance
    • Office Technology
    • Online Business
    • Taxes

Accounting | How To

How To Import Credit Card Transactions Into QuickBooks Online

Tim Yoder, Ph.D., CPA

REVIEWED BY: Tim Yoder, Ph.D., CPA

Tim is a Certified QuickBooks Time (formerly TSheets) Pro, QuickBooks ProAdvisor, and CPA with 25 years of experience. He brings his expertise to Fit Small Business’s accounting content.

 

WRITTEN BY: Mark Calatrava

Published May 16, 2022

Mark has researched and reviewed accounting software at Fit Small Business since 2019 and has developed an extensive knowledge of accounting software features and how unique business needs determine the best accounting software.

Published May 16, 2022

This article is part of a larger series on Accounting Software.

Learn More With Our QuickBooks Online Course
Explore the chapters in the guide.
  1. How to Set Up QuickBooks Online
  2. Part 1: Setting Up QuickBooks
    1. How to Set Up Company Information
    2. How to Customize Invoices, Sales Receipts & Estimates
    3. How to Set Up Invoices, Sales Receipts & Estimates
    4. How to Set Up Products and Services
    5. How to Set Up Messages
    6. How to Set Up Statements
    7. How to Set Up Expenses
    8. How to Set Up Advanced Settings
  3. Part 1: Setting Up QuickBooks (Cont.)
    1. How to Import Bank Transactions
    2. How to Import Credit Card Transactions
    3. How to Set Up Multiple Users
    4. How to Set Up the Chart of Accounts
    5. How to Set Up the Products and Services List
    6. How to Set Up Customers
    7. How to Set Up Vendors
  4. Part 2: Managing Sales and Income
    1. How to Create Estimates (Quotes or Bids)
    2. How to Create and Send Invoices
    3. How to Receive Payments
    4. How to Create & Send Sales Receipts
  5. Part 3: Managing Bills and Expenses
    1. How to Write & Print Checks
    2. How to Enter Bills
    3. How to Pay Bills
  6. Part 4: Managing Banking Transactions
    1. How to Enter Banking Transactions Manually
    2. How to Manage Downloaded Banking Transactions
    3. How to Record Bank Deposits
    4. How to Transfer Funds Between Bank Accounts
    5. How to Handle Bounced Checks From Customers
    6. How to Process Bank Reconciliation
  7. Part 5: Managing Business Credit Card Transactions
    1. How to Enter Business Credit Card Transactions Manually
    2. How to Manage Downloaded Business Credit Card Transactions
    3. How to Enter a Credit Card Refund
    4. How to Reconcile Business Credit Card Accounts
  8. Part 6: Managing Credit Card Sales
    1. How to Manage Credit Card Sales With QuickBooks Payments
    2. How to Manage Credit Card Sales With a Third-party Credit Card Processor
  9. Part 7: Set Up and Manage Payroll
    1. How Set Up and Run Payroll
    2. How to Manage Payroll Tax
    3. How to Add Historical Payroll Data
    4. How to Set Up Automatic Deposits
    5. How to Print Payroll Checks
    6. How to Run Payroll Reports
    7. How to Reconcile Payroll Liabilities
  10. Part 8: Reporting in QuickBooks Online
    1. How to Run a Profit and Loss Statement
    2. How to Run a Balance Sheet Report
    3. How to Run a Statement of Cash Flows
    4. How to Run an A/R Aging Report
    5. How to Run an A/P Aging Report

In this tutorial, you’ll learn to connect your credit card to QuickBooks Online and import credit card transactions. We’ll also explain when and how to import credit card transactions into QuickBooks Online using a QuickBooks Online file or Excel and a comma-separated values (CSV) file. If you’ve completed the prior tutorial, How to Import Bank Transactions, then this tutorial will be a breeze as the process is very similar.

This tutorial is designed for those who are using or want to use QuickBooks Online, which we ranked as the best small business accounting software. You’ll get the most benefit from the tutorial by following along in your own QuickBooks account. If you don’t already subscribe to QuickBooks, you have the choice of a 30-day free trial or 50% off for three months.

Visit QuickBooks Online

This tutorial is one in our series of Free QuickBooks Tutorials. You can watch the video below or follow the step-by-step instructions that include illustrations.

Step 1: Prepare Your Credit Card Log-in Credentials

To connect your credit card to QuickBooks, you need the username and password that’s used to sign in to your online credit card account. If you haven’t set up online access to your credit card account, you must do so before continuing with these steps. Visit your credit card company’s website for information on how to activate your online access.


Step 2: Locate Your Credit Card Company in QuickBooks Online

Select the Banking dropdown under Banking from the left menu bar of your QuickBooks Online company dashboard, as shown below.

Navigating to Banking Center in QuickBooks Online.

Go to the Banking Center in QuickBooks Online

If this is the first bank or credit card account you’re connecting to QuickBooks, you’ll see the following screen and you should click the green Connect account button to add your credit card account.

Connecting your first bank account in QuickBooks Online.

Connect your first bank account in QuickBooks Online

If you’ve already connected another bank or credit card account, you’ll be taken to the Banking Center. Click the Link account button in the upper right corner of the screen to continue.

Connecting a bank account to QuickBooks Online.

Link a credit card account to QuickBooks Online

Enter your credit card company’s name to determine if it’s available to connect to QuickBooks Online. Our fictitious sample company, Paul’s Plumbing, has a business credit card with Capital One.

Searching for your credit card company in QuickBooks Online.

Search for your credit card company in QuickBooks Online

If your company isn’t listed, you’ll have to import your credit card transactions with a QBO file or through Excel using a CSV file, which we’ll explain later.

After selecting your bank, click the green Continue button to be taken to your bank’s sign-in page automatically.

Click Continue to Sign in to your Account.

Continue to your credit card sign-in page


Step 3: Log Into Your Credit Card Account

QuickBooks will open a new browser window for you to sign in to your credit card account.

Signing in to your credit card account in a new window.

Sign in to your credit card account in a new window

After signing in, your bank might ask you to confirm that you want to share your banking information with Intuit and provide a summary of the information to be shared. If you agree, click the appropriate button on your bank’s confirmation page, and you’ll be taken back to QuickBooks.


Step 4: Link Credit Card Account to Chart of Accounts

Upon returning to QuickBooks, you’re provided a list of accounts you have with that credit card company or bank:

Select the bank account or accounts that you want and link to the Chart of Accounts.

Select the bank account or accounts that you want and link to the Chart of Accounts

Select all of the bank accounts you would like to link to QuickBooks Online. If you have a checking and credit card account at the same bank, you connect them both during this step. After you click on an account, a drop-down box will list the bank accounts included in your Chart of Accounts. If your credit card account is already included in your Chart of Accounts, select it.

Paul’s Plumbing needs to create a new account for their Bank of America credit card, so we’ll click Add new (shown above) at the top of the drop-down box.


Step 5: Create a New Credit Card Account in the Chart of Accounts

After clicking Add new, you’re asked to provide information to add an account to your Chart of Accounts. You can glance ahead to How to Set Up the Chart of Accounts if you want to learn more but, for now, you can provide a few details.

Add a new credit card to the Chart of Accounts in QuickBooks Online.

Add a new credit card to the Chart of Accounts in QuickBooks Online

The Account Type and Detail Type must be Credit Card. An account name is required, and we recommend including the credit card company name for easy identification. If you have more than one credit card with the same company, you might also include the last four digits of the credit card. When you have entered all the information, click the green Save and Close button, and you’ll be returned to the prior screen with the new account selected.


Step 6: Select the Right Date Range

After linking your credit card to an account from your Chart of Accounts, you must decide when QuickBooks should begin importing transactions.

Selecting the beginning date to transfer bank transactions.

Select the beginning date to transfer bank transactions

The default start date to pull transactions is the beginning of the year. You should try to pull transactions back to the date you wish to start using QuickBooks Online. If your credit company or QuickBooks doesn’t allow you to go back that far, you’ll have to transfer the older transactions using a QBO or CSV file.

Paul’s Plumbing is importing credit card transactions starting on January 1 of the current year. Click the green Connect button when you’re done.


Step 7: Review Downloaded Transactions in the Banking Center

QuickBooks Online will take you to the Banking Center after connecting your bank account. The Banking Center includes the following options:

  • Transactions for review: The orange number (not shown) in the Capital One box is the number of transactions that have been imported, but not yet reviewed and classified.
  • Review tab: The tab labeled For Review lists all the transactions imported from your selected bank or credit card that are awaiting review.
  • Add account: To connect another bank or credit card company to QuickBooks Online, click the green Add account button in the upper right-hand corner of the screen and repeat the process.

You can peek ahead at How to Manage QuickBooks Online Bank Feeds if you’d like to learn more about classifying transactions, but we recommend waiting until we complete a few more setup tutorials. It’s important to have your Chart of Accounts finalized before you start assigning transactions.

Now that your credit card account is connected, new transactions will be imported automatically into QuickBooks Online daily, or you can click Update in the upper right corner to import any new transactions immediately. You can visit the Banking Center anytime by clicking the Banking dropdown under Banking from the left menu bar (as you did at the beginning of this tutorial).


How To Import Credit Card Transactions Manually Into QuickBooks Online With a CSV or Similar File

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

QuickBooks Online can import credit card transactions from the following types of files:

  • CSV: These files are commonly used to export data for a multitude of purposes and can be opened and edited with Excel.
  • QBO: QBO files are QuickBooks WebConnect files specifically designed for exporting information from bank or credit card accounts to QuickBooks.
  • QFX: QFX files are financial exchange files created for exporting information to Quicken, but they’ll also work with QuickBooks Online.
  • OFX: An OFX file is a text file specifically designed for exporting financial data.
  • TXT: Text files can be imported but might require some editing first. You might want to open the TXT file with Excel and convert it to a CSV file for a smoother transfer.

To obtain a transfer file, log into your credit card account, and locate the option to download your account transactions. You’ll likely have the option to download your transactions in multiple formats. Choose the QBO or QFX format, if available, since they’re designed specifically for QuickBooks. The next best option is an OFX file. If none of those file types are available, a CSV or TXT file will suffice but require a couple of extra steps.

Save the transfer file to a location on your computer that you can remember easily to import the file.

Step 2: Select the Transfer File to Upload in QuickBooks

From the Banking Center, open the drop-down menu next to Update in the upper right corner, and then select Upload from file.

Selecting Upload from file from the Banking Center in QuickBooks Online.

Select Upload from file from the Banking Center in QuickBooks Online

Drag and drop your file of transactions or click Select files to browse your file on your computer, as shown below. Click the green Continue button to proceed.

Selecting the transfer file to import into QuickBooks Online.

Select the transfer file to import into QuickBooks Online

Step 3: Select a QuickBooks Account

Next, you must select an account from your Chart of Accounts to record the imported bank transactions.

Selecting an account to record imported transactions in QuickBooks Online.

Select an account to record imported transactions in QuickBooks Online

If needed, you can click Add new to set up a new credit card account as demonstrated earlier. Paul’s Plumbing created a new QuickBooks account named Local Credit Card. After you have selected a QuickBooks account to record the imported transactions, click the green Next button in the lower right-hand corner.

If your transfer file is a QBO, QBX, or OFX file, you’re done and can skip to step 6.

If your transfer file is a CSV or TXT file, you have a couple more steps to complete.

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

Before completing this step, you should open your CSV or TXT file in Excel to determine exactly what information your bank exported and how it’s formatted. Paul’s Plumbing exported the following CSV file from their local credit union account.

Tip:

When you open a CSV file in Excel, you may be asked to save the file as an Excel file to preserve features. Don’t do this because the file must remain a CSV file to be imported into QuickBooks.

CSV file for import into QuickBooks Online.

CSV file for import into QuickBooks Online

Notice that transaction amounts are shown in column C with credit card charges shown as positive numbers and payments to reduce the credit card balance as negative numbers. Some credit card companies might include charges in one column and payments in another column. Either way is fine, but you’ll need to know how the amounts are organized in the next step.

After completing step 3, if you’re importing a CSV or TXT file, QuickBooks will take you to the Map Columns screen (not shown), where you’ll need to provide information, including:

  • First row in the file is a header row: Place a checkmark in this box if the first row in your transfer spreadsheet provides the title for each column.
  • Date: Click the drop-down arrow and select the column in your transfer spreadsheet that contains the date. In the next field, select how your spreadsheet formats the date.
  • Description: Select the column that contains a description of the transaction. I recommend selecting whichever column is going to provide you with the most information to help classify the transaction without doing further research. Paul’s Plumbing chose the “Appears On Your Statement As” column instead of the “Description” column because of the more detailed information.
  • Amount: First, choose whether your spreadsheet has all amounts in one column or if charges and payments are in separate columns. As we saw above, Paul’s Plumbing’s spreadsheet has all the amounts in one column and are located in column C. If you indicate amounts are shown in two columns, you’ll need to specify one column for money spent (charges) and another for money received (payments).

When you’re satisfied with your mapping, click the green Next button in the bottom right corner of the screen.

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

You can select which transactions from your file to import. We highly recommend importing all transactions into the file. Even personal transactions on your business credit card account need to be imported. Reconciling your credit card account from QuickBooks to your credit card statement is an important step to make sure your books are accurate. The reconciliation isn’t possible if you don’t import all transactions.

Make sure all transactions are selected and then click the green Next button in the bottom right corner of the screen to complete the import of your transactions.

Tip:

If there are no transactions listed on this screen, make the following changes to your file:

  • Remove all formatting from the amount column, including dollar signs
  • Remove blank rows so that everything begins at row 1, column 1 of the spreadsheet

If you make changes to your spreadsheet, you must save it and then back up to step 2 and reselect the file to import.

Step 6: Return to the Banking Center

Go back to the Banking Center. Your bank account is now shown in the upper left corner with the number of transactions awaiting review. You may have to refresh your browser for your banking center to reflect your freshly imported transactions.

Banking Center with transactions awaiting review.

Banking Center with transactions awaiting review

We’ll learn how to review the transactions and accept, exclude, or match them to an existing transaction in How to Manage QuickBooks Online Bank Feeds, but I recommend completing the tutorials in order.

The Importance of Connecting Your Credit Card to QuickBooks

Connecting your credit card account to download transactions automatically is one of the biggest time-savers offered by QuickBooks Online. Once connected, all you need to do is sign in to QuickBooks and classify the transactions that will transfer daily automatically. Most credit card companies allow you to connect to QuickBooks using your online sign-in credentials. If your credit card doesn’t allow a connection to QuickBooks, you can still import your credit card transactions using a QBO file or a CSV file with the help of Excel.

Tip:

Combining personal and business activity on the same credit card makes for messy bookkeeping, wastes your time, and will likely drive up your accounting fees at tax time. We highly recommend that you get a business credit card and use it purely for business. You can check out our list of the small business best credit cards on the market.

Wrap Up

You’ve now learned to connect your credit card to QuickBooks Online and import credit card transactions manually when necessary. We’ll return to managing bank feeds in a later tutorial. First, however, we must finish setting up your QuickBooks Online company. The next tutorial in our QuickBooks Online Training Course is QuickBooks Online Multiple Users Setup, where you’ll learn how to allow your external accountant and as well as other employees full access to your QuickBooks Online.

← Previous Tutorial

QuickBooks Tutorials

Next Tutorial →

About the Author

Mark Calatrava

Find Mark OnLinkedIn

Mark Calatrava

Mark Calatrava is an accounting expert for Fit Small Business. He has covered more than 50 accounting software for small businesses and niche industries and has developed an in-depth knowledge of the important features of accounting software and how the importance of these features vary by business.

Fit Small Business

Facebook Twitter LinkedIn YouTube

Company

  • About Us
  • Editorial Policy
  • Careers

Partners

  • Work With Us

Contact Us

228 Park Ave S # 20702
New York, NY 10003-1502

info@fitsmallbusiness.com

Fit Small Business BBB Business Review

Facebook Twitter LinkedIn YouTube

© Fit Small Business 2023

California Privacy Rights | Privacy | Terms | Sitemap

Need Assistance with QuickBooks Online?
QB Live matches you with a personal bookkeeper!
Visit QuickBooks Live
Need Assistance with QuickBooks Online?
Visit QuickBooks Live

Was this article helpful?

Feedback

Join Fit Small Business

Sign up to receive more well-researched small business articles and topics in your inbox, personalized for you. Select the newsletters you’re interested in below.

Please select at least one newsletter.