Question

In: Accounting

On November 30th, FRI Company’s general ledger shows a checking account balance of $12,000.  The company’s cash...

On November 30th, FRI Company’s general ledger shows a checking account balance of $12,000.  The company’s cash receipts for the month which haven’t cleared the bank yet are $5,500 and checks written by the company this month which have not cleared the bank total $9,000.  

While comparing the bank statement with the general ledger FRI determined the bank overstated a deposit the company made on November 28th for $100.  The bank statement also reported service fees of $50, interest FRI earned on their account of $10, and an automatic withdrawal of $450 for the phone bill.  The bank statement also showed the bank had collected a $2,000 note receivable for FRI from a company executive.  The company noted that one of the checks they wrote was incorrectly recorded in the general ledger, it was written for $600 but they had subtracted $660 from their cash account.

The bank statement reported the company checking account balance was $17,170 on November 30.

Answer the following based on performing a bank reconciliation for FRI Company.

  1. How should the company treat the bank error? (add/sub from bank/general ledger)
  2. How should the company treat the company error? (add/sub from bank/ general ledger)
  3. What is the general ledger cash balance before reconciliation? $____
  4. What is the bank statement balance before reconciliation? $_____
  5. What is the general ledger balance after reconciliation? $_______

Solutions

Expert Solution

Solution

FRI Company

Bank Reconciliation

FRI Company

Bank Reconciliation Statement

For the Month Ended November 30

Balance as per bank statement

$17,170

Add: Deposits in transit

$5,500

Less: Outstanding checks

$(9,000)

Less: bank error

$(100)

$(3,600)

Corrected Balance as per Bank Statement

$13,570

Balance as per books

$12,000

Add: notes receivable collected by bank

$2,000

Add: error in recording checks

$60

Add: interest earned

$10

Less: Bank charges

$(50)

Less: automatic withdrawal

$(450)

$1,570

Corrected book balance

$13,570

How should the company treat the bank error:

Subtract from the bank balance.

How should the company treat the company error:

Add to general ledger ($660 - $600 = $60)

General ledger cash balance before reconciliation = $12,000

Bank statement balance before reconciliation = $17,170

General ledger balance after reconciliation = $13,570


Related Solutions

On October 31, 2021, Damon Company's general ledger shows a checking account balance of $8,439
On October 31, 2021, Damon Company's general ledger shows a checking account balance of $8,439. The company's cash receipts for the month total $74,600, of which $71,365 has been deposited in the bank. In addition, the company has written checks for $72,509, of which $71,234 has been processed by the bank. The bank statement reveals an ending balance of $12,749 and includes the following items not yet recorded by Damon: bank service fees of $290, note receivable collected by the bank...
Spielberg Company's general ledger shows a checking account balance of $22,910 on July 31, 2021
Exercise 4-9A Calculate the balance of cash using a bank reconciliation (LO4-5) Spielberg Company's general ledger shows a checking account balance of $22,910 on July 31, 2021. The July cash receipts of $1,825, included in the general ledger balance, are placed in the night depository at the bank on July 31 and processed by the bank on August 1. The bank statement dated July 31 shows bank service fees of $49. The bank processes all checks written by the company by...
On October 31, 2021. Damon Company's general ledger shows a checking account balance of $8.457 ...
On October 31, 2021. Damon Company's general ledger shows a checking account balance of $8.457. The company's cash receipts for the month total $74,720, of which $71,395 has been deposited in the bank. In addition, the company has written checks for $72,527, of which $71,342 has been processed by the bank. The bank statement reveals an ending balance of $13,187 and includes the following items not yet recorded by Damon: bank service fees of $350, note receivable collected by the bank...
Spielberg Company's general ledger shows a checking account balance of $22,880 on July 31, 2021. The...
Spielberg Company's general ledger shows a checking account balance of $22,880 on July 31, 2021. The July cash receipts of $1,795, included in the general ledger balance, are placed in the night depository at the bank on July 31 and processed by the bank on August 1. The bank statement dated July 31 shows bank service fees of $46. The bank processes all checks written by the company by July 31 and lists them on the bank statement, except for...
Riverbed Spa shows a general ledger balance for the Cash account of $5,227.95 on June 30...
Riverbed Spa shows a general ledger balance for the Cash account of $5,227.95 on June 30 and the bank statement as of that date indicates a balance of $4,450.00. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $34.00. 2. A bank memo stated that Bao Dai’s note for $900 and interest of $46.00 had been collected on June 29, and the bank had charged $6.30...
Novak Spa shows a general ledger balance for the Cash account of $3,974.35 on June 30...
Novak Spa shows a general ledger balance for the Cash account of $3,974.35 on June 30 and the bank statement as of that date indicates a balance of $4,145.00. When the statement was compared with the cash records, the following facts were determined: 1. There were bank service charges for June of $33.00. 2. A bank memo stated that Bao Dai’s note for $897.00 and interest of $42.00 had been collected on June 29, and the bank had charged $7.50...
A company's general ledger shows a cash balance of $4,590. Comparing the company's cash records with...
A company's general ledger shows a cash balance of $4,590. Comparing the company's cash records with the monthly bank statement reveals several additional cash transactions such as checks outstanding of $2,850, bank service fees of $120, and interest earned of $27. Calculate the correct balance of cash..
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...
The balances of the ledger account of buffet on sep 30th , 2019 are Cash 13000...
The balances of the ledger account of buffet on sep 30th , 2019 are Cash 13000 Accounts recivable 7000 Supplies 2400 Prepaid insurance 6000 Equipment 15000 Acc payable 6800 Jane capital 6800 Jane drawing 35000 Fees income 3000 Adverise expense 19000 Rent exp 12000 Salaries exp 2400 Supplies exp 1000 Depreciation 800 Supplies purchased on sep 1,2019 Inventory of supplies showed 1200 on sep 30,2019 Prepaid insurance policy on sep 1,2019 paid for six months insurance policy Equipments purchased sep...
On November 30, 2001, Dr. Smith had a balance of $6,502.88 in his Cash Ledger account....
On November 30, 2001, Dr. Smith had a balance of $6,502.88 in his Cash Ledger account. On that date the bank statement indicated a balance of $8,243.75. Comparison of returned checks and bank memoranda revealed the following: 1. Deposits in transit November 30 amounted to $3,407. 2. Outstanding checks at November 30 totaled $2,140.37. 3. The Bank erroneously changed a $950 check of the Barkley Company against Dr. Smith's Bank account. 4. Bank service charges for November amounted to $20.00....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT