QuickBooks Credit Card Payment is Not Showing up in Reconciliation

Check Transaction Status

Before you even begin making changes to data in QuickBooks, you need to be certain that the transaction actually went through and didn’t actually fail.

For this, you can log into your bank account and check your transaction history. A detailed history reveals transactions that happened a long while back. You can use the various filter and sort options available on your bank’s website to quickly get to the status of the transaction.

Note: you should also check for any journal entries on the QuickBooks desktop that may have been used to reconcile the transaction. If the credit card transaction was already reconciled using a journal entry, then it won’t show up when you try to create a reconciliation report.

Check Transaction History

By looking at the transaction history, you can recover any transactions that are still mentioned on your bank statement but aren’t showing up in Quickbooks. You can even recover these transactions.

Here are the steps to make a deleted credit card payment show up in QuickBooks:

💠 From the Reports menu, Choose Banking.
💠 Click on Reconciliation Discrepancy.
💠 Choose an account that the transaction belongs to.
💠 Click on Ok, then review the created report.
💠 Speak to the person who changed, added, or deleted the particular transaction for more information about the same.

Go through the Report and filter out all the transactions that show up on your Bank Statement, but not in QuickBooks. Any aberrant or missing transaction should be accounted for when reconciling an account in QuickBooks.

Further, a transaction detail report can also show changes made to a particular transaction in QuickBooks.

To check credit card payments through the transaction detail report, follow these steps:

💠 From the Reports menu, click on Custom Reports.
💠 Choose Transaction Detail.
💠 In the Display Tab, select the date range using the Date From and Date to options.
💠 From the Filter tab, choose all the required filters that’ll help to narrow down your search for transactions.
💠 Sort the transaction by Entered/Last Modified, then select Ok.
💠 Once you have the Report, find the altered or deleted transaction and speak to the concerned person for further details.
💠 Click on Ok after selecting the account that you want to reconcile.

Find Adjustments for Reconciliation

When a user uses a journal entry or reconciliation adjustment to forcefully reconcile a transaction so that he or she can match the transaction to the bank record, the transaction doesn’t show up when running a reconciliation report. While adjustments show that transactions are equal, they don’t actually fix the problem. Over time, this becomes a major problem when the user tries to create any type of report.

To view all the adjustment entries leading to the credit card payment not showing up in QuickBooks, follow these steps:

💠 Click on the Lists menu.
💠 Choose Chart of Accounts, then Reconciliation Discrepancies account.
💠 Enter the Date range for the adjustments.
💠 Find adjustments that lead to inaccuracy in your accounting data.

Once you’ve found such transactions, you can reverse them and ensure that transactions appear during reconciliation. Sometimes, an entry that was supposed to be made in a company’s accounting is not being recorded. If this happens, it will affect how a business performs.