Question

In: Accounting

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 bank during March. The bank notified Odum of this collection on the bank statement.

4. The bank service charge for March was $15.

5. A deposit of $951.75 mailed to the bank on March 31 did not appear on the bank statement.

6. The following checks mailed to creditors had not been processed by the bank on March 31:

#429 $ 57.40 #433 $214.80

#432 $147.50 #434 $191.90

7. A customer check for $149.50 in payment of his account and listed correctly for that amount on the bank statement had been incorrectly recorded on the accounting records as $194.50.

Required

1. Prepare a bank reconciliation for the Odum Corporation for March 31, 2007.

2. Prepare any adjusting journal entries necessary to record the information from Requirement 1.

Expert Solution

Bank Reconciliation:

Bank
Balance as per Bank Statement as on Mar 31, 2016	$17924.55
Add: Cash yet to be deposited in bank on 31/3/16	724.50
Add: Deposit in transit	951.75
	19600.80
Less: Outstanding Checks	-611.60
Adjusted Balance as per Bank Statement =	$18989.20

Books
Balance as per Cash Book as on Mar 31, 2016	$17198.00
Add: Notes principle collected by bank	2000.00
Add: Note interest collected by bank	25.00
	19223.00
Less: NSF check received	-173.80
Less: Bank charges	-15
Less: Excess deposits recorded in books	-45
Adjusted Balance as per Cash Book	$18989.20

Journal entries in the company's books:

Date	Accounts Titles	Debit $	Credit $
2007
Mar 31	Accounts Receivable	173.80
	Cash		173.80

	Cash	2025
	Note Receivable		2000
	Interest on Note receivable		25

	Bank Charges	15
	Cash		15

	Accounts Receivable	45
	Cash		45
	(excess deposit recorded in books)

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

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

On 31 March the balance brought down on a firm's bank account in its ledger was...

On 31 March the balance brought down on a firm's bank account in its ledger was £3,600, credit. At the same date, outstanding cheques amounted to £1,400 and outstanding lodgements amounted to £2,000. A cheque for £500, received from a DEBTOR, was SUBSEquently dishonoured. The receipt of the cheque had been correctly recorded but no entry has yet been made in the accounting records in respect of it being dishonoured. On the basis of the above information, the balance on...

Broadway Enterprises has received its bank statement as at March 31, 2019 which showed a balance...

Broadway Enterprises has received its bank statement as at March 31, 2019 which showed a balance of $15,180. Meanwhile its Cash book balance at March 31, 2019 stood $8,140. In addition, the Accountant of Broadway Enterprises was presented with the following information: Bank charges for the month were shown as $250 as per bank statement. Cheques issued to two creditors-Alloy Limited for $900 (cheque #253) and Ben Lion for $270 (cheque #258) were not presented to the bank and remain...

The balance in the Colt Company's Cash account on August 31 was $19,700, before the bank...

The balance in the Colt Company's Cash account on August 31 was $19,700, before the bank reconciliation was prepared. After examining the August bank statement and items included with it, the company's accountant found: Checks outstanding $4,300 Check from customer returned NSF 140 Note collected by bank for the Colt Company 1,200 Deposits outstanding 1,800 Bank service fees 60 What is the amount of cash that should be reported in the balance sheet as of August 31? rev: 02_28_2019_QC_CS-161029 A)$22,200....

Bank Reconciliation The bank reconciliation made by Sandler Company, a sole proprietorship, on March 31 showed:...

Bank Reconciliation The bank reconciliation made by Sandler Company, a sole proprietorship, on March 31 showed: Deposit in transit of $1,100 Outstanding checks no.797 $450 no.804 $890 The reconciled cash balance on March 31 was $11,720 The following bank statement is available for April 2012. Bank Statement TO Sandler Company April 30 Fairbanks, AK FAIRBANKS NATIONAL BANK Date Deposits No. Date Charges Date Balance Apr. 1 $1,100 804 Apr. 2 $890 Mar. 31 $11,960 3 1,680 807 3 730 Apr....

Bank Reconciliation The cash account of Abstract, Inc., disclosed a balance of $16,348.82 on October 31....

Bank Reconciliation The cash account of Abstract, Inc., disclosed a balance of $16,348.82 on October 31. The bank statement as of October 31 showed a balance of $19,711.75. Upon comparing the statement with the cash records, the following facts were developed.(a) Abstract’s account was charged on October 26 for a customer’s uncollectible check amounting to $1,927.(b) A 2-month, 8%, $1,350 customer’s note dated August 25, discounted on October 12, was dishonored October 26 and the bank charged Abstract $1,374.91, which...

Metro Rent – A Car Unadjusted Trial Balance Dec. 31, 2007 Account Name Debits Credits Cash...

Metro Rent – A Car Unadjusted Trial Balance Dec. 31, 2007 Account Name Debits Credits Cash in Bank 120,000 Shop Supplies Inventory 25,300 Prepaid Insurance 19,200 Mitsubishi Cars 1,500,000 Accumulated Depreciation 0 Accrued Commission Expense 0 Unearned Rental Income 25,000 M. Capital 1,507,000 Car Rental Income 160,000 Gasoline Expense 18,000 Insurance Expense 0 Repairs & Maintenance 9,500 Depreciation Expense 0 Shop Supplies Used 0 Commission Expense 0 Totals $1,692,000 $1,692,000 Car insurance covers the period from June 1, 2007 to...

On May 31, 2017, Forester Theatre's cash account per its general ledger showed the following balance:...

On May 31, 2017, Forester Theatre's cash account per its general ledger showed the following balance: CASH No. 101 Date Explanation Ref Debit Credit Balance May 31 Balance 6,841 The bank statement from Canada Bank on that date showed the following balance: CANADA BANK Cheques and Debits Deposits and Credits Daily Balance XXX XXX 5/31 6,804 A comparison of the details on the bank statement with the details in the Cash account revealed the following facts. 1.The statement included a...

On 31 July, Brian Company’s Cash at Bank account had a credit balance of $4 647.50....

On 31 July, Brian Company’s Cash at Bank account had a credit balance of $4 647.50. The following information is made available by the company for you to prepare a bank reconciliation for July: Deposit in-transit 31 July amounted to $1 015.30. Outstanding cheques 31 July amounted to $530.00. The bank statement at the end of July indicated a debit balance of $2 000.00. The bank incorrectly deposited a $799.20 cheque of Bright Company against Brian’s bank account. A $10...