i need help with all three; Journalizing, creating a trial balance, and then the financial statements
A. On the first tab of Excel, which is labeled Journal, journalized the following 14 transactions. (Some are on the next page, so don't miss them.) B. On the second tab of Excel, which is labeled Ledger, post each of the journalized transactions to the appropriate ledger accounts. Don't forget to put the correct journal page number in the post reference of the ledger ( 1 or 2 ), and bring back and post the correct account number in the post reference on your Journal. You will find he account numbers in the upper right corner of each account. For the dates, you only have to type the number. Don't forget that some accounts carry a debit balance (the credit column will stay blank) and some accounts carry a credit balance. (The debit column stays blank.) C. On the third tab of Excel, which is labeled Statements, complete the trial balance, the income statement, the statement of owner's equity, and the balance sheet. Don't forget that the statement of owners equity will have an opening balance of zero on April 1 . When you type 0 , it may not show up in Excel but just show you a small line - . Here are your 14 transactions: 1. April 1 T. Sanchez invests $20,000 into the business. 2. April 5 Sold $7500 of services on account. (Professional Fees). 3. April 7 Paid advertising expense, check number 1001,$250. 4. Aprit 8 Bought supplies on account from Taylor supply, invoice number 2340,$420. 5. April 9 Performed services for cash $2530. 6. April 15 Paid utility bill, check number 1002,$280. 7. April 17 Bought office furniture on account from Lewis furniture with a down payment of $300. Check number 1003 . The balance is on account. Total amount of office furniture $1800. 8. April 20 Bought liability insurance, check number 1004,$1800. 9. April 21 Paid rent for the month, check number 1005,$1000. 10. April 25 Paid Taylor supply on account, check number 1006,$420. 11. April 27 Received payment from R. Miller on account $7500. 12. April 28 Paid telephone bill, check number 1007,$150. 13. April 29 Paid office assistant salary, check number 1008,$1030. 14. April 30 Withdrew cash for personal use, check number 1009,$3000