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
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
| |||||
|---|---|---|---|---|---|
| select an opening name for section one
| $enter a dollar amount
| ||||
| select between addition and deduction
| enter a dollar amount
| ||||
| enter a subtotal of the two previous amounts
| |||||
| select between addition and deduction
| enter a dollar amount
| ||||
| select a closing name for section one
| $enter a total amount for the first section
| ||||
| select an opening name for section two
| $enter a dollar amount
| ||||
| select between addition and deduction
| |||||
| select a reconciling item
| $enter a dollar amount
| ||||
| select a reconciling item
| enter a dollar amount
| ||||
| enter a subtotal of the two previous amounts
| |||||
| select a closing name for section two
| $enter a total amount for the second section
| ||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts

For the Year Ended July 31, 2022For the Month Ended July 31, 2022July 31, 2022
Outstanding ChecksCheck for Supplies ErrorBank Service ChargeAdjusted Cash Balance Per BankAdjusted Cash Balance Per BooksCash Balance Per BankFederal Tax DepositsDeposit in Transit
LessAdd
Adjusted Cash Balance Per BooksOutstanding ChecksDeposit in TransitCheck for Supplies ErrorBank Service ChargeFederal Tax DepositsAdjusted Cash Balance Per BankCash Balance Per Bank

AddLess
Check for Supplies ErrorAdjusted Cash Balance Per BankOutstanding ChecksDeposit in TransitCash Balance Per BankBank Service ChargeAdjusted Cash Balance Per BooksFederal Tax Deposits
Federal Tax DepositsAdjusted Cash Balance Per BooksCheck for Supplies ErrorAdjusted Cash Balance Per BankCash Balance Per BankBank Service ChargeDeposit in TransitOutstanding Checks
Federal Tax DepositsDeposit in TransitCash Balance Per BooksAdjusted Cash Balance Per BankOutstanding ChecksCheck for Supplies ErrorAdjusted Cash Balance Per BooksBank Service Charge
LessAdd
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 
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 

Deposit in TransitAdjusted Cash Balance Per BooksOutstanding ChecksAdjusted Cash Balance Per BankCash Balance Per BooksCheck for Supplies ErrorBank Service ChargeFederal Tax Deposits