***PLEASE DO IT ON EXCEL***

Record the following transactions on a petty cash sheet. All petty cash vouchers will be numbered sequentially, beginning with #1. Ask your instructor which of the following tax rates to use: i.No taxes ii.Add 5% GST only iii.Add 13% HST iv.Add 5% GST + 7% PST 20Nov. 1 The fund was started with $200. 1 Bought pads of writing paper for office, $27.70 3 Paid for delivery of above stationery, $5.78 4 Bought special order of merchandise, $13.14. 4 Paid for delivery of the above special order of merchandise by courier, $5.25 5 Bought sugar and cream for staff kitchen, $4.50 (no taxes). 6 Paid for minor repairs to office furniture, $18.06. (Debit Repairs Expense) 6 Paid ABC Courier for delivering merchandise to customer, $7.35. 7 Bought packaging materials for warehouse, $28.35. 10 Paid for printing of advertising flyers, $32.55. 17 Paid for delivery of incoming merchandise, $11.98. 21 Contributed $20 to Heart & Stroke Foundation (no taxes). (b)Total all columns and prove equal debits and credits. Calculate the cash on hand. (c)Make an entry in the Cash Payments Journal to establish the fund on November 1. Cheque #130 was issued. (d)Make an entry in the Cash Payments Journal for the reimbursement of the fund on November 30. Cheque #149 was issued. PRACTICE EXERCISE 3 (a)Set up a petty cash sheet for the month of June. The amount of the fund is $150. All vouchers are numbered in sequence, beginning with #41. (b)Enter the following transactions on the petty cash sheet. Assume that all amounts include tax(es). Ask your instructor which of the following tax rates to use: i.Amounts include 5% GST only ii.Amounts include 13% HST iii.Amounts include 5% GST + 8% PST 20Jun. 1 Paid shipping charges for two new office chairs, $18.90. 2 Paid freight charges on incoming merchandise, $7.88. 6 Bought stationery and supplies for office, $28.14. 8 Paid Speedy Courier for delivering merchandise to customer, $17.01. 12 Bought postage stamps for office, $10.50. 14 Bought coffee cups for staff room, $3.47. 17 Bought packaging and tape for warehouse, $9.87. 21 Bought straws and paper napkins for staff room, $2.63. 23 Bought stamps for mailing advertising material, $11.55. 29 Gave donation to the Cancer Society, $25 (taxes not applicable). (c)Total the columns and prove equal debits and credits. Calculate the cash on hand. (d)Prepare a Cash Payments Journal entry to reimburse the petty cash fund. The reimbursing cheque is #97, dated June 30.