Đã Đóng

intermediate accounting

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.

Directions

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.

Kĩ năng: Kế toán

About the Client:
( 0 nhận xét ) New Delhi, India

ID dự án: #32647374

5 freelancer chào giá trung bình₹1370 cho công việc này

arslanu2

Hi! We are a professional accounting firm having seven years-long exposure in the accounting field. Our team also includes professionals from high-end qualifications like Chartered Accountancy. We handle clients for a Thêm

₹1500 INR trong 7 ngày
(5 Nhận xét)
4.3
AnwarIqbal420

Hi, I understand you are looking for an Accounting Subject Specialist to help you with the accounting working trial balance, as given in Attachment # 02. The word file, attachment # 01, is already solved. Same is the Thêm

₹1000 INR trong 1 ngày
(3 Nhận xét)
3.2
(1 Nhận xét)
1.4
tahirgknhu

Hi there, I study your project and I am professional in a accounting and interested in your project looking forward for your early reply. Thanks

₹1300 INR trong 7 ngày
(0 Nhận xét)
0.0
rijanbhatta

Hi - I have more than 2 years of experience in financial planning and analysis which includes budgeting, forecasting, accounting, month end processes etc. I am ACCA UK Final student and can help you with Accounting. I Thêm

₹1050 INR trong 7 ngày
(0 Nhận xét)
0.0