Question

In: Accounting

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.
4.	Note receivable of $2,500.00 and interest of $25 collected by the bank and not recorded on the books.
5.	Deposit in transit December 31, $320.00.
6.	A customer check for $290.40 in payment of its account was recorded on the books at $940.20.
7.	Outstanding checks, $2,030.55. Includes a duplicate check of $64.85 to C. Brown, who notified Miller that the original was lost. Miller stopped payment on the original check and has already adjusted the cash account in the accounting records for this amount.

	Required:
1.	Prepare a December 31 bank reconciliation for Miller.
2.	Prepare any journal entries necessary by Miller to record the information from Requirement 1.

Expert Solution

1.RECONCILIATION STATEMENT

Bal. per bank statement $ 2045.25

Add : Sales receipts not yet deposited $ 132.25

Add : Deposits in transit $ 320

Less : Outstanding checks ($ 2030.55)

Adjusted bal. per bank statement $ 466.95

Bal. per Cash account ($ 348.80)

Less : NSF check ($ 422.20)

Less : missing cash sales ($ 637.25)

Add : Note receivable collected $ 2,500

Add : Interest collected $ 25

Less error correction ( $940.20 - $290.40) ($649.80),

Adjusted bal. per cash account $ 466.95

2.Journal Entries

Dr Accounts receivable 422.20

Cr Cash 422.20

Dr Cash shortage 637.25

Cr Cash 637.25

Dr Cash 2500

Cr Note receivable 2500

Dr Cash 25

Cr Interest revenue 25

Dr Accounts receivable 649.80

Cr Cash 649.80

ekkarill92 answered 1 year ago

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

The Odum Corporation’s cash account showed a balance of $17,198 on March 31, 2007. The bank...

The Odum Corporation’s cash account showed a balance of $17,198 on March 31, 2007. The bank statement balance for the same date indicated a balance of $17,924.55. The following additional information is available concerning Odum’s cash balance on March 31, 2007. 1. Undeposited cash on hand on March 31 amounted to $724.50. 2. A customer’s NSF check for $173.80 was returned with the bank statement. 3. A note for $2,000 plus interest of $25 was collected for Odum by the...

Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $ ...

Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $ 235,000 $ 400,000 Accounts Receivable 367,200 325,000 Inventory 450,000 500,200 Prepaid Expenses 120,000 160,000 Long-term investment 100,000 300,000 Equiptment (Net) 1,050,000 1,125,000 Total Assets $ 2,322,200 $ 2,810,200 Accounts Payable $ 421,000 $ 411,000 Salary Payable 134,000 180,000 Interest Payable 110,000 112,000 Bonds Payable 550,000 560,000 Common Shares...

Ratios (Appendix) Miller Company's condensed income statement for 2016 and December 31, 2016, balance sheet follow:...

Ratios (Appendix) Miller Company's condensed income statement for 2016 and December 31, 2016, balance sheet follow: Income Statement Sales (net) $304,400 Cost of goods sold (183,600) Gross profit $120,800 Operating expenses (82,000) Operating income $38,800 Interest expense (7,000) Income before income taxes $31,800 Income taxes (10,000) Net income 21,800 Balance Sheet Cash $8,200 Accounts payable $18,000 Receivables (net) 14,700 Other current liabilities 6,800 Inventory 19,300 Bonds payable, 10% 70,000 Property, plant, and equipment (net) 195,800 Common stock, $10 par 80,500...

The statement of financial position of Dai Sing Ltd as at 31 December 2016 showed a...

The statement of financial position of Dai Sing Ltd as at 31 December 2016 showed a balance in Accounts Receivable of $1,753,800, and a credit balance in Allowance for Doubtful Accounts of $210,456. During the financial year ended 31 December 2017, the following transactions occurred: sales on account $5,566,300; sales returns $340,000; collections from customers $5,072,800; accounts written off $209,000; discount allowed $8,800; and collection of previously written off accounts of $57,000. Required a ‘The direct write-off method of accounting...

Hudson Corporation’s balance sheet at December 31, 2016, is presented below. Hudson Corporation Balance Sheet December...

Hudson Corporation’s balance sheet at December 31, 2016, is presented below. Hudson Corporation Balance Sheet December 31, 201 Hudson Corporation Balance Sheet December 31, 2016 Cash $ 13,100 Accounts payable $ 8,750 Accounts receivable 19,780 Common stock 20,000 Allowance for doubtful accounts ( 800 ) Retained earnings 12,730 Inventory 9,400 $ 41,480 $ 41,480 During January 2016, the following transactions occurred. Hudson Corporation uses the perpetual inventory method. Jan. 1 Hudson Corporation accepted a 4-month, 8% note from Betheny Company...

Preparation of bank reconciliation The April 30, 2016, bank statement for Comet Company showed a cash...

Preparation of bank reconciliation The April 30, 2016, bank statement for Comet Company showed a cash balance of $7,582. The cash account in the company's general ledger (G/L), according to the company's records on April 30, had a balance of $4,643. The following additional data were revealed during the reconciliation process: 1.A deposit of $652 that had been made by the company on March 31 was processed by the bank in April, and a deposit of $1,531 made on April...

A partial statement of financial position of Carla Vista Ltd. on December 31, 2016, showed the...

A partial statement of financial position of Carla Vista Ltd. on December 31, 2016, showed the following property, plant, and equipment assets accounted for under the cost model (accumulated depreciation includes depreciation for 2016): Buildings $300,000 Less: accumulated depreciation 100,000 $200,000 Equipment $131,000 Less: accumulated depreciation 51,000 80,000 Carla Vista uses straight-line depreciation for its building (remaining useful life of 20 years, no residual value) and for its equipment (remaining useful life of 8 years, no residual value). Carla Vista...

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