The Accounts Receivable Clerk receives customer checks from the Mailroom Clerk and stamps them ?For Deposit Only.? The Accounts Receivable Clerk then enters the the check information into the Accounts Receivable Program by retrieving data from the Customer Master file and entering data into the Accounts Receivable Transaction file. Three copies of the Accounts Receivable Summary Report are printed using the Accounts Receivable Program by retrieving data from the Customer Master file and Accounts Receivable Transaction file.Copy 1 of the Accounts Receivable Summary Report is sent to the Accounts Receivable Manager, Copy 2 is sent to the Accounting Manager, and Copy 3 is filed in the Accounts Receivable file cabinet by date. The customer checks are sent to the Treasurer. The Accounts Receivable Manager runs an Accounts Receivable Pending Report using the Accounts Receivable Program, Customer Master file, and Accounts Receivable Transaction file then reviews the report for reasonableness, including checking for valid customers. The Accounts Receivable Pending Report is then compared to the the Accounts Receivable Summary Report. The Accounts Receivable Manager approves the accounts receivable by entering an approval code into the Accounts Receivable Program which retrieves data from the Customer Master file, updates the Accounts Receivable Transaction file, and enters a new record into the Posted Accounts Receivable Transaction file. The Accounts Receivable Pending Report and the Accounts Receivable Summary Report are filed in the Posted Accounts Receivable file cabinet by date. The Accounting Clerk receives the customer remittance slips from the Mailroom Clerk and enters the payment information into the General Ledger Program by retrieving data from the Customer Master file and Chart of Accounts Master file while entering data into the General Ledger Transaction file. The Accounting Clerk prints a Journal Entry Report using the General Ledger Program by retrieving data from the Customer Master, Chart of Accounts Master, and General Ledger Transaction files and sends the Journal Entry Report to the Accounting Manager. The Accounting Manager compares the Accounts Receivable Summary Report with the Journal Entry Report. When the information reconciles, the Accounting Manager initials the Journal Entry Report. The Accounting Manager enters an approval code into the General Ledger Program which retrieves data from the Chart of Accounts Master file, updates the General Ledger Transaction file, and enters a new record into the Posted Journal Entries Transaction file. The Accounts Receivable Summary Report is filed in the Posted Accounts Receivable file cabinet by date, and the Journal Entry Report is sent back to the Accounting Clerk. The Accounting Clerk files the Journal Entry Report in the Journal Entries file cabinet by journal entry number and the customer remittances in the Remittance Slips file cabinet by customer name then by date. INSTRUCTIONS: Create one file in Excel with two worksheets (use a new, blank file). Name the first worksheet ?Table? and create a Table of Entities and Activities. Name the second worksheet ?Flowchart? and create a Document Flowchart. Upload your completed assignment to Blackboard before the deadline. ACADEMIC INTEGRITY: This is not a group project.Do not showyour SysDoc files to any other student.Students who turn in another student?s file, or a portion of another student?s file, will receive a zero on the assignment at the very least. Students who share their file with any other student will receive a zero on the assignment at the very least. Additional penalties for turning in another student?s work as though it was your own, or for sharing your work with others,may include a grade of ?F? in the course that cannot be removed by any forgiveness policy or by dropping the course, a notification to the University that the student violated the Code of Academic Integrity, a notation on the student?s transcript stating that the student violated the Code of Academic Integrity, and expulsion from the University or the School of Accounting. Please see the Academic Integrity sections of the syllabus for more information on this process.