Positive Unresolved amount and Outstanding amount

SOLVED

I am working on my August Bank Rec.  After I have cleared all relevant entries I am left with an Unresolved amount or $14,435.88 and an Outstanding amount of $14,117.04.  My O/S amount should be -$318.84 a single chq which did not clear in August.  (14,117.04 - 14,435.88 = -318.84)

When I uncheck all items and change my ending balance to my start balance instead of a zero Unresolved it shows: Resolved 14,435.88  O/S 20,111.09  Unresolved 14,509.38  (my bank fees are -73.50) and Discrepancy is zero.  It appears I need to make some kind of an entry to move 14,435.88 from unresolved to resolved and that will solve most of my problem|

I made two timing errors. 1)  I reversed and reentered a July deposit of $31,500.00 and 2) I transferred a GST pymt of $348.84 from my chq acct to svgs acct where it had been incorrectly paid from by the bank after I had reconciled and processed the July Bank Rec.

This amount 14435.88 is not a single entry nor can i figure out what it represents.  The worksheet indicates to make an adjustment of 14,435.88 to the statement ending balance and the same amount to the book balance.  

When i originally printed the Account Rec w/ Outstanding detail report for july the book balance was $8301.78 and it should have been $8650.62  out 348.84.  After \i made those 2 timing errors and reprinted that same report my Book balance in that report is now correct, and it shows asteriks beside the 31,500. o/s deposit and 348.84 gst outstanding deposit and under the outstanding withdrawls the astrik beside the 31,500.  When i print the Acct Rec summary report it shows my Book Bal and Stmt end balance back at 8301.78

I have 2 seperate issues here and am trying to solve one at a time but most concerned with the Unresolved/Outstanding amounts.

Any thoughts or ideas would be greatly appreciated. Thanks Diane

  • 0
    Hi Did your July Bank Rec Balance? You should also be able to correct your timing errors by re-opening them and changing to the date you want. Then on your August Bank Rec you can go in and clear those adjustment in and out entries.
  • 0 in reply to Marj@Swab
    Yes July and every prior bank rec balances.
    The 31,500. was corrected. The only entry I do still need to corrrect the gst 384.88. I'm more focused on solving the Unresolved & Outstanding problem. My numbers all seem to balance and it's interesting that my Unresolved is out +14435.88 and my Outstanding is out -14435.88! They should just cancel themselves out.....It should be any easy fix!!
  • 0 in reply to Diverse
    But when you made the correction for July did you correct with a July date or an August Date? If you haven't, go back and double check your July ending balances now to see if it still balances. If you don't have anything left to reconcile in August and you still have those numbers(14435.88), something has gone wonky in a previous month.
  • 0 in reply to Marj@Swab

    31,500. dated July . the correction was cleared in and out in aug. Im out the 348.84 and can correct that. Ive gone back through all my bank recs and opening and closing bank acct balances and all is good (except that 348.84 in July). There is nothing left to reconcile. The unresolved remains 14435.88 and my outstanding is over stated by 14435.88! It doesn't make sense to me that it wants me to adjust the end book balance and the stmt end balance. As far as i'm concerned they're right. somewhere I need to make an entry in Aug. to resolve that 14435.88 Unresolved which would then clear my Oustanding to the correct amount of -318.84. without changing my ending balance!

  • 0 in reply to Diverse
    I think I'll try resetting the bank recs and starting fresh. They only go back to March of this year and I'm thoroughly perplexed at what else to do! Thanks for your input!
  • 0 in reply to Diverse
    Hi, I wonder if you do a journal entry for that amount using the bank account for both sides of the entry. That way you will have a debit and a credit for that amount on your Bank Reconciliation. Then when you clear them it should take those amounts out of there.
  • 0 in reply to Marj@Swab
    verified answer
    Update*** Resetting the Bank Recs was the fix!!!...dont know where or what the problem was but its balanced now!
    Thank you!
  • 0 in reply to Diverse
    I'm glad it worked for you. I have noticed sometimes things go a little strange if we had the power flicker and you happen to be in Sage 50 working on something. Resetting the Bank Recs is a lot of work, but it that is what fixes it then that's what we do. Have a wonderful day.