The bank rec reports were never printed when the reconciliations were done for the last few months. These reports were used to match the bank balance in Bank Rec to the bank balance in GL and also to review outstanding items. I have tried to run the reconciliation report for a prior period but the system will only return the balance as of the last reconciled date (which was Jan 2009). The bank balance per bank rec does not match the bank balance per GL and I am trying to determine how far back this problem goes. The last printed report I have is for July which indicates the two were balanced at that time. What is the best way for me to obtain and compare the Bank Rec balance to the GL for each month since July as I cannot print the reconciliation reports for periods prior to Jan 2009.

Related to this, how can I print a complete transaction listing of everything posted through Bank Rec? The report options only seem to give me cleared historical items or outstanding items as of the last reconciled date (Jan09). if I need to do a detailed reconciliation of bank rec data to GL data, which is looking probable, am I best off running a historical report to Jan 31/09 and adding to it the outstanding items as of that date to try to recreate the entire list of data that has been entered since we started using Bank Rec (March 08)?

Any help would be VERY much appreciated.

Thanks,
Tanja