Can you help me put these transactions into the T Accounts? I have to use the equation =(SUM A-B) A and B change. I also have to do the trial balance statements and balance statement I have an example.To plug in the number in the trial balance statement and balance statement I have to use the equation ='T Accounts'!A$26 A and 26 change.

IBT - Accounting Test/Project Dr. Christy Russo maintains an office for the practice of veterinary medicine. The account balances as of September 1 are given below. All are normal balances. Assets Cash $ 2,459 Accounts Receivable 18,120 Prepaid Insurance 980 Expenses Automobile 20,650 Salary Expense 14,380 Furniture and Equipment 5,963 Rent Expense 10,320 Automobile Expense 859 Utilities Expense 1,213 Supplies Expense 840 Liabilities Accounts Payable 1,590 Revenue Professional Fees $72,118 Owner's Equity C. Russo, Capital 42,076 C. Russo, Drawing 40,000 The following transactions occurred during September of this year. a. Paid rent for the month, $1,290. b. Paid $1,800 for one year's coverage of liability insurance. c. Bought medical equipment on account from Bennett Surgical Supply, $849, paying $200 down with the balance due in thirty days. d. Billed patients for services performed, $9,015. e. Paid employee salaries, $1,797. f. Received and paid gas and electric bill, $112. g. Received cash from patients previously billed, $11,060. h. Received and paid a bill for gasoline for car, used only in the professional practice, from Garza Fuel Company, $116. i. Paid creditors on account, $1,590. j. Dr. Russo withdrew cash for personal use, $5,000. Instructions: 1. Open up a new Excel Workbook. 2. Create \"T\" Accounts 3. Analyze all transactions 4. Create Trail Balance Sheet 5. Create Ending Balance Sheet \fAssets Debit Increase Decrease Cash 2549 9015 11060 22624 10719 A/R 18120 1290 1800 200 1797 112 116 1590 5000 11905 9015 11060 Prepaid Insurance 980 1800 Automobile 20650 Salary Expense 14380 C.Russo, Drawing 40000 5000 = Liablities Credit Decrease Furniture &Equipment A/P 1590 5963 849 Rent Expense 10320 1290 Automobile Expense 859 116 Utilities Expense 1213 112 Supplies Expense 840 1590 1797 + Owner's Equity Credit Decrease Professional Fees 72118 C. Russo, Capital 42076 Russo Computing Trial Balance Statement April 25,2017 DR CR Account Cash A/R Prepaid Insurance Automobile Salary Expense Furniture & Equipment Rent Expense Automobile Expense Utilities Expense Supplies Expense A/P Professional Fees Capital Drawing TOTAL Assets Cash A/R Prepaid Insurance Automobile Salary Expense Furniture And Equipment Rent Expense Automobile Expense Utilities Expense Supplies Expense C. Russo, Drawing Total Assets Russo Computing Balance Statement April 25,2017 Liabilties A/P Owner's Equity Professional Fees C. Russo, Capital Total Liabilites and Equity \fAssets Debit Increase Decrease Cash 2459 11060 1290 1800 200 1797 112 116 1590 5000 1614 = Liablities Credit Decrease Furniture &Equipment A/P 1590 5963 849 6812 Rent Expense 10320 1290 11610 A/R 18120 9015 11060 16075 Automobile Expense 859 116 975 Prepaid Insurance 980 1800 Utilities Expense 1213 112 2780 1325 Automobile 20650 Supplies Expense 840 20650 840 Salary Expense 14380 1797 16177 C.Russo, Drawing 40000 5000 1590 649 649 45000 + Owner's Equity Credit Decrease Professional Fees 72118 9015 81133 C. Russo, Capital 42076 42076 Russo Computing Trial Balance Statement April 25,2017 Account DR CR Cash 1,614 A/R 16,075 Prepaid Insurance 2,780 Automobile 20,650 Furniture & Equipment 6,812 A/P 649 Capital 42,076 Drawing 45,000 Professional Fees 81,133 Salary Expense 16,177 Rent Expense 11,610 Automobile Expense 975 Utilities Expense 1,325 Supplies Expense 840 TOTAL 123,858 123,858 Assets Cash A/R Prepaid Insurance Automobile Salary Expense Furniture And Equipment Rent Expense Automobile Expense Utilities Expense Supplies Expense C. Russo, Drawing Total Assets Russo Computing Balance Statement April 25,2017 Liabilties 1,614 A/P 16,075 2,780 Owner's Equity 20,650 Professional Fees 16,177 C. Russo, Capital 6,812 11,610 975 1,325 840 45,000 123,858 Total Liabilites and Equity 649 81,133 42,076 123,858