Chapter 6 Bank Reconciliation in Excel BANK STATEMENT Date 5 June 1 Checks Deposits Other 18,060 16,860 16,360 15,160 24,910 23,990 49,190 48,840 44,240 1,200 10 1,200 10,000 Print NSF 840 35,000 4,600 27 29 14 17,000 59,570 Serv. Charge Interest Earned 920 50 30 59,000 18 18,500 10,000 June 1 Bal. June 13 deposit June 22 deposit June 29 deposit 20 440 1,200 500 Check #100 check #101 Check #102 17,000 23 1 of 1