cancel
Showing results for 
Search instead for 
Did you mean: 
beecheesymiami
Level 1

Reconciling: Transactions showing up on my reconciliation, but not on statement

When reconciling my credit card, I entered the ending balance and date of 3/20/2023, I check the transactions on the reconciliation page against my statement and all are there, and I get a $0 difference. However, on the reconciliation page and my transactions on my cc, there are still some remaining transactions for 3/20/2023, is this normal? Am I supposed to count these or does that mean they did not clear on 3/20?

5 Comments 5
ChristieAnn
QuickBooks Team

Reconciling: Transactions showing up on my reconciliation, but not on statement

Hi there, beecheesymiami.

 

Thank you for visiting the QuickBooks Community. I'll ensure you can manage your credit card transactions by following the steps below so your reconciliation stays accurate.

 

Since you've already compared the entries on the reconciliation page to your statement and found no differences, it's possible that the remaining transactions displayed are manually imported transactions that were supposed to be allocated to other bank accounts but ended up in the account you're reconciling. 

 

To resolve the problem, I recommend reviewing the remaining transactions to see if they should appear in the credit card account you're reconciling. If it isn't, you have to delete those entries from the Bank Register page. This ensures that your reconciliation remains correct.

 

Here's how: 

 

  1. Go to Gear icon ⚙ and select Chart of accounts.
  2. Find the account you want to review. Then, select View register in the Action column.
  3. Select the Filter icon, then select the filters you want to apply. You can use the Find field to search by amount, reference number, or memo.
  4. Select Apply.
  5. Locate each remaining transaction, then click it to expand the page.
  6. Choose the Delete button, then click Yes to confirm.

 

However, if those transactions are for your credit card, it's possible that said entries haven't cleared in your bank yet. If that's the case, all you have to do is wait for the remaining transactions to be clear in your financial institution.

 

Lastly, you may refer to this article to see different guidelines that can help you fix any reconciliation issues in QuickBooks: Learn the reconcile workflow in QuickBooks.

 

Drop a comment below if you still have concerns about managing your credit card transactions or reconciliation in QuickBooks. I'm always around to help, beecheesymiami. Have a great day!

beecheesymiami
Level 1

Reconciling: Transactions showing up on my reconciliation, but not on statement

Hello, thank you for responding! Maybe I wasn't super clear as this is all so new to me, hopefully, this response provides more insight. 

 

Please see attached screenshot of my reconciliation page.

 

- The remaining 4 transactions are dated 3/20, which also coincides with the end date of my credit card statement. 

- These transactions were not manual entries. They were entries automatically synced from my cc to QB and I categorized them. 

- The transactions do not show up on my bank statement, they are only showing up on my reconciliation page with dates within the bank statement end date.

 

The question is, are these not to be reconciled with his period if the difference is $0 and they do not appear within my statement?

JoesemM
Moderator

Reconciling: Transactions showing up on my reconciliation, but not on statement

Thanks for the prompt reply and for sharing additional details about your concern, @beecheesymiami. Allow me to chime in and help you with the reconciliation process in QuickBooks.

 

When reconciling in QuickBooks, you need to review your accounts to match your real-life bank and credit card statements. In your case, I'd suggest contacting your bank and verifying those transactions since the bank statement will be the basis for the reconciliation process.

 

From there, they can check the transactions and why it doesn't appear in your bank statement. Once fixed, you can follow this article in reconciling your account: Reconcile an account in QuickBooks Online.

 

Also, I'll be sharing these resources that will help you fix issues when reconciling and how to undo transactions from reconciliation:

 

 

If there's anything else I can help with, feel free to post here anytime. I'm always around, ready to help. Take care and stay safe!

lukeish
Level 1

Reconciling: Transactions showing up on my reconciliation, but not on statement

Hello, I followed the above instructions for the extra/duplicate entries left over after reconciling - I deleted them as described in the article. They have now re-appeared in my quickbooks account as "transactions to review" after a sync. Should I exclude all of these transactions?

 

Thank you.

IntuitSheila
Level 8

Reconciling: Transactions showing up on my reconciliation, but not on statement

Hi lukeish,

 

Thanks for joining the thread. 

 

You can exclude the duplicate transactions in your For Review section to avoid duplicate entries on file.

 

  1. Click on the Transactions tab.
  2. Click on Bank transactions.
  3. Locate and click the bank account.
  4. Under For review, click or select the duplicate transactions and click on Exclude.
  5. The transactions will move to the Excluded tab.
  6. Under Excluded tab you can select the transaction and click on Delete.

For reference you can also check this link to learn more about editing and categorising transactions in QuickBooks Online.

 

Drop by again in the Community if you have further concerns. I'll be around to help you.