Question

In: Accounting

Exercise 7-09 Helen Sells is unable to reconcile the bank balance at January 31. Helen’s reconciliation...

Exercise 7-09

Helen Sells is unable to reconcile the bank balance at January 31. Helen’s reconciliation is shown here.

Cash balance per bank

$4,297.20

Add: NSF check

595.00

Less: Bank service charge

51.50

Adjusted balance per bank

$4,840.70

Cash balance per books

$4,595.20

Less: Deposits in transit

566.50

Add: Outstanding checks

915.00

Adjusted balance per books

$4,943.70


(a) What is the proper adjusted cash balance per bank? (Round answers to 2 decimal places, e.g. 52.75.)

The proper adjusted cash balance per bank $Enter a dollar amount rounded to 2 decimal places


(b) What is the proper adjusted cash balance per books? (Round answers to 2 decimal places, e.g. 52.75.)

The proper adjusted cash balance per books $Enter a dollar amount rounded to 2 decimal places


(c) Prepare the adjusting journal entries necessary to determine the adjusted cash balance per books. (Round answers to 2 decimal places, e.g. 52.75. Credit account titles are automatically indented when amount is entered. Do not indent manually.)

Date

Account Titles and Explanation

Debit

Credit

Jan. 31

Enter an account title to record NSF check on January 31 Enter a debit amount Enter a credit amount
Enter an account title to record NSF check on January 31 Enter a debit amount Enter a credit amount
(To record NSF check)

Jan. 31

Enter an account title to record bank service charge on January 31 Enter a debit amount Enter a credit amount
Enter an account title to record bank service charge on January 31 Enter a debit amount Enter a credit amount

(To record bank service charge)

Solutions

Expert Solution

a The proper adjusted cash balance per bank          [Refer working note 1] $3,948.70
b The proper adjusted cash balance per books        [Refer working note 2] $3,948.70

.

.

C. Prepare the adjusting journal entries necessary to determine the adjusted cash balance per books

Date Account Ttitles and Explanation Debit Credit
Jan. 31 Accounts receivable $595
     Cash $595
(To record NSF check)
Jan. 31 Bank charges expense $51.50
     Cash $51.50
(To record bank service charges)

.

.

Working note 1 - Computation of adjusted cash balance as per bank
Amount
Cash balance per bank $4,297.20
Add: Deposits in transit $566.50
Less: Outstanding checks $915.00
Adjusted balance per bank          [$4,297.20 + $566.50 - $915] $3,948.70

.

.

Working note 2 - Computation of adjusted cash balance as per books
Amount
Cash balance per books $4,595.20
Less: NSF check $595.00
Less: Bank service charge $51.50
Adjusted balance per books    [$4,595.20 - $595 - $51.50] $3,948.70

Related Solutions

Elizabeth Sells is unable to reconcile the bank balance at January 31. Elizabeth’s reconciliation is shown...
Elizabeth Sells is unable to reconcile the bank balance at January 31. Elizabeth’s reconciliation is shown here. Cash balance per bank $4,272.20 Add: NSF check 565.00 Less: Bank service charge 45.50 Adjusted balance per bank $4,791.70 Cash balance per books $4,570.20 Less: Deposits in transit 572.50 Add: Outstanding checks 885.00 Adjusted balance per books $4,882.70 (a) What is the proper adjusted cash balance per bank? (Round answers to 2 decimal places, e.g. 52.75.) The proper adjusted cash balance per bank...
Everest Ltd’s bank reconciliation clerk is trying to reconcile the bank balance at 31 July 2019....
Everest Ltd’s bank reconciliation clerk is trying to reconcile the bank balance at 31 July 2019. The balance of the Cash at Bank account, before any entries for transactions initiated by the bank, was $2,930 in the company records. On 31 July 2019, Everest Ltd has following information. The bank statement balance is $2,306. The Cash at Bank account balance is $2,930 Unpresented cheques totalled $585. Outstanding deposit $1,175. The bank service charge is $25. A cheque for $98 was...
Prepare a bank reconciliation for Grace, Inc., as of January 31, from the following information: (a.)...
Prepare a bank reconciliation for Grace, Inc., as of January 31, from the following information: (a.) The January 31 cash balance in the general ledger is $5,088. (b.) The January 31 balance shown on the bank statement is $4,544. (c.) Checks issued but not returned with the bank statement were No. 435 for $452 and No. 448 for $182. (d.) A deposit made on January 31 for $1,280 was included in the general ledger balance but not in the bank...
Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the...
Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the following format. I am not going to be particular about how you show your numbers as long as you have them in the right spot and can get to the correct adjusted balances. Bank Balance: Cash Balance: Add: Add: Deduct: Deduct: Adjusted Balance: Adjusted Balance: Journalize the necessary entries. After completing the bank reconciliation show any necessary journal entries. Pretend you have a general...
7. The cash account shows a balance of $62,000 before reconciliation. The bank statement does not...
7. The cash account shows a balance of $62,000 before reconciliation. The bank statement does not include a deposit of $4,800 made on the last day of the month. The bank statement shows a collection by the bank of $1,500 and a customer's check for $635 was returned because it was NSF. A customer’s check for $580 was recorded on the books as $850, and a check written for $252 was recorded as $525. What is the correct balance in...
Bank Reconciliation The cash account of Abstract, Inc., disclosed a balance of $16,348.82 on October 31....
Bank Reconciliation The cash account of Abstract, Inc., disclosed a balance of $16,348.82 on October 31. The bank statement as of October 31 showed a balance of $19,711.75. Upon comparing the statement with the cash records, the following facts were developed.(a) Abstract’s account was charged on October 26 for a customer’s uncollectible check amounting to $1,927.(b) A 2-month, 8%, $1,350 customer’s note dated August 25, discounted on October 12, was dishonored October 26 and the bank charged Abstract $1,374.91, which...
Bank Reconciliation The bank reconciliation made by Sandler Company, a sole proprietorship, on March 31 showed:...
Bank Reconciliation The bank reconciliation made by Sandler Company, a sole proprietorship, on March 31 showed: Deposit in transit of $1,100 Outstanding checks no.797 $450 no.804 $890 The reconciled cash balance on March 31 was $11,720 The following bank statement is available for April 2012. Bank Statement TO Sandler Company April 30 Fairbanks, AK FAIRBANKS NATIONAL BANK Date Deposits No. Date Charges Date Balance Apr. 1 $1,100 804 Apr. 2 $890 Mar. 31 $11,960 3 1,680 807 3 730 Apr....
Bank reconciliation The company’s accounting intern has prepared the end-of-January bank reconciliation from the bank statement,...
Bank reconciliation The company’s accounting intern has prepared the end-of-January bank reconciliation from the bank statement, and is worried because the Adjusted Balance amounts do not agree. After reviewing the bank reconciliation, scroll down for the next steps in helping the intern. Murdstone Co. Bank Reconciliation January 31, 20Y5 1 Cash balance according to bank statement $23,557.98 2 Deduct deposit of May 31, not recorded by bank 12,125.25 3 $11,432.73 4 Add outstanding checks: 5 No. 124 $62.00 6 No....
Exercise 8-09 Crane Company sells one product. Presented below is information for January for Crane Company....
Exercise 8-09 Crane Company sells one product. Presented below is information for January for Crane Company. Jan. 1 Inventory 101 units at $4 each 4 Sale 80 units at $8 each 11 Purchase 144 units at $6 each 13 Sale 111 units at $9 each 20 Purchase 156 units at $7 each 27 Sale 100 units at $11 each Crane uses the FIFO cost flow assumption. All purchases and sales are on account. Assume Crane uses a periodic system. Prepare...
The bank portion of the bank reconciliation for the Fixar Company at January 31,2018 is as...
The bank portion of the bank reconciliation for the Fixar Company at January 31,2018 is as follows:                                                                                        FIXAR COMPANY                                                                                                                                                                                                       Bank Reconciliation                                                                                                                                                                         January 31, 2018                                                                                                                                                                                                                                                                                                                              Cash balance per bank                                                                                                                 $13,581.90                   Add: Deposits in transit                                                                                                                       1,432.80                                                                                                                                                                                       15,014.70 Less:        Outstanding checks                                                    Check Number Check Amount                                                                      3351        $1,089.20                                                                      3370                930.40                                                                      3371                844.50                                                                      3372                734.90                                                                      3374            1,050.00                                                                      3375            1,396.60                                                                                   6,045.60                                                                                                                                Adjusted cash balance per bank                                                                                                             $8,969.10 The...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT