Question

Using the following information, prepare a bank reconciliation for Ivanhoe Company for July 31, 2022.

a.		The bank statement balance is $3,760.
b.		The cash account balance is $4,200.
c.		Outstanding checks totaled $1,450.
d.		Deposits in transit are $1,780.
e.		The bank service charge is $83.
f.		A check for $85 for supplies was recorded as $58 in the ledger.

Ivanhoe Company Bank Reconciliation For the Year Ended July 31, 2022For the Month Ended July 31, 2022July 31, 2022
select an opening name for section one Outstanding ChecksCheck for Supplies ErrorBank Service ChargeAdjusted Cash Balance Per BankAdjusted Cash Balance Per BooksCash Balance Per BankFederal Tax DepositsDeposit in Transit				$enter a dollar amount
select between addition and deduction LessAdd : select a reconciling item Adjusted Cash Balance Per BooksOutstanding ChecksDeposit in TransitCheck for Supplies ErrorBank Service ChargeFederal Tax DepositsAdjusted Cash Balance Per BankCash Balance Per Bank				enter a dollar amount
				enter a subtotal of the two previous amounts
select between addition and deduction AddLess : select a reconciling item Check for Supplies ErrorAdjusted Cash Balance Per BankOutstanding ChecksDeposit in TransitCash Balance Per BankBank Service ChargeAdjusted Cash Balance Per BooksFederal Tax Deposits				enter a dollar amount
select a closing name for section one Federal Tax DepositsAdjusted Cash Balance Per BooksCheck for Supplies ErrorAdjusted Cash Balance Per BankCash Balance Per BankBank Service ChargeDeposit in TransitOutstanding Checks				$enter a total amount for the first section
select an opening name for section two Federal Tax DepositsDeposit in TransitCash Balance Per BooksAdjusted Cash Balance Per BankOutstanding ChecksCheck for Supplies ErrorAdjusted Cash Balance Per BooksBank Service Charge				$enter a dollar amount
select between addition and deduction LessAdd :
select a reconciling item     Adjusted Cash Balance Per Books    Adjusted Cash Balance Per Bank    Check for Supplies Error    Cash Balance Per Books    Bank Service Charge    Deposit in Transit    Federal Tax Deposits    Outstanding Checks		$enter a dollar amount
select a reconciling item     Adjusted Cash Balance Per Books    Check for Supplies Error    Federal Tax Deposits    Deposit in Transit    Outstanding Checks    Bank Service Charge    Cash Balance Per Books    Adjusted Cash Balance Per Bank		enter a dollar amount
				enter a subtotal of the two previous amounts
select a closing name for section two Deposit in TransitAdjusted Cash Balance Per BooksOutstanding ChecksAdjusted Cash Balance Per BankCash Balance Per BooksCheck for Supplies ErrorBank Service ChargeFederal Tax Deposits				$enter a total amount for the second section

Answer 1

Ivanhoe Company Bank Reconciliation For the Month Ended July 31,2022 Cash balance per bank statement Add: Deposits in transit S 3,760 S 1,780 $ 5,540 Less: Outstanding checks Adjusted cash balance per bank S 1,450 S 4,090 Cash balance per books Less: For Supplies error Bank serviec charge S 4,200 $ 27 $ 83 $ 110 S 4,090 Adjusted cash balance books per EA