1st bank rec since rebuilding data using accountant's year end figures

I have done and redone bank recs numerous times, and have always been able to figure it out when the discrepancy and unresolved argue with you.  But I am stumped this time.

I have rebuilt a company after they lost all data due to a computer crash, and they had never EVER backed up.  I used the accountant's year end statement from the past fiscal year to start the posting.  I didn't use history module at all.  Then posted everything for the next year.  When I started the bank rec, I  added all the outstanding chqs together, added that figure to the bank's statement starting balance to get my starting balance for the bank rec.

Now when I am trying to do the bank rec. I am getting the discrepancy and the unresolved exactly the same as the amount of the outstanding chqs and statement starting balance, (one minus, one plus).   Is the reason this is happening due to using the accountants year end figures for the bank account, and the outstanding chqs would be part of it, that balance. If so, that means I need to make an adjusting entry?   And if so, what do I debit  to balance out the outstanding chqs. 

Thanks for any help.

 

  • 0

    Hi Emaure56,

    I guess you have already read this KB article but I still post it here for you as a reference:

    Discrepancy and Unresolved are even. One is a positive and one is a negative  KB-10037

    If you follow step 3, you will be able to put your discrepancy back to zero since this is your first bank recconciliation after rebuild.

    For the unresolved, if you post it, it will post to the unresolved amount account and it is usually an expense account in the 5000 level  If you do not have it, you can create it in the Chart of Accounts.  For your information, if the unresolved is negative, it will credit your bank acocunt.  If it is positive, it will debit your bank account.  The logic is the same as posting an adjusting entry by your own.

    I understand you have already tried it very hard to figure out what is the unresolved, but suggestion is still try to figure what causes the unresolved amount beased on the formula below:

    Unresolved = (statement end balance + ending outstanding) - ending book balance.

    The bank statement should always be correct, so you may need to pay more attention to the ending outstanding amount and book balance.  The article below will give your more direction.  You can look at step 3 first.

    My bank reconciliation has a discrepancy and/or an unresolved amount.  KB-10237

    Hope this helps.

     

     

     

  • 0 in reply to Keith L

    I had already gone through all those steps, but thanks again for the link.  I have it saved at every desk I work at!    

    My thinking is, the outstanding chqs and the starting balance are already included in the accountants year end bank balance.  So when I post the outstanding chqs in the window for outstanding chqs, and then add the amount to the starting bank statement balance to get my opening balance for the bank rec in simply, those amounts were already included in the accountant's year end bank balance,  so I am putting it in twice.  

    I think I need to do the above, but make an adjusting entry to the bank account and to retained earnings. to make the accountants year end starting balance that I used, to be minus the outstanding chqs and starting bank balance to offset having outstanding chqs showing in the rec.

    ?????