Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI 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?
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:
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.
Hi Clark,
Thank you so much!
Sue
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here