Question

In: Accounting

On May 31, 2017, Forester Theatre's cash account per its general ledger showed the following balance:...

On May 31, 2017, Forester Theatre's cash account per its general ledger showed the following balance:

CASH

No. 101

Date

Explanation

Ref

Debit

Credit

Balance

May 31

Balance

6,841

The bank statement from Canada Bank on that date showed the following balance:

CANADA BANK

Cheques and Debits

Deposits and Credits

Daily Balance

XXX

XXX

5/31 6,804

A comparison of the details on the bank statement with the details in the Cash account revealed the following facts.

  • 1.The statement included a debit memo of $45 for the monthly bank service charges.
  • 2.Cash sales of $836 on May 12 were deposited in the bank. The bookkeeper recorded the deposit in the cash journal as $846.
  • 3.Outstanding cheques on May 31 totalled $515 and deposits in transit were $1,436.
  • 4.On May 18, the company issued cheque #1581 for $685 to M. Datz on account. The cheque, which cleared the bank in May, was incorrectly journalized and posted by Forester Theatre for $658.
  • 5.A $2,500 note receivable was wired to the bank account of Forester Theatre on May 31. Interest was not collected for the note.
  • 6.Included with the cancelled cheques was a cheque issued by Bohr Theatre for $600 that was incorrectly charged to Forester Theatre by the bank.
  • 7.On May 31, the bank statement showed an NSF charge of $934 for a cheque issued by Tyler Bickell, a customer, to Forester Theatre on account.

Instructions

(a)  

Prepare the bank reconciliation at May 31.

(b)  

Prepare the necessary adjusting entries at May 31.

Solutions

Expert Solution

Solution a:

Forester Theatre
Bank Reconciliation Statement
31-May
Cash Balance from Bank statement $6,804
Add: Deposit in transit $1,436
Add: Bank Error in charging another company' Check $600 $2,036
Less: Outstanding Checks $515
Adjusted cash balance $8,325
Cash Balance from Company records $6,841
Add: Note collected $2,500
Less: Service Charge $45
Less: Incorrect recording of Deposits from cash sales ($846-$836) $10
Less: Incorrect recording of Check 1581 ($685-$658) $27
Less: NSF charges $934 $1,016
Adjusted Cash Balance $8,325

Solution b:

Journal entries
S.no. Particulars Debit Credit
1 Bank Service charges Dr $45
     To Cash $45
2 Sales Revenue Dr $10
     To Cash $10
3 No journal entry required
4 Accounts Payable Dr $27
     To Cash $27
5 Cash Dr $2,500
     To note receivable $2,500
6 No journal entry required
$934
7 Accounts Receivable Dr $934
     To Cash

Related Solutions

The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at...
The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at December 31 (but prior to performing a bank reconciliation). The company's bank statement showed a balance of $22,000 at the same date. The only reconciling items consisted of: (1) a $5,000 deposit in transit, (2) a bank service charge of $200, (3) outstanding checks totaling $9,000, (4) a $3,000 check marked "NSF" from Susque Company, one of Lyco's customers, and (5) a check written...
On May 31st, Company O's General ledger shows a cash balance of $5123. The May 31...
On May 31st, Company O's General ledger shows a cash balance of $5123. The May 31 bank statement shows a balance of $4905. Other information is available as follows: 1. A May 31 deposit of $300 does not appear on the bank statement; but a $3 service charge does. 2. A customer's $40 insufficient funds check has been returned with the bank statement. 3. Outstanding checks of $10, 15 and $100 are identified on May What is the correct cash...
On January 31, 2019, the general ledger of Palmer Company showed the following account balances. ACCOUNTS...
On January 31, 2019, the general ledger of Palmer Company showed the following account balances. ACCOUNTS Cash 61,400 Accounts Receivable 20,900 Supplies 7,400 Prepaid Insurance 6,600 Equipment 89,900 Accum. Depr.—Equip. 0 Accounts Payable 15,100 Sadie Palmer, Capital 80,350 Fees Income 109,000 Depreciation Exp.—Equip. 0 Insurance Expense 0 Rent Expense 9,000 Salaries Expense 9,250 Supplies Expense 0 Additional information: Supplies used during January totaled $4,900. Expired insurance totaled $1,650. Depreciation expense for the month was $1,425. Complete the worksheet through the...
Problem 3-9A On July 31, 2017, the general ledger of Splish Brothers Inc. showed the following...
Problem 3-9A On July 31, 2017, the general ledger of Splish Brothers Inc. showed the following balances: Cash $4,480, Accounts Receivable $1,680, Supplies $560, Equipment $5,600, Accounts Payable $4,590, Common Stock $3,920, and Retained Earnings $3,810. During August, the following transactions occurred. Aug. 3 Collected $1,340 of accounts receivable due from customers. 5 Received $1,460 cash for issuing common stock to new investors. 6 Paid $3,020 cash on accounts payable. 7 Performed legal services of $7,280, of which $3,360 was...
The October 31 cash balance in the general ledger is $825. The October 31 balance shown...
The October 31 cash balance in the general ledger is $825. The October 31 balance shown on the bank statement is $375. Checks issued but not returned with the bank statement were No. 462 for $21 and No. 483 for $43. A deposit made late on October 31 for $438 is included in the general ledger balance but not in the bank statement balance. Returned with the bank statement was a notice that a customer's check for $67 that was...
Q3 / On July 31, 2018, the general ledger of Sandhill Inc. showed these balances: Cash...
Q3 / On July 31, 2018, the general ledger of Sandhill Inc. showed these balances: Cash $3,980; Accounts Receivable $1,490; Supplies $550; Equipment $4,970; Accounts Payable $4,090; Common Shares $3,500; and Retained Earnings $3,400. During August, the following transactions occurred: Aug. 2 Collected $1,190 of accounts receivable due from customers. 3 Received $1,300 for issuing common shares to new investors. 6 Paid $2,680 on accounts payable owing. 7 Earned fees of $6,500, of which $3,000 was collected in cash and...
The ABC company has an ending cash balance at October 31, 2020 in its general ledger...
The ABC company has an ending cash balance at October 31, 2020 in its general ledger of $              27,290.00 The balance per the bank statement at October 31, 2020 was $              26,455.00 PART 1: BANK RECONCLIATION The accounting has identified the following information related to the month of October: Cash balance per bank statement On October 31, deposit of $2,500 not reflected on the bank statement. Outstanding cheques of $3,000 on October 31 Cheque for utility expense, $430, was incorrectly recorded in...
On May-31, 2017 James Logan Company had a cash balance per books of $ 6,051 and...
On May-31, 2017 James Logan Company had a cash balance per books of $ 6,051 and The bank statement from Farmer’s community bank on that date showed a balance of $ 6,404. A comparison of the statement with the cash account revealed the following facts i.The statement included a debit of $ 40 for the printing of check books, not recorded in company’s book ii.A Collection in respect of account receivable amounting Rs 836 was recorded by company as $...
On May 31, 2017, Reber Company had a cash balance per books of $7,001.50. The bank...
On May 31, 2017, Reber Company had a cash balance per books of $7,001.50. The bank statement from New York State Bank on that date showed a balance of $6,624.60. A comparison of the statement with the cash account revealed the following facts. 1. The statement included a debit memo of $49.00 for the printing of additional company checks. 2. Cash sales of $731.00 on May 12 were deposited in the bank. The cash receipts journal entry and the deposit...
On May 31, 2017, Reber Company had a cash balance per books of $7,071.50. The bank...
On May 31, 2017, Reber Company had a cash balance per books of $7,071.50. The bank statement from New York State Bank on that date showed a balance of $6,694.60. A comparison of the statement with the cash account revealed the following facts. 1. The statement included a debit memo of $45.00 for the printing of additional company checks. 2. Cash sales of $833.00 on May 12 were deposited in the bank. The cash receipts journal entry and the deposit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT