Transaction analysis in FORENSIC AUDIT
Problem
Transaction analysis and grouping of transaction along with red signals analysis
Prompt Input
Assume you are forensic auditor. One of the person has executed so many number of transactions from his bank account by way of cash deposits, cash withdrawals, Transfer to other parties which also includes related party accounts including his inter bank transactions. By analyzing the bank statement provided I suggest to analyse the data you should provide me data in grouping like cash deposited, cash withdrawal, Transaction with same person or same firm and any other transactions of like nature. And provide me data in excel sheet in tabular form. You are also suppose to analyse red flag transactions covering into Account. The transactions which require further investigations and also the suspicious transactions are need to be identified and reported separately.
Prompt Output
Group Data into tables along with red signals, like from where cash withdrawals done, to the extent when (time) and also place (where) and also warning signals like related party transactions.