Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help to make a FLOWCHART on excel for this scenario. please and thank you!! ira Smith, the Accounting Manager at ABC Company, has decided

need help to make a FLOWCHART on excel for this scenario. please and thank you!! image text in transcribed
ira Smith, the Accounting Manager at ABC Company, has decided to document activities related to the ccounts Payable Process at ABC Company 50 that future changes to the accounting information system will be ficient and effective. She also hopes to make improvements on weaknesses discovered in the system. Sara rafted 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 module of the ABC Accounting Program, which records the amount in the ABC Accounting Program Database, and files the invoices in the unpaid invoices file, sorted alphabetically. Before ABCC 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, compares the invoice with the purchase order prepared by the Purchasing Department and with the receiving report prepared by the Receiving Department. Becouse 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 combined documents (altogether colled the "Voucher Package') to the Accounting Manager. The Accounting Manager reviews the Voucher Package for completeness and accuracy, prepares a two-part check (on original check and a copy). The Accounting Manager forwards the Voucher Package, the original check, and the check copy to the Operations Manager. Then the Accounting Manager records the check amount in the cash disbursements module of ABC Accounting Program, which records the check amount in the ABC Accounting Program Database. The Operations Manager reviews the documents for validity and signs the checks. The Operations Manager then forwards the original check to the vendor and retums 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. Prepare a document flowchart to document accounts payable processing at ABC Company. Submit an Excel workbook as an Excel file

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

Step: 3

blur-text-image

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

Survey of Accounting

Authors: Carl S Warren

5th Edition

9780538489737, 538749091, 538489731, 978-0538749091

More Books

Students also viewed these Accounting questions