What is the Adjusted Trial Balance and How is it Created? - Free Printable

It looks like you've uploaded a partial accounting worksheet for December 31, 2010, and it includes the Trial Balance, Adjustments, and Adjusted Trial Balance columns. The task appears to be about understanding or completing the adjusting entries and their impact on the accounts.

Let’s analyze the information provided and explain the adjusting entries and how they affect the financial statements.

---

🔍 Understanding the Worksheet

The worksheet is used in the accounting cycle to:
1. Start with the unadjusted trial balance.
2. Record adjusting entries (a, b, c).
3. Compute the adjusted trial balance.
4. Prepare financial statements.

We are given:
- Adjustments: labeled as a, b, c
- Adjusted Trial Balance values already filled in
- We can infer the nature of each adjustment based on changes.

---

✔ Step-by-Step Analysis of Adjustments

#### 🔹 Adjustment a: Supplies
- Supplies (Asset):
- Trial Balance: $700 (Dr.)
- Adjusted: $200 (Dr.)
→ Decrease by $500 → So, $500 worth of supplies were used.
- Supplies Expense:
- Trial Balance: $0
- Adjusted: $500 (Dr.)
→ Recognized expense for supplies used.

✔ Adjustment Entry a:
```
Debit: Supplies Expense $500
Credit: Supplies $500
```
This records the consumption of supplies during the period.

---

#### 🔹 Adjustment b: Depreciation
- Accumulated Depreciation – Equipment:
- Trial Balance: $1,000 (Cr.)
- Adjusted: $2,000 (Cr.)
→ Increase by $1,000 → Depreciation expense recorded.
- Depreciation Expense:
- Trial Balance: $0
- Adjusted: $1,000 (Dr.)
→ Expense recognized.

✔ Adjustment Entry b:
```
Debit: Depreciation Expense $1,000
Credit: Accum. Depr. – Equip. $1,000
```
This records depreciation on equipment for the year.

---

#### 🔹 Adjustment c: Interest Payable
- Interest Payable (Liability):
- Trial Balance: $0
- Adjusted: $100 (Cr.)
→ Accrued interest not yet paid.
- Interest Expense:
- Trial Balance: $0
- Adjusted: $100 (Dr.)
→ Expense incurred but not yet paid.

✔ Adjustment Entry c:
```
Debit: Interest Expense $100
Credit: Interest Payable $100
```
This records accrued interest on the note payable.

---

📊 Summary of Adjusting Entries:

| Adjustment | Account Debited | Amount | Account Credited | Amount |
|-----------|--------------------------|--------|----------------------------|--------|
| a | Supplies Expense | $500 | Supplies | $500 |
| b | Depreciation Expense | $1,000 | Accum. Depr. – Equipment | $1,000 |
| c | Interest Expense | $100 | Interest Payable | $100 |

---

🧮 Impact on Financial Statements

#### 📈 Income Statement (for Year Ending Dec 31, 2010)
- Revenues: Service Revenue = $12,000
- Expenses:
- Rent Expense: $4,000
- Supplies Expense: $500
- Depreciation Expense: $1,000
- Interest Expense: $100
- Total Expenses = $5,600
- Net Income = $12,000 – $5,600 = $6,400

#### 🏦 Balance Sheet (as of Dec 31, 2010)
- Assets:
- Cash: $5,400
- Supplies: $200
- Equipment: $17,000
- Less: Accum. Depr. = $2,000
- Total Assets = $5,400 + $200 + ($17,000 – $2,000) = $20,600
- Liabilities:
- Accounts Payable: $200
- Interest Payable: $100
- Note Payable: $9,000
- Total Liabilities = $9,300
- Equity:
- Josie Smith, Capital: $6,000
- Add: Net Income: $6,400
- Less: Withdrawals: $1,000
- Ending Capital = $6,000 + $6,400 – $1,000 = $11,400
- Total Liabilities & Equity = $9,300 + $11,400 = $20,700

⚠️ Wait — Assets = $20,600, but Liabilities + Equity = $20,700 → Discrepancy?

Let’s double-check:

- Equipment: $17,000
- Accum. Depr.: $2,000 → Net Book Value = $15,000
- Cash: $5,400
- Supplies: $200
- Total Assets = $5,400 + $200 + $15,000 = $20,600

But equity should be:
- Beginning Capital: $6,000
- Add Net Income: $6,400 → $12,400
- Less Withdrawals: $1,000 → $11,400
- Liabilities: $9,300
- Total L&E = $9,300 + $11,400 = $20,700

→ Mismatch!

Wait — something’s wrong. Let's check the Capital account.

Looking at the Adjusted Trial Balance, "Josie Smith, Capital" is listed as $6,000 — same as unadjusted.

But net income is $6,400, and withdrawals are $1,000.

So, capital should increase by net income, minus withdrawals.

But the capital account hasn’t been updated yet.

👉 This means the worksheet only shows adjusted balances, but the capital account is still at beginning balance.

In a full set of financial statements:
- Statement of Owner's Equity would show:
- Beginning Capital: $6,000
- Add: Net Income: $6,400
- Less: Withdrawals: $1,000
- Ending Capital: $11,400

So the balance sheet should reflect $11,400 in capital.

But since the worksheet only adjusts accounts up to the adjusted trial balance, the capital account remains unchanged unless closed.

✔ Conclusion: The worksheet is incomplete for final reporting — closing entries are needed.

---

✔ Final Answer: What Was the Task?

Since the image shows an almost complete worksheet, the likely task was:

> Complete the adjusting entries and verify the adjusted trial balance.

And we have done that.

---

✔ Summary of Solution

1. Adjusting Entry a: Supplies used = $500 → Expense recognized.
2. Adjusting Entry b: Depreciation = $1,000 → Expense and contra-asset updated.
3. Adjusting Entry c: Accrued interest = $100 → Expense and liability recorded.
4. These adjustments ensure revenue and expenses are matched to the correct period (matching principle).
5. Adjusted trial balance totals must balance:
- Total Debits = $5,400 (Cash) + $200 (Supplies) + $17,000 (Equip) + $1,000 (W/D) + $4,000 (Rent) + $500 (Supplies Exp) + $1,000 (Depreciation) + $100 (Interest) = $29,200
- Total Credits = $2,000 (Accum. Depr.) + $200 (AP) + $100 (Int. Pay.) + $9,000 (Note Pay.) + $6,000 (Cap.) + $12,000 (Rev.) = $29,300

Wait — Debits ≠ Credits → There’s a mismatch.

Let’s recheck:

Debits:
- Cash: 5,400
- Supplies: 200
- Equipment: 17,000
- W/D: 1,000
- Rent Exp: 4,000
- Supplies Exp: 500
- Depreciation Exp: 1,000
- Interest Exp: 100
→ Total Debits = 5,400 + 200 + 17,000 + 1,000 + 4,000 + 500 + 1,000 + 100 = $29,200

Credits:
- Accum. Depr.: 2,000
- AP: 200
- Int. Payable: 100
- Note Payable: 9,000
- Capital: 6,000
- Service Rev: 12,000
→ Total Credits = 2,000 + 200 + 100 + 9,000 + 6,000 + 12,000 = $29,300

✘ Discrepancy of $100.

But wait — Interest Expense is $100 (debit), and Interest Payable is $100 (credit). That’s balanced.

Is there a missing entry?

Ah! No other expenses or revenues are shown.

Wait — let’s check if interest expense is properly reflected.

Yes, it is.

But total debits = $29,200, credits = $29,300 → off by $100.

But looking back — Josie Smith, W/D is $1,000 — that's withdrawals, which is a contra-equity account, so it’s debit.

But capital is $6,000 — not increased.

So the adjusted trial balance has not included the net income effect on capital yet.

That’s normal — the worksheet stops here. The capital account remains at beginning balance until closing entries are made.

But trial balance must balance.

So either:
- The service revenue is $12,000, but maybe there’s another revenue?
- Or the interest expense is not yet posted?

Wait — in the adjusted trial balance, interest expense is $100 (Dr.), and interest payable is $100 (Cr.) — that’s fine.

But total debits = $29,200
Total credits = $29,300

Difference: $100

Wait — let's add again:

Debits:
- Cash: 5,400
- Supplies: 200
- Equipment: 17,000
- W/D: 1,000
- Rent Exp: 4,000
- Supplies Exp: 500
- Depreciation Exp: 1,000
- Interest Exp: 100
→ Sum = 5,400+200=5,600; +17,000=22,600; +1,000=23,600; +4,000=27,600; +500=28,100; +1,000=29,100; +100 = $29,200

Credits:
- Accum. Depr.: 2,000
- AP: 200
- Int. Payable: 100
- Note Payable: 9,000
- Capital: 6,000
- Service Rev: 12,000
→ 2,000+200=2,200; +100=2,300; +9,000=11,300; +6,000=17,300; +12,000 = $29,300

Still off by $100.

But interest expense is $100 — and interest payable is $100 — both appear.

Wait — perhaps there is a missing credit?

No — all accounts seem accounted for.

Wait — is the capital account supposed to be $6,000? Yes, because net income hasn't been closed.

But the adjusted trial balance should still balance.

Unless there’s a typo.

Alternatively — could interest expense be $100, but interest payable is $100, and both are correct?

Yes.

But why the imbalance?

Ah! Look at Supplies:
- Trial balance: $700
- Adjustment: Credit $500 → $200
- So supplies decreased by $500

And supplies expense increased by $500 → correct.

Now — depreciation: $1,000 added to accumulated depreciation → correct.

Interest: $100 accrued → correct.

But the adjusted trial balance doesn't include any new income.

But total debits are $29,200, credits $29,300 → difference of $100.

Wait — unless interest expense is not in the adjusted trial balance?

But it is — under "Interest expense", Dr. $100.

And "Interest payable" Cr. $100.

So both are present.

But no other account seems missing.

Wait — is service revenue $12,000? Yes.

But total credits = 2,000 (Accum. Depr.) + 200 (AP) + 100 (Int. Pay.) + 9,000 (Note Pay.) + 6,000 (Cap.) + 12,000 (Rev.) = 29,300

Total debits = 5,400 + 200 + 17,000 + 1,000 + 4,000 + 500 + 1,000 + 100 = 29,200

So off by $100.

But this suggests a data error in the image.

Alternatively — maybe interest expense is not in the debit column?

But it is.

Wait — look at the adjustments column:

- Interest expense has no adjustment listed — but in the adjusted trial balance, it's $100.

But in the adjustments column, c. 100 is under Interest payable (Cr.)

So the adjustment is:
- Debit Interest Expense $100
- Credit Interest Payable $100

But in the adjustments column, only Cr. 100 is shown under Interest Payable — the debit side is blank.

Ah! That’s the issue.

In the adjustments column, for Interest Expense, there should be a Dr. 100, but it's missing.

Similarly, for Interest Payable, Cr. 100 is shown.

So the adjustment entry is incomplete in the table.

Therefore, the adjusted trial balance is correct, but the adjustments column is missing the debit side.

✔ So the solution is:

> The adjusting entry for interest is missing its debit in the adjustments column.

You need to add:
- Dr. Interest Expense $100 in the Adjustments column (under Interest Expense row)

Then:
- Total Debits = 29,200 + 100 = 29,300
- Total Credits = 29,300 → now balanced

---

✔ Final Correction

To fix the worksheet:

Add to Adjustments Column:
- Under Interest Expense: Dr. 100
- Under Interest Payable: Cr. 100 (already there)

Now the adjustments column is complete, and the adjusted trial balance will balance.

---

✔ Conclusion

Problem: The worksheet is almost complete, but the adjusting entry for interest is missing the debit side in the adjustments column.

Solution: Add Dr. $100 to Interest Expense in the Adjustments column.

After correction:
- Adjusted Trial Balance totals: $29,300 (both sides)
- All accounts properly adjusted
- Net Income = $6,400
- Closing entries needed later

---

Let me know if you'd like the full journal entries or financial statements prepared from this data.