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.
SueHayward
Level 1

How to edit an incorrect check amount in the reconciliation detail that does not match the actual check amount as shown in the account activity

I am trying to reconcile my bank statement to my G/L bank account balance and am just $5.00 off. I know why, but not how to fix it. The reconciliation detail report shows an uncleared check of $200, but the actual check amount, as reflected in the account activity for the General Ledger is $195. So I must conclude that there are 2 files; one that can be edited that shows up on the check register (that has the correct amount of $195) and the other file (that feeds into the reconciliation report). I see no way to edit the transaction amount that needs to change from $200 to $195. The only thing I can think of is to use the Rebuild Data utility and hope that it corrects the reconciliation record based on the actual check amount. I understand that a rebuild is potentially risky, so I'm hesitant to try that and end up with other problems. Any ideas?

3 Comments 3
Clark_B
QuickBooks Team

How to edit an incorrect check amount in the reconciliation detail that does not match the actual check amount as shown in the account activity

Hello there, Sue.

 

I'd be glad to route you to edit an incorrect check amount in your Reconciliation Detail report in QuickBooks Desktop (QBDT).

 

You can double-click the amount of your incorrect check to route you to the actual check and then edit the amount of your check. 

 

Here's how:

 

  1. Go to the Reports menu. 
  2. Select Banking, and click Previous Reconciliation Report.
  3. In the type of report, select the Detail and then click Display.
  4. Locate the incorrect check amount through the report, and then double-click the amount.
  5. In the Dollar sign or amount field, enter the correct amount of the check.
  6. Select Save and Close.

 

Once done, check your reconciliation again and verify if the amount changed. However, if it still doesn't match after editing the amount you can use the Verify and Rebuild data. This way, we'll be able to identify and resolve the most commonly known data issues. Also, it's safe to use the verify and rebuild data as it won't affect your data. Just ensure to secure a backup company file if you ever run into issues.

 

I'll also add this article to guide you in customizing any report that you want to generate: Customize reports.

 

Stay in touch with me if there's anything else I can help you with editing your incorrect check amount in QuickBooks. I'll be right here to provide the information that you need.

SueHayward
Level 1

How to edit an incorrect check amount in the reconciliation detail that does not match the actual check amount as shown in the account activity

Hi Clark,

Thank you so much!

Sue

 

Jelayca V
QuickBooks Team

How to edit an incorrect check amount in the reconciliation detail that does not match the actual check amount as shown in the account activity

Thank you so much for your positive feedback, @Sue.

I'm thrilled to hear that my colleague, Clark, was able to assist you in resolving your concern with QuickBooks. Your satisfaction is our top priority, and we always strive to provide the best possible service to our valued customers like you.

Please keep in mind that the QuickBooks Community forum is always available to assist you with any other questions or concerns you may have. We have a team of experts who are dedicated to helping you get the most out of your QuickBooks experience.

Wishing you all the best! 

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

Need to get in touch?

Contact us