Free. Exclusive. Just for you.
Four unique services that make learning easier, faster, and smarter - only on our website.

Bob's Donut Shoppe, Inc. Accounting Worksheet for January 2020

Accounting worksheet for Bob's Donut Shoppe, Inc. for the month ending 31st January 2020, showing unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet columns with financial data.

Accounting worksheet for Bob's Donut Shoppe, Inc. for the month ending 31st January 2020, showing unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet columns with financial data.

PNG 2150×1084 562.6 KB Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #373890
Show Answer Key & Explanations Step-by-step solution for: Fundamentals of Accounting - Learn About Accounting Process and ...
To solve this problem, we need to complete the accounting worksheet by filling in the missing numbers for the Income Statement and Balance Sheet columns. The goal is to make sure the totals at the bottom balance out correctly.

Here is the step-by-step logic:

Step 1: Separate Accounts into Income Statement or Balance Sheet


First, we look at each account name to decide where it belongs:
* Income Statement: Revenues and Expenses (things that calculate profit or loss).
* Balance Sheet: Assets, Liabilities, and Equity (things the company owns or owes, plus owner's money). *Note: Dividends are also on the Balance Sheet because they reduce equity.*

Let's sort the rows based on the "Adjusted Trial Balance" numbers provided in the image:

Income Statement Items:
* Revenues: $3,600 (Credit)
* Cost of goods sold: $1,200 (Debit)
* Depreciation expense: $500 (Debit)
* Office rent expense: $750 (Debit)
* Supplies expense: $3,000 (Debit)
* Utilities expense: $700 (Debit)
* Wages expense: $3,000 (Debit)
* Interest expense: $500 (Debit)

Balance Sheet Items:
* Cash: $49,600 (Debit)
* Accounts Receivable: $3,000 (Debit)
* Prepaid Rent: $750 (Debit)
* Inventory: $18,800 (Debit)
* Renovation and improvements: $25,000 (Debit)
* Accumulated depreciation: $500 (Credit)
* Accounts payable: $19,000 (Credit)
* Accrued expenses: $700 (Credit)
* Unearned income: $9,000 (Credit)
* Long-term liabilities: $24,500 (Credit)
* Common stock: $50,000 (Credit)
* Dividends: $500 (Debit)

Step 2: Calculate Totals for the Income Statement


Now we sum up the Debits and Credits for the Income Statement items listed above.

Total Debits (Expenses):
$$1,200 + 500 + 750 + 3,000 + 700 + 3,000 + 500 = \mathbf{9,650}$$

Total Credits (Revenues):
$$\mathbf{3,600}$$

*(Check: The image already shows these totals at the bottom: 9,650 Dr and 3,600 Cr. This matches our calculation.)*

Step 3: Calculate Net Loss


Since the Expenses ($9,650) are higher than the Revenues ($3,600), the business has a Net Loss.

$$\text{Net Loss} = \text{Total Expenses} - \text{Total Revenues}$$
$$\text{Net Loss} = 9,650 - 3,600 = \mathbf{6,050}$$

In accounting worksheets, a Net Loss is recorded as a Credit in the Income Statement column (to balance it) and a Debit in the Balance Sheet column (because it reduces the owner's equity).

Step 4: Fill in the Balance Sheet Columns


We list the Balance Sheet items and add the Net Loss we just calculated.

Balance Sheet Debits (Assets + Dividends + Net Loss):
* Cash: $49,600
* Accounts Receivable: $3,000
* Prepaid Rent: $750
* Inventory: $18,800
* Renovation...: $25,000
* Dividends: $500
* Net Loss: $6,050

$$\text{Total Debits} = 49,600 + 3,000 + 750 + 18,800 + 25,000 + 500 + 6,050 = \mathbf{103,700}$$

Balance Sheet Credits (Liabilities + Equity):
* Accumulated depreciation: $500
* Accounts payable: $19,000
* Accrued expenses: $700
* Unearned income: $9,000
* Long-term liabilities: $24,500
* Common stock: $50,000

$$\text{Total Credits} = 500 + 19,000 + 700 + 9,000 + 24,500 + 50,000 = \mathbf{103,700}$$

Conclusion


The totals match!
* Income Statement Totals: $9,650 (Dr) and $9,650 (Cr, including the balancing Net Loss).
* Balance Sheet Totals: $103,700 (Dr) and $103,700 (Cr).

The specific value requested implicitly by the structure of such problems is usually the final balanced totals or the Net Loss figure. Based on the visible "Totals" row at the very bottom right, the final balanced amount for the Balance Sheet columns is 103,700.

Final Answer:
The completed worksheet results in a Net Loss of $6,050. The final balanced totals for the Balance Sheet columns are $103,700 for both Debits and Credits.
Parent Tip: Review the logic above to help your child master the concept of accounting worksheet.
Print Download

How to use

Click Print to open a print-ready version directly in your browser, or use Download to save the file to your device. The ⭐ Answer button generates an AI answer key instantly - useful for teachers who need a quick reference. Need a different version? Our AI Worksheet Generator lets you create a custom worksheet on any topic in seconds.

(view all accounting worksheet)

Free Accounting Templates in Excel | Smartsheet
How to Complete the Worksheet with Accounting Principles
Solved Assignment: 1) complete the accountants worksheet | Chegg.com
accounting worksheet format – Professional Articles on Business ...
Accounting Worksheet 1 | Teaching Resources
Accounting Worksheet (Definition) | Example of Accounting Spreadsheet
Accounting Worksheet Template in Excel, Google Sheets - Download ...
Preparation of Worksheet | Service Rendering or Trading
Accounting Worksheet | Accounting, Learn accounting, Worksheets
Digital Accounting Worksheet Printable Spreadsheet Printable ...