On July 31, 2024, Oriole Company had a cash balance per books of $6,495.00. The statement from Canada Bank on that date showed a balance of $7,740.00. A comparison of the bank statement with the Cash account revealed the following facts:

1.		The bank service charge for July was $30.00.
2.		The bank collected $2,370.00 of rental revenue for Oriole Company through electronic funds transfer.
3.		The July 31 receipts of $1,210.00 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31.
4.		The June 30 deposit of $2,490.00 was not included in the June bank statement. This amount was included in the July statement.
5.		Company cheque No. 2480 issued to M. Brown, a creditor, for $350.00 that cleared the bank in July was incorrectly entered as a cash payment on July 10 for $305.00.
6.		Cash sales of $875.00 on July 28 were deposited in the bank. The journal entry to record the cash receipt and the deposit slip were incorrectly made out and recorded by the bookkeeper as $785.00. The bank detected the error on the deposit slip and credited Oriole Company for the correct amount.
7.		Cheques #2483 for $850.00, #2485 for $570.00, and #2488 for $440.00 were outstanding on July 31.
8.		On July 31, the bank statement showed an NSF charge of $800.00 for a cheque received by the company from H. Miller, on account. Included in this amount was a $60.00 service charge. The company policy is to bill the service charge back to the customer.
9.		Payment of the monthly insurance was made using a monthly scheduled EFT payment for $990.00 that the bookkeeper forgot to record.

(a)

Prepare the bank reconciliation as at July 31. (List items that increase balance as per bank & books first. Round answers to 2 decimal places, e.g. 52.75.)

ORIOLE COMPANY Bank Reconciliation choose the accounting period For the Month Ended July 31, 2024For the Year Ended July 31, 2024July 31, 2024
select an opening name for section one Adjusted cash balance per bankBank service chargeCash balance per bank statementCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques				$enter a dollar amount
select between addition and deduction AddLess: select a reconciling item Adjusted cash balance per bankBank service chargeCash balance per bank statementCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques				enter a dollar amount
				enter a total of the two previous amounts
select between addition and deduction AddLess: select a reconciling item Adjusted cash balance per bankBank service chargeCash balance per bank statementCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques				enter a dollar amount
select a closing name for section one Adjusted cash balance per bankBank service chargeCash balance per bank statementCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques				$enter a total amount for section one
select an opening name for section two Adjusted cash balance per booksBank service chargeCash balance per booksCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques				$enter a dollar amount
select between addition and deduction AddLess:
select a reconciling item Adjusted cash balance per booksBank service chargeCash balance per booksCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques		$enter a dollar amount
select a reconciling item Adjusted cash balance per booksBank service chargeCash balance per booksCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques		enter a dollar amount
				enter a subtotal of the two previous amounts
				enter a total amount for the first part
select between addition and deduction AddLess:
select a reconciling item Adjusted cash balance per booksBank service chargeCash balance per booksCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques		$enter a dollar amount
select a reconciling item Adjusted cash balance per booksBank service chargeCash balance per booksCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques		enter a dollar amount
select a reconciling item Adjusted cash balance per booksBank service chargeCash balance per booksCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques		enter a dollar amount
select a reconciling item Adjusted cash balance per booksBank service chargeCash balance per booksCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques		enter a dollar amount
				enter a subtotal of the four previous amounts
select a closing name for section two Adjusted cash balance per booksBank service chargeCash balance per booksCollection of EFT Rent RevenueCollection of Note ReceivableDeposit in transitEFT payment for Insurance ExpenseError in depositError in recording cheque No. 2480 for Accounts PayableError in recording cheque No. 2485 for Accounts PayableNSF chequeOutstanding cheques				$enter a total amount for section two

Question Part Score

--/16

(b)

The parts of this question must be completed in order. This part will be available when you complete the part above.