Asset clearing to General ledger reconciliation

Summary:

Currently we are having issues to reconcile the historical transactions on the asset clearing accounts (every account in the ledger which has either the text string ‘system clearing’ or the text string ‘system cost’ in the account description) which net off against each other (which debits (coded to the asset clearing accounts, normally through accounts payable) match off against which credits (usually loaded to a live asset account through a ‘mass additions’ form)).

Second question is : We generate detailed trial balance to reconcile asset clearing account to asset accounts as a balance check process but there's large element of opening balance journals cannot be matched based on journal description /segmental account code / project code , is there any means that a detailed journal listing can be generated without the option of using Manage Journal option , as this only gives one line transaction and not detailed breakdown of the balance. Any assistance is much appreciated.