Assignment: Accounting Cycle Project
Objective : To improve your knowledge and/or technological application of the accounting cycle by displaying either your learned skills or using QuickBooks Software package. ( The accounting cycle consists of (i) Analyze transactions (ii) Prepare journal entries (iii) Post journal entries (iv) Prepare Trial Balance (v) Prepare adjusting entries (vi) Prepare Adjusted Trial Balance (vii) Prepare Financial Statements (viii) Close the Books (ix) Prepare post-closing Trial Balance ).
Project: On March 1,2017you created a new travel agency, Your Name ___________Travel Agency. The following transactions occurred during the company's first month.
1. March 1:You invested $40,000 cash and computer equipment worth $80,000 in the company.
2. March 2: The company rented furnished Office space by paying $3,400 cash for the first month's (March) rent.
3. March 3: The company purchased $2,200 of Supplies for cash.
4. March 10: The company paid $7,200 cash for the premium on a 12-month insurance policy. Coverage begins on March 11.
5. March 14: The company paid $3,600 cash for two weeks, salaries earned by employees.
6. March 24: The company collected $15,800 cash on commissions from airlines on tickets obtained from customers.
7. March 28: The company paid $3,600 cash for two weeks' salaries earned by employees.
8. March 29: The company paid $500. cash for minor repairs to the company's computer.
9. March 30: The company paid $1,300. cash for this month's telephone bill.
10. March 31: You withdrew $3,000 cash from the company for personal use.
The Company ‘s Chart of Accounts follows:
101 Cash 405 Commissions Earned
106 Accounts Receivable 612 Depreciation Expense - Equip.
124 Supplies 622 Salaries Expense
128 Prepaid Insurance 637 Insurance Expense
167 Computer Equipment 640 Rent& Maintenance Expense
168 Accumulated Depreciation 650 Office Supplies Expense
209 Salaries Payable 684 Repairs Expense
301 Your name, Capital 688 Telephone Expense
302 Your name, Withdrawals 700 Income Summary
Requirements: I have designed this project so that you can use either your learned accounting skills or using QuickBooks software. I recommend if possible use both approaches. USE QUICKBOOKS ONLY IF YOU ARE PROFICIENT AND HAVE EXTENSIVE KNOWLEDGE).
Note: Garbage in garbage out.
Task 1: Create a New Company file / or Set up General Ledger System (only if using QuickBooks)
1. Open QuickBooks Premier and prepare easy step interview.
- Enter your company information
- Select your industry and type of company
- Select the folder to store your QuickBooks File in: eg. My Documents / USB Flash Drive
- Customize QuickBooks for your Business
- Set up Chart of Accounts (see above).
- Create new accounts.
- Change or delete accounts.
Task 2: Prepare journal entries to record March transactions:
> Print journal entries per task #2
Task 3: Prepare or print Trial Balance at end of March:
Task 4: Use the following information to journalize the adjusting Entries:
(a) Two-thirds of one month's insurance coverage has expired.
(b) At the end of the month, $700 of office supplies are still available.
(c) This month's depreciation on the computer equipment is $600.
(d) Employees earned $320. of unpaid and unrecorded salaries as of month-end.
(e) The company earned $1,650 of commissions that are not yet billed at month-end (use the Accounts Receivable Account).
Task 5: Prepare or print out the adjusting entries:
Task 6: Prepare or print the Adjusted Trial Balance at end of March.
Task 7: Prepare or print Income Statement (Profit & Loss) for March.
Task 8. Prepare or print the Owners' Equity Statement for March.
Task 9: Prepare or print the Balance Sheet at end of March
Task 10: Prepare the closing entries for March.
Task 11. Prepare or print the Post Closing Trial Balance at end of March.
Task 12: Close the Accounting period for March.