Session Date and Bank Reconcilliation Reset

SOLVED

My last Bank reconcilliation was saved in July. I realized in August when I went to do that rec that i had inadvertently posted 2 July entries after the fact so my Aug bank rec is out.  I believe I need to reset the bank rec. My question is do I need to  change my session date to July before I reset? and will it just reset that one bank rec or will it clear all preceding recs?  Thanks!

  • 0
    It sounds like you think that your July bank rec is out, not Aug.

    Do you really need to reset? Have you tried printing the Account Reconciliation Report Summary with Outstanding Transactions? It should show the two added entries flagged and it should still match the balances of the accounts and still be reconciled, assuming neither of the two new entries actually hit the bank statement in July.

    To answer your specific questions, no you don't need to move the session date back and yes resetting the bank rec module resets the bank rec module for that particular account back to nothing. It does delete everything and every month of reconciliation actually done back to the beginning of doing bank recs in the program for that particular account.

    If you have two bank accounts eg. 1060 and 1080, and you reset the bank rec on account 1060, nothing has changed for account 1080.

    Also, when I say it deletes everything, I am only referring to the everything in the bank rec module. The original journal/ledger entries at affect the bank account still exist and can be used to set it up again, if you do choose to reset.
  • 0 in reply to Richard S. Ridings
    Hi Richard, thanks for your response. No it's my August bank rec that has a negative unresolved amount which I believe is due to my posting 2 July transactions after I had reconciled July. I was thinking I need to reset July so those amounts didnt show up in aug.
  • 0 in reply to Diverse
    and yes both entires were in the July stmt
  • 0 in reply to Diverse
    I think I am misunderstanding somewhere but I assumed when you said you "My last Bank reconciliation was saved in July", you meant that July's statement was fully reconciled and posted in the books.

    If so and you posted the two July entries after the July bank rec was completed, and those two entries were on the July statement, how could you reconcile July properly if the entries were not posted until after you finished the July bank rec?

    Did you allow the program to post an entry to balance July and then you posted the real entries to the bank when you found them, instead of the expense account used to balance the bank account?

    Are you sure you are not just dealing with adjusting entries where one side is not checked? Make sure you show the corrections so you can see everything (checkbox at the top of the columns).

    Having a negative unresolved does mean that there is some withdrawal not cleared yet or some deposit has been included but should not be.
  • 0 in reply to Richard S. Ridings

    Yes July was fully reconciled and posted to the books so July balanced. In August i did an adjusting entry to a July deposit of $31,500.(correcting the transaction date in July-should have let it be!!) When I go to the Aug rec- have all the entries set to o/s and make my end balance the same as my start balance my resolved shows -14,435.88 instead of zero so it makes sense i have this neg unresolved in Aug of -14,435.88 after i clear all my entries...I can't quit figure out this amount yet.... clearly I have other issues going on. I'm trying to make sense of this # first. I appreciate your help... i think i need to study this further

  • 0 in reply to Diverse
    You didn't mention whether you have all the corrections showing or not. As I said, you might be dealing with a correction that does not have both sides cleared properly. If you have not shown yourself all the corrections, you may not see that the reversal of the original July entry is marked as cleared and the final entry is still showing as outstanding.

    Of course, if you forced all the entries to show as outstanding, then you may have caused the problem to begin with because all corrected entries are marked as cleared automatically. If you unchecked one, then this is part of the problem. However, it is possible only the one side is marked by default when you are adjusting an entry that was already cleared. I don't recall ever doing it so I don't really know the program will handle it.

    Show all the corrections and sort by date and see what shows up then. The July entries should then show at or near the top.
  • 0 in reply to Richard S. Ridings

    yes I have all corrections showing. the July "correcting " entry shows at the top and is cleared when I clear the offsetting entry the amount out is reduced to the 14,435.88 otherwise it's out 45,935.88

  • 0 in reply to Diverse

    sorry Richard when i complete my Aug Rec what I have is a "positive" unresolved amount of 14,435.88 and outstanding 14,117.04. My correct outstanding should be -318.84 

  • 0 in reply to Diverse
    verified answer
    Then there has to be some other amount checked off or else it would not be resolved.

    If all corrections have both sides checked off and the opening and closing balances are the same, then both Resolved and Unresolved should be zero.

    All this time you have not mentioned Discrepancy. Because of this I have assumed it is zero as it should be, is it?

    I've also been unclear on exactly what the entries are because you have not actually given us them, but was one that you posted back into July for $14,435.88 and the other for $31,500? And then you adjusted the latter entry and changed the date and all this after you posted the July reconciliation?

    You have not also followed up with how July was reconciled with those two entries completely missing even though they showed on the bank statement.
  • 0 in reply to Richard S. Ridings
    Sorry Diverse, I didn't see your post from 3:04 pm before I posted. Either you cleared too many withdrawals or you still have to clear the Deposit side of an adjusting entry from the previous month.

    I think at this point, without seeing the data entry screen and the answers to the other questions in my last post, I might not be able to help much further. If someone else has an idea of something I am missing, please jump in.
  • 0 in reply to Richard S. Ridings
    with both sides checked off and opening and closing bal are the same my resolved is -14,435.88 and unresolved is 14,509.38
    discrepancy = 0.00
    the 14,435.88 is not an entry i posted
    the 31,500. deposit was entered in july and was on the july stmt...it was not missing. the bank reconciled
  • 0 in reply to Diverse
    one other thought....my statement end date and reconciliation dates are Aug 31, 2016 but my statement start date says July 31st. Should it not be August 1st ?
  • 0 in reply to Diverse
    verified answer
    Just another thought, have you check your data integrity recently? Goto "Maintenance", "Check Data Integrity" (must be in single user mode do do this)
  • 0 in reply to Ginkgo Bike
    yes data is ok, thanks
  • 0 in reply to Diverse
    Update* I reset my Bank Recs and that fixed my unresolved/outstanding problem. Thanks for your input!!