Answered step by step
Verified Expert Solution
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
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
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