Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
GolfNut72
Level 5

Duplicate check amount, but only 1 entry?

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 Comment 1
JeveeAdvin__la
QuickBooks Team

Duplicate check amount, but only 1 entry?

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.

    image.png

    image.png

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

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us