can someone help me with part 1 since i am stuck thank you in advance.
E ACC'I'll Practice Set Instruct l'ulluli: [il ;l. .M C' G) File /Users/tylereilenfeldt/Downloacls/ACC111%20Practice%20$et%20Instructionspdf ' ra ce e James Regal, Esquire is an Attorney and has formed his own law rm, Regal Law Firm. You have been hired by James as his bookkeeper. Aer talking to James. you prepare his chart of accounts, which is below. Regal Law Firm chart of Account: Accoum # Account Name 101 Cash 102 Accounts Recehable 103 Supplies 201 Accounts Payable 202 Uneamed Revenue 301 Regal. Capital 302 Regal. Drawing 401 Fee Income 501 Rent Expense 502 Salaries Expense 503 Supplies Expenss The rst month of business for the Regal Law Firm is March 2018. The transactions for the month of March are: gag Transaction 3/1/2018 James opened the bank account and deposited $5,000 for his capital contribution. 3/5/2018 James paid $250 for rent. 3/10/2018 James received $1,000 from a new client, Sue Barnes, as a deposit for legal services. 3/15/2018 James paid $375 of salaries to his legal assistant. 3/22/2018 James received a bill of $75 for ofce supplies which will be paid next month. 3/30/2018 James withdraw $1,000 for his personal use. Practice Set Part 1: Download Excel workbook and "save as" adding your last name to the end of the file. The assignment must be complete using Microsoft Excel. If it is not completed in Excel, your assignment may not be accepted. See the syllabus to download a free copy of Microsoft Excel. 1. Using the chart of accounts, open the accounts in the general ledger. 2. Record the journal entries for the March transactions using General Journal Page 1. Make sure that you include explanations. 3. Post the entries to the general ledger 4. Calculate the balances in the general ledger accounts. 5. Prepare the Trial Balance Columns in the worksheet. Make sure you properly complete the heading. After completing the Trial Balance in Step 5, compare the balance you calculated with the check gure for the Trial Balance in the Instructions. (If you have trouble getting it to agree, you may send me your excel workbook to check by attaching it to a Canvas message.) Do not move on until your trial balance agrees. E} ACC111 Practlc....pdf '35 ACC111 Practic....x|sx El Module 01Acc....pdf a Module 01Acc....pdf Show A\" 1ACC111 Practice Set Worksheets Q ~ Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share ~ X Cut Arial 10 A- A = Wrap Text General _ AutoSum Copy Fill Paste Merge & Center $ ~ % " .00 Conditional Format Cell Insert Delete Format Clear Sort & Format Formatting as Table Styles Filter M19 X V fx A B C D E F G H J K L M N Q R S T U V W n Un A W IH General Journal Page 1 Date Accounts and Explanations Ref Debit Credi GJ Page 1 General Ledger Worksheet GJ Page 2 Financial Statements GJ Page 3 PC TB + Ready + 100%1ACC111 Practice Set Worksheets Q ~ Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share ~ X Cut Arial 10 A- A Wrap Text General AutoSum Copy Fill AP. Paste Format Merge & Center $ % > .00 Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles Clear Filter C40 X v fx A B C D E F G H I K L M N O P Q R S T U V W OLD UN General Ledger Account Account No Date Description Ref Debit Credit Balance 13 Account Account No 15 Description Ref Debit Credit Balance 22 Account Account No 24 Date Description Ref Debit Credit Balance 25 26 27 28 SU 31 Account No 33 Date Description Ref Debit Credit Balance 34 41 Account No 42 Date Description Ref Debit Credit Balance 43 44 45 46 47 40 49 Account JU Account No GJ Page 1 Inmarintion General Ledger Worksheet nah it GJ Page 2 Can dit Financial Statements GJ Page 3 PC TB + Ready - + 100%1ACC111 Practice Set Worksheets Q ~ Search Sheet Home Insert Page Layout Formulas Data Review View '+ Share ~ X Cut Arial 10 A- A = = Wrap Text General AutoSum Copy Fill Sort & Paste Format Merge & Center $ % > .00 Conditional Format Cell Insert Delete Format Formatting as Table Styles Clear Filter H32 X v fx A B C D E F G H I J K L M N O P Q R S T U V W X Worksheet Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Account Names Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 11 15 18 Total 19 Net Income 20 Total 21 22 23 24 25 26 27 28 29 30 33 34 35 36 ! wa 38 39 44 GJ Page 1 General Ledger Worksheet GJ Page 2 Financial Statements GJ Page 3 PC TB + Ready + 100%
