Reference no: EM131147184

Case B: Bondstreet Company (Billing and Cash Receipts Processes)

The Bondstreet Company sells medical supplies to hospitals, clinics, and doctors' offices. Bonstreet uses an ERP system for all of its business processes.

The billing process begins each morning when a clerk in the billing section of the AR department requests that the ERP system display the billing due list on their computer screen. These are the shipments made the precious day from the warehouse at Bondstreet's customer fulfillment center. At the bottom of the lis, the computer displays the total number of records in the billing due list, the total number of items that were shipped, and a hash total of the customer numbers. The clerk records these onto a batch total sheet.

The clerk then requests that the ERP system execute the billing program. This program prepares invoice records by accessing the customer data to get the routing information for the electronic invoice and the payment terms to be given to the customer. The program also obtains the prices from the inventory data. Finally, the program examines the sales order data to determine how the shipment was routed so that shipping costs can be added to the invoice. At the end of this process, the computer calculates and displays a total of the number of invoices, the total items being billed, and a hash total of the customer numbers in the batch of invoices.

The billing clerk reconciles the invoice totals with those obtained from the billing due list. If the totals agree, the clerk accepts the batch of invoices. In response the ERP system updates the sales order to show that the shipment has been billed, closes the billing due list, creates an accounts receivable record, updates the general ledger for sale, sends an electronic invoice, to the customer, and displays a job completed notice on the billing clerks screen.

The cash receipts process begins each morning when the lockbox at Bondstreet's bank sends a file of remittance data processed the previous day. Bondstreet's ERP system automatically saves this file. For each payment, this file contains a customer number, invoice number, and amount paid. Totals in this file include hash totals for customer number and invoice number and the total payments. The bank also sends an email containing these same totals. A clerk in the cash applications section of the AR department requests that the ERP system display the totals in the remittance file and manually compares those totals to those in the email.

If the totals agree, the clerk requests that the ERP system apply the payments to the AR data. The computer examines the terms on the invoice record, calculated the amount that should be paid, and records the payment. The computer displays the totals recorded to AR and discounts, and the total amount paid. The clerk compares these totals to those obtained from the email and remittance file. If they agree, the clerk requests that the ERP system update the general ledger for this batch.

A) Draw a systems flowchart (using software)

B) Prepare a control matrix, including explanations of how each recommended existing control plan helps to accomplish or would accomplish in the case of missing plans, each related control goal.

C) Anotate the flowchart prepared in part A to indicate the points where the control plans are being applied or where they could be applied but are not (codes P-1, P-2, M-1, etc).