The accountant of ABC has collected the following information for the month of July 2019. ABC’s bank statement for July 2019 shows the following data: Balance on 1 July as per bank $29,500 Balance on 31 July as per bank $15,907.45       The cash balance as per company records as of July 31 is $11,589.45. Further review of the data reveals the following information:   Errors: Check no115 for $1,226. The bank correctly paid the amount, but ABC recorded the check as $1,262.   Outstanding checks on July 31, total $5,904   Deposits in transit on July 31 total $2,201.40   Bank statement shows: A. Debit-NSF check: $425.60 B. Debit-bank fee $30 C. Credit- collection of note receivable for $1,000 plus interest earned $50 and bank collection fee $15.   Required: Prepare bank reconciliation on July 31, 2019.

Your firm’s cash book shows a credit bank balance of $1,240 at 30 April 2021. On comparison with the bank statement, you determine that there are unpresented cheques totalling $450, and a receipt of $140 which has not yet been passed through the bank account. The bank statement shows bank charges of $75 which have not been entered in the cash book.Please provide solution. The balance on the bank statement is: ______ Dr./Cr.

On 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…

The 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.

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.

On March 31, Sigment Company had a $44,547.60 checkbook balance. The bank statement showed a balance on that date of $46,574.10, and the following information on the bank statement had not been entered in the checkbook:   $24.75 Service charge $68.85 NSF charge   A review of the company’s bank statement and checkbook showed a deposit in transit of $3,919.44 and outstanding checks as follows:                   Number 234 for $281.34                 Number 236 for $445.12                 Number 237 for $2,901.60                 Number 238 for $2,411.48   Prepare a bank reconciliation in proper format.  List and total the outstanding checks at the bottom of the bank reconciliation.

Beckett 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 balance

These 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,000

The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $19,850. Cash balance according to the bank statement at July 31, $20,970. Checks outstanding, $4,030. Deposit in transit, not recorded by bank, $3,240. A check for $590 in payment of an account was erroneously recorded in the check register as $950. Bank debit memo for service charges, $30. a.  Prepare a bank reconciliation, using the format shown in Exhibit 14. Mathers Co. Bank Reconciliation July 31 Cash balance according to bank statement $         Adjusted balance $ Cash balance according to company's records $         Adjusted balance $ b.  If the balance sheet is prepared for Mathers Co. on July 31, what amount should be reported for cash?$ c.  Must a bank reconciliation always balance (reconcile)?

The following data were accumulated for use in reconciling the bank account of Mathers Co. for July: Cash balance according to the company's records at July 31 $14,720. Cash balance according to the bank statement at July 31, $15,730. Checks outstanding, $2,990. Deposit in transit, not recorded by bank, $2,400. A check for $270 in payment of an account was erroneously recorded in the check register as $720. Bank debit memo for service charges, $30. a.  Prepare a bank reconciliation, using the format shown in