Comprehensive Problem: Manual Accounting Information System

The following problem is a comprehensive problem requiring you to complete all of the steps in the accounting cycle. Later in the semester you will be entering transactions using QuickBooks Online. This will demonstrate the important point that a manual accounting information system (AIS) and a computerized AIS both allow the user to perform the same steps in the accounting cycle, but they are done differently.

In a manual system, every step must be performed by the user. In contrast to this, in a computerized system, for each transaction, the user determines the type of transaction it is and enters it in the appropriate data entry screen. The computer then automatically places the transactions in transaction files (the equivalent of journals in a manual system). The user then instructs the system to post the transaction to the subsidiary ledger and at the end of the month to the general ledger. The computer can do the posting automatically.

Other steps done automatically by the computer are preparing a trial balance, closing entries, and generating financial statements. The user would have to provide the computer with information about adjusting entries at the end of the period. Some adjusting entries can be set up to be done automatically every month, but not all. When we say the computer can do a specific step “automatically,” this presumes that a programmer wrote the programs (i.e., detailed step-by-step instructions in a computer language) that tell the computer how to do the task. The computer can then follow those instructions and do it “automatically” without human intervention.

Problem

Assume there is a small shoe store in your neighborhood with a single owner. The owner started the business on December 1, 2021, and sells two types of shoes: a comfortable sneaker that is something athletes would purchase, and a comfortable dress shoe that looks dressy but has the comfort of a sneaker. The name of the business is The Shoe Horn. Complete tasks A and B that follow, using the detailed instructions for each. Following is a list of all transactions that occurred during December 2021.

a.	Dec. 1	Jack Simmons, the owner contributed a $500,000 check from his personal account, which he deposited into an account opened in the name of the business, to start the business.
b.	Dec. 1	He rented space that had previously been used by a shoe store and wrote check no. 100 for $9,000 for the first six month’s rent.
c.	Dec. 2	He paid for installation and phone usage $300 (check no. 101)
d.	Dec. 2	He paid for advertising in the local paper $150 (check no. 102). The ads will all run in December.
e.	Dec. 2	He purchased $500 of office supplies (check no. 103)
f.	Dec. 3	He paid $300 for insurance for three months (December 2021, January and February 2019 using check no, 104).
g.	Dec. 4	He purchased 800 pairs of sneakers at $40 a pair– on account from Nike (using purchase order no. 301). Assume the shoe store uses the perpetual inventory system.
h.	Dec. 5	He purchased 500 pairs of dress shoes from Footwear Corp. on account for $20 a pair (using purchase order no. 302).
i.	Dec. 10	He made a sale on account of 20 pairs of sneakers at $100 a pair, to a local University – Highland University (sales invoice number 2000) for their basketball team. Payment terms were 2/10 net 30.
j.	Dec. 11	He made a sale on account of 2 pairs of dress shoes at $50 a pair (sales invoice no. 2001) to a local charity, U.S. Veterans, that intended to raffle them off at one of their events.
k.	Dec. 12	He made a sale on account to The Jenson Group of 300 pairs of dress shoes at $50 a pair, to use as part of an employee uniform. Payment terms were 2/10 net 30.
l.	Dec. 14	He made a cash sale for 2 sneakers at $120 each and 1 pair of shoes for $60.
m.	Dec. 14	He paid the amount owed to Footwear Corp (check no 105)
n.	Dec. 17	Highland University returned 2 pairs of sneakers they had previously purchased on account.
o.	Dec. 18	He received a check from Highland University in full payment of their balance.
p.	Dec. 20	He made a cash sale to Charles Wilson of three pairs of sneakers at $120 each and 1 pair of dress shoes at $60.
q.	Dec. 20	He made a partial payment to Nike for $20,000 (check number 106)
r.	Dec. 27	Received a check from The Jenson Group in the amount of $9,000.
s.	Dec. 28	He paid $2,000 of his balance to Nike (check number 107)

Enter all of the transactions and complete all of the steps in the accounting cycle assuming a manual system. Follow the steps to be performed using a manual system.

Steps to be performed using a manual system

1. For each of the transactions listed for the month of December 2021, identify the journal to which the entry should be recorded. Your possible choices are as follows: general journal (GJ), cash receipts journal (CR), cash disbursements journal (CD), sales journal (SJ), or purchases journal (PJ). Prepare your own journals based on illustrations in class. Assume you are using a perpetual inventory system.
2. Enter each transaction in the appropriate journal using the format provided. You can use Excel or Word or pencil and paper and scan your document in.
3. Open up Accounts Receivable subsidiary ledger accounts for customers and Accounts Payable subsidiary ledger accounts for vendors using the format provided. Post each entry to the appropriate subsidiary ledger on the date the transaction occurred.
4. Total the four special journals, and post from all of them to the general ledger on the last day of December. You should open ledger accounts for the following accounts:
   • Cash
   • Accounts Receivable
   • Merchandise Inventory
   • Prepaid Insurance
   • Prepaid Rent
   • Office Supplies
   • Accounts Payable
   • Utilities Expense Payable
   • Jack Simmons, Capital
   • Sales
   • Sales Returns and Allowances
   • Sales Discounts
   • Cost of Goods Sold
   • Rent Expense
   • Advertising Expense
   • Telephone Expense
   • Utilities Expense
   • Office Supplies Expense
   • Insurance Expense
5. Compute balances for each general ledger account and for each Accounts Receivable and Accounts Payable subsidiary ledger account.
6. Prepare a trial balance.
7. Prepare an accounts receivable schedule and an accounts payable schedule.
8. Prepare adjusting journal entries based on the following information given, record the entries in the appropriate journal, and post the entries.
   • There were $100 worth of office supplies remaining at the end of December.
   • Make an adjusting entry relative to insurance.
   • There was a bill received in the mail for utilities expense for the month of December in the amount of $100 that is due by January 10, 2022. Jack Simmons intends to pay it in January.
9. Prepare an adjusted trial balance
10. Prepare closing journal entries, record them in the general journal, and post them.
11. Prepare an Income statement, Statement of Owner’s Equity, and Balance Sheet.

Extra credit

12. Prepare reversing journal entries

Answer rating: 100% (QA)

Journal Entry Date Particular Amount Amount Dec 1 Bank 50000000 Dec 1 Owners Capital 50000000 Dec 1 Prepaid Rent 900000 Dec 1 Bank 900000 Dec 2 Telephone Expenses 30000 Dec 2 Bank 30000 Dec 2 Advertis... View the full answer