50.1K

Verified Solution

Link Copied!

Sunshine Interiors 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 July $31,20$Y$0,$ 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:

Line Item Description Amount

Balance as of July $1$ $$9,580\mathrm{.}00$

CASH RECEIPTS FOR MONTH OF JULY $6,467\mathrm{.}42$

DUPLICATE DEPOSIT TICKETS:

Date and amount of each deposit in July:

Date Amount Date Amount Date Amount

July $2$ $$569\mathrm{.}50$ July $12$ $$580\mathrm{.}70$ July $23$ $$715\mathrm{.}45$

July $5701\mathrm{.}80$ July $16600\mathrm{.}10$ July $26601\mathrm{.}50$

July $9819\mathrm{.}24$ July $19701\mathrm{.}26$ July $311,177\mathrm{.}87$

CHECKS WRITTEN:

Number and amount of each check issued in July:

Check No$.$ Amount Check No$.$ Amount Check No$.$ Amount

$614$ $$243\mathrm{.}50621$ $$309\mathrm{.}50628$ $$837\mathrm{.}70$

$615350\mathrm{.}10622$ Void $629329\mathrm{.}90$

$616279\mathrm{.}90623$ Void $630882\mathrm{.}80$

$617395\mathrm{.}50624707\mathrm{.}016311,081\mathrm{.}56$

$618435\mathrm{.}40625158\mathrm{.}63632325\mathrm{.}40$

$619320\mathrm{.}10626550\mathrm{.}03633310\mathrm{.}08$

$620238\mathrm{.}87627391\mathrm{.}73634241\mathrm{.}71$

Total amount of

checks ssued in July $$8,389\mathrm{.}42$

BANK RECONCILIATION FOR PRECEDING MONTH:

Sunshine Interiors

Bank Reconciliation

June $30,20$Y$0$

Cash balance according to bank statement $$9,424\mathrm{.}70$

Add: Deposit of June $30$ not recorded by bank $$780\mathrm{.}80$

Deduct: Outstanding Check No$.580($$$310\mathrm{.}10)$

Outstanding Check No$.602(85\mathrm{.}50)$

Outstanding Check No$.612(92\mathrm{.}50)$

Outstanding Check No$.613(137\mathrm{.}40)$

Total deductions $(625\mathrm{.}50)$

Adjusted balance $$9,580\mathrm{.}00$

Cash balance according to company's records $$9,607\mathrm{.}70$

Deduct: Bank service charges $(27\mathrm{.}70)$

Adjusted balance $$9,580\mathrm{.}00$

JULY BANK STATEMENT:

MEMBER FDIC PAGE $1$

AMERICAN NATIONAL BANK OF DETROIT ACCOUNT NUMBER

FROM $7/01/20$Y$0$ TO $7/31/20$Y$0$

Line Item Description Number Line Item Description Amount

DETROIT, MI $48201-2500(313)933-8547$ BALANCE $9,424\mathrm{.}70$

$9$ DEPOSITS $6,106\mathrm{.}35$

$20$ WITHDRAWALS $7,657\mathrm{.}74$

SUNSHINE INTERIORS $4$ OTHER DEBITS AND CREDITS $3,749\mathrm{.}00$CR

NEW BALANCE $11,622\mathrm{.}31$

CHECKS OTHER DEBITS CHECKS OTHER DEBITS NSF Amount DEPOSITS DATE BALANCE

No$.580310\mathrm{.}10$ No$.61292\mathrm{.}50780\mathrm{.}8007/019,802\mathrm{.}90$

No$.60285\mathrm{.}50$ No$.614243\mathrm{.}50569\mathrm{.}5007/0310,043\mathrm{.}40$

No$.615350\mathrm{.}10$ No$.616279\mathrm{.}90701\mathrm{.}8007/0610,115\mathrm{.}20$

No$.617395\mathrm{.}50$ No$.618435\mathrm{.}40819\mathrm{.}2407/1110,103\mathrm{.}54$

No$.619320\mathrm{.}10$ No$.620238\mathrm{.}87580\mathrm{.}7007/1310,125\mathrm{.}27$

No$.621309\mathrm{.}50$ No$.624707\mathrm{.}01$ MS $4,000\mathrm{.}0007/1413,108\mathrm{.}76$

No$.625158\mathrm{.}63$ No$.626550\mathrm{.}03$ MS $160\mathrm{.}0007/1412,560\mathrm{.}10$

No$.627319\mathrm{.}73$ No$.629329\mathrm{.}90600\mathrm{.}1007/1712,510\mathrm{.}57$

No$.630882\mathrm{.}80$ No$.6311,081\mathrm{.}56$ NSF $375\mathrm{.}0007/2010,171\mathrm{.}21$

No$.632325\mathrm{.}40$ No$.634241\mathrm{.}71701\mathrm{.}2607/2110,305\mathrm{.}36$

$751\mathrm{.}4507/2411,056\mathrm{.}81$

$601\mathrm{.}5007/2811,658\mathrm{.}31$

SC $36\mathrm{.}0007/3111,622\mathrm{.}31$

EC $$ ERROR CORRECTION OD $$ OVERDRAFT

MS $$ MISCELLANEOUS PS $$ PAYMENT STOPPED

NSF $$ NOT SUFFICIENT FUNDS SC $$ SERVICE CHARGE

THE RECONCILEMENT OF THIS STATEMENT WITH YOUR RECORDS IS ESSENTIAL.

ANY ERROR OR EXCEPTION SHOULD BE REPORTED IMMEDIATELY.

Required:

Question Content Area

$1.$ Prepare a bank reconciliation as of July $31,20$Y$0.$ 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. All checks are written to satisfy accounts payable. Round your answers to two decimal places.

Sunshine Interiors

Bank Reconciliation

July $31,20$Y$0$

Line Item Description Amount Amount

Cash balance according to bank statement blank $Cash balance according to bank statement

$11,701\mathrm{.}41$

Add: Deposit in transit on July $31$

blank Add: Deposit in transit on July $31$

Deduct: Outstanding Check no$.613$

$Deduct: Outstanding Check no$.613$

$137\mathrm{.}40$

Deduct: Outstanding Check No$.628$

Deduct: Outstanding Check No$.628$

Deduct: Outstanding Check No$.633$

Deduct: Outstanding Check No$.633$

Total deductions blank Total deductions

Adjusted balance blank $Adjusted balance

blank

Cash balance according to company's records blank $Cash balance according to company's records

Deduct: Service charges

$Deduct: Service charges

$-$ Select $-$

$-$ Select $-$

blank

Total additions blank Total additions

$$-$ Select $-$

$-$ Select $-$

blank

Total deductions blank Total deductions

Adjusted balance blank $Adjusted balance

Question Content Area

$2.$ Journalize the necessary entries $($a$.)$ that increase cash and $($b$.)$ that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank. Round your answers to two decimal places.

DateAccountDebitCredit

a$.20$Y$0$ July $31$

b$.$ July $31$

Question Content Area

$3.$ What is

Answer & Explanation Solved by verified expert

See Answer