Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sierra Company needs to reconcile its bank account for the month of May. The company hand-writes all cheques. The following represents information that they have

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Sierra Company needs to reconcile its bank account for the month of May. The company hand-writes all cheques. The following represents information that they have at their disposal: Lake Superior Imperial Credit Union Bank Statement Item reconciled ("x") Date Document # Withdrawals Deposits Balance April 30 Opening Balance $4,318.28 May 1 620.13 4,938.41 May 2 422 310.00 4,628.41 May 7 428 328.87 4,299.54 May 8 725.82 425 3,573.72 4,411.99 May 10 838.27 431 127.07 May 15 May 16 May 19 4,284.92 3,979.57 432 305.35 603.89 4,583.46 May 25 CM-Note Collected 450.00 5,033.46 May 31 Service Charge 32.87 $5,000.59 General Ledger Printout Sierra Account: Company Bank Item Cleared ("x") Date Document # Debit Credit Balance April 30 Balance Forward $3,575.13 May 5 428 328.87 3,246.26 May 7 2,833.62 429 412.64 May 9 Deposit 3,671.89 838.27 May 11 3,608.69 430 63.20 May 12 3,481.62 431 127.07 May 15 3,176.27 432 305.35 May 17 Deposit 3,780.16 603.89 May 20 433 985.10 2,795.06 May 21 1,945.06 434 850.00 May 30 Deposit 785.25 $2,730.31 From the April bank reconciliation, the following items were outstanding from the bank: Date Document # Item cleared ("x") Amount April 3 422 $310.00 April 12 425 $728.52 April 15 426 $324.76 April 30 Deposit $620.13 Prepare the May bank reconciliation in good form. Notes for you: - You may use an "x" to mark items above that appear in both sets of records. - You can fill out the template below (not all blanks need to be filled in) or prepare the bank reconciliation on your own and submit at end of the test/email. - Template: for numeric values, use "-" to indicate a subtraction, and ignore commas. For example: ($9,100.25) = -9100.25 Bank Reconciliation Sierra Company Bank Statement |May Book Adjustements $ Ending Balance Bank Statement Ending Balance General Ledger $ Plus: Plus: $ $ $ Less: Outstanding items Less: $ $ $ $ $ $ $ $ $ Reconciled Bank: Reconciled Books

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

Documentation Improvement Methods The New Accounting Manual

Authors: Athar Murtuza

2nd Edition

0471379387, 978-0471379386

More Books

Students also viewed these Accounting questions

Question

How many three-digit numbers are divisible by 7?

Answered: 1 week ago

Question

What is Indian Polity and Governance ?

Answered: 1 week ago