Reconiliation...I think I really messed up

Hello there, Miseeyore. Let me help you in fix your ending balance during reconciliation.

When reconciling, you compare transactions in your books with the ones on the bank statement. In the end, the difference between your two records should be $0.00. If it's not, or in the event you reconciled an account before and your ending balance changed, you can find and fix issues so you can finish reconciling.

Here are some common reasons for ending balance discrepancies:
 

• Missing or duplicate transactions exist in QuickBooks.
• Previously reconciled transactions were edited or deleted.
• Adjustments were made to the last reconciliation using a journal entry.
• An incorrect ending balance was entered at the start of the reconciliation.
• Transactions were recorded in QuickBooks that haven’t yet cleared your bank.
   

To start with, first confirm that the opening and beginning balances are correct. Once you know they're accurate, you can start looking for other issues.

Then, review changed, deleted, or added transactions. You can use reports like Reconciliation Discrepancy, Transaction Detail, and Missing Checks to help locate any transactions that have been modified, removed, or added.

If you’re unable to resolve the issue after reviewing these reports, you may need to undo the previous reconciliation to correct your opening balance. Please note that if a transaction was edited or deleted years ago, resolving this may involve undoing reconciliations for multiple prior months to restore the accurate opening balance.

You can also check with an accounting professional if you're unsure of how to approach this. If you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.

Feel free to reach out again if you have additional questions or concerns

Thank you for the reply and guidance.

Thank you for the reply and guidance.  If I changed a transaction code, does that affect the reconciliation?  I found the transaction that was cleared before but is now not cleared and that is the one affecting it.

Good afternoon, @miseeyore. 

Thanks for reaching back out and asking additional questions about your reconcile. 

Yes, changing the transaction's account (which is what a transaction code often refers to in QB) after it's been reconciled will affect your books and can cause discrepancies. 

Even if the amount stays the same it can change which account's balance is affected and how it reports. You'll need to record correcting entries to properly maintain accuracy. 

I hope this helps answer your question. I'm only a post away if you need me again. Take care!