Question

In: Accounting

The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31,...

The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31, 2018, balance of $15,434.12. Information that might be useful in preparing a bank reconciliation is as follows: Outstanding checks were $1,401.45. The December 31, 2018, cash receipts of $615 were not deposited in the bank until January 2, 2019. One check written in payment of rent for $254 was correctly recorded by the bank but was recorded by MSI as a $269 disbursement. In accordance with prior authorization, the bank withdrew $530 directly from the checking account as payment on a mortgage note payable. The interest portion of that payment was $390. MSI has made no entry to record the automatic payment. Bank service charges of $22 were listed on the bank statement. A deposit of $915 was recorded by the bank on December 13, but it did not belong to MSI. The deposit should have been made to the checking account of MIS, Inc. The bank statement included a charge of $65 for an NSF check. The check was returned with the bank statement and the company will seek payment from the customer. MSI maintains a $280 petty cash fund that was appropriately reimbursed at the end of December. According to instructions from MSI on December 30, the bank withdrew $14,000 from the account and purchased U.S. Treasury bills for MSI. MSI recorded the transaction in its books on December 31 when it received notice from the bank. Half of the Treasury bills mature in two months and the other half in six months.

Required: 1. Prepare a bank reconciliation for the MSI checking account at December 31, 2018. You will have to compute the balance per books.

Prepare a bank reconciliation for the MSI checking account at December 31, 2018. You will have to compute the balance per books. (Round your answers to 2 decimal places.)

Bank Reconciliation
Balance per bank statement
Add:
Deduct:
Corrected cash balance
Balance per books
Add:
Deduct:
Corrected cash balance

2. Prepare any necessary adjusting journal entries indicated.

Record transaction to correct error in recording cash disbursement for rent.

Note: Enter debits before credits.

Event General Journal Debit Credit
1

Record credits to cash revealed by the bank reconciliation. Use the miscellaneous expense account to record the bank service charges.

Note: Enter debits before credits.

Event General Journal Debit Credit
2

3. What amount would MSI report as cash and cash equivalents in the current asset section of the December 31, 2018, balance sheet?

What amount would MSI report as cash and cash equivalents in the current asset section of the December 31, 2018, balance sheet? (Round your answer to 2 decimal places.)

What amount would MSI report as cash and cash equivalents in the current asset section of the December 31, 2018, balance sheet? (Round your answer to 2 decimal places.)

Solutions

Expert Solution

Balance per bank statement    15,434.12
Add:
Rent Payment          254.00
mortgage note payable          530.00
Bank service charges            22.00
NSF check            65.00
petty cash          280.00
Cash receipts          615.00
Less:
Outstanding checks      1,401.45
Rent Payment          269.00
deposit of Wrongly recorded          915.00
Corrected cash balance    14,614.67
Balance as per Books    14,614.67
Add:
Outstanding checks      1,401.45
Rent Payment          269.00
Deposit of Wrongly recorded          915.00
Less:
Rent Payment          254.00
mortgage note payable          530.00
Bank service charges            22.00
NSF check            65.00
petty cash          280.00
Cash receipts          615.00
   15,434.12
General Journal Debit Credit
Cash            15.00
To Rent 15
General Journal Debit Credit
Mortgage note payable          530.00
miscellaneous expense            22.00
NSF check Charges            65.00
Cash          617.00
Cash and cash equivalents:
Cash Balance as per books    14,614.67    14,012.67
Rent Correction            15.00
Mortgage note payable       (530.00)
miscellaneous expense          (22.00)
NSF check Charges          (65.00)
Treasury bills    14,000.00
Cash and cash equivalents:    28,012.67

Related Solutions

The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31,...
The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31, 2021, balance of $15,634.62. Information that might be useful in preparing a bank reconciliation is as follows: Outstanding checks were $1,421.75. The December 31, 2021, cash receipts of $625 were not deposited in the bank until January 2, 2022. One check written in payment of rent for $256 was correctly recorded by the bank but was recorded by MSI as a $273 disbursement. In...
The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31,...
The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31, 2021, balance of $15,835.12. Information that might be useful in preparing a bank reconciliation is as follows: Outstanding checks were $1,442.05. The December 31, 2021, cash receipts of $635 were not deposited in the bank until January 2, 2022. One check written in payment of rent for $258 was correctly recorded by the bank but was recorded by MSI as a $285 disbursement. In...
The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31,...
The bank statement for the checking account of Management Systems Inc. (MSI) showed a December 31, 2018, balance of $16,236.12. Information that might be useful in preparing a bank reconciliation is as follows: Outstanding checks were $1,482.65. The December 31, 2018, cash receipts of $655 were not deposited in the bank until January 2, 2019. One check written in payment of rent for $262 was correctly recorded by the bank but was recorded by MSI as a $276 disbursement. In...
The bank statement for the checking account of Garden Systems Inc. (GSI) showed a December 31,...
The bank statement for the checking account of Garden Systems Inc. (GSI) showed a December 31, 2018, balance of $15,534.37. Information that might be useful in preparing a bank reconciliation is as follows: Outstanding checks were $1,411.60. The December 31, 2018, cash receipts of $620 were not deposited in the bank until January 2, 2019. One check written in payment of rent for $255 was correctly recorded by the bank but was recorded by GSI as a $271 disbursement. In...
Friends, Inc. received its bank statement for the month ended 12/31/18. The bank statement showed a...
Friends, Inc. received its bank statement for the month ended 12/31/18. The bank statement showed a balance of $10,102.87. The company’s general ledger showed a balance of $8,656.11. The following items were discovered when comparing the bank statement to the books of the company: The bank charged check processing fees of $25.00. There was a $1,825.52 automatic withdrawal to pay the mortgage. Of the $1,825.52, $1,572.86 was for interest which had been accrued. The bank charged Friends, Inc. account $250.00...
Xmet Inc. showed the following alphabetized list of adjusted account balances at December 31, 2014:   ...
Xmet Inc. showed the following alphabetized list of adjusted account balances at December 31, 2014:      Accounts Payable 26,160   Accounts Receivable 39,600   Accumulated depreciation, Equipment 10,840   Accumulated depreciation, Warehouse 21,680   Cash 8,800   Cash Dividends 20,000   Common Shares 116,000   Equipment 78,800   Income Tax Expense 41,000   Land 121,600   Notes Payable, due in 2017 34,000   Operating Expenses 109,600   Preferred Shares 39,600   Retained Earnings 28,120   Revenue 275,800   Warehouse 132,800    Required: 1. Assuming normal balances, prepare the closing entries at December 31, 2014, the...
Miller Corporation’s December 31, 2016, bank statement showed a $2,049.25 balance. On this date, Miller’s Cash...
Miller Corporation’s December 31, 2016, bank statement showed a $2,049.25 balance. On this date, Miller’s Cash account reflected a $146.90 overdraft. In reconciling these amounts, the following information is discovered: 1. Cash on hand for undeposited sales receipts, December 31, $130.25. 2. Customer NSF check returned with bank statement, $419.20. 3. Cash sales of $634.25 for the week ended December 18 were recorded on the books. The cashier reports this amount missing, and it was not deposited in the bank....
Miller Corporation’s December 31, 2016, bank statement showed a $2,045.25 balance. On this date, Miller’s Cash...
Miller Corporation’s December 31, 2016, bank statement showed a $2,045.25 balance. On this date, Miller’s Cash account reflected a $348.80 overdraft. In reconciling these amounts, the following information is discovered: 1. Cash on hand for undeposited sales receipts, December 31, $132.25. 2. Customer NSF check returned with bank statement, $422.20. 3. Cash sales of $637.25 for the week ended December 18 were recorded on the books. The cashier reports this amount missing, and it was not deposited in the bank....
AIM Inc. showed the following equity account balances on the December 31, 2019, balance sheet: Common...
AIM Inc. showed the following equity account balances on the December 31, 2019, balance sheet: Common shares, unlimited authorized shares, 861,000 shares issued and outstanding $ 7,404,600 Retained earnings 2,144,800 During 2020, the following selected transactions occurred: Feb. 10 Repurchased and retired 163,800 common shares at $10.00 per share; this is the first retirement recorded by AIM. May 15 Declared a 2:1 share split to shareholders of record on June 1, distributable June 15. Dec. 1 Declared a 10% share...
AIM Inc. showed the following equity account balances on the December 31, 2019, balance sheet: Common...
AIM Inc. showed the following equity account balances on the December 31, 2019, balance sheet: Common shares, unlimited authorized shares, 788,500 shares issued and outstanding $ 7,254,200 Retained earnings 1,984,700 During 2020, the following selected transactions occurred: Feb. 10 Repurchased and retired 162,200 common shares at $10.00 per share; this is the first retirement recorded by AIM. May 15 Declared a 2:1 share split to shareholders of record on June 1, distributable June 15. Dec. 1 Declared a 10% share...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT