Determine which vendors have a large range of payment values

Assignment Help Accounting Basics

Reference no: EM133906408

Problem

Highlands University's accounting department is doing an internal audit of vendor payments. They want to understand if there are any risks associated with vendor payments. A spreadsheet is provided, and it shows the payments by customers and which invoices have been paid. VendorID VendorName VendorAddress PaymentDate PaymentAmount 342322 OfficePlus Ltd 234 Main St... 2021-02-02 $15,110 342334 GlassWorkds Box 343, 35 Rob Ave... 2022-01-07 $25,200 N/A Painters Pros Box 334, 9 State St... 2022-03-14 $76,000 342522 Custom Signs 553 Franklin Ave... 2022-03-16 $76,900 N/A INV204345 3043 Broadway Ave.. 2022-03-14 $76,000 ... ... ... ... ... If the descriptive question is "Which vendors should be investigated for potential fraud?", what analysis can be used to answer this question? Determine which vendors have a large range of payment values. Get the instant assignment help. Determine the total payments to vendors that have a vendor id setup. Determine which vendors have high percentage changes in total payments compared to the previous year. Identify vendors that don't have a valid vendor id and count of vendors who have an address that matches an employee address.

Reference no: EM133906408

Questions Cloud

What was disney first venture overseas : What was Disney's first venture overseas? What mistakes did they make? What did they learn?

Prepare the companys flexible budget for july : Alyeski Tours operates day tours of coastal glaciers in Alaska on its tour boat the Blue Glacier. Prepare the company's flexible budget for July.

Describe should look for in a small business attorney : Describe the characteristics you should look for in a small business attorney. How would you find such a lawyer? Please explain in detail!

What is the hunters total federal income tax withholding : Review this taxpayer's scenario information Intake/Interview Sheet and other tax forms in Publication. What is the Hunters total federal income tax withholding?

Determine which vendors have a large range of payment values : Determine which vendors have a large range of payment values. Determine the total payments to vendors that have a vendor id setup.

Describe the various types and levels of workforce : Describe the various types and levels of "workforce" and required skill set for each level of workforce within an organization?

Prepare the worksheet consolidation entry or entries needed : Prepare the worksheet consolidation entry or entries needed at December 31, 20X5, to remove the effects of the intercompany sale.

Why erp system requires an implementation methodology : Why ERP system requires an Implementation Methodology? Which methodology serves as base for ERP System Implementations, Delineate?

Prepare the companys planning budget for august : The company expects to wash 9,000 cars in August and to collect an average of $4.90 per car washed. Prepare the company's planning budget for August.

User Account

All Pages