Instruction For the person some business from her to set July 1, 2010. Jolene decided to move to lead to operate which was Gourmet Connons Domesticing 1. The folowy we were motomotor ca 510.000. courts receivable $22.00 op 1.100,00 Thenies recent Past 50.000 3 Pode promony 54500 www to be recorded 8 10 Purch wolf 56.100 from P5500 do 5.000 214200 www 1 h 510600 24 Received cash from cash clients for fees eamed for the period July 17-24. $8,500. Received cash from dients on account. $12,000. 26 27 2e 31 Paid receptionist for two weeks' salary, 51,500. Paid telephone bill for July $325. Paid electricity bill for July. 5875 Received cash from cash clients for fees earned for the period July 25-31. 57.100 Provided services on account for the remainder of July, $5,500 Jolene withdrew 520,000 for personal use. 31 31 31 Required: 1. Joumalize each transaction in a two-column journal starting on Page 1, referring to the chart of account in selecting the accounts to be debited and credited. (Do not insert the account numbers in the journal at this time) 2. Pout the Aly transactions A Download the spreadsheet in the Ledger panel and save the Excel file to your computer. Use the spreadsheer to put the way transactions from the joumal to a ledger of four column accounts. Be sure to save your work in Excel as it will be used to complete the following steps in Part 1 of this problem as well as steps in Part 2 of this problem. Your input into the spreadsheet will not be included in your grade in CengageNOW on this problem B. Add the appropriate posting reference to the journal in CengageNOW 3. Prepare an unadjusted trial balance 4. At the end of July the following adjustment data were assembled Analyze and use these data to complete requirementa (5) and (6) Insurance expired during July is $375 wy Work 3 more Check My Work uses remaining 8. Add the appropriate posting reference to the joumal in CengageNOW. 3. Prepare an unadjusted trial balance 4. At the end of July the following adjustment data were assembled Analyze and use these data to complete requirements (5) and (6). Insurance expired during July is $375 Supplies on hand on July 31 are $2,850. Depreciation of office equipment for July is $400. - Accrued receptionist salary on Aly 31 is 5140 Rent expied during July $2.000 Uhearned fees on July 31 are $3.000 3. (Optional) on your own paper or spreadsheet enter the unadjusted trial balance on an end of period work sheet and complete the spreadsheet. Find a blank end-of-period work sheet in the Excel spreadsheet you previously downloaded 0 A Jourmalce the adjusting entries on page 3 of the joumal. Adjusting entries are recorded on July 31 Be the attached spreadsheet in the Ledger panel to post the adjusting entries to the ledger of four column scoounts, inserting balance in the accounts affected Add the appropriate posting reference to the adjusting entries in the joumal in Cangagwow 7. Prepare an adjusted trial balance CHART OF ACCOUNTS Gourmet Consulting General Ledger ASSETS REVENUE 11 Cash 41 Fees Earned 12 Accounts Receivable 14 Supplies EXPENSES 15 Prepaid Rent 51 Salary Expense 16 Prepaid Insurance 52 Rent Expense 18 Office Equipment 53 Supplies Expense 54 Depreciation Expense 19 Accumulated Depreciation Office Equipment 55 Insurance Expense 59 Miscellaneous Expense LIABILITIES 21 Accounts Payable 22 Salanes Payable 23 Uneamed Fees ournal 1 Joumalee each transaction in a two-column journal arting on Page 1, referring to the chart of accounts in selecting the accounts to be debited and credited (Do not insert the account number in the journal at this time) 2 B. Add the appropriate posing reference to the journal in CengageNOW BA Joumate the aquating entries on page 3 of the jumal Aquating entries are recorded on Ay 31 & B. Add the appropriate posting rerence to the cutting entries in the journal in CengageNOW Note Scroll down to coes page2 through 3 of the journal PAGE 1 JOURNAL ACCOUNTING EQUATION DATE BOCETON POST REE DEBIT CREDIT ASSETS LIABILITIES LOUTY enprogress=false eBook Complete accounting syle, Part 1 Instructions Charter Account Journal Ledger Unadjusted Trial Balance Apusted Trial Balance Journal PAGE JOURNAL ACCOUNTING EQUATION DESCO POST OCHT CROIT ASSETS LABILITIES eBook Complete accounting cycle, Part 1 Instructions Journal Ledger Unadjusted Trial Balance Adjusted Trial Balance Journal > X PAGES JOURNAL ACCOUNTING EQUATION DATE POST ROI DAT CREDIT ASSETS LIABILITICS COUNTY DOCATION Austing Entries Completed, Part Instruction Journal Und Trine Aried niece DEADSHEET to her Instructions nal nadjusted Trial Balance X Unadjusted Trial Balance 3. Prepare an unadjusted trial balance. Gourmet Consulting UNADJUSTED TRIAL BALANCE July 31, 2019 ACCOUNT TITLE DEBIT CREDIT 1 Cash 2 Accounts Receivable 3 Supplies . Prepaid Rent $ Prepaid Insurance Office Equipment Accumulated Depreciation Office Equipment Accounts Payable Salaries Payable 10 Uneamed Fees 1 Jolene Upton, Capital 22 Jolene Upton, Drawing al Unadjusted Trial Balance Prepaid Kent Prepaid Insurance Office Equipment 7 Accumulated Depreciation Office Equipment Accounts Payable 9 Salaries Payable 10 Uneamed Fees 1 Jolene Upton Capital 12 Jolene Upton, Drawing 13 Fees Earned Salary Expense 15 Rent Expense 1 Supplies Expense Depreciation Expense Insurance Expense s Miscellaneous Expense 20 Totats Check My Work 3 more Check My Work uses remaining All work saved. o O B Instructions Chart of Accounts Joumal Ledger Unadjusted Inal Balance Adjusted Trial Balance X Gourmet Consulting ADJUSTED TRIAL BALANCE July 31, 2019 ACCOUNT TITLE DEBIT CREDIT 1 Cash 2 Accounts Receivable 3 Supplies 4 Prepaid Rent 5 Prepaid Insurance & Office Equipment ? Accumulated Depreciation Office Equipment Accounts Payable 9 Salaries Payable 10 Unearned Fees 1: Jolene Upton, Capital Jolene Upton, Drawing S Fees Earned 14 Salary Expense 15 Rent Expense 10 Unearned Fees 11 Jolene Upton, Capital 12 Jolene Upton, Drawing 13 Fees Earned 14 Salary Expense IS Rent Expense 16 Supplies Expense 17 Depreciation Expense 16 Insurance Expense 19 Miscellaneous Expense 20 Totals