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

Ambitude Company worksheet for April 30, Year 1, detailing financial data including cash, accounts receivable, expenses, revenue, and net income.

Ambitude Company worksheet for the month ended April 30, Year 1, showing adjusted trial balance, income statement, and balance sheet columns with account titles and amounts.

Ambitude Company worksheet for the month ended April 30, Year 1, showing adjusted trial balance, income statement, and balance sheet columns with account titles and amounts.

JPG 1280×720 57.6 KB Free · Personal Use
Quality Assured by Worksheets Library Team
Reviewed for educational accuracy and age-appropriateness
ID: #459477
Show Answer Key & Explanations Step-by-step solution for: How to Complete the Worksheet with Accounting Principles
The worksheet shows the Balance Sheet columns are empty. I need to fill in the Balance Sheet Debit and Credit columns based on the Adjusted Trial Balance amounts.

Let me identify which accounts go to the Balance Sheet:

Balance Sheet Debit (Assets + Drawings):
- Cash: 11,500
- Accounts Receivable: 8,260
- Prepaid Rent: 2,700
- Equipment: 24,010
- Owner's Drawings: 3,500

Balance Sheet Credit (Liabilities + Capital + Accumulated Depreciation):
- Accumulated Depreciation—Equipment: 4,638
- Notes Payable: 7,620
- Accounts Payable: 5,580
- Owner's Capital: 27,930
- Interest Payable: 63

Now let me also add Net Income to the Balance Sheet Credit column (since it increases owner's equity).

Net Income = 16,000 - 11,861 = 4,139

Balance Sheet Totals:

Debits:
- Cash: 11,500
- Accounts Receivable: 8,260
- Prepaid Rent: 2,700
- Equipment: 24,010
- Owner's Drawings: 3,500
Total Dr = 11,500 + 8,260 + 2,700 + 24,010 + 3,500 = 49,970

Credits:
- Accumulated Depreciation—Equipment: 4,638
- Notes Payable: 7,620
- Accounts Payable: 5,580
- Owner's Capital: 27,930
- Interest Payable: 63
- Net Income: 4,139
Total Cr = 4,638 + 7,620 + 5,580 + 27,930 + 63 + 4,139 = 49,970

Let me verify:
Dr: 11,500 + 8,260 = 19,760; + 2,700 = 22,460; + 24,010 = 46,470; + 3,500 = 49,970 ✓

Cr: 4,638 + 7,620 = 12,258; + 5,580 = 17,838; + 27,930 = 45,768; + 63 = 45,831; + 4,139 = 49,970 ✓

Both sides balance at 49,970.

Final Answer:
Balance Sheet Dr. Total: 49,970
Balance Sheet Cr. Total: 49,970

Individual Balance Sheet entries:
Dr: Cash 11,500; Accounts Receivable 8,260; Prepaid Rent 2,700; Equipment 24,010; Owner's Drawings 3,500
Cr: Accumulated Depreciation—Equipment 4,638; Notes Payable 7,620; Accounts Payable 5,580; Owner's Capital 27,930; Interest Payable 63; Net Income 4,139

Parent Tip: Review the logic above to help your child master the concept of accounting worksheet template.
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 template)

Free Accounting Templates in Excel | Smartsheet
Free Accounting Templates in Excel | Smartsheet
Digital Accounting Worksheet - printable spreadsheet - printable accounting worksheet - trial balance - keeping track of budget
Free Accounting Templates in Excel - download for your business
Blank 10 Column Accounting Worksheet | Excel spreadsheets ...
Free Excel Bookkeeping Templates
Sample 10 Column Worksheet Form for Accounting | Exercises ...
What is a 10-column worksheet in accounting?◅Cl...
Free Income-Expense Statement Template Template for Excel ...
Balance Sheet Template | Free Download | FreshBooks