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 $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 accordance with prior authorization, the bank withdrew $610 directly from the checking account as payment on a mortgage note payable. The interest portion of that payment was $430. MSI has made no entry to record the automatic payment.

Bank service charges of $30 were listed on the bank statement.

A deposit of $955 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 $55 for an NSF check. The check was returned with the bank statement and the company will seek payment from the customer.

MSI maintains a $250 petty cash fund that was appropriately reimbursed at the end of December.

According to instructions from MSI on December 30, the bank withdrew $18,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.
2. Prepare any necessary adjusting journal entries indicated.
3. What amount would MSI report as cash and cash equivalents in the current asset section of the December 31, 2018, balance sheet?

Solutions

Expert Solution

Bank Reconcilation Statement
Balance as per Bank Statement 16,236.12
Less :- Cheques Issued but not presented for Payments     1,482.65
Less :- Deposit made of MIS INC        955.00
Bank Balance as per Books 13,798.47
Bank Dr 14
Rent Cr 14
(Being rent entry correced)
Interest Dr 430
Mortgage Payment Dr 180
Bank Cr 610
(Being Mortgage and int entry passed)
Bank Charges Dr 30
Bank Cr 30
(Bank Charges recorded)
Bank Charges Dr 55
Bank Cr 55
(Cheque return charges recorded)
Petty Cash
No Entry Required, as nothing as mentioned except that petty cash is reimbursed appropriately (Its assumed, petty cash is already at 250 level)
Treasury Bills
No entry required as entry already passed
Cash and Cash Equivalents Amount
Bank Balance 13,798.47
Cash (Receipt but deposited in bank on 2nd Jan 18)        655.00
Petty Cash        250.00
Treasury Bills (Matured within 90 days)     9,000.00
Cash and Cash Equivalents 23,703.47

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 $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...
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