Part Four Instructions

In this part of the practice set, the student will prepare a Bank Reconciliation for the month of January. Start by using the ending balance in your cash account for the cash for your books and the ending balance on the bank statement for the bank balance.

Requirements

Make sure you have corrected any errors on your journal and adjusting journal entries and have the correct balance for the cash account in your T$-$Account before starting the Bank Reconciliation. Please use the correct balance in the cash account to start on the book side of the reconciliation.

Bank Reconciliation: Using the cash balance per books and the bank statement, prepare a bank reconciliation. A template you can use to create a Bank Reconciliation is located below.

Record Bank Reconciliation Adjustments: After you have prepared the bank reconciliation you must make any adjusting journal entries to your cash account by entering them in the general journal of the practice set so that the general ledger cash account agrees with the Bank Reconciliation.

Once you finish the Bank Reconciliation follow the instructions below:

Step $1$: Enter the journal entries into the Excel Template spreadsheet and when completed print it out. Save your completed template to your computer where you can access it later to upload.

Step $2$: Use the Excel Template spreadsheet to answer the questions in Blackboard for the corresponding week in the content folder.

Step $3$: Once you complete entering information into Blackboard, upload the template spreadsheet into Blackboard by clicking on the navigation pane then clicking on Practice Set.

Bank Reconciliation Template

Wells Fargo Bank Balance

Ending Cash Balance

Deposits in Transit

Outstanding Checks

Adjustments or Errors $+/-$

Reconciled Balance

"Carla's Candles"

Ending Cash Balance

Adjustments or Errors $+/-$

Reconciled Balance

Bank Statement

Wells Fargo Bank

Page $1$

PO Box $12345$

El Paso, Texas $79902$

Carla's Candles, Inc.

$123$ Main Avenue

El Paso, Texas $79945$

WELLS FARGO BANK STATEMENT

Carla's Candles, Inc.

$\backslash$table$[[$Balance$,$ beginning,$\frac{01}{01}\frac{?}{2024},$$$0$