Bank reconciliation shows resolved amount upon opening, before anything has been cleared

I posted this before, but mistakenly marked it as answered; but it wasn't.

When I was doing the reconciliation I think at some point I clicked on the ‘Show Deposit Slip Details’ box instead of the ‘Do not show corrections’ box.

I usually only have one or two cheques on a deposit because we do most of our business by credit/debit card. Sometimes I do a deposit and then someone brings in a cheque, so I do another deposit slip, because I know I can’t easily change a deposit once it is recorded. (My boss makes the deposits through the Interac machine and doesn’t use the deposit slips any way.) That is why I didn’t notice right away that each cheque was showing on the list, rather than the total deposit; but whenever I went to clear a deposit item, sometimes more than one would clear all at once. After that happened a couple of times, I noticed that the ‘Show Deposit Slip Details’ box was checked and I unchecked it. This is the only thing I can think of that caused a problem with the system.

When I got to the end of the bank statement, there was nothing left in unresolved, nor any discrepancy, but there was a much bigger amount outstanding than there should have been and when I looked back, I saw that none of the bank deposits were cleared. When I cleared them, it started showing a discrepancy in that exact amount. I checked the box to unclear everything and started over, but it didn’t change. In fact, it showed a resolved amount equal to all of the bank deposits, even though nothing was flagged as cleared. I even logged off and back on; nothing helped.

Is resetting the bank reconciliation, and setting it back up as if it was the first time, the only solution to this?

  • 0

    if you uncheck everything, and you set the ending balance to 0
    is the unresolved = -opening balance ?
    and are both the resolved and discrepancy amounts 0$ ?

  • 0 in reply to Roger L

    No, it is equal to the opening balance plus the resolved amount.

  • 0 in reply to Kain

    The opening balance is 14,168.39 and I have set the end balance to zero. Resolved shows 37,942.61, outstanding is -34,286.78 and unresolved is -52,111.00. Discrepancy shows as zero. The resolved amount of 37,942.61 is the exact amount of all of the deposits combined.

  • 0 in reply to Kain

    to be clear

    show deposit slip details is checked - so you see all deposit transactions

    do not show corrections is unchecked - so you see all corrections

    and all these transactions are unchecked

    and your resolved is still 37,942.61 ?

  • 0

    This shows as answered, but it's not. I must have clicked the wrong button when I was responding to Roger L. The answer to your question, Roger L, is Yes. I still have an unresolved of 37,942.61 even with the "show deposit slip" checked and the "do not show corrections" unchecked.

  • 0 in reply to Kain

    what happens if you set the statement end date to match the statement start date (reconciling just one day),

    and set the end balance to match the start balance

    and you uncheck everything - is the unresolved amount 0.00 ?

  • 0 in reply to Roger L

    No, the unreolved amount is -37,942.61 and the resolved is 37,942.61

  • 0

    When I was doing the reconciliation I think at some point I clicked on the ‘Show Deposit Slip Details’ box instead of the ‘Do not show corrections’ box.

    I usually only have one or two cheques on a deposit because we do most of our business by credit/debit card. Sometimes I do a deposit and then someone brings in a cheque, so I do another deposit slip, because I know I can’t easily change a deposit once it is recorded. (My boss makes the deposits through the Interac machine and doesn’t use the deposit slips any way.) That is why I didn’t notice right away that each cheque was showing on the list, rather than the total deposit; but whenever I went to clear a deposit item, sometimes more than one would clear all at once. After that happened a couple of times, I noticed that the ‘Show Deposit Slip Details’ box was checked and I unchecked it. This is the only thing I can think of that caused a problem with the system.

    When I got to the end of the bank statement, there was nothing left in unresolved, nor any discrepancy, but there was a much bigger amount outstanding than there should have been and when I looked back, I saw that none of the bank deposits were cleared. When I cleared them, it started showing a discrepancy in that exact amount. I checked the box to unclear everything and started over, but it didn’t change. In fact, it showed a resolved amount equal to all of the bank deposits, even though nothing was flagged as cleared. I even logged off and back on; nothing helped.

    Is resetting the bank reconciliation, and setting it back up as if it was the first time, the only solution to this?

  • 0 in reply to Kain

    I have the exact same problem...did you find another solution to this other than resetting the bank rec?