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 Reconcile Credit Card Accounts in QuickBooks Online

Updated February 20, 2023

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 June 29, 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 June 29, 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

Quickbooks Online
This guide will teach you how to reconcile credit card accounts in QuickBooks Online—a crucial step that ensures that the credit card activity in QuickBooks matches your credit card statements. This lesson will help you make QuickBooks credit card reconciliation easy.

This course, along with our other QuickBooks Online tutorials, will improve your knowledge of the platform, which we ranked our best small business accounting software. Watch the video or read through the instructions as you follow along in your own QuickBooks account. If you don’t have one, you can sign up for a 30-day free trial or get 50% off for three months.

Visit QuickBooks Online

Step 1: Navigate to the Credit Card Reconciliation Screen

Hover your cursor over Accounting in the left menu bar, and then select Reconcile.

Opening the credit card reconciliation screen.

Open the credit card reconciliation screen


Step 2. Select the Account & Enter Your Statement Information

We’ll walk you through what to input in the credit card reconciliation screen’s fields below.

Entering information to process QuickBooks credit card reconciliation.

Enter information to process QuickBooks credit card reconciliation

A. Account: Select the credit card account that you’re reconciling.

B. Last statement ending date: QuickBooks indicates the date of the last statement reconciled for this credit card account. There will be no date if this is the first reconciliation of the credit card.

Don’t skip months.

A reconciliation always starts with the reconciled balance from the prior month, so you can’t skip months. If it’s been several months since a reconciliation, you need to go back to the last reconciled statement and work forward one month at a time.

C. Beginning balance: QuickBooks shows the ending balance of the prior statement reconciled, which must be the beginning balance of the current statement. This amount will be zero if this is the first time the credit card is being reconciled.

Verify beginning balance.

For your reconciliation to work, the beginning balance calculated by QuickBooks must match the ending balance on the last statement reconciled. If there were any changes to previously reconciled transactions, the beginning balance may be off—and if it is, QuickBooks provides a link to help you identify the transaction that changed.

D. Ending balance: Input the ending balance from your credit card statement.

E. Finance charge: If you haven’t already done so in a separate transaction, input the finance charge (if any) from your credit card statement. Indicate the date the charge was assessed and the expense account, or category, to track the expense. QuickBooks will record this expense automatically when the reconciliation is complete.

After entering all your statement information, click the green Start reconciling button.


Step 3: Match Credit Card Transactions

After completing the previous step, QuickBooks will display a screen with a summary of the reconciliation in the top half and detailed transactions in the bottom half.

Matching credit card transactions to your credit card statement.

Match credit card transactions to your credit card statement

A. Statement ending balance: The statement balance carries over from your input in the prior screen and should match the ending balance on your credit card statement.

B. Cleared balance: QuickBooks calculates the cleared balance as the beginning balance from the prior screen plus charges you mark as cleared, minus payments you mark as cleared.

C. Difference: The difference between the statement ending balance and cleared balance must be zero before you can finalize a reconciliation. You’ll see an exclamation point if the difference isn’t zero, meaning you’ll have to reconcile those entries.

D. Radial buttons for cleared transactions: Click the radial button in the right-most column for each transaction if that transaction appears on your credit card statement. After you click the radial button, the transaction will be included in the cleared balance (item B).

What To Do if Credit Card Transactions Don’t Match QuickBooks Entries

Matching transactions between QuickBooks and your credit card statement consists of tracing transactions from the platform to your statement and then investigating unmarked transactions on your statement.

Trace Transactions From QuickBooks to Your Statement

Start by looking at each transaction listed in the QuickBooks screen above and finding it on your credit card statement. If you find it, click the radial button for the transaction (item D) and place a checkmark next to the transaction on your statement.

You need to investigate any transaction in QuickBooks that isn’t on your bank statement. While the most likely cause is an error in your QuickBooks accounting, don’t delete the transaction because it may affect other accounts or periods.

Here are some of the most common errors that will cause incorrect QuickBooks credit card transactions to appear:

  • Duplicate transactions: You may have inadvertently created a duplicate transaction and while the original transaction will be shown on the statement, the duplicate won’t. For instance, if the credit card activity is imported from the bank, you may have added a new transaction instead of matching it to an existing transaction. If so, you should delete the duplicate transaction.
  • Wrong account: The suspect transaction may have been a charge on a different credit card and incorrectly recorded on this account. If so, edit the transaction and assign it to the correct account.
  • Wrong date: If you enter the wrong statement date, you may run into some issues during reconciliation. For instance, if the statement date is too early, some necessary transactions might be missing; and if it’s too late, some additional transactions might be included in your statement. Always ensure that the statement date you enter in QuickBooks matches your bank statement.
Investigate Unmarked Transactions on Your Statement

When tracing from QuickBooks to your statement, you placed a mark next to each transaction on your statement that was shown in QuickBooks. Now, look for any transactions on your statement that don’t have a mark. If unmarked transactions are legitimate, they need to be added to QuickBooks. Once added, mark the transaction as cleared by clicking the radial button in the right-most column.

Open a second QuickBooks tab.

Instead of working on a single screen when doing reconciliation, you can keep two or more tabs open as this allows you to have the reconciliation screen open in one tab and make necessary changes to transactions in another, helping you speed up the process. To do this, right-click on the reconciliation screen’s tab in your internet browser and select “duplicate” to open a second tab. Once the changes are saved, you’ll need to refresh the original tab to see the updated screen.


Step 4: Confirm the Difference Is Zero

Once all the selected transactions in QuickBooks match the transactions on your credit card statement, the difference between your statement ending balance and cleared balance should be zero. If it isn’t, then review our troubleshooting tips to locate discrepancies either on your statements or in QuickBooks.

Here’s a sample reconciliation with all of the transactions matched to a credit card statement.

Completed credit card reconciliation in QuickBooks Online.

Completed credit card reconciliation in QuickBooks Online

When your reconciliation is complete, click the green Finish now button in the upper-right corner of the screen.


Step 5 (Optional): Make a Payment on the Credit Card Balance

QuickBooks will display a message to confirm the reconciliation is complete and to ask if you want to make a payment towards this credit card balance.

Choosing how to pay a reconciled credit card in QuickBooks Online.

Choose how to pay a reconciled credit card in QuickBooks Online

You don’t have to select an option at this point as you can write a check or enter a bill later by going to the Write Check or Create Bill screens directly. But if you want to make a payment now, then do one of the following:

A. Click Pay all or a portion of the bill now to go to the Write Check screen, where you can create a check for the credit card balance you wish to pay. The category should default to the credit card account you just reconciled, and you shouldn’t change it.

B. Click on Enter a bill to pay later to go to the Create Bill screen, where you can enter a bill for the balance you wish to pay by the due date shown on the credit card statement. Make sure the category is the credit card you just reconciled, the bill date is the statement date, and the due date agrees with the due date on the credit card statement.

You should enter a bill because doing so moves a portion of your credit card liability to a current accounts payable (A/P). The advantage is that your credit card payment and due date now appear with your other A/P, so you have a reminder to pay the bill before it becomes overdue.

When you’re finished setting up your payment or have decided to wait until later, hit the green Done button.


Benefits of QuickBooks Credit Card Reconciliation

  • Finds missing transactions: If transactions on your statement haven’t been entered in QuickBooks, you’ll have to add them so that the account will reconcile.
  • Identifies incorrect amounts: If the same transaction has different amounts in QuickBooks and the bank statement, the account won’t reconcile.
  • Locates duplicate transactions: By reviewing transactions that didn’t appear on your bank statement for the month, you can identify transactions that shouldn’t be in QuickBooks.
  • Shows erroneous or fraudulent charges: Any charges on your bank statement that aren’t in QuickBooks should be examined so that you can determine whether they’re legitimate charges. Once deemed authorized, enter them on the platform.

Wrap Up

Congratulations on finishing another tutorial and learning how to reconcile a credit card in QuickBooks Online. The next guide in our free QuickBooks tutorial series is how to manage credit card sales in QuickBooks Online through QuickBooks Payments.

← Previous Tutorial

Free QuickBooks Online 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

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.