Preparing a bank reconciliation

Hardy Photography’s checkbook lists the following:

Date Check No. Item Check Deposit Balance

Nov. 1 \( 500

4 622 Quick Mailing \) 45 455

9 Service Revenue \( 135 590

13 623 Photo Supplies 85 505

14 624 Utilities 45 460

18 625 Cash 50 410

26 626 Office Supplies 110 300

28 627 Upstate Realty Co. 290 10

30 Service Revenue 1,235 1,245

Hardy’s November bank statement shows the following:

Learning Objective 6

1. Adjusted Balance \)1,137

Balance

Deposits

Checks: No. Amount

622 \( 45

623 85

624 105*

625 50

Other charges:

Printed checks

Service charge

Balance

*This is the correct amount for check number 624.

\) 500

135

(285)

(48)

$ 302

23

25

Requirements

1. Prepare Hardy Photography’s bank reconciliation at November 30, 2018.

2. How much cash does Hardy actually have on November 30, 2018?

3. Journalize any transactions required from the bank reconciliation.

The bank reconciliation statement is the statement prepared to remove the errors of bank balance and cash balance.

In the bank reconciliation statement, there are two sides one is the bank, and the second is the book side. On the bankside, the opening balance of the bank account is entered. After this, the amount of deposit transit is added to the bank balance, and the number of outstanding checks is deducted.

The second side of the bank reconciliation statement is started with the opening balance of the company’s book. After this, the amount of bank collection and interest revenue is added to the balance, and the amount of service charge is deducted from the book side balance.

In this, the error check is subtracted because the wrong amount of the check is recorded in the book balance.

On November 30, 2018, their cash balance was $1,137.

The following entries are passed for the payment of utilities expense, printed check expense and service charge.