Question

Problem 7-03A (Part Level Submission) On July 31, 2022, Sandhill Co. had a cash balance per...

Problem 7-03A (Part Level Submission)

On July 31, 2022, Sandhill Co. had a cash balance per books of $6,285.00. The statement from Dakota State Bank on that date showed a balance of $7,835.80. A comparison of the bank statement with the Cash account revealed the following facts.
1. The bank service charge for July was $17.00.
2. The bank collected $1,665.00 from a customer for Sandhill Co. through electronic funds transfer.
3. The July 31 receipts of $1,346.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 $384.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $348.00.
5. Checks outstanding on July 31 totaled $2,005.10.
6. On July 31, the bank statement showed an NSF charge of $720.00 for a check received by the company from W. Krueger, a customer, on account.

(a)

Prepare the bank reconciliation as of July 31. (List items that increase balance as per bank & books first.)
SANDHILL CO.
Bank Reconciliation

choose the accounting period

For the Year Ended July 31, 2022For the Month Ended July 31, 2022July 31, 2022

select an opening name for section one

Error in recording check No. 2480Electronic funds transfer receivedBank service chargeDeposits in transitOutstanding checksCash balance per bank statementNSF checkAdjusted cash balance per bank

$enter a dollar amount
select between addition and deduction

AddLess

:
select a reconciling item

Error in recording check No. 2480Bank service chargeOutstanding checksElectronic funds transfer receivedNSF checkCash balance per bank statementAdjusted cash balance per bankDeposits in transit

enter a dollar amount
enter a subtotal of the two previous amounts
select between addition and deduction

AddLess

:
select a reconciling item

NSF checkOutstanding checksElectronic funds transfer receivedError in recording check No. 2480Deposits in transitBank service chargeCash balance per bank statementAdjusted cash balance per bank

enter a dollar amount
select a closing name for section one

Deposits in transitBank service chargeOutstanding checksAdjusted cash balance per bankElectronic funds transfer receivedCash balance per bank statementNSF checkError in recording check No. 2480

$enter a total amount for the first section
select an opening name for section two

Cash balance per booksError in recording check No. 2480Electronic funds transfer receivedBank service chargeAdjusted cash balance per booksNSF checkDeposits in transitOutstanding checks

$enter a dollar amount
select between addition and deduction

AddLess

:
select a reconciling item

NSF checkBank service chargeOutstanding checksElectronic funds transfer receivedError in recording check No. 2480Adjusted cash balance per booksCash 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

    NSF check    Deposits in transit    Cash balance per books    Adjusted cash balance per books    Error in recording check No. 2480    Bank service charge    Outstanding checks    Electronic funds transfer received    

$enter a dollar amount
select a reconciling item

    Bank service charge    Electronic funds transfer received    Outstanding checks    Cash balance per books    Deposits in transit    NSF check    Error in recording check No. 2480    Adjusted cash balance per books    

enter a dollar amount
select a reconciling item

    Error in recording check No. 2480    Deposits in transit    Adjusted cash balance per books    Outstanding checks    Electronic funds transfer received    NSF check    Bank service charge    Cash balance per books    

enter a dollar amount
enter a subtotal of the three previous amounts
select a closing name for section two

Error in recording check No. 2480Bank service chargeCash balance per booksDeposits in transitOutstanding checksElectronic funds transfer receivedNSF checkAdjusted cash balance per books

$enter a total amount for the second section

Homework Answers

Answer #1
Sandhill Co.
Bank Reconciliation Statement
Jul-31
Unadjusted bank balance    7,835.80
Add: Deposit in Transit    1,346.30
   9,182.10
Less: Outstanding checks    2,005.10
Adjusted bank Balance    7,177.00
Unadjusted cash balance    6,285.00
Add: EFT Collection    1,665.00
   7,950.00
Less:
NSF Check          720.00
Error in check 2480            36.00
Bank Service Charge            17.00
      773.00
Adjusted Cash Balance    7,177.00
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Problem 7-03A On July 31, 2022, Sunland Company had a cash balance per books of $6,330.00....
Problem 7-03A On July 31, 2022, Sunland Company had a cash balance per books of $6,330.00. The statement from Dakota State Bank on that date showed a balance of $7,880.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $22.00. 2. The bank collected $1,710.00 from a customer for Sunland Company through electronic funds transfer. 3. The July 31 receipts of $1,386.30 were not included in the...
Exercise 7-11 (Part Level Submission) The following information pertains to Sandhill Company. 1. Cash balance per...
Exercise 7-11 (Part Level Submission) The following information pertains to Sandhill Company. 1. Cash balance per bank, July 31, $10,614. 2. July bank service charge not recorded by the depositor $61. 3. Cash balance per books, July 31, $10,736. 4. Deposits in transit, July 31, $4,331. 5. $2,440 collected for Sandhill Company in July by the bank through electronic funds transfer. The accounts receivable collection has not been recorded by Sandhill Company. 6. Outstanding checks, July 31, $1,830. (a) Prepare...
On July 31, 2022, Blossom Company had a cash balance per books of $6,295.00. The statement...
On July 31, 2022, Blossom Company had a cash balance per books of $6,295.00. The statement from Dakota State Bank on that date showed a balance of $7,845.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $24.00. 2. The bank collected $1,675.00 from a customer for Blossom Company through electronic funds transfer. 3. The July 31 receipts of $1,349.30 were not included in the bank deposits...
The following information pertains to Carla Vista Company. 1. Cash balance per bank, July 31, $7,738....
The following information pertains to Carla Vista Company. 1. Cash balance per bank, July 31, $7,738. 2. July bank service charge not recorded by the depositor $48. 3. Cash balance per books, July 31, $7,774. 4. Deposits in transit, July 31, $3,110. 5. $2,426 collected for Carla Vista Company in July by the bank through electronic funds transfer. The collection has not been recorded by Carla Vista Company. 6. Outstanding checks, July 31, $696. (a) Prepare a bank reconciliation at...
The following information pertains to Crane Company. 1. Cash balance per bank, July 31, $7,938. 2....
The following information pertains to Crane Company. 1. Cash balance per bank, July 31, $7,938. 2. July bank service charge not recorded by the depositor $52. 3. Cash balance per books, July 31, $7,974. 4. Deposits in transit, July 31, $3,310. 5. $2,626 collected for Crane Company in July by the bank through electronic funds transfer. The collection has not been recorded by Crane Company. 6. Outstanding checks, July 31, $700. (a) Your Answer Correct Answer Partially correct answer iconYour...
The following information pertains to Carla Vista Company. 1. Cash balance per bank, July 31, $7,738....
The following information pertains to Carla Vista Company. 1. Cash balance per bank, July 31, $7,738. 2. July bank service charge not recorded by the depositor $48. 3. Cash balance per books, July 31, $7,774. 4. Deposits in transit, July 31, $3,110. 5. $2,426 collected for Carla Vista Company in July by the bank through electronic funds transfer. The collection has not been recorded by Carla Vista Company. 6. Outstanding checks, July 31, $696. (a) Your Answer Correct Answer Partially...
Problem 7-4A On July 31, 2019, Keeds Company had a cash balance per books of $6,140.00....
Problem 7-4A On July 31, 2019, Keeds Company had a cash balance per books of $6,140.00. The statement from Dakota State Bank on that date showed a balance of $7,690.80. A comparison of the bank statement with the Cash account revealed the following facts. 1. The bank service charge for July was $25.00. 2. The bank collected $1,520 for Keeds Company through electronic funds transfer. 3. The July 31 receipts of $1,193.30 were not included in the bank deposits for...
Angela Lansbury Company deposits all receipts and makes all payments by check. The following information is...
Angela Lansbury Company deposits all receipts and makes all payments by check. The following information is available from the cash records. June 30 Bank Reconciliation Balance per bank $7,000 Add: Deposits in transit 1,540 Deduct: Outstanding checks (2,000 ) Balance per books $6,540 Month of July Results Per Bank Per Books Balance July 31 $8,650 $9,250 July deposits 5,000 5,810 July checks 4,000 3,100 July note collected (not included in July deposits) 1,000 July bank service charge 15 July NSF...
Exercise 7-15 On August 31, 2021, Sheridan Company had a cash balance per its books of...
Exercise 7-15 On August 31, 2021, Sheridan Company had a cash balance per its books of $26,660. The bank statement on that date showed a balance of $17,760. A comparison of the bank statement with the Cash account revealed the following. 1. The August 31 deposit of $17,050 was not included on the August bank statement. 2. The bank statement shows that Sheridan received EFT deposits from customers on account totalling $2,420 in August. Sheridan has not recorded any of...
Lisa Lansbury Company deposits all receipts and makes all payments by check. The following information is...
Lisa Lansbury Company deposits all receipts and makes all payments by check. The following information is available from the cash records. June 30 Bank Reconciliation Balance per bank $22,400 Add: Deposits in transit 4,928 Deduct: Outstanding checks (6,400 ) Balance per books $20,928 Month of July Results Per Bank Per Books Balance July 31 $27,680 $29,600 July deposits 14,400 18,592 July checks 12,800 9,920 July note collected (not included in July deposits) 4,800 July bank service charge 48 July NSF...