We had an employee commit fraud. We will call the employee DON for our conversation. Date has to be presentable so we can explain to the local law enforcement
You will Analyze employee bank statement from Jul 2016 to Dec 31 2018
All data to be given date wise.
I need this data in 4 days as we have a court hearing
Deliverable will be
1) Money were sent to employees account from company bank account on DONs approval and the same amount or partial amount of money was routed back to DONs account. Give a break down of this data. You will notice the amount was routed back to Dons account same day or next day and was usually the exact amount as sent from company to employee account.
2) Total incoming money DONs bank account from other sources that we cannot track.( besides from our company) . Date wise
3) Total money sent to Don bank account from company bank account ( minus his salary). Date wise. Company name is always present in last row of Don bank account. Company name will be given later
4) Total ATM withdrawls date wise. You will find this data easily in excel as it is listed as ATM withdrawl in C column
5) Bank accounts where money was sent regularly. Don was transferring money to his family members. You can find names of such people in C column in excel. Date to be given date wise
Don was very good at keeping records as to who is sending money to or who it was coming from and you can find most of the data in the C column of Don account.
Company bank details will be given later and are in excel as well and easily searchable