Situation: You are an accounting clerk working at Hardware A, you are responsible for the management of the petty cash. You must create a petty cash fund.

Open the Excel petty cash register and enter transactions below in the table. Total columns: enter formulas for sums and subtractions. Save the Excel file as exercisepettycash2 and submit in Moodle when finished.

1. Determine the amount of the cheque No. 45 for replenishing at $200.00 if the balance of the petty cash at the end of the week was $49.50

Here are the transactions of the first week of the month.

a) June 1, 2020, - deposit in the account petty cash of an amount of $200.00, for the constitution of the Fund. This amount comes from the bank account.

b) June 2, - release of funds for purchase of office supplies, the amount before taxes $13.91,

c) On 3 June, delivery expense $ 6.08 before taxes.

d) June 4, - gas expense for delivery truck, amount before taxes $34.79

e) June 5, - expense for a small celebration with customers of the Hardware: cost of promotion and representation, amount before taxes $51.41

f) June 5 - taxi expenses $26.10 before taxes

Prepare journal entries in the attached General Journal to record these transactions and to replenish the petty cash on June 8th 2020.

Here is the partial chart of accounts.

Italian Cafe

Partial chart of accounts

June 1st 2020

1200	Bank
1210	Petty cash
1240	GST on purchase
1250	QST on purchase
4995	Petty cash Surplus
5110	Office supplies
5120	Delivery expense
5130	Gas expense
5140	Promotion and representation
5150	Miscellaneous expenses (taxi)
5995	Petty cash Deficit