Question

In: Accounting

Chapter 7 ex 07-18 The following data were accumulated for use in reconciling the bank account...

Chapter 7 ex 07-18

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, $24,556.
2. Cash balance according to the bank statement at August 31, $31,856.
3. Checks outstanding, $13,280.
4. Deposit in transit, not recorded by bank, $6,392.
5. A check for $48 in payment of an account was erroneously recorded in the check register as $480.
6. Bank debit memo for service charges, $20.
A. Prepare a bank reconciliation, using the format shown in

Exhibit 13

. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
B. 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)?
Amount Descriptions
Adjusted balance
Bank service charge
Bank error in charging check as $48 instead of $480
Bank error in charging check as $480 instead of $48
Deposit in transit, not recorded by bank
Error in recording check as $48 instead of $480
Error in recording check as $480 instead of $48
Outstanding checks
Total adjustments

A. Prepare a bank reconciliation, using the format shown in

Exhibit 13

. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Question not attempted.

Score: 0/88

Creative Design Co.

Bank Reconciliation

August 31, 20Y6

1

Cash balance according to bank statement

2

Adjustments:

3

4

5

6

7

8

Cash balance according to company’s records

9

Adjustments:

10

11

12

13

B. If the balance sheet were prepared for Creative Design Co. on August 31 what amount should be reported for cash? $________________




Solutions

Expert Solution

Solution

Creative Design Co.

  1. Creative Design Co.

Bank Reconciliation Statement

August 31, 20Y6

Cash balance according to bank statement

$31,856

Adjustments:

Deposits in transit

$6,392

Less: outstanding checks

($13,280)

($6,888)

Corrected cash balance

$24,968

Cash balance according to company records

$24,556

Adjustments:

Add: erroneous entry of check (480 - 48 = 432)

$432

Less: Bank service charges

($20)

$412

Corrected cash balance

$24,968

B Determination of the amount to be reported for cash in the company’s balance sheet:

If the balance sheet was prepared for Creative Design Co. on August 31, the amount to be reported for cash is $24,968.

C Must a bank reconciliation always balance:

Yes, the purpose of bank reconciliation is to tally the transactions involving bank with both the cash book and the bank version, the bank book. The books generally show differences between the balances for reasons of erroneous entries, electronic fund transfer, deposits in transit, outstanding checks, bank charges not debited in cash book and NSF checks. In order the books to show correct balances, the reasons should be tracked down and the differences to be corrected by providing the needed adjustments.


Related Solutions

Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative...
Bank Reconciliation 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, $20,300. Cash balance according to the bank statement at August 31, $21,600. Checks outstanding, $4,120. Deposit in transit, not recorded by bank, $3,310. A check for $170 in payment of an account was erroneously recorded in the check register as $710. Bank debit memo for service charges, $50. a....
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Creative...
Bank Reconciliation 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, $20,180. Cash balance according to the bank statement at August 31, $21,020. Checks outstanding, $4,100. Deposit in transit, not recorded by bank, $3,290. 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....
Bank Reconciliation The following data were accumulated for use in reconciling the bank account of Mathers...
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,130. Cash balance according to the bank statement at July 31, $23,520. Checks outstanding, $4,490. Deposit in transit, not recorded by bank, $3,610. 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 The following data were accumulated for use in reconciling the bank account of Creative...
Bank Reconciliation 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,900. Cash balance according to the bank statement at August 31, $15,900. Checks outstanding, $3,020. Deposit in transit, not recorded by bank, $2,430. A check for $270 in payment of an account was erroneously recorded in the check register as $720. Bank debit memo for service charges, $40. a....
The following data were accumulated for use in reconciling the bank account of Creative Design Co....
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, $20,014. 2. Cash balance according to the bank statement at August 31, $28,514. 3. Checks outstanding, $14,232. 4. Deposit in transit, not recorded by bank, $6,214. 5. A check for $55 in payment of an account was erroneously recorded in the check register as $550. 6. Bank debit memo for...
Bank Reconciliation The following data were gathered to use in reconciling the bank account of Azalea...
Bank Reconciliation The following data were gathered to use in reconciling the bank account of Azalea Company: Balance per bank $ 17,300 Balance per company records 8,170 Bank service charges 20 Deposit in transit 3,050 Note collected by bank with $150 interest 4,750 Outstanding checks 7,450 a. What is the adjusted balance on the bank reconciliation? $ b. Journalize any necessary entries for Azalea Company based on the bank reconciliation. If an amount box does not require an entry, leave...
Chapter 7 EX 7-03 The cash account for Pala Medical Co. at June 30, 20Y1, indicated...
Chapter 7 EX 7-03 The cash account for Pala Medical Co. at June 30, 20Y1, indicated a balance of $97,456. The bank statement indicated a balance of $127,960 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,050. B. A deposit of $19,720, representing receipts of June 30, had been made too late to appear on the bank statement. C. The bank...
Which of the following is a reconciling item on the bank side of a bank reconciliation?...
Which of the following is a reconciling item on the bank side of a bank reconciliation? 1. Cancelled cheques 2. Outstanding cheques 3. both outstanding cheques and NSF cheques 4. NSF cheques A cheque returned by a bank because the issuer's cash account balance could not cover the cheque is called: 1. a blank cheque 2. a certified cheque 3. a NSF cheque 4. an outstanding cheque On 1 January, Bochao Properties establishes a petty cash fund for $200. On...
chapter 7 lab -04 Bank Reconciliation and Entries The cash account for Collegiate Sports Co. on...
chapter 7 lab -04 Bank Reconciliation and Entries The cash account for Collegiate Sports Co. on November 1, 20Y9, indicated a balance of $81,145. During November, the total cash deposited was $293,150, and checks written totaled $307,360. The bank statement indicated a balance of $112,675 on November 30, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $41,840. A deposit of $12,200, representing receipts of November...
7. Chapter 13, Question 2: Use the attached data file “Chapter 13 Data Set 1” to...
7. Chapter 13, Question 2: Use the attached data file “Chapter 13 Data Set 1” to answer this question in the book. Do you agree with the author’s conclusion about whether practice time makes a difference? <15 Hours Practice 15-25 Hours Practice More than 25 Hours Practice 58.7 64.4 68 55.3 55.8 65.9 61.8 58.7 54.7 49.5 54.7 53.6 64.5 52.7 58.7 61 67.8 58.7 65.7 61.6 65.7 51.4 58.7 66.5 53.6 54.6 56.7 59 51.5 55.4 54.7 51.5 61.4...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT