outstanding amount = unresolved amount

I have a problem with my bank rec.  My outstanding amount = unresolved amount.  On paper, my bank rec is fine to the penny.  I verified my statement opening and ending balance, they are fine.  The only amounts that are not ticked = my outstanding, same amount as my manual bank rec.  Discrepency = 0.  I have reset the bank rec and redid it, but I still have the same issue, outstanding = unresolved.  My GL ending balance + outstanding = statement end balance.  How can I get rid of this unresolved amount???

Parents
  • 0

    I am not 100% sure I am reading your question properly.

    Making the assumption that the current unchecked amounts are not on the statement and therefore will clear in a future bank statement, there are a couple of things to check (and I know you mentioned a couple of these in your question but I am including them for others reading as well).

    1. The Statement starting and ending balances should be what you see on the bank statement, not your book's G/L account.  I'm pretty sure you did this ok because of your statement about GL ending balance + outstanding.
    2. The Statement Start and End dates should be what is on the statement or a specific month.  eg. if the statement end date is always within a couple of days of the calendar month end, I always use the calendar month end because I can remember that for reporting better than the real statement end date.
    3. Are you putting the Statement End date in the Reconciliation Date field instead of the proper field so that you do not see all the outstanding entries?
    4. Are there any amounts on the bank statement that you have not yet checked off on the bank rec?
    5. Do you have the "Do not show corrections" check box checked?  If so, uncheck it so you can see all the corrections.  Sometimes half of the corrections are checked and one check might be missing.
    6. Do you use Deposit Slips?  If so, is everything that is part of a deposit checked?  You can Show Deposit Slip Details to see.
    7. Is there anything on the Income or Expense tabs that you have already posted as a journal entry and checked off?  This could be a double entry causing a difference in your totals.
    8. If the unresolved amount is positive then you are generally looking for a total that ends up on the Deposit side eg. $100 deposit and $30 expense left unchecked will result in a positive $70 unresolved amount.  And the reverse is true for negative numbers, you are then looking for mostly Withdrawals.

    Without being able to see the info firsthand, I am voting for either #5 or #7 as the problem, but these are only guesses but I did have a client recently have a similar issue and #3 was the answer (roughly 70% of all problems on reporting is date-related).  Hopefully you can find something above useful.

  • 0 in reply to Richard S. Ridings

    Thank you!  It balances now! Slight smile

  • 0 in reply to MHelie

    Just curious.  What was the answer?

Reply Children
No Data