Question

In: Accounting

Shown below is the information needed to prepare bank reconciliation for Mandy Company on 31 October...

Shown below is the information needed to prepare bank reconciliation for Mandy Company on 31 October 2019:
(1) The cash ledger account showed a balance of $8,510, while the bank statement indicated a cash balance of $12,390.

(2) The bank statement showed $45 interest earned for the month of October.

(3) ZYX company settled its notes payable by depositing $4,000 directly into Mandy’s bank account.

(4) The company issued three checks totaling $1,000, which had not been shown in the bank statement in October. (5) A $300 check mailed to the bank for deposit had not reached the bank on 31 October.

(6) A $710 deposit to Manning Company was erroneously credited to Mandy’s account by the bank.

(7) The bank returned a customer’s NSF check for $575 received as payment of an account receivable.

(8) A $2,500 check received from a tenant for rental revenue was recorded as $3,500 in the book.

Question 1B

Prepare the necessary journal entries to update the accounting records.

Solutions

Expert Solution

Solution 1b:

Mandy Company
Bank Reconciliation - October 31
Bank's Cash balance Company's cash balance
Particulars Amount Particulars Amount
Ending balance as per Bank Statements $12,390.00 Ending Balance as per cash books $8,510.00
Additions: Additions:
Outstanding Deposits $300.00 Note Collection $4,000.00
Interest earned $45.00
Deductions: Deductions:
Outstanding Checks $1,000.00 NSF Cheque $575.00
Bank Error $710.00 Incorrect recording of check $1,000.00
Up to date cash balance as per bank $10,980.00 Up to date cash balance as per books $10,980.00
Journal Entries - Mandy Company
Date Particulars Debit Credit
31-Oct Cash Dr $4,000.00
      To Note receivables $4,000.00
(To record note collection)
31-Oct Cash Dr $45.00
      To Interest earned $45.00
(To record interest earned)
31-Oct Accounts Receivables Dr $575.00
       To Cash $575.00
(Being cheque dishonored by bank)
31-Oct Rental revenue Dr $1,000.00
       To Cash $1,000.00
(To record correction entry for check)

Related Solutions

The information below was used to prepare a bank reconciliation for Lorena Company at October 31:...
The information below was used to prepare a bank reconciliation for Lorena Company at October 31: ∙      According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557. ∙      Outstanding checks totaled $1,433. ∙      A customer's check for $999 was returned for NSF. ∙      October's service charge was $100. ∙      The bank collected $1,600 from a customer of Lorena Company in payment of a...
1.) The information below was used to prepare a bank reconciliation for Lorena Company at October...
1.) The information below was used to prepare a bank reconciliation for Lorena Company at October 31: ∙      According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557. ∙      Outstanding checks totaled $1,433. ∙      A customer's check for $999 was returned for NSF. ∙      October's service charge was $100. ∙      The bank collected $1,600 from a customer of Lorena Company in payment of...
The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as...
The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as follows: BLOSSOM COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,771 Add: Deposits in transit 1,580 13,351 Less: Outstanding cheques    #2451 $1,200    #2470 960    #2471 882    #2472 516    #2474 1,060 4,618 Adjusted cash balance per bank $8,733 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: BLOSSOM COMPANY...
The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as...
The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as follows: BLOSSOM COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,000 Add: Deposits in transit 1,500 12,500 Less: Outstanding cheques    #2451 $1,100    #2470 850    #2471 780    #2472 450    #2474 1,000 4,180 Adjusted cash balance per bank $8,320 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: BLOSSOM COMPANY...
Using the following information to prepare a bank reconciliation for XYZ Co. for May 31: (a)...
Using the following information to prepare a bank reconciliation for XYZ Co. for May 31: (a) The bank statement balance is $3,936. (b) The cash account balance is $4,194. (c) Outstanding checks amounted to $465. (d) Deposits in transit are $655. (e) The bank service charge is $50. (f) A check for $97 for supplies was recorded as $79 in the ledger.
Prepare a bank reconciliation for Grace, Inc., as of January 31, from the following information: (a.)...
Prepare a bank reconciliation for Grace, Inc., as of January 31, from the following information: (a.) The January 31 cash balance in the general ledger is $5,088. (b.) The January 31 balance shown on the bank statement is $4,544. (c.) Checks issued but not returned with the bank statement were No. 435 for $452 and No. 448 for $182. (d.) A deposit made on January 31 for $1,280 was included in the general ledger balance but not in the bank...
Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the...
Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the following format. I am not going to be particular about how you show your numbers as long as you have them in the right spot and can get to the correct adjusted balances. Bank Balance: Cash Balance: Add: Add: Deduct: Deduct: Adjusted Balance: Adjusted Balance: Journalize the necessary entries. After completing the bank reconciliation show any necessary journal entries. Pretend you have a general...
Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If...
Use the Following Information to Answer the Questions Below to prepare the Bank Reconciliation 1) If Any Differences or Errors are found, Assume that Our Business made the mistake and the BANK records are accurate. 2) The Following Items were Included on the Bank Statement from the Schwab Bank for the Month as Follows; Ending Bank Balance at January 31 was $69,000. Monthly Bank Fees of $1,500 NSF Check from Customer H.Clinton for $11,000 Interest Earned During the month was...
Prepare a bank reconciliation dated December 31, 2020, for Nittany Inc. based on the following information....
Prepare a bank reconciliation dated December 31, 2020, for Nittany Inc. based on the following information. ∙           Balance per bank statement is $1,000. ∙           Balance per books is $900. ∙           The December bank statement indicated a service charge of $30. ∙           Cheque #1169 for $400 made out to a supplier was mailed, but not yet received by the bank. . Cheque #1183 for $270 to a supplier was incorrectly posted by Nittany as $720 in the books. ∙           The bank...
Problem 1: The bank reconciliation for Weez Ltd as at 31 October 2017 was as follows....
Problem 1: The bank reconciliation for Weez Ltd as at 31 October 2017 was as follows. WEEZ Ltd Bank Reconciliation 31 October 2017 Cash balance per bank Add: Deposits in transit $ 12 444.70   1 530.20 13 974.90 Less: Outstanding cheques Cheque number Cheque amount 2451 2470 2471 2472 2474 $ 1 260.40 720.10 844.50 503.60 1 050.00 4 378.60 Cash balance per the General Ledger $ 9 596.30 The November bank statement had a balance of $17 069.40 and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT