This guide will cover how to manage downloaded credit card transactions in QuickBooks Online. You’ll learn how to match transactions to existing entries, add them as new transactions, or choose from multiple potential matches. Also, we’ll cover how to create a rule to help QuickBooks better remember similar transactions.
Step 1: Go to the Banking Center
Navigate to the banking center by hovering over Banking in the left menu bar and then clicking on the Banking drop-down menu, as shown below.
Seeing a different left-side navigation menu?
Step 2: Select Your Credit Card
The top portion of the banking center displays each checking and credit card account that you have connected to your QuickBooks account. Click on the card you wish to use for importing the transactions. If you haven’t connected your credit card account, see our tutorial on how to import credit card transactions into QuickBooks Online.
The summary box (shown above) displays the account balance reported by your bank and the balance from your QuickBooks account register. The orange number is the number of transactions downloaded from your bank account that haven’t yet been reviewed and accepted, matched, or excluded. In the screenshot above, there are 25 transactions awaiting review in our Bank of America credit card account.
Note that transactions that are downloaded into QuickBooks are already reflected in the bank balance. However, downloaded transactions don’t affect your QuickBooks balance until you review and accept them.
Don’t forget to reconcile. The bank balance and the QuickBooks balance should be the same once all your transactions are reviewed. If there’s a difference, you should be able to find it when you reconcile your credit card account at the end of the month.
Step 3: Navigate to the ‘For review’ Tab
You can see the list of transactions to review in the lower half of the banking center under the For review tab. Below, you can see a few of the 25 transactions awaiting review in our Bank of America credit card account.
Step 4: Review and Manage the Downloaded Transactions
To review and categorize downloaded credit card transactions in QuickBooks Online, you may see either a Match, View, or Add button under the Action column. QuickBooks Online is smart enough to suggest a category for each transaction based on its details.
However, clicking on Match will connect the transactions immediately, and clicking on Add will automatically add the transaction as a new entry. Hence, we suggest that you first review the transaction by clicking anywhere on the entry line—except in the Action column.
Advanced settings: You can specify which columns will appear under the For review tab by clicking on the settings cogwheel directly above the last column. You can include additional columns, such as check number, and show other transaction details, such as bank details.
When QuickBooks detects that a transaction already exists in QuickBooks, you’ll see a Match button under the Action column. You’ll see the potential match found under the Category or Match column. Click anywhere on the entry line to review the potential match.
In the screenshot below, QuickBooks found a potential match for a transaction made with Hicks Hardware. Once you confirm that the transactions match, click the green Match button.
The credit card transaction will move from the For review tab to the Categorized tab, but no transaction will be created in the QuickBooks register since the transaction already exists.
Find Other Matches
If you made a partial payment on an outstanding bill, QuickBooks won’t suggest a match automatically since the amount of the charge is different from the bill. Click Find other matches to open the list of outstanding bills and indicate which bill the credit card will be applied to.
You might also have to use the Find other matches button for matching transactions where the amounts are, in error, slightly different. You’ll need to correct the QuickBooks transaction amount to match the actual credit card charge before you can match the transactions.
In some cases, QuickBooks may detect more than one potential match. This can occur when there are multiple transactions in your account that share similar details, such as the date, amount, and payee. QuickBooks presents how many potential matches it found under the Category or Match column.
You can review the details of each potential match and select the one that best corresponds to the transaction you are reviewing. Click View or anywhere on the transaction line to review the potential matches. Once you select the appropriate match, click Match.
If the imported transaction is new and not yet recorded in QuickBooks, click on the transaction entry line, and QuickBooks Online brings up a screen where you can record the transaction based on its suggestions. For instance, in the screenshot below, QuickBooks suggests the transaction to be recorded under Uncategorized Income. However, you have the option to adjust it based on the transaction. Once done, click the Add button.
You may need to use the Split button If your transaction involves different expense categories. The ‘Split transaction’ screen allows you to allocate the amounts to the respective categories or accounts based on your needs.
Create a rule
When adding a new transaction, you’ll see a Create a rule option at the bottom of the screen. This will help QuickBooks automate the categorization of similar transactions in the future. If you went over our tutorial on how to manage QuickBooks Online bank feeds, you’ll find the “Create rule” form familiar.
To create a rule, you must specify the conditions and select what happens when the conditions are met. For instance, you can create a rule where any books-related transactions made with Books by Bessie above $200 and containing the phrase “books by Bessie” in the description are automatically categorized as bookkeeping services.
Why You Should Manage Downloaded Credit Card Transactions in QuickBooks
After you import credit card transactions into QuickBooks Online, our best small business accounting software, you must tell the platform how to classify the transactions. Imported credit card transactions don’t transfer into your account register automatically. Instead, they appear as transactions awaiting review in the banking center.
By properly categorizing credit card transactions, you can better monitor your expenses. For instance, you can categorize transactions as office supplies or travel expenses—allowing you to track where your money is being spent. More importantly, categorizing downloaded transactions helps you ensure the accuracy of your records and simplify the reconciliation process.
Frequently Asked Questions (FAQs)
Yes, you can. Rules can be created based on specific criteria, such as descriptions and transaction amounts.
Yes, you can. Click on the transaction entry to make the desired changes.
Yes, and you can do so by connecting your bank or credit card account to the platform.
You successfully learned how to manage downloaded credit card transactions in QuickBooks Online and how to match them to existing transactions and apply them against unpaid bills. You also learned to create a rule so that QuickBooks can provide greater detail when suggesting new transactions. The next guide in our course is how to enter a credit card refund in QuickBooks Online when you receive one from a vendor.