You are auditing general cash for the Pittsburgh Supply Company for the fiscal year ended July 31, 2023. The client has not prepared the July 31 bank reconciliation. After a brief discussion with the owner, you agree to prepare the reconciliation, with assistance from one of Pittsburgh Supply’s clerks. You obtain the following information:

Additional information obtained is as follows: 

1. Checks clearing that were outstanding on June 30 totaled $2,411. 

2. Checks clearing that were recorded in the July disbursements journal totaled $21,120.

3. Deposits included $600 from June and $24,874 for July. 

4. A check for $1,130 cleared the bank but had not been recorded in the cash disbursements journal. It was for an acquisition of inventory. Pittsburgh Supply uses the periodic-inventory method. 

5. A check for $646 was charged to Pittsburgh Supply but had been written on a different company’s bank account. 

6. The bank charged Pittsburgh Supply’s account for a nonsufficient funds check totaling $412. The credit manager concluded that the customer intentionally closed its account and the owner left the city. The check was turned over to a collection agency. 

7. A note for $5,000, plus interest, was paid directly to the bank under an agreement signed four months ago. The note payable was recorded at $5,000 on Pittsburgh Supply’s books.

Required

a. Prepare a bank reconciliation that shows both the unadjusted and adjusted balance per books. 

b. Prepare all adjusting entries. 

c. What audit procedures would you use to verify each item in the bank reconciliation? 

d. What is the cash balance that should appear on the July 31, 2023, financial statements?

Transcribed Image Text:

Beginning balance 7/1/23 Deposits Cash receipts journal Checks cleared Cash disbursements journal July bank service charge Note paid directly NSF check Ending balance 7/31/23 General Ledger $6,400 26,874 (23,171) $10,103 Bank Statement $8,378 25,474 (25,307) (135) (5,200) (412) $ 2,798