Concept explainers
Smith Company started its business on november 1,2020,below is the information needed to prepare a bank reconciliation for the business as at November 30,2020:
i) Balance per bank statement was $34100.
ii)$1300 check drawn by a customer johnson had been marked "NSF"in November and the company received this notice at the beginning of december 2020.
iii)Cash receipts of $8000 recorded on November 2020 were not deposited to bank unti; december 1.
iv)Bank service charge for November 2020 amounted $38 was sent to the company together with the bank statement.
v)Check #620 for $4000 had been issued in November but was npt presented to the bank for payment.
vi)Check #643 for electricity expense cleared the bank for $268 but was erroneously recorded in our books as $240.
vii) A $486 deposit by Easy Co.was erroneously credited to our account by the bank.
viii)the bank statement showed $30 interest earned on the bank for the month of November 2020.
Requieed:
Prepare a
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- SMU Tax Services gathered the following information to prepare their bank reconciliation for the month of October, 2021 Cash Balance according to the bank statement at Oct. 31, 2021 = $11,935 Cash Balance according to the company’s records at Oct. 31, 2021 = $11,185 Deposits in transit at Oct. 31, 2021 = $1,125 Outstanding checks at Oct. 31, 2021 = $2,080 A deposit of $20 was incorrectly recorded by the company as $200 The bank assessed a service charge of $25arrow_forwardXYZ Inc is preparing the October month-end Bank Reconciliation. The balance in the cash ledger on October 31 was $1,900. Some adjustments to this cash ledger balance were recorded on the Bank Reconciliation Report, as follows: • Bank service charge $55 NSF cheque: $375 • Cheque # 40 was correctly written and processed for $3,030 however the XYZ bookkeeper recorded the cheque amount for $3,300. What is the adjusted cash balance for October 31, for the Bank Reconciliation Report? Show your basic math.arrow_forward1) The "I am Definitely Switching My Major to Accounting Company" received its bank statement for the month ended October 31, 2023. To prepare the bank reconciliation $22do you gather the following data: - a) The balance per the bank statement is $16,292 b) The checkbook balance is $15,650 c) The bank statement shows an NSF Check from one of the company's customers in the amount of $895.00 d) There is a bank service charge of $45.00 on the bank statement e) Outstanding checks total $847.00 and deposits in transit total $1416.00 f) The bank statement shows collection of a note receivable in the amount of $2000 plus interest of $200.00 less a bank fee of $49.00 Required: Prepare a bank reconciliation using the above informationarrow_forward
- I need help with questionarrow_forwardOn December 31, 2021, the cash account of Coco Corp, showed a balance of P391,480. The bank statement on that date showed a balance of P409,500. Upon examining the cash records and the bank statement, the following information were determined.a. There was a bank service charge of P 1,500 for the month of December 2021.b. There was a credit memo for a note collected by the bank for oOco Corp. The customer’s note is P90,000 with interest of P2,600. The bank charged a collection fee of P550c. December 31, 2021 receipts for P289,000 were deposited only on January 2, 2022d. Checks issued which have not yet cleared the bank as at December 31,2021 amounts to P186,610e. There is a debit memo for P45,320 for a customer’s check returned marked “DAIF”f. A receipt of P90,000 had been entered as P60,000 in the cash book. Check # 12345 issued amounting to P49,100 was erroneously recorded as P41,900 and check # 12346 issued in the correct amount of P5,820 had been taken up as P58,200.What is the…arrow_forwardThe accountant of Sophia Manufacturing Company was tasked to perform monthly bank reconciliation. She downloaded the company’s April 30, 2019 bank statement that showed a balance of P32,400. She also printed the cash ledger from the company’s computerized accounting system. It contains the ending balance of P8,350. She also found the following reconciling items:a. The bank statement showed bank service fee of P800.b. The bank collected P1,500 from a note receivable for Sophia Manufacturing. Also, a collection fee of P250.00 was charged.c. Deposit in transit, P51,000.d. Checks outstanding on April 30, P79,100.e. The accountant found a check issued to Rhys Corp. for P4,500 that cleared the bank but was not in the cash ledger. Requirement:a. Prepare the bank reconciliation statement.b. Journalize the adjusting entries.arrow_forward
- The cash account for Santiago Co. on May 31, 2021 indicated a balance of $15,515.00. The March bank statement indicated an ending balance of $20,245.00. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: a. Checks outstanding totaled $4,820.00 b. A deposit of $3,796.00 had been made too late to appear on the bank statement. c. A check for $1,233.00 returned with the statement had been incorrectly recorded as $233.00. The check was originally for a vendor payment on account. d. The bank collected $5,541.00 on a note left for collection. e. Bank service charges for May amounted to $45.00. f. A check for $790.00 was returned by the bank because of insufficient funds. Prepare a bank reconciliation as of May 31, 2021. Journalize the necessary entries.arrow_forward1) Prepare a bank reconciliation dated December 31, 2020, for Welcome Inc. based on the following information. Balance per bank statement is $21,200.68. Balance per books is $20,559.40. The December bank statement indicated a service charge of $35. Cheque #1169 for $410.50 and cheque #1183 for $2,150.00 were not returned with the bank statement. The bank had not received a deposit in transit of $3,443.22 when the bank statement was generated. A bank debit memo indicated an NSF cheque written by Bill Broke to Welcome Inc. on December 11, 2020, for $169. A bank credit memo indicated a bank collection of $1,700 and interest revenue of $28 on December 15, 2020.arrow_forwardFrom the following particulars of Mark & Co. prepare a bank reconciliation statement as on August 31, 2017. 1. Balance as per the cash book $ 54,000. 2. $ 100 bank incidental charges debited to Anil & Co. account, which is not recorded in cash book. 3. Cheques for $ 5,400 is deposited in the bank but not yet collected by the bank. 4. A cheque for $ 20,000 is issued by Anil & Co. not presented for payment.arrow_forward
- Serato Company keeps all its cash in a checking account. An examination of the entity’s accounting records and bank statement for the month ended December 31, 2020 revealed a bank statement balance of P8,469,000 and a book balance of P8,524,000. A deposit of P950,000 placed in the bank’s night depository on December 29 does not appear on the bank statement. Checks outstanding on December 31 amount to P270, 000. The bank statement shows that on December 25, the bank collected a note for Serato Company and credited the proceeds of P935,000 to the entity’s account. The proceeds included P35,000 interest, all of which Serato Company earned during the current period. Serato Company has not yet recorded the said collection. Serato Company discovered that check number 1000759 written in December for P183,000 in payment of an account had been recorded in the…arrow_forwardBeckett Co. received its bank statement for the month ending June 30, 2019, and reconciled the statement balance to the June 30, 2019, balance in the Cash account. The reconciled balance was determined to be $6,428. The reconciliation recognized the following items: 1. Deposits in transit were $3,335. 2. Outstanding checks totaled $2,612. 3. Bank service charges shown as a deduction on the bank statement were $80. 4. An NSF check from a customer for $671 was included with the bank statement. Beckett Co. had not been previously notified that the check had been returned NSF. 5. Included in the canceled checks was a check written for $770. However, it had been recorded as a disbursement of $940. Required: Prepare the Bank reconciliation statement for the month ending June 30, 2019. BECKETT COMPANY Bank Reconciliation June 30, 2019 Balance per bank Balance per books Add: Add: Deduct: Deduct: Reconciled balance $ O Reconciled balancearrow_forwardThese data pertain to St. Luke Company as of December 31, 2020: Bank service charge not recorded by St. Luke Bank statement, December 31 Checks outstanding (including certified check of P20,000) Customer note collected by bank for St. Luke Deposit in transit Error made by the bank in recording check issued by St. Lucas Error made by the company in recording check that cleared the bank in December (check was drawn in December for P30,000 but recorded at P80,000) Technically defective checks of customers returned by bank 20,000 4,000,000 500,000 150,000 300,000 40.000 50,000 200,000 What is the cash balance per ledger on December 31, 2020? A. 3,980,000 B. 3,880,000 C. 3,860,000 D. 3,800,000arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education