I have the following question :

At 31 May the Cash account of A Taylor appeared as follows:

C A S H A C C O U N T
DEBIT CREDIT
Date Details Bank Date Details Cheque No Bank
£ £
May 1 Balance b/d 4,600 May 2 Rent 301 150
May 11 Loan 1,800 May 3 Telephone 302 220
May 12 Sales 1,400 May 7 Travel 303 320
May 30 Loan 1,700 May 5 P Wise 304 560
May 31 Sales 220 May 7 Rates 305 210
May 31 Sales 480 May 9 Advertising 306 170
May 31 Sales 240 May 11 Wages 307 150
May12 Purchases 308 290
May 15 Travel 309 340
May 17 P Allstar 310 220
May 19 Wages 311 110
May 20 Purchases 312 790
May 31 Wages 313 420
May 31 Balance c/d 6,490
10,440 10,440

June 1 Balance b/d 6,490


At 31 May the following cheques had not been presented for payment:-

Date Cheque No £
May 3 302 220
May 7 305 210
May 9 306 170
May 17 310 220




At 31 May the cheques banked on 31 May (£940) had not been credited to Mr Taylor’s Bank Statement.

Required:
Prepare a bank reconciliation statement at 31 May which shows the balance on the Bank Statement as at that date.

I have tried working this out. The 1st question I had no problem with as I had a cash account and a bank statement. But with this question I have no bank statement to go on.. How do I work out the balance per statement if I have no bank statement?

The checks at the end of the month will have been deducted from your book balance but not your bank balance. Does this help you figure out the bank statement balance?