Rancho Foods deposits all cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the bank statement as of May 31 have been taken from various documents and records and are reproduced as follows. The sources of the data are printed in capital letters. All checks were written for payments on account.

CASH ACCOUNT:
Balance as of May 1										$9,578.00
CASH RECEIPTS FOR MONTH OF MAY										$5,255.89
DUPLICATE DEPOSIT TICKETS:
Date and amount of each deposit in May:
Date		Amount		Date		Amount		Date		Amount
May 2		$569.50		May 12		$580.70		May 23		$ 731.45
5		701.80		16		600.10		26		601.50
9		189.24		19		701.26		31		580.34
CHECKS WRITTEN:
Number and amount of each check issued in May:
Check No.		Amount		Check No.		Amount		Check No.		Amount
614		$243.50		621		$309.50		628		$ 837.70
615		350.10		622		Void		629		329.90
616		279.90		623		Void		630		882.80
617		395.50		624		707.01		631		1,081.56
618		435.40		625		185.63		632		62.40
619		320.10		626		550.03		633		310.08
620		238.87		627		318.73		634		503.30
Total amount of checks issued in May										$8,342.01

BANK RECONCILIATION FOR PRECEDING MONTH (DATED APRIL 30):
Cash balance according to bank statement				$ 9,422.80
Add deposit of April 30, not recorded by bank				780.80
				$10,203.60
Deduct outstanding checks:
No. 580		$310.10
No. 602		85.50
No. 612		92.50
No. 613		137.50		625.60
Adjusted balance				$ 9,578.00
Cash balance according to companys records				$ 9,605.70
Deduct service charges				27.70
Adjusted balance				$ 9,578.00

Instructions:

1. Prepare a bank reconciliation as of May 31. If errors in recording deposits or checks are discovered, assume that the errors were made by the company. Assume that all deposits are from cash sales except for the note receivable of $4,000 and interest of $160 collected on May 14. All checks are written to satisfy accounts payable. If required, round your answers to the nearest cent.

Rancho Foods
Bank Reconciliation
May 31, 20Y8
Cash balance according to bank statement		$
Add deposit of May 31, not recorded by bank
		$
Deduct outstanding checks:
No. 613	$
No. 628
No. 634
Adjusted balance		$
Cash balance according to Rancho Foods		$
Add: Proceeds of note collected by bank:
Principal	$
Interest
Add: Error in recording May 9 deposit as $189.24 by the company instead of $819.24
Add: Error in recording Check No. 625 as $185.63 by the company instead of $158.63
		$
Deduct: Check returned because of insufficient funds	$
Deduct: Service charges
Adjusted balance		$

Feedback

2. Illustrate the effects on the accounts and financial statements of the bank reconciliation. If no account or activity is affected, select "No effect" from the dropdown and leave the corresponding number entry box blank. Enter account decreases and cash outflows as negative amounts.

Increase in Cash:

Statement of Cash Flows	Balance Sheet								Income Statement
	Assets			=	Liabilities	+	Stockholders' Equity
	Cash	+	Notes Receivable	=	Accounts Payable	+		Retained Earnings
May 31									May 31
Statement of Cash Flows								Income Statement
Operating								Sales
								Interest revenue
								No effect

Decrease in Cash:

Statement of Cash Flows	Balance Sheet								Income Statement
	Assets			=	Liabilities	+	Stockholders' Equity
	Cash	+	Accounts Receivable	=	No effect	+		Retained Earnings
May 31									May 31
Statement of Cash Flows								Income Statement
Operating								Miscellaneous administrative expense
								No effect
								No effect

Feedback

3. What is the amount of Cash that should appear on the balance sheet as of May 31? Round your answer to the nearest cent. $

4. Assume that a canceled check for $50 had been incorrectly recorded by the bank as $500. Which of the following is the correct way to include the error in a bank reconciliation? The error of $450 in the canceled check should be added to the "balance according to bank statement" on the bank reconciliation.

Feedback

I need the one answer in the last screen shot ...Please

PAGE 1 MEMBER FDIC AMERICAN NATIONAL BANK OF DETROIT DETROIT, MI 48201-2500 (313)933-8547 ACCOUNT NUMBER FROM 5/01/2018 BALANCE TO 5/31/20Y8 9,422.80 6,086.35 7,462.11 9 DEPOSITS 20 WITHDRAWALS 4 OTHER DEBITS AND CREDITS Rancho Foods 3,650.0OCR 11,697.04 NEW BALANCE .----- CHECKS AND OTHER DEBITS ----- - DEPOSITS -.-DATE-.-BALANCE- No.580 310.10 No.612 92.50 780.80 05/01 9,801.00 No.B02 85.50 No.614 243.50 569.50 05/03 10,041.50 No.815 350.10 No.616 279.90 701.80 05/06 10,113.30 No.817 395.50 No.618 435.40 819.24 05/11 10,101.64 No.819 320.10 No.620 238.BY 580.70 05/13 10,123.37 No.621 309.50 No.624 707.01 MS 4,000.00 05/14 13,106.88 No.825 158.63 No.626 550.03 MS 160.00 05/14 12,558.20 No.627 318.73 No.629 329.90 600.10 05/17 12,509.17 No.830 882.80 No.631 1,081.56 NSF 450.00 05/20 10,095.31 No.632 82.40 No.633 310.08 701.26 05/21 10,424.00 731.45 05/24 11,155.54 601.50 05/28 11,757.04 SC 60.00 05/31 11,697.04 EC - ERROR CORRECTION OD - OVERDRAFT MS - MISCELLANEOUS PS - PAYMENT STOPPED NSP - NOT SUFFICIENT FUNDS SC - SERVICE CHARGE THE RECONCILEMENT OF THIS STATEMENT WITH YOUR RECORDS IS ESSENTIAL ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEDIATELY. 2. Illustrate the effects on the accounts and financial statements of the bank reconciliation. If no account or activity is affected, select "No effect" from the dropdown and leave the corresponding number entry box blank. Enter account decreases and cash outflows as negative amounts. Increase in Cash: Balance Sheet Income Statement of Cash Flows Assets Liabilities Stockholders' Equity Statement cas Notes Receivable Accounts Payable C 27 Retained Earnings C790 May 31 4, 17 -4,000 May 31 Statement of Caskows Income Statement Operating Sales 630 Interest revenue 160.00 No effect 0 PAGE 1 MEMBER FDIC AMERICAN NATIONAL BANK OF DETROIT DETROIT, MI 48201-2500 (313)933-8547 ACCOUNT NUMBER FROM 5/01/2018 BALANCE TO 5/31/20Y8 9,422.80 6,086.35 7,462.11 9 DEPOSITS 20 WITHDRAWALS 4 OTHER DEBITS AND CREDITS Rancho Foods 3,650.0OCR 11,697.04 NEW BALANCE .----- CHECKS AND OTHER DEBITS ----- - DEPOSITS -.-DATE-.-BALANCE- No.580 310.10 No.612 92.50 780.80 05/01 9,801.00 No.B02 85.50 No.614 243.50 569.50 05/03 10,041.50 No.815 350.10 No.616 279.90 701.80 05/06 10,113.30 No.817 395.50 No.618 435.40 819.24 05/11 10,101.64 No.819 320.10 No.620 238.BY 580.70 05/13 10,123.37 No.621 309.50 No.624 707.01 MS 4,000.00 05/14 13,106.88 No.825 158.63 No.626 550.03 MS 160.00 05/14 12,558.20 No.627 318.73 No.629 329.90 600.10 05/17 12,509.17 No.830 882.80 No.631 1,081.56 NSF 450.00 05/20 10,095.31 No.632 82.40 No.633 310.08 701.26 05/21 10,424.00 731.45 05/24 11,155.54 601.50 05/28 11,757.04 SC 60.00 05/31 11,697.04 EC - ERROR CORRECTION OD - OVERDRAFT MS - MISCELLANEOUS PS - PAYMENT STOPPED NSP - NOT SUFFICIENT FUNDS SC - SERVICE CHARGE THE RECONCILEMENT OF THIS STATEMENT WITH YOUR RECORDS IS ESSENTIAL ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEDIATELY. 2. Illustrate the effects on the accounts and financial statements of the bank reconciliation. If no account or activity is affected, select "No effect" from the dropdown and leave the corresponding number entry box blank. Enter account decreases and cash outflows as negative amounts. Increase in Cash: Balance Sheet Income Statement of Cash Flows Assets Liabilities Stockholders' Equity Statement cas Notes Receivable Accounts Payable C 27 Retained Earnings C790 May 31 4, 17 -4,000 May 31 Statement of Caskows Income Statement Operating Sales 630 Interest revenue 160.00 No effect 0