Make a 10 column worksheet in this format along with income statement and balance sheet

ACC/ACF1100 Assignment #: 761 Proprietor: Dr. Furball Fixer Name: Best Friends Vet Clinic Description: Animal Surgery The business has the following opening balances: Additional Information: Cash At Bank Account Receivable Motor Vehicle Bank loan interest rates (% per year) Motor vehicle useful life (years) Motor vehicle scrap value ($) Insurance paid for (months) Rent paid for (months) Account Payable Bank Loan (due 2022) Medical Equipment Office Supplies Medical Supplies Capital Medical equipment useful life (years) Medical equipment scrap value ($) Closing stock of office supplies on 30/6 ($) Closing stock of medical supplies on 30/6 ($) Staff work a 14 day fortnight and are paid on the 15th day. Transactions: Date Description Date Description 1-Jun Paid General Insurance $2,001 3-Jun Pet consultation - Account $1,387 3-Jun Rent of Business Premises $3,035 4-Jun Purchase medical supplies - Account $566 5-Jun Vaccination - Cash $1,323 5-Jun Pet consultation - Cash $2,192 6-Jun Sundry Expenses $395 7-Jun Purchase office supplies - Account $883 7-Jun Receive Payment from Account Customers $1,001 8-Jun Vaccination - Account $853 9-Jun Desexing - Cash $2,918 9-Jun Advertising Expense - Cash $969 11-Jun Desexing - Cash $2,143 12-Jun Cash Withdrawals by Owner $1,133 13-Jun Advertising Expense - Account $1,321 13-Jun Vaccination - Cash $1,381 14-Jun Pet consultation - Cash $2,178 15-Jun Staff Wages $2,336 17-Jun Receive Payment from Account Customers $1,126 20-Jun Vaccination - Account $706 23-Jun Pet consultation - Account $1,457 23-Jun Purchase medical supplies - Cash $347 25-Jun Additional cash contributed by owner $2,606 26-Jun Payment to Account Payable $960 27-Jun Motor Vehicle Expenses $429 28-Jun Payment to Account Payable $566 29-Jun Staff Wages $2,336 Comments: - Assume that this assignment involves an existing business that was purchased by the new owner on 1 June 2019. - Note the list of transactions is in date order, left to right, line by line. - Use three separate ledger accounts for revenue, namely pet consultation, vaccination and desexing fees. All revenues relate to the month of June. - Transactions involve cash unless specified as "Account". - Record payments for rent and insurance in prepaid accounts initially. - Information relevant to complete adjusting entries can be found in the top right section of this page. - The periods to which the rent and insurance apply commence on 1 June. - Round your calculations to the nearest dollar. $17,161 $16,273 $38,303 $9,883 $24,104 $31,845 $658 $1,781 ? Amount 11 3 3,571 4 3,575 921 2,047 Amount Account Names Dr Trial Balance Cr Dr Dr. Furball Fixer's Best Friends Vet Clinic As at 30 June 2019 Adjustments Cr Adjusted Trial Balance Cr Dr Income statement Dr Cr Dr Balance Sheets Cr