Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sara Smith, the Accounting Manager at ABC Company, has decided to document activities related to the Accounts Payable Process at ABC Company so that future

Sara Smith, the Accounting Manager at ABC Company, has decided to document activities related to the Accounts Payable Process at ABC Company so that future changes to the accounting information system will be efficient and effective. She also hopes to make improvements on weaknesses discovered in the system. Sara drafted the following narrative, explaining the process:

The Accounts Payable Clerk receives invoices from vendors. When vendor invoices are received, the Accounts Payable Clerk records the amount due in the accounts payable subledger and files the invoices in the unpaid invoices file, sorted alphabetically. Before ABC Company pays a vendor invoice, the accounts payable clerk must perform a "three-way match." To perform the three-way match, the Accounts Payable Clerk, matches the invoice against the purchase order prepared by the Purchasing Department and the receiving report prepared by the Receiving Department. Because all three of these documents enter the Accounts Payable Department at different times, a separate alphabetical file is kept for each type of document. The Accounts Payable Clerk files purchase orders in a purchase orders file. The Accounts Payable Clerk files receiving reports in a receiving reports file.

Every Friday, ABC Company pays invoices. The Accounts Payable Clerk retrieves the vendor invoice, attaches the purchase order and the receiving report, and forwards the matched documents to Sara, the Accounting Manager. The Accounting Manager reviews the documents for completeness, prepares a two-part check (an original check and a copy), forwards all the documents to Anna (the Operations Manager), and records the check in the cash disbursements journal.

The Operations Manager reviews the documents for validity and signs the checks. She then forwards the original check to the vendor and returns the documents and the check copy to the Accounts Payable Clerk. The Accounts Payable Clerk files the documents alphabetically in a paid invoice file, sorted alphabetically.

  1. Prepare a context diagram to document accounts payable processing at ABC Company.
  2. Prepare a document flowchart to document accounts payable processing at ABC Company.
  3. Prepare a Business Process Diagram to document accounts payable processing at ABC Company.

Submit an Excel workbook as an xlsx file. Your submission should include the following:

  • One Excel file.
    • First tab: "Context Diagram"
    • Second tab: "Document Flowchart"
    • Third tab: "BPD"

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Joe Celkos Data And Databases Concepts In Practice

Authors: Joe Celko

1st Edition

1558604324, 978-1558604322

More Books

Students also viewed these Databases questions