• June 1: Owner contributed $50,000 in cash to the business.

• June 1: Owner purchased a company vehicle in the amount of $15,000.
• June 3: Owner took out a small business loan in the amount of $25,000.
• June 5: Owner paid rent for June, and prepaid office rent for a 6-month period to cover July through December at $1,195 per month.
• June 5: Owner paid business license fees in the amount of $250 to the county.
• June 5: Owner ordered office supplies, on account, in the amount of $750.00.
• June 6: Owner performed service for client on account in the amount of $1,000.
• June 9: Owner provided service for client in the amount of $1,500. Customer paid $750 at time of service. Client will be billed for the balance due.
• June 10: Owner paid $250 in advertising costs to the local paper.
• June 15: Owner recorded wages due to the part-time employee in the amount of $325. This will be paid on June 20.
• June 15: Owner prepaid business insurance to cover July through December at the rate of $125 per month.
• June 20: Owner paid wages due to part-time employee from period ending June 15.
• June 21: Owner paid for plumbing repairs in the office in the amount of $210.
• June 22: Owner withdrew $1,000 cash for personal use.
• June 23: Customer paid balance due from June 6 service in the amount of $1,000.
• June 25: Owner provided service to client in the amount of $800. Client paid at time of service.
• June 28: Owner paid balance due for office supplies purchase on June 5.
• June 29: Owner performed service for client on account in the amount of $2,225.00.
• June 30: Owner received telephone bill for month of June in the amount of $155 and recorded the expense. This bill will not be paid until July.
• June 30: Last day of pay period; owner owes part-time worker $325 for the June 16 through June 30 pay period. This will be paid on July 5.
• June 30: Record depreciation on vehicle at $250.
make me a unadjusted trial balance

1 answer

To create an unadjusted trial balance, we first need to analyze the transactions and determine the balances in various accounts based on the entries made. Here’s a summary of the key accounts involved:

Account Categories:

  1. Assets:

    • Cash
    • Accounts Receivable
    • Office Supplies
    • Prepaid Rent
    • Prepaid Insurance
    • Vehicle (Equipment)
    • Office Repairs (if considered an expense rather than an asset)
  2. Liabilities:

    • Accounts Payable
    • Loan Payable
    • Wages Payable
  3. Equity:

    • Owner's Capital
    • Owner's Withdrawals
  4. Revenue:

    • Service Revenue
  5. Expenses:

    • Rent Expense
    • Advertising Expense
    • Wages Expense
    • Depreciation Expense
    • Telephone Expense
    • Office Repairs Expense

Transactions and Balances:

  1. Cash:

    • Contributions: +$50,000 (initial contribution)
    • Loan Received: +$25,000
    • Rent Paid: –$7,170 (rent for June and prepaid for 6 months, $1,195*6)
    • Advertising Paid: –$250
    • Wages Paid: –$325
    • Withdrawal: –$1,000
    • Payment for Supplies: –$750
    • Customer Payments: +$1,750 ($750 + $1,000)
    • Service Revenue received: +$800
    • Vehicle Purchase: –$15,000
    • Plumbing Repairs: –$210

    Ending Cash Balance = $50,000 + $25,000 - $7,170 - $250 - $325 - $1,000 - $750 + $1,750 + $800 - $15,000 - $210 = $53,795

  2. Accounts Receivable:

    • For services performed: $1,000 (June 6) + $750 (June 9) + $2,225 (June 29) = $4,975
    • Customer paid $1,000 for the June 6 services: –$1,000

    Ending Accounts Receivable = $4,975 - $1,000 = $3,975

  3. Prepaid Rent:

    • Total rent for 6 months: $1,195 * 6 = $7,170 (asset)
  4. Office Supplies:

    • Purchased on account: $750
    • Paid off on June 28: (not included in the supplies balance)

    Total Office Supplies = $750

  5. Vehicle (Equipment):

    • Vehicle Purchase: $15,000
    • Less: Depreciation: –$250

    Ending Vehicle Balance = $15,000 - $250 = $14,750

  6. Wages Payable:

    • Wages due on June 15: $325
    • Wages for June 30: $325

    Total Wages Payable = $325 + $325 = $650

  7. Loan Payable:

    • Small business loan: $25,000
  8. Owner's Capital:

    • Initial Capital Contribution: $50,000.
  9. Owner's Withdrawals:

    • Withdrawals for personal use: $1,000.
  10. Service Revenue:

  • Total Revenue = $1,000 (June 6) + $1,500 (June 9) + $800 (June 25) + $2,225 (June 29) = $5,525
  1. Expenses:
  • Rent Expense: $1,195 (for June)
  • Advertising Expense: $250
  • Wages Expense: $325 (June 15 wages paid)
  • Telephone Expense: $155
  • Depreciation Expense: $250
  • Office Repair Expense: $210

Unadjusted Trial Balance:

Now that we have the balances, we can set up the unadjusted trial balance:

| Account | Debit | Credit | |----------------------------------------------|-------------|-------------| | Cash | $53,795 | | | Accounts Receivable | $3,975 | | | Office Supplies | $750 | | | Prepaid Rent | $7,170 | | | Prepaid Insurance | $750 | | | Vehicle (Equipment) | $14,750 | | | Total Assets | $88,365 | | | | | | | Accounts Payable | | $750 | | Wages Payable | $650 | | | Loan Payable | | $25,000 | | Owner's Capital | | $50,000 | | Owner's Withdrawals | $1,000 | | | Service Revenue | | $5,525 | | Rent Expense | $1,195 | | | Advertising Expense | $250 | | | Wages Expense | $325 | | | Telephone Expense | $155 | | | Office Repair Expense | $210 | | | Depreciation Expense | $250 | | | Total Liabilities and Equity | $88,365 | |

Summary:

  1. The total debits and total credits should equal for the trial balance to be correct.
  2. In this case, both totals are equal at $88,365.

This unadjusted trial balance provides a snapshot of the company's financial position at the end of June before any adjustments are made for accrued and deferred items.