Journal entries to general ledger in the excel spreadsheet

Assignment Help Finance Basics

Reference no: EM13820997

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

Invested $50,000 in the business
Paid $100 for phone service
Purchased $35,000 equipment on credit
Paid $3,000 for 3 months rent
Paid $5,500 for 6 months of insurance
Paid $1,000 for advertising on credit (Note: This is an expense to the company)
Customer purchased $2,000 on account
Customer in #7 paid $1,000 on account
Paid for #6 advertising
Sold to customer and received $5,000 cash

Reference no: EM13820997

Questions Cloud

Case study ping sweeps and port scans : Case Study Ping Sweeps and Port Scans

Identify at least four factors : Identify at least four factors that are related to the high divorce rate in the United States. Why has the divorce rate increased over the course of the last century?

Examine the historical evolution of the panopticon : Examine the historical evolution of the Panopticon all-seeing prison style developed by Jeremy Bentham and the impact of this style on modern system architecture and the use of closed-circuit television CCTV cameras.

Describe the labeling theory of deviance : Describe the labeling theory of deviance. What basic insight about deviance is offered by this approach? How does labeling figure into the difference between primary deviance and secondary deviance? What is the importance of stigma in labeling analys..

Journal entries to general ledger in the excel spreadsheet : 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 endin..

Did this series of question correctly organize each organism : Did this series of questions correctly organize each organism? Why or why not? What additional questions would you ask to further categorize the items within the kingdoms (Hint: think about other organisms in the kingdom and what makes them differe..

The brain and behavior essay : The Brain and Behavior Essay

Describe gerhard lenski''s model of sociocultural evolution : Describe Gerhard Lenski's model of sociocultural evolution, summarizing several key traits of 3. each stage. What major technological revolutions have reshaped human societies in the past?

Summarize freud''s theory of human personality : Summarize Freud's theory of human personality, Piaget's approach to human development, and Mead's view of the development of the self. What do all the theories have in common? What are the main differences among them?

User Account

All Pages