Question

In: Accounting

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 1 $ 3,959
  Receipts 44,050
  Disbursements (43,253 )
  Balance, December 31 $ 4,756
  The December bank statement contained the following information:
  Balance, December 1 $ 3,371
  Deposits 44,400
  Checks processed (43,318 )
  Service charges (36 )
  NSF checks (580 )
  Balance, December 31 $ 3,837

     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 $520 was correctly recorded by the bank but was incorrectly recorded on the books as a $250 disbursement for advertising expense. Included in the bank’s deposits is a $2,700 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, 2016.


2.

Prepare any necessary adjusting journal entries indicated. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

  

Solutions

Expert Solution

SOLUTION

(A) Bank Reconciliation statement-

Particulars Amount ($) Particulars Amount ($)
Balance per bank statement 3,837 Balance per books 4,756
Add: Deposits outstanding (1) 3,690 Deduct:
Deduct:   Error in recording check #411 ($520-$250) (270)
  Bank error - deposit incorrectly credited to company account (2,700)   Service charges (36)
  Outstanding checks (2) (957)   NSF checks (580)
Corrected cash balance 3,870 Corrected book balance 3,870

(1) Deposits outstanding-

Particulars Amount ($) Amount ($)
Receipts 44,050
Less: December receipts deposited
Bank deposits 44,400
Less: Deposit error (2,700)
Less: Prior months deposits outstanding (1,340) 40,360
Deposits outstanding, December 31 3,690

(2) Outstanding checks-

Particulars Amount ($) Amount ($)
Dec. Disbursements 43,253
Error in recording check #411 270
Less: December checks cleared:
Total checks cleared 43,318
Prior months checks:
  #363 (137)
#380 (70)
  #381 (100)
  #382 (230) 42,781
December checks outstanding 742
Add: Check #365 215
Total checks outstanding, Dec. 31 957

(B) Journal Entry-

Account titles and Explanations Debit ($) Credit ($)
Advertising expense 270
Miscellaneous expense (bank service charges) 36
Accounts receivable (NSF checks) 580
Cash 886

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, 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...
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...
The Fitzgerald Company maintains a checking account at the Bank of the North. The bank provides...
The Fitzgerald Company maintains a checking account at the Bank of the North. The bank provides a bank statement along with canceled checks on the last day of each month. T he October 31, 2016, bank statement included the following information: Balance, October 1, 2016 $ 32,690    Deposits 86,000    Checks processed -75,200    Service charges -350    NSF checks -1,600    Monthly loan payment deducted       directly by bank from account       (includes $400 in interest)    (3,400)...
The Fitzgerald Company maintains a checking account at the Bank of the North. The bank provides...
The Fitzgerald Company maintains a checking account at the Bank of the North. The bank provides a bank statement along with canceled checks on the last day of each month. The October 31, 2016, bank statement included the following information:   Balance, October 1, 2016 $ 32,590        Deposits 81,000        Checks processed (70,200)       Service charges (250)       NSF checks (1,500)       Monthly loan payment deducted        directly by bank from account        (includes $300 in interest) (2,300)     Balance, October 31, 2016 $ 39,340    The...
The Fitzgerald Company maintains a checking account at the Bank of the North. The bank provides...
The Fitzgerald Company maintains a checking account at the Bank of the North. The bank provides a bank statement along with canceled checks on the last day of each month. The October 31, 2018, bank statement included the following information: Balance, October 1, 2018 $ 32,690 Deposits 86,000 Checks processed (75,200 ) Service charges (350 ) NSF checks (1,600 ) Monthly loan payment deducted directly by bank from account (includes $400 in interest) (3,400 ) Balance, October 31, 2018 $...
  Harrison Company maintains a checking account at the First National City Bank. The bank provides a...
  Harrison Company maintains a checking account at the First National City Bank. The bank provides a bank statement along with canceled checks on the last day of each month. The July 2021 bank statement included the following information: Balance, July 1, 2021 $ 57,428 Deposits 180,900 Checks processed (194,010 ) Service charges (45 ) NSF checks (1,900 ) Monthly payment on note, deducted directly by bank from account (includes $220 in interest) (4,020 ) Balance, July 31, 2021 $ 38,353...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT