Question

In: Accounting

Infinity Emporium Company received the monthly statement for its bank account, showing a balance of $66,744...

Infinity Emporium Company received the monthly statement for its bank account, showing a balance of $66,744 on August 31. The balance in the Cash account in the company's accounting system at that date was $71,952. The company's accountant reviewed the statement and the company's accounting records and noted the following.

  • 1.After comparing the cheques written by the company with those deducted from the bank account in August, the accountant determined that all six cheques (totalling $6,180) that had been outstanding at the end of July were processed by the bank in August. However, five cheques written in August, totalling $4,560, were outstanding on August 31.
  • 2.A review of the deposits showed that a deposit made by the company on July 31 for $11,532 was recorded by the bank on August 1, and an August 31 deposit of $12,240 was recorded in the company's accounting system but had not yet been recorded by the bank.
  • 3.The August bank statement also showed:
    • a service fee of $24
    • a customer's cheque in the amount of $204 that had been returned NSF
    • a bank loan payment of $900, which included interest of $130, that the bank had deducted automatically
    • a customer paid $3,600 account balance by electronic transfer.

Required

  1. Prepare a bank reconciliation as at August 31. (Hint: Items that were outstanding last month but have been processed this month should no longer affect the bank reconciliation, since both the company and the bank now have them recorded.)
  2. How much cash does Infinity Emporium actually have available as at August 31?
  3. Explain how the adjusted (corrected) balance of cash, as determined by the bank reconciliation, could be higher than both the balance shown on the bank statement and the balance shown in the company's Cash account.
  4. Prepare adjusting journal entries to record all the necessary adjustments to bring the Cash account to its correct balance.

Solutions

Expert Solution

Since format for bank reconciliation was not given, i have used general format, so if you have any query, kindly comment with your query

a.

Bank Reconciliation
Balance as per bank statement $   66,744.00
Add :
Deposit in Transit $   12,240.00
Deduct :
   Checks Outstanding $     4,560.00
Corrected Cash Balance $   74,424.00
Balance as per books $   71,952.00
Add :
    Customer paid by electronic tranfer $     3,600.00
Deduct :
    Bank service charges $           24.00
    NSF Check $        204.00
    Bank loan payment $        900.00
Adjusted Cash Balance $   74,424.00

b. Actual Cash Available = $74424

c. Adjusted (Corrected) balance of cash can be higher than bank statement if deposits in transit is higher than checks outstanding.
Adjusted (Corrected) balance of cash can be higher than balance shown in company's cash account if positive adjustments i.e. collections made by bank not recorded in books is higher than negative adjustments i.e. Charges or payments debited by bank.

d.

Account Titles Debit Credit
Cash $     3,600.00
       Accounts Receivable $     3,600.00
(Cash Collected by bank through electronic transfer)
Bank Charges $           24.00
       Cash $           24.00
(Bank service charges)
Accounts Receivable $        204.00
       Cash $        204.00
(NSF Check)
Note Payable $        770.00
Interest Expense $        130.00
       Cash $        900.00
(Loan Payments)

Related Solutions

Corbin Catering prepares monthly bank reconciliations of its checking account balance. The bank statement received by...
Corbin Catering prepares monthly bank reconciliations of its checking account balance. The bank statement received by Corbin Catering for February 20X9 follows:,Corbin Catering, First Fifth Bank,54 Windsong Drive ,POBox 22, BANK STATEMENT ,DATEOF STATEMENT: February 28, 20X9,,Balance,February 1, 2009,$29,500,Interestearned ,$100,Servicecharge,$40,Accountcollected on behalf of Corbin ,1,600,Checks:,#310 ,120,#312,260,#313 ,180,#314 ,215,#316 ,80,#317 ,110,Deposits:,February 15, 20X9 ,5,000,Ending Balance ,$35,195,Corbin Catering’s books disclosed the following additional information:, Checking account balance, February 1, 20X9 ,$29,500,Checkswritten:,#310 ,$120,#311 ,40,#312 ,260,#313 ,180,#314,215,#315 ,200,#316 ,80,#317 ,110,Deposits:,February15, 20X9,$5,000,February28, 20X9,2,500,Endingbalance ,$35,795,:, a)Prepare...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance of $4,188.30 as at 31 January 2020. The cash balance on the company’s books at 1 January 2020 was $176.00 (debit). The progressive totals of the Cash Receipts Journal and the Cash Payments Journal before considering items 1 to 5 below were $21,475.40 and $17,622.10 respectively. The following reconciling items were identified: (1) Un-presented cheques amounted to $501.25. (2) Debits included in the bank...
Company received a bank statement showing a balance of $310,000. Reconciling items included outstanding checks of...
Company received a bank statement showing a balance of $310,000. Reconciling items included outstanding checks of $4,800 and a deposit in transit of $5,000. What is the company’s adjusted bank balance? 310 k 310,200 309,800 314,800
Blairsville Corp. prepares monthly bank reconciliations of its checking account balance. The bank statement for July...
Blairsville Corp. prepares monthly bank reconciliations of its checking account balance. The bank statement for July 2016 indicated the following: Balance, July 31, 2016 $63,400 Service charge for July 160 Interest earned during July 100 NSF check from Black Corp. (deposited by Blairsville) 1,150 Note ($3,000) and interest ($80) collected for Blairsville from a customer of Blairsville’s 3,080 An analysis of canceled checks and deposits and the records of Blairsville revealed the following items: Checking account balance per Blairsville’s books...
McDowell’s Company received their monthly bank statement for May 2016. An analysis of the bank statement...
McDowell’s Company received their monthly bank statement for May 2016. An analysis of the bank statement and their cash account revealed the following facts. Prepare the bank reconciliation for McDowell’s Company for May: 1.         The bank statement has a balance of $6,925.             2.         The cash account has a balance of $4,622.             3.         A deposit in transit made on April 30th was $4,200.             4.         Outstanding checks totaled $5,800.             5.         The bank collected a note of $1,200, plus...
On March 31, 2019, Home Decorating Pavilion received a bank statement showing a balance of $9,740....
On March 31, 2019, Home Decorating Pavilion received a bank statement showing a balance of $9,740. The balance in the firm's checkbook and Cash account on the same date was $10,164. The difference between the two balances is caused by the items listed below. A $2,865 deposit made on March 30 does not appear on the bank statement. Check 358 for $480 issued on March 29 and Check 359 for $1,640 issued on March 30 have not yet been paid...
On March 31, 2019, Home Decorating Pavilion received a bank statement showing a balance of $9,800....
On March 31, 2019, Home Decorating Pavilion received a bank statement showing a balance of $9,800. The balance in the firm's checkbook and Cash account on the same date was $10,370. The difference between the two balances is caused by the items listed below. A $2,925 deposit made on March 30 does not appear on the bank statement. Check 358 for $510 issued on March 29 and Check 359 for $1,700 issued on March 30 have not yet been paid...
Roper Electronics received its bank statement for the month of August with an ending balance of...
Roper Electronics received its bank statement for the month of August with an ending balance of $11,740. Roper determined that Check No. 613 for $155 and Check No. 601 for $420 were both outstanding. Also, a $6,900 deposit for August 30 was in transit as of the end of the month. Northern Regional Bank also collected a $5,000 notes receivable on August 1 that was issued March 1. Accrued interest is $250. Northern Regional Bank charged a $35 fee for...
Roper Electronics received its bank statement for the month of August with an ending balance of...
Roper Electronics received its bank statement for the month of August with an ending balance of $11,740. Roper determined that Check No. 613 for $155 and Check No. 601 for $420 were both outstanding. Also, a $6,900 deposit for August 30 was in transit as of the end of the month. Northern Regional Bank also collected a $5,000 notes receivable on August 1 that was issued March 1. Accrued interest is $250. Northern Regional Bank charged a $35 fee for...
Thomas Consulting received the September 30th bank statement with the following monthly activity: Balance at 8/31/2020...
Thomas Consulting received the September 30th bank statement with the following monthly activity: Balance at 8/31/2020 $68,922 Deposits 162,500 Checks paid (187,412) NSF checks (800) Auto withdrawal - loan payment automatically deducted from account (includes $225 in interest) (5,125) Bank service fees (50) Balance at 9/30/2020 $38,035 On 9/30/2020, the cash account ledger balance was $41,773. Deposits in transit were as follows; 9/28 $3,200 9/29 $2,461 9/30 $2,757 All checks posted in the ledger cleared the bank except for those...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT