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