On July 31, 2022, Carla Vista Co. had a cash balance per books of $6,335.00. The statement from Dakota State Bank on that date showed a balance of $7,885.80. A comparison of the bank statement with the Cash account revealed the following facts.1. The bank service charge for July was $19.00.2. The bank collected $1,715.00 from a customer for Carla Vista Co. through electronic funds transfer.3. The July 31 receipts of $1,394.30 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31.4. Company check No. 2480 issued to L. Taylor, a creditor, for $374.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $347.00.5. Checks outstanding on July 31 totaled $2,046.10.6. On July 31, the bank statement showed an NSF charge of $770.00 for a check received by the company from W. Krueger, a customer, on account.     Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first.)CARLA VISTA CO.Bank Reconciliationchoose the accounting period For the Month Ended July 31, 2022July 31, 2022For the Year Ended July 31, 2022select an opening name for section one Adjusted cash balance per bankBank service chargeNSF checkElectronic funds transfer receivedError in recording check No. 2480Cash balance per bank statementDeposits in transitOutstanding checks   $enter a dollar amount select between addition and deduction AddLess:select a reconciling item Deposits in transitCash balance per bank statementAdjusted cash balance per bankElectronic funds transfer receivedNSF checkError in recording check No. 2480Bank service chargeOutstanding checks   enter a dollar amount      enter a subtotal of the two previous amounts select between addition and deduction AddLess:select a reconciling item Cash balance per bank statementAdjusted cash balance per bankElectronic funds transfer receivedNSF checkError in recording check No. 2480Bank service chargeDeposits in transitOutstanding checks   enter a dollar amount select a closing name for section one Cash balance per bank statementElectronic funds transfer receivedDeposits in transitNSF checkBank service chargeAdjusted cash balance per bankOutstanding checksError in recording check No. 2480   $enter a total amount for the first section       select an opening name for section two Deposits in transitNSF checkOutstanding checksError in recording check No. 2480Bank service chargeElectronic funds transfer receivedCash balance per booksAdjusted cash balance per books   $enter a dollar amount select between addition and deduction AddLess:select a reconciling item NSF checkOutstanding checksError in recording check No. 2480Bank service chargeElectronic funds transfer receivedCash balance per booksAdjusted cash balance per booksDeposits in transit   enter a dollar amount      enter a subtotal of the two previous amounts select between addition and deduction AddLess:      select a reconciling item    Bank service charge    Cash balance per books    Electronic funds transfer received    Adjusted cash balance per books    Deposits in transit    Outstanding checks    NSF check    Error in recording check No. 2480     $enter a dollar amount    select a reconciling item    Cash balance per books    Outstanding checks    Deposits in transit    Electronic funds transfer received    Adjusted cash balance per books    Error in recording check No. 2480    NSF check    Bank service charge     enter a dollar amount    select a reconciling item    Cash balance per books    Electronic funds transfer received    Bank service charge    Deposits in transit    Outstanding checks    NSF check    Error in recording check No. 2480    Adjusted cash balance per books     enter a dollar amount        enter a subtotal of the three previous amounts select a closing name for section two NSF checkCash balance per booksDeposits in transitBank service chargeElectronic funds transfer receivedOutstanding checksError in recording check No. 2480Adjusted cash balance per books   $enter a total amount for the second section   SHOW LIST OF ACCOUNTSLINK TO TEXTLINK TO VIDEO   Prepare the necessary adjusting entries at July 31. (Credit account titles are automatically indented when amount is entered. Do not indent manually.)Date.Account Titles and ExplanationDebitCreditJuly 31.enter an account title to record electronic funds transfer received by bank    enter an account title to record electronic funds transfer received by bank    (To record electronic funds transfer received by bank)  31.enter an account title To record NSF check    enter an account title To record NSF check    (To record NSF check)  31.enter an account title for the adjusting entry to correct error in recording check    enter an account title for the adjusting entry to correct error in recording check    (To correct error in recording check)  31.enter an account title to record bank service charge    ente    (To

Question
Asked Oct 21, 2019
395 views

 

On July 31, 2022, Carla Vista Co. had a cash balance per books of $6,335.00. The statement from Dakota State Bank on that date showed a balance of $7,885.80. A comparison of the bank statement with the Cash account revealed the following facts.

1.   The bank service charge for July was $19.00.
2.   The bank collected $1,715.00 from a customer for Carla Vista Co. through electronic funds transfer.
3.   The July 31 receipts of $1,394.30 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31.
4.   Company check No. 2480 issued to L. Taylor, a creditor, for $374.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $347.00.
5.   Checks outstanding on July 31 totaled $2,046.10.
6.   On July 31, the bank statement showed an NSF charge of $770.00 for a check received by the company from W. Krueger, a customer, on account.
 
 
 
 
 
Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first.)

CARLA VISTA CO.
Bank Reconciliation
choose the accounting period
 For the Month Ended July 31, 2022July 31, 2022For the Year Ended July 31, 2022
select an opening name for section one
 Adjusted cash balance per bankBank service chargeNSF checkElectronic funds transfer receivedError in recording check No. 2480Cash balance per bank statementDeposits in transitOutstanding checks
     
$enter a dollar amount
 
select between addition and deduction
 AddLess
:
select a reconciling item
 Deposits in transitCash balance per bank statementAdjusted cash balance per bankElectronic funds transfer receivedNSF checkError in recording check No. 2480Bank service chargeOutstanding checks
     
enter a dollar amount
 
         
enter a subtotal of the two previous amounts
 
select between addition and deduction
 AddLess
:
select a reconciling item
 Cash balance per bank statementAdjusted cash balance per bankElectronic funds transfer receivedNSF checkError in recording check No. 2480Bank service chargeDeposits in transitOutstanding checks
     
enter a dollar amount
 
select a closing name for section one
 Cash balance per bank statementElectronic funds transfer receivedDeposits in transitNSF checkBank service chargeAdjusted cash balance per bankOutstanding checksError in recording check No. 2480
     
$enter a total amount for the first section
 
           
select an opening name for section two
 Deposits in transitNSF checkOutstanding checksError in recording check No. 2480Bank service chargeElectronic funds transfer receivedCash balance per booksAdjusted cash balance per books
     
$enter a dollar amount
 
select between addition and deduction
 AddLess
:
select a reconciling item
 NSF checkOutstanding checksError in recording check No. 2480Bank service chargeElectronic funds transfer receivedCash balance per booksAdjusted cash balance per booksDeposits in transit
     
enter a dollar amount
 
         
enter a subtotal of the two previous amounts
 
select between addition and deduction
 AddLess
:
         
  select a reconciling item
    Bank service charge    Cash balance per books    Electronic funds transfer received    Adjusted cash balance per books    Deposits in transit    Outstanding checks    NSF check    Error in recording check No. 2480    
 
$enter a dollar amount
 
   
  select a reconciling item
    Cash balance per books    Outstanding checks    Deposits in transit    Electronic funds transfer received    Adjusted cash balance per books    Error in recording check No. 2480    NSF check    Bank service charge    
 
enter a dollar amount
 
   
  select a reconciling item
    Cash balance per books    Electronic funds transfer received    Bank service charge    Deposits in transit    Outstanding checks    NSF check    Error in recording check No. 2480    Adjusted cash balance per books    
 
enter a dollar amount
 
   
         
enter a subtotal of the three previous amounts
 
select a closing name for section two
 NSF checkCash balance per booksDeposits in transitBank service chargeElectronic funds transfer receivedOutstanding checksError in recording check No. 2480Adjusted cash balance per books
     
$enter a total amount for the second section
 
 
 

SHOW LIST OF ACCOUNTS
LINK TO TEXT
LINK TO VIDEO
 
 
 
Prepare the necessary adjusting entries at July 31. (Credit account titles are automatically indented when amount is entered. Do not indent manually.)

Date.
Account Titles and Explanation
Debit
Credit
July 31.
enter an account title to record electronic funds transfer received by bank
 

 

 
 
enter an account title to record electronic funds transfer received by bank
 

 

 
  (To record electronic funds transfer received by bank)    
31.
enter an account title To record NSF check
 

 

 
 
enter an account title To record NSF check
 

 

 
 
(To record NSF check)
   
31.
enter an account title for the adjusting entry to correct error in recording check
 
 

 
 
enter an account title for the adjusting entry to correct error in recording check
 

 

 
  (To correct error in recording check)    
31.
enter an account title to record bank service charge
 

 

 
  ente
 

 

 
 
(To
check_circle

Expert Answer

Step 1

Prepare bank reconciliation statement as...

help_outline

Image Transcriptionclose

Carla Vista Co. Bank Reconciliation For the Month Ended July 31, 2022 Cash balance per bank statement $7,885.80 Add: Deposit in transit $1,394.30 $9,280.10 Less:Outstanding checks $2.046.10 Adjusted cash balance per bank $7.234.00 Cash balance per books $6,335.00 Add: Electronic fund transfer received $1,715.00 $8,050.00 Less: NSF check $770.00 Bank service charge $19.00 $27.00 $816.00 Error in recording check no. 2480 $7.234.00 Adjusted cash balance per books

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Accounting

Bank Reconciliation

Related Accounting Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Julia currently is considering the purchase of some land to be held as an investment. She and the se...

A: Investment refers to putting the money into the purchase of a fixed asset, property or stock for ear...

question_answer

Q: Uses of managerial accounting in a service company Priceline.com allows customers to bid on hotel ro...

A: Managerial Accounting in the service industry:The company providing services to the society, need to...

question_answer

Q: Question 3 Wario Widgets uses a perpetual inventory system and it uses the FIFO (First-In, First-Out...

A: FIFO: In First-in-First-Out method, items purchased initially are sold first. So, the value of the e...

question_answer

Q: 3 Allied made its first and only purchase of inventory for the period on May 3 for 2,000 units at a ...

A: Prepare journal entry for May 15 transaction.

question_answer

Q: Q5

A: Bond premium: Bond discount is the amount by which the selling price (or issue price or market price...

question_answer

Q: BE 20-1 High-Low Method 1The manufacturing costs of Rosenthal Industries for the first three months...

A: High low method is used in accounting to separate the variable cost & fixed cost from limited da...

question_answer

Q: conduct horizontal and vertical analyses for the balance sheet and income statement accounts and rep...

A: 1) Prepare the horizontal analysis to analyze the changes in Starbucks’ fixed assets, intangible ass...

question_answer

Q: Current Attempt in Progress Kiner Co. computed an overhead rate for mnachining costs ($680000) of $5...

A: Compute machining cost assigned to Cape product using activity-based costing as shown below:

question_answer

Q: Casilda Company uses the aging approach to estimate bad debt expense. The ending balance of each acc...

A: In case of a credit sale, the customer is given an option to make payment for the sale within a spec...