Prepare the bank reconciliation statement using the three methods.

 

PEAFRANCIA SAVINGS BANK NAGA CITY Bank Statement Castro Consulting Ateneo Ave., Naga City Statement Date: April 30, 2000 Account No.: 1585-0542-1 Account Type: Current Currency: Peso 3/31/00 Balance Total Credits Total Debits 4/30/00 Balance 286,805.78 268,247.00 No. of Credits 189,451.00 13 365,601.78 6. 9. No. of Debits No, of Checks Date Description Check No. Debits Credits Balance Beginning Bal. Check Deposit Cash Deposit Inclearing Check Inclearing Check Cash Deposit Cost of Checkbooks Inclearing Check Check Encashment 286,805.78 302,702.78 4/01 15,897.00 35,000.00 4/02 337,702.78 4/03 4/06 4/07 25,378.95 16,554.20 269 312,323.83 270 295,769.63 308,369.63 308,124.63 288,124.63 12,600.00 4/08 245.00 4/13 20,000.00+ 25,000.00+ 9,500.004 272 4/13 273 263,124.63 253,624.63 Check Encashment 4/15 Check Deposits 4/15 Check Encashment Check Deposit Returned Items 4/15 274 60,101.00 313,725.63 288,160.63 314,809.63 288,160.63 282,304.78 307,304.78 307,056.78 271 25,565.00H 4/20 26,649.00 26,649.00 5,855.854 4/23 4/24 Inclearing Check 4/27 275 Bank Credit Memo 25,000.00 4/27 Service Charges 248.00 4/28 Cash Deposit 27,500.00 Check Encashment Service Charges Cash Deposit Check Deposits Check Encashment 334,556.78 309,556.78 309,501.78 325,001.78 375,001.78 365,601.78 365,601.78 4/29 276 25,000.00+ 4/29 55.00 4/30 15,500.00 50,000.00. 4/30 4/30 277 9,400.00+ Ending Balance WORKING FOR THE FILIPINO ENTREPRENEUR Page 1 of 1