Bank Reconciliation

I did a bank reconciliation and accidentally put the incorrect amount in the statement end balance.  

I just realized that it was the incorrect amount after it was posted.

I could not figure out why I was out the amount that was unresolved because everything else matched up.  

I posted the unresolved amount to bank rec adjustments at the time so I could move forward with the next bank rec.

The next bank reconcilation started with the correct amount from the previous month.  How is this possible?  If I entered $10.00 as an opening balance and it should have been $5.00, the next time I do the bank rec, it should still be $10.00, correct?  

I can reverse the entry out from the bank rec that has already been cleared, but I cannot clear it from the account reconciliation screen.

I know this does not make any sense, but can anyone help me with this??

  • 0

    You're right - it makes no sense :) First off, I think you meant to type "If I entered $10,00 as a CLOSING balance," not an opening balance. You don't type the opening balance except when the first reconciliation is done. Last month's closing/ending balance becomes this month's opening balance.

    I would print out the last bank reconciliation report and verify the account, the dates and the balances on that. Compare the same field to the bank rec screen.

  • 0

    You said you posted the unresolved amount to bank rec adjustments in order to move forward.

    Now you need to make the same entry again in reverse in order to balance correctly.

    Leave the balance forward as it shows and enter the bank stmt ending balance as per bank stmt amount.

    Then you need to clear the 2nd JE in order to balance properly.

    Let me know if this helps.

  • 0 in reply to Smith and Co

    I have done all of this - I am referring to both comments posted.

    I did compare the dates and the balances.

    I have reversed the original JE - the bank rec is now correct.  

    However, now this entry is sitting in the Bank Rec Journal with only one side of an entry, which is the amount crediting the bank.

    The balance is not showing anywhere else except in the Bank Rec Journal.