The Accounts Receivable Clerk receives customer checks from the Mailroom Clerk and stamps

Question

Summer 2017 SysDoc1 Assignment
Accounts Receivable
NARRATIVE
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.
Page 1 of 1

Order Now