Hello Folks,
I'm hoping someone here can help me.
I started the Bank Reconciliation for last month, entering the correct ending balance. Out of Balance section was 0 because I just started. The previous months Bank Rec was fine, no issues - I verified the balance listed when I began the Bank Rec was the same amount as I had previously reconciled to.
While reconciling, I came across a missing transaction (~$8,000). I sorted a couple of the columns to make sure it was missing. Well, this transaction happened to be a check payment for an A/P invoice that printed incorrectly, had to be reversed, then reprinted. So, in the Bank Rec, there should have been a positive and negative amount for the incorrect check#, and a positive amount for the correct check #. However, there was only a neg amt for the incorrect #, and a positive amt for the correct #
Vendor inquiry showed everything right- incorrect chk, reversing chk, and correct chk. I assumed I should make a correcting entry in GJ, which included the bank acct ( so it would show in the reconcile). Well, I ended up with 3 GJ entries - 2 that cancel each other out, and one in GJ that says Not Updated. I know now that GJ does not hit the bank rec.
In the Bank Rec, after clearing all transactions, it continued to show Out of Balance. I ran the Utility, but to no avail. So, I uncleared everything to start over. But now it is Out of Balance by about 18,900. The GJ I did is the only transaction I can think of that might have affected the Bank Rec.
Any suggestions as to what I can do to fix this issue?
Regards, Matt