Question

Please complete in Excelb. Post the entries to T-Accounts. i. Use a new TAB in EXCEL to create the T-Accounts. (Hint: the CASH will have the most posThe trial balance of DeCore Design Service as of January 1, 2020 had the following normal balances: $ 12,000 2,500 350 1,200

Adjustments: 16. Prepaid insurance used during the year was $100 “per month”. 17. Unearned services earned during the year $1

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Journal Entries

Particulars Dr. Amt Cr. Amt.
Cash A/c                                                                Dr. 5000
                 To Common stock A/c 5000
Salary Payable A/c                                        Dr. 500
                 To cash A/c 500
Supplies A/c                                                 Dr. 600
                 To cash A/c 600
Cash A/c                                                                Dr. 600
                  To Unearned Revenue A/c 600
Account Payable A/c                       Dr. 2100
                 To cash A/c 2100
Prepaid insurance A/c                       Dr. 600
                 To cash A/c 600
Cash A/c                                                                Dr. 2800
                 To Design revenueA/c 2800
Rent Expense A/c                                          Dr. 2000
                 To cash A/c 2000
Accounts Receivable A/c                             Dr. 6500
                 To Design revenueA/c 6500
Truck A/c                                                           Dr. 30000
                 To cash A/c 6000
                To Notes Payable 24000
Cash A/c                                                                Dr. 1500
                 To Accounts Receivable A/c 1500
Fuel Expense A/c                                   Dr. 400
                 To Accounts payable A/c 400
Cash A/c                                                                Dr. 3000
                 To Design revenueA/c 3000
Salary Expense A/c                                           Dr. 700
                 To cash A/c 700
Dividend A/c                                                        Dr. 200
                 To cash A/c 200
Cash
Opening bal. 12000 Salary Payable 500
Common stock 5000 Supplies 600
Accounts Receivable 1500 Unearned Revenue   600
Design revenue 2800 Prepaid Insurance 600
Design revenue 3000 Rent Expense 2000
Accounts Payable 2100
Truck 6000
Dividend 200
Salary 700
Closing Balance 11000
24300 24300
Account receivable
Opening bal. 2500 Cash 1500
Design revenue 6500 Closing Bal. 7500
9000 9000
Supplies
Opening bal. 350 Supplies Exp 450
Cash 600 Closing Bal. 500
950 950
Prepaid Insurance
Opening bal. 1200 Insurance Expense 1200
cash 600 Closing Bal. 600
1800 1800
Account Payable
Cash 2100 Opening bal. 2100
Closing Bal. Nil
2100 2100
Salary Payable
Cash 500 Opening bal. 500
Closing Bal. 300 Salary Expense 300
800 800
Interest Payable
Closing Bal. 1440 Interest Expense 1440
1440 1440
Unearned Revenue
Profit & Loss 1000 Opening bal. 1000
Closing Bal. 600 Cash 600
1600 1600
Design Revenue
Profit & Loss 12300 Cash 2800
Cash 3000
Account receivable 6500
12300 12300
Common stock
Closing Bal. 15000 Opening 10000
Cash 5000
15000 15000
Truck
Notes Payable 24000 Depreciation 3000
Cash 6000 Closing Bal. 27000
30000 30000
Notes payable
Closing Bal. 24000 Truck 24000
24000 24000
Fuel Expense
Accounts payable 400 Profit & Loss 400
400 400
Depreciation Expense
Truck 3000 Profit & Loss 3000
3000 3000
Dividend
Cash 200 Profit & Loss 200
200 200
Insurance Expense
Prepaid Insurance 1200 Profit & Loss 1200
1200 1200
Salary Expense
Cash 700
salary Payable 300 Profit & Loss 1000
300 1000
Rent Expense
Cash 2000 Profit & Loss 2000
2000 2000
Supplies Expense
Know the answer?
Add Answer to:
Please complete in Excel b. Post the entries to T-Accounts. i. Use a new TAB in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Post the transactions to the T-accounts. Use the transaction dates as posting references. Use a "Bal"...

    Post the transactions to the T-accounts. Use the transaction dates as posting references. Use a "Bal" posting reference to show the ending balance of each account. For any accounts with a zero balance, select the "Bal" posting reference and enter a "0" on the normal side of the account. Review the journal entries you prepared above Cash Accounts Payable Service Revenue Salaries Payable Accounts Receivable Unearned Revenue Salaries Expense Office Supplies Common Stock Depreciation Expense Truck Prepaid Insurance Retained Earnings...

  • Post the transactions to the​ T-accounts. Use the transaction dates as posting references. Use a​ "Bal."...

    Post the transactions to the​ T-accounts. Use the transaction dates as posting references. Use a​ "Bal." posting reference to show the ending balance of each account. For any accounts with a zero​ balance, select the​ "Bal." posting reference and enter a​ "0" on the normal side of the account. I need help posting the transactions to t accounts Read the requirements. Accounts Payable Cash Service Revenue Salaries Payable Accounts Receivable Unearned Revenue Salaries Expense Dec. Mass Delivery Service began operations...

  • Part (B) Accounting Cycle Comprehensive Problem [75 marks in total] Best solutions, Inc. completed the following...

    Part (B) Accounting Cycle Comprehensive Problem [75 marks in total] Best solutions, Inc. completed the following transactions during January 2019: a. Shareholders invested in the business $60,000 cash and a delivery truck valued at $72,000 in exchange for common stock. b. Purchased supplies for $3000 cash. c. Paid $5,500 for a one-year insurance policy, effective January1. d. Performed delivery services for a customer and received $4,000 cash. e. Completed a large delivery job for a customer on account for $15,000....

  • i need help with 3-7 please. thanks! The requirements for this problem: 1. Record cach transaction...

    i need help with 3-7 please. thanks! The requirements for this problem: 1. Record cach transaction as a journal entry. 2. Post the transactions to T-accounts using the following chart of accounts. Cash Accounts Receivable Office Supplies Prepaid Insurance Truck Accumulated Deprec.- Truck Accounts Payable Salaries Payable Unearned Revenue Taylor, Capital Taylor, Withdrawals Income Summary Service Revenue Salaries Expense Rent Expense Deprec. Expense- Truck Insurance Expense Fuel Expense Off, Supplies Expense Advertising Expense 3. Prepare an unadjusted trial balance as...

  • This is an assignment that I am having a lot of trouble on. Comprehensive Problem Taylors...

    This is an assignment that I am having a lot of trouble on. Comprehensive Problem Taylors Delivery Service had the following transactions during December 2019: Dec 1 Taylors Delivery Service began operations by receiving $15,000 cash and with a fair value of $30,000 from the owner, Rue Taylor. The business ga Taylors capital in exchange for this contribution. Dec 1 Paid $2,000 cash for a 6-month insurance policy. The policy will begin on December 1. Dec 7 Paid Office Rent...

  • can you please mark the explanations while answering this practice problem? 1. 2. 3. etc Magness Delivery Service has completed closing entries and the accounting cycle for 2016. The busine...

    can you please mark the explanations while answering this practice problem? 1. 2. 3. etc Magness Delivery Service has completed closing entries and the accounting cycle for 2016. The business is now ready to record January 2017 transactions. Collected $1,000 cash from customer on account. 5 Purchased office supplies on account, $600. 12 Performed delivery services for a customer and received $2,000 cash. 15 Paid employee salary including the amount owed on December 31, $2,500. 18 Performed delivery services on...

  • (1) Prepare journal entr the chart of acco pare journal entries to record the October 2019...

    (1) Prepare journal entr the chart of acco pare journal entries to record the October 2019 transactions listed on the following page hart of accounts for the appropriate account titles to use). Prepare a sepa ach transaction and leave a space after each entry! Check fiqure: Total debits - account titles to use). Prepare a separate journal entry for check figure: Total debits = $112,705. OPTIONAL: Post the journal entries to the T-accounts and calculate the account balances. unadjusted trial...

  • Set up T-accounts for the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation-Equipment,...

    Set up T-accounts for the following accounts: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation-Equipment, Accounts Payable, Salaries and Wages Payable, Common Stock, Retained Earnings, Service Revenue, Supplies Expense, Gasoline, Expense, Depreciation Expense, Insurance Expense, and Salaries & Wages Expense Speedy Cleaning Service began its operations on December 1, 2019. The following transactions took place during its first month of operations. The company uses the calendar year as its reporting period. During December, the company completed the following transactions....

  • Record the following journal entries and post to the T-accounts for ABC Company for the month...

    Record the following journal entries and post to the T-accounts for ABC Company for the month of January: 1. On 1/1, Common stock was issued for $50,000. 2. On 1/3, ABC signed a 6% (.5% per month) note at State Bank for $75,000. 3. On 1/4, ABC purchased computer equipment for $81,500. 4. On 1/6, ABC purchased office supplies on account for $2,850. 5. On 1/7, ABC purchased prepaid insurance for $4,800 and paid rent of $1,800. 6. On 1/10,...

  • complete this six-step excel workbook 125% ... View Zoom Add Category T Text Insert Table Chart...

    complete this six-step excel workbook 125% ... View Zoom Add Category T Text Insert Table Chart Shape Media Comment Collaborate + Sheet1 Step 1: Journalize business transactions: Account Debit Credit Debit Credit 1. Investors contribute $20,000 in exchange for common stock 2. Company purchases equipment in the amount of $5,000 Step 2: Prepare Trial Balance Account Cash Supplies Prepaid Insurance Buildings Equipment Accounts Payable Unearned Revenue Mortgage Payable Common Stock Service Revenue Wage expense Advertising expense 3. Company purchases building...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT