Using the following information, prepare a bank reconciliation for Hintz Company for July 31, 2017.

a.		The bank statement balance is $3,506.
b.		The cash account balance is $3,930.
c.		Outstanding checks totaled $1,285.
d.		Deposits in transit are $1,670.
e.		The bank service charge is $30.
f.		A check for $98 for supplies was recorded as $89 in the ledger.

Hintz Company Bank Reconciliation July 31, 2017
Federal Tax DepositsOutstanding ChecksCheck for Supplies ErrorBank Service ChargeAdjusted Cash Balance Per BooksAdjusted Cash Balance Per BankCash Balance Per BankDeposit in Transit				$
Add Less : Outstanding ChecksCheck for Supplies ErrorFederal Tax DepositsAdjusted Cash Balance Per BooksBank Service ChargeAdjusted Cash Balance Per BankCash Balance Per BankDeposit in Transit
Less Add : Bank Service ChargeCheck for Supplies ErrorFederal Tax DepositsAdjusted Cash Balance Per BankAdjusted Cash Balance Per BooksDeposit in TransitOutstanding ChecksCash Balance Per Bank
Outstanding ChecksAdjusted Cash Balance Per BankAdjusted Cash Balance Per BooksCheck for Supplies ErrorCash Balance Per BankDeposit in TransitFederal Tax DepositsBank Service Charge				$
Adjusted Cash Balance Per BankBank Service ChargeCash Balance Per BooksFederal Tax DepositsOutstanding ChecksDeposit in TransitCheck for Supplies ErrorAdjusted Cash Balance Per Books				$
Less Add :
Cash Balance Per Books Adjusted Cash Balance Per Bank Adjusted Cash Balance Per Books Bank Service Charge Deposit in Transit Federal Tax Deposits Check for Supplies Error Outstanding Checks		$
Cash Balance Per Books Bank Service Charge Deposit in Transit Adjusted Cash Balance Per Books Check for Supplies Error Outstanding Checks Federal Tax Deposits Adjusted Cash Balance Per Bank
Bank Service ChargeAdjusted Cash Balance Per BooksCheck for Supplies ErrorFederal Tax DepositsAdjusted Cash Balance Per BankCash Balance Per BooksDeposit in TransitOutstanding Checks				$