Can you help me with putting these transactions into T Accounts and also help with the trial balance statement and balance statement?

Accounting Practice Assignment Judy Schmidt, M.D., has been practicing as a pediatrician for three years. During the month of June, she completed the following transactions in her practice of pediatrics: June 1. Paid office rent for June, $600. 2. Purchased equipment on account, $2100. 5. Received cash on account from patients, $4150. 8. Purchased X-ray film and other supplies on account, $145. 9. One of the items of equipment purchased on June 2 was defective. It was returned with permission of the supplier, who agreed to reduce the account of the amount charged for the item, $125. 12. Paid cash to creditors on account, $1250. 16. Sold X-ray film to another doctor at cost. Received cash, $63. 17. Paid cash for renewal of property insurance, $370. 20. Discovered that the balance of the cash account and of the accounts payable account as of June 1 were overstated by $50. A payment of that amount to a creditor in May had not been recorded. Make a $50 adjustment to the appropriate accounts. 23. Paid cash for lab analyses, $245. 27. Recorded cash from business bank account for personal and family expenses, $1250. 30. Recorded the cash received in payment of services (cash paying patients) to patients during the month of June, $1720. 30. Paid salaries of receptionist and nurses, $1725. 30. Paid gas and electricity expense, $157. 30. Paid water expense, $29. 30. Recorded fee charged to patients on account for services performed in June, $4145. 30. Paid telephone expense, $74. 30. Paid miscellaneous expenses, $132. Dr. Schmidt's account titles and opening balances as of June 1 are listed as follows: Cash-$3,123; Accounts Receivable-$6725; Supplies-$290; Prepaid Insurance-$365; Equipment-$19,745; Accounts Payable-$765; Capital-$29,483; Judy Schmidt, Drawing-$0; Professional Fees-$0; Salary Expense-$0; Rent Expense-$0; Lab Expense-$0; Utilities Expense-$0; Misc. Expense-$0. Assignment Instructions: 1. 2. 3. 4. 5. 6. 7. 8. 9. Open up a new Excel Spreadsheet and label the first tab 'T Accounts'. Create/open T accounts for all of the above accounts adding their opening balances. Analyze and enter all of the transaction for the month of June. Close all accounts for the month of June. Label the second tab 'Trail Balance Statement'. Create and properly format a Trail Balance Statement. Label the third tab 'Balance Statement'. Create and properly format a Balance Statement. Unload your spreadsheet to the Dropbox. Assets Debit Increase Decrease Cash 3123 4150 63 -50 1720 600 2100 145 1250 370 245 1250 Rent Expense 0 600 = Liablities Credit Decrease Equipment 19745 2100 125 A/R 6725 A/P 125 4150 Schmidt, Drawing 0 1250 Supplies 290 145 Lab Expense 0 63 245 Utilities Expense 0 Prepaid Insurance 365 370 Misc. Expense 0 765 1250 -50 + Owner's Equity Credit Decrease Capital 29483