Question

In: Accounting

Problem 1: The bank reconciliation for Weez Ltd as at 31 October 2017 was as follows....

Problem 1:

The bank reconciliation for Weez Ltd as at 31 October 2017 was as follows.

WEEZ Ltd Bank Reconciliation 31 October 2017
Cash balance per bank Add: Deposits in transit			$	12 444.70 1 530.20
				13 974.90
Less: Outstanding cheques
Cheque number	Cheque amount
2451 2470 2471 2472 2474	$	1 260.40 720.10 844.50 503.60 1 050.00		4 378.60
Cash balance per the General Ledger			$	9 596.30

The November bank statement had a balance of $17 069.40 and revealed the following cheques and deposits:

Bank statement
Cheques					Deposits
Date	Cheque number		Amount		Date		Amount
1/11 2/11 5/11 4/11 8/11 10/11 15/11 18/11 27/11 30/11 29/11		2470 2471 2474 2475 2476 2477 2479 2480 2481 2483 2486	$	720.10 844.50 1 050.00 1 640.70 2 830.00 600.00 1 750.00 1 330.00 695.40 575.50 900.00		1/11 4/11 8/11 13/11 18/11 21/11 25/11 28/11 30/11	$	1 530.20 1 211.60 990.10 2 575.00 1 472.70 2 945.00 2 567.30 1 650.00 1 186.00
						Total	$	16 127.90
		Total	$	12 936.20

The cash records for Weez Ltd for November showed a general ledger balance of $10 846.90 and the following summaries of cash payments and receipts:

Date

Cheque number

Amount

Date

Cheque number

Amount

1/11

2/11

4/11

8/11

10/11

15/11

18/11

2475

2476

2477

2478

2479

2480

2481

2482

1 640.70

2 830.00

600.00

538.20

1 570.00

1 330.00

695.40

612.00

20/11

22/11

23/11

24/11

29/11

30/11

2483

2484

2485

2486

2487

2488

$ 575.50

829.50

974.80

900.00

398.00

1 200.00

Total

$ 14 694.10

Date

Amount

3/11

7/11

12/11

17/11

20/11

24/11

27/11

29/11

30/11

$ 1 211.60

990.10

2 575.00

1 472.70

2 954.00

2 567.30

1 650.00

1 186.00

1 338.00

Total

15 944.70

Additional Information:

The bank statement contained the following direct debit and credit memoranda:

A credit of $1 505.00 for the collection of a $1 400 note for Weez Ltd plus interest of $120 and less a collection fee of $15. On October 31, 2017, with an adjusting journal entry, Weez Ltd had accrued $100 interest on the note.

A debit for the printing of additional company cheques $72.00.

A debit for an NSF cheque for $130. The company immediately called the customer and was assured that the cheque would now clear. As a result, the cheque was redeposited on 30/11 and is included in the $1 338.00 Cash Receipts above.

Cheque #2479 was a cash payment for equipment. The company’s records are correct.

The cash receipt dated 20/11 was from a large cash sale of merchandise. The company’s records are incorrect.

Required:

(a) In the general journal, prepare the required entries based on your review of the above data. Assume immediate posting of these journal entries, as well as the updating of the Cash GL account—you are not required to prepare the posting. Ignore GST.

(b) Prepare a bank reconciliation as at 30 November, beginning with Balance per Bank Statement.

Solutions

Expert Solution

	Accounts Title	Dr	Cr
30-Nov	Cash	$1,505
	Miscelleneous expense	15
	Notes Receivable		1400
	Interest Revenue		20
	Interest receivable		100

30-Nov	Miscelleneous expense	$72
	Cash		$72

30-Nov	Sales Revenue	$9
	Cash		$9


	Bank Reconciliation
	November 30 2018
	Company's Book
	Book balance		10846.9

	Add
	Proceeds of note less collection charge	1505	1505
			12351.9
	Deductions
	Error (2954-1945)	9

	Printing charges	72	81


	Adjusted Book balance		12270.9


	Bank statement
	Bank statement Balance		17069.4
	Additions: Deposit of November	$1,338
	Add: Bank error (1750-1570)	180	1518
	Deductions		$18,587
	Check No 2451	1260.4
	Check No 2472	503.6
	Check No 2478	538.2
	Check no 2482	612
	Check no 2484	829.5
	Check no 2485	974.8
	Check no 2487	398
	Check no 2488	1200
			6316.5
	Adjusted Bank Balance		$12,270.90

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as...

The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as follows: BLOSSOM COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,771 Add: Deposits in transit 1,580 13,351 Less: Outstanding cheques #2451 $1,200 #2470 960 #2471 882 #2472 516 #2474 1,060 4,618 Adjusted cash balance per bank $8,733 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: BLOSSOM COMPANY...

The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as...

The bank portion of the bank reconciliation for Blossom Company at October 31, 2021, was as follows: BLOSSOM COMPANY Bank Reconciliation October 31, 2021 Cash balance per bank $11,000 Add: Deposits in transit 1,500 12,500 Less: Outstanding cheques #2451 $1,100 #2470 850 #2471 780 #2472 450 #2474 1,000 4,180 Adjusted cash balance per bank $8,320 The adjusted cash balance per bank agreed with the cash balance per books at October 31. The November bank statement showed the following: BLOSSOM COMPANY...

Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the...

Complete the Bank Reconciliation (15pts) Prepare a bank reconciliation as of December 31, 2017 using the following format. I am not going to be particular about how you show your numbers as long as you have them in the right spot and can get to the correct adjusted balances. Bank Balance: Cash Balance: Add: Add: Deduct: Deduct: Adjusted Balance: Adjusted Balance: Journalize the necessary entries. After completing the bank reconciliation show any necessary journal entries. Pretend you have a general...

The bank reconciliation prepared by Gatz Company on May 31, 2017, appeared as follows: GATZ COMPANY...

The bank reconciliation prepared by Gatz Company on May 31, 2017, appeared as follows: GATZ COMPANY Bank Reconciliation May 31, 2017 Bank statement balance $9,264.35 Book balance $19,429.00 Add: Deposit of May 31 in transit 949.00 $10,213.35 Deduct: Deduct: Outstanding cheques: NSF cheque plus service #876 $636.00 charge $11,530.65 #882 1,744.00 2,380.00 Bank service charge 65.00 11,595.65 Adjusted bank balance $7,833.35 Adjusted book balance $7,833.35 The Cash account in the General Ledger appeared as follows on June 30...

The bank reconciliation prepared by Gemma Tours on March 31, 2017, appeared as follows: Gemma Tours...

The bank reconciliation prepared by Gemma Tours on March 31, 2017, appeared as follows: Gemma Tours Bank Reconciliation March 31, 2017 Bank statement balance $15,500 Book balance $34,257 Add: Deposit of March 31 in transit 22,044 $37,544 Deduct: Outstanding cheques: #79 $1,306 #84 1,981 3,287 Adjusted bank balance $34,257 Adjusted book balance $34,257 The Cash account in the General Ledger appeared as follows on April 30: Cash Acct. No. 101 Date Explanation PR Debit Credit Balance 2017 March 31 Balance...

The information below was used to prepare a bank reconciliation for Lorena Company at October 31:...

The information below was used to prepare a bank reconciliation for Lorena Company at October 31: ∙ According to the bank statement, the bank balance as of October 31 was $8,765. According to the books, the cash balance as of October 31 is $9,557. ∙ Outstanding checks totaled $1,433. ∙ A customer's check for $999 was returned for NSF. ∙ October's service charge was $100. ∙ The bank collected $1,600 from a customer of Lorena Company in payment of a...

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

Shown below is the information needed to prepare bank reconciliation for Mandy Company on 31 October...

Shown below is the information needed to prepare bank reconciliation for Mandy Company on 31 October 2019: (1) The cash ledger account showed a balance of $8,510, while the bank statement indicated a cash balance of $12,390. (2) The bank statement showed $45 interest earned for the month of October. (3) ZYX company settled its notes payable by depositing $4,000 directly into Mandy’s bank account. (4) The company issued three checks totaling $1,000, which had not been shown in the...

QUESTION 2 (BANK RECONCILIATION) In the draft accounts for the year ended 31 October 2019 of...

QUESTION 2 (BANK RECONCILIATION) In the draft accounts for the year ended 31 October 2019 of Thomas, garage proprietor, the balance at bank according to the cash book was RM894.68 in hand. Subsequently the following discoveries were made: Cheque number 176276 dated 3 September 2019 for RM310.84 in favour of Gene Sdn Bhd has been correctly recorded in the bank statement, but included in the cash book payments as RM301.84. Bank commission charged of RM169.56 and bank interest charged of...

Problem 8-4A The bank portion of the bank reconciliation for Langer Company at November 30, 2017,...

Problem 8-4A The bank portion of the bank reconciliation for Langer Company at November 30, 2017, was as follows. LANGER COMPANY Bank Reconciliation November 30, 2017 Cash balance per bank $14,577.90 Add: Deposits in transit 2,530.20 17,108.10 Less: Outstanding checks Check Number Check Amount 3451 $ 2,260.40 3470 720.10 3471 844.50 3472 1,426.80 3474 1,051.30 6,303.10 Adjusted cash balance per bank $10,805.00 The adjusted cash balance per bank agreed with the cash balance per books at November 30. The December...

Subjects