Question

In: Accounting

2. On Nov 30, 2016 Sammy’s Smith Shop Inc. had the following Cash in Bank of...

2. On Nov 30, 2016 Sammy’s Smith Shop Inc. had the following Cash in Bank of $15,450. The Bank Statement showed an ending Balance of $18,750 at Nov30 , 2019. Comparisons of Book to Bank revealed the following Reconciling items: a. Outstanding Checks $6,740 b. $18 Bank Service fee c. The Bank transferred a $1,200 check into Sammy’s Smith Shop but it should have deposited it into Sammy’s Ship Shop d. NSF check of $1,600 was received from Sammy’s customer Renata was reported on the bank statement e. The bank collected a $4,550 Note Receivable, plus interest of $750 less a collection fee of $250 f. Sammy recorded recorded a deposit from Cash sales of $8,250 as $13,072 g. Deposits in Transit: $3,250 Required: a. Prepare a Bank Reconciliation b. Record the adjusting journal entries c. What is the Ending Balance in Devin’s Cash Ledger at Nov 30st 2019?

Solutions

Expert Solution

Sammy's Smith Shop Inc
Bank Reconciliation
Nov 30, 2019
Cash Balance as per bank statement $ 18,750
Add: Deposit in transit $    3,250
Deduct:
Outstanding checks $ 6,740
Bank error in recording of deposit $ 1,200 $    7,940
Adjusted bank balance $ 14,060
Cash balance per books $ 15,450
Add: Electronic transfer collected by bank (4550+750-250) $    5,050
Deduct:
Bank service charges $        18
NSF Check $ 1,600
Error in recording of deposit ($13,072-$8,250) $ 4,822 $    6,440
Adjusted book balance $ 14,060
Cash $ 5,050
Bank charges / Misc. expenses $     250
Accounts receivable $ 4,550
Interest revenue $     750
(To record collection of note)
Accounts receivable $ 1,600
Cash $ 1,600
(To record NSF Checks)
Bank charges / Misc. expenses $        18
Cash $        18
(To record bank service charges)
Cash sales   $ 4,822
Cash $ 4,822
(To correct error in recording of cash sales)

You can reach me over comment box if you have any doubts. Please rate this answer


Related Solutions

Nov. 1 – John Smith invested 20,000 cash in his new business called “Goldsmith”  Nov....
Nov. 1 – John Smith invested 20,000 cash in his new business called “Goldsmith”  Nov. 2 – Goldsmith bought a computer using 1,000 cash  Nov. 3 – Goldsmith bought supplies for 5,000 to be paid in the near future  Nov. 4 – John Smith withdrew 2,000 cash from Goldsmith for his personal use  Nov. 5 – Goldsmith paid 1,000 cash for renting a location  Nov. 6 – Goldsmith hired a new office assistant  Nov....
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...
On November 30, 2001, Dr. Smith had a balance of $6,502.88 in his Cash Ledger account....
On November 30, 2001, Dr. Smith had a balance of $6,502.88 in his Cash Ledger account. On that date the bank statement indicated a balance of $8,243.75. Comparison of returned checks and bank memoranda revealed the following: 1. Deposits in transit November 30 amounted to $3,407. 2. Outstanding checks at November 30 totaled $2,140.37. 3. The Bank erroneously changed a $950 check of the Barkley Company against Dr. Smith's Bank account. 4. Bank service charges for November amounted to $20.00....
CASH DISCOUNT 6. A manufacturer sends an invoice dated Nov. 1 with terms 2/10, n/30 in...
CASH DISCOUNT 6. A manufacturer sends an invoice dated Nov. 1 with terms 2/10, n/30 in the      amount of $950. If the invoice is paid on or before Nov. 11, what amount is      paid? If you don’t take advantage of the discount and the invoice is paid by      Dec. 1, what amount is paid?
On November 30, 2016, Davis Company had the following account balances: Debit Credit Cash $3,090 Accounts...
On November 30, 2016, Davis Company had the following account balances: Debit Credit Cash $3,090 Accounts Receivable 9,900 Allowance for Doubtful Accounts $100 Inventory 17,750 Supplies 1,400 Land 9,000 Buildings and Equipment 42,000 Accumulated Depreciation 4,200 Accounts Payable 10,700 Common Stock 20,000 Retained Earnings (1/1/2016) 42,400 Dividends 2,000 Sales Revenue 69,700 Cost of Goods Sold 36,860 Salaries Expense 12,500 Advertising Expense 8,100 Other Expenses 4,500 During the month of December, Davis entered into the following transactions: Date Transaction Dec. 4...
Absorption and Variable Costing Problem The first month of operations ended Nov 30, 2016. Flexo Company...
Absorption and Variable Costing Problem The first month of operations ended Nov 30, 2016. Flexo Company produced 47,200 hammers of which 39,800 were sold. Operating data for the month are as follows: Sales: $325,000 Manufacturing costs: Direct materials: $90,000 Direct labor: $28,000 Variable manufacturing costs: $15,500 Fixed manufacturing costs: $11,000 =$144,500 Selling and administrative expenses: Variable: $19,000 Fixed: $11,000 =$30,000 1. How much is the Gross Profit (Gross Margin) under the absorption costing method? 2. How much is the Net...
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 92,500...
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 92,500 $ 69,000 Accounts receivable, net 102,500 76,000 Inventory 88,800 124,000 Prepaid expenses 6,900 10,400 Total current assets 290,700 279,400 Equipment 149,000 140,000 Accum. depreciation—Equipment (39,500 ) (21,500 ) Total assets $ 400,200 $ 397,900 Liabilities and Equity Accounts payable $ 50,000 $ 67,500 Wages payable 8,500 20,000 Income taxes payable 5,900 8,800 Total current liabilities 64,400 96,300 Notes payable (long term) 55,000 85,000 Total...
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 92,500...
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 92,500 $ 69,000 Accounts receivable, net 102,500 76,000 Inventory 88,800 124,000 Prepaid expenses 6,900 10,400 Total current assets 290,700 279,400 Equipment 149,000 140,000 Accum. depreciation—Equipment (39,500 ) (21,500 ) Total assets $ 400,200 $ 397,900 Liabilities and Equity Accounts payable $ 50,000 $ 67,500 Wages payable 8,500 20,000 Income taxes payable 5,900 8,800 Total current liabilities 64,400 96,300 Notes payable (long term) 55,000 85,000 Total...
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 93,100...
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 93,100 $ 68,000 Accounts receivable, net 101,000 75,000 Inventory 87,800 122,500 Prepaid expenses 6,800 10,200 Total current assets 288,700 275,700 Equipment 148,000 139,000 Accum. depreciation—Equipment (39,000 ) (21,000 ) Total assets $ 397,700 $ 393,700 Liabilities and Equity Accounts payable $ 49,000 $ 66,000 Wages payable 8,400 19,800 Income taxes payable 5,800 8,600 Total current liabilities 63,200 94,400 Notes payable (long term) 54,000 84,000 Total...
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 97,900...
IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 97,900 $ 60,000 Accounts receivable, net 89,000 67,000 Inventory 79,800 110,500 Prepaid expenses 6,000 8,600 Total current assets 272,700 246,100 Equipment 140,000 131,000 Accum. depreciation—Equipment (35,000 ) (17,000 ) Total assets $ 377,700 $ 360,100 Liabilities and Equity Accounts payable $ 41,000 $ 54,000 Wages payable 7,600 18,200 Income taxes payable 5,000 7,000 Total current liabilities 53,600 79,200 Notes payable (long term) 46,000 76,000 Total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT