accounting

Following is the September 30, 20X4 bank reconciliation for the Quiet Moose Lodge. You are also provided with the October check register and bank statement. Utilize this information to prepare October's bank rec- onciliation and related adjusting entry. You may assume that any discrepancies between the check register and bank statement relate to recording errors in the accounts of the Quiet Moose, and not the bank.

Ending balance per bank statement $18,344.07

Add: Deposits in transit 2,505.55

Deduct: Outstanding checks

#3444 $ 175.00

#3446 1,908.09 (2,083.09)

Correct cash balance $18,766.53

Ending balance per company records $18,696.53

Add: Interest earnings 80.00

Deduct: Service charges (10.00)

Correct cash balance $18,766.53

Spreadsheet fx

A B C D E F 1 DATE PART Y REF # CHECK DEPOSIT Balance 2 3 10-01-X4 BALANCE $18,766.53

4 10-02-X4 Gomez 3448 $ 145.99 18,620.54

5 10-05-X4 Deposit $ 3,400.00 22,020.54

6 10-07-X4 Bryers 3449 387.97 21,632.57

7 10-07-X4 Morton 3450 1,204.67 20,427.90

8 10-07-X4 Lee 3451 4,664.50 15,763.40

9 10-10-X4 Morici 3452 43.23 15,720.17

1 0 10-10-X4 LaCorx 3453 2,990.44 12,729.73

1 1 10-11-X4 Benson 3454 1,100.31 11,629.42

1 2 10-12-X4 Void 3455 11,629.42

1 3 10-13-X4 Morgan 3456 695.77 10,933.65

1 4 10-13-X4 Russell 3457 788.87 10,144.78

1 5 10-14-X4 Deposit 3,476.88 13,621.66

1 6 10-17-X4 Lowen 3458 3,664.34 9,957.32

1 7 10-19-X4 Post Office 3459 45.45 9,911.87

1 8 10-20-X4 Nguen 3460 677.21 9,234.66

1 9 10-30-X4 Behn 3461 499.00 8,735.66

2 0 10-31-X4 Deposit 8,131.21 16,866.87

2 1 $16,907.75 $15,008.09

Comprehensive bank reconciliation with business papers I-06.03

Mountain Home Bank

121 Main Street

P.O. Box 5566

Statement date: October 1, 20X4 through October 31, 20X4

Statement for: Quiet Moose Lodge

13 River Street

Patawa Township

Account # 474784

CHECKING SUMMARY

Previous statement balance on 09-30-X4 18,344.07

Total of 5 deposits + 19,339.09

Total of 14 withdrawals - 14,887.45

Interest earnings + 65.66

Service charges - 35.00

New balance 22,826.37

CHECKS AND OTHER DEBITS

Check Date Paid Amount Check Date Paid Amount

3446 3-Oct 1908.09 3454 12-Oct 1100.31

*3448* 5-Oct 145.99 *3456* 13-Oct 695.77

3449 7-Oct 387.97 3457 14-Oct 788.87

3450 7-Oct 1204.67 3458 18-Oct 3664.34

*3452* 10-Oct 43.23 3459 20-Oct 54.45

3453 11-Oct 2990.44 3460 21-Oct 677.21

Electronic funds transfer - Patawa Water Co-op 25-Oct 237.34

NSF returned check- maker Stacey 28-Oct 988.77

NSF fee 28-Oct 25.00

Monthly service fee 31-Oct 10.00

DEPOSITS AND OTHER CREDITS

Date Posted Amount

Customer deposit 1-Oct 2505.55

Customer deposit 5-Oct 3400.00

Collection item -- note receivable ($6500 + interest) 11-Oct 6774.33

Customer deposit 14-Oct 3476.88

Credit card sales posting 28-Oct 3182.33

Interest earnings 31-Oct 65.66