Mystery Unresolved amount in Bank Reconciliation - Please help!

Hi all,

I've just started working at a company that has never used the Bank rec module in Simply. I've used it at another company and quite like it, so I'm trying to start these guys on the bank rec module.  However I'm facing an issue.  All of the transactions going through the bank statement are entered into simply, in my bank rec, the resolved amount is equal to the difference between the opening and closing balance of the statement as it should.  However, there is an unresolved amount and I can't figure out where this amount is coming from... in the add prior transactions page I only moved cheques that I knew still hadn't cleared and transactions that were in the list that cleared in the month that I was reconciling (so that they'd show up on the transactions page and I could tick them off) from the "resolved' list to the "outstanding" list. I can't process the entry due to the unresolved amount... What do I do?? I've read a bit about resetting the bank rec, but since this is the first statement that I'm trying to reconcile in this module, I'm not sure if resetting would accomplish anything?

Much appreciated!!

  • 0

    Do you have a 'discrapancy' amount? Also when you first start the bank rec, do not enter the ending balance, look at the opening balance and verify that the 'unresolved' amount is the same as the beginning balance. The unresolved will be negative and the opening balance will be positive.

    Please post back.

  • 0 in reply to Smith and Co

    Thanks for the response! My discrepancy amount and unresolved amounts are the same,  one positive and one negative.

  • 0

    Artsaccountant said:
    ...in the add prior transactions page I only moved cheques that I knew still hadn't cleared and transactions that were in the list that cleared in the month that I was reconciling (so that they'd show up on the transactions page and I could tick them off)

    Let's say you are doing the bank rec for January (you didn't give us that information so I am going to use that as an example).  You did your December bank rec manually and you have a list of any entry that did not clear the bank in December.

    When you are adding Prior Outstanding entries, by definition you are adding to the list for your January bank rec, any entry that did not clear the bank that is dated PRIOR to the month you are reconciling.  From your quote above, it appears you have also added the amounts that cleared in the month you are reconciling.  This will probably cause the discrepancy, so if this is the case, go back to the Add Prior Outstanding screen and remove the amounts that have the dates in the month you are reconciling.  They will show up automatically.

  • 0 in reply to Richard S. Ridings

    Just looking at it now, the only transactions I've moved into the "outstanding" section are cheques that were posted last month and didn't clear the bank yet.  My discrepancy amount is positive and my unresolved amount is negative.

  • 0 in reply to Artsaccountant

    The discrepancy amount should be zero - you said you entered outstanding transactions from - for example - Dec/13 that hadn't cleared the bank yet as of Jan31/14. How about Nov? Compare the bank general ledger against the Nov/3 bank stmt to see if anything there that has not cleared the bank as of Jan31/14.

  • 0 in reply to Smith and Co

    Is your opening balance correct?