Hi Steve,

Sorry but I wasn't trying to be obtuse. I see now that you want to filter the list before it's sent to excel?

At the risk of morphing this discussion into something else, and please factor in that we don't use the bank rec module....

Is there any way in payables when viewing the check reconciliation screen that we can get only the outstanding cheques listed? Since we can't change the status of anything that is already cleared, reversed or voided, is it necessary to see them?

Whether clearing, reversing, or voiding the cheques, or exporting the information to excel in any manner that's been discussed above, life would be simplified if we didn't have to see every cheque ever written. (My current cheque series dates back to April 2011 and involves almost 6000 cheques, which all get displayed). I realize that by setting the report parameters to cherry pick the most recent cheques I need, I eliminate all the old stuff that has been cleared, voided or reversed. By utilizing the excel direct button on the check reconciliation screen, every cheque still gets exported rather than the outstanding ones I assume most of us really need to deal with.

Hi Marc,

Print the Check Reconciliation Listing report with all statuses selected - maybe to PDF to save paper. You will then be asked if you want to purge all checks that are not outstanding - ie cleared, reversed, etc.

And they say you can't teach an old dog new tricks.
I'll have to go home now, 'cause I've learned my new thing for the day ;-)
Thanks - never new that one.

Hi again
Here's my improvement to payables suggestion;

Can the option to "clear all checks that are not outstanding" not made available when (or perhaps if) we print off the outstanding checks list (either before or after posting the changes in status)?
(And without having to select all statuses first.)

It would clean things up without essentially having to consciously print the checks (and include all the statuses) listing a second time.

Dear Softrak

I think you know there is a lot of room for improvement in this functionality (and that's before we get to reversing checks). As you can infer from this discussion, a good start would be to allow filters so that you don't have to preview and export a check reconciliation report to easily produce an outstanding check list in Excel.

Steve

This thread is getting off topic. Please post comments about the AP Check Reconciliation process on a different thread. Thank you.