I have a client whose A/P subledger is way out from the G/L control account. There are no o/s batches to retrieve from A/P and everything is posted. They could have done numerous things to throw out the balance but my question is......

Is there any kind of utility program that can be run to identify the transactions that are not in the G/L but in A/P and vice versa without going back a forth between the 2 detailed printouts (60 pages) and crossing out identical transactions?

This is a much easier task given a tool like GridView.

Find out when they got out of synch if you can.

Make sure all the transactions in the control account came from AP by filtering them for the source code AP. In Ledger you can create a custom Source Journal to list just those transactions that don't have AP as the source. You can also use the transaction drill down in the financial reporter to get the details into Excel (or the ExcelDirect button on the transaction inquiry in Ledger V9.0B).

This might quickly and easily point to the problem.

I wrote a whole checklist for reconciling A/R subledger to G/L. It's totally applicable to reconciling A/P to G/L.

See this thread - http://www.softrak.com/ubbthreads/ubbthr...=true#Post16207

Steve