Post the general journal entries to the general ledger in the Excel spreadsheet.

It is time for the staff accountants to begin preparing daily accounting transactions. In preparation for the upcoming audit, the accountants must ensure that these transactions are correct and are free from any misstatement. Because this is a new subsidiary of the company, there are no beginning balances.

As a staff accountant, your job is to do the following:

  • Prepare the 10 transactions below by posting to the general journal. You should use an Excel spreadsheet to accomplish this task.
  • Post the general journal entries to the general ledger in the Excel spreadsheet.
  • Prepare a trial balance from the ending balances on the ledger. You should also use an Excel file for the trial balance.

Transactions

  1. Invested $50,000 in the business
  2. Paid $100 for phone service
  3. Purchased $35,000 equipment on credit
  4. Paid $3,000 for 3 months rent
  5. Paid $5,500 for 6 months of insurance
  6. Paid $1,000 for advertising on credit (Note: This is an expense to the company)
  7. Customer purchased $2,000 on account
  8. Customer in #7 paid $1,000 on account
  9. Paid for #6 advertising
  10. Sold to customer and received $5,000 cash
find the cost of your paper
Order now to get your homework done

Clarify the role of each legally mandated attendee on the Individualized Education Program team

This discussion assesses your ability to clarify the role of each legally mandated attendee on the Individualized Education Program team. This assessment also supports your achievement of Course Learning Outcome….

Describe the performance of “Salt Peanuts” provided in your Module 3 Playlist

n 100 words or more, describe the performance of “Salt Peanuts” provided in your Module 3 Playlist. Being a live performance, there are certain characteristics that we don’t have in….

Analyze the fixed and variable costs of a firm, how those costs have changed over time, and how those changes have impacted the firm’s overall health and sustainability

The purpose of this milestone is for students to explore the various costs their firm faces and to describe their firm’s market. Using the concepts and tools developed in Modules….