Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

my account reconciliation Use Worksheet 4.1. Mateo Gonzalez has an interest-paying (NOW) Checking account at the Second State Bank. His checkbook ledger lists the following

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
my account reconciliation Use Worksheet 4.1. Mateo Gonzalez has an interest-paying (NOW) Checking account at the Second State Bank. His checkbook ledger lists the following checks: Amount Check Numbers 654 $206.05 55.22 658 662 668 103.00 98.66 50.37 24.90 32.50 44.50 30.00 30.00 111.23 38.04 679 680 486.80 43.50 681 U U sllan Savings 682 683 74.50 98.25 Mateo also made the following withdrawals and deposits at an ATM near his home: Date Amount Transaction 11/1 $50.00 withdrawal 11/2 $525.60 deposit 11/6 $100.00 deposit 11/14 $75.00 withdrawal 11/21 $525.91 deposit 11/24 $150.00 withdrawal 11/27 $225.00 withdrawal 11/30 $400.95 deposit Mateo's checkbook ledger shows an ending balance of $286.54. He has just received his bank statement for the month of November. It shows an ending balance of $622.44; it also shows that he earned interest for November of $5.38, 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.1 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, 2015 Accountholder Name(s): Mateo Gonzalez Type of Account: NOW Account - First State Bank 1. Ending balance shown on bank statement Add up checks and withdrawals still outstanding: Check Number Amount or Date ATM 11-24 $ E EN ATM 11-27 R $ 1 TOTAL 2. Deduct total checks/withdrawals still outstanding from bank balance Add up deposits still outstanding: Date Amount 11/21/15 11/30/15 TOTAL 2. ATM 11-27 TOTAL $ Deduct total checks/withdrawals still outstanding from bank balance Add up deposits still outstanding: Date Amount 11/21/15 11/30/15 TOTAL 3. Add total deposits still outstanding to bank balance 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. my account reconciliation Use Worksheet 4.1. Mateo Gonzalez has an interest-paying (NOW) Checking account at the Second State Bank. His checkbook ledger lists the following checks: Amount Check Numbers 654 $206.05 55.22 658 662 668 103.00 98.66 50.37 24.90 32.50 44.50 30.00 30.00 111.23 38.04 679 680 486.80 43.50 681 U U sllan Savings 682 683 74.50 98.25 Mateo also made the following withdrawals and deposits at an ATM near his home: Date Amount Transaction 11/1 $50.00 withdrawal 11/2 $525.60 deposit 11/6 $100.00 deposit 11/14 $75.00 withdrawal 11/21 $525.91 deposit 11/24 $150.00 withdrawal 11/27 $225.00 withdrawal 11/30 $400.95 deposit Mateo's checkbook ledger shows an ending balance of $286.54. He has just received his bank statement for the month of November. It shows an ending balance of $622.44; it also shows that he earned interest for November of $5.38, 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.1 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, 2015 Accountholder Name(s): Mateo Gonzalez Type of Account: NOW Account - First State Bank 1. Ending balance shown on bank statement Add up checks and withdrawals still outstanding: Check Number Amount or Date ATM 11-24 $ E EN ATM 11-27 R $ 1 TOTAL 2. Deduct total checks/withdrawals still outstanding from bank balance Add up deposits still outstanding: Date Amount 11/21/15 11/30/15 TOTAL 2. ATM 11-27 TOTAL $ Deduct total checks/withdrawals still outstanding from bank balance Add up deposits still outstanding: Date Amount 11/21/15 11/30/15 TOTAL 3. Add total deposits still outstanding to bank balance 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Private Equity Toolkit A Step By Step Guide To Getting Deals Done From Sourcing To Exit

Authors: Tamara Sakovska

1st Edition

1119697107, 978-1119697107

More Books

Students also viewed these Finance questions

Question

LO 2-3 How to choose channels to reach your audience.

Answered: 1 week ago