The following information pertains to Pina Colada Corp..

1.		Cash balance per bank, July 31, $9,003.
2.		July bank service charge not recorded by the depositor $36.
3.		Cash balance per books, July 31, $9,024.
4.		Deposits in transit, July 31, $2,820.
5.		$1,636 collected from a customer for Pina Colada Corp. in July by the bank through electronic funds transfer. The collection has not been recorded by Pina Colada Corp..
6.		Outstanding checks, July 31, $1,199.

(a)

Prepare a bank reconciliation at July 31, 2022. (List items that increase cash balance first. Reconcile cash balance per bank first.)

Pina Colada Corp. Bank Reconciliation choose the accounting period July 31, 2022For the Year Ended July 31, 2022For the Month Ended July 31, 2022
select an opening name for section one Adjusted cash balance per bankAdjusted cash balance per booksBank service chargeCash balance per bank statementCash balance per booksDeposits in transitElectronic funds transfer receivedOutstanding checks			$enter a dollar amount
select between addition and deduction AddLess:	select an opening name for section one Adjusted cash balance per bankAdjusted cash balance per booksBank service chargeCash balance per bank statementCash balance per booksDeposits in transitElectronic funds transfer receivedOutstanding checks		enter a dollar amount
			enter a subtotal of the two previous amounts
select between addition and deduction LessAdd:	select an opening name for section one Adjusted cash balance per bankAdjusted cash balance per booksBank service chargeCash balance per bank statementCash balance per booksDeposits in transitElectronic funds transfer receivedOutstanding checks		enter a dollar amount
select an opening name for section one Adjusted cash balance per bankAdjusted cash balance per booksBank service chargeCash balance per bank statementCash balance per booksDeposits in transitElectronic funds transfer receivedOutstanding checks			$enter a total amount for section one
select an opening name for section one Adjusted cash balance per bankAdjusted cash balance per booksBank service chargeCash balance per bank statementCash balance per booksDeposits in transitElectronic funds transfer receivedOutstanding checks			$enter a dollar amount
select between addition and deduction LessAdd:	select an opening name for section one Adjusted cash balance per bankAdjusted cash balance per booksBank service chargeCash balance per bank statementCash balance per booksDeposits in transitElectronic funds transfer receivedOutstanding checks		enter a dollar amount
			enter a subtotal of the two previous amounts
select between addition and deduction LessAdd:	select an opening name for section one Adjusted cash balance per bankAdjusted cash balance per booksBank service chargeCash balance per bank statementCash balance per booksDeposits in transitElectronic funds transfer receivedOutstanding checks		enter a dollar amount
select an opening name for section one Adjusted cash balance per bankAdjusted cash balance per booksBank service chargeCash balance per bank statementCash balance per booksDeposits in transitElectronic funds transfer receivedOutstanding checks			$enter a total amount for section two