Question

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

a.		The bank statement balance is $3,510.
b.		The cash account balance is $4,050.
c.		Outstanding checks totaled $1,240.
d.		Deposits in transit are $1,690.
e.		The bank service charge is $81.
f.		A check for $76 for supplies was recorded as $67 in the ledger.

Crane Company Bank Reconciliation For the Month Ended July 31, 2022July 31, 2022For the Year Ended July 31, 2022
select an opening name for section one Federal Tax DepositsCheck for Supplies ErrorCash Balance Per BankAdjusted Cash Balance Per BankDeposit in TransitOutstanding ChecksBank Service ChargeAdjusted Cash Balance Per Books				$enter a dollar amount
select between addition and deduction AddLess : select a reconciling item Adjusted Cash Balance Per BankDeposit in TransitOutstanding ChecksCash Balance Per BankAdjusted Cash Balance Per BooksCheck for Supplies ErrorFederal Tax DepositsBank Service Charge				enter a dollar amount
				enter a subtotal of the two previous amounts
select between addition and deduction AddLess : select a reconciling item Deposit in TransitFederal Tax DepositsBank Service ChargeAdjusted Cash Balance Per BankCash Balance Per BankOutstanding ChecksAdjusted Cash Balance Per BooksCheck for Supplies Error				enter a dollar amount
select a closing name for section one Deposit in TransitBank Service ChargeOutstanding ChecksAdjusted Cash Balance Per BankFederal Tax DepositsCash Balance Per BankAdjusted Cash Balance Per BooksCheck for Supplies Error				$enter a total amount for the first section
select an opening name for section two Federal Tax DepositsAdjusted Cash Balance Per BooksOutstanding ChecksCheck for Supplies ErrorBank Service ChargeAdjusted Cash Balance Per BankCash Balance Per BooksDeposit in Transit				$enter a dollar amount
select between addition and deduction AddLess :
select a reconciling item     Outstanding Checks    Adjusted Cash Balance Per Bank    Deposit in Transit    Bank Service Charge    Adjusted Cash Balance Per Books    Cash Balance Per Books    Check for Supplies Error    Federal Tax Deposits		$enter a dollar amount
select a reconciling item     Deposit in Transit    Federal Tax Deposits    Check for Supplies Error    Adjusted Cash Balance Per Books    Adjusted Cash Balance Per Bank    Bank Service Charge    Cash Balance Per Books    Outstanding Checks		enter a dollar amount
				enter a subtotal of the two previous amounts
select a closing name for section two Adjusted Cash Balance Per BooksBank Service ChargeCheck for Supplies ErrorFederal Tax DepositsAdjusted Cash Balance Per BankDeposit in TransitCash Balance Per BooksOutstanding Checks				$enter a total amount for the second section

Answer 1

Cash balance as per bank		3510
ADD : Deposits in transit		1690
		5200
LESS : Outstanding checks		1240
Adjusted cash balance per books		3960
Cash balance as per books		4050
LESS : Bank service charge	81
LESS : Check for supplies error(76-67)	9
		90
Adjusted cash balance as per books		3960