Question

In: Accounting

Problem 7-14 (Algo) Bank reconciliation and adjusting entries [Appendix 7A] El Gato Painting Company maintains a...

Problem 7-14 (Algo) Bank reconciliation and adjusting entries [Appendix 7A]

El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows:

Balance per bank, November 30 $ 3,361
Add: Deposits outstanding 1,330
Less: Checks outstanding
#363 $ 136
#365 214
#380 69
#381 99
#382 220 (738 )
Adjusted balance per bank, November 30 $ 3,953


The company’s general ledger checking account showed the following for December:

Balance, December 1 $ 3,953
Receipts 43,950
Disbursements (43,153 )
Balance, December 31 $ 4,750


The December bank statement contained the following information:

  Balance, December 1 $ 3,361
  Deposits 44,300
  Checks processed (43,218 )
  Service charges (35 )
  NSF checks (570 )
  Balance, December 31 $ 3,838


The checks that were processed by the bank in December include all of the outstanding checks at the end of November except for check #365. In addition, there are some December checks that had not been processed by the bank by the end of the month. Also, you discover that check #411 for $620 was correctly recorded by the bank but was incorrectly recorded on the books as a $260 disbursement for advertising expense. Included in the bank’s deposits is a $2,600 deposit incorrectly credited to the company’s account. The deposit should have been posted to the credit of the Los Gatos Company. The NSF checks have not been redeposited and the company will seek payment from the customers involved.

Required:
1. Prepare a bank reconciliation for the El Gato checking account at December 31, 2021.
2. Prepare any necessary adjusting journal entries indicated.

Solutions

Expert Solution

1.

El Gato Painting Company
Bank Reconciliation
at December 31, 2021
Balance as per bank statement $   3,838
Add: Deposit in transit (43,950-44,300+2,600+1,330) $   3,580
Less:  
Outstanding checks (43,153-43,218+738+360) $   1,033
Bank error in recording of deposit $   2,600
$   3,633
Adjusted bank balance $   3,785
Balance as per company book   $   4,750
Less:
Service charges $        35
NSF Check $      570
Error in recording of check#411 ($620-260) $      360
$      965
Adjusted book balance $   3,785

2.

Date Account title Debit Credit
Misc. expenses/ bank charges $     35
Accounts receivable $   570
Advertising expenses $   360
Cash $   965

You can reach me over comment box, if you have any doubts. Please rate this answer


Related Solutions

El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows: Balance per bank, November 30 $ 3,421 Add: Deposits outstanding 1,390 Less: Checks outstanding #363 $ 142 #365 220 #380 75 #381 105 #382 280 (822 ) Adjusted balance per bank, November 30 $ 3,989 The company’s general ledger checking account showed the following for December: Balance,...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows: Balance per bank, November 30 $ 3,291 Add: Deposits outstanding 1,260 Less: Checks outstanding #363 $ 129 #365 207 #380 62 #381 92 #382 400 (890 ) Adjusted balance per bank, November 30 $ 3,661 The company’s general ledger checking account showed the following for December: Balance,...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows: Balance per bank, November 30 $ 3,261 Add: Deposits outstanding 1,230 Less: Checks outstanding #363 $ 126 #365 204 #380 59 #381 89 #382 370 (848 ) Adjusted balance per bank, November 30 $ 3,643 The company’s general ledger checking account showed the following for December: Balance,...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2016, reconciliation of the bank balance is as follows:   Balance per bank, November 30 $ 3,371   Add: Deposits outstanding 1,340   Less: Checks outstanding      #363 $137      #365 215      #380 70      #381 100      #382 230 (752 )   Adjusted balance per bank, November 30 $ 3,959 The company’s general ledger checking account showed the following for December:   Balance, December...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at...
El Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2018, reconciliation of the bank balance is as follows: Balance per bank, November 30 $ 3,391 Add: Deposits outstanding 1,360 Less: Checks outstanding #363 $ 139 #365 217 #380 72 #381 102 #382 250 (780 ) Adjusted balance per bank, November 30 $ 3,971 The company’s general ledger checking account showed the following for December: Balance,...
Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the...
Gato Painting Company maintains a checking account at American Bank. Bank statements are prepared at the end of each month. The November 30, 2021, reconciliation of the bank balance is as follows: Balance per bank, November 30 $ 3,431 Add: Deposits outstanding 1,400 Less: Checks outstanding #363 $ 143 #365 221 #380 76 #381 106 #382 290 (836 ) Adjusted balance per bank, November 30 $ 3,995 The company’s general ledger checking account showed the following for December: Balance, December...
Prepare the adjusting journal entries that Del Gato Clinic must record as a result of preparing the bank reconciliation.
Del Gato Clinic deposits all cash receipts on the day when they are received and it makes all cash payments by check. At the close of business on June 30, 2017, its Cash account shows a $14,600 debit balance. Del Gato Clinic's June 30 bank statement shows $14,038 on deposit in the bank. a. Outstanding checks as of June 30 total $2,402. b. The June 30 bank statement lists a $45 service charge. c. Check No. 919, listed with the...
Prepare a Bank Reconciliation Statement from the information provided and prepare adjusting Journal Entries.
Prepare a Bank Reconciliation Statement from the information provided and prepare  adjusting Journal Entries.The information below relates to the Cash account in the ledger of Bramble Company.Balance September 1—$17,010; Cash deposited—$64,500.Balance September 30—$17,664; Checks written—$63,846.The September bank statement shows a balance of $16,682 on September 30 and the following memoranda.Credits DebitsCollection of $1,621 note plus interest $39 $1,660 NSF check: Richard Nance $555Interest earned on checking account $54 Safety deposit box rent $74At September 30, deposits in transit were $4,580,...
Journalize entries related to bank reconciliation and all adjusting entries Whispering Winds Corp. prepares quarterly financial...
Journalize entries related to bank reconciliation and all adjusting entries Whispering Winds Corp. prepares quarterly financial statements. The post-closing trial balance at December 31, 2021, is presented below. WHISPERING WINDS CORP. Post-Closing Trial Balance December 31, 2021 Debit Credit Cash $23,400 Accounts Receivable 22,600 Allowance for Doubtful Accounts $1,500 Equipment 24,000 Accumulated Depreciation—Equipment 10,000 Buildings 109,000 Accumulated Depreciation—Buildings 10,000 Land 20,000 Accounts Payable 12,100 Common Stock 82,000 Retained Earnings 83,400 $199,000 $199,000 During the first quarter of 2022, the following...
P4-7 (Algo) Recording Adjusting and Closing Entries and Preparing a Balance Sheet and Income Statement Including...
P4-7 (Algo) Recording Adjusting and Closing Entries and Preparing a Balance Sheet and Income Statement Including Earnings per Share LO4-1, 4-2, 4-4 [The following information applies to the questions displayed below.] Tunstall, Inc., a small service company, keeps its records without the help of an accountant. After much effort, an outside accountant prepared the following unadjusted trial balance as of the end of the annual accounting period on December 31: Tunstall, Inc. Unadjusted Trial Balance for the Year Ended December...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT