how do i turn this information into a trial balance?
April 30 Received advertising bill for April, $700, from Tampa Herold. The bill is to be paid on May 2. Tampa Herald 1 Long Rd., Tampa Florida, IL 60527 (352) 744-1000 INVOICE SOLD TO: Sherman Realty 8200 Sunset Blvd. Los Angeles, CA 90028 Invoice No.: 4879 Date: April 30, 2017 Due Date: May 2, 2018 AMOUNT DATE DESCRIPTION April 26/1x Advertising in Tampa Herald during September 2017 SUBTOTAL $707.00 700.00 TOTAL Business Number 944122338 MAKE ALL CHECKS PAYABLE TO TAMPA HERALD $700.00 Required Work for April 1. Journalize transactions and post to ledger accounts. 2. Prepare a trial balance in the first two columns of the worksheet and complete the worksheet using the following adjustment data: a. One month's rent had expired. b. An inventory shows $150 of office supplies remaining, c. Depreciation on office equipment, $170. d. Depreciation on automobile, $300, 5. Prepare an April income statement, statement of owner's equity, and balance sheet. From the worksheet journalive and reading and closing entries in 3 of iournal Check Figure: April Post-Closing Trial Balance $52,485 6 Chapter 5: The Accounting Cycle Completed d. Depreciation on automobile, $300. 5. Prepare an April income statement, statement of owner's equity, and balance sheet. 6. From the worksheet, journalize and post adjusting and closing entries (p. 3 of journal). Prepare a post-closing trial balance. During May, Sherman Realty completed these transactions: Apnt Post-Llosin 552,485 May 1 Purchased additional office supplies on account from The Office Store, $900. The Office Store 1 Ferncroft Rd. Los Angeles, CA 90052 Phone (213) 631-0288 SOLD TO: Sherman Realty 8200 Sunset Blvd. Los Angeles, CA 90028 INVOICE DATE: May 1/1X NUMBER: D1996035 TERMS: Net 60 SHIPPED TO: Sherman Realty 1 8200 Sunset Blvd. Los Angeles, CA 90028 DATE DESCRIPTION UNIT PRICE AMOUNT May 1/1x Office supplies $900.00 Subtotal 900.00 Total $900.00 Business Number: 115555559 PLEASE PAY THE ABOVE THANK YOU FOR YOUR BUSINESS DETAILED INSTRUCTIONS - PARTI: 1. Journalize and post the April transactions (pages 180 - 187 in the textbook) in the General Journal and General Ledger areas of the workpapers. 2. Prepare a workshoet for April using the adjustment information on page 187 of the textbook 3. Prepare an income statement, statement of owner's equity, and balance sheet for April. 4. Journalize and post the adjusting and closing entries for April 5. Prepare a post-closing trial balance for April 6. Complete the Part 1 Self-Reflection 7. Submit the self-relection and work papers for grading in D2L. Check Pius://you have posted everything correctly, you should have an ending cash flance and wil0/819.735 and a trial balance 500.130
