Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help with the Adjusted Trial Balance in specific. I am struggling with it and cannot figure out the right figures to enter in. I
Need help with the Adjusted Trial Balance in specific. I am struggling with it and cannot figure out the right figures to enter in. I have all the adjusted entries and unadjusted balance sheet completed, i just do not understand how to enter into adjusted trial balance.
Here are the general ledger accounts:
After the success of the company's first two months, Santana Rey continues to operate Business Solutions. The November 30, 2017, unadjusted trial balance of Business Solutions (reflecting its transactions for October and November of 2017) follows. Debit 38,764 13,118 2,645 2,220 3,120 8,100 Credit No. Account Title 101 Cash 106 Accounts receivable Computer supplien Prepaid insurance Prepaid rent office equipment Accumulated depreciation-office equipment Computer equipment Accumulated depreciation-Computer equipment ccounts payable Wages payable Unearned computer services revenue 126 128 131 163 164 167 20,800 168 201 210 236 301 s. Rey, Capital s. Rey, Withdrawals Computer services revenue Depreciation expense-0ffice equipment Depreciation expense-Computer equipment Wages expense 71,000 302 5,800 403 29,319 612 613 623 2,425 637 Insurance expense 640 Rent expense Computer supplies expense Advertising expenser Mileage expense Miscellaneous expenses 652 655 1,688 676 604 677 240 684 Repairs expense-Computer 795 $100,319 $100,319 Totals Business Solutions had the following transactions and events in December 2017 2 Paid $990 cash to Hillside Mall for Business Solutions share of mall advertising costs 3 Paid $470 cash for minor repairs to the company' computer. 4 Received $4,450 cash from Alex's Engineering Co. for the receivable from November 10 Paid cash to Lyn Addie for six days of work at the rate of $100 per day. 14 Notified by Alexs Enqineering Co. that Business Solutions' bid of $7,700 accepted. lex's paid a $2,200 cash advance to Business Solutions 15 Purcha 16 Sent a reminder to Gomez Co. to pay the fee for services recorded on November 8 20 Completed a project for Liu Corporation and received $6,425 cash. 22- Took the week off for the holidays. Dec. on a proposed project has been. computer supplies ed $2,000 credit rc arris office Produc 26 on its receivable 28 Received $3,400 cash from Gomez Co. 29 Reinbursed s. Rey for business automobile mileage (500 miles at $0.31 per mile). 31 S. Rey withdrew $1,300 cash from the company for personal use The following additional facts are collected for use in making adjusting entries prior to preparing financial statements for the company's first three months: a. The December 31 inventory count of computer supplies shows $640 still available. b. Three months have expired since the 12-month insurance premium was paid in advance. c. As of December 31, Lyn Addie has not been paid for four days of work at $100 per day. d. The computer system, acquired on October 1, is expected to have a four-year life with no salvage value. e. The office equipment, acquired on October 1, is expected to have a five-year life with no salvage value. f. Three of the four months' prepaid rent has expired. Prepare an adjusted trial balance as of December 31, 2017 BUSINESS SOLUTIONS Adjusted Trial Balance December 31, 2017 Account Title Debit Credit Cash Accounts receivable 5,268 X This is a numeric cell, so please enter numbers only. Computer supplies Prepaid insurance Prepaid rent Office equipment Accumulated depreciation-Office equipment Computer equipment Accumulated depreciation-Computer equipment Accounts payable Wages payable Uneamed computer services revenue S. Rey, Capital S. Rey, Withdrawals Computer services revenue Depreciation expense-Office equipment Depreciation expense-Computer equipment Wages expense Insurance expense Rent expense Computer supplies expense Advertising expense Mileage expense Miscellaneous expenses Repairs expense--Computer 640 $ 5,268 Totals Prepare an income statement for the three months ended December 31, 2017. BUSINESS SOLUTIONS Income Statement For Three Months Ended December 31, 2017 Revenue Expenses Total expenses 0 Prepare a statement of owner's equity for the three months ended December 31, 2017. BUSINESS SOLUTIONS Statement of Owner's Equity For Three Months Ended December 31, 2017 S. Rey, Capital, October 1, 2017 Add: Net income Less: Withdrawals $ S. Rey, Capital, December 31, 2017 Prepare a balance sheet as of December 31, 2017 BUSINESS SOLUTIONS Balance Sheet December 31, 2017 Assets 0 0 Total assets 0 Liabilities Total liabilities 0 Equity Total liabilities and equity Cash Accounts Receivable Date Debit Credit Balance Date Debit Credit Balance 13,118 8,668 5,268 Dec. 01 Dec. 02 Dec. 04 Dec. 10 Dec. 14 Dec. 20 Dec. 28 Dec. 29 Dec. 31 38,764 37,774 42,224 41,624 43,824 50.249 53,649 53.494 Dec. 01 4,450 Dec. 04 Dec. 28 990 4,450 3,400 600 2,200 6.425 3.400 155 1,300 52,194 Computer Supplies Prepaid Insurance Date Date Debit Credit Balance Debit Credit Balance 2,645 4,645 2.220 Dec. 01 Dec. 01 Dec. 15 2,000 Office Equipment Debit Prepaid Rent Date Debit Credit Balance Date Credit Balance Dec. 01 3,120 Dec. 01 8,100 Accumulated Depreciation-Office Equipment Computer Equipment Date Debit Credit Balance Date Debit Credit Balance Dec. 01 Dec. 01 20,800 Accumulated Depreciation-Computer Accounts Payable Equipment Debit Date Credit Balance Date Debit Credit Balance Dec. 01 0 Dec. 01 2.000 Dec. 15 2,000 Wages Payable Unearned Computer Services Revenue Date Debit Credit Balance Date Debit Credit Balance Dec. 01 0 Dec. 14 0 Dec. 01 2.200 2,200 S. Rey, Withdrawals S. Rey, Capital Debit Balance 71.000 Balance 5,800 7,100 Date Credit Date Debit Credit Dec. 01 Dec. 31 Dec. 01 1,300 Depreciation Expense-Office Equipment Computer Services Revenue Credit Date Debit Balance Date Debit Credit Balance Dec. 01 Dec. 20 29,319 35,744 Dec. 01 6,425 Depreciation Expense-Computer Equipment Wages Expense Date Debit Credit Balance Date Debit Credit Balance Dec. 01 Dec. 01 Dec. 10 0 2,425 3,025 600 Insurance Expense Debit Credit Rent Expense Date Balance Date Debit Credit Balance Dec. 01 Dec. 01 0 Advertising Expense Computer Supplies Expense Date Debit Credit Balance Date Debit Credit Balance Dec. 01 Dec. 01 1,688 0 Mileage Expense Miscellaneous Expenses Date Debit Credit Balance Date Debit Credit Balance Dec. 01 Dec. 29 604 759 Dec. 01 240 155 Repairs Expense-Computer Date Debit Credit Balance Dec. 01 Dec. 03 795 1,265 470
Step 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