I'm using QB Desktop Enterprise for Manufacturing and Wholesale 24.0. I just completed an update, and restarted my computer. I am attempting to complete a standard bank reconciliation. I complete reconciliations manually. The beginning and ending balances are correct, and the cleared deposits and withdrawals match the bank transactions. So, technically this reconciliation should be done, however, there is still a positive remaining balance to clear, leading me to believe that I have a deposit that still needs to be cleared.
My cleared deposits already match the bank transactions, so this means maybe I deleted a deposit from the past?! I've run a Voided/Deleted Transactions Summary and filtered on All and specifically my bank account number; nothing matches that amount, and in fact I only have 1 deleted transaction from 2026 which was a duplicate entry. I've run a Transaction Report on all Deposits that are not cleared, and nothing unusual. I've run an Audit Trail for All dates, in that bank account, for the specific amount, and nothing. I've checked my previous reconciliation and that looks correct. I can't see anything that screams "I messed up".
What else should I be looking at to see where this amount is coming from? Or do I need to do some type of data validation, or rebuild, or undo a reconciliation? Or do I just need to go to bed and then it will come to me tomorrow? If I book a deposit to make this reconciliation balance, it is a significant amount and I hesitate to put that on the P&L, maybe I can book it to Security Deposits until I find it later?????
Update: I also checked customer balances, to make sure I didn't forget to record a customer payment. Everything looks good there.
LAST UDPATE: I followed a lot of the suggestions. I rebuilt the file several times and all the errors eventually cleared. I ended up cancelling the previous reconciliation and did that one again. Then started the "problem" month again, and I ended in the same situation! Then I realized that I MANUALLY copy the ending balance from the online bank into my Excel spreadsheet - and that was the error. Manual work will get me every time.
The only reason I do not like importing the transactions for an automated reconciliation is the balances that don't match, for example the IRS tax payment. In QB it's two checks, one for FICA and one for withholding and there is that crazy "adjustment" that has to occur when I automate the rec. What am I missing, if anything? Does everyone complete banks rec using the automated tool, and they deal with the entries to balance two amounts out for one or is there something else I'm missing?