The following data represents information necessary to assist in preparing the December 31, 2022 bank reconciliation for Hard Work Company.

The December 31 bank balance was $5,770.

The bank statement indicated a deduction of $23 for all bank service charges.

A customer deposited $1,240 directly into the bank account to settle an outstanding accounts receivable bill.

Cheque #559 for $800 and cheque #566 for $560 have been recorded in the company ledger but did not appear on the bank statement.

A customer paid an amount of $4,487 to Hard Work Company on December 31 but the deposit did not appear on the bank statement.

The accounting clerk made an error and recorded a $170 cheque as $1,700. The cheque was written to pay an outstanding accounts payable account.

Cheque #9606 for $140 was deducted from Hard Work Company's account by the bank. This cheque was not written by Hard Work Company and needs to be reversed by the bank.

The bank included an NSF cheque in the amount of $400 relating to a customers payment. The NSF fee was $14.

The general ledger cash account showed a balance of $6,704 on December 31.

Required a) Complete the bank reconciliation for Hard Work Company. b) Write the necessary journal entries to correct Hard Work Company's records.

Do not enter dollar signs or commas in the input boxes. Do not use negative signs.

a)

Hard Work Company Bank Reconciliation December 31, 2022
Cash balance per bank statement		Answer	Cash balance per books		Answer
Add			Add
Outstanding deposit	Answer		EFT deposit	Answer
Bank error	Answer	Answer	Ledger error	Answer	Answer
Deduct outstanding cheques			Deduct
Cheque #559	Answer		NSF cheque	Answer
Cheque #566	Answer	Answer	NSF service charge	Answer
			Bank service charge	Answer	Answer
Adjusted bank balance		Answer	Adjusted book balance		Answer

Enter the relevant journal entries in the order of transaction appearance above. Remember, not all transactions will require journal entries.

b)

Date	Account Title and Explanation	Debit	Credit
2022
Dec 31	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue	Answer
	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue		Answer
	To record bank charges
Dec 31	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue	Answer
	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue		Answer
	To record collection of accounts receivable
Dec 31	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue	Answer
	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue		Answer
	To correct the record of accounts payable
Dec 31	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue	Answer
	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue		Answer
	To record NSF cheque
Dec 31	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue	Answer
	AnswerAccounts PayableAccounts ReceivableBank Charges ExpenseCashCost of Goods SoldEquipmentInsurance ExpenseInterest ExpenseInterest PayableInterest RevenueSalaries ExpenseSales RevenueUnearned Revenue		Answer
	To record NSF Fee