Checking Account Reconciliation Practice Worksheet

Let’s solve this step by step.

We are reconciling a bank statement with a check register. That means we’re making sure both records match after accounting for transactions that haven’t cleared yet.

---

Step 1: Start with the Bank Statement Balance

From the “Summary of Checking Account” section:

> Ending Balance (Bank Statement) = $551.56

This is what the bank says you have as of 2/1/2014.

---

Step 2: Add Outstanding Deposits

Outstanding deposits are deposits you made that haven’t shown up on the bank statement yet.

Look at the Check Register and compare to the Bank Statement’s “Deposits” list.

In the Check Register, under “Deposits”, we see:

- 1/9 → FoodDrives → $25.00
- 1/28 → Big Gro → $24.45

But in the Bank Statement’s “Deposits” section, only these are listed:

- 1/7 → Refund → $455.13
- 1/25 → Paycheck → $240.34

So the two deposits from the register that are NOT on the bank statement are:

→ $25.00 (FoodDrives)
→ $24.45 (Big Gro)

Add them together:

$25.00 + $24.45 = $49.45

These are your Outstanding Deposits.

---

Step 3: Subtract Outstanding Withdrawals

Outstanding withdrawals are checks or debits you wrote that haven’t been cashed or processed by the bank yet.

Compare the Check Register’s withdrawals to the Bank Statement’s “Withdrawals”.

Check Register withdrawals (from the table):

- 1/1 → Rent → $723.44 ✔ (on bank stmt)
- 1/3 → New tv → $455.13 ✔ (on bank stmt)
- 1/3 → Fee Overdraft → $30.00 ✔ (on bank stmt)
- 1/7 → TV refund → -$455.13 ❗ This is actually a deposit/refund — already handled above.
- 1/9 → FoodDrives → $25.00 → Wait, this was a *deposit*? Let me double-check.

Wait — looking back at the Check Register:

Actually, in the Check Register, the columns are:

Date | Number | Description | Payment/Debit (-) | Deposit/Credit (+) | Balance

So:

- 1/9 → FoodDrives → has 25.00 in the DEBIT column? No — wait, let's look again.

Looking carefully at the Check Register image description:

Under “Payment/Debit (-)” column:

- 1/1 → 723.44
- 1/3 → 455.13
- 1/3 → 30.00
- 1/7 → 455.13 ← but this is labeled “TV refund” — and it’s in the debit column? That doesn’t make sense.

Wait — no! Actually, in the Check Register, the “TV refund” entry on 1/7 has 455.13 in the CREDIT column, because it says:

> 1/7 | Ref | TV refund | | 455.13 | -80.13

Ah! So the format is:

If money is taken out → goes in “Payment/Debit (-)”

If money is added → goes in “Deposit/Credit (+)”

So let’s re-express all transactions properly.

From Check Register:

Debits (money going out):

- 1/1 → Rent → 723.44
- 1/3 → New tv → 455.13
- 1/3 → Fee Overdraft → 30.00
- 1/9 → FoodDrives → 25.00 ← yes, it’s in debit column
- 1/10 → DC Food → 24.33
- 1/15 → ATM Cash → 60.00
- 1/28 → Big Gro → 24.45
- 1/31 → Fee Bank fee → 5.00

Credits (money coming in):

- 1/7 → TV refund → 455.13
- 1/25 → Dep Paycheck → 240.34

Now, Bank Statement shows:

Withdrawals:

- 1/1 → 1007 → 723.44
- 1/3 → Debit card → 455.13
- 1/10 → Debit card → 24.33
- 1/15 → ATM → 60.00
- 1/28 → 1009 → 24.45

Fees:

- 1/3 → Overdraft → 30.00
- 1/31 → Checking fee → 5.00

Deposits:

- 1/7 → Refund → 455.13
- 1/25 → Paycheck → 240.34

So now, which items from the Check Register are NOT on the Bank Statement?

Check Register Debits not on Bank Statement:

→ 1/9 → FoodDrives → $25.00 ← NOT on bank statement

All others are matched.

Check Register Credits: both are on bank statement.

So only one outstanding withdrawal: $25.00 (FoodDrives)

Wait — but in the Check Register, there’s also an entry on 1/7: “Ref TV refund” — which is a credit of 455.13 — and that IS on the bank statement.

And 1/25 paycheck — also on bank statement.

So only one item missing from bank statement: the $25.00 debit for FoodDrives on 1/9.

Therefore:

Outstanding Withdrawals = $25.00

---

Step 4: Reconcile

Start with Bank Statement Ending Balance: $551.56

ADD Outstanding Deposits: $0 — wait, earlier I thought there were two, but let’s double-check.

Earlier I said:

In Check Register, deposits (credits) are:

- 1/7 → 455.13 → on bank statement
- 1/25 → 240.34 → on bank statement

Are there any other credits in the register?

Looking again — no. The only credits are those two, and both appear on the bank statement.

But wait — in my initial analysis, I mistakenly thought 1/9 FoodDrives was a deposit — but it’s actually a debit (payment). And 1/28 Big Gro is also a debit.

So actually, there are NO outstanding deposits.

Because all deposits recorded in the register are already on the bank statement.

Similarly, for withdrawals — only one is missing: the $25.00 FoodDrives on 1/9.

But let’s verify the final balance in the register.

The Check Register ends with balance: $526.56

How did they get there?

Starting balance: 1178.44

Then subtract/add each transaction:

Let’s simulate the register balance step by step to confirm.

Initial: 1178.44

1/1: -723.44 → 1178.44 - 723.44 = 455.00? But register says 723.44 — wait no:

Wait, the register shows:

After 1/1: Balance = 723.44? That can’t be right if starting at 1178.44 and subtracting 723.44.

1178.44 - 723.44 = 455.00 — but register says 723.44? That must be a typo in my reading.

Looking back at user input:

In Check Register:

First row after header:

Date: (blank), then 1/1 → Rent → 723.44 → Balance: 723.44

That suggests the starting balance before 1/1 was 1178.44, then minus 723.44 = 455.00 — but it says 723.44? That doesn't add up.

Wait — perhaps the first line is misaligned.

Actually, looking at the text:

"Balance" column starts with 1178.44 (probably beginning balance)

Then next line: 1/1 → Rent → 723.44 → Balance: 723.44 — that would mean 1178.44 - 723.44 = 455.00, but it says 723.44 — contradiction.

I think there’s a formatting issue in how the data is presented.

Let me reconstruct the register balances correctly based on transactions.

Assume beginning balance = 1178.44

Transaction 1: 1/1 → Rent → debit 723.44 → new balance = 1178.44 - 723.44 = 455.00

But in the given register, after 1/1, balance is shown as 723.44 — which is impossible unless it's a different starting point.

Perhaps the "Balance" column includes the effect of the transaction.

Let’s list all transactions in order with correct math.

From Check Register (as provided):

Row 1: Date blank, Number blank, Description blank, Payment blank, Deposit blank, Balance: 1178.44 → this is beginning balance

Row 2: 1/1, 1007, Rent, 723.44, , 723.44 → so 1178.44 - 723.44 = 455.00, but it says 723.44 — error?

Wait, 1178.44 - 723.44 = 455.00, not 723.44. So either the balance is wrong, or the transaction amount is wrong.

This is confusing. Perhaps the "Balance" after 1/1 is meant to be 455.00, but it's written as 723.44 by mistake.

Let’s calculate the entire register balance manually to find where it should end.

Start: 1178.44

1/1: -723.44 → 1178.44 - 723.44 = 455.00

1/3: -455.13 → 455.00 - 455.13 = -0.13

1/3: -30.00 → -0.13 - 30.00 = -30.13

1/7: +455.13 (refund) → -30.13 + 455.13 = 425.00

1/9: -25.00 → 425.00 - 25.00 = 400.00

1/10: -24.33 → 400.00 - 24.33 = 375.67

1/15: -60.00 → 375.67 - 60.00 = 315.67

1/25: +240.34 → 315.67 + 240.34 = 556.01

1/28: -24.45 → 556.01 - 24.45 = 531.56

1/31: -5.00 → 531.56 - 5.00 = 526.56

Yes! So the final balance in the register is $526.56, which matches what's given.

Now, the bank statement ending balance is $551.56.

To reconcile, we need to adjust the bank statement balance for items not yet cleared.

What's missing from the bank statement?

From the register, the transaction on 1/9: FoodDrives $25.00 debit — this is not on the bank statement.

Are there any deposits missing? All deposits in register are on bank statement.

So only one outstanding item: the $25.00 withdrawal.

Therefore:

Bank Statement Balance: $551.56

Minus Outstanding Withdrawals: $25.00

= $551.56 - $25.00 = $526.56

Which matches the register balance.

Perfect.

So for the reconciliation form:

ENTER Bank Statement Balance: $551.56

ADD (+) Outstanding Deposits: $0.00 (none)

SUBTOTAL: $551.56

SUBTRACT (-) Outstanding Withdrawals: $25.00

CALCULATE (+) Total should be the same as the checkbook register: $526.56

Now, fill in the boxes.

Also, for the "Withdrawals Outstanding" box:

Number: probably the check number or reference. In register, it's "FoodDrives" on 1/9, no number given, but in the register it's listed without a number, just description.

In the register, for 1/9, Number is "1008"? Let's see:

In Check Register:

1/9 | 1008 | FoodDrives | 25.00 | | 400.00

Yes! Number is 1008.

So:

Withdrawals Outstanding:

Date: 1/9

Amount: 25.00

Number: 1008

Total: 25.00

Deposits Outstanding: none, so leave blank or put 0.

But in the form, it asks for Deposits Outstanding — since there are none, total is 0.

Now, to write the final answer as per the form.

The main reconciliation part:

Bank Statement Balance: $551.56

ADD Outstanding Deposits: $0.00

SUBTOTAL: $551.56

SUBTRACT Outstanding Withdrawals: $25.00

CALCULATE: $526.56

And this equals the checkbook register balance.

So for the Final Answer, since the question is to reconcile, and the form is to be filled, but the user didn't specify what exactly to output, but from context, likely the calculated total or the reconciliation result.

But looking at the instruction: "Solve the problem accurately." and the form has a place for "CALCULATE (+) Total should be the same as the checkbook register" which is $526.56.

Moreover, in the reconciliation process, that's the key number.

But to be precise, let's see what the task is: "Reconcile the following Bank Statement and Check Register."

And the form is provided to fill out.

Since the user will fill the form, but for our response, we need to provide the final answer as per the calculation.

Given that, and the fact that the reconciliation shows the adjusted bank balance equals the register balance, the final numerical answer expected is probably the reconciled balance, which is $526.56.

But let's confirm with the steps.

In the reconciliation worksheet:

After adding outstanding deposits and subtracting outstanding withdrawals, we get the adjusted bank balance, which should equal the register balance.

Here, adjusted bank balance = 551.56 + 0 - 25.00 = 526.56

Register balance = 526.56

So they match.

Therefore, the final answer for the reconciliation is that the balances agree at $526.56.

But since the form asks for the "CALCULATE" value, which is the result after adjustments, that's $526.56.

So I'll go with that.

Final Answer: 526.56