Using the t-accounts template, open (set up) the t-accounts with the balances from the balance sheet (located in the first worksheet in the attached template).
use the t-accounts template and input the following 17 transactions into each account.
calculate the balance of each account. use excel's function feature.
prepare a trial balance based on your account balances from the ledger (located in the third worksheet at the bottom of the spreadsheet).
chart of accounts

bonnie's batting cages and softball services

account number
account
account number
account
105
bank
305
b. birch, capital
110
a/r – infield flyers
310
b. birch, drawings
115
a/r – remdal red sox
405
membership fees
120
supplies
410
cash sales
125
equipment
505
bank charges expense
205
a/p – cannon sports
510
heating expense
210
a/p – ewert equipment
515
rent expense
215
a/p – sandhu sporting goods
520
repair expense
220
bank loan
525
wages expense
transactions for august

bonnie birch, the owner, invested $40 000 in the business.
borrowed $15 000 from the bank, which was deposited in the business' bank account.
paid $1 500 to romeyn properties ltd. for the monthly rent.
bought office and various sport supplies for $2 000 cash.
purchased $43 000 worth of bats, helmets, and other sports equipment from cannon sports on account. the amount is due in 30 days.
paid $800 cash for the heating bill received today.
bought pitching machines from ewert equipment for $12 000 and have 30 days in which to pay.
equipment was repaired ($350) from ewert equipment and will be paid for later.
bought $7 800 of miscellaneous sports supplies on account from sandhu sporting goods.
sold a one-month team membership to the infield flyers for $800 on account. the amount is to be received in 15 days.
sold a two-month team membership to the remdal red sox for $2 200 on account. the bill is due in 30 days.
cash sales for the month amounted to $40 200.
bank charges for services fees and interest amounted to $250, which was taken directly out of the business' bank account.
paid $2 200 cash for monthly wages.
sold a one-month membership cash for $1 300.
paid the full amount to ewert equipment from transaction 8 ($350).
owner withdrew $1 000 for personal use.