QuickHelper

(10)

$20/per page/

About QuickHelper

Levels Tought:
Elementary,High School,College,University,PHD

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 357 Weeks Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Accounting Posted 19 Sep 2017 My Price 11.00

Invested $50,000 in the business

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

Answers

QuickHelper
(10)
Status NEW Posted 19 Sep 2017 04:09 AM My Price 11.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)