Page 135 - Accounting Information Systems
P. 135

106     PART I        Overview of Accounting Information Systems

                 15. SYSTEM DOCUMENTATION—                          slip and the check are sent to the bank; the other de-
                                                                    posit slip is filed in the cash receipts department.
                 PAYROLL
                                                                 2. The remittance advice is sent to the AR clerk, who
                 Required                                           posts to the digital subsidiary accounts and then
                 Assuming the payroll system described in Problem 14  files the document.
                 uses database files and computer processing procedures,  Required
                 prepare a data flow diagram, an entity relationship dia-  Prepare a data flow diagram and a system flowchart of
                 gram, and a systems flowchart.                 the revenue cycle procedures previously described.


                                                                 17. SYSTEM DOCUMENTATION—
                 16. SYSTEM DOCUMENTATION—
                                                                EXPENDITURE CYCLE (MANUAL
                 REVENUE CYCLE MANUAL AND
                                                                AND COMPUTER PROCEDURES)
                 COMPUTER PROCESSES
                                                                The following describes the expenditure cycle for a hy-
                 The following describes the revenue cycle procedures
                                                                pothetical company.
                 for a hypothetical company.
                                                                   The company has a centralized computer system
                   The sales department clerk receives hard-copy cus-
                                                                with terminals located in various departments. The ter-
                 tomer orders and manually prepares a six-part hard-
                                                                minals are networked to a computer application, and
                 copy sales order. Copies of the sales order are distrib-
                                                                digital accounting records are hosted on a server in the
                 uted to various departments as follows: Copies 1, 2, and
                                                                data processing department.
                 3 go to the shipping department, and Copies 4, 5, and 6
                                                                   Each day, the computer in the data processing center
                 are sent to the billing department where they are tempo-
                                                                scans the inventory records looking for items that must
                 rarily filed by the billing clerk.
                                                                be replenished. For each item below its reorder point,
                   Upon receipt of the sales order copies, the shipping
                                                                the system creates a digital purchase order and prints
                 clerk picks the goods from the warehouse shelves and
                                                                two hard copies. A technician in the data center sends
                 ships them to the customer. The clerk sends Copy 1 of
                                                                the purchase orders to the purchasing department clerk.
                 the sales order along with the goods to the customer.
                                                                   Upon receipt of the purchase orders, the purchasing
                 Copy 2 is sent to the billing department, and Copy 3 is
                                                                clerk reviews and signs them. He sends Copy 1 to the
                 filed in the shipping department.
                                                                supplier and files Copy 2 in the purchases department.
                   When the billing clerk receives Copy 2 from the
                                                                   A few days later, the supplier ships the order and the
                 warehouse, she pulls the other copies from the tempo-
                                                                goods arrive at the receiving department. The receiving
                 rary file and completes the documents by adding prices,
                                                                clerk reviews the digital purchase order from his termi-
                 taxes, and freight charges. Then, using the department
                                                                nal, inspects the goods, creates a digital Receiving
                 PC, the billing clerk records the sale in the digital Sales
                                                                Report record, and prints two hard copies of the receiv-
                 Journal, sends Copy 4 (customer bill) to the customer,
                                                                ing report. The system automatically updates the inven-
                 and sends Copies 5 and 6 to the AR and inventory con-
                                                                tory records to reflect the receipt of goods. The clerk
                 trol departments, respectively.
                                                                sends Copy 1 of the receiving report with the goods to
                   Upon receipt of the documents from the billing clerk,
                                                                the stores, where they are secured. Copy 2 is filed in the
                 the accounts receivable and inventory control clerks
                                                                receiving department.
                 post the transactions to the AR Subsidiary and Inven-
                                                                   A day or two later, the accounts payable clerk receives
                 tory Subsidiary ledgers, respectively, using their depart-
                                                                a hard-copy supplier’s invoice (bill) for the items shipped.
                 ment PCs. Each clerk then files the respective sales
                                                                The clerk accesses the digital receiving report and pur-
                 order copies in the department.
                                                                chase order from her terminal. She then reconciles these
                   On the payment due date, the customer sends a
                                                                documents with the supplier’s invoice. If all aspects of the
                 check for the full amount and a copy of the bill (the
                                                                order reconcile, the clerk records the purchase in the digi-
                 remittance advice) to the company. These documents
                                                                tal purchases journal and posts the amount owed to the
                 are received by the mailroom clerk who distributes them
                                                                accounts payable subsidiary account from her terminal.
                 as follows:
                                                                   Each day, the computer application in the data proc-
                 1. The check goes to the cash receipts clerk, who  essing department automatically scans the accounts pay-
                    manually records it in the hard-copy cash receipts  able subsidiary file for items that are due for payment
                    journal and prepares two deposit slips. One deposit  and prints a two-part check. The system closes out the
   130   131   132   133   134   135   136   137   138   139   140