Question
In: Accounting
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. 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 | $ | |
| Adjustments: | ||
| Total adjustments | ||
| Adjusted balance | $ | |
| Cash balance according to company's records | $ | |
| Adjustments: | ||
| $ | ||
| Total adjustments | ||
| Adjusted balance | $ | |
b. If the balance sheet were prepared for
Maplewood Co. on August 31, 2016, what amount should be reported
for cash?
$
c. Must a bank reconciliation always balance
(reconcile)?
Solutions
Expert Solution
| a) | BaNk Reconciliation Statement | |||||
| Creative Design Co. | ||||||
| Bank Reconciliation | ||||||
| Aug 31, 20Y6 | ||||||
| Cash Balance according to bank statement | $21,020 | |||||
| Adjustment | ||||||
| Less : Checks Outstanding | $4,100 | |||||
| Less: Errorly payment of 340 return return as 430 in company books | ||||||
| ( 430 - 340) | $90 | $4,190 | ||||
| $16,830 | ||||||
| Add: Deposit in trasit not recorded in bank | $3,290 | |||||
| Add: Bank Debit memo For Service Charges | $60 | $3,350 | ||||
| Cash Balance according to Company Records | $20,180 | |||||
| Alternate | ||||||
| Cash Balance according to Company Records | $20,180 | |||||
| Adjustment | ||||||
| Add : Checks Outstanding | $4,100 | |||||
| Add: Errorly payment of 340 return return as 430 in company books | ||||||
| ( 430 - 340) | $90 | $4,190 | ||||
| $24,370 | ||||||
| Less: Deposit in trasit not recorded in bank | $3,290 | |||||
| Less: Bank Debit memo For Service Charges | $60 | $3,350 | ||||
| Cash Balance according to bank statement | $21,020 | |||||
| b) | If Balance Sheet Cash Balance To be recorded in baalance sheet | |||||
| Cash Balance according to Company Records | $20,180 | |||||
| Less Service charges | $60 | |||||
| Add: Errorly payment of 340 return return as 430 in company books | ||||||
| ( 430 - 340) | $90 | |||||
| Cash Balance in Balance Sheet | $20,210 | |||||
| C) | Bank reconcilition is prepare to reconclie cash balance as per company records and cash balance as per bank statement so must reconcile that mention reason why balance differ | |||||
ekkarill92 answered 2 years agoRelated 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,
$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....
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...
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 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....
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...
1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance...
1. Kreiger Corporation developed the following reconciling
information in preparing its July bank reconciliation:
Bank balance before
reconciliation
$23,000
Note receivable collected by
bank
7,500
Outstanding
checks
15,000
Deposits in
transit
8,000
Bank service
charge
100
NSF
check
1,800
Determine the cash balance per books (before adjustments) for
Kreiger.
2. Kendall Corporation had a 1/1/19 balance in the Allowance for
Doubtful Accounts of $18,000. During 2019, it wrote off $11,500 of
accounts and collected...
Gunnar Company gathered the following reconciling information in preparing its September bank reconciliation. Calculate the adjusted...
Gunnar Company gathered the following reconciling information in
preparing its September bank reconciliation. Calculate the adjusted
cash balance per books on September 30.
Cash balance per books, September 30
$ 3,181
Deposits in transit
421
Notes receivable and interest collected by bank
888
Bank charge for check printing
29
Outstanding checks
1,347
NSF check
144
a.$2,970
b.$3,896
c.$2,255
d.$3,114
Bank Reconciliation
The following data were accumulated for use in reconciling the
bank account of Mathers Co. for July:
Cash balance...
Derek Company gathered the following reconciling information in preparing its September bank reconciliation: Cash balance per...
Derek Company gathered the following reconciling information in
preparing its September bank reconciliation:
Cash balance per books, 9/30 $2,190
Deposits in transit 572
Notes receivable and interstate's collected by bank. 879
Bank charge for check printing 29
Outstanding checks 1,322
NSF 178
Find the adjusted cash balance per books on September 30.
Select the correct answer.
$2,862
$2,112
$1,440
$2,290
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
- Question 2 : Aggregate Scores: Write a program that opens 2 files, quiz.txt, and hw.txt. The...
- Define the term symbiosis specifically as it applies in a biological context. Compare and contrast parasitism,...
- A research team conducted a study showing that approximately 20% of all businessmen who wear ties...
- Research the internet for companies that have executed data science projects. Pick one company and describe...
- Explain two theories or frameworks for understanding how Western Europe emerged out of 1,000 years of...
ADVERTISEMENT