Question

In: Accounting

What kind of fraud schemes can I detect from the tests below? 1) Appending a field...

What kind of fraud schemes can I detect from the tests below?

1) Appending a field

2) Benford's Law

3) Direct Extraction

4) Duplicate Key Detection

5) Duplicate Key Exclusion

6) Gap Detection

7) Stratification

8) Summarization

9) Supplier Verification

Solutions

Expert Solution

1) Appending a field can detect payroll fraud. It involves ghost payrolling.

2)Benford’s Law are highly effective in finding inconsistent data and anomalies. This Law states that digits and digit sequences in a dataset follow a predictable pattern. It can identify possible errors, potential fraud and other irregularities on applying to a digital analysis.

3) Direct Extraction can be used in user-defined criteria to isolate paychecks that did not have taxes withheld, or analyze addresses to help uncover ghost employee schemes.By cross matching a list of existing employees with payroll records, payroll errors can be found out.

4) Duplicate key detection can be used to find records with or without duplicates in one field or up to eight fields.

5) Duplicate key exclusion helps in identifying duplicate items within a database, or gaps in dates, numeric or alphanumeric sequences. In addition, to extract payments with missing invoice numbers or approval IDs, simple equations can be written with its help. It helps to detect extra payments made of invalid invoice.

6) Gap detection can detect accounts receivable fraud.

7)Stratification can be performed with the help of number, character or date to total the number and value of records within each range in order to identify and review activities just under a group, just before the closing period or after it. It helps to look for transactions posted on weekends, or before or after normal work hours. It can detect fraudulent transactions.

8)Summarization involves accumulating the values of numeric fields for each unique key, such as supplier name, part number, location ID, or approver ID. Summarization of an accounts payable database by account number (the key) and totalling invoice amounts produces a database of outstanding liabilities by supplier. It can detect Accounts payable fraud.

9)Supplier verification helps to detect vendor fraud in which the fraudster manipulates a company’s accounts payable and payment systems for illegal personal monetary gain.


Related Solutions

What is Benford's Law and how can it be applied to detect financial statement fraud?
What is Benford's Law and how can it be applied to detect financial statement fraud?
1. List some controls that reduce fraud risks. 2. Explain how you can detect fraud
  1. List some controls that reduce fraud risks. 2. Explain how you can detect fraud.
What does it mean for a lake to be stratified? What kind of tests can be...
What does it mean for a lake to be stratified? What kind of tests can be done to show whether a lake is or is not stratified? Please explain in detail.
1-what tests can be used to detect Listeria monocytogenes? 2- ?Treatment – common resistances and alternative...
1-what tests can be used to detect Listeria monocytogenes? 2- ?Treatment – common resistances and alternative treatments – mechanism of action? for L. monocytogenes?
1) FRAP...what can we detect from this and why is it important? 2) What is the...
1) FRAP...what can we detect from this and why is it important? 2) What is the importance of transmembrane proteins?
PLEASE NO HANDWRITTEN OR COPIED ANSWERS What is the medium timeframe for detection of fraud schemes?
PLEASE NO HANDWRITTEN OR COPIED ANSWERS What is the medium timeframe for detection of fraud schemes?
State What Kind of Fraud Is One of The Occurrence of Revenue?
State What Kind of Fraud Is One of The Occurrence of Revenue?
What are the rules regarding an auditor's responsibility to detect fraud? In what situations could the...
What are the rules regarding an auditor's responsibility to detect fraud? In what situations could the auditor be liable?
According to Marsha Bertrand’s book “Fraud!: How to Protect Yourself from Schemes, Scams, and Swindles”, the...
According to Marsha Bertrand’s book “Fraud!: How to Protect Yourself from Schemes, Scams, and Swindles”, the most common hook in franchise fraud is earnings misrepresentation. In the early 1990s, Tower Cleaning Systems, a commercial cleaning franchisor, promised potential franchisees that they'd have revenues normally distributed with a mean of $9,500 and a standard deviation $1200 per month. The company, however, provided no documentation to back that up. You, as a forensic accountant, wanted to justify this claim and collected some...
Why is Benfords Law applicable to fraud detection? What kind of statistic concepts ( from Chapter...
Why is Benfords Law applicable to fraud detection? What kind of statistic concepts ( from Chapter 2 ) are utilized in this case?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT