Final Project

Cardinal Wholesalers 3

We first had to find fraudulent vendors by simply examining Cardinal Wholesaler’s vendor database. The vendor's number was so large, and we were opted to use computers as the alternative of inspection instead of manual invoice and bank statements inquiries. The auto-filter function found in Excel was an essential aspect that we significantly used to conduct a comprehensive review of the vendor's invoices and bank statements. Auto filter function was critical to this case since it will generate all the vendors more quickly and efficiently on stared conducting manual invoices and bank statement inspections. Inspecting 1000 vendors is a very tedious work, and hence there was a need to use Excel Auto Filter Function for this case scenario since the function have the capability of generating all the reports regarding vendors with fraud cases. Excel Auto Filter Function is a useful aspect in this auditing process we are undertaking.

When we use Excel Auto filter function and feed it with credential information regarding all the 1000 vendors under the auditing process such as Taxpayer ID, Address, and phone number in their respect vendors data fields. Excel Auto Filter Function will generate all information regarding vendors with suspicious and unethical behaviors that can be accorded to be a fraud. The Excel Auto filter Function have been programmed in such a way it will generate vendors with suspicious characteristics that were grouped according to suspicious characteristics that individual fraudster vendor is found to be possessing. The Excel Auto Filter Function will generate all vendors with no suspicious characteristics, vendors with one suspicious characteristic, those vendors with three suspicious characteristics, and finally, the Excel Auto Filter Function will generate all vendors with two suspicious characteristics. Auto Filter Function will generate all suspicious vendors with some suspicious characteristics such as a vendor having a phone number in the invoice and no phone number in the bank statement. Suspicious vendors characteristics reviews that an individual vendor is uninvolving in unethical behaviors and captions, which Amy be considered to be a fraud.

Three essential filled regarding individual vendors such as taxpayers' ID, their address, and telephone numbers were fed into the Excel Auto Filter Function for auditing and fraud inspection. After the Auto Filter Function from Excel comprehensively examined and uninspected all the credential information from invoices and bank statements, the system generated that six vendors had the most suspicious characteristics, and hence, we concluded that all the six of the vendors might be involved in unethical fraud actions. From the Auto Filter System, we found that no vendor who had all the three suspicious characteristics, but there were six of the vendors who had possessed two of the three irregular features. From the Auto Filter Function, we realized that most of the vendors had only one irregular feature.

The first suspicious vendor that was posing two of the suspicious characteristics was The Connection. This particular vendor had missing data in the field of taxpayer ID, and the telephone number was missing. When an individual vendor possesses these two characteristics, its believed that the vendor have involved in unethical and fraud actions, the second suspicious vendor that may be accorded to participate in questionable activities and fraud is PC ONE; this particular vendor had missing PO BOX for his address and a lost phone number. The disappeared phone number reviews that the vendor may not be into existence. That is, the vendor is not real. Another justification that shows that PC ONE vendor is not real and has no physical existence is that the vendor just provided the PO BOX address rather than a physical IP address that is a requirement. The thirst vendor who was found to poses suspicious characteristics is S & B Foods, Inc. This particular vendor was found to be lacking a phone number, and the vendor, too, had no valid taxpayers' ID. From the characteristics passed by this particular vendor shows that lack of phone numbers the particular vendor does not physically exist and also the vendor had an invalid taxpayer address and hence this is a clear indication that that particular vendor is not real and hence there’s no proof that this particular vendor physically exists.

The fourth vendor who was found to be posing suspicious characteristics that justifies that this particular vendor have involved in fraud activities is the Stamen Floral Distributors. This specific vendor had suspicious symptoms such as lack of a phone number indicates that this specific vendor is not real and also another suspicious feature passed by this particular vendor is that the vendors PO BOX had been listed as the address this shows that this vendor is not real and hence fraud activities have been carried out using this vendor's particular name. The fifth suspicious vendor who may be accorded to be have been involving in suspicious activities is Freshen Beverages. This specific vendor had PO BOX listed as his primary address, and still, this particular vendor had an invalid taxpayers' ID number. This shows that this particular vendor have been engaging in various fraud-related activities, and hence, it the reason the vendor-provided the wrong credential regarding taxpayer ID number and incorrect IP address. Finally, the sixth vendor who have suspicious characteristics is the Tri-State-Trucking. This particular vendor had similar irregular features like those posed by Freshen Beverages. Tri-State-Trucking vendor had PO BOX indicated as the primary address, and the vendor still had listed an invalid taxpayers' ID number. These characteristics posed by this particular vendor show that the vendor does not support physically exist, no legitimacy existence of the specific company, and the vendor's names have been used to carry out various fraud-related activities that can be considered to be unethical. Suspicious characteristics of different vendors show that various unethical and fraud activities have been continually being administered. Lack of real phone numbers and taxpayer ID numbers shows that the existence of a particular vendor is questionable, and no follow-up detail can be used to follow that specific vendor involving in fraud-related activities.

Assignment 4

For this particular part, we are going to generate red flags, which are indicators that some various vendors amongst the 1000 vendors under review and inspection participated in fraud-related activities. From this sector, we are going to inspect the fraud, which will be indicated as a red flag for various vendors by simply inputting data and credentials related to multiple vendors. Red flag indicators we show various vendors who may have red flag indication from the invoices and database. Invoices and database data significantly help us toy determine various vendors who may have questionable actions as Excel Auto Filter Function will review it.

Excel Auto Filter Function Is an essential tool when it comes to matters concerning auditing send fraud detection. After feeding, the system will various data related to vendors with distinct and suspicious characteristics. We will have to do a comprehensive review and inspection of multiple vendors invoices so as we can be able to determine various vendors with suspicious symptoms. For example, a vendor may be flagged and be generated by ghee Auto Filter Function when the vendor may be having a phone number in the database and no phone number when it comes to the invoice data.

One of the suspicious vendors that are displaying shady characters is the Connection this vendor have no telephone number and a taxpayer ID, but, ironically, this particular vendor has a taxpayer in the invoice. This is a clear indication that this specific vendor involves unethical actions and fraud since his suspicious characters are not questionable. It’s not logic that Connection Vendor does not have a taxpayer ID in the prior, but the vendor accidentally have a taxpayer ID listed in the invoice. The second suspicious vendor is PC ONE. This particular vendor had no phone number, and the vendor hade provided an invalid address, but its unlock that this specific vendor have a phone number indicated in the database. This is analogical in the prior the vendor hade not phone number, but in the database, we can locate the phone number of this particular vendor. This generates confusion and dilemma of how this income to happen. This is unethical and is just that this specific vendor have been engaging in various fraud-related activities. The phone number of PC ONE has also been indicated in the invoice. This is suspicious, and hence, it clear that this particular vendor have been engaging in various questionable activities and fraud. The third vendor with a shady character is S & B Foods, Inc. this specific vendor did not have a valid taxpayer ID and did not have a phone number but after doing a comprehensive inspection using the Excel Auto Filter Function will found that this particular vendor taxpayer ID number existed in the database and also the phone number of this vendor have been indicated in the invoice. It's clear justification, yet any vendor that lacks sufficient credentials means that the vendor is not legit, and various suspicious activities have been carried out using this vendor's particular name.

The fourth vendor that we found to be having suspicious characters is Stamen Floral Distributor. This vendor had not indicated his phone number and had not stated his PIP address, but instead, he had stated the PO BOX, but after running an examination in the Excel Auto Filter Function, we found that the phone number of this particular vendor was present in the database and it was listed in the invoice. The address of this vendor was also current in the database; this raises hypothetical questions that this vendor is engaging in malicious and illegal activities that can be considered to be a fraud. The firth vendor that indicated to be possessing suspicious character is the Freshen Beverages. This vendor prior had no valid tax pears ID number, but the vendor's taxpayers ID present in the invoice, and the accurate vendor's address is current in the databases. Finally, the sixth vendor we food to be possessing suspicious character is the Tri-State- Trucking, the vendor prior had no valid taxpayer ID and no physical address, but its unlock that all these credentials are present and well listed in the vendor's invoice and present in the database. These suspicious characteristics from various vendors indicate that fraud-related activities have continually been initiated. Fraud is unethical.

References

Dellaportas, S. (2013). Conversations with inmate accountants: Motivation, opportunity, and the fraud triangle. Accounting fórum, 37(1), 29-39.

Greenberg, J. (2017). A social influence model of employee theft: Beyond the fraud triangle. McGraw-Hill.