Hi Andrew,
I tried to get the bank balance as at a date using the Calc As Of function but for prior periods, it still only gives me the balance as of the last reconciled date. We have reconciled to Jan09 and that is the balance that is returned for any dates entered prior to then. I can get current balances for the unreconciled periods, but for any reconciled periods all it returns is the last reconciled balance. Is this the intent of this function?

I appreciate all the assistance you have given me; unfortunately it seems I may have to re-reconcile the account manually and then adjust BR and GL to match.