Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help with the full accounting cycle? Please read and follow all instructions in the following image. Present results in spreadsheet. This is part

Can you help with the full accounting cycle? Please read and follow all instructions in the following image. Present results in spreadsheet. This is part 2.

This is the completed transaction in journal and Transaction to pertinent T accounts.

image text in transcribed

image text in transcribed

I need the next 8 steps in spreadsheet :

Thank you in advance.

image text in transcribed

image text in transcribed

image text in transcribed

Credit Date 08/01 Debit $ 50,000 $5,000 08/01 $ 25,000 $ 10,000 $ 15,000 08/03 $ 3,500 $ 3,500 08/04 100 $ $ 1,100 $ 1,200 08/06 $ 600 $ 600 08/08 $ 150 $ 150 08/12 $ 500 $ 500 08/18 $ 2,000 $ 2,000 08/19 $ 5,000 $ 5,000 Jornal Particulars Cash A/C To Mary Smith, Capital A/C Equipment A/C To Cash A/C To Wason A/C Supplies A/C To Accounts Payable A/C Rent A/C Prepaid Rent A/C To Cash A/C Utilities Expense A/C To Cash A/C Cash A/C To Services Revenue A/c Accounts Receivable A/C To Services Revenue A/c Wason A/C To Cash A/C Salaries Expense A/C To Cash A/C Cash A/C To Accounts Receivable A/C Cash A/C To Services Revenue A/C Cash A/C To Services Revenue A/C Mary Smith, Drawings A/C To Cash A/C Telephone Expenses A/C To Cash A/C Cash A/C To Notes Payable A/C Notes Payable A/C To Cash A/C Closing Supplies A/C To Profit & Loss A/C Depreciation Expense A/C To Equipment A/C Salaries Expense A/C To Salaries Payable A/C Cash A/C To Unearned Revenue A/C 08/20 $ 200 $ 200 08/22 $ 10,000 $ 10,000 08/24 $ 100 $ 100 08/25 $ 500 $ 500 08/28 $ 600 $ 600 08/30 $ 15,000 $ 15,000 08/31 $ 500 $ 500 08/31 $ 500 $ 500 08/31 $ 500 $ 500 08/31 $ 5,000 $ 5,000 08/31 $ 3,000 $ 3,000 Cash / Account Details N. Torres, Capital Services Revenue Accounts Receivable Unearned Revenue Services Revenue Notes Payable Unearned Services Debit Details $ 50,000 Equipment $ 150 Rent $ 200 Utilities $ 10,000 Wason $ 100 Salaries Expense $ 15,000 N. Torres, Drawing $ 3,000 Telephone Exp. Notes Payable Prepaid Rent Credit $ 25,000 $ 100 $ 600 $ 2,000 $ 5,000 $ 500 $ 600 $ 500 $ 1,100 Sub-Total $ 78,450 $ 35,400 Balance $ 43,050 Details Credit Supplies / Account Details Accounts Payable Profit & Loss Debit $ 3,500 $ 500 Sub-Total $ 4,000 $ Balance $ 4,000 Accounts Receivable / Account Details Debit Services Revenue $ 500 Cash Details Credit $ 200 Sub-Total $ 500 $ 200 Balance $ 300 Prepaid Rent / Account Details Debit Cash $ 1,100 Details Credit Sub-Total $ 1,100 $ - Balance $ 1,100 Equipment / Account Details Cash Wason Debit Details $ 10,000 Depreciation $ 15,000 Credit $ 500 Sub-Total $ 25,000 $ 500 Balance $ 24,500 Details Notes Payable / Account Details Debit Cash $ 500 Cash Wason Credit $ 15,000 Sub-Total $ 500 $ 15,000 Balance $ 14,500 Salaries Payable / Account Details Debit Details Salaries Expense Credit $ 5,000 Sub-Total $ $ 5,000 Balance $ 5,000 Unearned Revenue / Account Details Debit Details Credit $ 3,000 Cash Sub-Total $ $ 3,000 Balance $ 3,000 Norma Torres, Capital / Account Details Debit Details Credit $ 50,000 Cash Sub-Total $ $ 50,000 Balance $ 50,000 Norma Torres, Drawings / Account Details Debit Cash $ 500 Details Credit Sub-Total $ 500 $ Balance $ 500 Service Revenue / Account Details Debit Details Credit Cash $ 150 Accounts Receivable $ 500 Cash $ 10,000 Cash $ 100 Sub-Total $ $ 10,750 Balance $ $ 10,750 Details Credit Salaries Expense / Account Details Debit Cash $ 5,000 Salaries Payable $ 5,000 Sub-Total $ 10,000 $ Balance $ 10,000 $ Utilities Expense / Account Details Debit Cash $ 600 Details Credit Sub-Total $ 600 $ Balance $ 600 $ Telephone Expense / Account Details Debit Cash $ 600 Details Credit Sub-Total $ 600 $ - Balance $ 600 $ Depreciation Expense / Account Details Debit Equipment $ 500 Details Credit Sub-Total $ 500 $ Balance $ 500 $ ACCOUNTING CYCLE MARY SMITH STARTED HER OWN CLEANKING EYEBROWS AND MAKEUP BUSINESS IN AUGUST OF THE CURRENT YEAR. DURING THE MONTH, THE FOLLOWING TRANSACTIONS WERE COMPLETED. PLEASE PERFORM: 1) CALCULATE NORMAL BALANCE OF ACCOUNTS 2) PREPARE THE UNADJUSTED TRIAL BALANCE. 3) RECORD TRANSACTIONS OF ADJUSTMENTS IN JOURNAL (ADJUSTING ENTRIES). 4) TRANSFER ALL ADJUSTMENT TRANSACTIONS TO ACCOUNTS (T) AND CALCULATE NORMAL BALANCES. 5) PREPARE THE FINANCIAL REPORTS OF INCOME STATEMENT, OWNER'S EQUITY STATEMENT AND THE CLASSIFIED BALANCE SHEET. 6) REGISTER CLOSING TRANSACTIONS IN JORNAL (CLOSING ENTRIES) 7) TRANSFER ALL CLOSING TRANSACTIONS TO THE ACCOUNTS (T) AND CALCULATE THE ACCOUNT BALANCES. 8) PREPARE THE POST CLOSING TRIAL BALANCE. 08/01 - MARY INVESTED $50,000 IN HER COMPANY. 08/01 - PURCHASED AN EQUIPMENT FOR $25,000. PAID $10,000 IN CASH AND $15,000 WASON ACCOUNT. 08/03 - PURCHASED SUPPLIES FOR $3,500 ON ACCOUNT. 08/04 - PAID $1,200IN CASH FOR RENTFOR THE WHOLE YEAR. 08/06 - PAID $600 FOR THE UTILITIES BILL. 08/08 - RECEIVED $150 FOR EYEBROWSERVICES FROM VARIOUS CLIENTS. 08/12 - GAVE $500 IN EYEBROW SERVICES ON ACCOUNT AND BILLED VARIOUS CLIENTS. 08/18 - PAID $2,000 IN CASH TO WHAT ISOWED ON ACCOUNT FOR DAY 1. 08/19 - PAID $5,000 IN EMPLOYEE SALARIES. 08/20 - RECEIVED $200 FROM CLIENTS FROM DAY 12. 08/22 - RECEIVED $10,000 IN ADVANCE FOR MAKEUP SERVICES FOR A BEAUTY PAGEANT 08/24 - RECEIVED $100 FOR EYEBROW SERVICES. 08/25 - WITHDREW $500 FOR PERSONAL USE. 08/28 - PAID $600 FOR THE TELEPHONE BILL. 08/30 - BORROWED $15,000 FROM BANCO SANTANDER AS A BANK LOAN. 08/31 - PAID $500 TO BANCO SANTANDER. CHART OF ACCOUNTS CASH - 101 SUPPLIES - 102 ACCOUNTS RECEIVABLE - 103 PREPAID RENT - 104 EQUIPMENT - 105 ACCUMULATED DEPRECIATION - 106 NOTES PAYABLE - 201 ACCOUNTS PAYABLE - 202 SALARIES PAYABLE - 203 UNEARNED REVENUE - 204 MARY SMITH, CAPITAL - 301 MARY SMITH, DRAWINGS - 302 INCOME SUMMARY - 303 SERVICE REVENUE - 401 SALARIES EXPENSE - 501 UTILITIES EXPENSE - 502 TELEPHONE EXPENSE - 503 DEPRECIATION EXPENSE - 504| SUPPLIES EXPENSE - 505 ADJUSTING ENTRIES: 08/31 - SUPPLIES ON HAND $500 08/31 - DEPRECIATION OF THE EQUIPMENT $500 08/31 - SALARIES EARNED BUT NOT PAID $5,000 08/31 - UNEARNED SERVICES GIVEN $3,000

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

Managerial Accounting Creating Value In A Dynamic Business Environment

Authors: Ronald Hilton, David Platt

13th Edition

1264100698, 9781264100699

More Books

Students also viewed these Accounting questions