Refer to the accounting information for Bonnie's BattingCages (page 2 onwards)ASSETS1. Using the T-accounts template (see attachment fromfolder), set up the T-accounts with the balances from theBalance Sheet below.2. Input the transactions below into each account.*** (Use a transaction reference number as a note)3. Calculate the balance of each account at the end of theApril transactions. Use the function feature of yourspreadsheet.4. Create a trial balance to make sure your debits = credits.Use the template provided in the 2nd tab in thespreadsheet.5. Create a new Balance Sheet dated April 30, 2023. Usethe template provided in the 3rd tab in the spreadsheet.AssetsT_accountsAssetsAccountBankBonnie's Batting Cages and Softball ServicesBALANCE SHEETMarch 31, 2023Accounts Receivable- Infield FlyersRemdal Red SoxSuppliesEquipmentTotal Assets$ 56 4503.300150013 50052 000$126 750T_accounts Trial BalanceLiabilitiesAccounts Payable-Cannon SportsTrial BalanceT_accounts Trial Balance- Ewert Equipment- Sandhu Sporting GoodsBank LoanTotal LiabilitiesOwner's EquityB. Birch, CapitalTotal liabilities and Owner's Equity$ 20 00032 000Transactions for March:1. B. Birch, the owner, invested $40 000 in the business.2. Borrowed $45 000 from the bank, which was deposited inthe business' bank account.3. Paid $7 500 to Turtle Dove Properties Ltd. for the monthlyandrent.25004. Purchased office and various sport supplies for $6 000cash.5. Purchased $13 000 worth of bats, helmets, and other sportsequipment from Cannon Sports on account. The amount isdue in 30 days.45 0006. Bought pitching machines from Ewert Equipment for $12000 on account and have 30 days to pay.7. Bought $8 800 of miscellaneous sports supplies onaccount from Sandhu Sporting Goods.8. Sold a one-month team membership to the Infield Flyersfor $1 300 on account. The amount is to be received in 151DR$99 500days.Salda9. Sold a two-month team membership to the Remdal RedSox for $2 600 on account. The bill is due in 30 days.10. Cash sales for the month amounted to $7 200.11. Bank charges for services fees and interest amounted to$550, which was taken directly out of the business' bankaccount.Liabilities27 250$126 750Owner's EquityBalance SheetBalance SheetLIABILITIESCRBalance SheetOWNER'S EQUITY

T accounts It is an informal term for a set of a financial records that uses double-entry…

Refer to the accounting information for Bonnie's Batting Cages (page 2 onwards) 1. Using the T-accounts template (see attachment from folder), set up the T-accounts with the balances from the Balance Sheet below. ASSETS 2. Input the transactions below into each account. *** (Use a transaction reference number as a note) 3. Calculate the balance of each account at the end of the April transactions. Use the function feature of your spreadsheet. 4. Create a trial balance to make sure your debits = credits. Use the template provided in the 2nd tab in the spreadsheet. 5. Create a new Balance Sheet dated April 30, 2023. Use the template provided in the 3rd tab in the spreadsheet. _accounts Assets Bank Bonnie's Batting Cages and Softball Services BALANCE SHEET March 31, 2023 Accounts Receivable -Infield Flyers Remdal Red Sox Supplies Equipment Total Assets $56 450 3.300 1500 13 500 52 000 $126 750 Liabilities Accounts Payable -Cannon Sports -Ewert Equipment - Sandhu Sporting Goods Trial Balance Bank Loan Total Liabilities Owner's Equity B. Birch, Capital Total liabilities and Owner's Equity $ 20 000 32 000 2500 45 000 $99 500 27 250 $126 750 Transactions for March: 1. B. Birch, the owner, invested $40 000 in the business. 2. Borrowed $45 000 from the bank, which was deposited in the business' bank account. 3. Paid $7 500 to Turtle Dove Properties Ltd. for the monthly rent. 4. Purchased office and various sport supplies for $6 000 each cash. 5. Purchased $13 000 worth of bats, helmets, and other sports equipment from Cannon Sports on account. The amount is due in 30 days. 6. Bought pitching machines from Ewert Equipment for $12 000 on account and have 30 days to pay. 7. Bought $8 800 of miscellaneous sports supplies on account from Sandhu Sporting Goods. 8. Sold a one-month team membership to the Infield Flyers for $1 300 on account. The amount is to be received in 15 days. P 9. Sold a two-month team membership to the Remdal Red DOX Sox for $2 600 on account. The bill is due in 30 days. 10. Cash sales for the month amounted to $7 200. 11. Bank charges for services fees and interest amounted to $550, which was taken directly out of the business' bank account. Balance Sheet LIABILITIES OWNER'S EQUITY