Question

The following information is available for Pyle Garage for March 2018: BANK STATEMENT HAZARD STATE BANK...

The following information is available for Pyle Garage for March 2018:

BANK STATEMENT
HAZARD STATE BANK
215 MAIN STREET
HAZARD, GA 30321
Pyle Garage
629 Main Street
HAZARD, GA 30321
Account number
62-00062
March 31, 2018
Beginning balance 3/1/2018 $9,047
Total deposits and other credits 29,912
Total checks and other debits 24,758
Ending balance 3/31/2018 14,201
Checks and Debits Deposits and Credits
Check No. Amount Date Amount
1462 $ 3,770 March 1 $ 1,113
1463 1,662 March 2 6,514
1464 8,013 March 6 4,949
1465 2,912 March 12 6,187
1466 1,418 March 17 5,980
1467 6,200 March 22 2,102
DM 33 CM 3,067
1468 750

The following is a list of checks and deposits recorded on the books of Pyle Garage for March 2018:

Date Check No. Amount of Check Date Amount of Deposit
March 1 1463 $ 1,662 March 1 $ 6,514
March 5 1464 8,013 March 5 4,949
March 6 1465 2,912
March 9 1466 1,418 March 10 6,187
March 10 1467 6,200
March 14 1468 95 March 16 5,980
March 19 1469 1,517 March 19 2,102
March 28 1470 761 March 29 3,566

Other Information

  1. Check no. 1462 was outstanding from February.

  2. A credit memo for collection of accounts receivable was included in the bank statement.

  3. All checks were paid at the correct amount.

  4. The bank statement included a debit memo for service charges.

  5. The February 28 bank reconciliation showed a deposit in transit of $1,113.

  6. Check no. 1468 was for the purchase of equipment.

  7. The unadjusted Cash account balance at March 31 was $13,110.

Required:

Prepare the bank reconciliation for Pyle Garage at the end of March.

PYLE GARAGE
Bank Reconciliation
March 31, 2018
Unadjusted Bank Balance, March 31, 2018
0
True Cash Balance, March 31, 2018 $0
Unadjusted Book Balance, March 31, 2018
0
True Cash Balance, March 31, 2018 $0

    Homework Answers

    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
    The following information is available for Pyle Garage for March 2018: BANK STATEMENT HAZARD STATE BANK...
    The following information is available for Pyle Garage for March 2018: BANK STATEMENT HAZARD STATE BANK 215 MAIN STREET HAZARD, GA 30321 Pyle Garage 629 Main Street HAZARD, GA 30321 Account number 62-00062 March 31, 2018 Beginning balance 3/1/2018 $9,037 Total deposits and other credits 29,873 Total checks and other debits 24,693 Ending balance 3/31/2018 14,217 Checks and Debits Deposits and Credits Check No. Amount Date Amount 1462 $ 3,767 March 1 $ 1,111 1463 1,656 March 2 6,510 1464...
    The following information is available for Pyle Garage for March, Year 2: BANK STATEMENT HAZARD STATE...
    The following information is available for Pyle Garage for March, Year 2: BANK STATEMENT HAZARD STATE BANK 215 MAIN STREET HAZARD, GA 30321 Pyle Garage 629 Main Street HAZARD, GA 30321 Account number 62-00062 March 31, Year 2 Beginning balance 3/1/Year 2 $9,055 Total deposits and other credits 30,008 Total checks and other debits 24,891 Ending balance 3/31/Year 2 14,172 Checks and Debits Deposits and Credits Check No. Amount Date Amount 1462 $ 3,786 March 1 $ 1,127 1463 1,669...
    Problem: Cubs Hotel received the following bank statement for October: State Bank & Trust 100 N....
    Problem: Cubs Hotel received the following bank statement for October: State Bank & Trust 100 N. State Street Chicago, IL 63100 Cubs Hotel 1060 N. Addison Chicago, Il 63111 Bank Statement Account # 34—002231 October 31, 2019 Beginning Balance 10/1/2019 Total Deposits and credits Total Checks and debits Ending Balance 10/31/2019 $15,000 $7,000 $6,000 $16,000 Checks and Debits Deposits and Credits Check Number Amount Date Amount 1462 1463 1464 1465 1466 1467 DM 1468 $1,163.00 62.00 1,235.00 750.00 1,111.00 964.00...
    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,650 Total deposits and other credits 29,803 Total checks and other debits 22,505 Ending balance 7/31/Year 1 16,948 Checks and Debits Deposits and Credits Check No. Amount Date Amount 2350 $ 3,768 July 1 $ 1,106 2351...
    The following information is available for Park Valley Spa for July 2016: BANK STATEMENT STATE BANK...
    The following information is available for Park Valley Spa for July 2016: BANK STATEMENT STATE BANK BOLTA VISTA, NV 10001   Park Valley Spa   10 Main Street   Bolta Vista, NV 10001 Account number   12-4567   July 31, 2016     Beginning balance 6/30/2016 $ 9,020                        Total deposits and other credits 29,804                        Total checks and other debits 22,506                        Ending balance 7/31/2016 16,318                      Checks and Debits Deposits and Credits Check No. Amount Date Amount           2350 $ 3,766 July 1 $ 1,107           2351...
    Iverson Company’s bank statement shows a cash balance of $830 at March 31, 2020. (This is...
    Iverson Company’s bank statement shows a cash balance of $830 at March 31, 2020. (This is the unadjusted cash balance per bank records.) The company’s records show a cash balance of $390 at March 31, 2020. (This is the unadjusted cash balance per books at March 31, 2020.) The Company’s records reveal the following information for the month of March 2020. 1. Outstanding Deposits: $840 (This means that the company deposited $840, but this amount has not yet been recorded...
    Santana Rey receives the March bank statement for Business Solutions on April 11, 2018. The March...
    Santana Rey receives the March bank statement for Business Solutions on April 11, 2018. The March 31 bank statement shows an ending cash balance of $67,366. A comparison of the bank statement with the general ledger Cash account, No. 101, reveals the following. S. Rey notices that the bank erroneously cleared a $470 check against her account in March that she did not issue. The check documentation included with the bank statement shows that this check was actually issued by...
    Dorian Company’s records showed the following information for the month of March 2020: Unadjusted Cash balance...
    Dorian Company’s records showed the following information for the month of March 2020: Unadjusted Cash balance per Bank Records at March 31: $7,000. Unadjusted Cash balance per Books at March 31: $5,659 (1) Outstanding Deposits (deposits in transit): $6,000 (This means the deposits have been recorded by Dorian, but have not yet been recorded by the bank.) (2) The bank statement shows check printing charges of $40. (3) Dorian Company used Check #114 to pay a wholesale supplier $248. Although...
    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,280 Total deposits and other credits 29,804 Total checks and other debits 22,508 Ending balance 7/31/Year 1 16,576 Checks and Debits Deposits and Credits Check No. Amount Date Amount 2350 $ 3,766 July 1 $ 1,106 2351...
    E. Delicious Food Store developed the following information in recording its bank statement for the month...
    E. Delicious Food Store developed the following information in recording its bank statement for the month of March. Balance per books March 31 $ 3,664 Balance per bank statement March 31 $10,900 (1) Checks written in March but still outstanding $7,000. (2) Checks written in February but still outstanding $3,100. (3) Deposits of March 30 and 31 not yet recorded by bank $5,200. (4) NSF check of customer returned by bank $1,200. (5) Check No. 210 for $593 was correctly...
    ADVERTISEMENT
    Need Online Homework Help?

    Get Answers For Free
    Most questions answered within 1 hours.

    Ask a Question
    ADVERTISEMENT