Question

In: Accounting

Question 2 Marin Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the...

Question 2

Marin Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information.

Balance, August 1

$18,580

Bank debit memorandum:

August deposits

71,180

Safety deposit box fee

$ 90

Checks cleared in August

68,613

Service charge

115

Bank credit memorandum:

Balance, August 31

21,052

  Interest earned

110

A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,880; receipts $74,180; disbursements $73,505; and balance, August 31, $19,555. Analysis reveals that the only reconciling items on the July 31 bank reconciliation were a deposit in transit for $4,865 and outstanding checks of $4,565. In addition, you determine that there was an error involving a company check drawn in August: A check for $400 to a creditor on account that cleared the bank in August was journalized and posted for $40.
Determine deposits in transit.
Deposits in transit $enter deposits it transit in dollars

SHOW LIST OF ACCOUNTS

LINK TO TEXT

Determine outstanding checks. (Hint: You need to correct disbursements for the check error.)
Outstanding checks $enter outstanding checks in dollars

SHOW LIST OF ACCOUNTS

LINK TO TEXT

Prepare a bank reconciliation at August 31. (List items that increase balance as per bank & books first.)
MARIN INC.
Bank Reconciliation
choose the accounting period

For the Month Ended August 31, 2022For the Year Ended August 31, 2022August 31, 2022

select an opening name for section one

Outstanding checksDeposits in transitError in recording checkSafety deposit box rentService chargeCash balance per bank statementAdjusted cash balance per bankInterest earned

$enter a dollar amount
select between addition and deduction

AddLess

:
select a reconciling item

Adjusted cash balance per bankOutstanding checksDeposits in transitError in recording checkSafety deposit box rentCash balance per bank statementInterest earnedService charge

enter a dollar amount
enter a subtotal of the two previous amounts
select between addition and deduction

AddLess

:
select a reconciling item

Deposits in transitAdjusted cash balance per bankInterest earnedCash balance per bank statementOutstanding checksError in recording checkService chargeSafety deposit box rent

enter a dollar amount
select a closing name for section one

Interest earnedError in recording checkService chargeAdjusted cash balance per bankCash balance per bank statementSafety deposit box rentDeposits in transitOutstanding checks

$enter a total amount for the first section
select an opening name for section two

Interest earnedDeposits in transitError in recording checkService chargeSafety deposit box rentCash balance per booksAdjusted cash balance per booksOutstanding checks

$enter a dollar amount
select between addition and deduction

AddLess

:
select a reconciling item

Outstanding checksInterest earnedError in recording checkAdjusted cash balance per booksCash balance per booksDeposits in transitService chargeSafety deposit box rent

enter a dollar amount
enter a subtotal of the two previous amounts
select between addition and deduction

AddLess

:
select a reconciling item

Outstanding checksDeposits in transitInterest earnedSafety deposit box rentCash balance per booksError in recording checkService chargeAdjusted cash balance per books

$enter a dollar amount
select a reconciling item

Cash balance per booksSafety deposit box rentDeposits in transitOutstanding checksInterest earnedAdjusted cash balance per booksError in recording checkService charge

enter a dollar amount
select a reconciling item

Safety deposit box rentOutstanding checksCash balance per booksAdjusted cash balance per booksDeposits in transitInterest earnedError in recording checkService charge

enter a dollar amount
enter a subtotal of the three previous amounts
select a closing name for section two

Error in recording checkCash balance per booksSafety deposit box rentOutstanding checksService chargeAdjusted cash balance per booksDeposits in transitInterest earned

$enter a total amount for the second section

SHOW LIST OF ACCOUNTS

LINK TO TEXT

Solutions

Expert Solution

Deposit in Transit = $74180+4865-71180 = $7865

Correct Disbursements for August = $73505-40+400 = $73865
Checks Outstanding = $73865+4565-68613 = $9817

Bank Reconciliation
Cash Balance as per bank statement $    21,052.00
Add :
Deposit in Transit $      7,865.00
Deduct :
Outstanding Checks $      9,817.00
Adjusted Cash Balance per Bank $    19,100.00
Cash Balance as per books $    19,555.00
Add :
      Interest Earned $          110.00
Deduct :
    Safety Deposit Box Fee $            90.00
    Service Charge $          115.00
    Error in recording check $          360.00 $          565.00
Adjusted Cash Balance per Books $    19,100.00

Related Solutions

Teal Mountain Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following...
Teal Mountain Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,660 Bank debit memorandum: August deposits $71,260 Safety deposit box fee $125 Checks cleared in August $68,578 Service charge $150 Bank credit memorandum: Balance, August 31 $21,212 Interest earned $145 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,960; receipts $74,260; disbursements $73,470; and balance, August 31, $19,750. Analysis reveals that...
Exercise 7-14 Metlock, Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the...
Exercise 7-14 Metlock, Inc.’s bank statement from Main Street Bank at August 31, 2022, gives the following information. Balance, August 1 $18,740 Bank debit memorandum: August deposits 71,340 Safety deposit box fee $ 45 Checks cleared in August 68,658 Service charge 70 Bank credit memorandum: Balance, August 31 21,372   Interest earned 65 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $19,040; receipts $74,340; disbursements $73,550; and balance, August 31, $19,830. Analysis...
Shamrock, Inc.’s bank statement from Main Street Bank at August 31, 2017, gives the following information....
Shamrock, Inc.’s bank statement from Main Street Bank at August 31, 2017, gives the following information. Balance, August 1 $18,550 Bank debit memorandum: August deposits 71,150 Safety deposit box fee $ 60 Checks cleared in August 68,643 Service charge 85 Bank credit memorandum: Balance, August 31 20,992   Interest earned 80 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,850; receipts $74,150; disbursements $73,535; and balance, August 31, $19,465. Analysis reveals that...
Werth Inc.’s bank statement from Hometown Bank at August 31, 2018, gives the following information. Balance,...
Werth Inc.’s bank statement from Hometown Bank at August 31, 2018, gives the following information. Balance, August 1 $18,400 Bank debit memorandum: August deposits 81,000 Safety deposit box fee $ 25 Checks cleared in August 78,678 Service charge 50 Bank credit memorandum: Balance, August 31 20,692   Interest earned 45 A summary of the Cash account in the ledger for August shows the following: balance, August 1, $18,700; receipts $84,000; disbursements $83,570; and balance, August 31, $19,130. Analysis reveals that the...
Question 2 Culver Company has just received the August 31, 2017, bank statement, which is summarized...
Question 2 Culver Company has just received the August 31, 2017, bank statement, which is summarized below. County National Bank Disbursements Receipts Balance Balance, August 1                           $13,192 Deposits during August                   $45,338       58,530 Note collected for depositor, including $56 interest                   1,464       59,994 Checks cleared during August       $48,576                   11,418 Bank service charges       28                   11,390 Balance, August...
Zhang Company’s bank statement from Nguyen National Bank at August 31, 2015, shows the information below....
Zhang Company’s bank statement from Nguyen National Bank at August 31, 2015, shows the information below. Balance, August 1                                                              $11,284 August deposits                                                                   47,521 Checks cleared in August                                                46,475 Balance, August 31                                                              16,856 Bank credit memoranda: Collection of note receivable plus $105 interest       $5,105 Interest earned                                                                             41 Bank debit memorandum: Safety deposit box rent                                                              20 A summary of the Cash account in the ledger for August shows: balance, August 1, $10,959; receipts $50,050;...
Roper Electronics received its bank statement from Northern Regional Bank for the month of August with...
Roper Electronics received its bank statement from Northern Regional Bank for the month of August with a balance of $11,740.00 as of August 31. Northern Regional Bank also collected a $5,000.00 notes receivable from Roper Electronic's customer on August 1. The customer owed interest on the receivable for the period March 1 to August 1 at 12% annual interest. Northern Regional Bank charged a $35.00 fee for the collection service.The bank statement reveals a bank service charge of $20.00. A...
Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed...
Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed two cheques outstanding at that time, #5888 for $6,390 and #5893 for $1,528.00. The following information was available for the September 30, 2020, reconciliation: From the September 30, 2020, bank statement: Balance of previous statement on Aug. 31/20 10,979.00 6 deposits and other credits totalling 23,509.00 9 cheques and other debits totalling 27,498.00 Current balance as of Sept. 30/20 6,990.00 Chequing Account Transactions Date...
Bank Reconciliation Statement. The cash account for Corey’s Construction Company at August 31, 2020, indicated a...
Bank Reconciliation Statement. The cash account for Corey’s Construction Company at August 31, 2020, indicated a book balance of $19,885. The bank statement received by the company indicated a balance of $39,473.63 as at August 31, 2020. A comparison of the bank statement and the accompanying cancelled cheques and memos with the records revealed the following: A deposit of $6,794.62 was received by the bank on August 31 after the bank statement was prepared. Cheques #251 for $1,200 and #260...
Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed...
Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed two cheques outstanding at that time, #5888 for $6,040 and #5893 for $1,443.00. The following information was available for the September 30, 2017, reconciliation: From the September 30, 2017, bank statement   BALANCE OF PREVIOUS STATEMENT ON AUG. 31/17 10,368.00   6 DEPOSITS AND OTHER CREDITS TOTALLING 18,392.00   9 CHEQUES AND OTHER DEBITS TOTALLING 23,908.00   CURRENT BALANCE AS OF SEPT. 30/17 4,852.00 Chequing Account Transactions Date...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT