Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Chapter 4 Financial Planning Exercise 6 Checking account reconciliation Use Worksheet 4 . 1 . Mateo Gonzalez has an interest - paying ( NOW )
Chapter
Financial Planning Exercise
Checking account reconciliation
Use Worksheet Mateo Gonzalez has an interestpaying NOW checking account at the Second State Bank. His checkbook ledger lists the following checks:
Check Numbers Amount
$
Mateo also made the following withdrawals and deposits at an ATM near his home:
Date Amount Transaction
$ withdrawal
$ deposit
$ deposit
$ withdrawal
$ deposit
$ withdrawal
$ withdrawal
$ deposit
Mateo's checkbook ledger shows an ending balance of $ He has just received his bank statement for the month of November. It shows an ending balance of $; it also shows that he earned interest for November of $ had a check service charge of $ for the month, and had another $ charge for a returned check. His bank statement indicates the following checks have cleared: and ATM withdrawals on and and deposits on and 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 to reconcile Mateo'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 RECONCILIATION
For the Month of November,
Accountholder Names: Mateo Gonzalez
Type of Account: NOW Account First State Bank
Ending balance shown on bank statement
$
Add up checks and withdrawals still outstanding:
Check Number or Date Amount
$
$
$
$
$
$
$
$
ATM $
ATM $
TOTAL $
Deduct total checkswithdrawals still outstanding from bank balance
$
Add up deposits still outstanding:
Date Amount
$
$
TOTAL $
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
$
Note: Your account is reconciled when line A equals line B
fill in the blanks CHECKING ACCOUNT RECONCILIATION
For the Month of November,
Accountholder Names: Mateo Gonzalez
Type of Account: NOW Account First State Bank
Ending balance shown on bank statement
$
Add up checks and withdrawals still outstanding:
Deduct total checkswithdrawals still outstanding from bank balance
Add up deposits still outstanding:
tableDateAmount$$TOTAL$
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started