Bank Reconciliation

SUGGESTED

I am reconciling the bank, my deposit (that I am tying to reconcile) is listed (say its $4300.00) and it has a red flag beside it, so it needs to manually reconciled it. I found two transactions that represent this deposit. One  is 500.00 it comprises of four checks I received from customers  (in payment for goods). The other is a journal entry for a check deposited from my personal bank account.  Both show up separately in the list of deposits (so I see one for $500.00 and one for $3800.00) normally when this happens I can click on each deposit and connect them.  I cannot get them to merge into one deposit, so it will allow me to manually reconcile. When i click on the smaller amount I see a list of the 4 checks (that make up part of this deposit) all with red checkmarks beside them, however when I double click on the larger deposit I get taken to the General Journal. It pulls up the entry i made (at the time of the deposit) but there is no way to connect it (the general journal entry) to the other deposit. As a result i cannot get the deposit to match. What do i do? 

Parents Reply Children
  • 0 in reply to Mark Moland
    SUGGESTED

    You do not have to clear the red flag to close the reconciliation.  It is just telling you what has not cleared. 

    You cannot group a General Journal Entry with a check on a deposit ticket.  Going forward, do them as separate deposits. 

    I still download the Bank Statement.  If I have any discrepancies, I simply make a note on the paper copy.  I print the outstanding items and the account reconciliation stmt.  Going forward, if something changes, I can always come back to the original documentation. 

    Shirley Byard, Sage 50 Master Certified Consultant

    [email protected]   304-233-2612

  • 0 in reply to Mark Moland

    The red flag is telling you there was a bank deposit that didn't clear automatically.  It sounds like you cleared the two deposits that made up the red flag, manually.  So I would manually clear the red flag because it's not an issue anymore (right click/delete).  If I'm understanding you correctly...

    When I do my bank reconciliations; I don't leave any red flags. I would enter journal entries to record if nothing has gone through the system to clear it.