Using the documentation from the bank and from Simone's check register, construct the bank reconciliation statement for November 26. Hint: Any items that you enter into the bank reconciliation statement should be entered in the order in which they appeared on the account ledger and bank statement Simone Smythe's Bank Reconciliation for November 29 1.153.70 Ending balance per bank statement, November 26 Add: Deposit in transit Deduct: Outstanding checks and ATM transactions 282.50 Check number 504 44.00 97505 ATM number Check number 100.75 110 110.00 ATM number 99508 37.50 Total withdrawals Adjusted bank balance 292.25 1.123 95 Balance per books, November 29 1123.95 Fourth State Bank of San Francisco, CA Statement of Account Simone Smythe November 20XX 550 Angel Street San Francisco, CA Account 348596 Date Description Subtractions Additions Balance 11-01 Previous balance 1,045.50 11-01 Deposit 500.00 1,545.50 11-03 Check 300 500.00 1,045.50 11-04 Check 301 250.00 795.50 11-05 ATM withdrawal 25.00 770.50 11-05 125.00 895.50 11-11 35.15 860.35 11-15 Deposit ATM withdrawal Deposit Check 302 ATM withdrawal 500.00 1,360.35 11-18 150.00 1,210.35 11-21 47.65 11-22 1,162.70 Deposit 175.00 11-24 1,337.70 Check 303 50.00 11-26 1,287.70 ATM withdrawal 50.00 1,237.70 Date Simone's Account Ledger Transaction Description Deposit Withdrawals Deposit - Payroll $500.00 Balance Nov-01 $1,545.5 $500.00 1,045.50 250.00 795.50 Nov-03 Check 300 - Rent Nov-04 Check 301 - Car payment Nov-05 ATM withdrawal 87501 Nov-05 Deposit - Birthday gift Nov-11 ATM withdrawal 89502 Nov-15 Deposit - Payroll 25.00 125.00 770.50 895.50 35.15 860.35 500.00 1,360.35 150.00 1,210.35 47.65 1,162.70 175.00 1,337.70 50.00 Nov-18 Check 302 - Groceries Nov-21 ATM withdrawal 93503 Nov-22 Deposit - Stipend Nov-24 Check 303 - Bookstore Nov-26 ATM withdrawal 94504 Nov-27 Check 304 - Dry cleaning Nov-27 ATM withdrawal 97505 Nov-27 Check 305 - Car insurance Nov-28 Deposit - Belated birthday gift 1,287.70 50.00 40.00 1,237.70 1,197.70 100.75 1,096.95 100.00 996.95 375.00 1,371.95 150.00 1,210.35 47.65 1,162.70 175.00 1,337.70 50.00 Nov-18 Check 302 - Groceries Nov-21 ATM withdrawal 93503 Nov-22 Deposit - Stipend Nov-24 Check 303 - Bookstore Nov-26 ATM withdrawal 94504 Nov-27 Check 304 - Dry cleaning Nov-27 ATM withdrawal 97505 Nov-27 Check 305 - Car insurance Nov-28 Deposit - Belated birthday gift 1,287.70 50.00 40.00 1,237.70 1,197.70 100.75 1,096.95 100.00 996.95 375.00 1,371.95 pour uupunu 17JUU tro Nov-24 50.00 1,287.70 Nov-26 50.00 1,237.70 Nov-27 40.00 1,197.70 Nov-27 Check 303 - Bookstore ATM withdrawal 94504 Check 304 - Dry cleaning ATM withdrawal 97505 Check 305 - Car insurance Deposit - Belated birthday gift ATM withdrawal 99506 100.75 1,096.95 Nov-27 100.00 996.95 Nov-28 375.00 1,371.95 Nov-29 37.50 1,334.45 pour uupunu 17JUU tro Nov-24 50.00 1,287.70 Nov-26 50.00 1,237.70 Nov-27 40.00 1,197.70 Nov-27 Check 303 - Bookstore ATM withdrawal 94504 Check 304 - Dry cleaning ATM withdrawal 97505 Check 305 - Car insurance Deposit - Belated birthday gift ATM withdrawal 99506 100.75 1,096.95 Nov-27 100.00 996.95 Nov-28 375.00 1,371.95 Nov-29 37.50 1,334.45
