Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
New Member
August 5, 2025
Question

Duplicate check amount, but only 1 entry?

  • August 5, 2025
  • 1 reply
  • 14 views

I'm not sure how to describe this exactly, but I will try and explain -

 

I am cleaning up some reconciliations, and I have a problem with one statement/check.

 

I have a check for $1445.67, number 1616.  The reconciliation is also out of balance by -1,445.67

I cannot find a duplicate entry.  I went back to the transactions, found the check, undid it, and re-entered it.

Same problem.

 

I'm not sure where or how to fix this issue.  Any suggestions?

 

Thanks

EJ

 

 

 

1 reply

QuickBooks Team
August 5, 2025

Hi there, GolfNut72.

 

The reconciliation issue of $1,445.67 (check #1616) is due to a duplicate transaction, incorrect clearing status, or a missing/miscalculated entry. To resolve, verify balances, check for duplicates, and confirm transaction details with your bank statement.

 

To fix the problem, follow these steps:

 

  1. Ensure that the opening balance and ending balances you input during reconciliation match the balances on your bank statement. Use the Edit Info option in the Reconciliation window to adjust, if needed.
  2. Cross-check transactions in QuickBooks with your bank statement and mark those that match to narrow down the discrepancies.
  3.  Go to  Accounting>Expense transaction, sort by amount ($1,445.67), and delete or exclude incorrect duplicate entries manually or via the bank feed.
  4. Go to Accounting > Chart of Accounts, view the account register for the check, and confirm it is marked as cleared (C) or reconciled (R) and exists only once.
  5. If the check doesn’t match, edit or create the check in QuickBooks and adjust for additional fees by creating a Bank Deposit entry, if required.





Also, you can refer to this helpful article for detailed troubleshooting steps on how to resolve discrepancies when QuickBooks Online doesn’t match your bank statement at the end of a reconciliation: Fix issues at the end of a reconciliation in QuickBooks Online.

Before we wrap up, I suggest you explore QuickBooks Live Expert Assisted  to streamline your accounting, maintain precise financial records, and access professional support. This could free up valuable time, allowing you to concentrate on expanding your business.

 

Please feel free to return if you have any additional concerns. We'll provide prompt assistance