Cleared credit card charge showing up as uncleared "deposit" in checking account register

Hi @lrskagit, thanks for dropping by. I've got an idea of why you're getting this issue and how to fix it. 

Please know that when reconciling your accounts you have to ensure that the beginning balance matches the balance from your last reconciliation. It's good to know that you've run the Previous Reconciliation report that shows recent changes in your accounts. Let's try running the report again to review all the cleared transactions, including the credit card charge that shows uncleared.

I'll guide you on how:

1. Go to the Reports menu, then select Banking.
2. Search and open the Previous Reconciliation report.
3. Select the account you reconciled, then either Detail, Summary, or Both.
4. Select Transactions cleared, plus any changes made to those transactions since the reconciliation.
5. Select Display.

Note the ending balance. This should match your beginning balance when you start reconciling again. Under New Transactions, you'll see all the changes you've made since the reconciliation including the uncleared credit card charge. I'd suggest clearing it manually from the account register.

Here's how:

1. Go to the Lists menu and select Chart of Accounts.
2. Look for the credit card account that needs fixing.
3. Locate the uncleared transactions.
4. Clear them by putting a checkmark.
5. Once done, click Record.
6. Click Yes to confirm.

Once done, go back to your Previous Reconciliation report. Make sure that there are no more entries under New Transactions.

After that, you can now proceed to reconcile the next statement until the difference between your bank statement and QuickBooks should be $0.00.

Here are some articles that you can read to learn more about reconciling accounts and how to fix discrepancies:  

• Fix beginning balance issues in QuickBooks Desktop   
• Fix issues when you're reconciling in QuickBooks Desktop

Should you need further assistance reconciling your accounts, let me know in the comment below. Stay safe!

I'm sorry, but I think you are misunderstanding my question.  I'm not having trouble with the cleared starting or ending balances.  The issue is that the "Register Balance" on the statement does not match the account balance on the balance sheet.  The reason why is that suddenly, for no reason I can ascertain, a credit card charge for $700 appears on an updated reconciliation report under Uncelared Transaction/Deposit and Credits.  So now, the Register Balance on the original reconciliation is $700 less than the BS balance although I haven't changed anything.  Additionally, the credit card statement reconciliation still shows this transaction as a cleared charge.  When I drill down on this transaction in the updated checking reconciliation and the credit card reconciliation, they both take me to the same transaction, so it doesn't seem that there are two transactions behind this.  What I want to know is why a credit card charge (not a payment on the credit card balance) is showing up on the checking account reconciliation and how can I remove it.  Thanks.

Hello there, @lrskagit.

Thanks for replying back here in the thread and providing us with a more detailed breakdown of the issue you're encountering right now. Allow me to chime in on this conversation to clarify things out and provide steps on how we can prevent this uncleared credit card charge from showing up as an uncleared "deposit" in the checking account register.

In QuickBooks Desktop (QBDT), here are the following reasons why the balance from the reconciliation doesn't match:

• Outstanding transactions
• New transactions for a connected account
• Duplicate transactions
• Edited or deleted transactions
• Credit card (liability) account

To make modifications to your reconciled accounts, we can carry out a quick reconciliation in QuickBooks Desktop (QBDT). This unique method makes a repair using an "off-cycle" reconciliation date. Here's how:

1. Go to Banking and select Reconcile.
2. Select the bank account with the transactions you need to reconcile.
3. Enter the date for an "off-cycle reconciliation" in the Date of Statement field. Note that when entering an "off-cycle" date, QuickBooks will remind you that you're doing a mini reconciliation. This puts previously unreconciled transactions back without affecting the "cycle" that they follow.
4. In the Ending Balance field, enter the balance of your last successful reconciliation and select Continue.
5. Check off the transactions you are fixing and re-reconciling in the Reconcile window.
6. Make sure the Difference field shows $0.00.
7. When everything looks good, select Reconcile Now.

Additionally, here's an article that'll help you create rules t help QuickBooks match your bank feed transactions: Create rules to categorize transactions in QuickBooks Desktop.

I'll be around in case you need further assistance in managing bank transactions in QBDT. Simply leave a comment below, and I'll get back to you.

Thanks for trying, but that didn't work.  When I checked off the item, there was a difference of that amount.  If I finished, it would have made an adjustment that isn't needed.  I think this must be a data corruption issue -- do you know any way that a credit card charge would show up as a checking account transaction?  It still shows in the credit card account register as a cleared item and there is no duplicate that I can find.  So one transaction is showing up in two different accounts. I checked that the proper credit card account was selected on the credit card charge entry -- everything looks normal.  All of this activity is after the cleared balance, which hasn't changed, so I guess I can just leave the outstanding item uncleared forever, but that seems like a lousy solution.  Thanks anyway.

Thanks for the answers, but I already tried all the things you are suggesting.  No one has actually addressed my major question...how can a already cleared credit card charge show up on the bank account ledger, other than data corruption.  Has anyone ever run across this before?

Hello, lrskagit. 

Yes, you are right. It's possible that your data was corrupted. Let's go ahead and start troubleshooting to determine whether it's something to do with data damage. Let's make sure also you've latest release for QuickBooks Desktop. 

Then, we can run Verify Rebuild, it possible your company file may be damaged, or the folder where the company file is saved may be damaged. The Verify Data utility identifies any potential data damage issues that might've caused an unexpected error while running the data. While the Rebuild Data utility repairs damaged data in your company file. Before this, you'll have to secure a backup copy of your company file. 

The other way around, we can check and run an Audit Trail report. Other users may have modified some of the transactions, which may cause some uncleared transactions. 

Here's how:

1. Click Reports at the top menu bar and choose Account & Taxes.
2. Select Audit Trail.
3. On the report screen, click Customize Report.
4. Go to the Filter tab and search for Transaction type.
5. Select Deposit and Credit card. Then hit OK.
6. Filter the dates. 

You can also check this article that can help guide you to generate reports in your QBDT to show the information you need: Customize reports in QuickBooks Desktop.

Feel free to leave a comment below if you have follow-up questions. I'm always glad to help.