Required: You will complete the Bank Reconciliation below by filling in the blanks with the amount of the reconciling items - to be encoded as whole numbers, NOcomma, NO Peso sign; if the amount is to be deducted, enclose it in parenthesis. Encode the number 0 if the amount is zero.(1)Unadjusted balance per Book(2)Bank credit memo(3)NSF check(4)Erroneous posting of deposit(5)Bank service charge(6)Interest income(7)Adjusted balance per bookUnadjusted balance per bank92883(8)Deposit in transit(9)Outstanding checks(10)Adjusted balance per bank Ms. Arzel opened the The Baker's Box with cash investment of P200,000 on July 06, 2020. She opened a Checking Account with initial deposit of P65,000 at BDO.At the end of July 31, the ending balance of the account is P88,945.On Sept. 07, Ms. Arzel received the bank statement for the month of August. Below is a copy of the bank statement and the records of The Baker's Box of theChecking Account No. 88888.BDO Bank StatementCustomer: The Baker's BoxAddress: DasmarinasAccount No.: 88888Period: August 01 - 31, 2020Date Check No. Amount DepositBalance1-Aug Balance2-Aug88,94588,54588,200522400The Baker's Box2-Aug523345Per General Ledger:3-Aug5-Aug6-Aug2,87491,074Cash in Bank, Account No. 8888852615,7887,93275,286Beg. balance3-Aug10-Aug52867,35488,9452-Aug 5224002-Aug 5233-Aug 5243-Aug 5253-Aug 526 15,7885-Aug 5275-Aug 5285-Aug 5295-Aug 5305-Aug 53114-Aug 53214-Aug 53321-Aug 53421-Aug 53528-Aug 53628-Aug 53728-Aug 5382,87434510-Aug11-Aug8,63675,9904,220 DC80,2108,6365,32112-Aug6,32086,5302,39912-Aug14-Aug17-Aug6,32014-Aug5293,30783,2234,94614-Aug14-Aug14-Aug14-Aug17-AugNSF1,45581,76810,5684,0324,94686,71421-Aug5,7905,87612,39012,7327,9325305,81280,90228-Aug3,3075317,82173,08128-Aug31-Aug5,81210,65883,7397,82120-Aug21-Aug21-Aug5331,88881,8513,94080,28286,0725341,5695,7901,88825-Aug5274,03282,0401,56926-Aug28-Aug31-Aug31-Aug5245,32176,7193,80018,26694,9854,0325382,10092,8855,992148 Int93,0332,10031-AugSC15092,883

The bank reconciliation statement adjust the balances of cash book and pass book with various…

BDO Bank Statement Account No.: 88888 Period: August 01 - 31, 2020 Customer: The Baker's Box Address: Dasmarinas Date Check No. Amount Deposit Balance 1-Aug Balance 2-Aug 2-Aug 3-Aug 5-Aug 6-Aug 88,945 88,545 88,200 522 400 The Baker's Box 523 345 Per General Ledger: 2,874 91,074 Cash in Bank, Account No. 88888 526 15,788 75,286 Beg. balance 3-Aug 2-Aug 522 2-Aug 523 3-Aug 524 3-Aug 525 3-Aug 526 15,788 5-Aug 527 5-Aug 528 5-Aug 529 5-Aug 530 5-Aug 531 14-Aug 532 14-Aug 533 21-Aug 534 21-Aug 535 28-Aug 536 28-Aug 537 28-Aug 538 7,932 88,945 400 528 67,354 2,874 345 10-Aug 11-Aug 12-Aug 8,636 75,990 80,210 10-Aug 12-Aug 14-Aug 8,636 6,320 4,946 4,220 DC 5,321 6,320 86,530 2,399 14-Aug 529 3,307 83,223 14-Aug NSF 1,455 81,768 17-Aug 21-Aug 28-Aug 28-Aug 31-Aug 10,568 5,790 4,032 7,932 14-Aug 14-Aug 14-Aug 17-Aug 20-Aug 21-Aug 21-Aug 4,946 86,714 80,902 73,081 530 5,812 7,821 5,876 3,307 531 12,390 5,812 7,821 10,658 83,739 533 1,888 81,851 12,732 534 1,569 80,282 3,940 5,790 86,072 1,888 25-Aug 4,032 82,040 76,719 527 1,569 26-Aug 28-Aug 31-Aug 31-Aug 524 5,321 3,800 4,032 18,266 94,985 538 2,100 92,885 5,992 148 Int 93,033 2,100 31-Aug SC 150 92,883

BDO Bank Statement Account No.: 88888 Period: August 01 - 31, 2020 Customer: The Baker's Box Address: Dasmarinas Date Check No. Amount Deposit Balance 1-Aug Balance 2-Aug 2-Aug 3-Aug 5-Aug 6-Aug 88,945 88,545 88,200 522 400 The Baker's Box 523 345 Per General Ledger: 2,874 91,074 Cash in Bank, Account No. 88888 526 15,788 75,286 Beg. balance 3-Aug 2-Aug 522 2-Aug 523 3-Aug 524 3-Aug 525 3-Aug 526 15,788 5-Aug 527 5-Aug 528 5-Aug 529 5-Aug 530 5-Aug 531 14-Aug 532 14-Aug 533 21-Aug 534 21-Aug 535 28-Aug 536 28-Aug 537 28-Aug 538 7,932 88,945 400 528 67,354 2,874 345 10-Aug 11-Aug 12-Aug 8,636 75,990 80,210 10-Aug 12-Aug 14-Aug 8,636 6,320 4,946 4,220 DC 5,321 6,320 86,530 2,399 14-Aug 529 3,307 83,223 14-Aug NSF 1,455 81,768 17-Aug 21-Aug 28-Aug 28-Aug 31-Aug 10,568 5,790 4,032 7,932 14-Aug 14-Aug 14-Aug 17-Aug 20-Aug 21-Aug 21-Aug 4,946 86,714 80,902 73,081 530 5,812 7,821 5,876 3,307 531 12,390 5,812 7,821 10,658 83,739 533 1,888 81,851 12,732 534 1,569 80,282 3,940 5,790 86,072 1,888 25-Aug 4,032 82,040 76,719 527 1,569 26-Aug 28-Aug 31-Aug 31-Aug 524 5,321 3,800 4,032 18,266 94,985 538 2,100 92,885 5,992 148 Int 93,033 2,100 31-Aug SC 150 92,883

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Based on the information in the worksheet, Calculate: February Deposits in Transit: Date Amount February Outstanding Checks: Check # Amount
Bank reconciliation: Current book balance: $19,250 Balance per bank statement: $15,000 Outstanding checks: $2,000 Bank fees: $250 Deposits in transit: $6,000 What is the reconciled cash amount?
aj.2
Adjusted cash balance?
Long Branch Company's Cash account shows an ending balance of $650. The bank statement shows a $12 service charge and an NSF check for $200. A $270 deposit is in transit, and outstanding checks total $450. What is Long Branch's adjusted cash balance? A. $438 B. $470 OC. $258 D. $862 OOO
Balance, December 31, 2018 $3,340 ADD: Deposit in transit 100 3,440 LESS: Outstanding checks $400 400 Adjusted bank balance, December 31, 2018 $3,040 Book: Balance, December 31, 2018 $2,540 ADD: Bank collection $510 Interest revenue 20 530 3,070 LESS: Service charge $30 30 Adjusted book balance, December 31, 2018 $3,040
Using the following information: The bank statement balance is $5,175. The cash account balance is $5,503. Outstanding checks amounted to $712. Deposits in transit are $998. The bank service charge is $33. A check for $76 for supplies was recorded as $67 in the ledger. Prepare a bank reconciliation for Candace Co. for May 31. Candace Co.Bank ReconciliationMay 31 Cash balance according to bank statement $fill in the blank 1 Adjustments: $- Select - - Select - Total adjustments fill in the blank 6 Adjusted balance $fill in the blank 7 Cash balance according to company's records $fill in the blank 8 Adjustments: $- Select - - Select - Total adjustments fill in the blank 13 Adjusted balance $fill in the blank 14
QUESTION 9 The Gatedown Company's bank statement has an ending cash balance of $14,110.00. The cash account in the general ledger has a balance of $12,477.00. Based on the following reconciling items, prepare a bank reconciliation. a) Bank service charge of $20.00 b) Deposit in transit $3,190.00 c) A check was returned NSF $645.00 d) Outstanding check $688.00 e) Note collected by the bank, credit memoranda, $4,800.00 What is the total of subtractions to arrive at the book balance? A) 645.00 B) 555.00
nta 22 Coronado has the following assets at December 31, 2019. Cash in bank-savings account 134,000 Certificates of deposit (270-day) 226,000 sponder a como Cash on hand 1,600 Postdated checks 6,000 Cash refund due from State Taxing Authority 32,100 Checking account balance 12,000 What amount should be reported as cash? arcar nta O a. 135,600 O b. 134,000 O c. 179,700 O d. 147,600 pe here to search
Hi please use the excel template
Using the following information: Bank balance: $3,678 Book balance: $2,547 Deposits in transit: $321 Outstanding checks: $108 and $334 Bank charges: $25 Notes receivable: $1,000; interest: $35 and using the following accounts/items: Bank Errors Bank Service Charges Cash Deposits in Transit Interest Expense Interest Income Notes Receivable Outstanding Checks you are to prepare a bank reconciliation: Bank Balance [ Select ] Book Balance [ Select] Add items: Add items: [ Select ] [ Select ] [ Select] [ Select ] [ Select ] [ Select ] [ Select ] [ Select ] Less items: Less items: [ Select ] [ Select ] [ Select] [ Select ] [ Select ] [ Select ] [ Select] [ Select ] Adjusted Bank Bal. [ Select ] Adjusted Book Bal. [ Select ] PLEASE NOTE: For the above reconciliation, if no dollar amount is needed, please use "$0" or if no item is needed, please use "None" - no quotation marks. You must enter the account and item names exactly as written above and all dollar amounts will be with "$" and commas…