Wildhorseis unable to reconcile the bank balance at January 31.Wildhorse's reconciliation is as follows.

Cash balance per bank$3,860.20

Add: NSF check540.00

Less: Bank service charge31.00

Adjusted balance per bank$4,369.20

Cash balance per books$4,175.20

Less: Deposits in transit680.00

Add: Outstanding checks936.00

Adjusted balance per books$4,431.20

Prepare a correct bank reconciliation.(List items that increase cash balance first. Reconcile cash balance per bank first. Round answers to 2 decimal places, e.g. 52.75.)

Wildhorse

Bank Reconciliation

choose the accounting period

For the Year Ended January 31

For the Month Ended January 31

January 31

select an opening name for section one

Outstanding checks

NSF check

Cash balance per bank statement

Adjusted cash balance per book

Deposits in transit

Bank service charge

Adjusted cash balance per bank

Cash balance per books

$

enter a dollar amount

select between addition and deduction

Less

Add

:select a reconciling item

Bank service charge

Outstanding checks

NSF check

Adjusted cash balance per book

Cash balance per books

Deposits in transit

Cash balance per bank statement

Adjusted cash balance per bank

enter a dollar amount

enter a subtotal of the two previous amounts

select between addition and deduction

Less

Add

:select a reconciling item

Deposits in transit

Cash balance per books

Cash balance per bank statement

Outstanding checks

Adjusted cash balance per bank

Bank service charge

NSF check

Adjusted cash balance per book

enter a dollar amount

select a closing name for section one

Cash balance per bank statement

Adjusted cash balance per bank

Cash balance per books

Outstanding checks

Deposits in transit

NSF check

Adjusted cash balance per book

Bank service charge

$

enter a total amount for section one

select an opening name for section two

Cash balance per books

Bank service charge

NSF check

Adjusted cash balance per bank

Adjusted cash balance per books

Outstanding checks

Deposits in transit

Cash balance per bank statement

$

enter a dollar amount

select between addition and deduction

Less

Add

:select a reconciling item

Bank service charge

Outstanding checks

Deposits in transit

Adjusted cash balance per books

Cash balance per bank statement

Adjusted cash balance per bank

NSF check

Cash balance per books

$

enter a dollar amount

select a reconciling item

Adjusted cash balance per books

Outstanding checks

NSF check

Adjusted cash balance per bank

Cash balance per books

Cash balance per bank statement

Bank service charge

Deposits in transit

enter a dollar amount

enter a subtotal of the two previous amounts

select a closing name for section two

Cash balance per books

Cash balance per bank statement

Bank service charge

NSF check

Adjusted cash balance per books

Deposits in transit

Outstanding checks

Adjusted cash balance per bank

$

enter a total amount for section two

eTextbook and Media

List of Accounts

Journalize the entries required by the reconciliation.(Credit account titles are automatically indented when amount is entered. Do not indent manually. Round answers to 2 decimal places, e.g. 52.75.)

No.

Account Titles and Explanation

Debit

Credit

1.enter an account title to record NSF check

enter a debit amount

enter a credit amount

enter an account title to record NSF check

enter a debit amount

enter a credit amount

(To record NSF check.)

2.enter an account title to record bank service charge

enter a debit amount

enter a credit amount

enter an account title to record bank service charge

enter a debit amount

enter a credit amount

(To record bank service charge.)