Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help SA 2-4,5,6. I believe I have the JE correct but stuck on the GL general ledger and the UTB trial balance. A
I need help SA 2-4,5,6. I believe I have the JE correct but stuck on the GL general ledger and the UTB trial balance.
A B D E Post the accounts with the cell references from the journal in worksheet JE. Develop formulas for the cumulative balances of the accounts as shown in the chapter. 11 Account Cash Account No. Balance Debit Credit 12,700 Debit Credit Date Item 1-Sep Balance 1-Sep 3-Sep 8-Sep 15-Sep 25-Sep 30-Sep 30-Sep 30-Sep 2 3 12 Account Accounts Receivable Account No. Balance Debit Credit 9,100 Debit Credit 3 Date Item 1-Sep Balance A 1 JE GL UTB SA 2-4 Journalize transactions 1. Open the Excel file $424,5,6_24. Label Sheet1 JE. Journalize the following selected September 2011 transactions for Artscape in this worksheet. Omit posting references and journal entry explanations. Sept. 1. Paid rent for the month, $1,150 3. Paid advertising expense, $670. 8. Paid cash for supplies, $230. 11. Purchased office equipment on account, $5,200. 15. Paid creditor on account, $920 19. Fees earned and billed to customers, $7,200. 25. Received cash from customers on account, $2,380. 30. Paid telephone bill for the month, $240. 30. Paid wages to employees, $1,450. 30. Niki Yamura withdrew cash for personal use, $1,100. b. When you have completed the journal transactions, perform a "save as replacing the entire file name with the following: SA2-4,5,6_2your first name all your last name SA 2-5 Post transactions 1. Open your SA2-1.23_2e your first name titalloser last name) file label Sheet2, GL. Post the journal entries for Artscape from $12-4 to the appropriate accounts in the general ledger, worksheet GL Insert the appropriate posting references as each item is posted. Extend the balances using spreadsheet formulas to the appropriate balance columns after each transaction is posted Ilse the following chart of accounts, placing the beginning balance in the first row of each account in the appropriate balance colunin Artscape Tral Balance August 31, 2011 Credit Balances Debilt Balance 12.700 3,100 1,500 11.900 11 Cash 12 Accounts Receivable 13 Supplies 14 Office Equipment 21 Accounts Payable 31 Yamura, Capital 32 Nama, Drawing.. 41 Tees Earned 51 Advertising Expense S2 Rent Expense 53 Expense 54 Wages Expense 2.700 21,400 3.100 23.100 3.300 900 47.200 47,200 b. Save your file using the same file name. el ess SA 26 Prepare a trial balance 1. Open your $42-1.2.3.vour first name tabour kar nama Re Label Sheets UTH Use this worksheet to prepare an unadjusted trial balance for the September 36 balances of Artscape from the leger accounts of $425 b. Save your file using the same file nameStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started