Bank Reconciliation (Appendix 6.1)

At the end of April, Meyer Company had a $8,090 balance in its cash account, while its bank statement for April showed an ending cash balance of $7,100. The April bank statement showed $10 of interest earned by Meyer on its checking account and a $300 NSF check written by one of Meyer's customers. Meyer's records show a $800 deposit in transit and $100 of outstanding checks at the end of April.

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Open spreadsheet

Required:

Prepare the bank reconciliation of Meyer for April.

Meyer Company
Bank Reconciliation
April 30
Cash balance, bank		$ fill in the blank 2
		fill in the blank 4
Total		$ fill in the blank 5
		fill in the blank 7
Adjusted cash balance		$ fill in the blank 8
Cash balance, company		$ fill in the blank 9
		fill in the blank 11
Total		$ fill in the blank 12
		fill in the blank 14
Adjusted cash balance		$ fill in the blank 15