On April 1, Jose Garcia created a new travel agency, Garcia Travel. The following transactions occurred during the company’s first month.   April 2 Garcia invested $38,000 cash and computer equipment worth $11,400 in the company in exchange for its common stock. April 3 The company rented furnished office space by paying $2,600 cash for the first month’s (April) rent. April 4 The company purchased $1,200 of office supplies for cash. April 10 The company paid $1,800 cash for a 12-month insurance policy. Coverage begins on April 11. April 14 The company paid $1,540 cash for two weeks’ salaries earned by employees. April 24 The company collected $24,000 cash for commissions revenue. April 28 The company paid $1,540 cash for two weeks’ salaries earned by employees. April 29 The company paid $650 cash for minor repairs to computer equipment. April 30 The company paid $400 cash for this month’s telephone bill. April 30 The company paid $1,700 cash in dividends.   Information for month-end adjustments follows: Prepaid insurance of $100 expired this month. At the end of the month, $600 of office supplies are still available. This month’s depreciation on computer equipment is $190. Employees earned $616 of unpaid and unrecorded salaries as of month-end. The company earned $1,830 of commissions revenue that is not yet General Journal tab - Prepare journal entries for Garcia Travel's first month of operations.  Prepare any necessary adjusting and closing entries for the current month. General Ledger tab - Each journal entry is posted automatically to the general ledger. Use the drop-down button to view the unadjusted, adjusted, or post-closing balances. Trial Balance tab - You may view the unadjusted, adjusted, or post-closing trial balances by choosing from the dropdown box below.  Your choice will determine the reported values on the financial statement tabs.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter1: Business Transactions (ptrans)
Section: Chapter Questions
Problem 3R: On June 1 of the current year, Wilson Wood opened Woodys Web Services. This sole proprietorship had...
icon
Related questions
icon
Concept explainers
Question

On April 1, Jose Garcia created a new travel agency, Garcia Travel. The following transactions occurred during the company’s first month.

 

April 2 Garcia invested $38,000 cash and computer equipment worth $11,400 in the company in exchange for its common stock.
April 3 The company rented furnished office space by paying $2,600 cash for the first month’s (April) rent.
April 4 The company purchased $1,200 of office supplies for cash.
April 10 The company paid $1,800 cash for a 12-month insurance policy. Coverage begins on April 11.
April 14 The company paid $1,540 cash for two weeks’ salaries earned by employees.
April 24 The company collected $24,000 cash for commissions revenue.
April 28 The company paid $1,540 cash for two weeks’ salaries earned by employees.
April 29 The company paid $650 cash for minor repairs to computer equipment.
April 30 The company paid $400 cash for this month’s telephone bill.
April 30 The company paid $1,700 cash in dividends.

 

Information for month-end adjustments follows:

  1. Prepaid insurance of $100 expired this month.
  2. At the end of the month, $600 of office supplies are still available.
  3. This month’s depreciation on computer equipment is $190.
  4. Employees earned $616 of unpaid and unrecorded salaries as of month-end.
  5. The company earned $1,830 of commissions revenue that is not yet

General Journal tab - Prepare journal entries for Garcia Travel's first month of operations.  Prepare any necessary adjusting and closing entries for the current month.

General Ledger tab - Each journal entry is posted automatically to the general ledger. Use the drop-down button to view the unadjusted, adjusted, or post-closing balances.

Trial Balance tab - You may view the unadjusted, adjusted, or post-closing trial balances by choosing from the dropdown box below.  Your choice will determine the reported values on the financial statement tabs.

Income Statement tab - Use the drop-downs to select the accounts properly included on the income statement.  The unadjusted, adjusted or post-closing balances will appear for each account, based on your selection.

Statement of Retained Earnings tab - The unadjusted, adjusted or post-closing balances will appear for each account, based on your selection.

Balance Sheet tab - Use the drop-downs to select the accounts properly included on the balance sheet.  The unadjusted, adjusted or post-closing balances will appear for each account, based on your selection.

Post-Closing tab - Use the drop-downs to indicate whether each account is included on the post-closing trial balance.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
College Accounting (Book Only): A Career Approach
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning