I am looking to have items identified as follows:

If it is an AR transactions to show that it came from the AR module and would include the Customer number, Name, Reference of invoice Number/Credit note etc..., also include any field that allows a comment, amount posted to the GL and transactions date.

I also would need this to be the same for the AP side.

For doing data analysis and reporting it is much easier to have this information in excel and build the reports from there.