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 9 189,451.00 No. of Debits 13 365,601.78 No. of Checks 9 Date Description Debits Credits Balance Check No. 15.897.00# 35,000.00 269 270 25,378.95 16,554.204 12,600.00 M 272 273 274 245.00 20,000.00 25,000.00 9,500,004 60,101.00 271 25,565.00-4 Beginning Bal. 4/01 Check Deposit 4/02 Cash Deposit 4/03 Inclearing Check 4/06 Inclearing Check 4/07 Cash Deposit 4/08 Cost of Checkbooks 4/13 Inclearing Check 4/13 Check Encashment 4/15 Check Encashment 4/15 Check Deposits 4/15 Check Encashment 4/20 Check Deposit 4/23 Returned Items 4/24 Inclearing Check 4/27 Bank Credit Memo 4/27 Service Charges 4/28 Cash Deposit 4/29 Check Encashment 4/29 Service Charges 4/30 Cash Deposit 4/30 Check Deposits 4/30 Check Encashment Ending Balance 26,649.00 286,805.78 302.702.78 337,702.78 312,323.83 295,769.63 308,369.63 308,124.63 288.124.63 263,124.63 253,624.63 313,725.63 288,160.63 314,809.63 288,160.63 282,304.78 307,304.78 307,056.78 334,556.78 309,556.78 309,501.78 325,001.78 375,001.78 365,601.78 365,601.78 26,649.00 5,855.854 275 25,000.00 248.00 27,500.00 276 25,000.00+ 55.00 15,500.00 50,000.00 277 9,400.00441 WORKING FOR THE FILIPINO ENTREPRENEUR Page 1 of 1 onciliation statement. 6. Compute the adjusted bank balance and the adjusted book balance. The two adjusted balances should equal. The adjusted cash balance is P385,850. Castro Consulting Partial Cash Receipts Journal April 2000 O.R. No. Date April 2 7 15 20 28 29 30 30 501 502 503 504 505 506 507 508 Description Ateneo de Naga University Prudential Guarantee and Assurance Inc. Burger King Corporation Equitable Banking Corporation Philtranco Bus Company Jocker's Food Industries Nissan North Edsa J. Ty Construction and Development Corp. Cash Receipts 35,000.00 12,600.00 60,101.000 26,649.00 27,500.004 50,000.00% 15,500.00 25,850.00 253,200.00 Castro Consulting Partial Cash Disbursements Journal April 2000 Check No. Date April 3 6 7 13 15 20 29 30 30 270 271 272 273 274 275 276 Description MicroGates Software Bureau of Internal Revenue First World Realty Company Payroll Replenishment of Petty Cash Fund First Bicol Electric Cooperative Payroll Replenishment of Petty Cash Fund Smart Communications, Inc. Cash Payments 16,554.207 25,565.00 20,000.00+ 25,000.00 9,500.00+ 5,855.851 25,000.00+ 9,400.00+ 5,601.78 142,476.83 277 278 311