Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribed

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 name

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Surviving The OSHA Audit Common Sense Solutions To Your Most Feared OSHA Compliance Issues

Authors: David A. Casavant

1st Edition

0998743704, 978-0998743707

More Books

Students also viewed these Accounting questions