Question

In: Accounting

The following information is available for Park Valley Spa for July Year 1: BANK STATEMENT STATE...

The following information is available for Park Valley Spa for July Year 1:

BANK STATEMENT
STATE BANK
BOLTA VISTA, NV 10001
Park Valley Spa
10 Main Street
Bolta Vista, NV 10001
Account number
12-4567
July 31, Year 1
Beginning balance 6/30/Year 1 $ 9,770
Total deposits and other credits 29,805
Total checks and other debits 22,513
Ending balance 7/31/Year 1 17,062
Checks and Debits Deposits and Credits
Check No. Amount Date Amount
2350 $ 3,768 July 1 $ 1,104
2351 1,641 July 10 6,495
2352 8,000 July 15 4,927
2354 1,397 July 21 6,177
2355 6,189 July 26 5,964
2357 1,502 July 30 2,085
DM 16 CM 3,053


The following is a list of checks and deposits recorded on the books of the Park Valley Spa for July Year 1:

Date Check No. Amount of
Check
Date Amount of
Deposit
July 2 2351 $ 1,641 July 8 $ 6,495
July 4 2352 8,000 July 14 4,927
July 10 2353 2,898 July 21 6,177
July 10 2354 1,397 July 26 5,964
July 15 2355 6,189 July 29 2,085
July 20 2356 72 July 30 3,548
July 22 2357 1,502


Other Information

  1. Check no. 2350 was outstanding from June.
  2. The credit memo was for collection of notes receivable.
  3. All checks were paid at the correct amount.
  4. The debit memo was for printed checks.
  5. The June 30 bank reconciliation showed a deposit in transit of $1,104.
  6. The unadjusted Cash account balance at July 31 was $14,603.


Required
a. Prepare the bank reconciliation for Park Valley Spa at the end of July.
b. Record in general journal form any necessary entries to the Cash account to adjust it to the true cash balance.
  

A. record the collection of notes recievable

event general journal debit credit
1

B. record cash paid for office supplies expenses

event general journal debit credit
2

Solutions

Expert Solution

Solution 1:

Park Valley Spa
Bank Reconciliation - July 31
Bank's Cash balance Company's cash balance
Particulars Amount Particulars Amount
Ending balance as per Bank Statements $17,062.00 Ending Balance as per cash books $14,603.00
Additions: Additions:
Outstanding Deposits $3,548.00 Collection of note $3,053.00
Deductions: Deductions:
Outstanding Checks (Check 2353, 2356) $2,970.00 Check printing charges $16.00
Up to date cash balance as per bank $17,640.00 Up to date cash balance as per books $17,640.00

Solution b:

Journal Entries - Park Valley Spa
Date Particulars Debit Credit
31-Jul Cash Dr $3,053.00
      To Note receivables $3,053.00
(To record collection of note)
31-Jul Miscellaneous expenses Dr $16.00
       To Cash $16.00
(To record check printing charges debited)

Related Solutions

1, Valley Spa purchased $8,400 in plumbing components from Tubman Co. Valley Spa Studios signed a...
1, Valley Spa purchased $8,400 in plumbing components from Tubman Co. Valley Spa Studios signed a 120-day, 10% promissory note for $8,400. If the note is dishonored, what is the amount due on the note? (Use 360 days a year.) Multiple Choice $8,400 $8,680 $8,650 $280 $8,730 2, Jervis sells $3,100 of its accounts receivable to Northern Bank in order to obtain necessary cash. Northern Bank charges a 2% factoring fee. What entry should Jervis make to record the transaction?...
Green Valley Bank sent Comstock Industries its end-of-month bank statement for July. The end of month...
Green Valley Bank sent Comstock Industries its end-of-month bank statement for July. The end of month balance by the bank is $11,237. The statement shows that a deposit for $4,250 is in transit at the end of the statement period. The statement also revealed that checks for $87, $105, and $95 are outstanding. Green Valley collected a $4,000 note receivable plus $120 of interest revenue. The bank charges $20 for the collection service. The bank charges a monthly account fee...
The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017.
  The following information is available to reconcile Branch Company’s book balance of cash with its bank statement cash balance as of July 31, 2017.    On July 31, the company’s Cash account has a $25,640 debit balance, but its July bank statement shows a $26,661 cash balance. Check No. 3031 for $1,000 and Check No. 3040 for $492 were outstanding on the June 30 bank reconciliation. Check No. 3040 is listed with the July canceled checks, but Check No....
Construct a balance sheet and Income statement for Boca State Bank with the following information. Investment...
Construct a balance sheet and Income statement for Boca State Bank with the following information. Investment Securities $23,000 Demand Deposits $19,000 Now accounts $89,000 Cash and due from banks $9,000 Taxes $3,000 Interest on fees and loans $9,000 Retail CDs $28,000 Long term debt $19,000 Reverse Repos $42,000 Interest on investment securities $4,000 Interest on long term debt $2,000 Loans $90,000 Fixed Assets $15,000 Interest on reverse repos $6,000 Interest on deposits $9,000 Other assets $4,000 Paid in capital $4,000...
There are a number of national and state parks available to tourists. Create a Park class...
There are a number of national and state parks available to tourists. Create a Park class which should have name of park, location, type of (i.e., national, state, local) facility, fee, number of employees, number of visitors recorded for the past 12 months, and annual budget data members. Write instance methods that: a) Return a string representing name of the park, the location and type of park. b) Return a string representing the name of the park, the location and...
A company has the following information. 1. Cash balance per bank, July 31, $7,328 2. July...
A company has the following information. 1. Cash balance per bank, July 31, $7,328 2. July bank service charge on bank statement, $40 3. Cash balance per company books, July 31, $7,280 4. Bank statement shows a Note Receivable of $2,000 plus $16 of interest was collected by the bank. 5. Outstanding checks, July 31, $772 6. Deposits in transit, July 31, $2,700 Compute the adjusted cash balance per company books. Do not enter a dollar sign or any commas.
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for...
Bank Reconciliation The following information is available to assist you in preparing a bank reconciliation for Calico Corners on May 31: The balance on the May 31 bank statement is $8,432.11. Not included on the bank statement is a $1,250 deposit made by Calico Corners late on May 31. A comparison between the canceled checks returned with the bank statement and the company records indicated that the following checks are outstanding at May 31: No. 123 $23.40 No. 127 145.00...
The following information is available regarding Desjardins Inc.’s bank information for September 2015: 1,The balance on...
The following information is available regarding Desjardins Inc.’s bank information for September 2015: 1,The balance on the September 30, 2015 Bank Statement was $8,316. 2,The company’s cash account showed a balance of $8,706 on September 30. 3,A deposit of $800 made by Desjardins Inc. late on September 30 was not included on the Bank Statement. 4,A comparison between the cancelled cheques returned with the Bank Statement and the company records indicates that the following cheques were still outstanding on September...
1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance...
1. Kreiger Corporation developed the following reconciling information in preparing its July bank reconciliation: Bank balance before reconciliation                           $23,000 Note receivable collected by bank                                 7,500 Outstanding checks                                                     15,000 Deposits in transit                                                          8,000 Bank service charge                                                          100 NSF check                                                                        1,800 Determine the cash balance per books (before adjustments) for Kreiger. 2. Kendall Corporation had a 1/1/19 balance in the Allowance for Doubtful Accounts of $18,000. During 2019, it wrote off $11,500 of accounts and collected...
King State Bank purchased $500,000 of ten-year, 7.5% Lucille Corporation bonds on July 1, 2019. Interest...
King State Bank purchased $500,000 of ten-year, 7.5% Lucille Corporation bonds on July 1, 2019. Interest on the bonds is paid on January 1 and July 1 of each year. The market rate on the bonds was 8%. The selling prices of the bonds at 12/31/19 and 12/31/20 were 102 and 101 respectively. Required: 1. Prepare an amortization schedule for the entire life of the bonds using Excel.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT