LOGO
Process Area Process Sub Area
NONAME CONSULTANTS
Accounts Payable Vendor Master File Checklist Customized? YES NO Process Ref. If “YES”, Approved by AP/01/01
Name of Client:
Assignment:
Job No:
Introduction
This checklist shall outline the controls necessary for the creation and maintenance of vendor information in a VMF in a typical ERP environment. This may be applicable for most accounting systems which we generally experience during our audits and similar assignments. The applicability of these controls generally directly depends on the magnitude of the business (size of the operations) which we are reviewing. Always consult your senior, supervisor or your assistant manager before applying all the controls
…show more content…
This is done to check the reliability of the Access Control Matrix you would have obtained. Check the availability of a defined policy. If a defined policy is available check the adequacy of controls in place by referring to the controls matrixes above. Obtain a list of vendors (vendor listing) from IT, sorted by date created. Use the conditional formatting excel tool to identify obvious duplicates. Run through the list to identify further duplications. This checking will take only half a day (maximum). Select a sample based on creation date. Check the Vendor Creation Form corresponding to the name. Identify delays between the approved date of the Vendor Creation Form and the actual creation date. Check the completeness of information both in the VMF and the form. Verify with attached supporting documents such invoices, quotation letters etc. Do the same for any recent amendments to the Vendor Database. Check whether all Vendor Creation/Editing Forms are approved by the relevant authorizing officers. Go through the whole file: pertaining to your scope (and not the sample you selected above). This checking will not take more than 30 minutes. Similarly, obtain a file with forms requesting deactivation of vendors. Check whether those vendors have been duly deactivated in the VMF. Try to pass a dummy payment entry (such as booking an invoice). Check for any undue delays in deactivation.
Recommended Sample Size
Describe how to complete and maintain documentation in accordance with organisational procedures, in relation to:
SMW’s current accounting information system is a cutting edge relational database system through Microsoft Access with internal controls set to adequately prevent and detect errors and fraud. This relational database system tracks sales orders, shipments, accounts receivable, cash receipts, purchases, accounts payable, cash disbursements, inventory levels and other relevant accounting information. The system’s output is compliant with Generally Accepted Accounting Principles (GAAP). The database processes currently in use at SMW are described below.
* Documents used: customer order, sales order, shipping document, sales invoice, sales journal, remittance advice, bank deposit list, cash receipts jornal, credit memo, sales return and allowance journal, uncollectable account authorization form, a/r master file, a/r trail balance, monthly statement
8. REQUIRED TO TURN IN (in this order): Typed multi-step income statement, Typed statement of retained earnings, Typed classified balance sheet, Typed Perpetual Inventory cards, Handwritten worksheet for uncollectible accounts expense calculations, and Handwritten June Journal Entries, the additional adjusting entries and all necessary closing entries. Be sure your name is on all pages.
As in any other investment, the upgrade of the “bookkeeping” system in the Books’R’Us scenario will be associate with concerns about cost, return of investment, security, workforce accessibility and limitations, complexity of the project. Overall issues that may arise during the implementation phase, such as roles and responsibilities, execution times, maintenance of the system and turnaround in efficiency that will create profit for the company are key responsibilities for any designer. With that in mind a few very important questions that we need to ask before we jump into the design phase are security level desired by the owners and what is the security clearance that each employee will have, what complexity level the owners would be comfortable with and what design will be easy for them to maintain and navigate more efficiently. As the design begins, the owners would greatly benefit by assisting in a quick interview about the database layout and the breaking down of the logical units, what they consider priority data and need to access multiple times a day.
Kudler Fine Food has expanded business and updated their computer systems to meet demands. As IT information is adopted within the organization, automation control processes has become more virtualized. To ensure that Kudler’s computerize systems function properly an audit must be performed on an annual basis. Management at Kudler Fine Foods wants to see the proposed audit schedules for all systems. Management wants to know the types of audit and how they will be conducted. In addition, management would like to know about events that might prevent reliance on auditing through the computer.
An initial evaluation of accounting and inventory systems for all the Riordan Enterprise locations is required. We need to know what software is currently in use and how effective it is. If our evaluation determines that, the existing software is not performing all of the needed requirements it will be necessary to upgrade them as well. Next, we will need to evaluate their existing hardware to determine its integrity. If the hardware is also outdated, another evaluation will be necessary to determine what will replace it. If the evaluation of the hardware determines that the existing equipment is adequate, then we can proceed with the software upgrade. The request specifically asks for a complete system that is faster and interrelated into all of the locations. After the evaluations are complete a list of additional hardware will be generated and a timeline of what to be installed / upgraded where.
Accounts Payable Module. The AP module allows for the check disbursement portion of the business to be done electronically. This module holds vendor data, tax and freight data, and accepts data from other modules that directly affect purchasing (Accounting System Overview, 2011).
I shall need the check lists by Friday. The ones I supplied are on the PBX computer. Warda type them. As we discussed. please update and let me have them approved so I can send a copy to Pat Finan.
A key aspect of company success is the ability to track, audit, and report accounting data. This will allow Riordan Manufacturing to maintain fiscal health and make informed decisions regarding expansion. Evaluating accounting software is based on what functions the company will use, and ensure that our company gets the maximum return on the investment. The next section will summarize a few accounting software suites that will provide the needed functions that Riordan Manufacturing will use during the day to day workflow.
Note: All information MUST be completed, and signatures are mandatory before consideration will be given to the manual check request. Please include check distribution method including phone number and/or address of contact person.
The system/application domain consists of mission-critical systems, applications, and data. Common targeted systems and applications are operating systems (desktop, server, and network), e-mail applications and servers, Enterprise Resource Planning (ERP) applications and systems, and web browsers.
d. Trace the date, check number, and amount of outstanding item – Occurrence & Completeness. (AU-C 315.A114 a.i-ii)
Accounting Information Systems Controls and Processes, 1st Edition_Leslie Turner, Andrea Weickgenannt (SM+TB+IM +Spatteli,s Pizzeria Solutions+Process