The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: 1. Cash balance according to the company's records at August 31, $42,920. 2. Cash balance according to the bank statement at August 31, $56,300, 3. Checks outstanding, $25,390. 4. Deposit in transit not recorded by bank, $13,325. 5. A check for $150 in payment of an account was erroneously recorded in the check register as $1,500. 6. Bank debit memo for service charges, $35. a. Prepare a bank reconciliation, using the format shown in Exhibit 13. Creative Design Co. Bank Reconciliation August 31, 20Y6 Cash balance according to bank statement Add: Deposit in transit on August 31 Deduct: Outstanding checks Adjusted balance Cash balance according to company's records Adjusted balance poooooool

The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: 1. Cash balance according to the company's records at August 31, $42,920. 2. Cash balance according to the bank statement at August 31, $56,300, 3. Checks outstanding, $25,390. 4. Deposit in transit not recorded by bank, $13,325. 5. A check for $150 in payment of an account was erroneously recorded in the check register as $1,500. 6. Bank debit memo for service charges, $35. a. Prepare a bank reconciliation, using the format shown in Exhibit 13. Creative Design Co. Bank Reconciliation August 31, 20Y6 Cash balance according to bank statement Add: Deposit in transit on August 31 Deduct: Outstanding checks Adjusted balance Cash balance according to company's records Adjusted balance poooooool

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

The following data were accumulated for use in reconciling the bank account of Nakajima Co. for July: Cash balance according to the company's records at July 31, $49,910. Cash balance according to the bank statement at July 31, $48,250. Checks outstanding, $4,460. Deposit in transit, not recorded by bank, $6,450. A check for $590 issued in payment of an account was erroneously recorded in the check register as $950. Bank debit memo for service charges, $30. Journalize the entries that should be made by the company, part (a) Error and part (b) Service Charge. If an amount box does not require an entry, leave it blank. a. July 31 Accounts PayableAccounts ReceivableCashPetty CashService RevenueCash Cash Cash Accounts PayableAccounts ReceivableCash Short and OverNotes ReceivablePetty Cash - Select - - Select - b. July 31 Accounts PayableAccounts ReceivableMiscellaneous ExpensePetty CashService Revenue - Select - - Select - Accounts ReceivableCashCash Short and…
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 $27,900. Cash balance according to the bank statement at July 31, $29,040. Checks outstanding, $5,660. Deposit in transit, not recorded by bank, $4,550. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $60. a. Prepare a bank reconciliation, using the format shown in Exhibit 14.
The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $32,527. During October, the total cash deposited was $139,121, and checks written totaled $135,890. The bank statement indicated a balance of $43,660 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: a. Checks outstanding totaled $6,625. b. A deposit of $1,888 representing receipts of October 31, had been made too late to appear on the bank statement. c. The bank had collected for Coastal Bike Co. $5,250 on a note left for collection. The face of the note was $5,000. d. A check for $260 returned with the statement had been incorrectly charged by the bank as $620. e. A check for $410 returned with the statement had been recorded by Coastal Bike Co. as $140. The check was for the payment of an obligation to Rack Pro Co. on account. f. Bank service charges for October amounted to $37.…
The June 30 cash balance in the general ledger is $785. The June 30 balance shown on the bank statement is $288. Checks issued but not returned with the bank statement were Number 712 for $13 and Number 723 for $44. A deposit made late on June 30 for $472 is included in the general ledger balance but not in the bank statement balance. Returned with the bank statement was a notice that a customer's check for $73 that was deposited on June 24 had been returned because the customer's account was overdrawn. During a review of the checks that were returned with the bank statement, it was noted that the amount of Check Number 728 was $65 but that in the company's records supporting the general ledger balance, the check had been erroneously recorded as a payment of an account payable in the amount of $56. Required: Show the reconciling items in a horizontal model that should be prepared to reflect the reconciling items as on June 30. Prepare the adjusting journal entry that should be…
The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $21,880. Cash balance according to the bank statement at August 31, $23,260. Checks outstanding, $4,440. Deposit in transit, not recorded by bank, $3,570. A check for $170 in payment of an account was erroneously recorded in the check register as $710. Bank debit memo for service charges, $30. a. Prepare a bank reconciliation, using the format shown in Exhibit 13. Creative Design Co.Bank ReconciliationAugust 31, 20Y6 Cash balance according to bank statement $fill in the blank edbfa3fe702204a_1 Adjustments: - Select - - Select - Total adjustments fill in the blank edbfa3fe702204a_6 Adjusted balance $fill in the blank edbfa3fe702204a_7 Cash balance according to company's records $fill in the blank edbfa3fe702204a_8 Adjustments: $- Select - -…
The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $146,035. The bank statement indicated a balance of $181,965 on June 30, 20Y1. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: A. Checks outstanding totaled $16,445. B. A deposit of $9,900, representing receipts of June 30, had been made too late to appear on the bank statement. C. The bank collected $31,800 on a $30,000 note, including interest of $1,800. D. A check for $2,000 returned with the statement had been incorrectly recorded by Pala Medical Co. as $200. The check was for the payment of an obligation to Skyline Supply Co. for a purchase on account. E. A check drawn for $170 had been erroneously charged by the bank as $710. F. Bank service charges for June amounted to $75. 1. Prepare a bank reconciliation. Refer to the Amount Descriptions list provided for the exact wording of the answer…
The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company’s records at August 31, $42,920. Cash balance according to the bank statement at August 31, $56,300. Checks outstanding, $25,390. Deposit in transit not recorded by bank, $13,325. A check for $150 in payment of an account was erroneously recorded in the check register as $1,500. Bank debit memo for service charges, $35. Question Content Area a. Prepare a bank reconciliation, using the format shown in Exhibit 13. Creative Design Co.Bank ReconciliationAugust 31, 20Y6 Cash balance according to bank statement blank $fill in the blank 0ff66e00407e061_1 - Select - blank - Select - Adjusted balance blank $fill in the blank 0ff66e00407e061_6 Cash balance according to company's records blank $fill in the blank 0ff66e00407e061_7 blank - Select - blank - Select - Adjusted balance blank $fill in the…
Using the following information: (a) The bank statement balance is $5,389. (b) The cash account balance is $5,686. (c) Outstanding checks amounted to $736. (d) Deposits in transit are $961. (e) The bank service charge is $63. (f) A check for $50 for supplies was recorded as $41 in the ledger. Required: Prepare a bank reconciliation for Candace Co. for May 31. Be sure to complete the statement heading. Refer to the Labels and Amount Descriptions provided for the exact wording of the answer choices for text entries. “Deduct” or “Add” will automatically appear if it is required. Enter all amounts as positive values.
Bank reconciliation and entriesThe cash account for Stone Systems at July 31, 20Y5, indicated a balanceof $17,750. The bank statement indicated a balance of $33,650 on July 31,20Y5. Comparing the bank statement and the accompanying canceledchecks and memos with the records reveals the following reconcilingitems: A. Checks outstanding totaled $17,865.B. A deposit of $9,150, representing receipts of July 31, had beenmade too late to appear on the bank statement.C. The bank had collected $6,095 on a note left for collection. Theface of the note was $5,750.D. A check for $390 returned with the statement had been incorrectly recorded by Stone Systems as $930. The check was forthe payment of an obligation to Holland Co. for the purchase ofoffice supplies on account.E. A check drawn for $1,810 had been incorrectly charged by thebank as $1,180.F. Bank service charges for July amounted to $80. Instructions1. Prepare a bank reconciliation.2. Journalize the necessary entries.3. If a balance sheet…
The April 30 bank statement for Shopify Corporation shows an ending balance of $34.351. The unadjusted cash account balance was $28,250. The accountant for Shopify gathered the following information: 1. There was a deposit in transit for $4,240. 2. The bank statement reports a service charge of $39. 3. A credit memo included in the bank statement shows interest earned of $95 4. Outstanding checks totaled $10,935 5. The bank statement included a $650 NSF check deposited in April. What is the true cash balance as of April 30? Multiple Choice $27656 $27006 $31B01
The following data were accumulated for use in reconciling the bank account of Creative Design Co. for August 20Y6: Cash balance according to the company's records at August 31, $14,740. Cash balance according to the bank statement at August 31, $15,650. Checks outstanding, $2,990. Deposit in transit, not recorded by bank, $2,400. A check for $480 in payment of an account was erroneously recorded in the check register as $840. Bank debit memo for service charges, $40. Question Content Area a. Prepare a bank reconciliation, using the format shown in Exhibit 13.
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, $27,010. Cash balance according to the bank statement at July 31, $28,120. Checks outstanding, $5,480. Deposit in transit, not recorded by bank, $4,400. A check for $340 in payment of an account was erroneously recorded in the check register as $430. Bank debit memo for service charges, $60. Journalize the entries that should be made by the company, part (A) Error and part (B) Service Charge. a. July 31 b. July 31