Based on the following data, prepare a bank reconciliation for December of the current year:

a. Balance according to the bank statement at December 31, $283,000. b. Balance according to the ledger at December 31, $245,410. c. Checks outstanding at December 31, $68,540. d. Deposit in transit, not recorded by bank, $29,500. e. Bank debit memo for service charges, $750. f. A check for $12,700 in payment of an invoice was incorrectly recorded in the accounts as $12,000.

Kornett Company Bank Reconciliation December 31, 20Y8
Bank service chargesCash balance according to bank statementCash balance according to company's recordsCashPetty cash		$fill in the blank 2
Add error in recording checkAdd deposit in transit, not recorded by bankDeduct error in recording checkDeduct deposit in transit, not recorded by bankDeduct bank service charges		fill in the blank 4
Add error in recording checkAdd outstanding checksAdd bank service chargesDeduct bank service chargesDeduct outstanding checks		fill in the blank 6
Adjusted balance		$fill in the blank 7
Bank service chargesCash balance according to bank statementCash balance according to company's recordsCashPetty cash		$fill in the blank 9
Deduct:
Bank service chargesCashDeposit in transit, not recorded by bankOutstanding checksPetty cash	$fill in the blank 11
Accounts receivableDeposit in transit, not recorded by bankError in recording checkOutstanding checksPetty cash	fill in the blank 13	fill in the blank 14
Adjusted balance