anyone help me find the worksheet please
anyone help me find the worsheet
Mini Practice Set Est. Time: 5 hours Sherman Realty Reviewing the Accounting Cycle Twice This comprehensive review problem requires you to complete the accounting cycle for Sherman Realty twice. This practice set allows you to review Chapters 15 while reinforcing the relationships between all parts of the accounting cycle. By completing two cycles, you will see how the ending April balances in the ledger are used to accumulate data in May. First, look at the chart of accounts for Sherman Realty Sherman Realty Chart of Accounts Assets 111 Cash 112 Accounts Receivable 114 Prepaid Rent 115 Office Supplies 121 Office Equipment 122 Accumulated Depreciation, Office Equipment 123 Automobile 124 Accumulated Depreciation, Automobile Revenue 411 Commissions Earned Expenses 511 Rent Expense 512 Salaries Expense 513 Gas Expense 514 Repairs Expense 515 Telephone Expense 516 Advertising Expense (continued on here) 180 180 CHAPTER 5 The Accounting Cycle Completed Liabilities 211 Accounts Payable 212 Salaries Payable Owner's Equity 311 Jacob Sherman, Capital 312 Jacob Sherman, Withdrawals 313 Income Summary 517 Office Supplies Expense 518 Depreciation Expense, Office Equipment 519 Depreciation Expense, Automobile 524 Miscellaneous Expense On April 1, 201X, Jacob Sherman opened a real estate office called Sherman Realty The following transactions were completed for the month of April: 2017 Aprili Jacob Sherman invested $14.000 cash in the real estate agency along with $9.000 of office equipment DEPOSIT TICKET CURRENCY MOLDO CASH SHERMAN REALTY (213) 478-3584 8200 SUNSET BOULEVARD Los Angeles, CA 90028 TOTAL RESU DATE_April 1 201x TOTAL 14.000 DO LES CAREERVED MET DEPOSIT 14,000.00 BAY BANK Box 1739 Terminal Annex Los Angeles, CA 90052 6122000661400-03857-01362 April Rented and paid 4 months' rent in advance to Mclay Property Management, 53.600 SHERMAN REALTY (213) 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 1 0001 201X ORDER OF $ TO BE McLay Property Mgmt Co. Three Thousand six Hundred 3,6008 DOLLARS BAY BAK Box 17 Tres Los Angeles, CA DOO LEWO Rent April July 2014 Jacob Sherman CHAPTER 5 The Accounting Cycle Completed 181 April: Bought an automobile on account from Jeep East, 314,000 INVOICE Jeep East 1 Salem S1 Los Angeles, CA 90052 (213) 639-1917 INVOICE NO. 1113 DATE A VIX TERMS NO To: SHERMAN REALTY 8200 Sunset Blvd Los Angeles, CA 90028 UNIT PRE AMOUNT QUANTITY 1 ONLY DESCRIPTION Automatic 51400000 314,000.00 14,000.00 Make checks payable to Jeep East SUBTOTAL FREIGHT TAK TOTAL DUE THANK YOU FOR YOUR BUSINESS 514.000.00 April Purchased office supplies from The Office Store, for cash, 5100 The Office Store 1 Fermero Los Angeles, CA 90052 Phone212) 631-020 SOLD TO Sherman Realty 1200 S Blvd. Los Angeles, CA 90028 INVOICE DATE AIX NUMBER TERMS Cash SHIPPED TO Shaman Ray 1200 Sunset Los Angeles, CA 90028 DATE DESCRIPTION UNIT PRICE AMOUNT 00.00 AIXO ples PARECIDO 10002 YOU Bus Number SSS THANK YOU FOR YOUR BUSINESS REASE PAY SHERMAN REALTY 013-3584 200 SUNGET BOULEVARD LOS ANGELES, CA coce 201X $ GRENS The office Store Nine Hundred and 900 non Sim -00 000 000 s II 182 182 CHAPTER 5 The Accounting Cycle Completed April Purchased additional office supplies from The Office Store, on account, 5450 INVOICE DATE April 5/1 NUMBER DAS TERMS: 60 The Office Store 1 Fercroft Rd. Los Angeles, CA 90052 Phone (213) 691-0288 SOLD TO Sherman Realty 8200 Sunset Blvd. Los Angeles, CA 90028 SHIPPED TO: Sherman Realty 8200 Sunset Blvd. Los Angeles, CA 90028 DATE DESCRIPTION UNIT PRICE AMOUNT 450.00 Art. 51% Omice supplies Sub 450.00 5450.00 Total Business Number: 115555559 THANK YOU FOR YOUR BUSINESS PLEASE PAY THE ABOVE April Sold a house to Bryce Lyman and collected $6.500 commission DEPOSIT TICKET QUY SA REALTY 1213) 478-3564 8200 SUNSET BOULEVARD Los Angeles, CA 90028 warto April 6 201X BAT BAIK Box 173 Terminal Anne Los Angeles, CA 90052 4.22000 IL00-03857016 SHEMALT COMMON RIPORT CHAPTER 5 The Accounting Cycle Completed 183 April Pald gas bill to Harvey Petroleum Gas Co., 525. SHERMAN REALTY (213) 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 8 0003 201X 25 PRY TO THE OPC Dr Harvey Petroleum Gas Co. Twenty-Five and its BAY BANK Box 1730 Terminal Annex Los Angeles, CA 90052 MEMO Gas Blu - April 6 DOLLARS Jacob Sherman Agri 15 Paid Tessa Hardy, office secretary, 5550. 0004 SHERMAN REALTY (213) 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 15 201X 0 Teosa Hardy ORDER OF $ 5506 DOLLARS Five Hundred Fifty and BY DA Box 1739 Terminal ex Los Angeles, CA 90052 MO Salary - April 1-15 Jacob Sherman April 17 Solid building lotto Wetland Developers and med en 17.500 payment to be received on May RUN BERTY COMMISSION REPORT Wetland Developers De Ar 2014 A Ramay. 2018 184 184 CHAPTER 5 The Accounting Cycle Completed April 20 Jacob Sherman withdrew 53.000 from the business to pay personal expenses SHERMAN REALTY 2139 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 0005 201X April 20 $ 3,000 DOLLARS PY TO THE Jacob Sherman OF Three Thousand and to BAYBANK Box 1730 Terminal Annex Los Angeles, CA 90052 ME Withdrawal Jacab skerman April Sold a house to Mary Dappler and collected a 58.000 commission DEPOSIT TICKET GUENCY CA SER REALTY 02133 478-3584 8200 SUNSET BOULEVARD Los Angeles, CA 90028 are B.DOC DO Dr_April 21 201X 6.000.00 BAT B Box 173 Terial nec Los Angeles, CA 90052 2200000-385T-0116 SERMAN RIALTY COMMISSON REPORT Duter Apr 2013 Bule La co 185 CHAPTER 5 The Accounting Cycle Completed 185 April 2 Pall to Harvey Petroleum Gamla SHERMAN REALTY 213478-3564 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 22 0006 200X 90% Cree Or Harvey Petroleum Gap Ca Ninety and BAYBANK Box 1739 Teile Los A CABOS O Gas Bil-April 22 DOLLAS Jacob Shereas AN Puldeep C 450 to repair tomobile INVOICE Jeep 1 Salem Los Angeles, CA 902 213, 6.9.1917 INVOICE NO.14 DATE: 2016 Cash | Ship to Tek SHERMAN REALTY 8200 Surov Los Angeles, CA CON UNCE re AMOUNT . OMY PAYMENT RECEVEDO TA THANK YOU FOR YOUR BUSINESS BOOT SHERMAN REALTY 013473-554 O SUNGET BOULEVARD LOS ANGELES, CA Aprill 24 2014 $ 400 CHORD Jeep East Four Hundred Fifty and Auten 164 Pacar Shorts -MacBook 80 000 DI F8 DD 59 TVO F7 F6 F3 F4 F5 A % & 186 186 CHAPTER 5 The Accounting Cycle Completed April 30 Paides Handy office secretary, 1950. 0008 SHERMAN REALTY 13 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 30 2017 550 TO THE remor Tessa Hardy Five Hundred Fifty and BAYBANK Box 173 Terminal Arvex Los Angeles, CA 90052 MEMO Salary - April 16-20 DOLLARS Jacob Sherman Art Paidage Agritulephone, 1200 Vonage Park Place Los A CAROOS Your Statement SHERMAN REALTY 8000 Sunnet Loa + CA 0447 Payment received April 30, 2018 And Total Due SHERAN REALTY 13 47-5 0000 00 SUNSET BOULEVARD LOS ANO, CA008 April 30 2014 GCC Vortage $ 2004 Two Hundred and BV Jacob Sherman MacBook 000 8 DI D 187 CHAPTER 5 The Accounting Cycle Completed 187 April 30 Received advertising bill for Agri, 5700, fronterad. The is to be paid on May 2. Tampa Herald 1 Long Tanpa Haride, IL (2) 10-1000 INVOICE SOLD TO: Inveice Na Shermany 8200 Sunset Los Angeles, CA 0028 4809 April 2013 May 2, 2018 Due Date DATE DESCRIPTION AMOUNT IX Ading in Herald during Seber 2011 SUBTOTAL $700.00 Business Number 044122338 YORAL MAKE ALL CHECKS PAYABLE TO TAMPA HERALD 5700.00 Required Work for April 1. Journaline transactions and post to prcco. 2. Prepare a trial balance in the first two columns of the worksheet and complete the worksheet using the following adjustment dans One month's rene had expired. An inventory shows $150 of office supplies remaining Depreciation on office equipment, $170. 4 Depreciation on automobile, 500 5. Prepare an April income statement, statement of owner's quity and balance sheet. From the worksheet, journal and post adjusting and designere ip 3 of journal Prepare a post-doing trial balance. During May Sherman Realey completed these transaction May 1 The Office Store INVOICE DATE Los ACA 005 SOLD TO SHED TO Los Angeles, CA 900 DATE DECEPTION AMOUNT WRC MacBook Mini Practice Set Est. Time: 5 hours Sherman Realty Reviewing the Accounting Cycle Twice This comprehensive review problem requires you to complete the accounting cycle for Sherman Realty twice. This practice set allows you to review Chapters 15 while reinforcing the relationships between all parts of the accounting cycle. By completing two cycles, you will see how the ending April balances in the ledger are used to accumulate data in May. First, look at the chart of accounts for Sherman Realty Sherman Realty Chart of Accounts Assets 111 Cash 112 Accounts Receivable 114 Prepaid Rent 115 Office Supplies 121 Office Equipment 122 Accumulated Depreciation, Office Equipment 123 Automobile 124 Accumulated Depreciation, Automobile Revenue 411 Commissions Earned Expenses 511 Rent Expense 512 Salaries Expense 513 Gas Expense 514 Repairs Expense 515 Telephone Expense 516 Advertising Expense (continued on here) 180 180 CHAPTER 5 The Accounting Cycle Completed Liabilities 211 Accounts Payable 212 Salaries Payable Owner's Equity 311 Jacob Sherman, Capital 312 Jacob Sherman, Withdrawals 313 Income Summary 517 Office Supplies Expense 518 Depreciation Expense, Office Equipment 519 Depreciation Expense, Automobile 524 Miscellaneous Expense On April 1, 201X, Jacob Sherman opened a real estate office called Sherman Realty The following transactions were completed for the month of April: 2017 Aprili Jacob Sherman invested $14.000 cash in the real estate agency along with $9.000 of office equipment DEPOSIT TICKET CURRENCY MOLDO CASH SHERMAN REALTY (213) 478-3584 8200 SUNSET BOULEVARD Los Angeles, CA 90028 TOTAL RESU DATE_April 1 201x TOTAL 14.000 DO LES CAREERVED MET DEPOSIT 14,000.00 BAY BANK Box 1739 Terminal Annex Los Angeles, CA 90052 6122000661400-03857-01362 April Rented and paid 4 months' rent in advance to Mclay Property Management, 53.600 SHERMAN REALTY (213) 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 1 0001 201X ORDER OF $ TO BE McLay Property Mgmt Co. Three Thousand six Hundred 3,6008 DOLLARS BAY BAK Box 17 Tres Los Angeles, CA DOO LEWO Rent April July 2014 Jacob Sherman CHAPTER 5 The Accounting Cycle Completed 181 April: Bought an automobile on account from Jeep East, 314,000 INVOICE Jeep East 1 Salem S1 Los Angeles, CA 90052 (213) 639-1917 INVOICE NO. 1113 DATE A VIX TERMS NO To: SHERMAN REALTY 8200 Sunset Blvd Los Angeles, CA 90028 UNIT PRE AMOUNT QUANTITY 1 ONLY DESCRIPTION Automatic 51400000 314,000.00 14,000.00 Make checks payable to Jeep East SUBTOTAL FREIGHT TAK TOTAL DUE THANK YOU FOR YOUR BUSINESS 514.000.00 April Purchased office supplies from The Office Store, for cash, 5100 The Office Store 1 Fermero Los Angeles, CA 90052 Phone212) 631-020 SOLD TO Sherman Realty 1200 S Blvd. Los Angeles, CA 90028 INVOICE DATE AIX NUMBER TERMS Cash SHIPPED TO Shaman Ray 1200 Sunset Los Angeles, CA 90028 DATE DESCRIPTION UNIT PRICE AMOUNT 00.00 AIXO ples PARECIDO 10002 YOU Bus Number SSS THANK YOU FOR YOUR BUSINESS REASE PAY SHERMAN REALTY 013-3584 200 SUNGET BOULEVARD LOS ANGELES, CA coce 201X $ GRENS The office Store Nine Hundred and 900 non Sim -00 000 000 s II 182 182 CHAPTER 5 The Accounting Cycle Completed April Purchased additional office supplies from The Office Store, on account, 5450 INVOICE DATE April 5/1 NUMBER DAS TERMS: 60 The Office Store 1 Fercroft Rd. Los Angeles, CA 90052 Phone (213) 691-0288 SOLD TO Sherman Realty 8200 Sunset Blvd. Los Angeles, CA 90028 SHIPPED TO: Sherman Realty 8200 Sunset Blvd. Los Angeles, CA 90028 DATE DESCRIPTION UNIT PRICE AMOUNT 450.00 Art. 51% Omice supplies Sub 450.00 5450.00 Total Business Number: 115555559 THANK YOU FOR YOUR BUSINESS PLEASE PAY THE ABOVE April Sold a house to Bryce Lyman and collected $6.500 commission DEPOSIT TICKET QUY SA REALTY 1213) 478-3564 8200 SUNSET BOULEVARD Los Angeles, CA 90028 warto April 6 201X BAT BAIK Box 173 Terminal Anne Los Angeles, CA 90052 4.22000 IL00-03857016 SHEMALT COMMON RIPORT CHAPTER 5 The Accounting Cycle Completed 183 April Pald gas bill to Harvey Petroleum Gas Co., 525. SHERMAN REALTY (213) 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 8 0003 201X 25 PRY TO THE OPC Dr Harvey Petroleum Gas Co. Twenty-Five and its BAY BANK Box 1730 Terminal Annex Los Angeles, CA 90052 MEMO Gas Blu - April 6 DOLLARS Jacob Sherman Agri 15 Paid Tessa Hardy, office secretary, 5550. 0004 SHERMAN REALTY (213) 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 15 201X 0 Teosa Hardy ORDER OF $ 5506 DOLLARS Five Hundred Fifty and BY DA Box 1739 Terminal ex Los Angeles, CA 90052 MO Salary - April 1-15 Jacob Sherman April 17 Solid building lotto Wetland Developers and med en 17.500 payment to be received on May RUN BERTY COMMISSION REPORT Wetland Developers De Ar 2014 A Ramay. 2018 184 184 CHAPTER 5 The Accounting Cycle Completed April 20 Jacob Sherman withdrew 53.000 from the business to pay personal expenses SHERMAN REALTY 2139 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 0005 201X April 20 $ 3,000 DOLLARS PY TO THE Jacob Sherman OF Three Thousand and to BAYBANK Box 1730 Terminal Annex Los Angeles, CA 90052 ME Withdrawal Jacab skerman April Sold a house to Mary Dappler and collected a 58.000 commission DEPOSIT TICKET GUENCY CA SER REALTY 02133 478-3584 8200 SUNSET BOULEVARD Los Angeles, CA 90028 are B.DOC DO Dr_April 21 201X 6.000.00 BAT B Box 173 Terial nec Los Angeles, CA 90052 2200000-385T-0116 SERMAN RIALTY COMMISSON REPORT Duter Apr 2013 Bule La co 185 CHAPTER 5 The Accounting Cycle Completed 185 April 2 Pall to Harvey Petroleum Gamla SHERMAN REALTY 213478-3564 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 22 0006 200X 90% Cree Or Harvey Petroleum Gap Ca Ninety and BAYBANK Box 1739 Teile Los A CABOS O Gas Bil-April 22 DOLLAS Jacob Shereas AN Puldeep C 450 to repair tomobile INVOICE Jeep 1 Salem Los Angeles, CA 902 213, 6.9.1917 INVOICE NO.14 DATE: 2016 Cash | Ship to Tek SHERMAN REALTY 8200 Surov Los Angeles, CA CON UNCE re AMOUNT . OMY PAYMENT RECEVEDO TA THANK YOU FOR YOUR BUSINESS BOOT SHERMAN REALTY 013473-554 O SUNGET BOULEVARD LOS ANGELES, CA Aprill 24 2014 $ 400 CHORD Jeep East Four Hundred Fifty and Auten 164 Pacar Shorts -MacBook 80 000 DI F8 DD 59 TVO F7 F6 F3 F4 F5 A % & 186 186 CHAPTER 5 The Accounting Cycle Completed April 30 Paides Handy office secretary, 1950. 0008 SHERMAN REALTY 13 478-3584 8200 SUNSET BOULEVARD LOS ANGELES, CA 90028 April 30 2017 550 TO THE remor Tessa Hardy Five Hundred Fifty and BAYBANK Box 173 Terminal Arvex Los Angeles, CA 90052 MEMO Salary - April 16-20 DOLLARS Jacob Sherman Art Paidage Agritulephone, 1200 Vonage Park Place Los A CAROOS Your Statement SHERMAN REALTY 8000 Sunnet Loa + CA 0447 Payment received April 30, 2018 And Total Due SHERAN REALTY 13 47-5 0000 00 SUNSET BOULEVARD LOS ANO, CA008 April 30 2014 GCC Vortage $ 2004 Two Hundred and BV Jacob Sherman MacBook 000 8 DI D 187 CHAPTER 5 The Accounting Cycle Completed 187 April 30 Received advertising bill for Agri, 5700, fronterad. The is to be paid on May 2. Tampa Herald 1 Long Tanpa Haride, IL (2) 10-1000 INVOICE SOLD TO: Inveice Na Shermany 8200 Sunset Los Angeles, CA 0028 4809 April 2013 May 2, 2018 Due Date DATE DESCRIPTION AMOUNT IX Ading in Herald during Seber 2011 SUBTOTAL $700.00 Business Number 044122338 YORAL MAKE ALL CHECKS PAYABLE TO TAMPA HERALD 5700.00 Required Work for April 1. Journaline transactions and post to prcco. 2. Prepare a trial balance in the first two columns of the worksheet and complete the worksheet using the following adjustment dans One month's rene had expired. An inventory shows $150 of office supplies remaining Depreciation on office equipment, $170. 4 Depreciation on automobile, 500 5. Prepare an April income statement, statement of owner's quity and balance sheet. From the worksheet, journal and post adjusting and designere ip 3 of journal Prepare a post-doing trial balance. During May Sherman Realey completed these transaction May 1 The Office Store INVOICE DATE Los ACA 005 SOLD TO SHED TO Los Angeles, CA 900 DATE DECEPTION AMOUNT WRC MacBook
