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, $26,070.2. Cash balance according to the bank statement at August 31, $27,620.3. Checks outstanding, $5,290.4. Deposit in transit, not recorded by bank, $4,250.5. A check for $170 in payment of an account was erroneously recorded in the check register as $710.6. 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, 20Y6Cash balance according to bank statementAdjusted balanceCash balance according to company's recordsAdjusted balanceb. If the balance sheet were prepared for Creative Design Co. on August 31, what amount should be reported for cash?c. Must a bank reconciliation always balance (reconcile)?

A bank reconciliation statement is a summary of cash balance as per Bank and as per Books that…

Answered: The following data were accumulated for…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Using the following information, prepare the journal entries to reconcile the bank statement. Bank balance: $6,988 Book balance: $8,923 Deposits in transit: $1,875 Outstanding checks: $569 and $1,423 Bank service charges: $75 Bank incorrectly charged the account $75. The bank will correct the error next month. Check number 2456 correctly cleared the bank in the amount of $123 but posted in the accounting records as $213. This check was expensed to Utilities Expense. If an amount box does not require an entry, leave it blank.
Refer to the Information given below: a. The August 31 balance shown on the bank statement is $9,050. b. There is a deposit in transit of $1,300 at August 31. c. Outstanding checks at August 31 totaled $1,620. d. Interest credited to the account during August but not recorded on the company's books amounted to $68. e. A bank charge of $44 for checks was made to the account during August. Although the company was expecting a charge, the amount was not known until the bank statement arrived. f. In the process of reviewing the canceled checks, it was determined that a check issued to a supplier in payment of accounts payable of $142 had been recorded as a disbursement of $412 g. The August 31 balance in the general ledger Cash account, before reconciliation, is $8,436. Required: Prepare a bank reconciliation as of August 31 from the above Information. Balance per bank Add: Deduct: Reconciled balance Bank Reconciliation August 31 Balance per books Add: Deduct: Reconciled balance
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. Journalize the entries that should be made by the company that (a) increase cash and (b) decrease cash. If an amount box does not require an entry, leave it blank.
1. Cash balance according to the company's records at August 31, $25,520. 2. Cash balance according to the bank statement at August 31, $26,850. 3. Checks outstanding, $5,180. 4. Deposit in transit, not recorded by bank, $4,160. 5. A check for $480 in payment of an account was erroneously recorded in the check register as $840. 6. Bank debit memo for service charges, $50. Prepare Bank Reconciliation statement?
The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $93,115. The bank statement indicated a balance of $125,800 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 $30,080. b. A deposit of $19,240, representing receipts of June 30, had been made too late to appear on the bank statement. c. The bank collected $24,075 on a $2,500 note, including interest of $1,575. d. A check for $1,800 returned with the statement had been incorrectly recorded by Pala Medical Co. as $180. The check was for the payment of an obligation to Skyline Supply Co. for a purchase on account. e. A check drawn for $390 had been erroneously charged by the bank as $930. f. Bank service charges for June amounted to $50. Instructions 1. Prepare a bank reconciliation. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for…
The following data were gathered to use in reconciling the bank account of Reddan Company: Balance per bank $18,250 Balance per company records 12,045 Bank service charges 30 Deposit in transit 3,500 Note collected by bank with $160 interest 4,160 Outstanding checks 5,575 a. What is the adjusted balance on the bank reconciliation? b. Journalize any necessary entries for Reddan Company based on the bank reconciliation. For a compound transaction, if an amount box does not require an entry, leave it blank. ? ? ? ? ? ? ? ? ? ? ? ? ? Please don't provide images in answers thank you
The following data were accumulated for use in reconciling the bank account of Kaycee Sisters Inc. for August 20Y9: Cash balance according to the company's records at August 31, $16,840. Cash balance according to the bank statement at August 31, $17,570. Checks outstanding, $3,420. Deposit in transit, not recorded by bank, $2,740. A check for $340 in payment of an account was erroneously recorded by Kaycee Sisters Inc. as $430. Bank debit memo for service charges, $40. Prepare a bank reconciliation, using the format shown in Exhibit 12.
Prepare a bank reconciliation from the following information:a. Balance per bank statement as of May 31, $17,755.44b. Balance per books as of May 31, $12,211.94c. Deposits in transit, $2,254.81d. Outstanding checks, $7,819.16e. Bank service charge, $20.85
Entries for Bank Reconciliation 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, $22,240. Cash balance according to the bank statement at July 31, $23,450. Checks outstanding, $4,510. Deposit in transit, not recorded by bank, $3,630. 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. Journalize the entries that should be made by the company, part (A) Error and part (B) Service Charge. a. July 31 b. July 31
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. Question Content Area a. Prepare a bank reconciliation, using the format shown in Exhibit 12. Nakajima Co.Bank ReconciliationJuly 31 Cash balance according to bank statement $fill in the blank 8740c9ff3f91023_1 - Select - - Select - Adjusted balance $fill in the blank 8740c9ff3f91023_6 Cash balance according to company's records $fill in the blank 8740c9ff3f91023_7 - Select - - Select - Adjusted balance $fill in the blank 8740c9ff3f91023_12 Question Content Area b. If the…
answer in text form please (without image)
Rexrode Company's bank statement at January 31 showed an ending balance of $24,712.80. The unadjusted cash account balance for Rexrode is $21,245.75. The following data were gathered by Rexrode's accountant: Outstanding checks as of January 31: $4,895.44 ● NSF check from customer: $183.62 • Debit memo related to the returned deposit: $20.00 Credit memo for interest earned: $12.00 • Deposits in transit: $1,236.77 Required: a. Prepare a bank reconciliation for Rexrode Company at January 31. b. Indicate how each of the required adjusting entries impact the financial statements. . • Complete this question by entering your answers in the tabs below. Required A Required B Indicate how each of the required adjusting entries impact the financial statements. Note: Enter any decreases to account balances and cash outflows with a minus sign. Leave cells blank if no input is needed. Round your answers to 2 decimal places. Item Outstanding checks NSF check from a customer Debit memo related to the…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS