Unit 1 includes the completion of a basic systems case as part of the review of earlier accounting course work. The case requires completion of an entire accounting cycle for a retail company using both paper records and Excel spreadsheets. The first part of the case is completed manually and the latter part requires the use of Excel.
The objective of this case is to refresh and solidify your knowledge of the accounting system. Your instructor is available to answer questions and provide feedback throughout assuming you reach out in a timely manner. The objective is for each of you to accurately complete this case.
Should you get stuck and need instructor assistance, be sure to send pictures, screen shots, or your Excel document to your instructor as part of your explanation.
Download the following the case materials:
Ch. 3 Basic Systems Case - Student Materials Download Ch. 3 Basic Systems Case - Student Materials- Print it out.
Complete requirements #1 & 2 (Regular Journal Entries and Posting) manually using the journal and ledger provided in the student materials. Because specific dates are not provided in the case, just label your journal entries according to the case (a, b, c, etc.)
The following recording provides additional guidance. Be sure to view [login to view URL] Chapter 3 Accounting for Retailer & Introduction to AIS Case (Links to an external site.)AC320 Chapter 3 Accounting for Retailer & Introduction to AIS Case
Download the following case spreadsheet:
Ch. 3 Basic Systems Case Spreadsheet for Students Download Ch. 3 Basic Systems Case Spreadsheet for Students- Use this document as you complete case requirements #3-5.
The following recording provides additional guidance for this portion of the case. Be sure to view [login to view URL] AIS Case Completing WTB and Financial Statements (Links to an external site.)AC320 AIS Case Completing WTB and Financial StatementsIf you need additional guidance on using Excel, the following optional recording was created about Excel in general. AC320 Excel Spreadsheet Basics and Excel Charts (Links to an external site.)AC320 Excel Spreadsheet Basics and Excel Charts
Complete Requirement #3 (Adjusting Entries) using the AIS Case tab in the Excel document.
Here are a couple short videos if you are having trouble problem-solving for the necessary adjustments.1 - A review of transaction analysis (Dr/Cr rules) and recording of rent[login to view URL] (Links to an external site.)2 - Accrual of interest[login to view URL] (Links to an external site.)
Complete Requirement #4 using the Financial Statements tab. You may create additional sheets if you prefer to use a separate sheet for each financial statement. Notice the second sheet is not formatted for you because you are expected to fully design the financial statements.
Complete Requirement #5 using the AIS Case tab.
Case check figures:
Total Debit/Credits for the unadjusted Trial Balance 138,000
Total Debit/Credits for Adjusted Trial Balance 141,350
Total Debit/Credits for Post-Closing Trial Balance 103,100
Net Income 2,850
Total Assets 100,100
Complete Requirement #6 (Closing Entries) using the manual documents. (Recall that you can find information about closing entries in the textbook as well as a video in Wiley Course Resources.)
Submit both your Excel document and the manual portion of the case (journal and ledger). You will need to scan your manual documents to submit those. If you don’t have this capability, take digital pictures of your manual documents and upload those.