Clearing adjustment entries on reconciliation reports

On my bank and visa reconciliations there are some adjustments listed in the outstanding deposits and withdrawals columns which cancel each other out.  The accountant would like me clear all of these corresponding entries to clean up the bank and visa recs. How do I do that?

I have experimented with entering the same start and end date (eg. Oct 1) with a statement end balance that takes the Unresolved to zero (and carries forward the same and therefore, correct opening balance), then posting. The next start date then becomes Oct 2. (After messing with it, I restore from backup so I don't irrevocably make a mess). I am concerned that I may lose some entries this way. Is that possible? What is a better way to clean up the many adjusting entries I inevitably have (ie. Reversing J111. Correction is J112) so they don't appear on the report?

Thanks,

Karen

  •  Hi there:  Can you just check the box that says    "Do not show corrections"?   Or will that screw up the bank rec?  What about checking each of the entries as "cleared" since they match up and should be able to be checked off instead of left as outstanding.    I rarely bother to use the Simply Bank Rec in the system so not really sure.   Can't advise on the Visa Reconciliation as I have never used the Simply system to reconcile that either.   Rita Deering

  • Thanks for your input. I can check the "Do not show corrections" box but it doesn't affect the reports, ie. the adjusting entries still show in the reports and that's what the accountant wants cleaned up. Any other ideas?

    Karen

  •  As Rita mentioned, could you not check off the entries as cleared in the bank reconciliation since they zero each other out?

  • I check items off as cleared, but the problem is that all the adjusting/correcting entries still show up on Simply's "Account Reconciliation Report," ie. the Source column has eg. ADJCash or ADJ2074 (cheque #); the Comment column has eg. "Reversing J264. Correction is J491; the Status column has Adjustment, Reversed, Cleared or Outstanding. It's the Adjustment and Reversed entries that cancel each other out that I would like to take out of the report.

    Karen

     

  •  You can try going into your Account Reconciliation Transaction Detail report.  There you will have option to either select or de-select transaction to report.  Try unclicking the boxes for adjustments and reversals.  That the only thing I can suggest you try. 

More Content