eBook

Chapter $4$

Financial Planning Exercise $6$

Checking account reconciliation

Use Worksheet $4\mathrm{.}1.$ Zachery Gomez has a NOW account at the Third National Bank. His checkbook ledger lists the following checks:

Check NumbersAmount$654$$$206\mathrm{.}0565855\mathrm{.}42662103\mathrm{.}0066899\mathrm{.}316706\mathrm{.}1467150\mathrm{.}3867224\mathrm{.}9067332\mathrm{.}1067444\mathrm{.}5067530\mathrm{.}0067630\mathrm{.}00677111\mathrm{.}2367838\mathrm{.}0467997\mathrm{.}99680486\mathrm{.}3068143\mathrm{.}5068275\mathrm{.}0668398\mathrm{.}02$

Zachery also made the following withdrawals and deposits at an ATM near his home:

DateAmountTransaction$(11)/(1)$$$50\mathrm{.}00$Withdrawal$(11)/(2)$$$525\mathrm{.}60$Deposit$(11)/(6)$$$100\mathrm{.}00$Deposit$(11)/(14)$$$75\mathrm{.}00$Withdrawal$(11)/(21)$$$525\mathrm{.}55$Deposit$(11)/(24)$$$150\mathrm{.}00$Withdrawal$(11)/(27)$$$225\mathrm{.}00$Withdrawal$(11)/(30)$$$400\mathrm{.}01$Deposit

Zachery's checkbook ledger shows an ending balance of $$286\mathrm{.}54.$ He has just received his bank statement for the month of November. It shows an ending balance of $$622\mathrm{.}44$; it also shows that he earned interest for November of $$3\mathrm{.}73,$ had a check service charge of $$8$ for the month, and had another $$12$ charge for a returned check. His bank statement indicates the following checks have cleared: $654,662,672,674,675,676,677,678,679,$ and $681.$ ATM withdrawals on$(11)/(1)$ and$(11)/(14)$ and deposits on$(11)/(2)$ and$(11)/(6)$ have cleared; no other checks or ATM activities are listed on his statement, so anything remaining should be treated as outstanding. Use a checking account reconciliation form like the one in Worksheet $4\mathrm{.}1$ to reconcile Zachery's checking account. Round your answers to the nearest cent. Enter all answers as positive values. Enter your answers in the given order of Check numbers.

CHECKING ACCOUNT RECONCILIATIONFor the Month of November, $2025$Accountholder Name$($s$)$: Zachery GomezType of Account: Individual

$1.$Ending balance shown on bank statement

$

Add up checks and withdrawals still outstanding:

Check Number or DateAmount$ $ $ $ $ $ $ $ ATM $11-24$$ ATM $11-27$$ TOTAL$

$2.$Deduct total check$($s$)/($w$)$ithdrawals still outstanding from bank balance$-$

$

Add up deposits not shown on bank statement:

DateAmount$(11)/(21)()/(15)$$$(11)/(30)()/(15)$$ TOTAL$

$3.$Add total deposits still outstanding to bank balance$+$

$

A$.$

Adjusted Bank Balance

$

$4.$Ending balance shown in checkbook

$

$5.$Deduct any bank service charges for the period$-$

$

$6.$Add interest earned for the period$+$

$

B$.$

New Checkbook Balance

$

Note: Your account is reconciled when line A equals line B$.$

Use Worksheet $4\mathrm{.}1.$ Zachery Gomez has a NOW account at the Third National Bank. His checkbook ledger lists the following checks:

Zachery also made the following withdrawals and deposits at an ATM near his home:

Zachery also made the following withdrawals and deposits at an ATM near his home:

Zachery's checkbook ledger shows an ending balance of $$286\mathrm{.}54.$ He has just received his bank statement for the month of November. It shows an ending balance of

$$622\mathrm{.}44$; it also shows that he earned interest for November of $$3\mathrm{.}73,$ had a check service charge of $$8$ for the month, and had another $$12$ charge for a returned

check. His bank statement indicates the following checks have cleared: $654,662,672,674,675,676,677,678,679,$ and $681.$ ATM withdrawals on $(11)/(1)$ and $(11)/(14)$

and deposits on $(11)/(2)$ and $(11)/(6)$ have cleared; no other checks or ATM activities are listed on his statement, so anything remaining should be treated as outstanding.

Use a checking account reconciliation form like the one in Worksheet $4\mathrm{.}1$ to reconcile Zachery's checking account. Round your answers to the nearest cent. Enter all

answers as positive values. Enter your answers in the given order of Check numbers. For the Month of November, $2025$

Accountholder Name$($s$)$: Zachery Gomez

Type of Account: Individual

Ending balance shown on bank statement

Add up checks and withdrawals still outstanding:

Deduct total check$($s$)/($w$)$ithdrawals still outstanding from bank

balance

Add up deposits not shown on bank statement:

Add total deposits still outstanding to bank balance

A$.$ Adjusted Bank Balance

Ending balance shown in checkbook

Deduct any bank service charges for the period

Add interest earned for the period

B$.$ New Checkbook Balance