It is time for the staff accountants to begin preparing daily accounting transactions. In preparation of 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

Click here for the General Journal Ledger template.

please create the excel spreadsheet and please include an outline

thank you nice tip will be included

Looking for a solution written from scratch with No plagiarism and No AI?

WHY CHOOSE US?

We deliver quality original papers

Our experts write quality original papers using academic databases.We dont use AI in our work. We refund your money if AI is detected  

Free revisions

We offer our clients multiple free revisions just to ensure you get what you want.

Discounted prices

All our prices are discounted which makes it affordable to you. Use code FIRST15 to get your discount

100% originality

We deliver papers that are written from scratch to deliver 100% originality. Our papers are free from plagiarism and NO similarity.We have ZERO TOLERANCE TO USE OF AI

On-time delivery

We will deliver your paper on time even on short notice or  short deadline, overnight essay or even an urgent essay