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?